Your reconciliation beginning balance doesn’t match. Here’s how to find out why.

You open the reconciliation screen, and the beginning balance is already wrong. Not the ending balance — the beginning one, the number QuickBooks carried forward from the last time everything agreed. Nothing you do in this month's reconciliation will fix it, because the problem happened before this month started.

Search this and you will find the same instruction everywhere: run the Reconcile Discrepancy Report. That is good advice as far as it goes. What almost nobody tells you is that the report only sees two of the four things that cause this, and if yours is one of the other two you can stare at an empty report for an hour wondering what you're missing.

So start by working out which one you have.

The four causes, and how to tell them apart

1. The opening balance was wrong from the beginning

When an account is first set up — or first connected to a bank feed — QuickBooks records an opening balance as of the start date you chose. If that figure didn't match the real-world balance on the day before your start date, every reconciliation since has been built on a number that was never right.

How to spot it: the Discrepancy Report is empty, and the difference has been the same amount for as long as anyone can remember. Nothing was changed, so there is nothing for the report to list.

How to confirm it: find the account's opening balance entry and compare it to the bank statement for the day before you started tracking the account. Not the day of — the day before.

2. A reconciled transaction was changed afterwards

Someone edited the amount, changed the date, voided it, deleted it, or unticked its reconciled status. The reconciliation that included it was correct at the time; it stopped being correct later.

How to spot it: the Discrepancy Report lists it, with what changed and when. This is the cause the report was built for, and it is the most common one.

Where it usually comes from: bank-feed cleanup. Someone reviewing old transactions "tidies up" something that had already been reconciled, and QuickBooks doesn't stop them.

3. A previous reconciliation was forced

Somebody hit reconcile with a difference still showing, and QuickBooks posted an adjusting entry to make it close. The books balanced; the underlying problem didn't go anywhere.

How to spot it: look for a reconciliation adjustment entry, typically dated the last day of an old reconciliation period, often with no meaningful description. If you find one, the real discrepancy is whatever that entry was papering over.

4. You're reconciling against the wrong period

The least interesting cause and worth ruling out in thirty seconds: statement period doesn't match, or the account was reconciled twice for overlapping dates.

Fix each cause on its own terms

A wrong opening balance is corrected at the source, not at the reconciliation screen. Correct the opening balance entry to the real prior-day figure. Understand that this moves the offset — usually into Opening Balance Equity, which is a separate problem you then have to clear properly rather than leave sitting on the balance sheet.

A changed transaction is either restored to what it was, or accepted and re-reconciled. Once corrected, use a mini-reconciliation to repair the chain: set an off-cycle date between your last good reconciliation and the next, enter the ending balance from your last successful reconciliation, tick only the transactions you've just corrected, confirm the difference reads $0.00, and complete it. That re-establishes the beginning balance without disturbing periods that were already fine.

A forced adjustment needs a decision, not a fix. Find what it was hiding. If the original discrepancy can be identified, correct that and remove the adjustment. If it genuinely cannot be traced — which happens with old files — the honest move is to document it and leave it, rather than delete an entry and put the balance sheet out by the same amount.

A wrong period fixes itself once you notice.

What most guides never mention: what to do before you change anything

Two things, both of which cost more to skip than to do.

Check whether the period has been filed from. If correcting this changes a year your CPA has already used to prepare a return, that is a conversation to have before you touch it, not after. The bookkeeping fix and the tax consequence are separate questions, and only one of them is yours to decide alone.

Set a closing date once you're done. Most beginning-balance problems are caused by someone editing a period everyone assumed was finished. A closing date with a password makes that a deliberate act rather than an accident. It is the single highest-value five minutes in this entire process, and it prevents the recurrence rather than the symptom.

When this stops being a DIY job

Fix it yourself when the difference is small, recent, and the Discrepancy Report names the transaction. That is a genuinely quick job and you do not need anyone.

Get help when:

• The Discrepancy Report is empty and the difference is large — you are looking at an opening-balance problem, and correcting it wrongly moves the error onto your balance sheet instead of removing it.
• The discrepancy goes back more than a couple of periods, so the corrections compound.
• You find forced reconciliation adjustments — plural. One is an accident; several is a habit, and the file's balances have not been verified in a long time.
• More than one account is affected. At that point the reconciliation is a symptom, not the problem.
• Fixing it would restate a filed year.

That last group is what a QuickBooks reconciliation engagement is for: tracing the discrepancy to its origin rather than adjusting until the screen goes green. Where it turns out several accounts and several periods are involved, it is usually scoped as a cleanup instead — one-time, fixed fee, quoted in writing before any work starts.

TechBrot does the operational bookkeeping and hands your CPA a file they can file from. We don't file returns, and we'll tell you plainly if what you have is a ten-minute fix rather than an engagement.