Bank Reconciliation for Indian Enterprises
Enterprise bank reconciliation is not BRS at scale — it is bank-specific format parsing, narration pattern matching, multi-bank consolidation, and audit-ready documentation. Guides covering HDFC, ICICI, SBI, MT940, and CARO 2020 audit workflows.
Basic bank reconciliation works when a business has one account and reads statements in a browser. It breaks the moment an enterprise has 15 current accounts across four banks, each with its own narration format, each integrated with a different ERP, and each subject to CARO 2020 audit scrutiny. At that scale, the reconciliation problem is not 'do the balances match' — it's 'can we classify every entry deterministically and show an auditor how we did it.'
India's bank-specific complexity is underrated. HDFC NetBanking, HDFC CMS, and HDFC MT940 are three different formats. ICICI CIB has its own narration grammar. SBI's YONO Business and CMP exports use different date and amount conventions. PSU banks ship dot-matrix-era statements in PDFs that need OCR before they can even be parsed. Co-operative banks often have no digital export at all.
This cluster covers the banks (HDFC, ICICI, SBI), the formats (MT940, CSV, PDF), the operational surfaces (narration patterns, opening balance, bank charges, payroll bank reconciliation), and the audit lens (CARO 2020). Articles are written for finance teams managing multi-bank consolidation — not for bookkeepers reconciling one account.
My Bank Reconciliation Does Not Tally: How Do I Narrow Down Where the Difference Starts?
When a bank reconciliation will not tally, narrow it down in three moves. Prove the bank statement's own arithmetic, prove the cash book's arithmetic, then compare the two running balances date by date to find the first day they part ways. That day holds the missing or wrong entry.
How Do You Reconcile an Overdraft or Cash Credit Account When the Balance Is Negative?
An overdraft or cash credit account is reconciled like any other bank account, but the balance is money you owe the bank. That means the add and deduct signs on timing items flip compared with a positive balance. A worked example shows the full statement.
Bank Reconciliation Statement: When Do You Add and When Do You Deduct?
Starting from the cash book balance, add what makes the passbook higher and deduct what makes it lower. Starting from the passbook, every sign flips. An eight-item table and a worked example show both routes reaching the same adjusted balance.
BRS Format in Excel: A Simple Layout With the Cash Book on One Side and the Passbook on the Other
A workable bank reconciliation statement in Excel needs four blocks: balance as per cash book, items to add, items to deduct and balance as per passbook, with one check cell that must show zero. One sheet is enough for a single bank account.
What Is the Difference Between a Cash Book and a Passbook?
The cash book (bank column) is your own record of every rupee moving through the bank account. The passbook or bank statement is the bank's record of the same account. Because each side records entries at different times, the two balances rarely agree on any given date, and a bank reconciliation statement explains the gap.
My Customer Says They Have Paid, but I Cannot See the Money in My Bank Statement
When a customer says they have paid and you cannot see the money, ask for the UTR or UPI reference and the paying account, then search every one of your accounts by amount and date. Most cases are a pending transfer, a payment into a different account or a credit with an unfamiliar sender name.
Why Does the Bank Call My Deposit a Credit When My Cash Book Shows It as a Debit?
The bank writes your account from its own side. A deposit is money the bank owes you, so it is a credit in the bank's records. Your cash book treats the bank balance as your asset, so the same deposit is a debit there. Every entry is a mirror image.
There Is a Debit in My Bank Statement That I Do Not Recognise: Where Do I Look?
Most debits you do not recognise are bank charges with GST, auto-debits such as EMIs, insurance, SIPs, UPI AutoPay or NACH mandates, card or ATM use, or tax payments. A genuine unauthorised debit is the rarest cause, but it is the one you must report to your bank at once.
How Do I Decode the Codes in My Bank Statement Narration (NEFT, IMPS, UPI, ACH) and Match Each to an Entry in My Books?
Read a bank statement narration from left to right. First comes the channel (NEFT, RTGS, IMPS, UPI, ACH or NACH, cheque clearing, ATM or POS), then a reference number, then text about the other party. The channel tells you which kind of entry in your books to look for.
Is My Bank Reconciliation Correct? Five Checks Before You Sign It Off
A bank reconciliation is right when both adjusted balances agree to the rupee, every reconciling item has a document behind it, last month's items have cleared, the statement balance is the bank's own figure, and someone other than the preparer has reviewed it.
How to Do a Bank Reconciliation Step by Step: A Worked Example in ₹
Bank reconciliation is five moves: get the passbook, tick matching entries, list what is left, adjust the cash book for passbook-only items, and prove both adjusted balances agree. This worked March example takes a cash book of ₹4,72,500 to a passbook of ₹4,91,060.
How Do You Read an Indian Bank Statement Before You Reconcile It?
Every Indian bank statement lists each debit and credit with a transaction date, a value date, a narration, a cheque or reference number and a running balance. To reconcile, you match each line to your cash book on date, reference and amount, and finish at the closing balance.
I Reconciled the Wrong Entries: How Do I Undo a Bank Reconciliation in Tally or Zoho Books?
Undoing a reconciliation sends entries back to unreconciled so you can match them again. In Zoho Books you can undo only the most recent reconciliation; in TallyPrime you view reconciled entries and set their status back to unreconciled.
Which BRS Items Need a Journal Entry in Your Books and Which Need None?
Items the bank recorded that your books have not, such as charges, interest, direct credits and debits and dishonoured cheques, need a journal entry, and so do mistakes in your own entries. Timing items and bank errors need none in your books.
Ledger Balance vs Available Balance: Which One Goes Into a Bank Reconciliation?
Use the ledger (book) balance printed on the statement for the reconciliation date. The available balance in net banking can be higher or lower because of liens, holds, pending debits, uncleared items and any overdraft limit, so it is not the figure your cash book should agree with.
Matched, Categorised or Manually Added: What Do These Zoho Books Bank Statuses Mean?
Zoho Books gives every bank transaction one of three labels. Matched means the statement line is linked to an entry you already recorded, Categorised means the entry was created from the line, and Manually Added means you keyed it in yourself. Mixing them up is the most common way a receipt gets counted twice.
I Have Months of Unreconciled Bank Statements: Where Do I Start?
Do not start with this month's statement. Fix a verified starting point, a month whose bank balance you can confirm, then reconcile month by month forward, carrying open items with you, and only then deal with the oldest exceptions.
My Bank Gives Me Only PDF Statements: How Do I Reconcile Them With My Books?
Before converting a PDF statement, look for a CSV or Excel download in net banking or ask your branch for one. If there is truly no other option, convert the PDF, and always check the converted file against the statement's opening and closing balance before you reconcile.
A Payment I Recorded Is Not in My Bank Statement, or It Came Back: What Happened?
When a payment you recorded is missing from the bank statement, it is usually still pending, returned to your account, paid from a different account, or a cheque the supplier has not presented yet. The statement line, the UTR and the dates tell you which.
Where Does a Post-Dated Cheque Go in Your Books, and Does It Appear in the BRS?
A post-dated cheque is a promise, not a payment, until the date written on it. Keep it in a PDC register, record it in the books on the cheque date, and it can only become a BRS reconciling item after that date if it is still uncleared.
What Are the Reconciliation Beginning Date and Opening BRS in TallyPrime?
TallyPrime reconciles a bank ledger only from its Reconciliation Beginning Date, which defaults to the first day of the financial year. Anything older that was never cleared has to be entered as Opening BRS, or it leaves a difference that never goes away.
The Same Amount Appears Twice: Is It a Duplicate in My Books or a Double Debit by the Bank?
When the same amount appears twice, first check which record shows it twice. Twice in your books only means a duplicate voucher or double import. Twice in the bank only means a double debit, a retry or a reversal pair. Twice in both may be two genuine payments.
Stale Cheque in India: When Does a Cheque Expire and What Happens in Your Books?
A cheque in India is valid for three months from the date written on it. After that it is stale: the bank will not pay it. If you issued it and it was never presented, reverse the payment in your books and pay the party again by a fresh cheque or NEFT.
TallyPrime Auto or Manual Bank Reconciliation: Which Should You Use?
In TallyPrime's manual mode you enter a Bank Date on each entry. In auto mode you import the statement, Tally links exact matches and suggests potential ones, and whatever stays Available Only in Books or Available Only in Bank is yours to resolve.
What Is a Deposit in Transit? Cheques You Have Banked but the Bank Has Not Yet Credited
A deposit in transit is a cheque or cash you deposited and entered in your cash book that the bank had not credited by the statement date. Your cash book is therefore higher than the passbook. In a BRS starting from the cash book you deduct it, and it normally clears in the next statement.
What Is an Outstanding (Unpresented) Cheque in a Bank Reconciliation?
An outstanding or unpresented cheque is one you issued and entered in your cash book that the payee has not banked or the bank has not yet paid. Your books show the money gone; the passbook does not. In a BRS starting from the cash book you add it back.
What Is the Bank Date in TallyPrime, and Why Does It Decide Whether an Entry Is Reconciled?
The Bank Date in TallyPrime is the date the bank actually processed a transaction. In manual reconciliation an entry counts as reconciled only once it has a Bank Date; until then it stays on the unreconciled list.
Why Does My Bank Reconciliation Go Wrong Only at Month-End?
Month-end differences come from cut-off. Entries made in the last few days of the month often reach the bank in the next month, and the bank posts some items, such as quarterly charges and interest, on the final day before you have entered them.
Why Do Some Items Stay Unreconciled for Months, and How Do I Clear Them?
Items stay unreconciled for months when nobody owns them or when someone outside the business has to act. Clear each by type: reverse a stale cheque, chase a deposit, book a missing entry, fix an error, or park a true unknown in suspense with an owner and a date.
Why Is My Bank Balance Different From My Cash Book?
The bank balance and the cash book differ for three reasons: timing (cheques not yet presented or credited), items the bank has recorded that you have not (charges, interest, direct debits and credits), and mistakes on either side. A bank reconciliation statement lists each one.
Why Is My Bank Account Showing a Negative Balance in My Books?
A bank ledger goes negative in your books when payments are entered before the receipts that fund them, an opening balance or deposit is missing, a payment is posted to the wrong bank, or the account really is an overdraft or cash credit facility.
Why Does My TallyPrime Bank Reconciliation Show a Difference?
TallyPrime's Difference line is the Expected Bank Balance minus the balance as per bank statement. It is not zero when entries sit on one side only, Opening BRS is missing, or the beginning date cuts off older items.
Why Won't TallyPrime Import My Bank Statement? CSV, Excel, PDF and Supported Banks
TallyPrime's help says it imports bank statements only as CSV or Excel files downloaded from the bank portal, for supported banks. PDF files, and CSV or Excel files converted from PDF, are not accepted.
Why Does the Balance in Zoho Books Differ From My Bank Balance?
When Zoho Books and your bank show different balances, the cause is usually one of four things: statement lines not yet matched or categorised, a manual entry that duplicates a feed line, activity older than the 90-day feed window, or an opening balance that never agreed with the bank.
Zoho Books Bank Feeds or Statement Import: Which Should You Use, and Why Do Duplicates Appear?
Bank feeds in Zoho Books pull transactions automatically through a banking service provider for supported banks. Statement import takes a file you download. Use feeds for daily work and import to fill gaps, and check duplicates against the real statement before excluding them.
Why Does My Bank Statement Show a Credit I Cannot Match?
A ₹47,236 credit shows up on the HDFC current account, no counterparty in the narration, no candidate invoice on the accounts-receivable ledger. It is almost always one of seven things. This is the plain-language walk through each one and where to look on the ledger to close it out.
Axis Bank Corporate Statement Reconciliation: CIB, NEFT/RTGS, MT940 for Indian Treasury
Axis Bank is one of the most widely used corporate banking partners for Indian treasuries. Its Corporate Internet Banking (CIB) platform delivers statements as CSV, PDF, and MT940 — each with distinct narration shapes, cut-off behaviour, and parse traps. This guide covers Axis CIB export options, MT940 structure, NEFT/RTGS/NACH narration patterns, holiday cut-off handling, and intra-day versus end-of-day balance reconciliation.
Bank Statement Narration Pattern Classification: A Library for Indian Treasury Teams
Bank statement narrations in India are not standardised. Each bank — HDFC, ICICI, SBI, Axis, Kotak, Yes, IndusInd, PSU banks — uses a different prefix and field order for the same transaction type. Treasury teams that build a reusable narration classification library cut reconciliation exceptions by 60 percent or more. This guide documents 18 common narration families, the anchor tokens that identify them, and the match-key extraction logic that makes them usable downstream.
Bank Statement OCR vs Machine-Readable Formats: When to Use Which for Indian Reconciliation
Most Indian banks now offer CSV, Excel, or MT940 downloads through corporate NetBanking — but a non-trivial share of statements still arrive as PDFs, including scanned dot-matrix prints from PSU branches, password-protected exports from older cooperative bank portals, and image-only PDFs uploaded by clients. The choice between OCR and machine-readable ingestion is not a single decision; it is per source, per period, and per accuracy requirement. This guide covers when OCR is necessary, what accuracy bands to expect, where format degradation hurts most, and how to combine PDF and CSV pulls for the same period to backstop coverage.
IDFC FIRST Bank Corporate Reconciliation: Statement Formats and Narration Conventions
IDFC FIRST Bank has grown rapidly as a corporate banking partner for mid-market enterprises and NBFCs in India. Its corporate portal, MT940 export, and connected banking APIs have distinct statement structures and narration formats that affect how reconciliation systems extract UTRs, match counterparties, and explode NACH batches. This guide covers IDFC FIRST corporate statement formats, narration conventions by transaction type, and configuration details for reliable automated reconciliation.
Kotak Mahindra Bank Corporate Statement Reconciliation
Kotak Mahindra Bank serves a growing share of mid-market and NBFC corporate accounts in India. Its Kotak FYN corporate portal exposes statements through CSV, MT940, and structured collection reports, with bank-specific narration shapes for NEFT, RTGS, NACH, and bulk batch payments. This guide covers Kotak FYN export options, MT940 structure, narration patterns by transaction type, batch payment IDs, fee debit handling, and the GST and TDS treatment that reconciliation systems must encode.
MT940 vs CAMT.053 vs MT942: Format Comparison for Indian Bank Statement Reconciliation
SWIFT's CBPR+ migration to ISO 20022 reached its November 2025 cutover, ending the parallel-run window for cross-border MT messages. For Indian treasury teams, the practical question is which statement format — MT940, CAMT.053, or MT942 — to consume from each bank, and how to plan reconciliation parsers for the multi-year tail of mixed-format delivery that follows. This guide compares the three formats on structure, content, delivery cadence, and reconciliation implications, with specific notes for HDFC, ICICI, SBI, and PSU bank deliveries.
Multi-Bank Cash Position Reconciliation for Indian Treasury Teams
Treasury teams at mid-market and enterprise Indian companies typically operate 8 to 12 current accounts spread across HDFC, ICICI, SBI, Axis, Kotak, IndusInd, Yes Bank, and one or two PSU banks. Cash position reconciliation across this footprint determines what gets swept overnight, what funds short-term liquidity, and what sits idle losing yield. This guide covers the mechanics of multi-bank cash position reconciliation: sweep arrangements, intraday MT942 ingestion, virtual-account collections, deposit-versus-CMS view alignment, and idle balance identification.
Yes Bank Corporate Statement Reconciliation
Yes Bank serves a large book of mid-market and SME current accounts in India, with corporate banking delivered through its YES Connect (host-to-host) and YES Online (corporate portal) channels. The bank's statement formats, narration conventions, and the 2020 reconstruction event each have specific implications for reconciliation engineers. This guide covers Yes Bank corporate statement formats, narration patterns by transaction type, host-to-host options, and the legacy account-number considerations finance teams should plan for.
CARO 2020 and Bank Reconciliation: Audit Requirements for Indian Companies
Clause 3(ii)(b) of CARO 2020 requires auditors to report whether quarterly statements filed with banks agree with books of account for companies with working capital limits exceeding ₹5 crore. Finance teams that treat bank reconciliation as a month-end formality face audit qualifications, material weakness disclosures, and GST exposure from unreconciled bank credits.
Bank Charges Reconciliation in India: Service Fees, GST on Charges, and Auto-Debit Matching
Bank charges — service fees, NEFT and RTGS transaction charges, cheque book charges, annual maintenance fees, and GST on all of the above — are among the most consistently mismatched items in Indian bank reconciliation. They arrive as auto-debits without prior invoice, carry GST at 18%, and must be allocated to the right expense ledger. This guide covers how bank charge reconciliation works in India and why it generates disproportionate exceptions.
Bank Statement Narration Patterns in India: How Reconciliation Systems Parse Them
Narration-based matching is the core challenge in Indian bank reconciliation. NEFT, RTGS, IMPS, UPI, and NACH credits each arrive with different narration structures from different banks — and none follow a single national standard. This guide covers the narration patterns from major Indian banks, how reconciliation systems extract match keys, and where narration parsing fails.
HDFC Bank Reconciliation: Statement Formats, CMS API, and Narration Patterns
HDFC Bank is the most widely used bank for enterprise current accounts in India. Its NetBanking, CMS (Cash Management Services), and MT940 export have specific narration formats and field structures that affect how reconciliation systems parse and match transactions. This guide covers HDFC Bank statement types, narration structures, CMS integration, and configuration details for automated reconciliation.
ICICI Bank Reconciliation: CIB Statement Format and Enterprise Account Matching
ICICI Bank's Corporate Internet Banking (CIB) platform has specific statement export formats and narration structures that affect enterprise reconciliation. ICICI's MT940 implementation uses /TXT/ prefix in the :86: tag — different from HDFC's /INF/ — and its NEFT/RTGS narrations follow a format that requires specific parser configuration. This guide covers ICICI Bank statement types, narration patterns, and what enterprise finance teams should configure for automated reconciliation.
MT940 Bank Statement Format in India: How It Enables Automated Reconciliation
MT940 is the SWIFT message format used by India's leading banks for enterprise statement export. Unlike PDF or CSV downloads, MT940 delivers structured, parseable transaction data that reconciliation engines consume directly — no screen-scraping, no manual field extraction. This guide covers how MT940 works, which Indian banks support it, and what it changes for automated bank reconciliation at scale.
Opening Balance Reconciliation in India: Resolving Month-Start Discrepancies
Opening balance reconciliation is the first control check of every new accounting period — confirming that the opening balance in the books matches the prior period's closing balance. For Indian companies running monthly reconciliation across multiple bank accounts, GST ledgers, and TDS receivables, opening balance discrepancies are the first detection point for prior-period errors that were not resolved. This guide covers the common causes and resolution sequence.
Salary and Payroll Bank Reconciliation in India: Bulk Transfer Matching and TDS Alignment
Salary disbursements generate some of the largest single-day bank debits for Indian companies — and some of the most persistent reconciliation exceptions. A bulk salary NEFT to 400 employees appears as a single bank debit but must align with an itemised payroll register that includes TDS deductions (Section 192), PF contributions, ESI deductions, and professional tax. This guide covers how salary payroll bank reconciliation works and where it breaks.
SBI Bank Reconciliation: Government Account Formats, YONO Business, and Statement Parsing
State Bank of India (SBI) is the primary bank for PSUs, government-linked companies, and many large Indian enterprises. Its YONO Business platform, CMP (Cash Management Product) service, and statement formats differ from private banks — particularly for government credits: PFMS disbursements, GST refunds, subsidy receipts, and TDS challan payments. This guide covers SBI bank reconciliation for enterprise finance teams.
See how TransactIG handles reconciliation for your industry
TransactIG is configurable for your ERP, your bank feeds, and your compliance requirements. Most implementations complete in 2–4 weeks without code development.