ICICI Bank statement into Tally. Without typing it.
ICICI sends statements in two different formats. We read both. Upload yours, check the ledgers we suggest, and the entries go into Tally.
What ICICI statements put you through
Typing every UPI payment into Tally by hand
Upload once. Every line is read for you.
Digging the payee name out of a long UPI line
We pull the payee out and match the ledger.
Unlocking the statement ICICI emailed you
Type the password once at upload. Done.
Payments turning into receipts on the Cr/Dr format
We spot which format you have before reading it.
Columns sliding sideways on later pages
Shifted columns are put back where they belong.
Setting the same shops and vendors every month
A payee you set once is remembered next time.
How to import an ICICI Bank statement into Tally
Works with the statement you download and the one ICICI emails you.
Download it from ICICI
In net banking, open Bank Accounts, then Statement of Account. Pick your dates and download as PDF or Excel.
Upload it
Drop the file in. If it is locked, type the password — ICICI usually uses your date of birth as ddmmyyyy, or your customer ID.
You check the ledgers
Each transaction comes with a suggested ledger. ICICI statements have a lot of UPI, so set one ledger across many similar rows at once.
Post to Tally
Download the clean Excel, then let Tally Connector — our free Windows app — import it into your open Tally company. Choose your ICICI bank ledger and the receipts, payments and contras are created for you. No XML file to build, and Undo Import reverses the whole batch. Or just keep the Excel.
What we do with each ICICI column
This is the ICICI net banking layout. The other format swaps the two amount columns for one amount plus a Cr/Dr marker.
| ICICI column | What it becomes |
|---|---|
| S No. | Used to check nothing was skipped |
| Value Date | Kept for your reference |
| Transaction Date | Voucher date |
| Cheque Number | Cheque number on the entry |
| Transaction Remarks | Narration, and picks the ledger |
| Withdrawal Amount (INR) | A payment entry |
| Deposit Amount (INR) | A receipt entry |
| Balance (INR) | Used to double-check every row |
If your ICICI statement shows a Cr/Dr column instead, that works too — the marker tells us receipt or payment.
Common questions
How do I import an ICICI statement into Tally?
Download it from ICICI net banking as PDF or Excel, upload it to SmartXtract, check the ledger suggested for each transaction, and post the approved entries into your Tally company.
Does it work with the locked statement ICICI emails?
Yes. Type the password when you upload. ICICI usually uses your date of birth as ddmmyyyy or your customer ID.
My statement has a Cr/Dr column, not withdrawal and deposit. Is that OK?
Yes. Both ICICI formats work. Where there is one amount column with a Cr/Dr marker, the marker decides whether it becomes a receipt or a payment.
Can I use the ICICI Excel file instead of the PDF?
Yes. XLS, XLSX and CSV all work, and go through the same ledger matching as PDFs.
Will UPI payments get the right ledger?
We pull the payee out of the UPI line and match it, so a shop you set last month is recognised this month. You still check every suggestion before anything posts.
Can I get an Excel file instead of posting to Tally?
Yes. Download the clean transactions as an Excel file with the ledger names included. There is a separate guide for converting ICICI PDFs to Excel.
What does the free trial include?
20 pages, no card needed. Enough to run a full monthly statement and check the result.