Why Your Bank Reconciliation Beginning Balance Is Wrong
When the opening balance in a reconciliation is off, the problem usually started earlier. That small difference can stop your close, throw off reports, and eat up an afternoon if you start guessing.
Why does the number change if last month already tied out? Because one transaction, one edit, or one missed statement item can carry forward into the next month. The good news is that you can trace it in a clear order without wrecking the books.
Key Takeaways
- A wrong opening balance usually points to a problem in a prior period, not the current month.
- The fastest way to find it is to compare the prior reconciliation, the bank statement, and the transaction history.
- Edited, deleted, or duplicated transactions are common causes, especially when someone changed a closed period.
- Avoid forcing adjustments unless you have exhausted the clean fixes first and kept the audit trail intact.
- A short checklist can save time before you hand the issue to your accountant or bookkeeper.
Start with the last clean reconciliation
A bank reconciliation beginning balance should match the ending balance from the last completed reconciliation. If it doesn't, the current month is only showing the symptom.
That is why the first step is to step back, not forward. Pull the prior reconciliation report, the bank statement for that same period, and the current month statement side by side. If the ending balance from the prior month does not agree with the bank statement, the issue started there.
A repeatable process helps here. A QuickBooks Online bank reconciliation checklist can be useful even if you use another accounting system, because the logic is the same: confirm the statement, match the ending balance, and then roll into the next month.
Look for the first period where the numbers stop matching. Do not assume the current month created the error. In many cases, the opening balance only exposes an old mistake that sat unnoticed until the next reconciliation.
Common reasons the opening balance is off
Several issues show up again and again. Some are simple. Some are messy because they involve a prior closed period.
| Cause | What you might see | What to check |
|---|---|---|
| Prior month was not truly reconciled | The difference repeats in the next month | Review the prior reconciliation report and ending balance |
| A cleared transaction was edited or deleted | The opening balance changed after a close | Check the audit trail or change history |
| Wrong statement date or ending balance | The difference appears in one month only | Confirm the bank statement cutoff and totals |
| Duplicate or missing transaction | Bank and books disagree by a specific amount | Search for duplicate deposits, checks, fees, or transfers |
| Merchant payout net of fees | Deposit amount is smaller than gross sales | Compare processor reports and fee deductions |
Merchant deposits can create extra confusion. If your bank shows one net deposit and your books show several gross sales entries, the gap can look like a reconciliation error when it is really a payout issue. In those cases, tracking credit card processing fees helps you match the bank deposit to the processor report more accurately.
If the beginning balance is wrong, do not force the reconcile screen to fit. Find the first bad number first.
Trace the mismatch in a fixed order
Once you know the issue probably started earlier, follow the same order every time. That keeps you from chasing random transactions.
- Pull the prior reconciliation report.
Confirm the ending balance, the cleared items, and the date the period was closed. If that report is missing, ask for it before anything else. - Compare the bank statement to the reconciled month.
Match the statement ending date and ending balance exactly. A one-day cutoff error can make the whole month look wrong. - Review the audit trail or change log.
Look for edits, deletions, voids, reclassifications, or new entries in a closed period. A single changed transaction can shift the opening balance. - Search for the amount of the difference.
If the mismatch is $87.44, look for a transaction for that exact amount, or a combination that adds up to it. Small exact amounts often point to bank fees, refunds, or duplicated entries. - Test transfers and uncleared items.
Transfers between accounts can appear as income or expense if they were entered wrong. Outstanding checks, deposits in transit, and old uncleared items also cause trouble.
A bookkeeping monthly close checklist can help keep this review orderly, especially if you reconcile several accounts each month. A bookkeeping monthly close checklist keeps the focus on the accounts that should already be tied out before reports are final.
Fix the source without damaging the record
The cleanest fix is the one that preserves history. If the previous period is still open, correct the original transaction, then rerun the reconciliation. If the period is closed, stop and document the issue before touching anything.
For open periods, you can usually correct the entry itself. That might mean entering a missing deposit, removing a duplicate, fixing the date on a transfer, or posting a bank fee that was never recorded. Once the source is corrected, the opening balance should fall back in line.
For closed periods, the approach needs more care. A locked month should not be edited casually because the change affects reports, taxes, and any review trail. If a correction is necessary, keep notes, save supporting documents, and use the accounting method your accountant prefers.
Good fixes usually fall into these categories:
- Add a missing transaction with the original date and support.
- Delete or void a duplicate only if the system and review process allow it.
- Correct a transfer so both sides of the movement match.
- Record bank fees, interest, or merchant charges in the right period.
- Reopen and reclose a period only when you have clear approval.
A forced adjustment can make the reconciliation look clean while leaving the books wrong. That trades a short-term fix for a longer problem.
If your month-end process is loose, the same mismatch can keep returning. Tightening the close helps more than one-off repairs. A bookkeeping monthly close checklist is a good way to make sure reconciliations happen before reports are handed off or taxes are prepared.
What to gather before you call your accountant or bookkeeper
You can save time by pulling the right documents first. That also makes it easier for someone else to spot the break in the chain.
- The bank statement for the prior month and the current month.
- The prior reconciliation report, including ending balance and cleared items.
- A transaction detail report for the account that is off.
- Any notes about edits, deletions, voids, or manual journal entries.
- Merchant payout reports if card sales or processor fees are involved.
- Records for transfers between accounts, especially if you move money often.
Once you have those items, describe the problem in one sentence. For example, "The prior month ending balance does not match the bank statement, and the opening balance changed after a transfer was edited." That kind of summary helps a bookkeeper move straight to the source.
If you manage your own books, keep these documents together each month. If someone else does the bookkeeping, send the full packet before asking for a correction. The more complete the record, the less likely the fix will disturb a clean period.
Conclusion
A wrong beginning balance is usually a clue, not a mystery. It often points to an edited prior period, a missing transaction, or a statement mismatch that carried forward.
The best approach is simple, compare the prior reconciliation, the bank statement, and the audit trail before making changes. Protect the audit trail , fix the source, and avoid forcing the screen to balance unless there is no other clean option.
