Reconcile Square Payouts to Your Bank Statement

TL;DR A Square deposit on your bank statement is a net transfer, not a day's sales. It bundles card payments (including tips and sales tax), minus processing fees, refunds, disputes and anything else Square withholds, such as loan repayments. To reconcile, first match each Square transfer to a bank deposit by amount and date, then break each transfer into its parts using Square's transfer or sales reports, and record gross sales, fees, refunds and other deductions separately in your books. Cash and other non-card payments recorded in Square never appear in a Square transfer, so reconcile them on their own. When every deposit is matched and every transfer's parts add up to its net amount, your sales and fees are complete.

Square is everywhere in small, in-person businesses: coffee shops, salons, market stalls, food trucks, repair shops, studios. It's simple to start taking card payments, and money lands in your bank automatically. The trouble shows up at bookkeeping time. Your bank statement has a deposit from Square most business days, and none of them match the sales report for that day.

That mismatch is normal. Card payments are batched, fees are taken out first, refunds come out of later transfers, tips are mixed in, and weekends shift timing. If you record each deposit as "sales", your revenue is understated, card fees disappear from your expenses, and sales tax figures won't line up. This guide shows a reliable way to reconcile Square transfers to your bank statement: how transfers work in general terms, what you need, a step-by-step method, a worked example, and the awkward cases. Square's dashboard and reports change over time and vary by country, so we describe them generally rather than as exact click-paths.

How Square transfers work

When a customer pays by card through Square, the money goes into your Square balance first. Square then sends that balance, after deductions, to your linked bank account as a transfer. In general:

• Card payments are batched. One transfer usually covers a period of card sales, commonly a business day, depending on your settings and the transfer schedule.
• Processing fees are usually deducted before the transfer. The deposit you see is net of fees.
• Refunds reduce a later transfer. A refund issued today is typically taken out of the next transfer, not the one that contained the original sale.
• Disputes and chargebacks can result in funds being held or deducted.
• Optional faster transfers may be available for a fee. If you use them, you'll see more, smaller deposits and an extra fee for each one.
• Other Square products can also draw on your balance. For example, if you take a loan or financing through Square, repayments may be withheld from your card sales before transfer. Payroll and other services may be debited separately.

There's one more wrinkle. If your Square balance is set to stay in a Square account rather than transfer to an outside bank, there won't be a deposit on your external bank statement at all. In that case, reconcile the Square account's own statement in the same way you'd reconcile any bank account.

What you need

• Bank statements for the period, converted to a spreadsheet. SheetStatement converts PDF statements to Excel or CSV and checks the opening and closing balances, so you know the deposit list is complete. The free plan covers 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans handle more.
• Square's transfer report for the same period, showing each transfer's date and net amount.
• The details behind each transfer: the payments, refunds, fees and adjustments included. Square generally lets you view and export these from the dashboard.
• Square's sales summary for the period, which shows gross sales, tips, discounts, sales tax, and how customers paid (card, cash, other).
• Your books, in accounting software or a spreadsheet ledger.

Before you start, make sure your bank statements themselves reconcile: opening balance plus all transactions equals closing balance. If a page is missing, you'll spend hours hunting for a "missing" Square deposit that's actually missing from your spreadsheet. Our guide to reconciling a bank statement in Excel explains the check.

Step 1: list Square deposits from the bank statement

Filter the bank data to deposits from Square. Descriptions usually contain "Square" or a variation of the company name, but the exact text depends on your bank. Put them on their own sheet:

If you have more than one Square location or business linked to different accounts, add a column for which account the deposit landed in.

Step 2: list Square transfers from Square's report

From Square's transfer report, list:

Keep the report's own identifiers. You'll need them to drill into the details for any transfer that doesn't match.

Step 3: match by amount and date

Deposits usually arrive on the transfer date or within a few business days. A simple formula on the bank sheet finds the matching transfer:

=XLOOKUP(1, (Transfers[Net amount]=C2) * (ABS(Transfers[Transfer date]-A2)<=4), Transfers[Transfer ID], "No match")

This looks for a transfer with exactly the same amount within four days of the bank date. Adjust the window for your bank. Our guide to matching bank transactions with XLOOKUP explains the pattern and how to deal with two transfers of the same amount close together.

After matching, three lists matter:

• Matched pairs: done for now.
• Bank deposits with no transfer: possibly a transfer from another period, a deposit from something else that happens to mention Square, or a transfer to the wrong account.
• Transfers with no deposit: often in transit at the end of the period. Check the first days of the next statement.

Step 4: break each transfer into its parts

Matching deposits proves the cash arrived. Bookkeeping needs more: what that cash was made of. For each transfer, Square's details show the components. Summarise them like this:

Then check the arithmetic for each row:

=ROUND(Card sales + Tips + Sales tax - Refunds - Fees - Loan repayment + Other - Net, 2)

How you split sales, tax and tips depends on how Square's report presents them; the point is that the parts must add back to the net amount that hit your bank. If they don't, a component is missing from your summary.

Step 5: record it in your books

The cleanest approach is a clearing account, sometimes called "Square clearing" or "Undeposited Square funds":

1. Record gross sales (and sales tax collected, and tips if you pass them to staff) into the clearing account from your sales summary.
2. Record fees, refunds and other deductions out of the clearing account.
3. Record the bank deposit as a transfer from the clearing account to your bank.

If everything is right, the clearing account returns to zero, apart from transfers that are in transit at period end. A clearing account that drifts away from zero is a sign something has been missed.

Many accounting packages have Square integrations that do some of this automatically. They're useful, but still check that the clearing balance makes sense and that bank feed deposits aren't also being recorded as income, which would double-count sales. Our QuickBooks duplicate transactions guide covers that clean-up.

A worked example

A small café uses Square and an outside business checking account. Here's one week, with invented figures.

Bank statement deposits from Square:

Square transfers: five transfers with the same net amounts, dated Mon 2 to Fri 6. The Monday 9 deposit covers the Friday transfer, which included Friday's card sales plus weekend card sales batched together.

All five match. Now look inside the Monday 9 deposit, the largest:

Check: 2,698.00 + 214.00 − 38.50 − 79.40 − 50.00 = 2,744.10. It adds up.

How it's recorded:

• Sales (net of tax) and sales tax payable from the sales summary, into Square clearing.
• Tips into clearing and then to a tips payable or payroll account, depending on how tips are paid out.
• Refunds of $38.50 out of clearing, against sales.
• Fees of $79.40 out of clearing, to a card processing fees expense.
• Loan repayment of $50.00 out of clearing, against the loan liability (the split between principal and any fee or interest depends on the loan terms).
• The $2,744.10 deposit from clearing into the bank account.

Cash sales. That week the café also recorded $612 of cash sales in Square. None of that is in any transfer. The cash was banked separately as a $600 deposit, with $12 kept in the till float. That's a separate reconciliation: Square's cash sales total versus cash deposits plus the change in cash on hand.

If the café had simply recorded the five bank deposits as "sales", it would have booked $7,205.00 of sales for the week and no fees at all. The true picture includes higher gross sales, card fees as an expense, refunds, tips owed to staff, a loan repayment, and cash sales that never touched Square's transfers.

Awkward cases

A deposit you can't match. Check whether two transfers were combined (for example after a bank holiday), whether the amount includes a faster-transfer fee, or whether it's from a different linked business or location.

A transfer with no deposit. If it's near period end, it's probably in transit. If it's mid-month, check whether the transfer went to a different bank account, for example after you changed linked accounts.

Negative or zero transfers. If refunds or disputes exceed card sales, a transfer can be tiny, zero, or Square may debit your bank. A debit from Square on your bank statement should be matched the same way, as a negative amount.

Disputes and holds. A disputed payment may be withheld or deducted, then later returned if the dispute is resolved in your favour. Record the deduction and the return as separate movements in the clearing account.

Faster transfers. Each one carries its own fee and creates an extra, smaller deposit. Match them individually.

Fees charged outside transfers. Subscriptions for some Square software or hardware purchases may be charged to a card or debited separately rather than withheld. Find them on your bank or card statement and record them as their own expenses.

Multiple locations. If each location deposits to a different account, reconcile each one separately. If they all deposit to one account, add a Location column so you can tell transfers apart.

Monthly routine

1. Convert and reconcile the month's bank statement.
2. Export the Square transfer report and transfer details for the month, plus a few days either side.
3. Match deposits to transfers; list exceptions.
4. Summarise each transfer's components and check they add up to the net amount.
5. Post gross sales, tax, tips, refunds, fees and other deductions via a clearing account.
6. Reconcile cash sales separately against cash deposits.
7. Confirm the clearing account balance equals transfers in transit.

The same pattern works for other processors. If you also sell online, see our guides to reconciling Stripe payouts and reconciling Shopify payouts. For the month as a whole, our month-end close checklist puts this step in context.

Building a reusable reconciliation workbook

If you reconcile Square every month, set up one workbook and reuse it. Four sheets are enough:

• Bank: the converted bank statement rows for the month, filtered to Square deposits and debits, with a Match column holding the transfer ID found by the XLOOKUP formula.
• Transfers: Square's transfer report, pasted in as it comes, with a Matched column that looks back at the Bank sheet:

=IF(COUNTIF(Bank[Match], A2) > 0, "Matched", "Open")

• Components: one row per transfer with the gross sales, tips, tax, refunds, fees, loan repayments and other deductions, plus the check column that must be zero.
• Summary: month totals for each component, which become the figures you post to your books, and a reconciliation of the clearing account: opening balance, plus gross amounts, minus deductions, minus deposits, equals closing balance (transfers in transit).

Keep the previous month's workbook. Transfers in transit at the end of one month should be the first deposits matched in the next, and having last month's open list beside you makes that a two-minute job.

A couple of habits save trouble later. Always export Square's reports with a few days either side of the month, because the matching window crosses month boundaries. And never overwrite a pasted report with edits; if something needs correcting, add an Adjustment row with a note, so you can always trace your figures back to what Square and the bank actually reported.

Sales tax and income tax

Square's sales reports usually separate sales tax collected from sales. Your bank deposits don't. That's another reason not to book deposits as sales: the deposits include tax you owe to the tax authority, minus fees that relate to the whole payment.

For income tax, card processor reports such as payment card information returns may show gross amounts rather than what you received. Our guide to reconciling 1099-K forms with bank deposits covers that in the US context. This is general information, not tax advice; rules depend on where you operate, so check with an accountant.

Convert your bank statements first

Reconciling Square starts with a complete list of deposits. Upload your bank statement PDFs to SheetStatement, confirm each statement's opening and closing balances, and export the transactions to Excel or CSV. The free plan includes 3 pages a month to try it.

FAQ

Why don't my Square deposits match my daily sales?

Deposits are net transfers. They exclude processing fees and refunds, may include tips and sales tax, may combine several days of card sales, and never include cash sales.

Should I record Square deposits as income?

Not directly. Record gross sales, sales tax, tips, refunds and fees from Square's reports, usually through a clearing account, and treat the deposit as a transfer into your bank.

How do I find which sales are in a Square transfer?

Square generally lets you view the details behind each transfer, including payments, refunds and fees. Use that detail to split the transfer into its parts.

Why is there a Square deposit missing from my bank statement?

It may be in transit at period end, combined with another transfer, sent to a different linked account, or held because of a dispute. Check the next statement and Square's transfer status.

How do I handle Square loan repayments?

If repayments are withheld from card sales before transfer, record them out of the clearing account against the loan, not as a reduction of sales.

Do cash sales show up in Square transfers?

No. Cash and other non-card payments recorded in Square aren't part of transfers. Reconcile them against your cash deposits separately.

Can I do this reconciliation in Excel?

Yes. Convert your bank statements to rows, export Square's transfer report, and match them with XLOOKUP, then summarise each transfer's components.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.