Opening Balance Doesn't Match Bank Statement? Fix It

TL;DR: When the opening balance in your books doesn't match the bank statement, the cause is almost always in an earlier period: a wrong starting balance when the account was set up, a change to a transaction that was already reconciled, a deleted or duplicated transaction, or an incomplete import. Find the first statement date where books and bank disagree, look at what changed in that period, and correct the underlying transaction rather than forcing the balance with an adjustment. Talk to your accountant before changing anything in a closed or filed period.

Few things are more frustrating than starting a reconciliation and finding it's wrong before you've ticked a single transaction. The statement says the month opened at 4,210.55; your software says 3,985.30. Nothing you do this month will fix that, because the problem isn't in this month. It happens to experienced bookkeepers as often as beginners, typically when an account changes hands, someone tidies up old transactions, or a bank feed and manual imports overlap.

This guide explains where opening balance differences come from and a methodical way to find and fix them, in accounting software or a spreadsheet.

What "opening balance" means here

There are two different things people call the opening balance:

1. The account's starting balance: the balance you entered when you first set up the account in your software, as at a particular date.
2. The statement's opening balance: the balance at the start of the statement period you're reconciling, which should equal the previous statement's closing balance.

In accounting software, the reconciliation screen usually shows a "beginning balance" calculated from previously reconciled transactions. If that doesn't equal the statement's opening balance, something in the reconciled history has changed or was wrong to begin with.

The usual causes

Cause	What it looks like
Wrong starting balance at setup	Difference present from the very first reconciliation
A reconciled transaction was edited	Difference appears suddenly, after a past period was fine
A reconciled transaction was deleted	Same: sudden difference equal to the deleted amount
A transaction was un-reconciled	Difference equal to that transaction
Duplicate imported into a reconciled period	Difference equal to the duplicated amount
Missing statement or partial import	Difference from the point where the gap starts
Wrong statement used last time	Difference equal to the gap between two statements' balances
Opening balance entered with wrong sign	Difference equal to twice the balance

The pattern of the difference (when it appeared, and how big it is) usually points at the cause. Write down both facts before you start digging; they narrow the search more than any report.

Step 1: Confirm the bank side is right

Before blaming the books, make sure the statements are complete and chain correctly. Every statement's opening balance should equal the previous statement's closing balance.

Statement	Opening	Closing
Jan	3,120.00	3,410.20
Feb	3,410.20	2,980.75
Mar	2,980.75	4,210.55
Apr	4,210.55	...

If a statement is missing, or a statement's transactions don't add up to its change in balance, sort that out first. Converting statements to a spreadsheet makes this quick: SheetStatement checks each statement against its own opening and closing balances.

Step 2: Find the first date where books and bank disagree

Work backwards. For each past statement date, compare the bank's closing balance with your books' balance as at that date (from a balance sheet or an account register report dated on the statement's closing date).

Date	Bank	Books	Difference
Jan 31	3,410.20	3,410.20	0.00
Feb 28	2,980.75	2,980.75	0.00
Mar 31	4,210.55	3,985.30	225.25

Note the books balance here is the full balance, including uncleared items. To compare like with like, adjust for outstanding items at each date, or use the software's reconciliation reports, which show the reconciled balance. Our guide to outstanding checks and deposits in transit explains the adjustment.

The first period with a difference is where you look. In this example, something in March.

Step 3: Look at what changed in that period

In accounting software:

• QuickBooks Online has reconciliation reports for past reconciliations, and some editions highlight changes made to reconciled transactions since the reconciliation was completed. The audit log shows edits and deletions, with who made them and when.
• Xero has a bank reconciliation summary report and an account transactions view, and its history and notes on transactions show changes.
• Other software typically has an audit trail or change log.

Look for transactions in the period that were edited, deleted, added after reconciliation, or un-reconciled. Compare the amount of each change with the difference.

In a spreadsheet, compare the transactions in your books for the period with the statement line by line. Matching formulas, as in our Google Sheets reconciliation guide, find the odd one out quickly.

Step 4: Use the size of the difference

The amount is a clue:

• Equals a single transaction in the period: that transaction was deleted, edited or duplicated.
• Twice a transaction: a transaction was entered with the wrong sign.
• Divisible by 9: a transposition (for example 52.00 entered as 25.00 is a difference of 27).
• Equals the starting balance, or twice it: the starting balance was omitted or entered with the wrong sign.
• A round number: possibly a manual "adjustment" someone made to force an earlier reconciliation.

That last one is common. If an earlier reconciliation didn't balance and someone added an adjustment to make it, the problem is hidden rather than fixed, and it will surface again.

Step 5: Fix the underlying transaction

Once you find the cause, fix it at the source:

• Edited transaction: restore the original amount and date, matching the statement.
• Deleted transaction: re-enter it exactly as it appears on the statement and mark it reconciled in the right period, if your software allows.
• Duplicate: delete the extra copy. Our article on QuickBooks duplicate transactions after import covers how to find them.
• Wrong starting balance: correct the opening balance entry for the account. In software, this is often a journal entry or an opening balance transaction dated the day before your start date.
• Missing transactions: import or enter the missing ones.

Whatever the fix, add a note to the transaction or your reconciliation file explaining what you changed and why, so the next person doesn't undo it.

Avoid the temptation to post a balancing adjustment in the current month. It makes this month's reconciliation look right while leaving every report for the earlier period wrong.

Step 6: Re-check and, if needed, redo reconciliations

After fixing, the beginning balance on your next reconciliation should match the statement. If several periods were affected, you may need to undo and redo the reconciliations from the first bad period. Software that supports undoing reconciliations usually requires administrator or accountant access; check before you start.

Opening balances in a spreadsheet

If you keep your books in Excel or Google Sheets, the same logic applies, with fewer tools to help. A running balance column is your best friend:

1. Sort your book transactions by date.
2. Start with the opening balance in the first row.
3. Add a running balance column: =previous balance + amount.
4. Next to it, bring in the bank's running balance for the same date from the converted statement.
5. Add a difference column.

Scroll down the difference column. While the books and bank agree (allowing for outstanding items), it stays at zero or shows only the known timing differences. The row where it first jumps is where the problem started. In a sheet with thousands of rows, a formula like =MATCH(TRUE, INDEX(ABS(D2:D5000)>0.005,0), 0) finds the first non-zero row for you, or use a filter on the difference column.

The same approach works for checking accounting software: export the account register to a spreadsheet and compare it with the converted statements.

When the account was set up mid-period

A frequent cause of setup errors is choosing a start date in the middle of a statement period. If you started in your software on March 15 but your statement runs March 1 to 31, the correct opening balance is the bank balance at the end of March 14, which isn't printed on any statement as a headline figure. People often enter the March 1 opening balance or the March 31 closing balance instead, and every reconciliation after that is off.

Fix it by working out the true balance at the start date from the statement's running balance (or by adding up transactions from the statement's opening balance to the start date), and correct the opening balance entry. Then make sure transactions before the start date aren't also in the books, or they'll be counted twice.

Starting at the beginning of a statement period avoids the problem entirely, and we recommend it whenever you have the choice.

Opening balances for credit cards

Credit card accounts have the same issue with an extra twist: the sign. The opening balance on a card is an amount owed, so in most software it's entered as a liability. Entering it as a positive asset, or as a negative number in the wrong field, gives a difference of exactly twice the balance. If your card reconciliation is out by twice the opening balance, check that first. Our credit card reconciliation guide covers card-specific signs.

Uncleared items at the start date

If you start an account in your software at a date when there were checks outstanding or deposits in transit, the opening balance needs care. Your book balance at the start date includes those items; the bank balance doesn't. Either enter the bank balance as the opening balance and then enter the outstanding items individually (so they can be cleared when they appear), or enter the book balance and mark the opening entry appropriately. Software handles this differently, so follow its guidance or ask your accountant. Getting it wrong is a common source of a small, stubborn difference in the first few reconciliations.

Closed and filed periods: be careful

If the period with the problem has been closed (many tools let you lock periods) or used for a tax return, VAT return or financial statements, changing it can affect figures already reported. Before you change anything:

1. Talk to your accountant.
2. Decide together whether to correct the original period or make a correcting entry in the current period with a clear explanation.
3. Document what changed and why.

This isn't about rules we can state generally; it depends on your circumstances and jurisdiction. The point is not to change filed numbers silently.

A worked example

A bookkeeper takes over a small retail client in Xero. The April reconciliation won't start: the statement opens at 4,210.55, but the reconciled balance in Xero is 3,985.30. Difference: 225.25.

1. Statements chain correctly from January to April.
2. Comparing balances by statement date shows January and February agree; March is out by 225.25.
3. Searching March's current transactions for 225.25 and 450.50 finds nothing that explains it, which suggests the transaction is no longer there.
4. Looking at the account history, she finds a 225.25 card settlement deposit in March that was deleted in early April, after March had been reconciled. The previous bookkeeper had thought it was a duplicate.
5. She checks the statement: the deposit is real and appears once. She restores it, matched to the statement line.
6. The reconciled balance becomes 4,210.55, matching the April statement's opening balance.

The size of the difference pointed at a single transaction, and the change history showed which one.

Preventing it

• Lock reconciled periods where your software allows it, so reconciled transactions can't be edited casually.
• Limit who can delete transactions, or at least review the audit log monthly.
• Never force a reconciliation with an unexplained adjustment.
• Reconcile every month, promptly. Problems are much easier to find when they're a month old.
• Import carefully: check date ranges to avoid overlaps, especially when combining bank feeds and imported statements. See our guide to importing bank statements into QuickBooks Online.
• Keep the statements for every period, so you can always check the bank side.

More edge cases

Two bookkeepers, two start dates. When a file changes hands, the new bookkeeper sometimes enters a fresh opening balance at their own start date, on top of the existing history. The account now has two opening balances. Look for more than one opening balance entry in the account register, and remove the one that doesn't belong, with your accountant's agreement if the period is closed.

Bank feed with a historical import. Some bank feeds pull in a set number of days of history when first connected. If you'd already entered those weeks manually, they're now duplicated, and the reconciled balance drifts. Compare the first feed date with your last manual entry.

Currency rounding. For foreign currency accounts converted into a home currency for reporting, small differences can appear from exchange rate revaluation. Reconcile in the account's own currency; revaluation differences belong in an exchange gain or loss account, not the bank reconciliation.

A closed account that still shows a balance. If an account was closed with a final transfer out, but the books show a small remaining balance, it's usually a final fee or interest line that was never recorded. Check the final statement.

A mini decision tree

1. Is the difference present from the first reconciliation? → Check the starting balance and start date.
2. Did it appear suddenly? → Check the audit log for edits, deletions and un-reconciled items in the first bad period.
3. Is it equal to a transaction? → That transaction was deleted, duplicated or edited.
4. Is it twice a transaction? → Wrong sign.
5. Divisible by 9? → Transposition.
6. Equal to a whole statement's movement? → A statement was imported twice or not at all.

A second worked example

A bookkeeper finds a difference of exactly 3,912.66 on a QuickBooks account. That's the total movement of the June statement. The audit log shows the June CSV was imported twice, on two different days, by two people. Excluding one copy of the batch removes the difference. The fix took five minutes once the size of the difference pointed at a whole statement.

FAQ

Why doesn't my opening balance match my bank statement?

Usually because something changed in an earlier period: a reconciled transaction was edited, deleted or duplicated, the account's starting balance was wrong, or a statement or import was incomplete.

How do I find which transaction caused the difference?

Find the first statement date where the books and bank disagree, then look for a transaction in that period whose amount equals, or is half of, the difference. Use your software's audit log or change history.

Can I just enter an adjustment to make it match?

It's not a good idea. An unexplained adjustment hides the real problem and leaves earlier reports wrong. Find and fix the underlying transaction, or agree a documented correction with your accountant.

What if the starting balance was wrong when the account was set up?

Correct the opening balance entry, dated as of the account's start date. If that period has been reported or filed, talk to your accountant first.

Do I need to redo past reconciliations?

Sometimes. If corrections affect several reconciled periods, you may need to undo and redo them from the first affected period, which often requires admin or accountant access.

How can I prevent opening balance differences?

Reconcile monthly, lock reconciled periods, restrict deletions, avoid forcing reconciliations, and check import date ranges.