You picked Square partly because its QuickBooks Online integration is the best in the business. It syncs your in-house card sales, Square’s fees, refunds, and deposits automatically, handles the sale-date-versus-deposit-date timing correctly, and maps categories cleanly. For dine-in and pickup, your books basically run themselves. And yet, every month, the QBO bank reconciliation still won’t close — there’s a $1,180 DoorDash deposit sitting in the bank feed that matches nothing Square synced, no invoice, no day.
One operator put it exactly: their “statements don’t match the deposits” and the numbers “did not balance to reality” no matter how many times they re-ran the reports. If you’re on Square + QuickBooks Online and you run DoorDash, Uber Eats, or Grubhub, here is the counterintuitive truth: your integration is working perfectly. It’s delivery that breaks the bank rec — and Square’s sync, no matter how good, structurally cannot fix it.
The short version: Square’s QuickBooks Online integration only reconciles money that moves through Square. DoorDash, Uber Eats, and Grubhub collect the customer’s payment themselves and deposit you directly, days later, net of a 15–30% commission — Square never sees it, so its flawless sync never records it. Reconcile the delivery payouts back to the Square orders separately, and the QBO bank reconciliation finally closes — with the recoverable overcharges surfaced in the process.
Why your QuickBooks Online bank reconciliation won’t balance — even with Square’s best-in-class sync
Square’s native QuickBooks Online integration genuinely is the strongest of any restaurant POS. That’s precisely why the remaining gap is so disorienting: everything else reconciles, so the one thing that doesn’t feels like a mystery. It isn’t. Here is the exact mechanism.
Square’s integration only sees money Square processes. When a customer taps a card in your dining room, Square processes the payment, nets its 2.6% + 10¢ fee, deposits the rest next business day, and the QBO integration records all of it correctly. When a customer orders on DoorDash, the customer pays DoorDash. Square may record the order for kitchen and reporting purposes, but no money moved through Square — so the integration has a sale with no corresponding Square deposit to reconcile against.
The platform pays net, on its own schedule. DoorDash keeps a 15–30% commission, nets out refunds and promotional costs, and deposits a weekly lump directly into your bank 3–5 days later. That bank-feed line in QBO is net of deductions Square never knew about, covering many orders across several days. Square’s integration synced the gross order; the bank received a smaller net number on a different date. Nothing matches because the two systems measured different things.
It crosses accounting periods. Orders near month-end fall into the next month’s payout. Your March reconciliation is missing money that physically arrives in April; April’s deposit contains March’s orders. Reconciling delivery by calendar month against Square’s synced sales guarantees a mismatch the integration can’t resolve.
“Just exclude the delivery deposits” isn’t reconciling. A common workaround is to categorize the DoorDash bank-feed deposits straight to an income or clearing account so the reconciliation will close. It closes, but it’s a plug: you’ve recorded that you received some money from DoorDash without ever confirming it was the right money. Commission overcharges, refund clawbacks on orders you fulfilled correctly, and missing payouts all disappear into that plug — unexamined and unrecovered.
Staring at a delivery deposit in QBO that won’t tie to anything Square synced? Run a free scan and see exactly which orders, fees, and refunds make up the gap.
Run a Free ScanThe gap isn’t in Square or QuickBooks — it’s between Square, the platforms, and your bank
This is the reframe that makes it solvable. Square’s integration is faithfully reporting everything Square knows about. QuickBooks is faithfully reporting that a deposit arrived. Neither can explain the difference, because the “why” lives entirely on the delivery platform’s side — in five places Square never sees:
- Commission drift. Your contracted rate is one number; the rate actually applied per order drifts higher with plan changes, promotional tiers, and order-type misclassification. Square has no visibility into the platform’s commission math.
- Refund clawbacks. Platforms deduct refunds for driver lateness, delivery problems, and customer fraud — issues your kitchen didn’t cause. Your Square ticket shows the order was made; the platform pulled it from your payout anyway.
- Missing orders. An order that’s in Square but never appears on any platform payout is the cleanest leak: you made the food and were never paid.
- Promotional deductions without enrollment. Marketing and promo charges sometimes hit payouts with no matching enrollment record.
- Payout timing. Not an error, but until accounted for, period-boundary orders look like missing money against Square’s synced sales.
None of those five are visible to Square’s integration, and none are reconciled by QuickBooks. They only surface when you put the Square orders and the platform payout side by side. That is the work that makes the QBO bank reconciliation close. For the platform-side mechanics in isolation, see reconciling delivery platform payouts; if you also run or are evaluating Toast, the same problem on Toast is covered in Toast + QuickBooks Online deposits not matching delivery payouts.
How to reconcile Square + delivery payouts so QuickBooks finally ties out (step by step)
You need three things for the same period: your Square sales export (to isolate delivery orders), each delivery platform’s transaction-level payout report, and your bank statement / QBO bank feed. About 30–45 minutes per platform the first time.
Step 1 — Separate delivery orders in Square
In the Square Dashboard, run the sales report for the period and filter by source or fulfillment type. Pull DoorDash, Uber Eats, and Grubhub orders out from in-house card sales. The in-house portion is what Square’s integration already reconciled correctly — leave it. The delivery portion is money the platforms owe you on their own schedule, and it should never have been expected to match a Square deposit in the first place.
Step 2 — Pull each platform’s transaction-level payout report
From each merchant dashboard (DoorDash Merchant Portal, Uber Eats Manager, Grubhub for Restaurants), export the transaction-level payout report — not the summary. You want per-order subtotal, commission, refund adjustments, promotional charges, and the net payout, plus the deposit reference and date.
Step 3 — Match payout line items to Square orders
For each platform, match its payout line items to the Square delivery orders by order ID (or by timestamp and amount if the IDs don’t line up). For every matched order verify three things: commission ÷ subtotal equals your contracted tier rate; every refund deduction has a matching Square ticket; and every Square delivery order appears somewhere on a payout. Anything that fails one of those is a flag.
Step 4 — Tie the net payout to the bank deposit and the QBO bank-feed line
Sum the reconciled net for the payout period and match it to the actual bank deposit (allow 3–5 business days of transfer time), then to the corresponding transaction in your QuickBooks Online bank feed — the one Square’s integration did not create, because that money never moved through Square. This reconciled net is the number that bank-feed line was always going to match.
Step 5 — Flag and dispute the recoverable gaps
Commission charged above your contracted rate, refund clawbacks on orders your Square tickets show were fulfilled correctly, missing orders, and promo deductions you never enrolled in are all recoverable. Record the order ID, expected amount, actual amount, and dispute through the platform’s merchant portal with the Square ticket as evidence. Our DoorDash payout reconciliation guide walks the per-order dispute workflow in detail.
Worked example: $4,000 of Square DoorDash sales, one $2,910 QBO deposit
A restaurant on the DoorDash Plus plan (25% commission) runs a week of delivery. Square’s integration synced the in-house numbers perfectly; here is what the delivery side shows:
Square delivery sales recorded (gross, menu price): $4,000.00
QuickBooks Online bank feed — single DoorDash deposit, 4 days later: $2,910.00
Apparent “missing” money the Square integration can’t explain: $1,090.00
What the reconciliation against the DoorDash payout report explains:
- Marketplace commission at the contracted 25%: −$1,000.00 (expected — not a discrepancy)
- 6 orders charged at 28% instead of 25%: −$42.00 (recoverable overcharge)
- 2 refund clawbacks on orders Square shows were handed off correctly: −$60.00 (disputable)
- 1 Square delivery order ($30.00) that never appears on any DoorDash payout: (missing payout)
Reconciled, expected net payout: $3,000.00 · Actually deposited: $2,910.00 · Recoverable: $132.00 for one week
Now the QBO bank-feed line makes sense: the $2,910 deposit reconciles to $3,000 of true net minus $90 still owed (the $42 overcharge + the $30 missing order + an $18 timing slice that clears next week). The reconciliation closes against a number you can defend — and you have a $132 dispute filed instead of a plug papering over the gap Square’s integration couldn’t see.
Annualize that single week and it’s well over $6,000 of leak plus recoverable disputes that, without reconciliation, simply vanish into the delivery deposits your integration auto-categorized and never questioned.
See your real numbers: connect Square, add your delivery statements and bank deposits, and get the reconciled net plus every recoverable discrepancy.
Run a Free ScanWhat this means for your books (and your bookkeeper)
Here is the clean hand-off. Square’s integration already gave your books accurate in-house numbers — don’t touch those. For delivery, what the books actually need is two things per platform per payout period: the true net amount received (which now matches the bank), and the itemized list of deductions and recoverable discrepancies that explains the difference between gross Square delivery sales and that net.
With those two things, the QuickBooks Online bank reconciliation closes against a defensible number instead of a plug. How those figures are then posted — which accounts the commission, refunds, and recoverable disputes are booked to — is your bookkeeper’s or accountant’s call and outside the scope of this guide. The point of this guide is upstream of that: your bookkeeper cannot book a number nobody has reconciled, and Square’s integration never reconciled the delivery side because that money never passed through Square.
This is also the line between this guide and a POS–QuickBooks integration comparison. Square’s integration is the best available and you should keep using it — it just doesn’t reconcile what the platforms paid. If you’re comparing connectors, our breakdown of POS systems that actually sync with QuickBooks covers that — but note that even Square’s best-in-class sync leaves this delivery gap, because the gap is in the payout, not the data transfer.
How DeliverGuard reconciles this automatically
Doing the five steps above by hand works for one week. Across hundreds of orders a month, three platforms, and a monthly close, it is the task that gets skipped — and skipped reconciliation is exactly where the leak compounds behind deposits your integration already auto-categorized as “fine.”
DeliverGuard connects to your Square data and ingests your DoorDash, Uber Eats, and Grubhub statements and your bank deposits, then matches every order across all three. Commission overcharges, refund clawbacks, missing payouts, promo deductions, and timing shifts are categorized automatically, with the per-order evidence you need to dispute them. You get the reconciled net per platform that your QuickBooks Online bank reconciliation will finally match — in minutes instead of an afternoon. Verifying delivery commissions this way also surfaces the broader hidden delivery fees most restaurants miss.
Frequently Asked Questions
Square’s native QuickBooks Online integration is genuinely the best of any restaurant POS, and that’s exactly why the remaining gap is confusing. The integration syncs everything Square processes — in-house card sales, Square’s own fees, refunds, and deposits — cleanly. But DoorDash, Uber Eats, and Grubhub do not pay you through Square. They collect the customer’s money themselves and deposit you separately, days later, net of a 15–30% commission. Square never sees that money, so its flawless sync never records it. The QBO bank reconciliation breaks on the one category Square’s integration structurally cannot cover: third-party delivery payouts.
The Square-to-QuickBooks integration records the delivery order as a sale (often at full menu price) on the day it happened, but the platform’s deposit is a weekly net lump that arrives later, after commission, refunds, and promotional deductions. One net lump covering many orders on a different date will never match the per-order sales Square synced. The deposit only reconciles once you break the platform payout back down to the orders it actually paid for.
Only the sales side, and only for orders that flow through Square. If a delivery order is recorded in Square, the integration syncs it as revenue. What the integration cannot do is reconcile the delivery platform’s net payout, because that payout never moves through Square — DoorDash, Uber Eats, and Grubhub deposit it to your bank directly. Square’s own documentation positions the QBO sync for in-house operations; heavy delivery operations are where it leaves a gap that needs separate reconciliation.
Separate delivery orders from in-house Square sales, pull each platform’s transaction-level payout report, and match the payout line items to the Square orders for that period order-by-order. Verify the commission rate (commission divided by subtotal vs. your contracted tier), confirm every refund deduction has a matching Square ticket, and flag any Square delivery order missing from the payout. The reconciled net per platform is the figure the QBO bank-feed deposit will finally match — separate from the in-house deposits Square already synced correctly.
Square’s integration already handles in-house deposits correctly — leave those alone. Delivery platform deposits are a different stream: the amount that hits your bank is the platform’s net payout, not gross delivery sales, so the books need the reconciled net plus the list of commission, refund, and fee deductions that explain the difference. Producing those reconciled figures and the recoverable-discrepancy list is the reconciliation step this guide covers. How they are then booked is your bookkeeper or accountant’s call and outside the scope of this guide; the point is they need a reconciled net to book, not a raw bank lump.
Because the two solve different problems. Square’s integration solves data entry for the money Square processes. Delivery reconciliation solves the money difference for the payouts Square never touches. Square will sync $4,000 of menu-price DoorDash sales while only $2,910 ever reached your bank from DoorDash, and the integration has no way to explain the $1,090 gap because that math happened entirely on DoorDash’s side. A great integration plus unreconciled delivery still equals a bank rec that won’t close.
It depends on the platform and discrepancy type. Commission-rate errors are generally disputable up to roughly 90 days back, longer with contract documentation if the error is systematic. Refund clawbacks are most easily disputed within about 30 days. Missing orders should be disputed as soon as discovered because supporting delivery logs expire. Running a reconciliation across the last 90 days of Square orders and platform payouts typically surfaces one-time recoverable money alongside the ongoing leak.