What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/QuickBooks Online
QuickBooks Online

QuickBooks Online: How to Reconcile an Account Until the Difference Is Zero

Reconciling is ticking off what's on your statement until QuickBooks agrees with the bank. If older instructions told you to look under Transactions, the menu has moved. Both current routes are below, then the order to check things in when it won't balance.

Open the Reconcile screen

Newer menu (an All apps button on the left):

All apps Accounting Reconcile

From the gear icon, which works in either layout:

Settings ⚙ Reconcile

Then: pick the account, type the statement's Ending balance and Ending date, select Start reconciling, and tick transactions until Difference reads $0.00.

One month, start to finish

  1. 1

    Clear the bank feed first

    Banking For review

    Add or match everything waiting in the feed for this period. A transaction still sitting in For review isn't in your books yet, so it can't be ticked off.

  2. 2

    Open Reconcile and choose the account

    First time? You'll see Get started. Otherwise select Reconcile, pick the bank or card account from the Account dropdown, and look at the last statement ending date QuickBooks shows. This statement should begin the following day.

  3. 3

    Type the figures from the statement itself

    Use the printed ending balance and date on the PDF or paper statement, not today's balance on the bank's website. They're rarely the same number.

    Watch for: the beginning balance QuickBooks displays. It has to equal the opening balance on this statement. If it doesn't, stop and fix that first, because no amount of ticking will close the gap.

  4. 4

    Tick off what the statement shows

    Work down the statement and tick each matching line in QuickBooks. Filter by payments or deposits if the list is long. Checks and deposits that haven't cleared the bank yet stay unticked and roll into next month.

  5. 5

    Finish now

    At $0.00, select Finish now, then Done. Use Save for later if you need to stop halfway; your ticks are kept.

Difference isn't zero? Check these in order

Re-read the difference after each one. Most months it's the first or second.

A typo in the ending balance or date

How you'll know: The difference is a round number, or the date is a day off.

Fix: Select Edit info at the top of the Reconcile screen, compare both fields with the statement, and save.

The beginning balance has moved

How you'll know: It no longer matches the statement's opening balance, though last month reconciled fine.

Fix: A reconciled transaction was edited or deleted since. Our guide to fixing reconciliation discrepancies shows how to find which one.

The bank grouped payments QuickBooks has separately

How you'll know: One deposit on the statement, three customer payments in QuickBooks, none of them a match on its own.

Fix: Move the payments to Undeposited Funds and record one bank deposit that combines them, so a single entry matches the bank's line.

Something on the statement isn't in QuickBooks

How you'll know: A bank fee, interest, or a payment you forgot to enter.

Fix: Add it as an expense, a deposit or a sales receipt, dated as on the statement. Small fees are a common culprit; see recording bank charges.

Something in QuickBooks isn't on the statement

How you'll know: The difference equals one transaction's amount exactly, often a duplicate from the feed plus a hand-entered copy.

Fix: Untick it if it simply hasn't cleared yet. If it's a genuine duplicate, delete one copy, but only when you're certain it's an error.

You still can't find it

How you'll know: Everything ticked matches, and a small gap remains.

Fix: QuickBooks lets you finish anyway and posts an adjusting entry for the gap. Talk to your accountant before you do, because that entry hides the error rather than fixing it.

Questions people ask

What does it mean to reconcile in QuickBooks?

It means proving that the transactions QuickBooks holds for an account are the same ones on your bank or credit card statement for that period. It's how typos, double entries and missing transactions get caught before they reach your tax return.

How do I undo or unreconcile a transaction in QuickBooks Online?

For one transaction, open the account's history from the chart of accounts, find it, and click the R in the status column until it's cleared, then save. Undoing a whole past reconciliation in one go needs QuickBooks Online Accountant, so your accountant has to do it. Full steps in how to undo a reconciliation.

How do I reconcile a credit card account in QuickBooks?

Open Reconcile the same way and choose the card account. Charges and refunds are ticked off against the card statement exactly as with a bank account, and the payment you made to the card appears as one line.

What do I do if a reconciled transaction got deleted or changed afterward?

You'll usually notice because the beginning balance on the Reconcile screen no longer matches your statement. Open the reconciliation report for the earlier month to see what changed, then restore the original entry. Past reports live under History by account; see reconciliation reports.

How often should I reconcile in QuickBooks Online?

Every month, for every bank and card account, as soon as the statement arrives. One month takes minutes. Six months at once means hunting errors that are half a year old.

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.