Reporting - Square & Banking

[ColRay]

Will sales reporting show the CATAGORY of each sale

AND

Do Bank Transaction & or Statement also show the CATAGORYS/ITEMS pertaining to the Sale/Transaction

[lawnbrook]

@ColRay,

There are many ways you can report on your data from the square backend...

One thing to note:

Category is a concept that applies to ITEMS. As such there is no concept of a category against a SALE, as it may contain muktiple items from different categories.

You can generate category reports, or item reports for given time periods.

I checked the transaction list and it only appears to show items (not categories).

In regard to the bank transactions. Square will send one payment for a given time period and therefore this payment represents all tranactions (minus fees) since the last transfer. 

In our business I generate a report of category totals for the day (as this is the breakdown that's important to me). And create one 'sale' in my accounting package, that accounts for these, minus fees.. The difference between this, and what hits the bank account is the cash transaction total..

If you can explain what you're trying to achieve, then perhaps the community can give you a little more guidance on whether you can do it.

Regards,

Bruce

[ColRay]

Bruce, we are a social Golf Club. Essentially, we want to be able to collect 'Green Fees' from Members (Under the CATAGORY. Membership) at each game & conduct a number of Raffles (Under the CATAGORY 'Raffles' with ITEMS of '1 Number for $5', '2 Numbers' for $10, 3 Numbers for $15, 4 Numbers for $20'.)

Our Treasurer only wants to see in the 'BANK Transactions' & 'Bank Statement' the Nett individual 'Green Fees' paid (not Square reporting)   

Our Treasurer wants to see in the 'BANK Transactions' & 'Bank Statement' the Nett amount collected for ALL Raffle ITEMS (not Square reporting)

Other similar SQUARE transactions will be developed as we 'get it together'

[lawnbrook]

Hi @ColRay ,

I think you may be going about it the wrong way. You need to be looking at either square reporting, and possibly your accounting package if you're using, one to give you these breakdowns.. You bank statement is not the place to be finding this information.

Any credit card processor is the same and will send you an end of day lump sum containing all transactions for the day.

I'd ask you to consider this:

If you weren't using a payment processor, and in fact using cash, when you're treasurer went to the bank to deposit the funds, would he make multiple deposits to represent the different transaction types? I'd suggest he would just deposit the funds in a lump sum and rely on the reporting (in this case, likely stored in his head) to give him this breakdown..

Is there any specific reason the treasurer doesn't want to use the tools already available to him withing the square platform ?

Essentially, at the push of a button, Square can give you a breakdown of membership income, raffle income and square fees payed for ANY given timeframe. This should then be used to reconcile against the bank deposit..

I hope that makes sense