ICICI Bank locks every e-statement it emails you — good for security, annoying when your CA asks for the data in Excel. The fix is to convert your locked ICICI bank statement PDF to Excel through a workflow that unlocks the file in your browser's memory, reads the transaction tables, and forgets the password the instant the spreadsheet is ready. No uploads that linger on servers, no desktop software, no retyping.
This guide is written for small business owners and finance teams running on ICICI current accounts: high transaction volumes, GST filings, and monthly reconciliations that cannot afford transcription errors. You will get the password format, the safe unlock method, and the exact steps to a spreadsheet your accountant can use immediately.
The ICICI password format, explained
ICICI derives the statement password from your registered details — typically the first four characters of your name in lowercase plus your date of birth in DDMMYYYY format, or your customer ID combined with your birth date. The precise recipe is printed in the email that delivered the statement, and it is case-sensitive. Copy it exactly; "almost right" is still wrong.
Businesses hit two special cases. First, statements for current accounts sometimes use the authorized signatory's details rather than the company's — check whose name generated the password. Second, older statements may predate ICICI's current format; if a 2021 file will not open with the new pattern, the old email for that period carries the old pattern. When in doubt, re-download from ICICI net banking or the iMobile app — fresh files use the current format, and the ICICI download guide shows every method.
Unlocking without creating a new risk
A locked PDF protects your entire financial history, so the unlock step deserves care. The safe pattern is: the file is decrypted in memory on your own device, the tables are extracted, and everything — file and password — is discarded before you even see the download button. Nothing is emailed, nothing is cached "for your convenience," and no tool should ever ask for your net banking credentials.
Watch for converters that keep unlocked copies in an online "dashboard" by default. That convenience is a liability: it turns one protected file into a permanently stored unprotected one. Prefer tools that delete aggressively, and review the password removal guide before handing any statement to a new service.
From locked PDF to Excel in 3 steps
Step 1 — Upload the protected file. Convert Statement takes the ICICI PDF as-is. Enter the password at the prompt; decryption happens in memory solely to expose the transaction tables.
Step 2 — Verify the mapping. ICICI current-account statements are long, so check the preview: dates in one column, narrations intact, debits and credits in separate numeric columns, running balance preserved. Spot-check a known large transaction — a vendor payment you remember — to confirm amounts survived.
Step 3 — Download and reconcile. The Excel file drops straight into your monthly reconciliation. Dates are real dates, amounts are numeric, and every row is chronological. A 200-page statement converts in roughly the time it takes to make coffee.
What businesses do with the export
- GST filing: filter by narration to isolate business expenses and cross-check input credits. Our GST filing guide walks through the workflow.
- Monthly reconciliation: match the export against invoices and receipts in minutes; mismatches surface immediately instead of at year end.
- CA handoffs: send one spreadsheet per month instead of a folder of locked PDFs — your CA will quote you less, or at least complain less.
- Cash-flow review: pivot the data by week to see exactly when money leaves; seasonal businesses find this transformative. Background reading: statement analysis for accountants.
Troubleshooting ICICI files
Password works in Adobe but not the converter. Some readers tolerate trailing spaces; converters should not. Retype the password carefully rather than pasting, in case the email added invisible characters.
Missing narration text. ICICI truncates very long narrations in the PDF itself — the spreadsheet can only carry what the PDF contains. For full references, cross-check the net banking transaction view.
Consolidated multi-account PDFs. If one file holds several accounts, convert once, then split sheets per account and add an Account column. Filters keep everything clean afterward.
Need CSV for Tally? Export the same conversion as CSV and import directly. Details at ICICI statement conversion options.
Frequently asked questions
What is the password for my ICICI statement PDF?
It is built from your registered name or customer ID plus your date of birth; ICICI prints the exact format in the statement email. Current-account passwords may use the authorized signatory's details — check the email for that period.
Is entering the password online actually safe?
Yes, when decryption happens in memory on your device and the password is never stored or transmitted beyond the session. Avoid any service that wants your net banking login — the PDF password alone is all a converter needs.
Can I convert a full year of statements at once?
Convert month by month and combine the sheets in one workbook — it keeps row counts manageable and lets you verify each month independently. Bulk workflows are covered in our higher-volume plans.
Will NEFT, RTGS, and IMPS entries convert correctly?
Yes. Each transfer becomes its own row with the reference number in the narration, exactly as printed in the PDF. Filtering by "NEFT" or "RTGS" isolates those transfers instantly.
Give your CA spreadsheets, not locked PDFs. Convert your ICICI statement to Excel free — upload, enter the password, download clean data. Processing statements for multiple entities? See plans designed for volume.