Indian bank statements do not share a format. In the 44 printed layouts from 25 banks that we have collected, the same four fields (date, narration, debit or credit, balance) appear under more than a dozen different headings, in different orders, and in one layout the balance is not printed at all. Below is what actually differs, bank by bank, and why it matters when you move a statement into Tally or Excel.
The layouts here are the ones we have seen on real statements. It is a collection, not a census, so a bank can have a layout we have not met yet.
What is the same in every bank statement?
Every statement carries a transaction date, a narration, an amount that is a debit or a credit, and (almost always) a running balance. Everything else varies: what the column is called, where it sits, and whether debit and credit share one column or have two.
How banks name the same column
| Field | Headings we have seen |
|---|---|
| Date | Date, Txn Date, Tran Date, Trans Date, Post Date, Value Date, Transaction Date |
| Narration | Description, Particulars, Narration, Details, Transaction Remarks, Tran. Particulars, Transaction Detail, Transaction Description |
| Cheque or reference | Chq No, Cheque No, Chq./Ref.No., Chq/Ref. No., Ref No./Cheque No., Inst. No, Instrument No, Voucher No., Cheque Details |
| Money out | Debit, Debits, Withdrawal, Withdrawals, Withdrawal (Dr.), Withdrawal Amt., Withdrawal Amount (INR) |
| Money in | Credit, Credits, Deposit, Deposits, Deposit (Cr.), Deposit Amt., Deposit Amount (INR) |
| Balance | Balance, Closing Balance, Closing Bal, Available Balance, Balance(INR), Balance (INR) |
The names are not a reliable guide to meaning. HDFC and Janaseva Sahakari Bank call the running balance “Closing Balance”, though it is printed on every line, not once at month end. Where a bank prints both a Post Date and a Value Date, you have to choose which one your books use.
Where the columns sit
Order changes the meaning of every column that follows, which is why a column-by-position import goes wrong without any visible error.
| Difference | Example from the statements we hold |
|---|---|
| Two dates, in different order | SBI and Indian Bank print Post Date then Value Date. One Central Bank of India layout prints Value Date first, another prints Post Date first |
| Credit before Debit | A Yes Bank statement downloaded through a corporate portal prints Credit, then Debit, then Closing Bal. Nearly every other bank prints Debit first |
| A serial number column | Kotak prints a “#” column, Union Bank prints S.NO, ICICI prints S No. or Sr No, Bank of Baroda’s app statement prints Sr no |
| A branch code column | SBI’s online statement prints one between the reference and the amounts. One Central Bank of India layout prints one straight after the two dates. Axis prints Init. Br at the far right, after the balance |
| Two date columns with different meanings | A Janaseva Sahakari Bank statement prints Date and EntryDate side by side |
| Currency in the heading | ICICI prints “Withdrawal Amount (INR)” in one layout and plain “Withdrawals” in another |
One bank, several layouts
Do not assume that knowing one HDFC or ICICI statement means you know the bank’s statements. The same bank prints different layouts depending on the channel (branch, net banking, app, corporate portal) and the account type.
| Bank | Layouts we hold | What separates them |
|---|---|---|
| ICICI | 6 | “Statement of Transactions” with narration printed around the date line; an account statement with S.no and Transaction ID; a “Detailed Statement” with Sr No; the OpTransactionHistory download; a sweep account with Autosweep and Reverse Sweep columns; and a detailed statement with Tran ID (printed as “Withdrawl (Dr)”) |
| Bank of Baroda | 4 | A space-padded branch print; the bob World app statement; a Finacle “REP31 Customer Account Ledger Report”; and an e-statement with Narration, Chq.No., Withdrawal (Dr) and Deposit (Cr) |
| IDBI | 4 | A monthly “Statement of Transaction”; a Finacle “REP31” ledger with a Tran Id; a net-banking statement with Customer Details and Branch Details blocks; and an internet-banking “Transaction Statement” |
| SBI | 3 | A branch “Statement of Account” with a CIF box; an online “Account Statement”; and an “Account Summary / Welcome” statement |
Quirks that cause wrong entries
These are the layout habits that catch people out when a statement is moved by hand, by copy-paste or by a generic converter.
Narration printed above and below the date line
In an ICICI “Statement of Transactions” and a Bank of Baroda e-statement, a long narration is split around the line that carries the date and amount: some of the words sit on the line above, some below. Copy the rows and the narration lands on the wrong transaction. HDFC wraps its narration below the date line instead, and SBI above it.
No balance column at all
IDBI’s internet-banking “Transaction Statement” prints Sr, Date, Description, Amount and a Type of Cr or Dr, newest first. There is no running balance, so you cannot check the file against the bank’s own arithmetic. Most other layouts print one.
Newest first
Most statements run oldest to newest. A Kotak current sweep account statement, a Dr. Babasaheb Ambedkar bank statement, Karnataka Bank’s online statement and IDBI’s internet-banking statement all run newest first. Anything that assumes the first row is the opening entry reads them backwards.
Overdraft and cash credit accounts
SBI cash credit statements and a Dombivli Nagari Sahakari Bank overdraft statement print negative balances. A credit reduces the figure instead of raising it, so a balance that goes from -5,00,000 to -4,00,000 is a credit of ₹1,00,000.
Minus signs that mean different things
A minus in a Debit or Credit column is a reversal in one Canara layout, and plain debits are written negative in a Kotak one. Read the sign without knowing the bank and you flip the entry.
No heading, wrapped values and fake bold
A Karnataka Bank branch report prints no column heading at all, only a letterhead and the transactions. SBI’s narrow online statement wraps every date over two lines (1 Sep above 2026) and splits figures across lines. A Karnataka Gramin Bank statement prints every word twice, so the date reads 02-04-202602-04-2026 when the text is copied out.
Not a text file at all
Some branch prints are scans or phone photos of paper, not text. Among the statements we hold, SBI, Union Bank, Indian Bank, Bank of Baroda and a district co-operative bank each have at least one. Password-protected files turn up too. For these, the file has to be read as an image before anything else can happen. See converting a scanned bank statement for Tally.
What this means for Tally and Excel
A file that looks right can still be wrong. When the column order shifts, the debit column can hold credits and every figure still looks like a valid amount. The check that catches it is the statement’s own running balance: opening balance plus credits minus debits should equal the next printed balance, row after row. If it does not, a column has moved or a row has been misread.
That is how SmartXtract checks each row of a converted statement. For the format question in Tally itself, see which statement format works best with Tally. To see it on your own bank’s layout, start free with 20 pages, no card, or read how the PDF to Tally import works.
Frequently asked questions
Do all Indian banks use the same bank statement format?
No. Each bank prints its own, and most banks print several, depending on whether the statement comes from a branch, net banking, a mobile app or a corporate portal. The four fields underneath (date, narration, debit or credit, balance) are the same, but the headings, order and layout differ.
Why does the same bank have different statement formats?
Different channels use different reporting systems. A branch print, a net-banking download and an app statement from the same bank can have different column names, different date columns and different ways of wrapping narration. Account type matters too: a current, cash credit or sweep account can print differently from a savings account.
Which bank statement format is easiest to import?
The ones with a clear heading row, one transaction per line, a separate Debit and Credit column and a running balance. A statement that wraps narration over several lines, prints no heading, or has no balance is harder, whichever bank it comes from.
Why is there no balance column in some statements?
Some downloads print only an amount with a Cr or Dr marker, such as IDBI’s internet-banking “Transaction Statement”. With no balance printed, nothing in the file lets you check that every transaction was read correctly.
Do bank statement formats change over time?
Yes. Banks change their statement layouts, and an old statement and a new one from the same account can differ. That is why a template built for one month’s file can fail on the next.
Can I import any Indian bank statement into Tally?
You can get any readable statement into Tally with the right conversion, but the file you start from matters. A PDF has to be read column by column and checked, an Excel download is cleaner, and a scan or photo has to be read as an image first.