Free tool for CAs and accountants
ICICI Bank statement to Excel and Tally
Upload a ICICI Bank statement PDF and get a clean Excel in seconds, with every row checked against the running balance. Password-protected PDFs work too.
- Every row proven by the balance
- Opens password-protected PDFs
- Excel free, Tally with a free account
- Nothing stored
PDF e-statement downloaded from net banking (not a scan or photo), or the bank's Excel / CSV download. Up to 4 MB.
Read in memory and thrown away. We don't store your statement, and passwords are never saved.
How to convert a ICICI Bank statement
- Download your ICICI Bank account statement as a PDF (or Excel / CSV) from net banking.
- Drop the file above. If it asks for a password, ICICI Bank statements are usually the first four letters of the name in lower case followed by the date of birth as DDMM.
- Check any rows marked as not matching the running balance, then download the Excel, or export Tally entries with a free account.
Getting the ICICI Bank e-statement
Internet Banking or iMobile: Accounts → Statement → choose the dates → download as PDF or Excel. The PDF from net banking works best; a scan or photo of a printed statement won't convert.
Questions
- Is my statement stored?
- No. The file is read in memory to make the Excel and then thrown away. Statement passwords and the details you type to open a locked PDF are never saved.
- How do I know the numbers are right?
- Every row is checked against the running balance: previous balance + deposit − withdrawal must equal the balance printed on that row, to the paisa. Rows that don't add up are marked so you can check them, never silently changed.
- Does it work with password-protected PDFs?
- Yes. ICICI Bank statement PDFs are usually the first four letters of the name in lower case followed by the date of birth as DDMM (check the bank's email, they change it from time to time). Type it in, or fill in the account holder's details and we'll try the usual patterns. You also get an unlocked copy of the PDF.
- Can I import it into Tally?
- Yes, with a free account. Rows become Payment, Receipt and Contra vouchers with ledger suggestions that learn from your choices, exported as an XML file you import into Tally in one step.
- What about scanned statements?
- Not yet. Please use the PDF e-statement downloaded from net banking, or the bank's Excel / CSV download. Those have exact figures; scans don't.
- How many can I convert?
- 3 statements a day without an account, 20 a month with a free account, and unlimited on a paid plan.
Converting statements for many clients?
IntegralChase collects documents from your clients: one link per client, uploads from their phone, automatic reminders, password PDFs unlocked, and wrong-year or wrong-account files flagged. Their ICICI Bank statements go straight to Tally entries.