Turn Indian bank statement PDFs into Excel
A year of Indian bank records is usually a stack of PDFs: monthly or quarterly e-statements, branch printouts and whatever a client forwarded. The columns are familiar, withdrawals, deposits and a running balance, but UPI narrations wrap across lines and lakh-grouped amounts paste into Excel as text. Pick your bank for its quirks, or upload a statement.
- Currency
- Indian rupees (INR), lakh grouping
- Date order
- Day first, DD/MM/YYYY or DD-MM-YYYY
- Money columns
- Withdrawals, deposits, balance
- Common imports
- TallyPrime, Zoho Books
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.
Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.
Banks
Indian banks and what their statements do
Public sector banks 6
-
SBI
An ESTMT text emails six months of savings statements, locked with a four-digit code you choose.
-
Punjab National Bank
Registered accounts get a monthly e-statement; OD and CC balances often run below zero, marked Dr.
-
Bank of Baroda
PDFs from bob World Internet or a branch, with lakh-grouped amounts such as 1,25,000.00.
-
Canara Bank
The ai1 app's e-passbook produces statements of up to one year at a time.
-
Union Bank of India
Internet banking offers PDF, XLS or Text; loan statements come in pieces of up to 366 days.
-
Bank of India
The app's quick links give financial-year statements for savings, current, loan and PPF accounts.
Private sector and small finance banks 9
-
HDFC Bank
Statement PDFs open with your Customer ID, and emailed statements come only as PDF.
-
ICICI Bank
Net Banking holds four years of statements; older years survive only as saved PDFs.
-
Axis Bank
Three years online and older copies from a branch; e-statements are password protected.
-
Kotak Mahindra Bank
Statements by financial or calendar year, plus combined statements covering several accounts.
-
IndusInd Bank
The app shows 90 days and IndusNet twelve months; e-statements arrive monthly or quarterly.
-
YES BANK
The consolidated e-statement puts accounts, deposits and Demat holdings in one PDF.
-
IDFC FIRST Bank
The app saves the statement as Excel or PDF, or emails it to your registered email address.
-
Federal Bank
FedNet statements cover up to six months, and the bank publishes how its PDF password is formed.
-
AU Small Finance Bank
NetBanking offers PDF, XLS or CSV; loan, card and term deposit statements are separate files.
Statement layout
How Indian bank statements are set out
Withdrawals, deposits and lakh grouping
Nearly every statement has separate withdrawal and deposit columns beside a running balance, with amounts grouped the Indian way, as in 2,45,000.00. Each row comes out with one signed amount as a plain number, and the balance is recomputed line by line.
Narrations that wrap
UPI, NEFT, IMPS and RTGS narrations carry a reference and the counterparty's name and often run over two or three lines. They are joined into one description, so a search for a UTR or a payee finds the whole transaction.
Locked e-statements
Many banks lock emailed statements: HDFC Bank with your Customer ID, SBI with the code from your ESTMT request. Upload the locked PDF as it is and type the password when asked; it is used only to open the file and is never stored.
Output and review
What comes out, and how it's checked
Each statement becomes rows of date, narration, signed amount and balance, which you can download as Excel, CSV or JSON. The rows are checked from the opening balance to the closing one. Signed in, upload an April to March run of statements for one account and any missing month, overlap or duplicate is flagged before you combine them.
TallyPrime and Zoho Books
-
TallyPrime
Tally's bank statement import (Alt+O > Bank Statement) takes files downloaded from the bank, not ones converted from PDF. Bring converted rows in through an Excel mapping template (Alt+O > Manage > Mapping Templates), or work beside manual bank reconciliation.
-
Zoho Books
Under Banking, choose the account and click Import Statement. For the amount column type, pick 'Single Column with Negative Values', and save the mapping for next month's file.
FAQ
Questions about Indian bank statements
My statement PDF asks for a password. Which one is it?
Can I convert a whole financial year at once?
Will TallyPrime's statement import take the converted file?
Any bank, any country