Skip to content

BRS

Bank Reconciliation in Merciglobal Cloud ERP

Streamline your financial closing process with smart tools and accurate tracking.

What is Bank Reconciliation (BRS)?

Bank Reconciliation is the process of matching your business's internal financial records with the statements provided by your bank. This ensures there are no discrepancies between what your company records and what the bank confirms.

In Merciglobal Cloud ERP, this feature is presented through an intuitive user interface and robust automation tools, making reconciliation efficient and accurate for businesses of all sizes.

Visual Breakdown of the Reconciliation Interface

Search & Filter Section

  • Search Cheque: Filter transactions by cheque number (e.g., 00291 to locate relevant entries)
  • Search Amount: Filter transactions based on specific amounts

  • Show Filters: Options include:

  • All: Display all records

  • Not Marked: Show only unreconciled transactions
  • Marked: Display already reconciled entries

Action Buttons

  • Mark All Entries: Marks all visible transactions as reconciled
  • Download Data (CSV): Exports filtered data for offline analysis or audit purposes
  • Map BRS CSV: Uploads a bank reconciliation sheet for automatic mapping
  • Upload Bank Statement: Allows direct import of official bank statements
  • Generate Statement: Creates a comprehensive bank reconciliation report

Transaction Data Table - Column Wise Guide

Column Description
Date Transaction date (e.g., 10-04-2025)
Description Vendor or customer name, transaction description
RDate Reconciliation date (auto-filled when marked)
Cheque Unique cheque number used for reconciliation
Debit/Credit Amount of the transaction
Balance Account balance updated post-transaction
Dr/Cr Indicates whether the transaction is a Debit or Credit
Doc Document number associated with the transaction
Info Reference details (e.g., TDS information, RTGS references)

Each row represents an individual financial transaction with accompanying reconciliation metadata.

Benefits of Using Bank Reconciliation in Merciglobal

Speed and Accuracy

  • Quickly mark multiple entries for reconciliation
  • Search transactions by cheque number or amount with ease

Real-time Clarity

  • Instantly updated balances with new entries
  • Immediate detection of mismatches or duplicate entries

Easy Integration

  • Upload reconciliation data from CSV or bank statements
  • Automatic mapping with internal accounting records

Export Capability

  • Download reconciliation data for external audits
  • Generate reports for accounting and finance teams

Transparency and Security

  • Each transaction logs associated document IDs and types
  • Maintains a complete, auditable action trail

Typical Workflow

  1. Upload a bank statement (CSV or system-generated)
  2. Filter transactions by cheque number or amount
  3. Use "Mark All Entries" to reconcile efficiently
  4. Generate and export the reconciliation statement

Summary

The Bank Reconciliation feature in Merciglobal Cloud ERP simplifies and secures the financial reconciliation process. Tailored for finance professionals, developers, and auditors, this tool offers the speed, clarity, and reliability essential for effective enterprise banking operations.

Note: Regular reconciliation is essential for maintaining financial integrity and avoiding future discrepancies.

Prepared for: Merciglobal Customers, Developers, and Sales Team Members

Auto-Matching with a Bank Statement File

The Bank Stmt button reads your bank statement and fills the Reconciliation Date for every matching entry automatically.

Setting up the column positions (one time per bank)

  1. Click Map BRS Csv on the reconciliation screen (or open Masters > Auto BRS Mapper).
  2. Select the bank account and enter the column number (1 = first column) where the statement shows:
    • the Date column (transaction/clearing date),
    • the Cheque No. column,
    • the Dr amount column - Withdrawal (Debit),
    • the Cr amount column - Deposit (Credit).
  3. Save. Example: for a statement laid out as Date | Particulars | Cheque No | Withdrawal | Deposit | Balance, enter 1, 3, 4 and 5.

Uploading the statement

  1. Open Bank Reconciliation for the bank and period.
  2. Click Bank Stmt, choose the statement file and click Upload Stmt.
  3. A summary shows how many entries got their Reconciliation Date, which were already reconciled, and which cheque numbers were not found in the statement.

Notes

  • CSV and Excel (.xls / .xlsx) statements are both accepted; for Excel the first sheet is read.
  • Title rows, column headings, totals and footer lines are ignored automatically - only rows with a valid date are used.
  • When the Cheque No. column is blank but the narration carries the cheque (for example OW CHQ 086650-PARTY NAME), that cheque number is picked up from the narration.
  • An entry is matched only when both the cheque number and the amount agree. Entries that are already reconciled are never changed.
  • Entries without a cheque number (RTGS, NEFT and similar) are not auto-matched; mark them with the Spacebar as usual.

Typing the Reconcile Date directly (RDate cell)

Where this option is switched on for your company, you no longer need the Space pop-up to reconcile an entry:

  1. Move to the RDate cell of the entry (Bank Reconciliation or All Firm Bank Reconciliation).
  2. Type the bank clearing date - any of 03-04-2026, 03/04/2026, 030426 or 03042026 is accepted.
  3. Press Enter. The cell shows a "saving" shade and the date is stored at once; balances update as before.

Rules checked while saving:

  • The date cannot be earlier than the voucher / cheque date.
  • The date must be within about a year of the voucher date (typing mistakes such as a wrong year are refused).
  • An invalid date shows a message and the cell goes back to its earlier value - nothing is saved.

To un-reconcile, clear the RDate cell (Delete) and press Enter - same as pressing R. The Space pop-up still works exactly as before. Ask Merciglobal support to enable this option for your company.