Reconciling a bank account in QuickBooks confirms that what’s recorded in your books actually matches what happened in your real bank account, catching missing transactions, duplicates, or typos before they turn into a bigger problem. Here’s how to reconcile a bank account in QuickBooks, step by step, and what to do when the numbers don’t match on the first try.
Last verified: September 2026.
If you haven’t set up your QuickBooks file yet, our complete setup guide covers where reconciliation fits into the recommended order.
Before you start: what you need
Have your most recent bank statement ready, either the paper copy or the PDF from your bank’s website. You’ll need the exact statement ending date and the ending balance shown on that statement, both of which QuickBooks asks for at the start of the process.
How to reconcile a bank account in QuickBooks: the steps
- Go to the Reconcile screen. From the left menu, select Accounting, then Reconcile (in QuickBooks Online), or go to Banking then Reconcile in QuickBooks Desktop.
- Select the account you’re reconciling. Choose the specific bank or credit card account that matches the statement you have in hand.
- Enter the statement ending date and ending balance. Copy these exactly as they appear on your bank statement, a small typo here throws off the entire reconciliation.
- Check off each transaction that appears on your statement. QuickBooks shows a list of transactions recorded in your books for that period. Match each one against your statement and check it off as confirmed.
- Watch the difference amount as you go. QuickBooks shows a running total of the difference between your checked transactions and the statement balance. This should reach exactly $0.00 once every real transaction is checked off correctly.
- Finish the reconciliation once the difference hits zero. Click Finish Now (or the equivalent button) to lock in the reconciliation for that period.
What to do if the numbers don’t match
A difference that isn’t zero means something is off, either a transaction is missing from your books, duplicated, or entered with the wrong amount. Work through these in order:
- Check for missing transactions first. Compare your statement line by line against what’s checked off in QuickBooks. A transaction on your statement that isn’t in QuickBooks at all is the most common cause.
- Look for duplicates next. The same transaction entered twice, often from a bank feed import plus a manual entry, inflates your books relative to the real balance.
- Check amounts on transactions you’re unsure about. A transaction entered with the wrong dollar amount, even by a few cents, prevents the difference from reaching zero.
- Check for a transaction dated outside the statement period. Something entered with the wrong date can end up excluded from or wrongly included in the current reconciliation.
Fix whichever discrepancy you find, then return to the Reconcile screen, the running difference updates automatically once the underlying transaction is corrected.
Common mistakes that cause reconciliation problems
Editing or deleting a transaction from a period you already reconciled is the single most disruptive mistake, it throws off every reconciliation after that point, not just the one you’re currently working on. QuickBooks warns you before this happens in most cases, don’t dismiss that warning without understanding what it’s telling you.
Reconciling infrequently is the other common problem. Waiting six months between reconciliations means investigating a much larger pile of transactions with less memory of what actually happened, compared to catching a discrepancy the same month it occurred.
How often you should actually do this
Monthly, matched to when your bank statement closes, is the standard cadence for most small businesses. A business with high transaction volume can benefit from reconciling weekly, catching errors faster reduces how much digging you have to do to find the cause. Reconciling less often than monthly makes each session harder and increases the chance of missing something small enough to compound over time.
Why reconciliation catches more than just typos
Beyond catching entry mistakes, regular reconciliation is also how you notice fraud or unauthorized charges early, a transaction on your statement that you don’t recognize at all, not just miscategorized, is worth investigating immediately rather than assuming it’s a QuickBooks error. It’s also the mechanism that keeps your financial reports trustworthy, a profit and loss statement built on an unreconciled account is only as accurate as the data behind it, which means any report you run between reconciliations carries some uncertainty until the next one confirms everything lines up.
If a reconciliation problem seems to trace back to a specific error message rather than a simple missing transaction, check our QuickBooks error index for that code.
When to bring in help
If a reconciliation won’t balance after checking all the common causes above, and especially if it’s been unreconciled for several months, it’s worth bringing in a bookkeeper for that specific cleanup rather than continuing to guess. A professional can usually trace a stubborn discrepancy faster than someone doing it for the first time, and getting current again is worth the one-time cost.
Frequently asked questions
What if I can’t find the source of a small discrepancy?
For a genuinely tiny, unexplainable difference (a few cents from a rounding issue, for example), some businesses record it to a miscellaneous expense account rather than spending hours chasing it. Reserve this only for truly small, thoroughly checked amounts, not as a habit.
Can I undo a reconciliation if I made a mistake?
Yes, QuickBooks allows you to unreconcile individual transactions or an entire reconciliation period, though doing so affects everything reconciled after that point too. Use this carefully and ideally with guidance if you’re not sure exactly what needs to change.
Does reconciling a credit card account work the same way?
Yes, the same process applies to credit card accounts, matching your statement against what’s recorded in QuickBooks, with the same goal of reaching a zero difference.
Why does QuickBooks show transactions I don’t recognize during reconciliation?
This usually means a bank feed imported a transaction automatically that wasn’t manually reviewed and categorized yet. Check it against your actual statement before checking it off, don’t assume every imported transaction is correct without verifying it.
This site is independent and is not affiliated with, endorsed by, or sponsored by Intuit Inc. QuickBooks® is a registered trademark of Intuit Inc. All product names, logos, and brands are property of their respective owners.