To import an ICICI Bank statement into an expense tracker without messing up your totals, download the statement for exactly the period you need from your own ICICI Bank login, upload it into the right account, review the rows before saving, and keep your downloads from overlapping. Overlapping periods are the most common way the same debit ends up in your records twice.
Which period should I download?
Decide the cut-off before you click anything. The cleanest approach is whole calendar months: the first to the last day, no gaps and no overlap. Look for the statement or e-statement section after logging in, choose the account and the dates, and see which file types your own screen offers. Menu names and layouts change, so follow what the screen shows.
Why not just download the last 90 days every time? Because the third month of last time's file and the first month of this time's file are the same transactions.
What does an overlap look like?
Say you imported 1 to 30 September last month. Today you download 15 September to 15 October. The fortnight from 15 to 30 September now exists twice. If those two weeks held 38 transactions totalling ₹29,400, your spending for September would be wrong by ₹29,400.
| Import | Period | Counted once? |
|---|---|---|
| First file | 1 to 30 September | Yes |
| Second file | 15 September to 15 October | No, 15 to 30 September repeats |
| Better second file | 1 to 31 October | Yes |
What happens if I upload an overlapping file anyway?
SpendixAI flags possible duplicate imports, and a Possible duplicate charges report lists the same amount to the same merchant within two days. That helps you find them, but two genuine purchases of the same amount at the same shop can look alike, so check the dates and narration before deleting anything. Deleted transactions go to a recycle bin for 30 days, which is a useful safety net while you decide.
How do I import it step by step?
- Create an account first, for example ICICI Bank Savings, and select it.
- Upload the PDF, CSV or Excel file. You can upload several files in one go if they cover different months.
- Review the rows in the preview, especially the first and last date, and any large debit.
- Save, then look at the import history to see the status of each file.
Does it matter if I have an ICICI Bank card as well?
Yes, treat a card as a separate account, with its own statement and its own closing balance. Import it into its own account and mark the card bill payment in the savings account as a payment, not as spending. That way a ₹12,000 bill is counted once, when you swiped the card, and not again when you paid it.
What if the file does not read cleanly?
We cannot promise every ICICI Bank layout will parse perfectly. If a PDF gives scrambled rows, try the CSV or Excel version. Statements can also differ between account types. When only a few rows are wrong, fix them in the preview or add them by hand.
If you do find a duplicate after saving, delete only the repeated copy, not both. The recycle bin keeps deleted transactions for 30 days, so a wrong deletion can be put back, but it is better to check the date, the amount and the narration of both rows and keep the one that came from the earlier import.
A calendar to avoid overlaps
- Pick a day each month, such as the third, to download last month's file.
- Always use the first and last day of the month as the range.
- Write the range in the file name before uploading.
- Open the import history and check the last imported date before starting.
- Never download from the same start date twice.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

