Skip to content

Bank Reconciliation in Merciglobal Cloud ERP

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


What is Bank Reconciliation (BRS)?

(How to match 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 thinks it has and what the bank confirms.

In Merciglobal Cloud ERP, this feature is presented through an intuitive UI and powerful automation tools, making reconciliation a breeze for businesses of all sizes.


Visual Breakdown of the Reconciliation Interface

Below is a detailed explanation of each visible component from the screenshot of the Merciglobal Bank Reconciliation UI:

Search & Filter Section

  • Search Cheque: Allows filtering by cheque number (e.g., 00291 entered to find all related transactions)
  • Search Amt: Search transactions by specific amount
  • Show Filters: Toggle between:
  • All: Show all records
  • Not Marked: Show only unreconciled entries
  • Marked: Show already reconciled records

Action Buttons

  • Mark All Entries: Instantly marks all visible transactions for reconciliation
  • Download Data (CSV): Export filtered data for offline processing or audit
  • Map BRS CSV (🔵): Upload your bank’s reconciliation sheet for automatic mapping
  • Upload Bank Stmt (🔴): Directly import your official bank statement
  • Generate Statement (🟡): Create a complete bank reconciliation report

Transaction Data Table - Column Wise Guide

Column Description
Date Transaction date (e.g., 10-04-2025)
Desc Description or vendor/customer name
RDate Reconciliation Date (auto-filled when marked)
Cheque Unique cheque number for matching (e.g., 0002910)
Debit/Credit Amount transacted
Balance Updated account balance after transaction
Dr/Cr Indicates Debit (Dr) or Credit (Cr) entry
Doc Document number linked to transaction
Info Reference document details (e.g., TDS info, RTGS references)

Each row in this table shows a single financial transaction, complete with cheque and bank reconciliation metadata.


Benefits of Using Bank Reconciliation in Merciglobal

Speed & Accuracy

  • Bulk mark entries to save time 🕒
  • Quickly search by cheque or amount 🔎

Real-time Clarity

  • See updated balances as soon as entries are added
  • Detect mismatches or duplicate entries instantly

Easy Integration

  • Upload .CSV or direct bank statements
  • Auto-map with internal records

Export-Friendly

  • Download reconciled data for external audits
  • Generate and share statement with accounting teams

Transparent & Secure

  • Every entry logs document ID and type (TDS, RTGS, etc.)
  • Fully auditable trail of actions

Typical Workflow

  1. 📥 Upload a bank statement (CSV or system-generated)
  2. 🔍 Filter transactions by cheque number or amount
  3. 🖱️ Use "Mark All Entries" for quick reconciliation
  4. 🧾 Generate and export the reconciliation statement

Summary

The Bank Reconciliation feature in Merciglobal Cloud ERP is designed to simplify, automate, and secure the financial reconciliation process. Whether you're a finance professional, developer, or auditor, this tool provides the efficiency and clarity needed for modern enterprise banking operations.

💡 Ensure you reconcile periodically to maintain financial hygiene and avoid future discrepancies.


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