A multi-location food service business came to me with clean-looking books — and Square clearing accounts that had never once been reconciled. The balances had simply rolled forward, year after year, quietly absorbing fees, refunds, and deposits that never quite matched. In one month, every account reconciled to zero. Here's what happened, anonymized to protect the client.
Client identity withheld for privacy; figures below are illustrative. The situation, the work, and the outcome are real.
The business
A busy restaurant running multiple locations, all on Square. Cards all day, cash at the counter, gift cards over the holidays. On the surface the books looked fine — every month closed, every report ran. The owner had no reason to think anything was wrong.
What we found: recorded, but never reconciled
The Square sales were being recorded — but the Square accounts had never been properly reconciled. Those are two different jobs, and the gap between them is exactly where the trouble hides.
Recording puts the activity in the books. Reconciling is the step that ties what Square processed to what actually reached the bank — through the clearing accounts where Square holds your money between the sale and the deposit. That second step had simply never happened. So the balances rolled forward for years, never tied out, never questioned. This is the mechanism behind why Square deposits never match QuickBooks — and why it quietly compounds.
Why "balanced" wasn't "correct"
- Square pools sales, takes its fees, and pays out in batches — so the deposit never matches the day's sales.
- Recording the activity isn't the same as reconciling it. Without the second step, errors hide in the clearing accounts and grow.
- Left unreconciled for years, the gap can reach tens of thousands — with tax returns already filed on the wrong numbers.
What we did
We rebuilt how Square flowed into QuickBooks, and put the daily work on a reliable system so it stays right going forward:
- Recorded each day's sales by payment type, on the day they happened — not whenever the bank deposit cleared.
- Traced every deposit — card, cash, gift card — from sale to clearing account to bank.
- Reconciled all four clearing accounts to zero variance, every month.
- Modeled cash over/short against the actual drawer, so a counting slip shows up the day it happens.
- Tracked gift card liability correctly — money taken but not yet earned is a liability, not income.
- Followed in-transit deposits into the next month until they actually landed.
- Delivered a one-page monthly Scorecard in plain English.
The result, in one month
Every dollar accounted for. Gift card liability tracked separately, so deferred revenue stopped masquerading as income. Anomalies surfaced in the report instead of being discovered at tax time. The owner went from hoping the books were right to knowing it — and now reads a single page each month instead of guessing.
Why this matters for any Square business
If your books are on Square and no one can tell you the current balance of your clearing accounts — and what it should be, you have the same risk this business did. "Balanced" and "correct" are not the same thing. The fix isn't another app. It's recording sales the right way, reconciling the clearing accounts every month, and keeping the daily work from falling behind. It's exactly the work I do for every Square client.
FAQ
Is this a real client?
Yes. The story and the work are real; the client is anonymized and the figures are illustrative to protect their privacy.
How long does fixing Square clearing accounts take?
For this business, all four reconciled to zero within the first month. It varies with volume, number of locations, and how far the accounts have drifted — that's what a free Square Health Check sizes up.
Do you only work with restaurants?
No. This happened to be food service, but the same Square-to-QuickBooks reconciliation applies to retail, salons, and any business on Square — and the work is fully remote.