Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
A manufacturing company with 8 bank accounts — 2 current accounts with different banks, 1 NACH collection account, 1 salary account, 2 CC limit accounts, 1 export proceeds account, 1 escrow account — produces 8 separate monthly bank reconciliations. The finance team spends 12 days per month on reconciliation, primarily because each account is reconciled independently.
The problem: 40% of unmatched items in each account are inter-bank transfers. If reconciliation ran across all accounts simultaneously, these transfers would self-match — and the 12-day close would compress to 4.
Why Multi-Bank Reconciliation Requires a Different Approach
Single-account bank reconciliation matches the cash book against the bank statement. Multi-bank reconciliation has two additional challenges:
- Inter-bank transfers — debits in one account that are credits in another
- Consolidated cash position — the CFO wants to know the total cash across all accounts, not account-by-account balances
Without a multi-account reconciliation system, both challenges are solved manually — inter-bank transfers are identified and explained in each account’s BRS, and the consolidated position is assembled by summing the individual account balances.
Standard Multi-Bank Account Structure
| Account type | Purpose | Reconciliation frequency |
|---|---|---|
| Primary current account | Vendor payments, operating expenses | Daily |
| NACH collection account | EMI and mandate collections | Daily (batch-level) |
| Salary disbursement account | Monthly payroll | Monthly (pre-payroll) |
| Export/EEFC account | Foreign currency receipts | Daily |
| Escrow/nodal account | Marketplace or RERA | Daily |
| CC/OD account | Working capital facility | Daily |
| Fixed deposit accounts | Short-term investment | Monthly |
Inter-Bank Transfer Matching
Inter-bank transfers are the primary source of unmatched items in multi-bank reconciliation. The matching process:
Step 1 — Identify transfers: In each account’s statement, identify debits and credits that are inter-company transfers (not vendor payments or customer receipts).
Step 2 — Match by UTR: For NEFT and RTGS transfers, the UTR is the unique identifier that appears in both the sending and receiving account statements. Match pairs by UTR.
Step 3 — Handle timing differences: Same-day RTGS transfers may appear in both statements on the same date. NEFT transfers after the evening cutoff appear in the receiving account the next business day — a 1-day timing difference. Flag unmatched transfers older than 2 business days for investigation.
Step 4 — Pooling sweeps: Automatic sweeps from a zero-balance pooling arrangement generate many transfers per day. These should be configured as auto-match rules — the sweep amount from sub-account A equals the credit in the master account on the same date.
Building a Consolidated Cash Position
A consolidated cash position report shows:
- Balance in each account (as at the reconciliation date)
- Outstanding items in each account (timing differences)
- Adjusted balance (balance net of timing items)
- Total adjusted cash across all accounts
The adjusted balance is the more accurate measure: it reflects what cash is actually available, excluding deposits in transit (which will arrive shortly) and outstanding cheques (which will leave shortly).
For treasury management, the consolidated adjusted cash position — updated daily — is the basis for:
- Working capital borrowing decisions (do we need to draw on the CC facility today?)
- Investment decisions (is there surplus cash that can be moved to an FD?)
- Vendor payment scheduling (which payments can we release today vs deferring?)
Escrow and Regulatory Account Reconciliation
Certain accounts require specific reconciliation procedures due to regulatory obligations:
RERA escrow accounts: Builders must deposit 70% of project collections in a RERA escrow. Withdrawals require documentation (completion certificates, invoices). The escrow reconciliation must match every deposit (70% of each flat payment), every withdrawal (with documentary support), and the closing balance must agree to the RERA portal’s registered balance.
Marketplace nodal accounts: Payments collected from buyers are held in a nodal account (regulated by RBI) before being settled to sellers. The nodal reconciliation matches buyer collections to seller settlements, with the nodal balance representing uncollected settlements.
CC/OD accounts: Working capital credit facilities have drawn and undrawn balances. The reconciliation matches the bank’s statement of utilisation against the company’s drawdown records, with interest calculated on daily balances.
Bank reconciliation software that connects to multiple bank accounts simultaneously — importing statements via MT940, bank APIs, or CSV — and matches inter-bank transfers across accounts eliminates the most time-consuming part of multi-bank reconciliation.
Reconciliation software India that generates a consolidated cash position across all accounts — with per-account BRS and the consolidated summary view — gives CFOs the real-time cash visibility they need without requiring manual assembly from 8 separate reconciliation files.
The Reserve Bank of India publishes guidelines on cash management services, inter-bank transfer systems (NEFT/RTGS/IMPS), and the regulatory requirements for escrow and nodal accounts — the framework within which multi-bank structures operate in India.