Indian bank statement formats explained: dates, Dr/Cr, narration and more
Indian bank statements follow conventions that differ from US layouts in ways that matter for conversion: day-first dates, separate withdrawal and deposit columns, long narration strings full of reference codes, and lakh-style digit grouping.
By Muhammad Sharif · October 2026 · 8 min read
If you convert statements from Indian banks such as HDFC, ICICI, SBI, Axis, Kotak or PNB, you will notice that the layout choices differ from the US statements many tools are designed around. None of these is difficult once you know what to expect, but each can quietly corrupt a conversion if a tool or a spreadsheet makes the wrong assumption. This guide describes the usual conventions. Exact column names and order vary by bank, account type and the year the statement was issued, so treat it as a map, not a specification.
Day-first dates
Indian statements almost always print dates as DD/MM/YYYY, DD-MM-YYYY, DD/MM/YY or as a day with a month abbreviation, such as 05 Apr 2026. A date like 05/04/2026 means 5 April. If you open a CSV of such dates in Excel with a US regional setting, the program reads it as 4 May for any date up to the 12th, and leaves later dates as text. The fixes and detection tests are in our date format guide. As a rule: set your Excel region to match the statement, or convert dates to the unambiguous year-month-day form straight away.
Two dates per row
Many statements show a transaction date and a value date, with the value date sometimes a day or more later (for cheques, clearing and some transfers). Pick one and use it consistently. For reconciling to the closing balance, either will give the same total, but monthly totals may shift at the edges of the month depending on which date you choose. Accountants commonly use the transaction date for categorising and keep the value date for reference.
Withdrawal and deposit in separate columns
A very common layout is:
| Date | Narration | Chq/Ref No. | Value Dt | Withdrawal | Deposit | Closing Balance |
|---|---|---|---|---|---|---|
| 05/04/26 | UPI-SWIGGY-... | 6049… | 05/04/26 | 412.00 | 52,330.18 | |
| 07/04/26 | NEFT CR-ACME LTD-SALARY | N097… | 07/04/26 | 48,000.00 | 1,00,330.18 |
The sample above is invented to illustrate the pattern and is not copied from any bank. Because there is no minus sign anywhere, a line read as plain text has one amount and no sign. Reliable conversion either maps the columns by position or uses the closing balance to infer the direction (balance fell, so it was a withdrawal). See our guide to signs for formula-based methods.
Dr/Cr markers and brackets
Some banks, and many credit card statements, mark the type of entry with the letters Dr (debit) or Cr (credit) after the amount, and sometimes after the running balance too. Elsewhere you may see a trailing minus or brackets. When you convert, make sure the marker survives. The converter on this site recognises CR and DR suffixes and brackets and signs the amount accordingly, but you should still test one withdrawal and one deposit by eye.
Narration: long, messy and full of references
The description column is usually called Narration, Particulars or Transaction Remarks. It combines the payment method (UPI, NEFT, IMPS, RTGS, ATM, POS, ECS, NACH), the counterparty, a reference number and sometimes a note. Several consequences:
- Long narrations wrap onto two or three lines in the PDF. A good converter merges them back into one row; check that wrapped text did not become separate rows.
- Reference numbers can be 12 digits or longer. They sit near the amount columns and can be mistaken for money, so verify that the amount column has two decimal places throughout.
- UPI narrations typically include a handle, such as a VPA, which identifies a person or merchant. Treat exported narrations as personal data.
- For categorising, search on stable fragments like the merchant name rather than the whole string, since the references change every time.
Lakh-style digit grouping
Indian statements often group digits as 1,00,000.00 (one lakh) and 1,00,00,000.00 (one crore), rather than 100,000.00. Excel handles both when the cell is numeric, but if the amount arrives as text with those commas, two things can go wrong: a tool that expects groups of three may misread the number, and a simple Find and Replace of commas needs to happen before converting to a number. Removing all commas and then converting to a number works for both styles. If you want lakh-style display in Excel, apply a custom number format such as [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00 to the cells (the underlying value stays a normal number).
Currency
Amounts are in rupees (INR) and are usually printed without a symbol. Some statements add "INR" in the header only. If you import into accounting software, check that the bank account is set to INR, since an import file that declares a different currency can cause a mismatch. A QBO file made by a converter declares a default currency, so verify it, or use CSV with the mapping screen instead.
Statement types you will meet
- Net banking PDF: downloaded from the bank's site. Text-based, convertible.
- Email statements: often password-protected with a combination such as date of birth, PAN or customer ID. Unlock them in a PDF reader before converting.
- Passbook entries and scanned statements: images, which need OCR and careful checking.
- Bank-stamped statements: paper with a stamp, usually for visas or loans. If the recipient accepts a digital file, ask the bank for an electronically signed PDF instead.
- Mini statements: short ATM or SMS extracts of the last few transactions, not suitable for reconciling.
Conversion checklist for Indian statements
- Confirm the file is text-based and unlocked.
- Convert, then check that the first and last dates fall inside the statement period, to confirm day-first parsing.
- Check that withdrawals are negative and deposits positive, using one example of each.
- Scan the amount column for values with no decimals or unusually long numbers: these are reference numbers.
- Run opening balance plus total equals closing balance, as in our reconciliation guide.
Our bank-specific pages for HDFC, ICICI, SBI, Axis, Kotak and PNB link back to these ideas and let you convert a statement directly.
Frequently asked questions
Can I convert an Indian bank statement to Excel without uploading it?
Yes. The converter on this site reads the PDF inside your browser, so the statement is never sent to a server, and it handles day-first dates and Dr/Cr markers. Text-based PDFs work best.
Why does Excel show my dates as text or in the wrong month?
Your Excel region is probably set to a month-first format. Re-import the CSV with the date column as Text and rebuild dates with a formula, or change the region setting to match the statement.
Do I need to remove the commas in lakh-style numbers?
If the amount is text, yes: remove all commas, then convert to a number. Numbers that Excel already treats as numeric need no change.
