# How to Reconcile Square Deposits to Sales

- Author: PreciseBankFlow (https://precisebankflow.com)
- Published: 2026-10-17
- Category: Payment and deposit reconciliations
- Canonical: https://precisebankflow.com/blog/reconcile-square-deposits

> How to reconcile Square deposits: match daily transfers to sales reports, separate fees, refunds and instant transfer charges, and find missing days.
To reconcile Square deposits, match every Square transfer on the bank statement to the Square transfer record that produced it, then tie each transfer back to the sales it contains. The gap between gross sales and the bank credit should be fully explained by processing fees, refunds, instant transfer charges and payments that moved to another day.

## What is inside one Square deposit?

A Square deposit is a net figure. It starts with the card payments Square accepted for a period, subtracts refunds and Square's processing fees, and subtracts any charge for a faster transfer. Cash sales recorded in the Square app never pass through it, so a deposit almost never equals the sales report for that day.

Think of each bank credit from Square as the last line of a small calculation. The lines above it are the ones you need to rebuild:

- **Card payments accepted**, which make up gross card sales for the period the transfer covers.
- **Refunds** issued back to customers' cards during the same period.
- **Processing fees**, which Square keeps from each payment before paying out.
- **Transfer charges**, applied when the seller chose an instant or same-day transfer instead of the standard schedule.
- **Other deductions**, such as a disputed payment held back or a repayment taken from the balance.

Two things are left out on purpose. Cash taken through the Square point of sale is in the sales summary but goes into the till, not the transfer. Gift card sales and redemptions change what was earned and what was owed, which is a liability question rather than a deposit question. Keep both in view when you compare the sales report to the bank, because each one is a reason the totals differ that has nothing to do with Square.

## Pulling the Square transfer list and the sales summary for the same dates

The Square transfer list is the bridge between the bank and the sales report. Export the transfers that landed in the month, then the sales summary and transaction detail for the days they cover. The ranges will differ, because the first transfer of the month usually carries sales from the last day of the prior month.

Square's help page on [matching transfers to sales](https://squareup.com/help/us/en/article/3813-match-deposits-to-sales) says the transfer list sits under Banking in the Square Dashboard, and that a transfer's detail lists the individual card payments it holds. The same page notes that transaction details can only be downloaded as a CSV file from the Dashboard, not from the point of sale app. If the client only gives you screenshots from the app, ask for Dashboard access or a CSV instead.

Set the ranges this way:

1. **Transfers:** every transfer with a bank arrival date inside the statement period.
2. **Sales and transactions:** from the earliest payment in the first transfer to the latest payment in the last transfer. That usually means starting one or two days before the month and ending a day or two before it closes.
3. **Bank statement:** the full period, plus the first few days of the next statement if you have it, so late transfers can be confirmed.

Keep the files together for the month. A reviewer who opens the reconciliation should find the transfer list, the transaction CSV and the bank statement side by side, each covering a range that makes sense against the others.

## Matching each Square transfer to its bank statement line

Each Square transfer should appear once on the bank statement, for the same amount, within a business day or two of the date Square sent it. Match them one to one by amount first, then confirm the date. A transfer with no bank line, or a bank line with no transfer, is the item to chase.

Bank descriptions for Square credits are short and look alike from day to day, so the amount carries the match. Work down the transfer list in date order and tick each transfer against the bank credit of the same amount. Two transfers of identical value in one week are the only common source of confusion, and the date usually settles it.

Look for these patterns while you tick:

- **One bank credit, two transfers.** This is rare with Square, but check that the bank did not combine two credits on the same day into one line on a summary statement.
- **A transfer that arrived to a different account.** Sellers with more than one bank account linked, or more than one Square location, sometimes send a location's money elsewhere. The transfer detail shows the last digits of the receiving account.
- **A bank credit that is not a transfer.** A Square Capital loan advance or a reversal of a disputed payment can arrive as its own credit. It needs its own entry, not a sales entry.

Once every bank credit has a transfer, the bank side is done. What remains is proving that each transfer equals the sales in it less the deductions.

## Square fees, refunds and instant transfer charges in the books

Square fees, refunds and instant transfer charges are the entries that take a net deposit back to gross sales. Record sales at the gross amount Square accepted, record refunds against sales or a returns account, and record fees and transfer charges as expenses. After those entries, the amount posted to the bank equals the transfer.

The bookkeeping entry for one transfer has a single debit to the bank for the net amount and a set of lines that explain it. A clean pattern is a clearing account for Square: debit it for gross card sales, credit it for refunds, fees and transfer charges, and credit it for the transfer when it reaches the bank. When every transfer is matched, the clearing account should hold only payments accepted near month end that Square had not yet sent.

Instant and same-day transfers deserve their own line. At the time of writing, Square's [transfer FAQ](https://squareup.com/help/us/en/article/5438-transfer-faqs) lists a 1.95% fee per transfer for both, and says the instant transfer fee comes on top of standard card processing fees. A seller who uses instant transfers every day can pay more in transfer charges than they realize, because the fee never appears as a separate bank line. Booking it to its own expense account makes the cost visible to the owner.

Refunds are the other trap. A refund issued on Tuesday for a Saturday sale reduces Tuesday's transfer, not Saturday's. Match refunds to the transfer they came out of, and record them in the period they were issued.

## Why is a Square deposit missing for a business day?

A Square deposit usually goes missing because of timing, not loss. Payments taken after the daily cutoff move to the next transfer, standard transfers do not go out on Saturdays, bank holidays push transfers back a day, and a seller on manual transfers gets no deposit until someone asks for one.

Square's transfer FAQ gives the standard timing: payments taken before 5 PM Pacific usually reach the bank the next business day, later payments arrive by the second business day, and standard transfers are not sent on Saturdays. A Friday evening sale can therefore sit in Monday's or Tuesday's credit. When a day looks missing, open the following transfer and check whether its payments start earlier than expected.

Work through these causes in order:

1. **Cutoff:** the day's late payments are in the next transfer.
2. **Weekend or holiday:** two or three days arrive together in one credit.
3. **Manual transfers:** the seller holds money in the Square balance and transfers it when they choose, so deposits arrive in irregular lumps.
4. **Instant transfer earlier in the day:** the seller already moved part of the balance, so the scheduled transfer is smaller or absent.
5. **Hold or dispute:** Square held some funds, which appear later or not at all.

If none of these explains the gap, the payment may have been taken on a different Square account or location. That is a question for the owner, and it matters for controls too. The person who takes the money should not be the only one who sees where it is deposited, a point covered in [segregation of duties for cash](/blog/segregation-of-duties-for-cash).

## Worked example: one week of Square deposits tied to sales

The table below is an example week for an illustrative coffee shop. Every figure is made up. It shows the tie-out from gross card payments to each bank credit, with the cash column kept separate because cash never enters a transfer.

| Transfer covers | Gross card payments | Refunds | Processing fees | Instant transfer charge | Net transfer | Bank credit date | Cash in sales summary |
| --- | ---: | ---: | ---: | ---: | ---: | --- | ---: |
| Mon (example) | 1,820.00 | 0.00 | 52.78 | 0.00 | 1,767.22 | Tue | 310.00 |
| Tue (example) | 1,655.40 | 24.00 | 47.40 | 0.00 | 1,584.00 | Wed | 275.50 |
| Wed (example) | 1,912.15 | 0.00 | 55.45 | 36.21 | 1,820.49 | Wed, same day | 298.00 |
| Thu (example) | 1,701.60 | 0.00 | 49.35 | 0.00 | 1,652.25 | Fri | 340.25 |
| Fri late, Sat, Sun (example) | 5,240.80 | 18.50 | 151.44 | 0.00 | 5,070.86 | Mon | 1,105.00 |

Read across the Wednesday row. The owner sent an instant transfer, so the money arrived the same day and the transfer was charged an extra amount. In this example the charge is 1.95% of the amount after processing fees. Read the Friday row next. Late Friday payments missed the cutoff and joined the weekend, so one Monday credit carries three days of sales.

For the week, gross card payments are 12,329.95. Refunds of 42.50, fees of 356.42 and the one instant charge of 36.21 bring that to net transfers of 11,894.82, which is the total of the five bank credits. The cash column, 2,328.75, should then tie to the cash deposit slips for the week, a separate check.

If the example's arithmetic had left a difference, the next step would be to compare transaction counts per transfer. A single payment missing from the CSV, or counted on the wrong day, shows up as a count that disagrees with the transfer detail.

## Mistake: posting Square deposits straight to sales income

Posting each Square deposit to sales income records revenue at the net amount and hides the cost of taking cards. Sales come out understated, fees never reach the profit and loss statement, and refunds disappear into a smaller figure. The books then disagree with the Square sales report every month.

The error compounds. Once fees are buried in sales, the owner cannot see what card acceptance costs, and an accountant preparing the tax return has to rebuild gross sales from Square's reports anyway. Refunds that should reduce revenue in the month they are issued instead reduce a deposit in a different week. Cash sales, which never pass through a transfer, may be left out entirely if the bookkeeper treats the deposit as the full day's sales.

The fix is the clearing account approach above, applied from the start of the year so each month ties. The same discipline applies to other platforms that pay net. [Reconciling Shopify payouts to orders](/blog/reconcile-shopify-payouts) and [Amazon settlement reconciliation](/blog/amazon-settlement-reconciliation) follow the same pattern with their own reports.

PreciseBankFlow reads the bank statement, checks that it foots, and matches each credit to the ledger line you recorded for it, so a Square credit with no matching entry shows up as an exception. You can [request early access](/get-started) if you reconcile card deposits for clients.