Skip to content
fileshape

Import an ICICI Bank statement into QuickBooks Online

Download the detailed statement from ICICI internet banking as XLS, drop it below and choose QuickBooks Online. Fileshape finds the transaction table under ICICI's account summary, uses Transaction Date and Transaction Remarks, and turns the separate withdrawal and deposit columns into one signed Amount that QuickBooks understands.

01

Your file

Stays on your device. Nothing is uploaded.

Drop a file here

CSV, Excel, ODS, JSON, XML, YAML, HTML or Markdown tables. It stays on this device.

No file handy? Try a sample:

Step by step

Export, convert, import

1 · Export from ICICI Bank statement

  1. 01In ICICI internet banking, open the account and go to the detailed statement for the period you need.
  2. 02Download it as XLS. It's the older Excel 97-2003 format, which Fileshape reads directly; you don't need to re-save it.

2 · Import into QuickBooks Online bank import (3-column)

  1. 01In QuickBooks Online, go to Bank transactions → Link account → Upload from file and choose the Fileshape CSV.
  2. 02Pick the matching QuickBooks bank account, match the Date, Description and Amount columns and confirm the MM/DD/YYYY date format.

How ICICI's columns map

ICICI's detailed statement starts with a few lines about the account and period, then a table with S No., Value Date, Transaction Date, Cheque Number, Transaction Remarks, Withdrawal Amount(INR), Deposit Amount(INR) and Balance(INR). The exact spacing in the amount headers varies between downloads, for example “Withdrawal Amount (INR)”; Fileshape ignores spaces and punctuation when matching columns, so either spelling works without renaming anything.

QuickBooks gets three columns. Date comes from Transaction Date and is rewritten as MM/DD/YYYY. Description is the Transaction Remarks text with extra spaces trimmed. UPI remarks are long (they include the VPA and a reference), so you may want to shorten them later with a find-and-replace transform. Amount is Deposit minus Withdrawal, rounded to two decimals, so money out is negative.

Remarks that help QuickBooks match payees

QuickBooks' bank rules work on the description text, so the cleaner the remarks, the better the auto-categorisation. A useful pattern for ICICI is to add a Find & replace transform on Description that strips the long UPI reference numbers and keeps the merchant name. Because the recipe is saved with your settings (copy the recipe JSON or the share link), you only set this up once and reuse it every month.

If you reconcile on value date rather than transaction date, change the Date column's source to Value Date in the mapping step. Both are DD/MM/YYYY in the ICICI file and both are converted the same way.

A monthly routine that stays consistent

Most people convert ICICI statements once a month. Keep the statement period aligned to the calendar month, convert, and import straight away so QuickBooks' bank feed and your books never overlap. The preview row count should equal the number of transactions on the statement; if it doesn't, check the header row setting in step 1.

Column mapping

How each QuickBooks Online bank import (3-column) column is filled

These are the exact rules the converter applies to your ICICI Bank statement file. You can change any of them in step 3 before downloading.

QuickBooks Online bank import (3-column) columnValue
DateCopied from Transaction Date; date written as MM/DD/YYYY
DescriptionCopied from Transaction Remarks; extra spaces removed
AmountDeposit Amount(INR) minus Withdrawal Amount(INR), rounded to 2 decimals

FAQ

Questions

Is the ICICI file sent anywhere?

No. Conversion runs entirely in your browser tab.

Can I convert ICICI statements for Xero instead?

Yes. Choose Xero as the output layout; the date is written as DD/MM/YYYY and the remarks go to Payee and Description.

What if ICICI changes its column names?

The mapping screen shows any column it can't find. Pick the new column from the dropdown and the rest of the recipe keeps working. Please tell us so we can update the preset.

Related

Updated 2026-11-20