Why Your Square Clearing Account Never Reconciles

A Square clearing account is supposed to do one thing: empty itself out. Money lands in it when you make a sale, and it leaves when Square pays you — so at the end of the month it should sit at about zero. If yours is a big number that keeps climbing instead, something is wrong. And it's usually not the timing everyone blames. It's errors quietly stacking up, month after month, inside an account most people never think to open.

What the clearing account is actually for

When you set up Square in QuickBooks the right way, you don't book a sale straight to your bank. You book it to a holding account — a Square clearing account — and then, when Square's deposit lands, that deposit pulls the matching money back out. The account is just a temporary parking spot that lets you trace every dollar from the sale to the payout that finally covered it.

Used that way, it's the cleanest check you have. Because the account is only ever holding money on its way through, it should empty back out to roughly zero each month. When it does, you've proven that every sale you recorded was actually paid — that the books and the bank tell the same story. When it doesn't, the account is waving a flag: something went in that never came back out.

Why it never gets back to zero

If your clearing account balance keeps growing, the cause is almost always one of these — and usually several at once:

• Sales booked at net instead of gross. If you record only what hit the bank, the fees Square took out are never put into the account, so the math can't close.
• Fees never recorded as their own expense. They get buried inside the deposit, so the account is short by every fee, every month.
• Deposits matched to the wrong place. A payout coded straight to income, or to the wrong clearing account, leaves the real balance stranded. A bank deposit that lands in the wrong account fails the reconciliation on both ends.
• Refunds and chargebacks ignored. Money handed back to a customer comes out of a later payout, but if it was never recorded going out, the account never balances.
• Month-end sales never relieved. The last days of the month are money you earned but weren't paid yet. That's legitimate — but if next month's deposit isn't tied back to it, last month's "in transit" just sits there forever and the balance ratchets up.
• The sync app imports but never reconciles. The Square-to-QuickBooks connectors pull transactions in, which looks like progress. But importing isn't reconciling — nobody confirmed each payout actually cleared the sales it was supposed to. The books look connected and are still wrong.

None of these announces itself. Each one leaves a small piece of money behind, and the pieces accumulate. A year of small leftovers is a clearing account in the thousands that nobody can explain.

A balance that's a little off vs. one that's broken

Not every non-zero balance is a problem, and this is the part most people get wrong in both directions. Here's the honest line between the two.

At any given month-end, your clearing account should hold the sales Square hasn't paid out yet — the last day or two of the month, still in the pipeline. That's real money in transit, and it's supposed to be there. So the test isn't "is the balance zero." The test is: strip out what's genuinely in transit, and is the rest zero?

If the leftover after that is near nothing — and next month it's near nothing again — you're fine. But if the leftover is a real number, and it's a different real number every month, and the trend is up, that's the tell. Timing money clears itself the moment the next deposit lands. A balance that grows instead of clearing isn't waiting on a payout. It's a pile of small errors that never got chased down — and in bookkeeping, an unexplained balance that drifts month to month is exactly what a clean clearing account is built to catch.

What the growing balance is hiding

A stuck clearing account isn't just untidy. It distorts the numbers you actually make decisions and file taxes on:

• Revenue that's off in either direction. Depending on how the errors landed, your income can be overstated or understated — and you won't know which until someone untangles it.
• Fees you paid tax on. Square's processing fees are a legitimate deduction. Trapped inside a net deposit and never recorded, they quietly raise your taxable income — you pay tax on money you never kept.
• Refunds that vanished. Money returned to customers that never made it into the books, so your sales look higher than they were.
• Gift cards counted as income too early. A sold gift card is a liability until it's redeemed — booked as revenue on day one, it inflates this month and shorts a later one.
• Tax returns built on numbers that were never right. The most expensive version, because fixing it after the fact means amending.

How to get it back to zero — and keep it there

Clearing the account isn't guesswork, and it isn't a plug. You don't force the balance to zero with a fudge entry — you account for every piece until it gets there on its own:

• Record each day's sales at the gross amount, by payment type, the day they happen — into the clearing account, not the bank.
• Record Square's fees as their own expense as they come out, so the account carries the full picture.
• Match every bank payout back to the clearing account, so each deposit clears the exact sales it paid for.
• At month-end, strip out what's genuinely in transit and confirm the rest is zero. If there's a leftover, break it into its parts — a missed fee, an unrecorded refund, a miscoded deposit — and fix the cause. Never just write it off.

This is the step most bookkeeping skips: it records revenue whenever the deposit happens to land and lets the difference roll forward for years. Doing it properly is exactly how I handle Square reconciliation for every Square client — and where a clearing account is already years deep, the QuickBooks cleanup that rebuilds it is usually the first job. If you want to see what that looks like start to finish, here's a Square business whose books "balanced" for years and were wrong.

How to check yours in five minutes

You don't need to audit anything to get a read. Open your Square clearing account in QuickBooks and look at the balance over the last several months. If it hovers near zero and roughly matches what's actually sitting in your Square balance, you're in good shape. If it's a large number that's been climbing — or you don't have a clearing account at all and every Square deposit is booked straight to income — the gap has been building, and the longer it runs the more it costs to untangle. The deposit side of this same problem is worth a read too: why your Square deposits never match QuickBooks explains why the numbers drift in the first place.