To import an HDFC Bank statement into an expense tracker, download the statement for the period you want from your own net banking or mobile banking login, upload the file, check the rows the tracker reads, and tally the totals with the closing balance printed on the statement. A single month takes ten to fifteen minutes, and the tracker never needs your banking login.
Where do I find the statement to download?
Menus change from one app update to the next, so do not trust a screenshot from a forum post. Log in to HDFC Bank yourself and look for a section called something like Statements, Account Statement or e-Statement. Pick the account, then the dates, then the file type. Whatever formats your own screen offers are the ones you can use.
- Choose one calendar month at first. A short period is easy to tally and easy to redo.
- If you are building a financial year, plan twelve downloads from April to March rather than one huge file.
- Save each file with the month in its name, such as hdfc-savings-2026-04, so you can tell them apart later.
PDF, CSV or Excel: which one should I pick?
If the bank offers more than one, prefer the one that keeps rows in proper columns. A rough guide:
| Format | Why pick it | What to watch |
|---|---|---|
| CSV | Plain rows and columns, the least to go wrong | Open it once to check dates and amounts look sensible |
| Excel | Rows already in cells, easy to eyeball | Do not edit or re-save it before uploading |
| Always available and looks like the official copy | Layouts differ, so rows need a careful review |
What do I do after downloading?
The order matters, because every transaction keeps the account it was imported into.
- Create or select the account first, for example HDFC Bank Salary Account, so rows land in the right place.
- Upload the file. SpendixAI accepts PDF, CSV and Excel statements and shows the rows for review before anything is saved.
- Read the preview. Look at the first five and last five rows, the largest debits, and any row with a blank date or amount.
- Save only when the preview matches what you see on the original statement.
How do I know the import is right?
Use the arithmetic that every statement obeys: opening balance plus credits minus debits equals closing balance. Say your statement shows an opening balance of ₹42,000, total credits of ₹85,000 and total debits of ₹71,350. Then ₹42,000 plus ₹85,000 minus ₹71,350 is ₹55,650, and that should equal the closing balance printed on the statement.
Now add up the credits and the debits in the imported list. If both totals match the statement, the import is complete. If debits are short by, say, ₹1,200, a row was probably skipped; compare the dates until you find it.
What if the rows do not read cleanly?
We cannot promise that every HDFC Bank statement layout will parse perfectly, and layouts can differ between account types and over time. If a PDF gives messy rows, download the CSV or Excel version of the same period instead. If only a PDF exists, fix the odd rows in the preview, or add the stragglers by hand as ordinary expenses.
Keep one habit from the first import: never edit the downloaded file. If a row looks wrong, correct it in the tracker and leave the original untouched, so that the document you tally against is always the bank's version. Corrections made in a copy of the file are easy to forget, and a changed original is useless as evidence if you need to check a line months later.
A short routine for every month
- Download the new month's statement within the first week.
- Upload it into the same account as last month.
- Review rows, save, then tally credits, debits and closing balance.
- Add any cash spending that never touched the account.
- Keep the original file somewhere safe in case you need to check a row later.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

