Convert a ICICI bank statement PDF to Excel, CSV & Tally XML,
without uploading it anywhere

Drop your ICICI Bank e-statement below and export it as .xlsx, CSV or Tally Prime vouchers. Parsing runs inside your own browser tab — the PDF is never sent to a server — and every row is checked against the statement's running balance before you export.

Drop your bank statement PDF here

or click to choose a file · SBI, HDFC, Kotak, Axis, ICICI, Federal e-statements

Which ICICI statements work

The branch or netbanking “Statement of transactions” PDF. ICICI has changed this layout over the years; the 2019 format is the one verified end to end.

verified Verified against a real-format 2019 “Statement of transactions” — 37 of 37 rows passed the balance chain.

Scanned or photographed statements are not supported for any bank yet — they are images and need OCR. Native e-statements downloaded from netbanking are also more accurate, because the text is already in the file rather than being guessed from pixels.

How to download your ICICI statement as PDF

  1. Sign in to ICICI Internet Banking or iMobile.
  2. Open the account and request a statement for your date range.
  3. Download the PDF e-statement (not a scan or a screenshot).
  4. Drop it into TieOut and enter the password if prompted.

Menu labels move around as banks redesign their portals. If yours does not match, look for “statement”, “e-statement” or “account statement” and choose PDF rather than Excel or CSV — the PDF is the authoritative document, and TieOut validates against the balances printed on it.

What TieOut does with ICICI's layout

A PDF has no table in it. It stores text fragments at x/y coordinates, and the neat columns you see on screen are visual alignment. Rebuilding rows means knowing what this particular bank does — and ICICI does the following.

  • ICICI prints the page marker — “Page 2 of 2” — on the same line as a transaction rather than on its own line. A converter that drops any line containing a page marker drops a real transaction with it. TieOut only skips lines that are nothing but a page marker.
  • Unused amount columns are filled with 0.00 instead of being left blank, and balances carry a trailing “ Cr” or “ Dr”. Both have to be stripped before the arithmetic works; left in, they turn every balance into text and the running-balance check into nonsense.
  • The statement opens with a “B/F” brought-forward row, and carries Autosweep and Reverse Sweep columns that are not transactions. These are recognised and excluded rather than being imported as ledger entries.
  • Because “@icici” appears inside UPI handles in almost every bank’s narrations, ICICI is matched last during bank detection — otherwise an SBI statement full of UPI transfers would be read as an ICICI one.

ICICI statement columns

ColumnsDate | Particulars | Chq. No. | Withdrawals | Deposits | Autosweep | Reverse | Balance (INR)
Date formatdd-mm-yyyy

How the ICICI conversion is checked

Every extracted row must satisfy balance = previous balance + credit − debit, and the last balance must equal the closing balance printed on your statement. Rows that break the chain are flagged rather than dropped, so a fully green table is provable evidence that no transaction was missed. That is running-balance validation, and it runs on your file rather than on someone else's test set.

Import a ICICI statement into Tally Prime

Export as Tally XML, create the bank ledger in Tally under the same name you exported with, then go to Gateway of Tally → Import → Vouchers and select the file. Rows arrive as Receipt and Payment vouchers with stable IDs, so re-importing the same statement updates rather than duplicates. The full path, including the two things that usually go wrong, is in how to import a bank statement into Tally Prime.

Help wanted: a ICICI statement

A statement in ICICI’s current format. The parser is verified against the 2019 layout, and the honest position is that a newer statement has not been checked end to end. If you have one you can share, it is the single most useful thing you could send.

Is it safe to convert a ICICI statement online?

It depends entirely on where the file goes. Almost every online converter uploads your PDF to its server, which puts your account number, balances and every transaction into someone else's storage under their retention policy. TieOut does not upload the file at all — and you can prove it in ten seconds by switching off your Wi-Fi and converting anyway. More on what different converters actually do with your statement.

ICICI Bank conversion FAQs

How do I convert an ICICI bank statement PDF to Excel for free?

Download the statement of transactions as a PDF from ICICI Internet Banking, drop it into TieOut and export as .xlsx or CSV. It is free, needs no account, and the PDF is parsed in your browser rather than uploaded to a server.

Why do ICICI statements lose a transaction in most converters?

ICICI prints “Page 2 of 2” on the same line as a transaction. Converters that discard any line containing a page marker discard that transaction too, and because a bank statement has no obvious gap when one row vanishes, it is easy to miss. The running-balance check catches it: a missing row breaks the chain immediately.

What are the Autosweep and Reverse Sweep columns?

They are ICICI’s automatic transfers between your account and a linked deposit. They appear as columns on the statement but are not ordinary transactions, so TieOut excludes them from the exported rows instead of posting them into your books.

Is the current ICICI statement format supported?

It has not been verified end to end. The parser is checked against a real 2019-format statement, and newer layouts may need adjustment — if the balance chain fails on your statement, that is the parser telling you so rather than silently giving you wrong data.

Other banks