When your beginning balance doesn’t match your bank statement, something in your previously reconciled transactions changed after the last time the account balanced. Accounting software doesn’t store the opening figure as a fixed number. It recalculates it every time you open the reconciliation screen by adding up every transaction you’ve ever marked cleared. Edit one of those entries, delete it, or accidentally flip its cleared status, and the beginning balance shifts retroactively. The problem almost always lives inside your own books, and you can usually trace it to one transaction or a small handful.
Why the Number Moved
Three things account for most mismatches.
The first is deletion. If a check or deposit that was already reconciled gets deleted from the register, its amount drops out of the running total the software uses to build your beginning balance. The second is editing. Changing the dollar amount on a cleared transaction rewrites the total the same way. The third is the cleared status itself. Clicking the cleared checkmark in the register removes that transaction from the reconciled pile, and the software treats it as though it had never balanced.
None of these changes announce themselves. A well-meaning employee fixing what looked like a typo on last month’s check can throw off this month’s reconciliation without knowing it.
Void, Don’t Delete
When a transaction from a prior period has to come off the books, void it instead of deleting it. Voiding sets the amount to zero but leaves the record in the register with its date, payee, and reference intact. Deleting removes it entirely, taking the audit trail with it. Most accounting professionals treat deletion of cleared transactions as a last resort precisely because it erases the evidence you’d need if a mismatch surfaces later.
Pull These Documents First
Before you go hunting, gather your reference points:
- The bank statement for the current period.
- The bank statement from the previous period.
- The reconciliation report from the last time the account balanced successfully.
That prior reconciliation report is your anchor. It shows which transactions were cleared and what ending balance was confirmed. If the ending balance on that report doesn’t match the beginning balance your software is showing now, the change happened after that reconciliation was completed, and everything you need to investigate falls into that window.
Most accounting software also produces a Reconciliation Discrepancy Report, usually found in the Reports menu under Banking or Accounting. It flags every transaction that was modified, deleted, or had its cleared status changed since the last reconciliation. If your software offers an audit trail, pull that too. The audit trail logs the user, the timestamp, and the nature of each change, which matters when more than one person touches the books.
While you have the register open, glance at any checks sitting on the outstanding list for months. Under the Uniform Commercial Code, a bank has no obligation to honor a check presented more than six months after it was written, though it may choose to.1Legal Information Institute (LII) / Cornell Law School. Uniform Commercial Code 4-404 – Bank Not Obliged to Pay Check More Than Six Months Old A stale check left on your outstanding list deducts money the bank will likely never pay out, which skews the reconciliation. Void it in your register and reissue if you still owe the payee.
Finding the Specific Error
Start with the Reconciliation Discrepancy Report if your software provides one. It usually hands you a short list, and the culprit is often obvious at a glance. If the report isn’t available in your software version, you’ll compare the audit trail against last month’s bank statement line by line.
The dollar amount of the mismatch is itself a clue. Search the register for that exact figure.
- If the discrepancy equals the value of a specific check or deposit, someone probably deleted or uncleared that transaction.
- If it’s exactly double a transaction amount, a duplicate entry was likely cleared twice.
- If the discrepancy is divisible by nine, you’re almost certainly looking at a transposition error where two digits were swapped. The math behind digit transpositions always produces a multiple of nine, so this quick test can save hours.
When none of those shortcuts work, narrow by date. Identify the last period where everything balanced and work forward. Sort the register by cleared date and compare each entry against the bank statement. It’s tedious, but it’s reliable.
Fixing It
The correction depends on what caused the problem.
If a reconciled transaction was deleted, re-enter it with the original date, payee, account, and amount, then mark it as cleared in the register. If a dollar amount was changed, edit it back to the figure on the bank statement. If a transaction was accidentally uncleared, click its status back to reconciled. In each case, the beginning balance should snap back into place once you save.
Undoing the Last Reconciliation
Sometimes the cleanest path is to undo the most recent reconciliation entirely and redo it. Many accounting platforms have an undo reconciliation feature that strips the cleared status from every transaction in a specific period so you can start over. In QuickBooks Online, it lives on the reconciliation history screen. In desktop versions, you may need to uncheck transactions manually. Undoing a reconciliation doesn’t delete anything; it just resets the cleared markers. If more than one period is affected, work backward from the most recent.
A Journal Entry as a Last Resort
When the discrepancy is small, the original documentation is lost, and the cost of continued investigation clearly exceeds the amount in question, a journal entry can force the balance to match. The entry typically debits or credits a miscellaneous expense or adjustment account and offsets against the bank account.
Do not park these adjustments in Opening Balance Equity. That account is a temporary holding account created by the software during initial setup and should have a zero balance once the books are established. A lingering balance there signals unresolved setup errors or misposted adjustments and makes your balance sheet unreliable.
Document the reason in the journal entry memo field. The IRS requires every taxpayer to keep records sufficient to establish the amounts reported on a return.2Office of the Law Revision Counsel. 26 US Code 6001 – Notice or Regulations Requiring Records, Statements, and Special Returns Sloppy recordkeeping that leads to underreported income can trigger an accuracy-related penalty equal to 20% of the underpayment when the IRS determines the taxpayer was negligent or disregarded its rules.3Office of the Law Revision Counsel. 26 US Code 6662 – Imposition of Accuracy-Related Penalty on Underpayments A memo showing you identified and addressed the problem is worth writing.
When the Bank Made the Mistake
Most beginning balance mismatches originate in your own records, but banks do make mistakes. If you’ve exhausted the leads in your register, compare your records against the bank statement entry by entry and look for a transaction the bank posted at the wrong amount, a duplicated deposit, or someone else’s transaction that landed on your account.
On a personal account, federal law gives you 60 days from the date the statement was sent to notify the bank and trigger its error resolution process.4Consumer Financial Protection Bureau. Regulation E 1005.11 – Procedures for Resolving Errors That window applies specifically to consumer accounts used for personal, family, or household purposes.5eCFR. 12 CFR Part 205 – Electronic Fund Transfers Regulation E
Business checking accounts are not covered by the same federal regulation. Businesses fall under the Uniform Commercial Code, which requires you to examine your statements with reasonable promptness and report unauthorized transactions. The outer deadline under the UCC is generally one year from when the statement was made available, but waiting that long sharply reduces your ability to recover funds. Review business statements as soon as they arrive.
Keeping This From Happening Again
The single most effective safeguard is setting a closing date password in your accounting software. The feature locks all transactions dated on or before a specified date, so anyone trying to edit, delete, or add a transaction in a closed period has to enter a password. Without it, one accidental change to a reconciled entry can go unnoticed until the next month’s closing.
A few other habits keep beginning balances stable:
- Reconcile monthly, without exception. The longer you wait between reconciliations, the harder it is to trace a discrepancy.
- Void rather than delete, and make that an office rule so everyone follows it.
- Separate reconciliation duties from transaction entry. If the person who writes checks and records deposits is also the one reconciling the statement, both errors and fraud become harder to catch.
- Save the reconciliation report the moment an account balances. When a future mismatch appears, that snapshot is what tells you exactly what changed.