Convert ICICI Bank Bank Statement to Excel
ICICI’s emailed statement arranges rows as DATE, MODE, PARTICULARS, DEPOSITS, WITHDRAWALS and BALANCE, with a single date per transaction, while the detailed export from net banking adds both Transaction Date and Value Date. The PARTICULARS column is notorious: strings such as ‘UPI/{RRN}/{remark}/{VPA}/…’ wrap across several PDF lines, so a naive copy-paste turns one payment into three broken fragments. Reconstructing a year of ₹ transactions that way means squinting at reference numbers until they blur. SheetMyBank recognises both ICICI variants, reassembles wrapped particulars into single cells, and outputs deposits and withdrawals as proper numbers rather than text — ready for SUM the moment the sheet opens.
Fetch the source file from net banking under Bank Accounts → e-Statements → View Detailed Statement, which officially reaches back four years, or use the iMobile Pay app via Accounts → Statements. The conversion then happens on your own machine — SheetMyBank’s parser runs as client-side code, so the PDF stays where you saved it. With BALANCE printed on every row, each figure gets cross-checked against the prior row plus deposits minus withdrawals, and any mismatch is flagged before it can poison your accounts.
Drop your ICICI Bank statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
ICICI Bank statement FAQ
What password opens an ICICI e-statement PDF?
ICICI’s documented format is the first four letters of your name in lowercase followed by your birth date and month as DDMM — the bank’s own example is suji0501 for Sujit born on 5 January. If it fails, the covering email restates the format applicable to your account.
How far back can I download ICICI statements online?
Net banking’s View Detailed Statement under Bank Accounts → e-Statements officially covers the last four years, which is generous by Indian bank standards. For anything older you would need a branch request, so it is worth converting and archiving those PDFs as Excel while they are available.
Why does my emailed ICICI statement show one date but the net banking export shows two?
The email statement prints a single DATE column, whereas the detailed net banking export includes both Transaction Date and Value Date. SheetMyBank handles either layout and keeps whatever date columns exist, so choose the detailed export if your reconciliation depends on value dating.