Most small business owners open QuickBooks, glance at the balance, and assume it matches what’s really in the bank. It doesn’t — not until you reconcile. This QuickBooks Online reconciliation guide walks you through how to reconcile in QuickBooks Online, start to finish: what reconciliation actually is, how to set up your bank feed first, the step-by-step match, what to do when it won’t balance, and how to turn the whole thing into a 15-minute monthly habit.
I’ll tell you up front why I care about this so much. I once took over a company with three years of unreconciled books. Their accountant never opened QuickBooks — he just “did the return off the bank statements.” For two of those years, they had carryover losses that nobody ever deducted. That oversight cost them around $4,000 in taxes they never owed. Three years. Four thousand dollars. All because nobody did the one thing this guide is about.
Let’s make sure that’s never you.
Updated September 2026. The QuickBooks Online reconciliation process, the bank reconciliation itself, has not changed, but the menu has: Reconcile now lives under Transactions (or the gear icon, under Tools) instead of Accounting. The steps below use the current menu, and I have added the two questions I get asked most often after someone reads this: how to reconcile a credit card, and how to undo a reconciliation you got wrong.
What Bank Reconciliation Actually Is (And Why It’s Non-Negotiable)
Bank reconciliation in QuickBooks Online is simple to define: you match every transaction in your books against your actual bank statement, line by line, until the two agree to the penny. That’s it. You’re confirming that what you think happened in your business actually happened in your bank account.
Here’s the analogy I give people. Checking your QuickBooks balance without reconciling is like guessing how much gas you have by remembering the last time you filled up. You might be close. You might be running on fumes. The only way to know is to look at the gauge — and reconciliation is the gauge.
Now, the objection I hear constantly: “I only need to reconcile if the bank makes a mistake.” I’ve stopped arguing with people about it directly, because the framing is wrong. Reconciliation isn’t about catching the bank. Banks rarely make errors. Instead, it’s about catching everything else — the duplicate transaction you entered twice, the check that never cleared, the deposit that got categorized wrong, the subscription you forgot you were paying. In other words, reconciliation is how you confirm reality, not how you audit your bank.
The balance isn’t the only number that lies
There’s a second trap worth naming. A lot of owners run their reports on an accrual basis without really knowing what that means. So when they invoice a customer, QuickBooks books it as income — even though that money hasn’t landed yet. They look at the P&L, see a number, and think they made more than they actually did. That means they’re making decisions on phantom profit. QuickBooks Online reconciliation grounds you in real cash: what’s actually in the account right now. For more on this, see QuickBooks mistakes that quietly cost your business money.
Before You Reconcile: Set Up Your Bank Feed the Right Way
The QuickBooks Online bank feed connects your bank account directly to your books so transactions import automatically. It’s the single biggest time-saver in the platform — and the single biggest source of false confidence.
Here’s the mistake: people see transactions flowing in from the bank feed and assume that means their books are done. They’re not. Importing is not matching, and matching is not reconciling. The bank feed gets data into QuickBooks. Reconciliation is what proves that data is correct and complete.
Therefore, before you reconcile, set the feed up properly. Connect your bank to QuickBooks Online, then actually review what comes in. Categorize each transaction. When the feed suggests a match to something already in your books, confirm it — don’t blindly hit “Add” on everything, because that’s how you create duplicates that wreck your reconciliation later. A clean bank feed makes the actual reconciliation fast. A sloppy one makes it a nightmare.
How to Reconcile in QuickBooks Online: The Step-by-Step Process
This is the part you came for. Here’s the QuickBooks Online reconciliation process, start to finish.
- Get your bank statement. This is your source of truth. You need the ending date and the ending balance for the period you’re reconciling.
- Open the Reconcile tool. From the left-hand menu, go to Transactions > Reconcile. You can also click the gear icon and choose Reconcile under Tools. If your QuickBooks still shows the older menu, it lives under Accounting > Reconcile.
- Select the account you’re reconciling and enter the statement’s ending balance and ending date exactly as they appear on the statement.
- Match each transaction. Go down the list and check off every transaction in QuickBooks that also appears on your statement.
- Now look at what you didn’t check. This is the step most people skip, and it’s the most important one. Once you’ve checked off everything on your statement, stop and review every transaction that’s still unchecked. If it’s a check that simply hasn’t cleared yet, fine — leave it. But anything else sitting there unchecked is a red flag: it could be a duplicate, a transaction entered in the wrong register, a wrong amount or date, or something recorded that never actually happened. Don’t rush past these. Each one needs to be investigated before you finish (see the next section for how).
- Watch the difference field. As you check items off, QuickBooks tracks the difference between your statement and your books. Your goal is a difference of $0.00.
- Click Finish Now once the difference hits zero and every leftover transaction is accounted for. That period is now reconciled and locked in.
Step 1 is the one I lean on hardest. Start from the statement, not from your own list of accounts. A client caught me working from a schedule I had labelled wrong this fall, and when I opened her statements they showed an account that was not in her books at all. No list would have shown me that. I wrote up what happened in why a reconcile starts from the bank statement, never from the list.
One more step: save the reconciliation report
Before you move on, open the QuickBooks Online reconciliation report (the History by account link on the Reconcile screen) and save it as a PDF. That report is the proof the period was reconciled, and it is the first thing a CPA or a new bookkeeper will ask for.
If your books are too far behind to do this cleanly, that’s a different job. Here’s bookkeeping services for small business if you’d rather hand the catch-up to someone.
When Your Reconciliation Doesn’t Balance — And How to Fix It
Remember those unchecked transactions from step 5? This is where you investigate them. Whether the difference field refuses to hit zero, or you’ve simply got transactions left over that aren’t uncleared checks, a QuickBooks reconciliation discrepancy almost always comes down to a short list of usual suspects. Work through them in order:
- Duplicates. The same transaction entered twice — often once manually and once from the bank feed. This is the most common culprit.
- Entered in the wrong register. The transaction is real, but it’s sitting in the wrong account, so it’ll never match the statement you’re reconciling.
- Wrong amount or date. A transaction entered for $94 instead of $49, or dated to the wrong month.
- A transaction in your books that isn’t on the statement (or the reverse). Something you recorded that never actually cleared, or a bank charge you never entered.
- A changed or deleted prior transaction. If someone edited a previously reconciled item, it throws off your beginning balance.
- Wrong beginning balance. If this number is off before you even start, the period was never reconciled correctly to begin with.
Fix them one at a time and watch the difference shrink. If you’ve been ignoring reconciliation for months or years, though, the discrepancies pile up and chasing each one stops being worth your time. At that point, a professional cleanup is usually cheaper than the hours you’ll burn. Here’s what professional bookkeeping cleanup actually costs. And if you’d rather hand reconciliation off entirely, here is what ongoing professional bookkeeping runs.
How to Make Monthly Reconciliation a 15-Minute Habit
The owners who never struggle with this all do the same thing: monthly reconciliation, every month, the moment the statement closes. Small and frequent always beats huge and annual.
Reconciliation is step 2 of my full monthly bookkeeping checklist — the whole close takes 15 minutes when the daily work is done.
Picture a random Wednesday afternoon for an owner whose books are reconciled like clockwork. No bounced checks. No wondering who owes them what. They know exactly how much money they have, what’s coming in, and what needs to go out. So when an opportunity shows up — a new piece of equipment, a marketing campaign worth testing — they can decide in minutes instead of guessing and hoping. That’s what a clean reconciliation buys you: not just accurate books, but the confidence to make a move.
To keep it to 15 minutes:
- Reconcile right when each statement closes, not three months later.
- Keep your bank feed current so transactions don’t bottleneck.
- Categorize weekly, so reconciliation is just confirming — not catching up.
- Never let it pile up. A pile is what turns 15 minutes into a weekend.
If even 15 minutes a month is 15 minutes you don’t have, that’s a delegation problem, not a bookkeeping problem. Here’s how to delegate your bookkeeping completely.
The Money Peace Dashboard starts with reconciled accounts — download it free and see what your business actually earned this month.
What Reconciled Books Make Possible When It’s Time to File
Remember that company with three years of unreconciled books and $4,000 in missed carryover losses? That’s the real cost of skipping this. Their accountant filed off bank statements — what I call “bank statement tax returns” — and never opened the actual books. Reconciliation is what makes your books trustworthy enough to file from. Without it, your CPA is either guessing or working from a statement that doesn’t tell the whole story.
When your accounts are reconciled through the full tax year you’re filing, your CPA gets clean numbers, you claim everything you’re entitled to, and nothing quietly leaks out the side. Here’s what your CPA needs before they can file, and a tax-ready bookkeeping checklist to get there.
So here’s the question only you can answer: when’s the last time you actually reconciled — not glanced at the balance, but matched it line by line against the statement? If you can’t answer that with a date, that’s your answer.
Frequently Asked Questions
How do I reconcile my bank account in QuickBooks Online?
Go to Transactions > Reconcile from the left-hand menu (or the gear icon, then Reconcile under Tools), select the account, and enter the ending balance and date from your bank statement. Then check off each transaction in QuickBooks that matches the statement until the difference reads $0.00, and click Finish Now. Always reconcile against the actual statement — never against the running balance the bank feed shows — and review any leftover unchecked transactions before you finish.
What does it mean when QuickBooks reconciliation doesn’t balance?
It means your books and your statement disagree, usually because of a duplicate transaction, a transaction entered in the wrong register, a wrong amount or date, a transaction that never cleared, an edited prior entry, or an incorrect beginning balance. Work through those causes one at a time and the difference will shrink to zero. A persistent beginning-balance error usually means a past period was never reconciled correctly.
How often should a small business reconcile accounts in QuickBooks?
Monthly — every time a bank or credit card statement closes. Monthly reconciliation keeps each session short, often under 15 minutes, and catches errors while they’re still small and easy to trace. Waiting until tax time turns a quick habit into a painful, expensive cleanup.
How do I reconcile a credit card in QuickBooks Online?
The steps for how to reconcile in QuickBooks Online are the same for a credit card as for a bank account. Go to Transactions > Reconcile, choose the credit card account, and enter the statement ending date and ending balance exactly as the card statement shows them. The one difference is the sign: a credit card balance is what you owe, so enter it as a positive number and let QuickBooks Online handle the rest. When the difference reaches $0.00, finish. Then make sure the payment you made toward the card is recorded as a transfer from your bank account, not as an expense, or you will count that spending twice.
How do I undo a reconciliation in QuickBooks Online?
For a single transaction, open the account register, click the R in the reconcile column until it is blank, and save. That pulls one item out of a reconciled period. To undo an entire reconciliation, you need an accountant user on the file: from the Reconcile screen, open History by account, find the period, and choose Undo. If you do not have accountant access, this is exactly the kind of thing a bookkeeper or ProAdvisor can do for you in a few minutes, and it is far safer than deleting transactions to force the difference to zero when a reconciliation doesn’t balance.
Based in New Jersey? Here is how I work with New Jersey small businesses: books kept in QuickBooks Online, reconciled every month, and explained in plain English.
Get the WFPL TLDR — monthly insights for business owners who are done guessing.
