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.,
00291to locate relevant entries) - Search Amount: Filter transactions based on specific amounts
-
Show Filters: Options include:
-
All: Display all records Not Marked: Show only unreconciled transactionsMarked: 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
- Upload a bank statement (CSV or system-generated)
- Filter transactions by cheque number or amount
- Use "Mark All Entries" to reconcile efficiently
- 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