Skip to content

Guides · QuickBooks how-to

How to reconcile in QuickBooks Online — properly.

Reconciliation is the step that turns plausible-looking books into proven ones. The full walkthrough — what to gather, where the Reconcile screen lives, how to match against the statement, and how to chase a stubborn difference to zero without cheating.

Written by a Certified QuickBooks ProAdvisor practice that reconciles client accounts every month. General education, not advice for your specific situation.

Statement-first method ProAdvisor-written · 40 years
THE BANK ENDING BALANCE STATEMENT the authority YOUR BOOKS CLEARED BALANCE QB REGISTER proven against it DIFFERENCE  $0.00 every line accounted for, both directions

In brief

Reconciliation in four answers.

What is reconciling, really?

Proving your QuickBooks register against the bank's own statement for one period, line by line, until the difference reads $0.00. Proof, not tidying.

Isn't the bank feed enough?

No. The feed imports; it doesn't prove. Accepted feed transactions can still hide duplicates, gaps, and wrong amounts — reconciliation is the separate step that catches them.

Where does it live in QBO?

Transactions → Reconcile (or the gear menu → Reconcile). Pick the account, enter the statement's ending balance and date, and tick lines off against the paper.

What if it won't hit zero?

A missing transaction, a duplicate, a mistyped amount, or a broken beginning balance — find which, fix it, never force an adjustment. The stubborn cases →

A Westgate framework · before the steps

The Statement-First Rule.

The Statement-First Rule is the discipline that the bank's own statement — not the bank feed, not the register, not memory — is the authority every reconciliation proves the books against. It exists because QuickBooks Online quietly encourages the opposite habit. The bank feed looks authoritative: transactions arrive automatically, carry real dates and amounts, and accepting them feels like keeping the books current. But the feed is an import mechanism. It can deliver the same transaction twice, miss one during a connection gap, or get matched to the wrong register entry — and everything still looks plausible.

Reconciliation is the antidote, and it only works pointed in the right direction: start from the statement, and prove that every line on it exists in QuickBooks exactly once — then confirm nothing extra is in QuickBooks that the bank never saw. When that holds for the period, the difference reads $0.00 and the account is proven, not just populated. That distinction — populated versus proven — is the whole reason reconciliation exists as a discipline.

BANK FEED automatic imports IMPORT, NOT PROOF duplicates & gaps ride along QB REGISTER BANK STATEMENT the authority ending balance + date RECONCILE — LINE BY LINE, BOTH WAYS $0.00 difference = proven
The Statement-First Rule: the bank feed imports into the register one way — convenient, but proof of nothing. Reconciliation is the separate loop that proves the register against the statement in both directions, and it's the only path to a difference of $0.00 that means something.

The walkthrough

The six steps, in the order that works.

The same sequence our operators run on every client account, every month. Fifteen minutes when the books are current.

1 · Get the actual statement

Download the month's statement from the bank — PDF or paper, not the transaction feed. You need two numbers off it: the ending balance and the ending date. Those two define the period you're about to prove.

2 · Check the beginning balance

On the Reconcile screen, QuickBooks shows a beginning balance carried from last month's reconciliation. It must equal your statement's opening balance. If it doesn't, stop — a reconciled transaction was edited or deleted, and that gets fixed first.

3 · Enter the ending figures

Transactions → Reconcile, choose the account, then type the ending balance and ending date exactly as the statement shows them. QuickBooks now lists every register transaction in the period, uncleared, waiting to be ticked.

4 · Match statement-first

Work down the statement, not the screen: find each statement line in QuickBooks and tick it. Deposits first, then withdrawals, is the calmest path. Anything on the statement you can't find in QuickBooks goes on a short list — that list is gold.

5 · Chase the difference to zero

When every line is ticked, the difference should read $0.00. If it doesn't, the gap itself is the clue — one missing transaction, one duplicate, one mistyped amount. Fix the cause in the register. Never paper over it with an adjustment entry.

6 · Finish and keep the proof

Click Finish now, then save or print the reconciliation report. That report is your audit trail — the dated proof this account was clean through this statement. Repeat for every account that gets a statement: cards and loans too, not just checking.

One caution from forty years of fixing what shortcuts leave behind: an account is either reconciled to its statement or it isn't — there is no "close enough." A $3.87 difference forced through an adjustment doesn't disappear; it moves into next month's beginning balance and waits, and undoing a bad reconciliation later is far messier than never forcing one. When months of this have piled up, that's no longer a reconciliation problem — it's a QuickBooks cleanup.

Troubleshooting

When the difference won't go to zero.

A stubborn difference is never mysterious — it's mechanical. Four causes account for nearly every case we see.

Read the difference itself before hunting. If it exactly equals one statement line, that transaction is missing from QuickBooks — enter it and you're done. If it equals a QuickBooks entry the statement doesn't show, you're looking at a duplicate, usually a feed transaction accepted on top of a manually entered one — delete the copy, keep the original. If it's divisible by nine, an old bookkeeper's tell, suspect transposed digits: $541 entered as $514. And if the screen was wrong before you ticked anything, the beginning balance is broken — someone edited or deleted a previously reconciled transaction, and that history has to be repaired before this month can prove out.

DIFF ≠ $0.00 MISSING ENTRY on statement, not in QB FIX: ENTER IT DUPLICATE in QB twice, bank saw once FIX: DELETE COPY WRONG AMOUNT $541 keyed as $514 — ÷9 tell FIX: CORRECT IT BROKEN OPENING reconciled history edited FIX: REPAIR HISTORY FORCED ADJUSTMENT ENTRY  — never; it hides the error in next month's opening
Diagnosing a stubborn difference: match the gap to its mechanical cause — missing entry, duplicate, keyed amount, or broken opening balance — and fix the cause in the register. A forced adjustment doesn't resolve the error; it forwards it to next month.

Two of these have full diagnosis pages if you're in the middle of one right now: the account that won't reconcile and the backlog of unreconciled accounts. And if the beginning balance has been broken for months, stop patching month by month — that's repair work, and it's exactly what our reconciliation service does with a documented fix log.

The honest section

Should you be doing this yourself?

Often, yes — genuinely. One business checking account, a current file, statements that reconcile in fifteen minutes a month: that's owner-doable with nothing but this guide and the discipline to do it every month. Plenty of businesses never need more, and we'd rather say so than pretend otherwise.

The handoff point is mechanical, not moral. When there are four or five accounts across banks and cards, when reconciliation keeps losing to revenue work three months running, when the beginning balance is broken and the fix means excavating last year's history, or when the file has never actually been reconciled — only fed — the fifteen-minute habit has become a project, and the project compounds while it waits. That's when it stops being a DIY task: months behind goes to a cleanup first, and staying current afterward is what a monthly bookkeeping relationship is for — every account reconciled to its statement as part of a proper month-end close, with the reports to prove it.

Not sure which side of that line you're on? The free assessment looks at your actual file and tells you plainly — including "you're fine, keep doing it yourself."

Free books assessment

QuickBooks reconciliation FAQ · Updated July 2026

The questions owners ask mid-reconcile.

Open Reconcile (Transactions → Reconcile, or the gear menu → Reconcile), choose the account, and enter the ending balance and ending date from your actual bank statement. QuickBooks then shows every transaction in the register for that period; tick each one off against the statement, line by line, until the difference in the corner reads $0.00. Then click Finish now and save the reconciliation report. The statement is the authority throughout — you're proving the books against the bank, not the other way around.
Three things. The bank statement itself — PDF or paper, not the live feed — because its ending balance and ending date are what you reconcile to. A register that's current, meaning the bank feed has been added or matched through the statement period. And an intact starting point: the beginning balance QuickBooks shows must match your statement's opening balance. If it doesn't, a previously reconciled transaction was changed or deleted, and that needs fixing before this month can be trusted.
No — and this is the single most common QuickBooks misunderstanding we see. The bank feed imports transactions; accepting them just moves suggestions into your register, duplicates and all. Reconciliation is a separate, deliberate step that proves the register against the bank's own statement for a defined period. A file can have every feed transaction accepted and still be months unreconciled — plausible-looking books with no proof behind them.
It means that for the statement period, your QuickBooks register and the bank agree exactly — every dollar the bank saw is in your books once, at the right amount, and nothing extra crept in. That's the proof that reports built on this account are real. It is period-specific: a clean March doesn't validate April, which is why reconciliation is a monthly habit rather than a one-time fix.
One of four mechanical causes, almost always: a transaction on the statement that never made it into QuickBooks; a duplicate in QuickBooks the bank only saw once; an amount typed differently than it cleared — transposed digits are classic; or a beginning balance that was already broken before you started. Work the difference like an accountant: if it equals one statement line exactly, find that transaction; if it's divisible by 9, suspect transposition. What you should never do is force an adjustment entry to make it read zero — that buries the error instead of fixing it.
Monthly, within days of each statement arriving — once per account, every account with a statement: checking, savings, credit cards, and loans. Monthly reconciliation takes minutes when it's current because errors are fresh and few. Let it slide two or three quarters and the same work compounds into a cleanup project, because every unreconciled month is another layer errors can hide in. It's the anchor step of a proper month-end close for exactly that reason.
Partially, yourself; fully, with help. Any user can un-reconcile individual transactions — open the register, click the transaction's reconcile status (the R) until it clears — which is enough to fix a single mis-ticked line. Undoing an entire month's reconciliation in one action requires accountant access to the file, which is one honest reason to have a ProAdvisor attached. Use undo sparingly and in reverse order — newest month first — because un-reconciling an old month un-anchors every month reconciled after it. And if you're undoing to chase a difference, fix the register error instead; undo is for reconciliations run against the wrong balance or date, not for gaps that have a mechanical cause.

Months of unreconciled accounts to dig out of? Start at reconciliation. More guides: the guides hub →

Call Free books review