ICICI e-statements are password-protected PDFs with separate Dr/Cr amount columns and lakh-grouped figures — three things Tally can't read and one conversion clears.
Convert the statement first
- Upload the ICICI PDF to the converter and enter the statement password — the covering email states the exact format, typically a combination of your name and date of birth. The password opens the file and is never stored.
- Dr/Cr markers become signed amounts, lakh grouping (1,23,456.78) becomes standard decimals, DD-MM-YYYY dates become ISO — and the statement is reconciled against its printed opening and closing balances.
- Download the Excel export — clean, typed columns.
Import into Tally
- In TallyPrime, press Alt+O (Import) → Bank Statement on the ICICI ledger, or use your practice's Excel import route.
- The exported columns — date, narration, amount, balance — line up with what the import expects; UPI/NEFT/IMPS narrations are intact for matching.
- Verify the closing balance against the statement — it will match, because the conversion had to reconcile before export.
ICICI-specific notes
- Signs are proven, not guessed: ICICI's Dr/Cr columns are normalised into one signed amount and every sign is verified against the running balance during conversion — a flipped entry can't slip through to your ledger.
- Savings, current and credit card statements all convert; card statements group charges differently, and the conversion maps each layout back to one clean row per transaction.