POS Reconciliation: Getting Toast and Square Daily Sales to Match QuickBooks

POS Reconciliation: Getting Toast and Square Daily Sales to Match QuickBooks

Here is the moment every restaurant owner hits within the first month of opening. The Toast or Square dashboard says you sold $6,710 yesterday. The deposit that lands in QuickBooks Online two days later is $5,645. The numbers never match. Not once. And if your bookkeeper records deposits straight from the bank feed as "Sales," your books are understating revenue, missing your sales tax liability, and hiding processing costs inside a number that looks like income.

This is not a bug in Toast, Square, or QuickBooks. The bank deposit is never supposed to equal the POS sales report, because at least six things happen to your money between a guest tapping a card and cash hitting your account. Put a daily sales journal entry and a POS clearing account in place, and reconciliation drops from a monthly nightmare to a 15 minute weekly routine. This guide walks through the whole system, with a worked journal entry that balances to the penny.

Why the Deposit Never Equals the Sales Report

Six mechanics sit between gross sales and the bank deposit. Every reconciliation gap you will ever chase traces back to one of them.

1. Processing fees are netted out of the deposit. Toast and Square deduct their card processing fees before the money reaches your bank. If you rang $5,810 in card sales, the deposit arrives at $5,810 minus roughly 2.5 to 3.5 percent. Those fees are a real operating expense, and if you only book the net deposit, they vanish from your P&L and your revenue is understated by the same amount.

2. Tips are collected by you but owed to staff. Credit card tips flow through the processor into your deposit, but they are not your revenue. They are a liability until you pay them out through payroll or cash tip-outs. A $620 tip day inflates the deposit without touching sales.

3. Batch settlement lag. Sales you ring today settle as a batch and typically hit the bank in 1 to 2 business days on standard Square and Toast funding. Friday through Sunday sales often land as a Monday or Tuesday pile-up, and a month-end cutoff always leaves 1 to 3 days of sales that belong to this month but deposit in the next.

4. Refunds and chargebacks. A refund processed today gets netted against today's batch, even if the original sale was last week. Chargebacks are worse: the processor claws the money back weeks later, sometimes with a dispute fee attached, and the deduction shows up in a deposit that otherwise has nothing to do with the original transaction.

5. Gift card loads versus redemptions. When a guest buys a $150 gift card, money comes in but you have not earned anything yet. That is a liability. When they redeem it next month, you earn revenue but no money moves. If you book gift card sales as revenue on the load date, you recognize income twice or never, depending on how the redemption gets recorded.

6. Cash sales never touch the processor. Cash rung through the POS shows up in the sales report but never appears in a Toast or Square deposit. It sits in the drawer, then the safe, then a bank run. If your only source of truth is the bank feed, cash sales disappear until someone deposits them, and short drawers go unnoticed for weeks.

So the daily gap between the POS report and the bank is not an error. It is the sum of fees, tips, tax, gift card movement, cash, and timing. The fix is to record what actually happened each day, not what the bank happened to receive.

The Daily Sales Summary Journal Entry, Done Right

The core discipline is one journal entry per location per day, built from the POS end-of-day report. Debits equal credits, every category lands in its own account, and nothing waits for the bank. Here is a worked example for a single location on a single day.

The end-of-day report shows: food sales $4,200, beverage sales $1,300, sales tax collected $440, credit card tips $620, and one $150 gift card sold. Guests paid $900 in cash and $5,810 on cards. The processor's fee on the card batch works out to $165, so the eventual deposit will be $5,645.

Look at what this one entry accomplishes. Revenue is recorded at gross, split by category, on the day it was earned. Sales tax sits in a payable so filing is a report, not an archaeology project. Tips sit in a liability you can tie to payroll. The gift card load sits in a liability that gets relieved when someone redeems it. Processing fees show up as the expense they are. And the amount the bank should receive, $5,645, sits in the clearing account waiting for the deposit.

A few practical notes. If a gift card was redeemed that day, add a debit line to Gift Card Liability for the redemption amount. If there were comps or discounts, either net them into the sales lines or carry a separate contra-revenue debit so you can track discounting. A refund reduces the sales credit and the clearing debit by the same amount, so the entry still balances. Some operators post this as a zero-total sales receipt instead of a journal entry; the mechanics are identical.

The POS Clearing Account Method

The clearing account is what makes the whole system self-checking. Set it up as a bank-type or other-current-asset account in QuickBooks Online called something like "Toast Clearing" or "Square Clearing." Every daily entry debits it for the net card amount you expect to receive. Every real deposit in the bank feed gets matched against it, crediting it back down.

When the system is working, the clearing balance is never zero and never large. It should hover right around 1 to 2 days of net card sales, which is exactly the settlement lag. If your average net card day is $5,000, a clearing balance floating between $5,000 and $10,000 is healthy. That is money in flight, sales you have earned that the processor has not paid out yet.

The diagnostic power comes from watching that balance drift. A steadily growing balance means daily entries are being posted but deposits are being coded somewhere else, often straight to a revenue account by an eager bank feed rule. A shrinking or negative balance means deposits are being matched but daily sales entries are being missed, so you are banking money you never recorded earning. Either direction, the clearing account turns a silent error into a visible number within days instead of at year-end.

If this pattern sounds familiar, it should. It is the same discipline behind QuickBooks' own Undeposited Funds workflow, where receipts wait in a holding account until the physical deposit clears them out. We cover the accounting logic and US GAAP treatment of that pattern in our guide to undeposited funds accounting. A POS clearing account is that same idea, purpose-built for card settlement lag.

One rule makes or breaks it: never let a bank feed rule auto-categorize processor deposits as income. Every Toast or Square deposit must match against the clearing account. The moment a deposit bypasses clearing and posts as sales, you have double-counted revenue and broken the self-check.

What the Toast and Square QuickBooks Integrations Do Well, and Where They Fall Short

Both Toast and Square offer QuickBooks Online integrations, and both are worth using. They are also both worth double-checking.

What they do well. Square's official QBO sync and Toast's accounting integration (built on xtraCHEF and partner connectors) push a daily summary into QuickBooks automatically, which kills the most common failure mode: nobody posting the entry at all. They handle the fee split, so gross sales, fees, and net deposit land in separate accounts. And the same mapping runs every day without a human remembering to do it.

Where they fall short. Three gaps show up in practice. First, category mapping is only as good as its setup, and it drifts. Add a new menu group in Toast or a new item category in Square and it often lands in a default or unmapped account until someone notices, which means your food versus beverage split quietly degrades. Second, multi-location handling is weak. If your locations live in one QBO file, you need every synced entry tagged with the right class or location, and the integrations are inconsistent about it. If each location is its own QBO company, the integration connects one to one and gives you no combined view at all. Third, journal granularity varies. Some configurations post one lumped entry that buries tips or nets fees in ways that do not match how you want your P&L structured, and tax lines can map to the wrong liability account if you have more than one jurisdiction.

The right posture: let the integration do the daily posting, but audit the mapping monthly and reconcile weekly. Automation without reconciliation just produces wrong numbers faster.

The 15 Minute Weekly Reconciliation Routine

With daily entries flowing and a clearing account in place, weekly reconciliation is short. Here is the routine.

Minutes 1 to 5: match batches to deposits. Open the clearing account register and the bank feed side by side. Each processor deposit should match one daily batch (or a merged weekend batch on Monday or Tuesday). Match them off. Most weeks, everything pairs cleanly.

Minutes 5 to 10: check the residual. The clearing balance after matching should equal the net card sales from the last 1 to 2 unsettled days. Compute that from the most recent end-of-day reports. If it matches, you are reconciled, and you are done early.

Minutes 10 to 15: investigate anything left. A residual that does not tie to settlement lag is one of a short list of suspects: a chargeback or dispute fee netted from a deposit, a refund that hit a different day's batch, an instant-transfer fee, a missed daily entry, or a deposit that a bank rule hijacked into the wrong account. Looking at one week of activity, the culprit usually surfaces in minutes. Wait until month-end and the same hunt takes hours.

While you are in there, spot-check cash. Drawer cash recorded in the daily entries should tie to what got deposited or is sitting in the safe. A persistent small shortage is a controls conversation, and you can only have it if the books show what the drawer should have held.

The Multi-Location Angle: Clearing Accounts Per Location, One Consolidated View

Everything above gets multiplied the day you open location two. The non-negotiable rule is one clearing account per location per processor. A single shared clearing account across locations turns your best diagnostic into mush: the balance still moves, but you can no longer tell which store missed an entry or which deposit went astray. With per-location clearing accounts, the store with the drifting balance identifies itself.

Per-location daily entries also unlock the reporting that actually runs a restaurant group. Food sales, beverage sales, and comps by location feed straight into prime cost by location, the number that tells you whether the new store is a keeper. If your locations share one QBO file, that means disciplined class tracking on every entry. If each location is its own QBO company, which is standard once locations are separate legal entities, QuickBooks gives you no combined view at all. We walk through that structural choice and the prime cost math in our guide to multi-location restaurant P&L in QuickBooks Online.

This is where FinBoard.ai fits. FinBoard connects to every one of your QuickBooks Online files, maps each location's accounts to one shared chart, and produces a consolidated P&L with per-location columns automatically. Clearing accounts, sales categories, tips payable, and gift card liabilities from every location roll up into one view, and every consolidated number supports drill-down to the underlying transactions in the source file. When the group P&L shows a merchant fee spike or a growing clearing balance at one store, you click through to the entries behind it instead of opening five browser tabs. The daily sales discipline in this guide is exactly the always-reconciled foundation that makes a 5 day multi-entity month-end close realistic.

Frequently Asked Questions

Why don't my Toast or Square deposits match my QuickBooks sales?

Because the deposit is net of everything the processor handles: card fees are deducted before payout, credit card tips ride along inside the deposit, refunds and chargebacks are netted against the batch, and batches settle 1 to 2 business days after the sales date. Cash sales and gift card movements never appear in the deposit at all. Record the whole day with a daily sales journal entry and let deposits clear against a POS clearing account.

What is a POS clearing account and how do I set one up?

A POS clearing account is a holding account in QuickBooks Online (bank type or other current asset) that stands in for money the processor owes you. Your daily sales entry debits it for net card sales; each Toast or Square deposit is matched against it. Set one up per location per processor, and disable any bank rules that code processor deposits as income. A healthy clearing balance hovers around 1 to 2 days of net card sales; a growing balance means missed matching or misrouted deposits, and a negative balance means missed daily sales entries.

Should I record daily sales as journal entries or let the integration sync them?

Use the integration if it is set up correctly, because consistency beats manual effort. Square's QBO sync and Toast's accounting integrations post a daily summary automatically. But verify the output against the structure in this guide: gross sales by category, fees as an expense, tips and gift cards as liabilities, sales tax to a payable, and net card sales to a clearing account. Audit the category mapping monthly, especially after menu changes, and reconcile weekly regardless of how the entries get posted.

How do I reconcile POS sales across multiple restaurant locations?

Keep one clearing account and one daily entry per location, tagged by class or location if you share a QBO file. If each location is a separate QuickBooks company, QuickBooks cannot combine them, so use a consolidation layer like FinBoard.ai to map all locations to one chart of accounts and produce a consolidated P&L with per-location detail and drill-down. Then run the same weekly routine per location: match batches to deposits, verify each clearing residual equals that location's settlement lag, and investigate anything left over.

Stop Chasing Deposits, Start Reading Numbers You Trust

Take it with you: the free POS Daily Sales Reconciliation Tracker gives you the daily entry sheet, deposit matching and the running clearing balance from this article, prefilled with a sample week.

The system in this guide is small: one journal entry per location per day, one clearing account per location, and 15 minutes a week of matching. In exchange you get gross revenue by category, a sales tax balance you can file from, tips and gift cards tracked as the liabilities they are, and a control that flags missed entries within days. If you run more than one location, FinBoard.ai turns those clean per-location books into one consolidated view with drill-down to every underlying transaction, so the group P&L, prime cost by location, and the reconciliation trail live in one place. See it with your own QuickBooks files at finboard.ai.