To import a Bank of India statement into an expense tracker, save the statement from your own banking login as a PDF, CSV or Excel file, upload it against the right account, review the rows, and then match the result to the closing balance. If you want a whole year in the tracker, upload the months in one batch, but check each month's balance separately.
Starting a year of history without a mess
Many people open a tracker in the middle of a financial year, which runs from April to March in India, and want the earlier months in as well. That is fine. The trick is to treat every month as its own unit. A twelve-month file is hard to check; twelve one-month files are easy, because each has its own opening and closing balance.
- Pick a start month, such as April.
- Download one file per month from the statement or e-statement section of your own net banking.
- Name each file with the month so that nothing is uploaded twice by mistake.
- Keep them all in a folder before you start.
I cannot tell you which menu holds the statement in the Bank of India app or site, because layouts are updated often. Look for a statement, e-statement or transaction history option, and ask your branch if you cannot find one.
How do you upload several months together?
- Create or choose the Bank of India account in your tracker first.
- Select all the monthly files and add them as one batch.
- Open the import history and confirm each file has a status.
- Review rows month by month, starting with the earliest.
- Save once a month looks right, and move to the next.
SpendixAI supports batch uploads and shows an import history with a status for each file, so a failed file does not silently disappear: an Import failed notification tells you to look. The account is chosen before the import and stays attached to every row.
What should you check in each month?
| Item | Where to look | Example |
|---|---|---|
| Opening balance | First balance on the statement | ₹14,200 |
| Credits total | Sum of money in | ₹48,000 |
| Debits total | Sum of money out | ₹43,600 |
| Closing balance | Opening + credits - debits | ₹18,600 |
The example is invented: 14,200 + 48,000 - 43,600 = ₹18,600. The closing balance of one month should be the opening balance of the next. If April closes at ₹18,600 and May opens at the same figure, there is no gap between files. If May opens higher or lower, a day or a page was left out.
What about rows that look wrong?
Look at direction first. A credit read as a debit changes your balance check by twice the amount, which is easy to spot. Then look at dates: if day and month are swapped, a statement for April will show rows in the wrong months. Fix or delete the affected rows before saving rather than after, because it is quicker to correct them in the review step.
We have not seen every Bank of India layout, so I cannot promise every file will read perfectly. That is why the review step is there.
If a month is still off after these checks, set it aside and carry on with the others. Come back with fresh eyes, and compare that month's page count and row count on the statement with the tracker, since a missing page is the usual cause.
After the history is in
Do one pass to categorise the larger merchants and set rules. Because you have a full year of data, the rules will catch most repeats. Then look at the uncategorised rows and sort what is left. From the next month, a single new file is all you need.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


