MCKI Blog · Square + QuickBooks

Why Your Square Deposits Don't Match QuickBooks

If you take payments through Square, you've probably noticed it: the amount that lands in your bank account never quite matches what you sold that day. It's tempting to assume the books will sort it out on their own. They won't. That mismatch is built into how Square works — and if your bookkeeping doesn't account for it, the gap quietly grows until the numbers you file taxes on are wrong.

The short version

  • Square pools your sales, subtracts its fees, and pays you in batches a day or two later — so the deposit is almost never the same as the sale.
  • If your books record only the bank deposit, you understate revenue, miss the fees you could deduct, and lose track of refunds and gift cards.
  • The fix is a Square clearing account that traces every dollar from sale to deposit and reconciles to about zero every month.

Square doesn't pay you the way you sold

When a customer taps a card, Square doesn't send that exact amount to your bank. It holds the money in your Square balance, takes its processing fee — roughly 2.6%–2.9% plus a few cents per transaction — and then pays out the rest in a batch, usually the next business day and never over a weekend. So a Saturday and Sunday of sales might land as a single Monday deposit, minus fees, minus any refunds. The deposit is real. It just doesn't look anything like your sales total.

Why the deposit never matches the sale

Several things happen between the sale and the deposit, and every one of them moves the number:

  • Fees come out first. Square skims its processing fee before it ever pays you, so the deposit is already smaller than the sale.
  • Refunds and chargebacks are netted out. Money returned to a customer is quietly subtracted from a later payout.
  • Several days get batched into one deposit. A weekend or a holiday can land as a single lump that covers multiple days of sales.
  • Tips and other types are handled separately. They don't always flow the way your sales receipts suggest.
  • Month-end sales are still "in transit." The last day or two of the month is often money you've earned but haven't been paid yet when the books close.

What the mismatch quietly hides

On its own, a deposit that's "a little off" sounds harmless. The problem is what builds up behind it:

  • Understated revenue. If you book the deposit as your sales, your income is short by every fee and every in-transit dollar.
  • Missed deductions. Square's fees are a legitimate business expense — but buried inside a net deposit, they never get recorded, so you pay tax on money you never actually kept.
  • Lost refunds. Money returned to customers that never shows up in the books.
  • Gift cards counted too early. A sold gift card is a liability until it's used, not revenue on day one.
  • Tax returns filed on numbers that were never right — the most expensive version of the problem, because fixing it means amending.

How to reconcile Square in QuickBooks properly

The reliable method is a Square clearing account — a holding account in QuickBooks that mirrors your Square balance, so every dollar is traced from the sale to the deposit:

  • Record each day's sales at the gross amount, by payment type — the day they happen, not the day the money lands.
  • Run every sale through the clearing account, then record Square's fees as an expense as they're taken out.
  • Match each bank payout against the clearing account, so the deposit clears the exact sales it paid for.
  • At month-end, the clearing account should reconcile to about zero. Anything left is money in transit or an error to chase down.

This is the work most bookkeepers skip — they record revenue whenever the deposit lands and let the difference roll forward for years. It's also exactly how I handle Square reconciliation for every Square client, alongside the QuickBooks cleanup that usually comes with it.

How to tell if yours is off

You don't need to audit your whole system to know. Open your QuickBooks Square clearing account and look at the balance. If it's near zero and matches what's actually sitting in Square, you're in good shape. If it's a large number that's been climbing for months — or you don't have a clearing account at all — the gap has been building, and the longer it runs, the more it costs to untangle. The good news: catching it early turns a years-long mess into a one-time cleanup.

FAQ

Why don't my Square deposits match my bank?

Because Square takes its fees and batches several days of sales into one payout, usually a day or two later. The deposit is the net of everything that happened — fees, refunds, timing — not a single sale.

Where do Square fees go in QuickBooks?

They should be recorded as a processing-fee expense as they're deducted, not left netted inside the deposit. Booked properly, those fees are a deduction that lowers your taxable income.

Doesn't the Square–QuickBooks integration handle this automatically?

The sync apps import transactions, which helps — but they rarely reconcile the clearing account or confirm that each payout actually cleared. The books can look connected and still be wrong. Someone has to check that every account ties out to zero.

My Square books are already a mess — can it be fixed?

Almost always. A one-time cleanup rebuilds the clearing accounts and brings the balances current, with a fixed quote first. From there, monthly reconciliation keeps it right.

The next step

Want your Square books to actually match?

See exactly how I trace every Square dollar from sale to deposit — or book a free 15-minute Square check and I'll tell you what I'd expect to find in your clearing accounts.

See How I Fix Square Books Book a Free 15-Min Square Check