The opening balance for a first bank reconciliation is the closing balance of the statement just before your start date, adjusted for checks and deposits already in the books but not yet cleared. Pick the statement that ends the day before your books start, list those open items, and keep the next statement to prove each one cleared.
Which statement should a first bank reconciliation start from?
A first bank reconciliation should start from the statement whose closing date matches the day before your ledger begins, or the last day of a closed period. If your books start on 1 April, the 31 March statement is the anchor. Its closing balance is the bank's opening figure for your first reconciliation.
The choice matters because every later reconciliation inherits it. A starting point that is a few days off, such as a statement ending 28 March for books starting 1 April, leaves three days of activity belonging to neither period. Those days surface later as an unexplained difference with no obvious cause.
Three situations decide the start date in practice:
- New business, new account. The first statement opens at zero, or at the opening deposit. The opening balance is that deposit, and there are no prior open items.
- Existing business, new accounting system. Start at a month-end or year-end when the old system's figures are final. The statement for that month-end is the anchor.
- Existing books that were never reconciled. Start at the earliest month-end you can support with both a statement and a ledger, then roll forward. If that is more than a year back, a cut-off at the last tax year-end is often a fair compromise.
If statements and the ledger use different cycle dates, for example the bank closes on the 20th, pick the ledger date and get a bank balance as of that date from online history. Avoid mixing cycle-end and month-end figures in the opening calculation.
Building the opening book balance from the bank statement and open items
The opening book balance equals the statement closing balance, plus deposits recorded before the start date that the bank had not yet posted, less checks written before the start date that had not yet cleared. That is the same calculation as any reconciliation, run once to set the starting figure instead of to check it.
Here is a worked example. The business, named Oakline Landscaping for illustration, and every figure in it are invented.
| Opening calculation as of 31 March | Amount |
|---|---|
| Closing balance per 31 March statement | 18,420.00 |
| Add: deposit of 31 March, posted by the bank 1 April | 2,900.00 |
| Less: check 1021, dated 27 March | (640.00) |
| Less: check 1024, dated 30 March | (1,215.50) |
| Less: check 1025, dated 31 March | (310.00) |
| Opening book balance, 1 April | 19,154.50 |
The arithmetic: 18,420.00 plus 2,900.00 is 21,320.00. The three checks total 2,165.50, and 21,320.00 less 2,165.50 is 19,154.50.
If Oakline is setting up books for the first time, 19,154.50 is the figure entered as opening cash. If Oakline already has a ledger, 19,154.50 is what the ledger should show at 31 March, and any difference must be explained before the first monthly reconciliation starts.
This calculation is the adjusted balance approach working backwards. Bank reconciliation methods compared explains why proving both sides, rather than only one, is the safer habit for every month after this one.
Old outstanding checks and deposits at the opening date
Open items at the opening date are checks and deposits recorded before the start that cleared afterwards. Find them by reading the first one or two statements after the start date and picking out every item dated before it. Each one belongs on the opening list, with its date, number, payee and amount.
The statements after the start date are the most reliable source, because they show what actually cleared. A checkbook register or the old system's outstanding list is useful as a cross-check, but neither proves that a check was really outstanding rather than void.
Watch for three kinds of old item:
- Checks that clear months later. A check written in March can clear in July. If the opening list was built only from April's statement, it will miss it, and July's reconciliation will show a mystery debit. Scan at least two statements after the start date, and three if checks are slow to be cashed.
- Checks that never clear. A check on the old outstanding list that has not cleared in six months may be lost, void or never sent. Leave it on the list with a note, and follow it up. Old uncashed checks can eventually become reportable to the state, so do not simply drop them; uncashed checks as unclaimed property explains when that point arrives.
- Deposits that do not appear. A deposit recorded before the start date that never shows on a statement is a warning, not a timing item. Find the deposit slip or the bank record before accepting it as a reconciling item.
A simple sheet with one row per open item, a cleared date column and a reference to the statement page is enough to manage this. A bank reconciliation template for Google Sheets gives a layout that works for the opening list as well as for monthly use.
How do you prove a first reconciliation opening balance to a reviewer?
A reviewer accepts an opening balance when every number in the calculation traces to a document. The statement closing balance traces to the statement. Each open item traces to the ledger entry that recorded it and to the later statement line where it cleared. With those three links in place, the opening figure is a fact, not an estimate.
Assemble the support in one file, in this order:
- The anchor statement, with the closing balance highlighted.
- The opening calculation, laid out like the table above, signed and dated by the preparer.
- The ledger detail for the open items, showing each was recorded before the start date.
- The clearing statements, with each open item marked where it cleared, and the date.
- A note on anything still open, with the reason and the next action.
- Reviewer sign-off, by someone who did not build the list.
The reviewer's tests are straightforward. Pick two open checks and trace each from ledger to clearing statement. Confirm the anchor statement foots. Scan the first clearing statement for any check dated before the start that is not on the list. If the list was built in a spreadsheet, a lookup against the clearing statements can confirm every item; how to do bank reconciliation in Excel with formulas shows the matching formulas.
Unexplained opening differences and the opening balance equity trap
An unexplained difference between the derived opening figure and the ledger should be investigated before it is posted anywhere. If it cannot be explained, it can be recorded to an equity or suspense account with written approval, a stated amount limit and a date for review. It should never be left to sit in opening balance equity without a note.
Many accounting systems post any opening figure that does not balance to an account named opening balance equity, or similar. The account is useful at setup. It becomes a trap when it quietly absorbs a difference that was really an error: unrecorded fees, a duplicate deposit, or a payment booked to the wrong account.
In the Oakline example, suppose the old ledger showed 19,388.20 at 31 March, against the derived 19,154.50. The gap is 233.70, with the ledger higher. Work through it before posting:
- Three monthly fees of 25.00 for January to March were never recorded: 75.00.
- A customer payment of 158.70 was entered twice in March.
- 75.00 plus 158.70 is 233.70. The difference is fully explained.
Both items get correcting entries in the old ledger, and opening balance equity takes nothing. Had 20.00 remained after those two items, a small, documented adjustment with approval would be reasonable. Had 2,000.00 remained, the opening balance is not ready.
When not to start the first bank reconciliation at the latest statement
Starting at the latest statement is wrong when the period before it may hold errors or fraud you need to find. A first reconciliation set from the most recent month treats everything before it as correct. If checks were altered, payees changed or deposits skimmed, that history disappears into the opening figure.
Go back further when any of these apply:
- Check images do not match the ledger. A payee or amount on a cleared check that differs from the register is a sign of check tampering, and the months before the start date need review, not an opening balance.
- The previous bookkeeper left suddenly or cannot explain the books.
- Taxes or loan covenants depend on prior figures. The opening balance then needs to agree to filed returns or lender reports.
- The old ledger and the statements disagree by more than you can explain in a short list like the one above.
In those cases, reconstruct month by month from the earliest reliable statement, and set the opening balance only once each earlier month reconciles. It is slower, but it is the only way the first reconciliation proves anything. For the statement side of that rebuild, PreciseBankFlow reads a run of statements, confirms each one foots and lists the lines that do not match the ledger, so each month of the rebuild starts from its exceptions.