A1:F22fxIF OR ROUND SUMIF
Bank Reconciliation Statement — the first rows of the actual spreadsheet
Bank Reconciliation Statement
The opening rows of the file you get — sample data included, not a mock-up.

Finance template

Bank Reconciliation Statement

Adjusts the bank and the cash book side by side and says "Reconciled" when they agree.

$12one payment, yours to keep
  • ✓Instant download
  • ✓Every later version free
  • ✓Commercial use
  • ✓No watermark
15
live formulas, each one recalculated and checked
6
columns: Date, Description, Reference, Item type, Amount, Adjusts
8
figures worked out for you

Need more than one? All 13 Finance templates for $39 — $200 bought separately. All 70 for $99.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 20 November 2026.

There are free templates. Why this one?

There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 15 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.

It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No watermark, and you can use it commercially.

About this Bank Reconciliation Statement template

A bank reconciliation explains why the bank statement and your cash book show different balances. This Excel template takes both closing balances and one row for each difference: unpresented cheques, deposits in transit, bank charges, interest, direct credits and direct debits.

Each item type adjusts the correct side automatically. The bank balance is reduced by unpresented cheques and increased by deposits in transit; the cash book picks up charges, interest and direct payments. When the two adjusted balances match, the status reads Reconciled.

Good for

  • →Monthly bank reconciliation for a small business
  • →Accounting students practising the bank reconciliation statement format
  • →Bookkeepers checking a client's cash book before month-end

What it works out for you

Reconciliation

  • →Less: unpresented cheques
  • →Add: deposits in transit
  • →Adjusted bank balance
  • →Adjusted cash book balance
  • →Difference
  • →Status

What is inside the Bank Reconciliation Statement template

The table has 6 columns. Calculated columns fill themselves in; the rest are yours to type over.

  • →Date
  • →Description
  • →Reference
  • →Item type
  • →Amount
  • →Adjusts

Settings in the “Closing balances” box

  • →Balance per bank statement
  • →Balance per cash book

How to use the Bank Reconciliation Statement in Excel

Enter both closing balances at the bottom, then one row per difference. Each item type adjusts the side it belongs to; the status turns to "Reconciled" when the two adjusted balances match.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.

Shaded, boxed cells below the table are settings the formulas read from. Change those first — every row that depends on them updates at once.

Functions and formulas it uses

Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.

IFORROUNDSUMIF

Questions about the Bank Reconciliation Statement

Which items adjust the bank statement and which adjust the cash book?

Unpresented cheques and deposits in transit adjust the bank statement balance. Bank charges, interest received, direct credits and direct debits adjust the cash book. The Adjusts column shows which side each row affects.

What if the status says Not reconciled?

The Difference line shows by how much. Look for a missing item, an amount typed wrongly, or an item given the wrong type.

Does it work in Google Sheets?

Yes. It uses SUMIF, IF, OR and ROUND, which work the same in Excel, Google Sheets and LibreOffice.

What you get with the Bank Reconciliation Statement

  • ✓15 formulas, every one recalculated and checked
  • ✓Opens with sample rows already filled in
  • ✓Excel, Google Sheets and LibreOffice Calc
  • ✓Set up to print on one page wide
  • ✓Commercial use, no attribution needed
  • ✓Every later version included free

Get the Bank Reconciliation Statement for $12

One payment. The file downloads straight away, and every later version of it is yours at no extra cost.

Buying a few? All 13 Finance templates for $39, or all 70 for $99.

More finance templates

See all Finance →