Bank Reconciliation Template Example
Example document for Bank Reconciliation Template. Use this as a reference when creating your own.
For Informational Purposes
This document template is provided for informational purposes. Customize it for your specific needs.
Document: Bank Reconciliation Template
Example Document
Last updated 7/27/2026
Bank Reconciliation Statement
Business Name: Smith's Electrical Services ABN: 12 345 678 901 Bank Account Name: Smith's Electrical Operating Account BSB: 033-000 Account Number: 123456 Reconciliation Date: 30 June 2024 Prepared By: John Smith
1. Balance per Bank Statement
Balance as at 30 June 2024 from Bank Statement: $ 5,450.00
2. Add: Deposits not yet credited by the Bank (Deposits in Transit)
| Date | Details | Amount |
|---|---|---|
| 30 June | Cash from Job #405 (Night Deposit) | $ 1,200.00 |
| Total Deposits in Transit | $ 1,200.00 |
3. Less: Unpresented Cheques / Outstanding Payments
| Cheque No / Ref | Payee | Date | Amount |
|---|---|---|---|
| 1045 | Bright Sparks Wholesalers | 28 June | $ 350.00 |
| 1046 | Office Supplies Co | 29 June | $ 85.50 |
| Total Unpresented Cheques | $ 435.50 |
4. Adjusted Bank Balance
(Balance per Bank + Deposits in Transit - Unpresented Cheques) Adjusted Bank Balance: $ 6,214.50
5. Balance per Cash Book / Ledger
Balance as at 30 June 2024 from your records: $ 6,239.50
6. Add: Bank Credits not recorded in Cash Book
| Date | Details | Amount |
|---|---|---|
| 30 June | Interest earned on account | $ 5.00 |
| Total Bank Credits | $ 5.00 |
7. Less: Bank Charges & Debits not recorded in Cash Book
| Date | Details | Amount |
|---|---|---|
| 25 June | Monthly Account Fee | $ 15.00 |
| 28 June | Government Transaction Tax | $ 15.00 |
| Total Bank Debits | $ 30.00 |
8. Adjusted Cash Book Balance
(Balance per Cash Book + Bank Credits - Bank Debits) Adjusted Cash Book Balance: $ 6,214.50
9. Verification
| Item | Amount |
|---|---|
| Adjusted Bank Balance (from Item 4) | $ 6,214.50 |
| Adjusted Cash Book Balance (from Item 8) | $ 6,214.50 |
| Difference | $ 0.00 |
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: 30 June 2024
- Record Bank Fees/Charges:
- Debit Bank Charges Expense: $ 30.00
- Credit Bank Account: $ 30.00
- Record Interest Income:
- Debit Bank Account: $ 5.00
- Credit Interest Income: $ 5.00
Notes
This example shows a fully reconciled account. The adjusted balances match exactly at $6,214.50. The business owner recorded the cash deposit made on the last day of the month which the bank had not processed yet. They also identified cheques written but not yet cashed by suppliers. They also found bank fees and interest on the statement that were not yet in their own ledger. These adjusting entries ensure the ledger is accurate for the BAS.
About this Example
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.