To build an annual expense summary, collect twelve months of statements, put every debit into one table with a category, summarise by category and month, and then write down three things the numbers tell you. The result is one page that shows where a year of money went, which you can use to set next year's budget. Here is the method with invented figures.
Which twelve months should you use?
Use the April to March financial year if you are reviewing for tax and accounts, or the calendar year if you want a clean view of the year behind you. Pick one and stay with it. Use every account you spend from: salary account, credit cards and any wallet.
How do you gather and clean the rows?
- Download each statement as PDF, CSV or Excel from your bank's statement section.
- Combine them in one sheet with columns for date, description, amount, account and category.
- Remove payments between your own accounts and credit card bill payments, or you will count them twice.
- Fix merchant names that appear in several forms.
- Give every row a category, starting with the largest amounts.
If you use SpendixAI, you can upload the statements after choosing the right account for each, review the rows before saving and let the categorisation run in stages. Your own rules come first, then your history. If AI is switched on it handles what is left. You then read the totals in the reports, and correct any wrong category, which becomes history for next time.
How do you summarise by category and month?
In Excel or Google Sheets, a pivot table with category as rows, month as columns and amount as values does it in a minute. Without a pivot table, use =SUMIFS($D$2:$D$3000,$E$2:$E$3000,$G2,$B$2:$B$3000,H$1), where D is the amount, E the category, B the month name, G2 the category label and H1 the month label.
A worked yearly table
| Category | Yearly total | Monthly average |
|---|---|---|
| Rent | ₹2,16,000 | ₹18,000 |
| Groceries | ₹1,08,000 | ₹9,000 |
| Dining and delivery | ₹48,000 | ₹4,000 |
| Transport | ₹36,000 | ₹3,000 |
| Utilities and bills | ₹30,000 | ₹2,500 |
| Total | ₹4,38,000 | ₹36,500 |
Check: 2,16,000 + 1,08,000 + 48,000 + 36,000 + 30,000 = 4,38,000, and ₹4,38,000 ÷ 12 = ₹36,500. Rent alone is ₹2,16,000 ÷ ₹4,38,000, about 49 per cent of this made-up total.
What three takeaways should you write?
Look at the table and the month-by-month columns, then write three short lines. Here are examples of the kind of lines to write:
- Rent is almost half of spending, so a rent change moves the whole plan more than anything else.
- If dining peaks in the festival months, that line needs a seasonal allowance rather than a flat monthly figure.
- Utilities are steady, so they can be budgeted at a flat figure.
What problems should you expect?
- Overlapping statements: if two downloads include the same day, the same rows appear twice. Scan your totals for a day that looks doubled before you trust them.
- Refunds: record them against the original category, or the total will overstate spending.
- Cash: spending you never entered is missing, so add cash expenses by hand, singly or several at a time, before you total.
- Wrong merchant names: one shop under three spellings splits its total across rows.
What should you do with the summary?
Use it to set next year's category caps, to spot subscriptions that crept up and to hand your CA a tidy list if they ask for it. The Export centre in SpendixAI offers templates for Tally, Zoho Books and QuickBooks, a standard all-transactions file and a categories-and-tax-codes file, if you need your data in another system.
Checklist before you close the file
- Every account is included.
- Transfers between your own accounts and card bill payments are excluded.
- Every row has a category.
- The monthly totals add up to the yearly total.
- The three takeaways are written down.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

