Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingBank Reconciliation

SpreadsheetAccounting & BookkeepingFree

Bank Reconciliation

Match your cash book to the bank statement, explain every difference and know when it is reconciled.

Shown with sample data

Colour

Bank Reconciliation

Match your cash book to the bank statement, explain every difference and know when it is reconciled.

Adjusted bank balance
$23,203
Adjusted book balance
$23,203
Difference
$0
Should be $0 when reconciled
Items to clear
3

How to use it

  1. 1Enter the bank statement closing balance and your cash book (ledger) balance on the Reconciliation sheet.
  2. 2List every item that appears on only one side on the Items sheet and choose its type; the side and sign are worked out for you.
  3. 3Keep going until the difference is zero and the status reads Reconciled.
  4. 4Post the bank-only items (fees, interest, corrections) to your books.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A month-end bank reconciliation laid out the way accountants present it. Enter the statement and cash book balances, list the reconciling items (deposits in transit, outstanding cheques, bank fees, interest and errors) and the statement adds and deducts each one on the correct side, shows the adjusted balances and says Reconciled when the difference is zero.

Who it’s for

  • Month-end close for a small business
  • Bookkeepers reconciling several accounts
  • Finding missing or duplicated transactions

What’s included

  • Reconciliation sheet: Statement and book balances with every adjustment.
  • Items sheet: Everything that appears on only one side.

How to use it

  1. 1Enter the bank statement closing balance and your cash book (ledger) balance on the Reconciliation sheet.
  2. 2List every item that appears on only one side on the Items sheet and choose its type; the side and sign are worked out for you.
  3. 3Keep going until the difference is zero and the status reads Reconciled.
  4. 4Post the bank-only items (fees, interest, corrections) to your books.

Tips

  • Tick off matching items on the statement and ledger first; only the leftovers go on the Items sheet.
  • A difference that divides exactly by 9 is often a transposition error.
  • Follow up any cheque outstanding for more than three months.

Questions

Which items adjust the bank side?

Deposits in transit (added) and outstanding cheques (deducted): the bank has not processed them yet.

Which adjust the books?

Bank fees, interest, direct debits and errors you have not recorded yet.

Related searchesbank reconciliationmonth end closereconcile bank statementbookkeepingoutstanding chequesdeposits in transit

Details

Format
Spreadsheet
Category
Accounting & Bookkeeping
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounting & BookkeepingFree

Bank Reconciliation

Match your cash book to the bank statement, explain every difference and know when it is reconciled.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounting & Bookkeeping
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More accounting & bookkeeping templates

View all
General Ledger2 sheets

Total debits

$19,020

Total credits

$19,020

Out of balance

$0

ABCD
1Entry no.DateAccountDescription
2J-001Nov 1BankOwner investment
3J-001Nov 1Owner equityOwner investment
4J-002Nov 2EquipmentLaptop and printer
5J-002Nov 2BankLaptop and printer
Journal
SpreadsheetBookkeeping

General Ledger

A double-entry journal with account totals, a running check that debits equal credits and balances by account type.

10 min setupPreview
Invoice Tracker2 sheets

Outstanding

$9,940

Overdue

$8,690

Average days to pay

15

ABCD
1InvoiceClientSentDue
21001Harbor LogisticsSep 15Sep 29
31002Northwind StudioSep 22Oct 6
41003BluepeakSep 30Oct 14
51004Juniper & CoOct 8Oct 22
Invoices
SpreadsheetBilling & Receivables

Invoice Tracker

Every invoice you have sent with due dates, payments received, days late and who to chase.

10 min setupPreview
Accounts Receivable Aging Report2 sheets

Total outstanding

$47,805

Overdue

$31,455

Over 60 days

$12,680

Balance by age
$17k
$16k
$11k
$2,150
$1,980
1-30Current61-9031-6090+
SpreadsheetAccounting & Bookkeeping

Accounts Receivable Aging Report

Open invoices aged into current, 1-30, 31-60, 61-90 and 90+ days, with collection priority and next steps.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ