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.
Your file
Stays on your device. Nothing is uploaded.
Drop a file hereChoose a file to convert
CSV, Excel, ODS, JSON, XML, YAML, HTML or Markdown tables. It stays on this device.
Step by step
Export, convert, import
1 · Export from ICICI Bank statement
- 01In ICICI internet banking, open the account and go to the detailed statement for the period you need.
- 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)
- 01In QuickBooks Online, go to Bank transactions → Link account → Upload from file and choose the Fileshape CSV.
- 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) column | Value |
|---|---|
| Date | Copied from Transaction Date; date written as MM/DD/YYYY |
| Description | Copied from Transaction Remarks; extra spaces removed |
| Amount | Deposit 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
Other conversions
- Convert an HDFC bank statement for QuickBooks OnlineTurn an HDFC NetBanking statement (XLS or delimited) into the 3-column CSV QuickBooks Online imports: Date, Description and a signed Amount.
- Convert an SBI account statement for QuickBooksTurn an SBI (onlinesbi) account statement into a QuickBooks Online CSV. Debit and Credit become one signed amount, and dates become MM/DD/YYYY.
- Import an HDFC bank statement into XeroConvert an HDFC NetBanking statement into Xero's bank statement CSV: Date, Amount, Payee, Description and Reference, ready for reconciliation.
Updated 2026-11-20