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.

Benchmark vs free tools

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?
It depends on the bank. HDFC Bank uses your Customer ID, SBI the four-digit code you sent with ESTMT, and Federal Bank the first four letters of your name in capitals plus your date of birth as DDMM. The e-statement email usually says which, and you can enter it when you upload the file.
Can I convert a whole financial year at once?
Yes. Upload the monthly or quarterly statements for April to March together and they're compared as a set. Where the bank offers a financial-year statement, as Kotak and Bank of India do, one file is simpler still.
Will TallyPrime's statement import take the converted file?
Not through its bank statement import, which Tally keeps for files from the bank. Use a transactions mapping template, or reconcile by hand with the converted sheet open beside you.

Any bank, any country

Bank statement converter