Bank Reconciliation

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

BANK RECONCILIATION STATEMENT

As at {{date}}

Bank Account Name: {{bank_account_name}}

Bank Account Number: {{bank_account_number}}

Balance as per Bank Statement

Balance per Bank Statement (as at {{date}}): {{bank_statement_balance}}

Add: Deposits Not Yet Credited by 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 Deposits Not Yet Credited: {{total_deposits_not_credited}}

Less: Unpresented Cheques

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 Unpresented Cheques: {{total_unpresented_cheques}}

Balance as per Cash Book (After Adjustments)

Adjusted Bank Balance: {{adjusted_bank_balance}}

Balance as per Cash Book

Balance per Cash Book (as at {{date}}): {{cash_book_balance}}

Add: Bank Credits Not Yet Recorded in Cash Book

Date: {{credit_date_1}}, Description: {{credit_description_1}}, Amount: {{credit_amount_1}} (e.g., direct deposits, interest received)

Date: {{credit_date_2}}, Description: {{credit_description_2}}, Amount: {{credit_amount_2}}

Total Bank Credits Not Yet Recorded: {{total_bank_credits}}

Less: Bank Debits Not Yet Recorded in Cash Book

Date: {{debit_date_1}}, Description: {{debit_description_1}}, Amount: {{debit_amount_1}} (e.g., bank charges, debit orders, dishonoured cheques)

Date: {{debit_date_2}}, Description: {{debit_description_2}}, Amount: {{debit_amount_2}}

Total Bank Debits Not Yet Recorded: {{total_bank_debits}}

Adjusted Cash Book Balance

Adjusted Cash Book Balance: {{adjusted_cash_book_balance}}

Reconciliation Outcome

Discrepancy (if any): {{discrepancy_amount}}

Note: The Adjusted Bank Balance and Adjusted Cash Book Balance should be equal. Any discrepancy requires further investigation.

Authorisation

Prepared By: {{prepared_by_name}}

Position: {{prepared_by_position}}

Date: {{prepared_by_date}}

Reviewed By: {{reviewed_by_name}}

Position: {{reviewed_by_position}}

Date: {{reviewed_by_date}}