To import an IDFC FIRST Bank statement into an expense tracker, download your own statement for the period you want from the bank's net banking or app, save it as PDF, CSV or Excel, upload it against the right account, review the rows, and then confirm that the totals agree with the closing balance. Allow about fifteen minutes the first time and far less afterwards.
Where do you get the statement file?
Banks rearrange their menus often, so look for the idea rather than a fixed path. Sign in to your own net banking or mobile app, open the account, and look for a section named statement, e-statement or account statement. Choose the dates you want, then pick a download format if one is offered. If you cannot find it, the bank's help page or branch can show you the route.
Which format should you pick?
If the bank offers more than one, the choice affects how clean the rows are. These are general tendencies, so look at your own file.
| Format | What it is good for | What to watch |
|---|---|---|
| CSV | Plain rows and columns that open anywhere | Dates may be read in the wrong order by a spreadsheet |
| Excel | Keeps columns apart, easy to scan | Header lines above the table may need removing |
| The official copy, always available | Layout is built for printing, so rows can wrap or split |
How do you import it, step by step?
- Create the account in the tracker first, such as a savings account named after the bank.
- Choose that account before you upload, because each transaction keeps the account it was imported into.
- Upload the file. SpendixAI accepts PDF, CSV and Excel, and you can upload several files in one batch.
- Review the rows on screen before saving: check the dates, the amounts and which column is debit.
- Save, then open the import history to see the status. If something fails you also get an Import failed notification.
SpendixAI does not connect to your bank and never asks for net-banking logins, so the file you downloaded is the only thing it sees.
How do you know the import is right?
Use the arithmetic of the statement itself: opening balance, plus everything credited, minus everything debited, should equal the closing balance. Say your statement shows an opening balance of ₹12,480, credits of ₹55,000 and debits of ₹41,730. Then 12,480 plus 55,000 is 67,480, and subtracting 41,730 gives 25,750. If the closing balance on the statement reads ₹25,750 and your imported totals give the same, nothing is missing. If the tracker shows a different credit or debit total, count the rows against the statement next.
What if some rows look wrong?
We cannot tell you exactly how every IDFC FIRST Bank statement is laid out, and layouts can differ by account type and by year. So treat the review screen as the real safeguard. These are the usual trouble spots.
- Dates swapped, so that 03/04 is read as the fourth of March.
- A long narration split over two rows, giving a row with no amount.
- Debit and credit amounts in one column with a Dr or Cr marker.
- A header or page-total line imported as if it were a transaction.
Fix the odd rows on the review screen, or try the CSV or Excel version of the same period, which is often tidier than the PDF.
What should you do after the first import?
- Note the last date you imported, and start the next file from the following day.
- Add rules for payees that repeat, so next month's rows are categorised automatically.
- Keep the original file somewhere safe in case you need to cross-check later.
- Set a reminder to import monthly, or after any month with unusual spending.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

