QuickBooks Reconciliation Guide

That zero is the only outcome that counts. Everything else in the screen is there to help you reach it. The trouble is, a difference that won't budge usually means the transactions inside QuickBooks were wrong before you ever opened Reconcile — most often because a statement was imported with a line missing. So this guide walks the reconciliation itself, then the part nobody warns you about: getting clean data in first.

What reconciling in QuickBooks actually means

Reconciliation is the check that your QuickBooks records and your bank agree. You take the bank's statement — opening balance, every transaction, closing balance — and confirm QuickBooks shows the same set. Nothing extra, nothing missing.

QuickBooks frames it around two numbers you type in from the statement: the beginning balance (which QuickBooks usually pre-fills from the last reconciliation) and the ending balance (which you enter). Between those, you clear individual transactions. Clearing a line tells QuickBooks "yes, this one is on the bank statement too." As you clear, a running Difference updates. Get it to 0.00 and the period is reconciled; QuickBooks marks those transactions with an R and locks the period's beginning balance for next month.

It helps to keep three terms straight. Cleared means a transaction has hit the bank and shows on the statement. Reconciled means you've formally matched it during a reconciliation — that's the R. And the bank feed is a separate thing entirely: it pulls transactions in, but pulling them in is not the same as reconciling them. You still have to run Reconcile to prove the totals tie out.

How to reconcile a bank account in QuickBooks Online

Here's the sequence, the way it runs on screen:

1. Go to the gear icon > Reconcile (newer layouts list it under Bookkeeping > Reconcile).
2. Choose the account you're reconciling — the specific checking, savings or credit-card account that matches the statement in front of you.
3. Check the Beginning balance QuickBooks shows against your statement's opening balance. These must match before you go further. If they don't, stop and read the beginning-balance section below — carrying on will only bury the problem.
4. Enter the Ending balance and Ending date exactly as the statement reads. A transposed digit here makes a clean reconciliation look broken.
5. Click Start reconciling. QuickBooks lists every transaction in that account up to the ending date, split into Payments and Deposits.
6. Tick each transaction that also appears on the statement. The Difference in the top-right corner moves with every tick.
7. Work down until Difference = 0.00, then select Finish now.

If the difference sits at zero, you're done and the statement is reconciled. If it won't reach zero, don't force it — QuickBooks lets you finish with a difference, but that just rolls the error into next month, where it's harder to trace.

When the difference won't go to zero

This is where most of the time goes. A stuck difference is QuickBooks telling you its records and the bank's don't match — and the gap is almost always one of a handful of things.

• A transaction in QuickBooks isn't on the statement. A duplicate, or a payment entered in the wrong period. Untick it.
• A transaction on the statement isn't in QuickBooks. Bank fees, interest and direct debits get missed most often. Add the line, then clear it.
• An amount is keyed wrong. A 45.30 entered as 45.03 leaves a difference of 0.27 — the size of the gap often points straight at the error.
• The ending balance you typed is wrong. Re-read it off the statement before assuming the transactions are at fault.
• A previously reconciled transaction was edited or deleted, which throws the beginning balance out (more on that next).

A practical move: the difference amount itself is a clue. If it equals exactly one transaction you can see on the statement, that line is probably missing or uncleared. If it's a small odd figure, suspect a typo in an amount. If it's large and round, suspect a whole missing deposit.

Why the beginning balance might be wrong

If QuickBooks' beginning balance doesn't match your statement's opening balance, do not start clearing transactions — you'll only chase a difference you can't close. A wrong beginning balance means something already-reconciled changed after the fact: a transaction with an R was edited, deleted, or had its amount or date altered.

QuickBooks flags this with a "We can help you fix it" link by the beginning balance. It opens a discrepancy report listing exactly which reconciled transactions were changed and when. Reverse those edits, restore the deleted line, and the beginning balance falls back into place — then you can reconcile the current period normally. Skipping this and forcing the period closed is how a small discrepancy quietly compounds month after month.

Get clean data in first, and reconciliation goes smoothly

Here's the pattern behind most painful reconciliations: the bank data was wrong before anyone opened Reconcile. If transactions were imported from a converted statement and one line dropped out during the conversion, QuickBooks is missing it — and no amount of ticking boxes will close the gap, because the transaction simply isn't there to clear.

That's the case for checking the import *before* it reaches QuickBooks. When you bring historical statements in by file — the route for anything the live bank feed can't reach — the safe order is: convert the PDF, confirm it's complete, import, then reconcile. A statement that already balanced on the way in tends to reconcile in QuickBooks on the first pass.

This is the gap Export Bank Statement is built to close. It converts a bank-statement PDF — including scanned or photographed statements, via OCR — into a clean CSV or Excel file, and then runs a reconciliation check of its own: it recomputes opening balance, plus money in, minus money out, against the statement's printed closing balance, and flags any statement that doesn't reconcile. So a dropped or misread transaction shows up at conversion time, not three weeks later when QuickBooks' Difference refuses to hit zero and you've no idea which month it crept in.

Be clear on what that is, though. It's a convert-then-import workflow: you export a CSV in QuickBooks' native bank-import format and upload it yourself. There's no live bank-feed API pushing data in, and it isn't a bookkeeping service — the reconciliation inside QuickBooks is still yours to run. What the tool gives you is confidence the numbers you're reconciling against are whole.

For the upload itself, see how to import PDF statements into QuickBooks. If a file throws an error on the way in, how to fix QuickBooks import errors maps each message to its cause, and can QuickBooks import PDF bank statements? settles the format question first. There's a broader set of US accounting guides too.