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.
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.
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.
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.
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.
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.
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 →Almost always because a transaction that was part of a previous completed reconciliation got edited, deleted, or added after the fact. The Reconciliation Discrepancy report under Reports will show you exactly which one and when it changed.
When you create the account under Chart of Accounts, there's a field for the balance as of a specific date. QuickBooks posts it to Opening Balance Equity automatically. If you need to add or correct it after the account already exists, edit that entry directly in the account's register.
No, and you shouldn't try to force it. If you're confident your books are right and the statement is wrong, resolve that with your bank directly rather than overriding the number in QuickBooks; the Beginning Balance exists specifically so it can't be edited around a real discrepancy.
Same underlying cause and same first step: run the Reconciliation Discrepancy report under Reports. Desktop surfaces the same information, just through its own report list rather than Online's search bar.