QuickBooks Online · Feature
QuickBooks Online reconciliation: how the reconcile tool works.
The QuickBooks Online reconcile tool matches an account in your books to the bank or credit-card statement for a single period. You enter the statement’s ending balance and date, mark the transactions that have cleared, and drive the difference to zero before you finish — which locks the period and produces a reconciliation report. Below: exactly what the tool does, how to reconcile correctly each month, and when months that won’t balance mean it’s a ProAdvisor call. Independent firm, not affiliated with Intuit Inc.
QuickBooks Online reconciliation is the process of confirming that an account in QuickBooks — a bank account or credit card — matches the institution’s statement for a given period. In the reconcile tool you enter the statement’s ending balance and ending date, then mark each transaction in QuickBooks that also appears on the statement as cleared. As you check items off, QuickBooks tracks the difference between your books and the statement; a completed reconciliation requires that difference to be zero. When you finish, QuickBooks marks those transactions as reconciled, effectively locking the period, and generates a reconciliation report you can save. Important: matching transactions in the bank feed is not the same as completing a reconciliation — the feed records activity, but only the reconcile tool proves the account ties to the statement.
Reference maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent firm — not Intuit, and not Intuit’s official software support. Not affiliated with Intuit Inc.
The reconcile tool, in five questions.
What does the QuickBooks Online reconcile tool do?
It matches an account in QuickBooks — a bank account or credit card — to that account’s statement for one period. You enter the statement’s ending balance and date, mark each transaction that has cleared, and drive the difference to zero. When you finish, QuickBooks marks those transactions reconciled (locking the period) and produces a reconciliation report.
How do I reconcile an account in QuickBooks Online?
Get the statement; confirm the beginning balance in QuickBooks matches last period’s ending balance; enter the new statement’s ending balance and date; mark each transaction that appears on the statement as cleared (the bank feed speeds this up); investigate any difference instead of forcing it; finish only when the difference is zero; then save the reconciliation report.
Is matching the bank feed the same as reconciling?
No — and this is the most common misunderstanding. Accepting or matching transactions in the bank feed just records activity in your books. Reconciliation is a separate step that proves the account ties to the statement for a period. You can have a fully reviewed bank feed and still have never reconciled. Only the reconcile tool produces a reconciliation report and locks the period.
Why won’t my QuickBooks reconciliation balance?
The difference is non-zero because something in the books doesn’t match the statement: a missing or duplicated transaction, a wrong amount or date, an entry posted to the wrong account, or a beginning balance thrown off by a prior period that was changed or forced. The correct fix is to find and correct the cause — never to enter an adjustment just to make the difference disappear.
How often should I reconcile in QuickBooks Online?
Every account, every statement period — usually monthly, when the bank or credit-card statement is issued. Reconciling on a regular cadence keeps differences small and easy to trace. The longer an account goes unreconciled, the harder each month is to tie out, which is how businesses end up needing a catch-up or cleanup.
What “reconciling” in QuickBooks Online means.
Reconciling is how you prove that an account in QuickBooks agrees with the outside record of it — your bank or credit-card statement. For one statement period you tell QuickBooks the statement’s ending balance and ending date, then go down the list and mark every transaction in QuickBooks that also appears on the statement as cleared. The reconcile tool keeps a running difference between what your books say and what the statement says; when that difference is zero, the period reconciles and you can finish.
The point isn’t the green checkmarks — it’s the proof. A reconciled month means every dollar in and out of that account has been accounted for and matches an independent source. That’s what makes the rest of the financials trustworthy. It’s also why a forced reconciliation is so damaging: an adjustment entered just to make the difference disappear leaves a number in the books that no statement supports, and it compounds quietly month after month.
What the QuickBooks Online reconcile tool does.
Each piece of the reconcile screen has one job — and together they prove the account ties to the statement.
Input 01 · The statement ending balance and date
You start a reconciliation by telling QuickBooks two things from the statement: its ending balance and its ending date. These define the target — the figure your books must agree with — and the period the reconciliation covers. Everything else on the screen works toward matching that ending balance.
Input 02 · The beginning balance
QuickBooks carries the beginning balance forward from the last completed reconciliation. It should equal the prior statement’s ending balance. When the beginning balance is wrong, it almost always means a previously reconciled transaction was later changed or deleted — a sign to investigate before going further.
Action 03 · Marking transactions as cleared
The main panel lists the transactions in QuickBooks for that account. You check off each one that also appears on the statement — deposits, payments, and charges that have actually cleared the institution. The bank feed makes this faster, since matched feed transactions are easy to confirm against the statement.
Signal 04 · The running difference
As you mark items cleared, QuickBooks shows a live difference — the gap between the cleared total in your books and the statement’s ending balance. A completed reconciliation requires this difference to be exactly zero. A non-zero difference is the tool telling you something doesn’t match yet; it is not something to override.
Outcome 05 · Finishing locks the period
When the difference is zero you can finish. QuickBooks marks the cleared transactions as reconciled, which effectively locks them — changing or deleting a reconciled transaction later will throw off a future beginning balance and warn you. This lock is what gives a reconciled period its integrity.
Outcome 06 · The reconciliation report
Finishing produces a reconciliation report listing the cleared and uncleared transactions and the balances that tie out. Save it — it’s the audit trail that proves the account matched its statement for that period, and it’s the first thing a ProAdvisor or accountant looks for when reviewing the books.
How to reconcile correctly each month.
Seven steps, in order. The discipline that matters most is in step six: only finish at a zero difference — never force it to balance.
Get the statement
Start with the actual bank or credit-card statement for the period — not an online snapshot of the current balance. You need its ending balance and ending date, because those are what the reconciliation is measured against.
Confirm the beginning balance matches last period
Before you do anything else, check that the beginning balance QuickBooks shows equals last period’s statement ending balance. If it doesn’t, a previously reconciled transaction was changed or deleted — resolve that first, because reconciling on a wrong starting point just buries the error.
Enter the ending balance and date
Open the reconcile tool for the account and enter the statement’s ending balance and ending date exactly as shown. This sets the target and the period; an entry typo here will make the reconciliation impossible to balance honestly.
Match each transaction (use the bank feed to speed it)
Go down the list and mark each QuickBooks transaction that also appears on the statement as cleared. Where the bank feed has already brought in and matched transactions, confirming them is quick — but still check them against the statement rather than assuming the feed is complete.
Investigate any difference — don’t force it
If the difference isn’t zero, find out why: a missing transaction, a duplicate, a wrong amount or date, or something posted to the wrong account. Correcting the actual cause is the whole point of reconciling. Entering an adjustment just to clear the difference defeats the purpose and corrupts the books.
Finish only at a zero difference
Complete the reconciliation only when the difference reads zero on its own. A reconciliation finished with a forced adjustment isn’t reconciled — it’s a number nothing supports, and it will compound into every period that follows. If you can’t reach zero honestly, stop and get the file reviewed.
Save the reconciliation report
Once finished, save (or export) the reconciliation report. It’s the proof the period tied to the statement and the record you’ll want at tax time, during a review, or if a later balance looks off. Keep one per account, per period.
Reconciliation won’t balance, or months are behind?
A Certified ProAdvisor reviews the file free, then reconciles each account to its statement — and unwinds any forced adjustments — without ever forcing a balance. A focused diagnostic is typically a $1,200–$3,000 fixed-fee scope; cleanup runs $1,500–$15,000+ if the books are behind. Independent firm.
When a ProAdvisor should help.
It won’t balance
You’ve checked your work and the difference still won’t go to zero, or the beginning balance is off and you can’t find why. That’s the moment to get help — not to enter an adjustment to finish. A ProAdvisor traces the difference to its real source and corrects that instead.
Prior reconciliations were forced
If past periods were balanced with adjusting entries just to make them close — or you inherited a file where they were — those forced numbers sit in the books unsupported and distort everything after them. Unwinding forced reconciliations correctly is ProAdvisor cleanup work.
Months are behind
When several statement periods have gone unreconciled, catching up means reconciling each period in order against its own statement — and untangling whatever drifted in between. That’s a catch-up or cleanup engagement, not a single sitting.
A Certified ProAdvisor reconciles to a zero difference — never to a forced one.
Finishing a reconciliation is easy; finishing an honest one is the work. When the difference won’t go to zero, a Certified QuickBooks ProAdvisor traces it to its real source — a missing transaction, a duplicate, a wrong date or amount, an entry posted to the wrong account, or a prior period that was forced — and corrects that, rather than entering an adjustment to make the number disappear. The same discipline applies to months that have fallen behind: each period is reconciled to its own statement, in order, until the account ties. A Certified ProAdvisor with active Online and Desktop certifications does this against a written scope. Independent firm — not Intuit, and not Intuit’s software support; an Intuit account, login, or billing matter stays with Intuit.
Zero
the only acceptable difference — we never force a balance
$1,200–$3,000
typical fixed-fee diagnostic for a focused reconciliation fix
Independent
Certified ProAdvisor firm — not Intuit, not Intuit’s software support
What people ask about reconciling in QuickBooks Online.
Is this Intuit’s official QuickBooks support?
What does the QuickBooks Online reconcile tool actually do?
Is matching the bank feed the same as reconciling?
What is the “difference” and why must it be zero?
Why won’t my reconciliation balance?
Should I ever force a reconciliation to balance?
How often should I reconcile in QuickBooks Online?
Can a ProAdvisor fix reconciliations that won’t balance or were forced?
Reconciliation won’t balance, or months are behind?
Won’t reconcile? Get the file reviewed before you force it.
If the difference won’t go to zero, prior reconciliations were forced to balance, or you’re months behind, the answer is never to make an adjustment just to finish — that hides the real problem. Start with a free file review; from there a focused diagnostic is typically a $1,200–$3,000 fixed-fee scope, and a full cleanup runs $1,500–$15,000+ when the books are behind. Independent ProAdvisor firm, written scope before any work begins.