Business OS
Finance & AccountingBanking

Bank Reconciliation

This Bank Reconciliation template is used to reconcile the cash balance of a business as per its accounting records with the balance shown on the bank statement. This ensures accuracy and helps identify discrepancies such as outstanding checks or deposits in transit.

Updated 15d ago
bank reconciliationfinancial documentcash managementaccountingfinance

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Bank Reconciliation Statement

For the Period Ending: {{period_ending_date}}

Bank Account Name: {{bank_account_name}}

Bank Account Number: {{bank_account_number}}

Balance per Bank Statement

Balance as per Bank Statement (as of {{bank_statement_date}}): {{bank_statement_balance}}

Add: Deposits in Transit:

Deposit 1 (Date: {{deposit_1_date}}, Amount: {{deposit_1_amount}})

Deposit 2 (Date: {{deposit_2_date}}, Amount: {{deposit_2_amount}})

Less: Outstanding Checks:

Check 1 (Number: {{check_1_number}}, Date: {{check_1_date}}, Amount: {{check_1_amount}})

Check 2 (Number: {{check_2_number}}, Date: {{check_2_date}}, Amount: {{check_2_amount}})

Adjusted Bank Balance: {{adjusted_bank_balance}}

Balance per Books (Company Records)

Balance as per Books (as of {{book_record_date}}): {{book_record_balance}}

Add: Bank Collections/Errors:

Bank Collection 1 (Description: {{bank_collection_1_description}}, Amount: {{bank_collection_1_amount}})

Error Correction (Description: {{error_correction_1_description}}, Amount: {{error_correction_1_amount}})

Less: Bank Charges/Errors:

Bank Service Charge (Amount: {{bank_service_charge_amount}})

NSF Check (Customer: {{nsf_customer_name}}, Amount: {{nsf_check_amount}})

Error Correction (Description: {{error_correction_2_description}}, Amount: {{error_correction_2_amount}})

Adjusted Book Balance: {{adjusted_book_balance}}

Reconciliation Summary

Adjusted Bank Balance: {{final_adjusted_bank_balance}}

Adjusted Book Balance: {{final_adjusted_book_balance}}

Discrepancy (if any): {{discrepancy_amount}}

Explanation of Discrepancies (if any)

{{explanation_of_discrepancies}}

Prepared By

Name: {{preparer_name}}

Title: {{preparer_title}}

Date: {{preparation_date}}

Reviewed By

Name: {{reviewer_name}}

Title: {{reviewer_title}}

Date: {{review_date}}

Signature

________________________

{{authorized_signature_name}}

{{authorized_signature_title}}

Related templates