Bank Reconciliation (Bank Reco)

Bank Reconciliation (Bank Reco)

Bank Reconciliation Module - User Guide

1. Introduction 📝

The Bank Reconciliation (Bank Reco) module is a critical financial control tool used to harmonize the company’s book balances with actual bank statements. It allows users to track the clearance of cheques and electronic transfers by assigning a Value Date (Reco Date) to each transaction, effectively bridging the timing gap between accounting entry and actual bank statement clearance.

â„šī¸

In the overall business flow:

  1. Identifies Unpresented Cheques (issued to vendors but not yet cleared).
  2. Tracks Uncleared Deposits (customer receipts in transit).
  3. Produces the statutory Bank Reconciliation Statement (BRS) explaining differences between ERP Book Balance and Bank Statement Balance.

Typically, this module is used by Finance Managers, Senior Accountants, and Auditors.


2. Getting Started with Bank Reco 🚀

Core Concepts

  1. Voucher Date: The date the transaction was recorded in the ERP.
  2. Cheque Date: The date mentioned on the physical instrument or electronic instruction.
  3. Value Date (Reco Date): The date the funds actually debited or credited on the official bank statement.
  4. Pending Items: Any transaction where the “Value Date” is empty is considered uncleared or in transit.

3. Features & Benefits ✨

⚡ Batch Reconciliation (Excel Import)

  • Bulk Value Date Update: Instead of manual line-by-line entry, click Bank Reco Model to download the unreconciled transactions into an Excel template, fill in clearance dates from your bank portal, and upload via Bank Reco Upload.
  • Voucher ID Verification: The system utilizes tracking identifiers in column 1 to ensure that clearance dates map to the exact voucher record even with identical amounts or dates.

📊 Professional BRS Statements & Filtering

  • Report Type Toggle: Filter transactions by “Unreconciled Only” (focus purely on open clearing items) or “ALL” (complete view of cleared and uncleared transactions).
  • Balance Walk-through: Generates an audit-ready Excel report that starts with the Bank Book Balance, adjusts for unpresented cheques and uncleared deposits, and arrives at the Bank Statement Balance.

4. Complete Flow 🔄

Step 1: Select Bank & Period

  • Select the Bank Ledger from the autocomplete list.
  • Select the Date Range (must fall within the active financial year).
  • Choose Report Type: ALL or Unreconciled.

Step 2: Perform Reconciliation

  • Online Entry: Enter or edit the Value Date column directly in the grid.
  • Bulk Excel Import:
    1. Click Bank Reco Model to download open items into BankReco.xlsx.
    2. Input the clearance dates under the Value Date column.
    3. Upload the file using Bank Reco Upload.

Step 3: Error Check & BRS Print

  • Check the upload report for any validation errors.
  • Click Print to download the completed Bank Reconciliation Statement in Excel.

5. Validations and Business Rules âš ī¸

Business Logic Validations (Error Codes A–G)

The system validates every reconciliation row against strict banking and accounting rules:

  • Code A: Invalid Voucher Date format.
  • Code B: Invalid Cheque Date format.
  • Code C: Invalid Value Date format.
  • Code D: Value Date < Cheque Date — Value Date cannot be dated prior to the cheque or instruction date.
  • Code E: Value Date > 3 Months from Cheque Date — Flags stale instruments exceeding the 3-month statutory validity period.
  • Code F: Invalid Voucher ID / Voucher Number / Date combination (transaction record mismatch).
  • Code G: Future Value Date Not Allowed — The bank clearance date cannot be in the future (Value Date > Today).

Structural Validations (Error Codes Z1–Z7)

  • Column Structure: The uploaded Excel sheet must maintain its 9 columns starting with Voucher ID and ending with Value Date.
  • Data Integrity (Z1–Z7): Rejects sheets with missing internal tracking IDs, blank mandatory columns, or altered amounts.

6. Related Reports 📊

  • 📑 Bank Reconciliation Statement: Reconciles the difference between physical bank balance and ERP ledger balance.
  • đŸĻ Cash & Bank Book (Daily Balance - Value Date): Evaluates bank liquidity as per cleared dates rather than entry dates.
  • đŸ’ŗ Cheque Register Report: Tracks the lifecycle of physical cheque leaves issued to vendors.

7. Best Practices / Tips 💡

  • Preserve Voucher ID Column: Never delete or modify the first column (Voucher Id) in the Excel download model.
  • Date Format Consistency: Use standard date formats (e.g., 01-Apr-26) when editing in Excel to prevent regional date conversion errors.
  • Stale Cheque Management: For cheques flagged with Code E (> 3 months), stop the cheque and issue a fresh replacement voucher.