I'm looking to create a report that will show Category and items sales that will match up my balance transfer amount. When I get a deposit, it could include sales from admission, concession, pumpkin sales, etc that I want/need to breakdown and assign in Quickbooks. I do not download every transactions into Quickbooks as it would make the file too large.
How does everyone else handle this breakdown? We use this for management review and decisions.
Also note, not every transaction of our business is run through Square.
I have downloaded the Item csv and Transactions csv reports. If the Item csv had a column for the Deposit ID that would be a tremendous help as I could then manipulate in excel to get my data totals.
Any suggestions would be appreciate.
Patty in VA
