ICICI Bank statement analyser: Excel in, ITR-ready report out
ICICI Bank's transaction remarks are a compact code language: slash-separated, with a mode prefix in front. You will see UPI/ for UPI, MMT/ for IMPS, BIL/ for bill payments and internal transfers, VIN/ or VPS/ for card spends, and NEFT rows with the counterparty tucked between delimiters. Greenote Lite speaks that language — each prefix maps to a category and the party name is picked out of the remark, so the report lands categorised and named.
How to export your ICICI Bank statement as Excel or CSV
- 1Log in to ICICI internet banking (or iMobile) and open the account statement view — typically under Bank Accounts.
- 2Select the account and set a custom date range covering the period under audit.
- 3Download in Excel or CSV format — most versions offer XLS right next to PDF. Skip the PDF.
- 4Upload the file as-is; the engine finds the transaction table on its own.
Menu names shift between netbanking versions, so treat the steps above as a guide — the constant is the format: take the Excel, XLS or CSV download, not the PDF. Greenote Lite does not read PDF statements; the full Greenote desktop app (coming soon) will.
What Greenote Lite does with an ICICI statement
ICICI's prefix-plus-slashes style makes mode detection unusually reliable, and the engine layers party extraction on top:
- Mode prefixes are decoded directly: UPI/ rows are treated as UPI, MMT/ as IMPS transfers, BIL/ as bill payments or internal transfers, and VIN- or VPS-style rows as card transactions.
- A typical UPI remark packs the reference, payer or payee, bank and VPA between slashes; the engine keeps the human name for the party ledger and drops the twelve-digit reference.
- ICICI exports usually carry both a transaction date and a value date column — both are read, so the report's dates match the statement.
- Very long remarks are sometimes truncated by the export itself. Rows that lose their party fragment are still classified from the surviving prefix, and anything genuinely ambiguous is marked Suspense rather than guessed.
The download is a four-sheet Excel workbook: a party ledger of who paid whom, every transaction categorised and named, a category summary, and an ITR summary with AIS/SFT flags. See why the party ledger comes first or the full statement-to-ITR workflow.
ICICI statement questions
They are ICICI's mode prefixes: MMT usually indicates an IMPS transfer, BIL a bill payment or internal transfer, and VIN or VPS a card transaction. Greenote Lite maps each prefix to the right category automatically, so you never have to memorise them.
Either. Both carry the same transaction remarks the engine parses. Pick whichever your netbanking version offers; just avoid PDF, which Greenote Lite doesn't read.
Mostly, yes. Rows keep their category from the mode prefix, and parties are extracted wherever the name survives. Rows where the counterparty is genuinely unreadable are grouped honestly under Suspense/Unknown instead of being force-matched to the wrong party.
Try it on a real ICICI statement
Your first statement is free — the trial processes the first 50 transactions so you can judge the quality end to end. No card, no signup wall, and the file is deleted the moment your report is ready.