Square Deposit Matcher
Square pays your card sales into your bank in batches, after taking out fees and refunds, so a deposit rarely matches a day's sales. Upload your Square Transactions CSV and see each deposit broken down into card sales, refunds and fees, with the payments in it, so you can tick it off against your bank statement line by line. Your file is read in memory and discarded. Nothing is stored unless you choose to share a copy.
Which file to upload
In your Square Dashboard, go to Payments & invoices > Transactions, choose a date range, then Export > Transactions CSV. Choose a range that starts a few days before the deposits you want to check, since a deposit can include sales from earlier days.
Not sure where to find the export? See how to find and read your Square sales reports. To see the transfers that reached your bank, see where to find your Square deposits.
Get this every night, automatically
This matches one export at a time. Connect Square and Flumen breaks down every deposit for you each night, including the chargebacks, holds and reserves, and instant deposit fees that Square reports with each deposit but an export can't show.
Free plan, no signup form. By connecting you agree to our Terms and Privacy Policy.
Frequently asked questions
Why doesn't my Square deposit match my sales?
A deposit is card sales minus Square's processing fees and any refunds paid out in the same batch, and it can cover more than one day. Cash and gift card payments never reach your bank through Square.
Which Square export do I need?
The Transactions CSV, from Payments & invoices > Transactions > Export > Transactions CSV. The Items Detail CSV has no deposit information.
Is my data stored?
Nothing is stored unless you choose to share a copy. Your file is read in memory and discarded when the results page is built, nothing from it is logged, and the bank amounts you type never leave your browser. A shared copy has customer, employee, card and bank details removed and is deleted after 90 days. How shared copies are handled.