IN
Upload an ICICI Bank statement PDF and every transaction comes back as clean rows — date, transaction remarks, reference, value date, withdrawal, deposit and balance — checked so the closing figure ties out. Export to Excel, CSV, or a Tally-ready XML for your accountant.
An ICICI statement is a mix — card swipes, UPI payments, NEFT transfers, ATM cash and auto-debits all sitting in one list, each described in the transaction-remarks column. That mix is fine to skim on a phone, but the moment you need to add it up or file it, you need it as rows.
What an ICICI statement looks like
An ICICI account statement uses these columns:
Column | What's in it |
|---|---|
Date | The transaction date |
Transaction Remarks | The payment detail and reference string |
Cheque/Ref No | The cheque or reference number |
Value Date | The date the entry affected the balance |
Withdrawal | Money out |
Deposit | Money in |
Balance | Running balance after the transaction |
The Transaction Remarks column is doing the heavy lifting. A card payment names the merchant, a UPI line carries the payee's UPI ID and a reference, and a NEFT or IMPS transfer carries the beneficiary and a reference number. These remarks are long and often wrap across lines, and a rough PDF export reads the overflow as its own row. The converter keeps the whole remark on one transaction, with its reference number and value date beside it, so a month of mixed activity comes out searchable rather than scrambled.
Where to download your ICICI statement
- Internet Banking: log in at icicibank.com, go to Bank Accounts → Statements, choose the account and period, and download the PDF.
- iMobile Pay app: open the account, select Statement, pick the period and save or email the PDF.
An ICICI e-statement PDF is password-protected — it opens with the password ICICI sets (shown on the download page). Once it's open the text is selectable and the conversion is exact. A scanned printout works too, through OCR.
Card, UPI and bank transfers in one place
What makes an ICICI statement fiddly isn't one payment type — it's the mix. A single month can hold debit-card swipes, dozens of UPI payments, a couple of NEFT or IMPS transfers, an ATM withdrawal and a scheduled auto-debit, each formatted a little differently in the remarks. As a PDF that variety is hard to work through; as rows you can filter to just the UPI credits, just the card spends, or just the transfers, and total each in seconds. That's the difference between reading a statement and actually reconciling one.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total, filter and pivot.
- Tally — a Tally-ready XML so the entries import as vouchers rather than being keyed in by hand.
- Zoho Books, QuickBooks and others — the same data in each one's format.
Before download, the maths is checked: opening balance, plus deposits, minus withdrawals, has to reach the closing balance. On a statement mixing card, UPI and NEFT lines, that check is what catches a single entry dropped between pages.
Common snags with ICICI statements
- Long transaction remarks wrap. The full remark and reference are kept on one row instead of being split.
- Value date vs transaction date. Both are preserved so reconciliation is accurate.
- Password-protected PDF. Open it with the ICICI password first, then convert the opened file.
Frequently asked questions
Can I convert an ICICI statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the closing balance checked so it reconciles.
Can I import an ICICI statement into Tally?keyboard_arrow_down
Yes. The converter builds a Tally-ready XML, so the mixed card, UPI and NEFT entries post as vouchers your accountant can bring straight in, instead of being typed one by one.
My ICICI PDF is password-protected — will it still convert?keyboard_arrow_down
Yes, once you open it. Enter the password ICICI provides, and the converter then reads the opened statement's remarks, references and amounts exactly.
What sits in the Transaction Remarks column?keyboard_arrow_down
Whatever describes the payment — a merchant for a card swipe, a UPI ID and reference for a UPI payment, or a beneficiary and reference for NEFT and IMPS. The converter keeps that whole remark on each transaction.
