PropoDoc provides self-help document templates and tools. It is not a law firm and does not provide legal advice. Learn more.
Skip to main content
Template
Free

Bank Reconciliation Template

Template for Bank Reconciliation Template. Customize this template for your specific needs.

For Informational Purposes

This document template is provided for informational purposes. Customize it for your specific needs.

Document: Bank Reconciliation Template

Template Preview

Version 1 • Last updated 7/27/2026

Bank Reconciliation Statement

Business Name: [INSERT BUSINESS NAME] ABN: [INSERT ABN] Bank Account Name: [INSERT BANK ACCOUNT NAME] BSB: [INSERT BSB] Account Number: [INSERT ACCOUNT NUMBER] Reconciliation Date: [INSERT END DATE OF STATEMENT] Prepared By: [INSERT NAME]

1. Balance per Bank Statement

Balance as at [INSERT DATE] from Bank Statement: $ [INSERT BANK STATEMENT BALANCE]

2. Add: Deposits not yet credited by the Bank (Deposits in Transit)

DateDetailsAmount
[DATE][DETAILS OF DEPOSIT]$ [AMOUNT]
[DATE][DETAILS OF DEPOSIT]$ [AMOUNT]
Total Deposits in Transit$ [TOTAL AMOUNT]

3. Less: Unpresented Cheques / Outstanding Payments

Cheque No / RefPayeeDateAmount
[NUMBER][PAYEE NAME][DATE]$ [AMOUNT]
[NUMBER][PAYEE NAME][DATE]$ [AMOUNT]
Total Unpresented Cheques$ [TOTAL AMOUNT]

4. Adjusted Bank Balance

(Balance per Bank + Deposits in Transit - Unpresented Cheques) Adjusted Bank Balance: $ [CALCULATE BALANCE]


5. Balance per Cash Book / Ledger

Balance as at [INSERT DATE] from your records: $ [INSERT CASH BOOK BALANCE]

6. Add: Bank Credits not recorded in Cash Book

DateDetailsAmount
[DATE][E.G. INTEREST EARNED]$ [AMOUNT]
[DATE][E.G. DIRECT DEPOSIT RECEIVED]$ [AMOUNT]
Total Bank Credits$ [TOTAL AMOUNT]

7. Less: Bank Charges & Debits not recorded in Cash Book

DateDetailsAmount
[DATE][E.G. ACCOUNT FEE]$ [AMOUNT]
[DATE][E.G. GOVT CHARGE]$ [AMOUNT]
Total Bank Debits$ [TOTAL AMOUNT]

8. Adjusted Cash Book Balance

(Balance per Cash Book + Bank Credits - Bank Debits) Adjusted Cash Book Balance: $ [CALCULATE BALANCE]


9. Verification

ItemAmount
Adjusted Bank Balance (from Item 4)$ [COPY AMOUNT]
Adjusted Cash Book Balance (from Item 8)$ [COPY AMOUNT]
Difference$ [CALCULATE DIFFERENCE]

Note: The Difference must be Zero. If it is not zero, check for errors in addition or items missed.

10. Adjusting Journal Entries

(Use this section to update your official Cash Book / Ledger)

Date: [INSERT DATE]

  1. Record Bank Fees/Charges:
  • Debit Bank Charges Expense: $ [AMOUNT FROM ITEM 7]
  • Credit Bank Account: $ [AMOUNT FROM ITEM 7]
  1. Record Interest Income:
  • Debit Bank Account: $ [AMOUNT FROM ITEM 6]
  • Credit Interest Income: $ [AMOUNT FROM ITEM 6]
Use in GeneratorView Guide

About this Template

Part of the Bank Reconciliation Template document collection

Document Type

Bank Reconciliation Template

A spreadsheet tool used to compare your internal cash records against your bank statement to ensure accuracy and prevent fraud.

Complexity

moderate

Format

spreadsheet