Convert ICICI Bank Statements to CSV & Excel

ICICI iMobile and internet-banking PDFs use DD/MM/YYYY dates, INR amounts, and UPI / NEFT / RTGS / IMPS descriptions. StatementKit writes a clean Excel or CSV file you can open in Tally Prime.

ICICI Bank at a Glance

Full Name: ICICI Bank Limited

Country: India

Currency: INR (Indian Rupee)

Date Format: DD/MM/YYYY

Layout: Date | Particulars | Withdrawals | Deposits | Balance

Common refs: UPI, NEFT, RTGS, IMPS, NACH

ICICI Statement Format

Indian bank PDFs often use Indian numbering (1,23,456.78) and rupee symbols. A generic converter leaves those as text, so Tally and Excel cannot sum the column. StatementKit stores amounts as numbers and dates as YYYY-MM-DD.

UPI lines include VPA / UPI reference and the merchant or person name.
NEFT / RTGS / IMPS keep the UTR or reference in the description.
Salary credits and EMI stay as separate rows with their narration.
Password-protected PDFs from iMobile must be unlocked before upload.

How to Convert an ICICI Statement

In ICICI iMobile or internet banking, download the account statement PDF. Unlock it if the bank password-protected the file.
Upload it to StatementKit.
Download Excel for review, or CSV if you are mapping columns into Tally Prime.

Frequently Asked Questions

Can I use this for Tally Prime?

Yes. Export CSV, then map Date, Particulars, and Amount in Tally’s bank statement import. Excel is better if you want to review UPI narrations first.

Does it work with ICICI credit card statements?

Yes. Card PDFs convert like other issuers — see credit card statement to Excel.

What about current accounts and CC / OD accounts?

Those use the same transaction table. Opening and closing balances in the header are not mixed into the transaction list.