I do deposit invoices with balances paid later.
The banking reports never add up to the amount banked. You have to deduct the deposit amount (net of credit card fees).
It's way too unwieldy.
reporting is completely broken now. not is it unwieldy but balance reporting to excel has been disabled. i found major discrepancies in the balance reporting page and opened a support case. never heard back but now there is no excel so i can't check.
Am actively looking for an alternative.
I doubt it can be fixed as the entire data model seems convoluted and reporting so obtuse.
But for info:
I opened a case with support back on June 8th. Square never provided a case # so I don't know how to reference.
When I look at the report on the web I see this (balance blacked out):
When I export the excel I get something different (this option popped back up for me today):
The statement shows same as the excel at least:
It's impossible to figure out what the issue might be because the balance has no details on how it is calculate like such as balance = (sales - tips - fees + tax). This is an example of the issue @CVR2 is referencing. I have tried it manually and never got it to add up. I just have to trust that square is depositing the right amount. Hard to trust it though when the web report and the export of that report don't match.
@karrade7 Thank you for providing more details and screenshots above. I did notice the dates from the picture above were two different dates.
Can you send me a screenshot of the excel document from September 29th?
Square Community
Square Products