n-How to Fix the Beginning Balance in QuickBooks Online (You Can't Just Type a New One In)
The Beginning Balance on the Reconcile screen isn't a field you edit directly; QuickBooks calculates it from your last completed reconciliation. If it looks wrong, something changed after that reconciliation, a transaction got edited, deleted, or added retroactively. Run the Reconciliation Discrepancy report to find exactly what changed, then fix that transaction instead of hunting for a way to override the number.
The full walkthrough
1. Confirm which "beginning balance" you actually mean. The reconciliation Beginning Balance (on the Reconcile screen) and an account's original opening balance (set when you first created the account) are two different things. This walkthrough covers the reconciliation one, since that's the one QuickBooks won't let you edit directly and the one that actually confuses people.
2. Run the Reconciliation Discrepancy report. Go to Reports, search for Reconciliation Discrepancy, and select the account. This lists exactly which previously reconciled transactions were changed, when, and by how much.
3. Open each flagged transaction. Compare it against your original bank or credit card statement for that period.
4. Decide whether it was a mistake or an intentional edit. If someone accidentally changed the amount, category, or date on an already-reconciled transaction, correct it back to match the original statement. If it was deleted outright, re-enter it exactly as it originally cleared.
5. Re-check the Beginning Balance. Once the underlying transaction is fixed, go back to Reconcile; the Beginning Balance recalculates automatically and should now match your statement's actual starting balance.
6. If you genuinely need to change an account's opening balance instead, open the account register, find the opening balance entry (usually dated as of your QuickBooks start date and posted to Opening Balance Equity), and edit the amount directly there.
Why this keeps happening in the first place
A wrong beginning balance is almost never QuickBooks malfunctioning. It's a side effect of someone editing, deleting, or re-categorizing a transaction weeks or months after it was already reconciled, often without realizing that transaction was part of a closed period.
The usual trigger is a bank feed correction, fixing a miscategorized charge, or cleaning up a duplicate, done without checking whether the transaction being touched had already been reconciled. One edit like that can throw off every reconciliation done since.
The real fix isn't a better way to find the discrepancy after the fact; it's not letting an already-reconciled transaction get touched without someone knowing. That's a guardrail, not a manual habit, and it's the kind of thing that's easy to enforce automatically but hard to enforce by memory.
What we've built on top of QuickBooks reconciliation integrity
Alerts when a reconciled transaction gets edited
The moment someone changes, deletes, or re-categorizes a transaction that's already part of a completed reconciliation, whoever owns the books gets notified immediately, instead of finding out weeks later when the balance doesn't match.
Automatic discrepancy tracing
When the beginning balance doesn't match, the exact transaction and edit responsible get surfaced automatically, skipping the manual report-reading and line-by-line comparison.
How often does your beginning balance come up wrong?
Those are two of the places this shows up. If this happens often enough to be a real pattern in your business, tell us and we'll tell you if it can be caught before it becomes a problem.
Tired of chasing down why your beginning balance is off?
Tell us how often it happens and what usually causes it, and we'll tell you whether it can be caught automatically before your next reconciliation. And if beginning balance discrepancies aren't your actual pain point, that's fine too; we automate whatever's manual in the business, any tool, any process.
Let's talk