Bank Reconciliation Statement

📖 What is a Bank Reconciliation Statement?

A Bank Reconciliation Statement is a financial document that compares and matches the balance shown in a company's cash book with the balance reported on its bank statement. This process helps identify any differences between the two records and ensures that all transactions have been properly accounted for.

                Why is it important? Bank reconciliation helps detect errors, omissions, fraud, unauthorized transactions, and timing differences. It is a critical internal control measure that every business should perform periodically — typically at the end of each month.
            

Common reasons for differences include deposits in transit (recorded in books but not yet cleared by the bank), outstanding checks (issued but not yet presented for payment), bank service charges, interest earned, and NSF (Non-Sufficient Funds) checks.

✅

Accuracy

Ensures your books match actual bank records

🔍

Detection

Identifies errors, fraud, and missing entries

📊

Compliance

Meets accounting standards and audit requirements

📝 The Input Form

The input form is designed to capture all necessary information to generate an accurate reconciliation statement. It is divided into three logical sections: Company & Bank Details, Bank Statement Adjustments (Column A), and Cash Book Adjustments (Column B).

Company & Bank Details

These fields identify the company, bank account, and the statement period being reconciled. If bank accounts are configured in the system, you can select from a dropdown — otherwise, manual entry is available.

Reconciliation Fields Explained

Field	Column	Effect	Description
Balance as per Bank Statement	A	Starting Point	The ending balance shown on the bank statement for the period
Deposits in Transit	A - Add	Increases	Deposits recorded in cash book but not yet appeared on bank statement
Outstanding Checks	A - Less	Decreases	Checks issued by the company but not yet cleared by the bank
Balance as per Cash Book	B	Starting Point	The balance shown in the company's own cash book / ledger
Interest Earned	B - Add	Increases	Interest credited by the bank but not yet recorded in cash book
Bank Service Charges	B - Less	Decreases	Fees charged by the bank but not yet recorded in cash book
NSF Checks	B - Less	Decreases	Bounced checks deposited but returned due to insufficient funds

How to Use the Form

Select or enter the bank account details. The system auto-fills the current balance if available.
Choose the statement ending date for the reconciliation period.
Enter the Bank Statement balance and any adjustments (deposits in transit, outstanding checks).
Enter the Cash Book balance and any adjustments (interest earned, service charges, NSF checks).
Watch the live preview boxes update automatically as you type.
Click "Generate Reconciliation Statement" to view the final report.

📊 The Generated Report

Once the form is submitted, the system generates a professional, print-ready Bank Reconciliation Statement. The report is structured in a clean two-column format showing both the Bank Statement adjustments and the Cash Book adjustments side by side, making it easy to compare and verify.

Report Structure Preview

🏦 Bank Statement

Balance per Bank $10,000.00

Add: Deposits in Transit + $2,500.00

Less: Outstanding Checks - $1,200.00

Adjusted Balance $11,300.00

📒 Cash Book

Balance per Cash Book $11,000.00

Add: Interest Earned + $350.00

Less: Service Charges - $50.00

Adjusted Balance $11,300.00

Report Sections

The generated statement includes the following key sections:

🏢

Header

Company name, bank name, account number, and statement date

📋

Two Tables

Side-by-side Bank & Cash Book adjustment tables

💎

Result Cards

Highlighted adjusted balances for both columns

✅

Status

Reconciled or variance amount with explanation

Reconciliation Status

✅

SUCCESSFULLY RECONCILED

Both adjusted balances match. Books are in agreement.

⚠️

NOT RECONCILED

Variance exists. Review entries for missing transactions or errors.

                🖨️ Print-Ready: The generated report is fully optimized for printing. Click the "Print Statement" button to get a clean, professionally formatted hard copy suitable for filing, auditing, or management review.
            