What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks Bank Reconciliation and Payout Splits
QuickBooks Reconciliation

QuickBooks Bank Reconciliation: The Steps, and the Deposits That Won't Match

Reconciling in QuickBooks Online means ticking off every transaction on your bank statement until the difference reads $0.00. The clicks are below. If you're stuck on a deposit from Stripe, PayPal, Square or Shopify, skip to the part after them.

How to reconcile a bank account in QuickBooks Online

Open Reconcile, choose the bank account, enter the statement's ending balance and ending date, and select Start reconciling.

All apps Accounting Reconcile

Older layout? The same screen is under the gear icon.

Settings ⚙ Reconcile

Tick each transaction that appears on the statement until Difference shows $0.00, then select Finish now.

Reconciling one statement

Have the statement open before you start. Reconciling from the bank's website balance, rather than the statement, is the usual cause of a difference that won't go away.

  1. 1

    Make sure the period is complete

    Every transaction on the statement should already be in QuickBooks, added or matched from the bank feed. Anything still waiting for review won't appear on the Reconcile screen.

  2. 2

    Pick the account and check the starting point

    Reconcile Account

    Choose the account. Check the Last statement ending date: this statement should start the day after it. The beginning balance QuickBooks shows should equal the opening balance on your statement.

    Watch for: a beginning balance that doesn't match. It means an earlier reconciled transaction was edited or deleted, and our guide to fixing reconciliation discrepancies covers finding it.

  3. 3

    Enter the statement figures

    Type the Ending balance and Ending date exactly as printed, then select Start reconciling.

  4. 4

    Tick off what cleared

    Select each transaction that appears on the statement. The cleared balance updates as you go. Leave uncleared checks and deposits in transit unticked; they belong to next month.

  5. 5

    Finish at zero

    When Difference reads $0.00, select Finish now, then Done. QuickBooks saves a report you can find later under History by account.

    Watch for: the option to finish with a difference anyway. QuickBooks books an adjusting entry for the gap, so ask your accountant first. If you reconciled the wrong figures, here's how to undo a reconciliation.

What QuickBooks matches for you, and what it can't

Plenty of the matching is already automatic. The gap is a deposit that stands for many sales.

QuickBooks handles

One bank line, one book entry

  • Suggested matches in the bank feed when an invoice payment or bill payment already exists
  • Bank rules that categorize repeat transactions such as rent or software subscriptions
  • The statement tick-off itself, with a saved report each month
Left to you

One bank line, many sales

  • A Stripe, PayPal, Square or Shopify payout that bundles dozens of orders
  • Processing fees taken out before the deposit lands, so no invoice equals it
  • Refunds and chargebacks from an earlier payout netted into this one
  • A different routine for each processor, every month

Payout-sync apps such as A2X and Synder split payouts for the channels they support, and if one covers all of yours, use it. n-frames builds the split when your processors, invoices or account structure fall outside what those apps handle.

Why a processor deposit has nothing to match

The sales were booked at full price

How you'll know: Invoices or sales receipts total more than the deposit, by roughly the processing fee.

Fix: Book the payout gross into a clearing account, record the fee as an expense, and match the net deposit to the clearing entry. Processing fees accounted for this way give you real margin, not gross.

Payments sit in Undeposited Funds

How you'll know: Customer payments are recorded but the bank feed can't find them, because QuickBooks is waiting for you to group them into a deposit.

Fix: Group them into a bank deposit that matches the payout, with the fee as a negative line, so the feed has one entry to match.

A refund from last month came out of this payout

How you'll know: This month's deposit is short by an amount that matches no order in it.

Fix: Pull the payout's own transaction list from the processor. It lists every order, refund and fee inside the deposit, whatever date the sale was.

What this looks like in practice

Shopify retailer

Shopify to QuickBooks sync

A retailer's Shopify sales synced into QuickBooks as one number a day, and every month someone spent half a day working out why a payout didn't match. We rebuilt the sync to itemize by product category, use real product costs, and match each payout to the orders, fees and refunds behind it. The half-day reconciliation became a five-minute check.

Questions people ask

Doesn't QuickBooks already do bank reconciliation?

Yes, and it does it well for one-to-one transactions: a bank line that matches one invoice payment, bill or expense. What it can't do on its own is break a batched payout, one deposit covering many orders with fees taken out, back into the sales and fees inside it.

Which payment processors does this work with?

Stripe, PayPal, Square, Shopify Payments and most processors that pay out in batches. Each has a way to export or read the transactions inside a payout, which is what the matching is built on.

What happens when something genuinely does not match?

It's flagged for a person to review instead of force-matched to the nearest amount. A wrong automatic match is harder to find later than no match at all.

Is the quote for automating QuickBooks bank reconciliation really free, with no obligation?

Yes. n-frames reviews which deposits give you trouble and which processors you use, and quotes a written price for the matching. Nothing is owed unless you go ahead.

How often should I reconcile my bank account in QuickBooks?

Monthly, when the statement arrives, is the usual rhythm. Busy accounts with a lot of processor deposits are easier to keep straight weekly, because a mismatch is still fresh enough to trace.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.