Bank Reconciliation: The Complete Guide for Indian SMEs (2026)

Bank reconciliation is one of the oldest accounting practices, and it remains one of the most important. For Indian SMEs managing multiple bank accounts, UPI transactions, and high-volume NEFT/RTGS payments, a structured reconciliation process is the foundation of accurate financial reporting. This guide covers everything from manual BRS preparation to auto-matching logic.

What Is Bank Reconciliation?

Bank reconciliation is the process of comparing your internal cash book (or accounting ledger) with your bank statement to ensure both records agree. The Bank Reconciliation Statement (BRS) is the output — a document that lists all differences between the two and explains why they exist.

The core idea is simple: your books and the bank's books should show the same balance. In practice, they rarely do on any given day because of timing differences — cheques issued but not yet cleared, deposits in transit, bank charges not yet recorded, and direct debits you haven't accounted for.

The BRS bridges that gap. It starts with the balance per your books, adjusts for timing differences, and arrives at the balance per the bank statement — or vice versa. If the adjusted balances match, your reconciliation is clean.

Why Bank Reconciliation Matters

• •Cash accuracy: Your management reports are only as good as your cash balance. Unreconciled entries mean your reported cash position is wrong, which affects every decision that depends on available funds.
• •Fraud detection: Unauthorized transactions, forged cheques, and skimming are detected faster through reconciliation. If a withdrawal appears on the bank statement but not in your books, that's an immediate red flag.
• •Audit readiness: Auditors will examine your BRS. Unreconciled items older than 30 days invite scrutiny. Regular reconciliation keeps your books clean and audit-ready.
• •GST and tax compliance: Bank transactions feed into GST returns and income tax computations. Unrecorded income or expenses can lead to under-reporting or over-reporting.
• •Vendor and customer trust: Knowing exactly what's been paid and received lets you resolve disputes quickly. No more guessing whether a payment went through.

Bank Statement Formats in India

Indian banks provide statements in various formats, and each has its quirks. Understanding these is essential for automated reconciliation:

ICICI Bank

Provides CSV and XLS formats. Date format is typically DD/MM/YYYY. The narration field includes UTR numbers for NEFT/RTGS, UPI reference IDs, and cheque numbers. Withdrawal and deposit are in separate columns. Statement downloads are available via corporate internet banking with date range selection.

HDFC Bank

CSV exports use DD/MM/YY date format. The description field combines transaction type and reference number. Closing balance is provided for each row. HDFC's corporate portal allows automated statement pulls via host-to-host integration for high-volume accounts.

State Bank of India

SBI provides statements in a slightly different CSV layout. Date format varies between branches (DD-MM-YYYY or DD/MM/YYYY). The narration field structure depends on transaction type — NEFT narrations include beneficiary name and remitter info. Columns may include a running balance.

Kotak Mahindra Bank

Excel format with DD-MMM-YYYY dates (e.g., 15-Mar-2026). Narration field is well-structured for NEFT/RTGS with clear UTR references. Debit and credit in separate columns. One of the cleaner formats for automated parsing.

Axis Bank

Provides CSV and PDF. CSV uses DD-MM-YYYY format. Transaction description includes mode (NEFT/RTGS/UPI/IMPS) as a prefix, making it easier to categorize. Balance column is cumulative.

Step-by-Step Bank Reconciliation Process

Here is the manual reconciliation process, which forms the basis for understanding what automated tools do:

• •Step 1: Obtain the bank statement for the period — typically month-end, but can be weekly for high-volume accounts.
• •Step 2: Export your cash book / bank ledger from your accounting software for the same period.
• •Step 3: Compare the opening balance. If these don't match, last month's reconciliation has an issue — resolve that first.
• •Step 4: Tick off matching entries. Go through each bank statement line and find the corresponding entry in your cash book. Mark both as reconciled.
• •Step 5: List unmatched entries from the bank statement — these are items in the bank but not in your books (bank charges, interest, direct debits, unrecorded credits).
• •Step 6: List unmatched entries from your cash book — these are items in your books but not yet in the bank (uncleared cheques, deposits in transit, NEFT/RTGS initiated but not yet processed).
• •Step 7: Prepare the BRS — start with your book balance, add/subtract the differences, and arrive at the bank balance (or vice versa).
• •Step 8: Record adjusting entries in your books for bank-side items you hadn't recorded (charges, interest, etc.).

Common Reconciliation Items

Outstanding Cheques

Cheques you've issued and recorded in your books but the payee hasn't deposited yet. These reduce your book balance but the bank still shows the higher amount. Track cheques outstanding for more than 90 days — they may need to be reversed (stale cheques).

Deposits in Transit

Cash or cheques deposited at the bank but not yet credited to your account. Common with outstation cheques which can take 2-3 days to clear.

Bank Charges and Fees

Account maintenance charges, transaction fees, SMS alert charges, cheque book charges, and GST on banking services. These appear on the bank statement but may not be in your books until you see the statement. Record them as expenses with the correct GST treatment.

Interest — Earned and Paid

Interest on deposits (current accounts rarely earn interest, but FDs and savings accounts do) and interest on overdraft/CC facilities. TDS on interest income (Section 194A) is also deducted by the bank — record both the gross interest and TDS.

Direct Debits and Standing Instructions

EMI payments, insurance premiums, utility bills on auto-debit, and NACH mandates. If you haven't set up recurring entries in your books, these will be bank-only items each month.

UPI Transactions

UPI collections and payments settle almost instantly, but the volume can be high. Each UPI transaction has a unique reference ID. For businesses receiving many UPI payments (retail, e-commerce), reconciling individual UPI entries against sales invoices is a significant task.

How Auto-Matching Works

Automated bank reconciliation uses algorithms to match bank statement lines to cash book entries. Here's how the matching typically progresses:

Exact Match

Same date, same amount, same reference number. This catches 60-70% of entries in most businesses. NEFT/RTGS transactions with UTR numbers are the easiest to match exactly.

Fuzzy Match

Same amount but slightly different dates (bank processing delay) or similar reference numbers (with/without prefixes). Fuzzy matching uses configurable rules — for example, allow a 2-day date tolerance and ignore hyphens in reference numbers.

Amount Tolerance Match

Useful for matching payments where bank charges have been deducted, or where TDS has been withheld by the payer. If you invoiced ₹1,00,000 and received ₹98,000 (after 2% TDS), an amount tolerance rule can suggest this as a potential match.

Multi-Line Matching

Multiple cash book entries matching a single bank line, or vice versa. Common when a customer pays multiple invoices in one NEFT transfer, or when the bank combines daily UPI collections into a single credit entry.

Handling Unmatched Entries

After auto-matching, the remaining unmatched entries need investigation:

• •Bank charges and interest: Record in your books as expenses/income. Set up recurring entries for predictable charges.
• •Customer payments not in books: Check if a sales invoice is missing. Could be an advance payment or payment against a different entity.
• •Payments not yet in bank: Verify the payment was actually initiated. Check with the bank if NEFT/RTGS has been processed.
• •Unknown credits: Investigate immediately — could be a customer payment, refund, or erroneous credit. Contact the bank if you can't identify it.
• •Unknown debits: Could be an unauthorized transaction. Flag for immediate investigation.

Monthly vs Daily Reconciliation

The right cadence depends on your transaction volume and business type:

• •Daily reconciliation suits: businesses with 50+ transactions per day, e-commerce sellers, companies with cash collections, businesses with overdraft/CC facilities where daily interest accrues
• •Weekly reconciliation suits: mid-size businesses with 20-50 daily transactions, B2B companies with regular NEFT/RTGS flows
• •Monthly reconciliation suits: small businesses with fewer than 20 transactions per day, service companies with predictable payment patterns
• •Regardless of cadence: always do a formal reconciliation at month-end for reporting and audit purposes

Bank Reconciliation in Excel vs Software

Excel is a natural starting point and works for low-volume reconciliation:

• •Excel works for: single bank account, fewer than 100 transactions per month, one person doing reconciliation
• •Excel limitations: VLOOKUP-based matching breaks with format inconsistencies, no audit trail of who matched what, version control is manual, multi-line matching is nearly impossible to automate in Excel
• •Software advantages: automated statement import (multiple bank formats), configurable matching rules, exception tracking with aging, audit trail of every match/unmatch action, multi-bank consolidation

The tipping point is usually around 200-300 transactions per month or when you manage more than 2 bank accounts. At that point, the time spent on manual Excel reconciliation exceeds the cost of dedicated software like ReckOps.

Best Practices

• •Standardize narration fields: When making payments, use consistent descriptions (e.g., always include invoice number in NEFT remarks). This makes auto-matching much easier.
• •Record bank charges immediately: Don't wait for month-end. Set up a process to record bank charges weekly.
• •Investigate old outstanding items: Any unmatched item older than 30 days needs attention. Stale items accumulate and make reconciliation progressively harder.
• •Separate reconciliation by bank account: Don't combine multiple accounts into one BRS. Reconcile each account independently.
• •Maintain a reconciliation calendar: Set specific dates for downloading statements, running matching, and resolving exceptions.
• •Review the BRS with a second pair of eyes: The person reconciling shouldn't be the only one reviewing exceptions. Segregation of duties matters.

Frequently Asked Questions

What if my opening balance doesn't match?

Go back to the previous month's reconciliation. The closing balance of last month's BRS should be the opening balance for this month. If there's a discrepancy, resolve last month's reconciliation first — carrying forward an error compounds the problem.

How do I handle bank-to-bank transfers?

Use a transit account (sometimes called a clearing account) in your books. When you transfer from Bank A to Bank B, debit the transit account from Bank A and credit it from Bank B. This prevents double-counting and makes reconciliation of both accounts clean.

Should I reconcile petty cash the same way?

Yes, but with a physical count. Compare the petty cash register to the actual cash on hand. The principles are the same — match every entry, investigate differences, and maintain documentation.

How do I reconcile UPI collections from payment gateways?

Payment gateways like Razorpay or PayU settle in batches — multiple individual UPI payments combined into one bank credit. You need the gateway's settlement report to break down the lump sum into individual transactions for matching against your invoices.

What's the difference between BRS and bank reconciliation?

Bank reconciliation is the process; BRS is the output document. The BRS summarizes the differences between your book balance and bank balance at a point in time. Think of it as the reconciliation report.