Bank Statement Reconciliation: A Habit Our Mill Runs Weekly

Why Our Mill Does It Weekly, and You Can Do It Monthly

In a business, money moves every day: farmers and suppliers are paid, buyers pay on credit terms, and collections go back against the cash credit balance. Our accountant comes in about once a week, and the bank reconciliation is part of that visit. The reason is simple. A difference found within a week usually has an obvious explanation, because someone still remembers the payment. The same difference found at year-end is a small investigation.

There is a second reason, and it is the one I care about more. Our CA and our bank only ever see the figures on paper, so every figure that leaves the mill for them rests on the books being right. A reconciled bank account is the cheapest proof there is that the books are real. A reconciliation you skip does not go away. It waits, and it comes due when the bank next asks for figures, usually in the busiest week of the year.

A household has far fewer transactions, which is why monthly is the right rhythm for most people. The principle is the same at any size. A budget built on an unreconciled account is a guess with a spreadsheet around it.

A Debit You Don't Recognise

Step 1: Give it 24 hours. Sometimes a transaction has an unfamiliar description but is perfectly legitimate: a grocery store's parent company name, or a digital payment that doesn't show the merchant clearly.

Step 2: Search the description online. "ABCD PAYMENTS PVT LTD" might be the backend for a specific service or subscription.

Step 3: Check your UPI app or card statement. UPI apps often have cleaner merchant names than the bank statement. Your card issuer may also have a more detailed transaction description.

Step 4: If still unrecognised and the amount is significant, flag it.

• For debit card fraud: Call your bank's customer care immediately, report the fraudulent transaction, and request a chargeback
• For UPI fraud: Report through NPCI's UPI Help or through your bank app
• For subscription you forgot about: This is your chance to cancel

Reporting promptly matters for more than convenience: RBI's rules on customer liability for unauthorised electronic transactions reduce or remove your liability only if you report within the timelines the bank specifies. The longer an unrecognised debit sits unreported, the weaker your position.

Step 5: If your bank or NPCI doesn't resolve it. You have a further, cost-free escalation path: the Reserve Bank Integrated Ombudsman Scheme (RB-IOS). It exists specifically for complaints against a bank or RBI-regulated entity that went unresolved or were resolved unsatisfactorily, and needs no lawyer or fee. File it only after your bank or NPCI has had a fair chance to respond; it isn't a first-contact channel.

Never ignore an unrecognised debit. Small unauthorised charges, ₹99 here and ₹199 there, are how subscription scams and card-testing attacks work. Finding them monthly means they don't accumulate. The wider defences are in protecting yourself from financial fraud.

Cash, Cards and UPI Apps

The ATM cash problem

ATM withdrawals are the greyest area in reconciliation. You know money came out, but unless you tracked what the cash was spent on, it disappears into "cash spending".

Option 1: Accept it as a residual. If ATM withdrawals are small (under 5% of your monthly spending), record them as "Cash/Misc" and move on. Don't let perfect be the enemy of done.

Option 2: Keep a cash register. A small notebook or a notes app where you log what you spend cash on. At month-end, assign these to categories and reconcile the ATM withdrawal against the cash log.

Option 3: Eliminate cash. Move all spending to UPI and card. It is not always possible (local kirana stores, auto-rickshaw fares), but the closer you get, the cleaner the reconciliation.

Credit card reconciliation

If you use a credit card, add a separate reconciliation for it. The card statement shows every charge, and each one should be:

1. Individually recognisable and legitimate
2. Categorised in your expense log (charge was made when the purchase was made, even if the bill comes later)
3. Matched against your bank statement's credit card payment (you should be paying the full outstanding balance each month, not just the minimum)

The two statements reconcile with each other: the card payment debit on the bank statement should match the credit on the card statement.

Several UPI apps: PhonePe, GPay and Paytm

If you pay from more than one UPI app (PhonePe linked to one account, Google Pay to another), pull the transaction history from each app as well as the bank statement. The statement records the amounts but often shows only the UPI transaction ID; the app (PhonePe, GPay, Paytm, BHIM) shows the merchant name, amount and date in a readable form. Use both:

1. Download the bank statement and note all UPI debits for the month.
2. Open each UPI app's transaction history for the same period.
3. For any UPI debit where the bank statement shows an unclear merchant description (e.g., "UPI/218394758291/"), cross-reference the transaction ID in the UPI app to identify the merchant.
4. Categorise the transaction once you have the merchant name.

This takes 5–10 minutes for a typical month with 30–50 UPI transactions and removes the "unknown merchant" problem that leaves many people's categorisation incomplete. If the accounts themselves are multiplying, a system for tracking multiple bank accounts helps.

Reading the Codes on an Indian Statement

Indian statement descriptions are often cryptic. The most common formats:

NACH and ACH debits on specific dates are almost always SIPs, insurance premiums, or EMIs. Cross-reference them with your automation checklist to confirm each one is a payment you expect.

Getting the statement into Google Sheets

Most Indian banks offer a CSV download. The usual paths:

HDFC Bank: Log in to net banking → My Accounts → Account Statement → Select date range → Download CSV. The CSV has columns: Date, Narration, Withdrawal Amount, Deposit Amount, Closing Balance.

ICICI Bank: Net banking → Accounts → Account Summary → View Statement → Download (choose Excel or CSV). ICICI's export has similar columns.

SBI: Net banking → Account Statement → Request e-Statement → Choose period → Download CSV.

Axis Bank: Net banking → Accounts → Transaction History → Download → CSV format.

In Google Sheets, go to File → Import and upload the CSV. Then clean it for reconciliation:

• Remove any header or footer rows the bank adds (such as the account summary at the bottom)
• The "Narration" or "Description" column holds merchant names, NACH identifiers and UPI transaction IDs, and these need categorising
• Add a "Category" column next to the transaction columns and categorise each row

Once every row has a category, one formula gives you the monthly total for each: =SUMIF(CategoryColumn, "Food", AmountColumn)

SIPs: Two Records for One Investment

A SIP produces two events, a bank debit and a mutual fund unit allocation, and reconciling both confirms the investment actually happened.

Bank side: The NACH debit appears on your bank statement. Amount, date and mandate description should match your expected SIP amount.

AMC side: The unit allocation confirmation arrives by email from the AMC within 2–3 business days of the debit. The email (or the AMC's portal) shows the fund name, date, NAV at which units were allocated, number of units, and total units after the purchase.

If the bank debit happened but no allocation email arrived, check the AMC portal directly. It is rare but does happen, particularly when the bank mandate failed silently and the debit was an error, or when the AMC is slow to process. If units are not allocated within 5 business days, contact the AMC customer care.

The Annual Statement

Monthly reconciliation uses the monthly statement to catch errors and categorise spending. The annual statement, a full financial year's transactions, serves a different purpose: it is the definitive input for ITR filing, loan applications and interest income.

When you need the annual statement (not monthly):

• ITR filing: Your CA or tax software needs bank statements to cross-check TDS credits, interest income and dividend inflows against what is declared. Request a PDF or CSV of the full financial year (April to March) from your bank and file it under /Taxes/AY[year]/ in your document system. The matching itself is covered in Form 16 vs AIS vs Form 26AS.
• Home loan application: Banks typically require the last 12 months of salary account statements for a home loan. Clean, consistently filed monthly statements mean you can produce a full year at once instead of requesting it retroactively.
• FD interest and TDS: If you hold FDs, interest is credited to your savings account and appears on the annual statement. Cross-checking it against your Form 26AS confirms whether the bank has correctly deducted and reported TDS on the interest.

Downloading the annual statement: Most banks support a date-range download spanning a full financial year. In HDFC Bank net banking: Accounts → Account Statement → Select from April 1 to March 31 → Download PDF or CSV. Do this for all active accounts by the end of April each year.

Three Problems It Catches

Reconciliation is not just bookkeeping. It catches problems that would otherwise go unnoticed:

Case 1: the forgotten subscription. During reconciliation you notice a ₹499/month charge to "NETFX INDIA PVT LTD" that you don't recognise. A search shows it is an OTT platform you signed up for during a trial. You have been paying for 8 months without watching anything: ₹3,992 gone. Cancel immediately. Without monthly reconciliation you would keep paying indefinitely. A subscription and renewal tracker stops the next one.

Case 2: the double-charged EMI. Your home loan EMI is ₹28,500. During reconciliation you notice two NACH debits for the same amount on the same date, one from your loan account and one from what appears to be the same lender. You contact the lender, who confirms a duplicate debit and credits the excess back within 5 business days. Skip reconciliation for three months and you would have missed three months of double debits.

Case 3: the SIP that didn't run. Your equity SIP should run on the 5th. The reconciliation shows no NACH debit for it on the 5th of last month, yet the balance looks normal and no failure SMS arrived. On the investment platform, the SIP did fail silently (the SMS never reached you because of a network issue). You buy the missed instalment manually. Without reconciliation, that month's investment would simply have been missed.

These are not rare scenarios: over 2–3 years of monthly reconciliation, most people meet at least one of them. The 20–30 minutes a month is the cost; catching real money problems is the return.

Making It Faster

Monthly is the right cadence for most people. Go weekly if your transaction volume is high or you are actively managing a tight budget.

The first reconciliation always takes longest. If you have never done this, the first month of categorising every transaction from scratch takes 2–3 hours. The second month takes 60–90 minutes. By month three, if you roughly categorise transactions in real time through your UPI app, the monthly reconciliation takes 20–30 minutes.

Import statements directly into Google Sheets. Once the data is in, a VLOOKUP or a filter finds uncategorised items quickly.

The habit changes how you relate to money. You know, specifically, where it went. That knowledge, not discipline and not restriction, is the foundation of every financial improvement, and it is the same knowledge a business buys when it pays someone to reconcile its books every week.