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
- Log in to ICICI Bank Internet Banking and go to Accounts, then Bank Accounts, then Statements (or Account Statement).
- Select the account and choose Detailed Statement with a date range. Statements can be viewed and downloaded for roughly the last four years.
- Set the format to PDF and click Download or Generate, then save the file.
- To email it instead, choose Email Statement on the same screen; the mailed copy will be password-protected.
- 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.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
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.