Money tips

Reconstruct twelve months of spending from old statements

Analyse a year of bank statements in one weekend: download twelve months, import them in order, categorise top merchants first and read one report.

Editorial illustration for Reconstruct twelve months of spending from old statements

You can understand a whole year of spending in a weekend by downloading twelve monthly bank statements, putting them in order, categorising only the biggest merchants first, and then reading one annual report. You do not need perfect data. You need enough to see where the money went and write down three observations.

Saturday morning: gather the twelve statements

Work in a financial year (April to March) or any twelve months you like, but be consistent. Download one statement per account, in PDF, CSV or Excel. Your bank's app or net banking will usually have a statement download option; look at your own statement to see what date range and format it offers, since this differs from bank to bank.

Do not forget the accounts that carry some of your spending: a second savings account, a credit card, a wallet. Skipping one makes a year look cheaper than it was. Name each file with the month and the account, for example 2025-04-savings.pdf, so you can import them in order.

AccountMonths coveredFormat downloadedStatus
Salary accountApr to MarPDFTwelve files ready
Credit cardApr to MarPDFNine files; three still to fetch
WalletOct to MarCSVOnly six months exist

That table is an example of a tracking sheet. Fill yours in before you start importing so gaps are visible.

How do I import old statements in the right order?

Importing oldest first keeps the story readable and helps spot duplicates, because a transaction that appears in two overlapping statements looks the same twice. In SpendixAI, you pick the account (bank, card or wallet) before uploading, so each transaction keeps its account, and you can upload several statements in one batch. The rows are shown for your review before they are saved, and the import history shows a status for each file. Possible duplicate imports are flagged, and a report lists same-amount charges to the same merchant within two days.

Choose your base currency before importing anything, because it cannot be changed once transactions exist. If a statement layout is unusual, not every row may parse perfectly, so read the preview rather than clicking through.

Which merchants should I categorise first?

Do not try to label 3,000 rows. Sort by total spent per merchant and label the top fifteen to twenty. These usually cover most of the rupees, even if they cover few of the rows. After that, your own rules and your history do the repeat work: once you tell the tracker that a merchant is groceries, similar rows follow, and corrections are remembered. AI categorisation, if you switch it on, handles only what is left, and you can keep it off.

  • Rent, EMIs and society maintenance: usually obvious, label first.
  • Cash withdrawals: put them in their own category until you can say what they were for.
  • UPI transfers to individuals: these are the hardest, so label what you recognise and leave the rest as 'To review'.
  • Refunds and reversals: check that they sit against the original category.

Sunday: what does the year actually say?

Open one annual report that groups spending by category and month. Do not look at every number. Read in three passes: the total by category, the monthly line for any bump, and the top merchants. A worked example with invented numbers: a year's spending of ₹6,48,000 averages ₹54,000 a month (6,48,000 divided by 12). If December shows ₹92,000, that is ₹38,000 above the average, and the category breakdown will tell you whether it was travel, festival shopping or an annual premium.

Write three observations, not thirty

A year of data invites an endless list. Cap it at three, each phrased as something you can act on: 'Food delivery was bigger than my electricity and water bills combined.' 'The same three subscriptions ran all year and I opened one.' 'Every April and October carried a big annual cost I had not planned for.'

Next to each, write one small action and a date. That page is the real output of the weekend.

Keep it going without another weekend

From now on, import each month's statement when it arrives. Ten minutes a month beats ten hours a year. Set a reminder for the day after your statement is generated, review the new rows, and add any cash spending by hand. If you ever need to share the year with an accountant, a CSV download of the report gives them clean rows to work from.

Check the numbers with your own bank records before you rely on them for anything important.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports