A yearly spending by category report is simply every transaction from the last twelve months, sorted into categories and totalled. The part that makes it useful for planning is splitting it in two: steady costs that repeat every month, and lumpy costs that arrive once or twice a year and make a normal month look cheaper than it really is.
Why do monthly averages mislead?
Look only at a quiet month and you will think you spend less than you do. Christmas, a car service, annual insurance and school costs all land in a few months and vanish in the rest. A full year shows them all, which is why the report is worth building before you write a budget.
How do you separate steady costs from lumpy ones?
Sort each category by how often it occurs. If something appears in at least ten of the twelve months, it is steady. If it appears once or twice and the amount is large, it is lumpy. Here is a made-up split to show the method.
| Cost | Pattern | How to plan it |
|---|---|---|
| Groceries | Every week | Use the yearly total divided by twelve |
| Energy bills | Every month | Average, then check winter against summer |
| Car servicing | Once a year | Divide by twelve and save monthly |
| Home contents cover | Paid once | Divide by twelve and save monthly |
| Christmas | One heavy month | Divide by twelve and save monthly |
| School uniform | Once a year | Divide by twelve and save monthly |
How do the sums work for the lumpy costs?
Say last year's lumpy items were car servicing £420, home contents cover £216, Christmas £650 and school uniform £180. Together that is £1,466. Divided by twelve it is £122.17, so setting aside £122 each month covers them almost exactly (twelve payments of £122 make £1,464). Put that into a separate pot or a clearly named line, and when the bill arrives the money is already there.
How do you build the report itself?
- Export twelve months from each current account and credit card.
- Merge them into one list and delete card repayments and moves between your own accounts.
- Label every line with a category. Keep the list short enough that you can remember it.
- Total each category for the year. Check that the grand total roughly equals what left your accounts.
- Mark the lumpy rows so you can pull them out of the monthly average.
What should next year's plan look like?
Start with steady costs at last year's monthly level. Add the lumpy pot of £122. Then adjust for changes you know about, such as a new subscription or a rent increase letter you have already received. Do not guess at inflation; plan from the invoices you actually see.
Review quarterly. After three months compare actual against plan by category, not just in total, because a total can look fine while groceries overshoot and a lumpy line hides the gap.
Do you need an app for this?
Not at the start. A spreadsheet with a category column and a pivot table or SUMIFS does the job. SpendixAI is built for India and INR, so it is not meant for pound-based accounts, but the Report builder's approach (filter and group by period and category) is the model to look for in any tool: you should never need to retype a transaction to see a yearly view.
A last check
- Every account included for all twelve months.
- Repayments between your own accounts removed.
- Lumpy costs identified and spread across twelve months.
- Plan categories match report categories.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

