Skip to content
stmtai

Convert ICICI statement PDFs to Excel, Tally and CSV.
Tally, Zoho Books, Excel files from the PDF.

ICICI's emailed statement PDFs use the first four letters of the account title in lowercase followed by the date and month of birth in DDMM; for a current account it is the date and month of incorporation, and for a joint account it is the first holder's details. Internet Banking offers the detailed statement in PDF, Excel and text as well, and the Excel is usable for a month or two of tidy transactions.

Drop your ICICI statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in INR.

Last updated

How to download a ICICI statement as a PDF

  1. Log in to ICICI Bank Internet Banking and go to Accounts, then Bank Accounts, then Statements (or Account Statement).
  2. Select the account and choose Detailed Statement with a date range. Statements can be viewed and downloaded for roughly the last four years.
  3. Set the format to PDF and click Download or Generate, then save the file.
  4. To email it instead, choose Email Statement on the same screen; the mailed copy will be password-protected.
  5. In iMobile Pay: tap Accounts and Deposits, then the account, then Statement or Email Statement, and pick the period.

Then drop the file above; several months of ICICI statements at once come back as one workbook.

Is the ICICI PDF password-protected?

ICICI's emailed statement PDFs use the first four letters of the account title in lowercase followed by the date and month of birth in DDMM; for a current account it is the date and month of incorporation, and for a joint account it is the first holder's details. Vivek Kumar born 1 February gives vive0102. Type that into the prompt that appears when you drop the file; it is unlocked in your browser and the password goes no further. The Internet Banking download comes unprotected if you prefer.

What ICICI statements look like

Transaction Date, Value Date, Description, Ref No./Cheque No., Debit, Credit, Balance.

ICICI statements print Transaction Date, Value Date, Description, Ref No./Cheque No., Debit, Credit and Balance, and the transaction date is the one that goes into the output. Dates are dd/mm/yyyy. Descriptions are prefixed with the channel: UPI/, NEFT-, IMPS/, BIL/ (for bill payments) or ACH/ for standing instructions, followed by the counterparty and a numeric reference. Balance uses lakh grouping and is shown to two decimals without a Cr or Dr marker, since savings accounts do not go negative. A page holds around 35 rows and a quarterly statement on a busy salary account is commonly 15 to 25 pages; the mini-summary at the top gives opening and closing balance only, no counts.

Why not use ICICI's own export?

Internet Banking offers the detailed statement in PDF, Excel and text as well, and the Excel is usable for a month or two of tidy transactions. It suffers the usual Indian bank export problems: dates come through as text, the two date columns confuse a simple import, and Excel sometimes drops leading zeros in reference numbers. Corporate Net Banking users have a separate e-Statements area under Accounts. The PDF conversion is worth it when you are working from statements a client forwarded, or when you want the balance check that the raw Excel does not perform.

Where ICICI statements trip up converters

  • Two dates per row; the transaction date is used. Lakh-style grouping is handled.

Which software ICICI customers import into

ICICI customers most often import into Tally, Zoho Books, Excel.

ICICI questions

Which date does the Excel use, Transaction Date or Value Date?

Transaction Date. Value Date is kept in a separate column so you still have it for interest calculations, but sorting, month-end cut-offs and the running balance check all use the transaction date, which is what ICICI orders the statement by.

I entered the password and the PDF still will not open.

The letters are lowercase and taken from the account title as ICICI holds it, which may be a shortened or differently spelled name from what is on your PAN. For a joint account use the first holder. If it still fails, download the statement from Internet Banking, which has no password at all.

How do I convert a ICICI statement PDF to Excel?

Download it from ICICI using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many ICICI statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in India

Comparing converters for ICICI statements? 14 tools that name ICICI or its market, side by side, checked October 2026.

All banks and formats · See a sample result