# Beginning Balance Does Not Match Bank Statement? Fix It

- Author: PreciseBankFlow (https://www.precisebankflow.com)
- Published: 2026-02-11
- Updated: 2026-02-11
- Category: Finding reconciliation errors
- Canonical: https://www.precisebankflow.com/blog/beginning-balance-does-not-match-bank-statement

> Beginning balance does not match the bank statement? Find the changed prior item, compare reconciliation reports and restore the balance correctly.
When the beginning balance does not match the bank statement, a transaction that was already reconciled has almost always changed since the last sign-off. Compare last month's saved reconciliation report with the ledger as it stands now, find the line that was edited, deleted, voided or redated, and put it back before you reconcile the new month.

## Why doesn't the beginning balance match the bank statement?

The beginning balance of a reconciliation is the total of every transaction already marked cleared, and it should equal the opening balance printed on the new statement. It stops matching when something inside that cleared history changes. The statement is fixed once printed, so the moving side is nearly always the books.

The usual causes, roughly in the order you meet them:

- **A reconciled transaction was edited.** Someone changed an amount, often while fixing a different problem, and the cleared total moved by the difference.
- **A reconciled transaction was deleted.** Duplicate clean-ups are a common source. If both copies were marked cleared last month, deleting one is right, but last month's reconciliation was wrong.
- **A reconciled transaction was voided.** A void keeps the line but zeroes the amount.
- **A reconciled transaction was redated** into an earlier or later period, so it leaves the cleared total for the month you are checking.
- **A cleared mark was removed or added by hand** in the register, outside a reconciliation.
- **The wrong statement is open.** The new statement's opening balance belongs to a different account or a different cycle.

The last cause is the quickest to rule out. Check the account number and statement period, and confirm the new opening balance equals the closing balance on the previous statement. If the bank's own statements do not carry forward, ask the bank. Every other cause sits in your records.

## Comparing last month's reconciliation report with the ledger today

The fastest way to see what changed is to put two lists side by side: the cleared items on last month's saved reconciliation report, and the same account's cleared items in the ledger as of today, filtered to the same end date. Any line that differs between them is a candidate.

Most accounting systems save a report when you finish a reconciliation. Use that saved copy, not a report regenerated today, because a regenerated report shows the changed data and hides the change. If you only have a regenerated report, a PDF exported at the time is the next best thing.

Sort both lists by amount, then by date, and compare. A spreadsheet with the two lists in adjacent columns and a difference column makes the change easy to see.

The figures in this example are illustrations. A firm finished its March reconciliation with cleared items totalling $61,204.37, which equalled the March statement's closing balance. In April, the reconciliation opens at $60,754.37, $450.00 short.

| Item | Saved March report | Ledger today, to March 31 | Difference |
| --- | --- | --- | --- |
| Deposit, March 4 | $8,300.00 | $8,300.00 | $0.00 |
| Check 5081, March 9 | ($1,120.00) | ($1,120.00) | $0.00 |
| Deposit, March 15 | $450.00 | (not present) | ($450.00) |
| Check 5090, March 22 | ($2,975.50) | ($2,975.50) | $0.00 |
| Cleared total | $61,204.37 | $60,754.37 | ($450.00) |

The March 15 deposit is missing from the ledger. That is the line to research.

## Finding the changed prior item behind the opening gap

A changed prior item is a transaction from a reconciled period that no longer looks the way it did at sign-off. To find it, use the size of the gap, the audit trail, and the comparison above. The gap's amount usually tells you what kind of change happened before you know which line.

Read the gap like this:

- **The gap equals a whole transaction.** A line was deleted, voided, redated out of the period or unmarked as cleared.
- **The gap is the difference between two plausible amounts.** A line was edited.
- **The gap equals a line that appears twice in last month's cleared list.** A duplicate was cleared and one copy has since been removed.

Then open the audit trail or change log for the account and filter it to changes made after last month's reconciliation date that touch transactions dated on or before last month's end. Most systems record who changed a line, when and from what. That is also where you see whether the change was intentional.

In the example, the log shows the March 15 deposit was deleted on April 6 by a staff member who believed it was recorded twice. A second $450.00 deposit on March 16 exists in the ledger. Two outcomes are possible. If the bank shows one deposit of $450.00, March was wrong: both copies were marked cleared, and the deletion was correct. If the bank shows two deposits, the deletion was the error. The method for telling a duplicate from a real second deposit is in [finding and reversing a deposit recorded twice](/blog/deposit-recorded-twice).

Redating needs its own check. A line moved from March 30 to April 2 leaves the March cleared total but still exists, so a search by amount finds it in the wrong month. Errors of that kind, and how to tell them from timing items, are covered in [fixing a transaction recorded in the wrong period](/blog/transaction-recorded-in-wrong-period).

Old outstanding checks are a quieter source. If someone voids a check that sat outstanding for a year and dates the void back in the month the check was written, the cleared total does not move, because the check never cleared. The book balance of a closed month does move, so last month's saved report no longer agrees with the ledger. Stale checks have their own rules, because the money may have to go to the state rather than back into cash; see [when uncashed checks become unclaimed property](/blog/uncashed-checks-unclaimed-property).

## Restoring the beginning balance without a plug

Restoring the beginning balance means putting the reconciled history back as it was at sign-off, so the cleared total equals the statement again. Undo the unintended change, or, when the change was right, record it in the current period with a note instead of rewriting the closed month.

Follow these steps:

1. **Confirm the saved figure.** Last month's report should show a cleared total equal to last month's statement closing balance. If it does not, last month was never balanced and you have a different problem.
2. **List every changed line** from the comparison and the audit trail, with the amount each one moved.
3. **Sum the changes.** They should add up to the opening gap exactly. If they do not, keep looking before you fix anything.
4. **For each unintended change, restore the original.** Recreate the deleted line, reverse the void, put back the original amount or date, and mark it cleared again in the same period it cleared before.
5. **For each intended change, book it in the current month.** If the deleted deposit really was a duplicate, last month's reconciliation counted it twice. Record the correction in the open period with a memo, and show it as a reconciling item so the new reconciliation explains it.
6. **Reopen the new reconciliation** and confirm the beginning balance now equals the statement's opening balance.
7. **Write a short note** on the current reconciliation: what changed, who changed it, when and how it was fixed.

Step 5 deserves care. The goal is that last month's signed report still agrees with the books as they were at sign-off, and that the books today agree with the bank. When those two goals conflict, the current-period correction is what reconciles them. The full decision about adjusting now versus restating is a separate question for material amounts.

### Stopping the gap from coming back

Close each reconciled period in the accounting system with a lock date or closing password if it has one. Agree that no one edits a cleared line without first saying so to whoever reconciles. Review the change log once a month before you start reconciling, so changes are found while the person who made them still remembers why.

## What if the beginning balance never matched at all?

A beginning balance that never matched the bank statement usually comes from the first reconciliation, not from a later change. The opening entry was set from the wrong date, from a balance that ignored outstanding items, or from someone's estimate. Every reconciliation since has carried the same gap.

You see this pattern when the gap is constant across months and no audit trail entry explains it. It is common with inherited books, with a new accounting system loaded from a balance instead of a history, and with accounts that someone reconciled only by forcing the difference to zero.

To fix it, go back to the first statement the books cover. Take that statement's opening balance. Subtract checks written before that date that cleared after it, and add deposits made before that date that cleared after it. The result is what the books should have opened with. Compare it with the opening entry actually booked. The difference should equal the recurring gap.

Correct the opening entry in the current period, usually against owner's equity or retained earnings, with an explanation and approval. If the account belongs to a client, tell the client and anyone who relied on the earlier figures, because the earlier balance sheets were off by the same amount.

## Mistake: editing the opening balance to equal the statement

Editing the opening balance to equal the statement is the most tempting fix and the worst one. Changing the figure in a reconciliation screen, or posting an entry dated in a closed month, makes this month look right while the real change stays hidden in the history.

The edited figure hides three things. It hides who changed the reconciled line, which matters if the change was not innocent. It hides whether last month's reconciliation was right, which matters to anyone who relied on it. And it hides the amount itself, so if a second change happens later, the two combine and the next person has no trail to follow.

An auditor or reviewer who sees an opening figure that disagrees with the last signed report will ask for the explanation anyway. A written note with the restored line is a two-minute read. An overwritten balance can take hours to unpick.

PreciseBankFlow checks that each statement's opening balance plus deposits less withdrawals equals its printed closing balance, and marks the statement out of balance when it does not, so the bank side of the comparison is proven before you start on the books. You can read more on the [PreciseBankFlow homepage](/).