Statements to Tally
ICICI Bank statement to Excel and Tally
Turn ICICI Bank statement PDFs into Excel sheets or Tally vouchers in a few clicks, without retyping a single row.
Free, no page limits. Email or Google sign-up.
| Date | Narration | Debit | Credit | Balance |
|---|---|---|---|---|
| 02/10 | UPI/CR/CUSTOMER/ORDER 1021 | 18,500.00 | 1,03,500.00 | |
| 05/10 | NEFT/RENT/OCTOBER | 22,000.00 | 81,500.00 | |
| 09/10 | IMPS/MARKETPLACE SETTLEMENT | 42,310.00 | 1,23,810.00 |
Four ways to take your ICICI Bank data out
Excel for checking and reconciling- CSV for any other tool
- MCS with cluster and ledger columns
- Tally XML with your ledgers already set
ICICI Bank entries, sorted into Dr. and Cr.
Upload the ICICI Bank statement the way the bank gave it to you: from net banking, from the branch or from email. You don't need to reformat anything first.
Dr.
PaymentsWithdrawals become payment vouchers, or contra entries if you choose.Cr.
ReceiptsDeposits become receipt vouchers against the ledgers you set.Balance
CheckedOpening and closing balances are matched against the rows.Before you download anything, FileKey checks the opening and closing balance against the rows, so a misread row is easy to spot.
From ICICI Bank PDF to Tally
- 1Upload the PDF
Pick ICICI Bank or let FileKey detect the bank. Enter the password if the file has one.
- 2Check the rows
Edit a transaction or add a missing one before you export.
- 3Set ledgers
Map narrations to your Tally ledgers once.
- 4Import into Tally
Download Tally XML and, in TallyPrime, use Import > Transactions.
Questions about ICICI Bank statements
Is the ICICI Bank statement converter free?
Yes. FileKey is free right now, with no page limits and no credits. Sign up with your email or Google.
Can FileKey read password-protected ICICI Bank statements?
Yes. Enter the PDF password once when you upload. FileKey uses it to open the file and does not store it.
Can I edit ICICI Bank transactions before exporting?
Yes. The transactions open in a table where you can edit a row, add a missing one and adjust the opening balance before you download.
Can I import a ICICI Bank statement into Tally?
Yes. Set your ledgers in FileKey, download Tally XML and import it in TallyPrime with Import > Transactions.
What if a ICICI Bank statement doesn't convert?
Raise a ticket on that conversion from inside the app, for example for a missing transaction or a balance that doesn't match, and the FileKey team will look at it.
Is FileKey affiliated with ICICI Bank?
No. FileKey is an independent tool for CAs and accountants. ICICI Bank is a trademark of its owner.