ICICI Bank Statement to CSV: A Practical Guide

There is usually a deadline attached to this job. An ITR filing that needs a year of interest credits, a home loan file where the lender asked for six months of transactions, a bookkeeping backlog, or an account you closed two years ago and now have to account for. What you have is an ICICI Bank statement, and what you need is a spreadsheet.

Sometimes ICICI hands you something spreadsheet-shaped directly. Often — for emailed e-statements, for anything a client or a relative forwarded you, for accounts you can no longer log into — you have a PDF and nothing else. This guide covers both routes, the parts of ICICI's layout that quietly defeat generic converters, and how to prove the result is complete.

Quick answer

Two paths get ICICI transactions into CSV:

1. Take ICICI's own statement download. With Internet Banking or iMobile access you can pull a statement for a date range. For personal savings accounts what you get is generally a password-protected PDF; spreadsheet-friendly delivery formats are offered on the business and corporate side rather than to retail customers.
2. Convert the PDF. For e-statements, older periods, closed accounts and third-party statements, the PDF is the only artefact that exists. Upload it to a converter like BankStatementKit, which reads the transaction table and balance-checks the output against the statement's own printed figures.

Rule of thumb: if you can log in and ICICI still offers your period, start there. Everything else is a PDF job. There is more on ICICI's layout on the ICICI statement converter page.

Turn an ICICI PDF into a verified CSV

Option 1: ICICI's built-in statement download

If you have Internet Banking access, try the bank first — the data comes from the source.

1. Log in to ICICI Bank Internet Banking, or open iMobile.
2. Go to your bank accounts and open the detailed statement view for the account.
3. Choose the period you need and request the statement or e-statement for that range.
4. Download the file and open it.

Where the built-in download stops

ICICI's own export is the right first move, and it runs out in familiar ways:

• Retail statements arrive as PDFs. ICICI sends personal account e-statements as password-protected PDFs for security. The multi-format delivery options — spreadsheet, text, XML and similar — are positioned for business and corporate customers, not savings-account holders.
• Online history has a limit. Older periods drop off the self-service window, and older periods are exactly what loan files and tax assessments ask for.
• You need a live login. Closed accounts, dormant NRI accounts and statements someone emailed you have no login attached.
• A statement of an account you do not own is never downloadable. Accountants and lenders work almost entirely from client-supplied PDFs.

All four routes end in the same place: a PDF.

Option 2: Convert the ICICI PDF statement to CSV

1. Find the detailed transaction statement rather than a summary view — you want the one with per-row remarks and a running balance.
2. Upload it. If it is an emailed e-statement it will ask for a password; supply it and the file is decrypted in memory and never written to disk.
3. The transactions are read into seven standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance.
4. Read the verification label, then download the CSV.

Convert an ICICI statement

About the password

ICICI's emailed statements are encrypted, and account statements and credit card statements do not use the same rule.

For credit card statements ICICI is explicit: the password is the last four digits of your credit card number. Nothing else — no name, no date of birth. For savings account statements ICICI does not publish a rule, and the third-party guides that claim one contradict each other, so check the covering email ICICI sends with the statement rather than trusting a formula off the internet.

Why ICICI PDFs trip up generic converters

The serial-number column is a trap. ICICI's detailed statement numbers each transaction in a leading column. That looks like a gift to a converter — anchor on the number, read the rest of the line — until a transaction remark is too long for its column and wraps onto a second physical line that carries no serial number and no amounts. Line-oriented extraction turns one transaction into a numbered row plus an orphan fragment, and the orphan usually gets thrown away along with part of the description.

Sweep entries inflate the row count. Accounts linked to a flexi or sweep-in deposit generate autosweep and reverse-sweep movements that print among ordinary transactions. They are real transactions with real amounts, so they belong in the CSV — but they mean "the statement should have about thirty rows" is not a check you can trust. Only the balance chain is.

Withdrawal and Deposit are separate columns. ICICI prints withdrawal and deposit amounts in two distinct columns rather than one signed figure. A converter that flattens them without tracking which column a number came from will flip the sign on every debit in the file, and nothing downstream will complain until a reconciliation fails.

Prove the CSV matches the statement

This is the step people skip, and it is the one that decides whether the file is usable. An ICICI detailed statement gives you two independent checks:

1. The running balance chain. Every row prints a balance. For each row, the previous balance minus the withdrawal plus the deposit must equal the printed balance. One dropped row, one duplicated row, one debit read as a credit — the chain breaks at exactly the row where it happened, and stays broken to the end of the file. That property is what makes it useful: it localises the error instead of just announcing one.
2. The opening and closing balances. The first balance on the statement plus total deposits minus total withdrawals must equal the last. This catches errors the chain would miss if whole blocks went astray, such as a page that failed to parse at all.

By hand this is ten or fifteen minutes per statement and nobody does it twice. BankStatementKit runs both checks on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, with a discrepancy pointing at the row where the numbers stop agreeing.

FAQ

The bottom line

If ICICI still offers your period online, start with the bank's own download. For emailed e-statements, older ranges, closed accounts and client PDFs, convert the file — and insist on a conversion you can check, because the wrapping remarks, the tempting serial-number column and the split withdrawal and deposit columns are precisely where a silent error hides.