How to Fix Reconciliation Discrepancies in QuickBooks Online (Step by Step)

There's a specific kind of dread that only bookkeepers know. You open the reconciliation screen in QuickBooks Online, ready to knock out a routine bank rec, and the beginning balance is wrong. It doesn't match the bank. It doesn't match what it was last month. Something has changed, and you have no idea what.

If you're dealing with a reconciliation discrepancy right now, take a breath. I've been here more times than I can count — as a lead bookkeeper at Intuit QuickBooks Live, reconciliation discrepancies were probably 30% of my escalation calls. They're stressful, but they're fixable. Almost always.

This guide walks you through exactly how to find the problem, fix it, and prevent it from happening again. No panic required.

The Moment: When the Beginning Balance Doesn't Match

Let's set the scene. You go to Settings > Reconcile in QBO. You select the bank account. You enter the ending balance and ending date from the bank statement. And then you see it: the beginning balance shown in QBO doesn't match the beginning balance on your bank statement.

Before you spiral, understand this: a reconciliation discrepancy is a symptom, not a diagnosis. Something specific happened in the file to cause it. Your job is to find that something. And QBO gives you the tools to do it — they're just not always obvious.

Why Beginning Balances Go Wrong: The Three Main Causes

In my experience, beginning balance discrepancies in QBO almost always trace back to one of three things. Understanding which one you're dealing with determines your fix.

Cause 1: Someone edited or deleted a previously reconciled transaction.

This is the most common cause by far. Here's what happens: a transaction was marked as reconciled (you can tell by the "R" in the reconciliation status column). Then someone — the client, another bookkeeper, an accountant — went back and changed that transaction. Maybe they edited the amount. Maybe they deleted it entirely. Maybe they changed the date so it moved to a different period.

QBO doesn't lock reconciled transactions by default. Anyone with the right permissions can walk into a reconciled period and start making changes, and QBO won't stop them. The transaction loses its reconciled status, and suddenly your beginning balance is off by whatever amount was changed. Duplicate transactions from bank feed issues can also throw off reconciliations — if the same transaction exists twice, one might be reconciled while the other inflates the balance.

Cause 2: Someone manually uncleared a transaction.

This one's subtle. In a bank register, clicking on the reconciliation status column (showing "R" for reconciled, "C" for cleared, or blank) toggles a transaction's status. Click an "R" and it changes to "C." Click again and it goes blank. I've seen this happen when clients are poking around in their own file. They don't know what that column does — they just see letters and start clicking. One misclick, and your reconciliation is off.

Cause 3: A transaction was moved to a different account after reconciliation.

Someone reconciled a transaction in the checking account. Later, someone else recategorized that transaction — maybe they changed it from Checking to a credit card account, or moved it to a different bank account. The transaction still exists in QBO, but it's no longer in the account where it was reconciled. The original account's reconciled balance drops by that amount.

This is especially common in files where multiple people have edit access, and when clients use the mobile app and accidentally change things while trying to "categorize" transactions.

Your First Move: The Reconciliation Discrepancy Report

Before you start manually hunting through transactions, QBO has a built-in report that shows you exactly what changed. It's called the Reconciliation Discrepancy report, and it's genuinely one of the most useful reports in the system.

Here's how to find it:

Go to Settings (gear icon) > Reconcile.
Instead of starting a new reconciliation, click History by account (it's a link near the top of the reconciliation screen).
Select the account you're having trouble with.
Find the most recent completed reconciliation and click View report.
On the reconciliation report that opens, look for a link or option that says Discrepancy report or navigate to Reports > Reconciliation Discrepancy and select the account.

The discrepancy report shows every transaction that was changed after reconciliation — including the transaction type, original amount, what changed, who made the change, and when. This is your treasure map. In most cases, it will point you directly to the problem.

Going Deeper: The Audit Log

Sometimes the Reconciliation Discrepancy report doesn't tell the whole story. Maybe the discrepancy is from changes that happened weeks ago. Maybe multiple changes compound each other. That's when you pull out the big gun: the Audit Log.

Go to Settings (gear icon) > Audit Log. This is a comprehensive record of every change made in the QBO file — who did it, when, and what exactly changed.

To make the Audit Log useful (because it records everything and can be overwhelming):

Filter by date range. Start with the period between your last successful reconciliation and when you noticed the discrepancy.

Filter by user. If you suspect a specific person made the change, narrow it down. This is especially useful in files with multiple users.

Filter by event type. Look for "Delete," "Edit," or "Void" events. You can usually skip "Create" events unless you're looking for duplicate entries.

When you find a suspicious entry, click on it to see the full before-and-after detail. QBO will show you the original values and the new values. This is where you'll find your smoking gun.

Pro tip: Export the Audit Log to Excel if you're dealing with a lot of changes. You can sort and filter much more efficiently in a spreadsheet than in QBO's interface. Go to the Audit Log page, set your filters, and click the export icon.

Step-by-Step: Fixing the Discrepancy Without Undoing Everything

Okay, you've found the problem. Now how do you fix it without blowing up all your previous reconciliation work?

Scenario 1: A reconciled transaction was deleted.

If someone deleted a transaction that was previously reconciled, you need to re-enter it. Create a new transaction with the same date, amount, payee, and account. Then manually mark it as reconciled by going to the account register and clicking the reconciliation status column until it shows "R." This restores the reconciled balance without requiring you to undo and redo the entire reconciliation.

Scenario 2: A reconciled transaction was edited (amount changed).

Two options here. If the original amount was correct, change it back to the original amount and re-mark it as reconciled. Done.

If the edited amount is actually correct (maybe the original was wrong), you'll need to create an adjusting entry. The adjustment should equal the difference between the old and new amounts. Date it to the period of the original reconciliation, categorize it appropriately, and mark it as reconciled.

Scenario 3: A transaction was moved to a different account.

Move it back. Edit the transaction and change the account back to where it was originally. Then check the reconciliation status — it may need to be re-marked as reconciled. If moving it back doesn't make sense (because the recategorization was correct), you'll need the adjusting entry approach: add a transaction to the original account to restore the reconciled balance, and make sure your current-period reconciliation accounts for the change.

Scenario 4: Someone toggled the reconciliation status.

The simplest fix. Go to the account register, find the transaction, and click the reconciliation status column to toggle it back to "R." Just be careful — make sure you're restoring the correct status, not creating a new problem.

When to Undo a Reconciliation vs. When to Adjust

QBO lets you undo a reconciliation entirely. Go to Settings > Reconcile > History by account, find the reconciliation in question, and click Undo. All transactions from that reconciliation will be unreconciled, and you can start over.

Undo when:

The discrepancy is in the most recent reconciliation period
There are multiple errors that are easier to fix by starting fresh
You have the bank statement handy and the time to re-reconcile
The reconciliation was done incorrectly in the first place (wrong ending balance, wrong transactions checked off)

Don't undo when:

The discrepancy traces back multiple periods — undoing one reconciliation will cascade into the next
The file has been through tax preparation based on those reconciled periods
The discrepancy is small and an adjusting entry is simpler and less disruptive
You're on a deadline and can't afford the time to re-reconcile

Undoing reconciliations is a legitimate tool, but it's not always the most efficient one. If the discrepancy is $14.99 and traces back to a single deleted transaction, re-entering that transaction and marking it reconciled takes two minutes. Undoing and redoing an entire month's reconciliation takes an hour. Use the scalpel, not the sledgehammer.

The Nuclear Option: When an Adjusting Entry Is the Right Call

Sometimes you inherit a file where the reconciliation history is so tangled that forensic accounting would take longer than it's worth. The previous bookkeeper was force-reconciling by posting adjustments to "Reconciliation Discrepancies" every month. Or the discrepancy traces back two years and multiple bookkeepers. Or the bank has been closed and you can't even get statements to verify against.

In these cases, a clean adjusting entry is the right call. Here's how I handle it:

Document the discrepancy amount and your research into the cause. Even if you can't pinpoint the exact transaction, write down what you checked and what you found.
Post a journal entry for the discrepancy amount. Debit or credit the bank account (whichever direction corrects the balance), and put the offset in an appropriate account — usually an equity account like "Opening Balance Equity" or a specific "Prior Period Adjustment" account.
Mark the journal entry as reconciled in the bank register.
Add a memo to the journal entry explaining exactly what it is and why you posted it: "Adjusting entry to correct beginning balance discrepancy of $X.XX. Discrepancy traced to [best explanation]. See documentation in [location]."
Communicate the adjustment to the client and their CPA.

I know this feels like giving up. It's not. It's a professional judgment call. Your time has value, and spending eight hours chasing a $200 discrepancy from 2022 is not a good use of it. Document what you know, make the adjustment, and move forward with clean reconciliations. That said — never use an adjusting entry to cover up something you don't understand. The nuclear option is for old, inherited, truly untraceable issues. Not for "I don't feel like looking into this."

Preventing Future Discrepancies

The best reconciliation discrepancy is one that never happens. Here's how to lock things down:

Set a closing date. This is the single most important preventive measure. Go to Settings > Advanced > Accounting > Close the books. Enter the date of your last completed reconciliation period. When someone tries to edit a transaction before that date, QBO will either warn them or block them entirely, depending on your settings.

Choose "Allow changes after viewing a warning and entering a password" and set a password that only you know. This doesn't make the closing date bulletproof — someone with the password can still make changes — but it creates a speed bump that prevents accidental edits. The client won't know the password, and that's the point.

Update the closing date after every reconciliation. This is the step people forget. You reconcile January, great. But if you don't move the closing date forward, February's reconciled transactions are still unprotected. Make it part of your reconciliation workflow: reconcile, then immediately update the closing date.

Manage user permissions. Not everyone needs full access to everything. Go to Settings > Manage Users and review who has what level of access. If the client's office manager doesn't need to edit bank transactions, don't give them that permission. The more restrictive your permissions, the fewer surprise changes you'll deal with.

Educate your clients. A simple conversation — "once I've reconciled a month, please don't change any transactions from that period without checking with me first" — prevents more issues than any technical control. Most clients don't change reconciled transactions on purpose. They just don't know the consequences.

Use the Audit Log proactively. Don't wait for a discrepancy. Once a month, after reconciling, do a quick scan for any changes to your reconciled periods. Two minutes of proactive checking beats two hours of reactive detective work.

Real Talk: The Judgment Call

Here's what nobody tells you in bookkeeping school (or in QBO certification courses): sometimes you inherit a file that is so thoroughly messed up that there's no clean answer. The previous bookkeeper was force-reconciling by posting mystery adjustments. Or they were "reconciling" by just clicking everything until the number matched, whether or not the transactions actually cleared the bank. Or they weren't reconciling at all, and someone came in later and marked everything as reconciled in bulk.

In those situations, you have to make a judgment call. How far back can you reasonably verify? Is a $50 discrepancy from 2021 worth three hours of research? Can you get old bank statements for a proper historical reconciliation, or is that information gone?

My approach: work backward from the present. Get the most recent month reconciled correctly. Then the month before that. Keep going back until you either reach clean reconciliations or hit a wall where the data quality is too poor to continue. At that wall, post your adjusting entry, document everything, and draw a line in the sand.

Your job isn't to achieve perfection in a file that was neglected for years. Your job is to get it to a state where, going forward, the financial statements are accurate and the reconciliations are reliable. Reconciliation is Step 8 of my full 12-step cleanup process — it comes after the COA and categorization work, so the transactions are in the right accounts before you start matching. That's the standard. And sometimes getting there means accepting that the historical data has limitations.

The bookkeepers I respect most aren't the ones who refuse to post an adjusting entry on principle. They're the ones who do the research, document their findings, communicate clearly with the client and CPA, and make a defensible decision. That's professional judgment. That's the job.

Don't Just Fix the Symptom

Reconciliation issues are usually just one symptom of a bigger file health problem. If the beginning balance is off, there's a good chance other things are off too — uncategorized transactions, vendor records that need cleanup, payroll discrepancies, and chart of accounts issues that are hiding errors.

Before you fix one discrepancy and call the project done, scope the full picture. I built LedgerClean to do that diagnostic automatically — upload your client's QBO exports and it checks reconciliation gaps alongside 7 other detection categories, then gives you a prioritized issue list with fix procedures and time estimates. Free to try.