How to Convert ICICI Bank Statement PDF to Excel & CSV
The Complete 2026 Guide
1. Quick Answer: How to Convert an ICICI Statement to Excel
To convert an ICICI bank statement PDF to Excel, first download the statement from ICICI NetBanking or the iMobile app, then unlock the password-protected PDF using the first 4 letters of your name in lowercase + your date and month of birth in DDMM format (for account statements) or the last 4 digits of your credit card number (for credit card statements). Then use an offline browser-based converter running on WebAssembly — your ICICI data never leaves your device.
The entire process takes under 60 seconds: download → unlock → convert → verify → download Excel. No installation, no upload, no subscription required for basic use.
Privacy Compliance active
StatementConverter offers 5 free conversions per day with no account required. For unlimited conversions, batch processing, and advanced features, Pro plans start at ₹2,799/month (billed annually).
2. Why ICICI Account Holders Need Excel Conversion
ICICI Bank is India's largest private sector bank by consolidated assets, serving over 1.5 crore digital customers across savings accounts, current accounts, credit cards, home loans, personal loans, demat accounts, and fixed deposits. Every month, millions of ICICI customers receive password-protected PDF statements — but a PDF is a viewing format, not a working format.
| Task | With ICICI PDF | With ICICI Excel/CSV |
|---|---|---|
| ITR filing | Manually copy 50–300 transactions into Excel for your CA | Export directly; your CA imports and categorizes in minutes |
| GST reconciliation | Cannot match GSTR-2B with ICICI UPI/NEFT/RTGS payments | Filter by date, sort by amount, auto-match with supplier invoices |
| Tally import | No direct import path; manual ledger entry | CSV maps directly to Tally Prime's bank ledger format |
| Expense tracking | Scroll through pages to find a specific UPI transaction | Ctrl+F search, date filters, vendor grouping via pivot tables |
| Demat reconciliation | Cannot match ICICI Direct buy/sell with contract notes | Filter by "ICICI Direct" or "ISIN" in descriptions |
| Loan EMI tracking | Cannot calculate principal vs. interest breakup | Excel formulas auto-calculate EMI components |
| FD interest verification | No way to verify TDS on interest income | Filter "Interest Credit" entries, sum TDS amounts |
| Audit support | Disorganized paper files | Chronological, searchable digital ledger with balance validation |
The ICICI PDF problem is unique: ICICI statements are not just PDFs — they are password-protected, multi-page, densely formatted documents with UPI IDs, IMPS references, NEFT narration, RTGS details, cheque numbers, demat transaction IDs, EMI schedules, and running balances. Manual extraction is error-prone and time-consuming. For a CA firm handling 40 ICICI client statements per month, manual conversion costs 35+ hours of billable time that could be spent on actual tax strategy.
3. ICICI Statement Password Formats: The Complete Reference
ICICI uses different password formats depending on the statement type and source. Entering the wrong password is the #1 reason users fail to convert ICICI statements. Use this table as your definitive reference:
ICICI Account Statement Passwords (Savings/Current)
| Source | Password Format | Example |
|---|---|---|
| All Account Statements (Primary) | First 4 letters of name (lowercase) + DDMM of DOB | rohi0806 (Name Rohit Mehra, DOB 08-June) |
| Alternative (if primary fails) | First 4 letters of name (UPPERCASE) + DDMM of DOB | ROHI0806 (Name Rohit Mehra, DOB 08-June) |
| Corporate Accounts | First 4 letters of company name (lowercase) + DDMM of incorporation date | abcl1503 (Company ABC Ltd, incorporation 15-March) |
Critical Note: ICICI is unique among Indian banks — it uses lowercase for the name portion, not uppercase like HDFC or SBI. Also, ICICI uses only the date and month (DDMM), not the full date of birth (DDMMYYYY). This is the most common source of confusion.
ICICI Credit Card Statement Passwords
| Source | Password Format | Example |
|---|---|---|
| Primary Format (Most Common) | Last 4 digits of your credit card number | 3456 (Card ends in 3456) |
| Email e-Statement (Alternative 1) | First 4 letters of name (lowercase) + DDMM of DOB | mahe0901 (Name Mahesh Kumar, DOB 09-Jan) |
| Email e-Statement (Alternative 2) | Date of birth in DDMMYYYY format | 05121990 (DOB 05-Dec-1990) |
| Email e-Statement (Alternative 3) | First 4 letters of name (lowercase) + MMDD of DOB | smar0520 (Name Smartin Jose, DOB 20-May) |
Quick Password Lookup by Scenario
| Scenario | Try This Password First | Try This Second | Try This Third |
|---|---|---|---|
| Account statement from NetBanking/iMobile | First 4 letters (lowercase) + DDMM | First 4 letters (UPPERCASE) + DDMM | — |
| Account statement via email | First 4 letters (lowercase) + DDMM | First 4 letters (UPPERCASE) + DDMM | — |
| Credit card from iMobile/NetBanking | Last 4 digits of card number | First 4 letters (lowercase) + DDMM | DDMMYYYY |
| Credit card via email | Last 4 digits of card number | First 4 letters (lowercase) + DDMM | DDMMYYYY |
| Joint account statement | Primary holder's lowercase name + DDMM | Second holder's lowercase name + DDMM | — |
4. How to Download Your ICICI Statement (5 Methods)
Before you can convert, you need the PDF. Here are the five reliable ways to get your ICICI statement.
Method 1: ICICI NetBanking (Best for Desktop & Full History)
- Visit www.icicibank.com and log in.
- Navigate to Bank Accounts → e-Statements → View Detailed Statement.
- Select your account number and statement period.
- Select PDF format and click Download.
Method 2: ICICI iMobile App (Fastest for Mobile Users)
- Open the ICICI iMobile app on your device.
- Log in with your MPIN, password, or biometric.
- Tap Accounts → Select your account number.
- Tap Statement or e-Statement.
- Select the period (Last 3 Months, Last 6 Months, Last 1 Year, or Custom Range).
- Choose PDF format and tap Download.
Method 3: Email e-Statement (Automatic Monthly Delivery)
- Check your registered email inbox for emails from ICICI Bank.
- Look for the subject: "Account Statement for your ICICI Bank Account" or "Statement for your ICICI Credit Card".
- Download the PDF attachment and open using your name + DDMM or card password.
Method 4: ICICI WhatsApp Banking (Quick Mini-Statement)
- Send "Hi" from your registered mobile number to ICICI Bank's WhatsApp number.
- Follow the menu options to request your statement PDF.
Method 5: Branch Visit (Physical Statement)
Visit your nearest ICICI Bank branch with your ID proof and request a printed account statement. Duplicates cost ₹100.
5. Step-by-Step: Convert ICICI Statement to Excel
Once you have the password-protected PDF, follow this exact workflow.
Prepare Your PDF File
Rename the file descriptively (e.g. `ICICI_Savings_FY2025-26.pdf`) and verify it is not corrupted.
Open the Converter
Go to getstatementconverter.com. The WebAssembly engine loads in browser RAM automatically.
Select ICICI and Enter Password
Choose ICICI in the bank selector, and type your password (first 4 letters lowercase + DDMM or card last 4 digits). Drag and drop the PDF into the terminal.
Convert and Review
Click convert. Wasm processes the statement. Verify row counts and closing balances in the preview table.
Download Your File
Select Excel (.xlsx) or CSV, and download. The file is saved locally from your browser cache.
6. What the Excel Output Looks Like
StatementConverter's ICICI parser extracts the following standardized columns:
| Column | Description | Example |
|---|---|---|
| Date | Transaction date in DD-MM-YYYY | 15-03-2026 |
| Description | Full transaction narration | UPI/CR/1234567890/ABC TRADERS |
| Debit | Amount withdrawn (negative cash flow) | 5,000.00 |
| Credit | Amount deposited (positive cash flow) | 25,000.00 |
| Balance | Running balance after transaction | 1,25,430.50 |
Special ICICI Fields Preserved:
- UPI Reference Numbers: `UPI/CR/1234567890/...` preserved in full.
- NEFT Reference Numbers: `NEFT/DR/123456/...` kept intact for audits.
- RTGS Transaction IDs: `RTGS/123456789012/...` maintained.
- IMPS References: `IMPS/123456789012/...` extracted.
- Cheque Numbers: `CHQ/123456` extracted when present.
- Demat Transaction IDs: `ISIN/INE123A01022` or `ICICI Direct` references preserved.
7. ICICI Credit Card Statement Conversion
ICICI credit card statements have a different layout from savings account statements. They include:
| Column | Description | Example |
|---|---|---|
| Date | Transaction date | 10-03-2026 |
| Description | Merchant or transaction detail | AMAZON.COM*Z2K9L3 |
| Amount | Transaction amount (always positive) | 2,499.00 |
| Type | Debit (purchase) or Credit (refund/payment) | Debit |
| Reward Points | Points earned | 25 |
Note: ICICI credit card statements do not show running balances per transaction. The parser extracts the statement summary (total dues, minimum due, credit limit, available credit, cash limit) as a separate metadata sheet in the Excel file.
8.ICICI Demat & FD Statement Conversion
ICICI offers integrated banking and demat services through **ICICI Direct**. Reconciling these activities is easy with StatementConverter:
ICICI Demat Statement
DP charges, dividends, buy/sell trade settlement entries mapped to ISIN codes.
StatementConverter isolates ICICI Direct debits/credits, DP charges, and dividend payouts automatically.
ICICI Fixed Deposit (FD) Statement
FD principal amounts, maturity dates, interest credits, and TDS interest deductions (verified against Form 26AS).
StatementConverter extracts maturity dates, interest credits, and TDS interest deductions automatically.
9. Use Cases: ITR, GST, Tally, and Audit
For Individual Taxpayers (ITR Filing)
Cross-check Form 16, isolate taxable savings/FD interest, track section 80 deductions (ELSS, PPF), match HRA rent payments, and trace capital gains buy/sell.
For GST-Registered Businesses
Verify GSTR-2B purchase input tax credit against actual bank payouts, trace reverse charge mechanism (RCM) debits, and track contractor TDS payouts (Section 194C).
For Tally Prime Users
Tally Prime supports CSV import for bank reconciliation. Our output structure maps directly to Tally Prime's ledger fields.
For Chartered Accountants & Tax Audits
CAs conducting audits under Section 44AB can filter for deposits exceeding ₹10 lakh, search for high-value items, and validate opening/closing parameters securely without violating ICAI client confidentiality guidelines.
10. Batch Processing: Multiple ICICI Statements at Once
Accounting firms and businesses can convert entire folders of ICICI statements in one step:
- Collect all ICICI PDF files.
- Drag and drop them together into the terminal.
- Download as individual Excel files or merge into a single master ledger with a "Source File" identifier.
This reduces processing time for 40 monthly statements from 20+ hours manually to under 10 minutes.
11. Troubleshooting: ICICI Conversion Errors Solved
Error 1: "Password Incorrect"
Use first 4 letters of your name in lowercase + your DOB DDMM. For credit cards, use the last 4 digits of your credit card.
Error 2: "No Tables Detected"
The statement is a scanned image (e.g. photos of physical books). Use the Scan Extractor (OCR) mode at 300+ DPI.
Error 3: Missing Transactions in Output
Some multi-line narrations wrap to new rows. Enable "Split Multi-Line Descriptions" in the advanced settings before parsing.
Error 4: Balance Does Not Match Passbook
Verify opening balance matches the first page. Check for page-break transactions split across consecutive pages.
Error 5: Credit Card Password Not Working
If last 4 digits fail, try lowercase name + DOB DDMM, or DOB in DDMMYYYY format.
12. Frequently Asked Questions (FAQ)
What is the password for my ICICI bank statement PDF?
For ICICI account statements (savings/current), the password is the first 4 letters of your name in lowercase + your date and month of birth in DDMM format. For example, if your name is "Rohit Mehra" and your date of birth is 08 June 1992, your password is `rohi0806`. For credit card statements, it is usually the last 4 digits of card number.
Can I convert ICICI statements without knowing the password?
No. ICICI encrypts PDF statements to protect your financial data. You must know the correct password to open the PDF. However, once you open it in StatementConverter, you can download an unprotected Excel file for easier future access. Never share your password — it is tied to your personal identity.
Is it safe to convert ICICI bank statements online?
Only if the converter is 100% offline. Cloud-based converters upload your ICICI statement to their servers, creating a data breach risk. StatementConverter uses WebAssembly to process ICICI statements inside your browser — your data never leaves your device. This is the only method compliant with ICAI confidentiality guidelines for CAs handling client ICICI data.
Can I convert multiple ICICI statements at once?
Yes. StatementConverter supports batch processing for Pro users. You can drag and drop multiple ICICI PDFs, and they will be converted individually or merged into one consolidated Excel file. The free tier allows 5 conversions per day.
Does this work for ICICI credit card statements?
Yes. Both ICICI account statements and ICICI credit card statements are fully supported, including password-protected PDFs. Credit card statements extract merchant names, transaction amounts, reward points, and EMI details. All ICICI card types are supported including Amazon Pay ICICI, Platinum Chip, MakeMyTrip, Rubyx, Sapphiro, Emerald, and HPCL Super Saver.
Can I import converted ICICI statements into Tally Prime?
Yes. Tally Prime supports CSV import for bank reconciliation. StatementConverter's CSV output aligns with Tally's expected column structure (Date, Narration, Debit, Credit). Map the columns during Tally import, and your ICICI ledger will populate automatically.
Will my ICICI statement data be stored online?
No. With StatementConverter's WebAssembly architecture, your ICICI PDF is processed entirely on your local device. No data is transmitted to any server, stored in any cloud, or retained after your browser session ends. This is the core privacy advantage over DocuClipper, Lido, and other cloud-based tools.
What if my ICICI statement has 50+ pages?
StatementConverter handles multi-page ICICI statements of any length. A full financial year statement (April–March) with 500+ transactions and 30+ pages processes in under 2 minutes. The Pro plan removes any page limits per document.
Can I convert scanned ICICI passbook pages?
Yes, but only with OCR (Optical Character Recognition). ICICI passbook pages are image-based, not text-based. Use the Scan Extractor mode, ensure the scan is 300+ DPI, and review the output carefully — handwritten entries or faded print may cause OCR errors.
How do I convert ICICI statements for ITR filing?
1. Download the full FY statement (April to March). 2. Convert to Excel using StatementConverter. 3. Sort transactions by date. 4. Add a "Category" column: Salary, Interest, Rent, Utilities, Investments, EMI, ICICI Direct, etc. 5. Share the categorized file with your CA for ITR preparation.
Why does my ICICI statement show different balances in Excel vs. PDF?
This usually happens because a transaction was split across a page break and missed, or ICICI bank charges or interest credits were treated as regular transactions, or a reversal/correction entry was not captured. Always verify opening and closing balances. If they do not match, review the statement for summary rows or page-break transactions.
Is there a free way to convert ICICI statements to Excel?
StatementConverter offers 5 free conversions per day with no account required. For unlimited conversions, batch processing, and advanced features like the analytics dashboard, Pro plans are available starting at ₹2,799/month (annual billing).
What is the ICICI statement password for joint accounts?
For joint accounts, use the first account holder's name (first 4 letters lowercase) + their date and month of birth (DDMM). If that fails, try the second account holder's details. The password is generated based on the primary account holder's information.
Can I download ICICI statements older than 1 year?
Yes. ICICI NetBanking allows you to download statements for up to the last 4 years. For statements older than 4 years, you may need to visit your branch or contact ICICI customer care at 1860-120-7777.
How do I download a password-free ICICI credit card statement?
You can download a password-free ICICI credit card statement from the iMobile app: Login to iMobile → Go to Cards & Forex → Manage → Statements → Select Past Statement → Choose the period and tap Open (not email) → Save the PDF. This version has no password. Alternatively, use NetBanking: Cards → Credit Cards → e-Statement → Download.
13. Conclusion
Converting ICICI bank statements from PDF to Excel is not just a convenience — it is a financial compliance necessity for ITR filing, GST reconciliation, Tally bookkeeping, demat reconciliation, and audit preparation. With over 1.5 crore digital customers and password-protected PDFs that use a unique lowercase format, having a reliable, secure, and ICICI-specific converter is essential.
StatementConverter is the only tool that combines ICICI-specific format detection (handling the unique lowercase name + DDMM password format, last 4 digits of card for credit cards, and multi-page statements) with absolute offline privacy via WebAssembly. Whether you are an individual taxpayer preparing for ITR, a business owner tracking GST payments, an investor reconciling ICICI Direct trades, or a CA firm managing 40 client ICICI accounts, the workflow is the same: download, unlock, convert, verify — done in under a minute.
Ready to convert your ICICI statement?
Open our secure ICICI converter terminal. Extract all transactions instantly to formatted spreadsheets entirely on your device.
Launch ICICI Converter Terminal