Skip to main content
How-To · 5 min read

Virtual Account Reconciliation in India: How Auto-Matching Works

Virtual accounts solve one of Indian reconciliation's oldest problems: NEFT and RTGS payments that arrive without a clear invoice reference. By assigning each customer a unique virtual account number, incoming payments are automatically tagged to the right customer — eliminating the narration-parsing step that requires manual reconciliation. This guide covers how virtual account reconciliation works and where it fails.

Terra Insight
Terra Insight Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 18 March 2026
Domain expertise
TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops

A lending company processes 12,000 EMI collections per month from borrowers using NACH mandates and NEFT payments. Before virtual accounts, the treasury team spent 8 days per month manually matching NEFT credits to borrower accounts — many borrowers paid from different accounts, with narrations like “EMI payment” or their name that did not always match the loan account number.

After deploying virtual accounts — one per borrower — the same 12,000 collections reconcile in under 2 hours: every NEFT credit arrives tagged to the correct borrower, and the LMS is updated automatically via the bank’s webhook.

How Virtual Accounts Work in India

A virtual account number is a unique identifier within a bank’s payment routing system. The bank maintains a mapping table: VAN → physical account + customer identifier. When a payment arrives at the VAN, the bank:

  1. Receives the NEFT/RTGS credit at the physical account
  2. Identifies the VAN from the payment reference
  3. Tags the credit with the customer identifier
  4. Generates a webhook event with the VAN, UTR, amount, and payer details
  5. Credits the physical account

The reconciliation system receives the webhook and:

  1. Looks up the customer assigned to this VAN
  2. Creates the receipt in the AR/LMS system
  3. Attempts to match the receipt to an open invoice or EMI instalment
  4. If matched: closes the record and sends confirmation
  5. If unmatched: flags for allocation review

Virtual Account Types and Use Cases

VA typeIssued byPrimary use caseSettlement
Bank CMS VANsHDFC, ICICI, Yes Bank, AxisB2B invoice collectionsReal-time (T+0)
Payment gateway VANsRazorpay, PayU, CashfreeSME collections, marketplace payoutsT+1 (batch)
NACH collection VANsBanks / NBFC platformsLoan EMI, insurance premiumT+1 (post-batch)
Escrow VANsRegulated entities onlyMarketplace, RERAPer RBI escrow guidelines

Reconciliation Events and Failure Modes

Successful VAN Match

Customer assigned to VAN 40023981XX pays ₹45,000. The webhook fires with VAN 40023981XX, UTR HDFCR2026031512345, amount ₹45,000. The reconciliation system matches to open invoice INV-2026-0234 for ₹45,000. Invoice closed. AR updated. Customer notification sent.

VAN Credit with Amount Mismatch

Same VAN, same customer, pays ₹40,500 (10% TDS deducted on ₹45,000). The webhook fires with ₹40,500 — does not exactly match the invoice of ₹45,000. The reconciliation system applies the TDS detection rule for this customer (Section 194J, 10%) and determines: ₹40,500 = ₹45,000 − 10% TDS. Match: gross invoice ₹45,000 = VAN credit ₹40,500 + TDS receivable ₹4,500. Invoice closed. TDS receivable created.

Webhook Failure

The bank’s webhook system experiences a timeout. The VAN credit appears in the bank statement but no webhook was received. The reconciliation system must have a fallback: periodic polling of the bank statement to identify VAN credits that did not generate a webhook event. Any credit tagged to a VAN that has no corresponding webhook entry is flagged for investigation.

Wrong VAN Used

Customer of Company A pays on the VAN assigned to Company B (wrong digit in the VAN). The credit is routed to Company B’s physical account and tagged to a customer who did not make this payment. Detection: the attributed customer’s account shows no open invoice matching the amount. Resolution: bank’s VAN reversal process — credit is reversed and re-routed to the correct VAN. Timeline: 1–3 business days.

VAN Housekeeping for Clean Reconciliation

Virtual account reconciliation accuracy depends on the quality of the VAN register:

  • Unique assignment: Each customer should have exactly one VAN. Shared VANs break the automatic attribution.
  • Inactive VAN management: When a customer account is closed, the VAN should be deactivated to prevent misrouted payments.
  • New customer onboarding: The VAN must be assigned and communicated to the customer before the first payment is expected. A customer who pays before a VAN is assigned will use the physical account number — and the payment will not be auto-reconciled.
  • VAN expiry: Some bank CMS arrangements assign temporary VANs (invoice-specific, 30-day validity). After expiry, payments on the VAN are rejected by the bank — the customer must be notified to use the updated VAN.

Integration Between VA System and ERP

The VAN reconciliation webhook must connect to the ERP or LMS in real time. For companies using SAP, Oracle, or Tally:

  • The webhook event must trigger an automatic journal entry in the ERP (Dr. Bank, Cr. AR)
  • The ERP receipt must be linked to the specific invoice using the invoice reference from the reconciliation system
  • The TDS receivable entry (if TDS was deducted) must be created simultaneously

Without ERP integration, the VAN webhook updates the reconciliation system but the ERP still requires manual data entry — eliminating most of the efficiency gain.

Bank reconciliation software with native VAN webhook support — parsing bank API events from HDFC, ICICI, Yes Bank, and Axis Bank CMS platforms — eliminates the gap between the VAN notification and the reconciliation system update.

Reconciliation software India that handles VAN-level auto-matching, TDS detection on VAN credits, and real-time ERP posting provides the complete auto-reconciliation workflow — reducing NEFT collection reconciliation from days to minutes.

The Reserve Bank of India publishes guidelines on virtual account structures for payment aggregators and banking correspondents, including the regulatory requirements for escrow-linked VANs and the responsibility framework for misrouted VAN payments.

Primary reference: Reserve Bank of India — where virtual account guidelines for payment aggregators and banking correspondents are published.

Frequently Asked Questions

What is a virtual account number in Indian banking?
A virtual account number (VAN) is a unique account number assigned to a specific customer or purpose, which routes incoming payments to a single physical bank account. When a customer pays using their assigned VAN via NEFT or RTGS, the bank automatically identifies the payment as coming from that customer — no narration parsing required. The physical bank account receives the credit, but the bank's system tags the credit with the VAN, enabling automatic reconciliation.
How does virtual account reconciliation work?
When a payment is received on a VAN, the bank generates an event notification (via API webhook) containing: the VAN, the amount, the UTR, the payer account number, and the timestamp. The reconciliation system receives this webhook, looks up which customer is assigned to this VAN, and automatically creates the receipt entry against the appropriate AR ledger record. If the amount matches an open invoice, the invoice is closed. If not, the receipt is flagged for allocation.
What are the types of virtual accounts used in India?
Three types: (1) Bank-issued VANs — assigned by banks like HDFC, ICICI, or Yes Bank as part of a cash management service; (2) Payment gateway VANs — issued by Razorpay, PayU, or Cashfree for NEFT collection; (3) NACH virtual accounts — used by NBFCs and lenders to receive EMI payments, where each borrower's mandate routes to a unique VAN. Each type has different API formats and different reconciliation events.
What are the failure modes in virtual account reconciliation?
The main failure modes are: (1) customer pays from a different account than expected and the bank identifies the payer incorrectly; (2) customer pays an amount that does not match any open invoice (overpayment or underpayment); (3) the VAN webhook fails to reach the reconciliation system due to a network timeout; (4) multiple customers share a VAN due to a configuration error (this creates misattribution at scale). Each failure requires different resolution logic.
How is TDS handled with virtual account payments?
When a client pays via VAN and deducts TDS, the VAN credit is the net amount (gross invoice minus TDS). The reconciliation system receives the VAN credit and must determine whether the shortfall from the invoice amount is due to TDS deduction or a partial payment. This determination requires either: (1) remittance advice from the client specifying TDS deduction, or (2) automated TDS detection based on the client's known TDS deduction pattern (section and rate).

See how TransactIG handles reconciliation for your industry

Configuration takes 2–4 weeks. No code development required. ISO 27001:2022 certified.