Thanks for your response! 

The sales summary is not quite what I'm looking for. 

For accounting purposes, I need basically a balancing of the checkbook type deal. Like in QuickBooks or previously Payal, I'd need each transaction that occurs to be listed in one place.  

So line items would be individual to each and every transaction that occurs (i.e. payment, refund, fee reversal from square, deduction from my account to cover refund, etc). 

Here are the example I'm looking for. I'm not sure they exist yet in Square. 

Ah, I see. I'm sorry I missed that earlier! While we don't have a running balance (like in your screenshot), we do sync up with Quickbooks. So, if you still have Quickbooks it may be worth investigating. 

Is there a way to sync square with Quickbooks DESKTOP?

You can import the Square Sales data into Quickbooks Desktop but it’s a manual process. Not an option to have it automatically sync

https://quickbooks.intuit.com/learn-support/en-us/import-or-export-data-files/import-square-transact...

That sounds very promising! Thank you! 

Just to confirm, is this the app add-on you're referencing?

https://squareup.com/us/en/app-marketplace/app/commerce-sync

Yep that’s the one. Been using it for a couple of years now and it works great. It only syncs once a day but it makes tax time a breeze since it creates the sub accounts in QuickBooks for all the different things it needs to report and makes all the entry’s. 

Thanks for stepping in to share your tips, @homeprogreen! We appreciate you! 🙏

You’re welcome 

Probably be a lot more accurate if you looked at the daily report and entered the Square Fees as a debit to the Square Account that you have setup. As an example let’s use your figure of 450 dollars. So the daily report says you took 450 in card swipes so you credit the account the 450 like you do now. Then you look at the fees line on the daily report that you got your sales total from and you see that Square kept $11.43 in swipe fees so you enter the 11.43 as a debit to your expense line account “ Square Fees” or Bank Fees.   That’s going to leave you a balance in your “ Square account “ of 438.57 which should match what square actually deposited in your bank account overnight. So then you just debit or transfer that amount out of your square account into your regular bank account. If you offer discounts then you would also need a line item expense “ discounts “ that you would also need to debit from the square account. That amount is also available on your daily sales report. Much cleaner way of tracking it and I am sure that your accountant will appreciate the fact that all the amounts are accurate and easily matched up 

I am good with everything you said.  And am doing as you directed.  What I need for the auditors is a report from Square that I can say "what was the balance Square owes us as of February 28, 2023.  The only way I can get that report is to open the Balance screen on February 28th after all our transactions for that date are complete and take a screen shot.  Square has all the data necessary to create a dated balance report.  Toast does it.  Stripe does it.  Easy peasy.

@Taglotn ;

You can go to your Square Dashboard > Transactions - then select the date or date range.

The on the Right side of the Screen it has a Export button so you can Export your Transactions for that Date or Date Range.

So if you would Choose a Date Range of Feb 1st, 2023 till Feb 28th, 2023. You would have a report in a CSV file that will show you everything your Accountant would need.  

Here is a sample of 2 sales from 2-25-2023 I just opened 6-6-2023.  You will have to sum up the Net Total column to see what was Deposited to your account or what is owed to your account for the date range you entered.  I removed some identifying IDs in the sample below.

Another way is to go to your Dashboard > Balance -- Click on your Location - View ALL Transfers  Then enter the Date or date range and then Export.  Shows the Deposit Date and the Date the Sale was made plus the Gross (Collected) Square Fees (Fees) and how much for the Transaction was deposited (Deposited).  Now again you would have to sum up these columns to get a total for your date or date range.