Bank Reconciliation Template

Company Letterhead Block

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Bank Reconciliation Statement

For the Period Ending: {{date}}

Bank Account Name: {{bank_account_name}}

Bank Account Number: {{bank_account_number}}

1. Balance as per Bank Statement

Balance as per bank statement on {{date}}: {{bank_statement_balance}}

2. Add: Unpresented Deposits

Deposits made but not yet credited by the bank:

Date: {{deposit_date_1}}, Description: {{deposit_description_1}}, Amount: {{deposit_amount_1}}

Date: {{deposit_date_2}}, Description: {{deposit_description_2}}, Amount: {{deposit_amount_2}}

Total Unpresented Deposits: {{total_unpresented_deposits}}

3. Less: Uncashed Cheques

Cheques issued but not yet debited by the bank:

Cheque No: {{cheque_no_1}}, Date: {{cheque_date_1}}, Payee: {{cheque_payee_1}}, Amount: {{cheque_amount_1}}

Cheque No: {{cheque_no_2}}, Date: {{cheque_date_2}}, Payee: {{cheque_payee_2}}, Amount: {{cheque_amount_2}}

Total Uncashed Cheques: {{total_uncashed_cheques}}

4. Adjusted Bank Balance

Calculated as: (Balance as per Bank Statement + Total Unpresented Deposits - Total Uncashed Cheques)

Adjusted Bank Balance: {{adjusted_bank_balance}}

5. Balance as per Cash Book

Balance as per company cash book on {{date}}: {{cash_book_balance}}

6. Add: Bank Credits not in Cash Book

e.g., Direct deposits, interest received:

Date: {{credit_date_1}}, Description: {{credit_description_1}}, Amount: {{credit_amount_1}}

Total Bank Credits: {{total_bank_credits}}

7. Less: Bank Debits not in Cash Book

e.g., Bank charges, debit orders, dishonoured cheques:

Date: {{debit_date_1}}, Description: {{debit_description_1}}, Amount: {{debit_amount_1}}

Total Bank Debits: {{total_bank_debits}}

8. Adjusted Cash Book Balance

Calculated as: (Balance as per Cash Book + Total Bank Credits - Total Bank Debits)

Adjusted Cash Book Balance: {{adjusted_cash_book_balance}}

9. Reconciliation Summary

The Adjusted Bank Balance of {{adjusted_bank_balance}} should equal the Adjusted Cash Book Balance of {{adjusted_cash_book_balance}}.

Any remaining difference must be investigated and resolved.

10. Prepared By

Name: {{preparer_name}}

Title: {{preparer_title}}

Date: {{prepared_date}}

11. Approved By

Name: {{approver_name}}

Title: {{approver_title}}

Date: {{approved_date}}

Signature Block

_____________________________

{{authorised_signature}}

{{authorised_name}}

{{authorised_title}}

Date: {{signature_date}}