To plan next year from real data, collect twelve months of transactions, give every one a category, and add up each category for the year. Divide each total by twelve to get a monthly figure, then change a number only when you know something will be different. The plan then starts from what actually happened rather than from what you remember.
Which twelve months should you use?
Use the most recent twelve full months, not necessarily January to December. If you are planning in November, take last November through this October. A rolling year catches every seasonal bill once and only once. Gather all the places money left: the checking account, each credit card and any cash you wrote down.
How do you build the yearly category totals?
- Download or export each account's activity for the twelve months and put it in one list with date, description, amount and category columns.
- Remove card payments and transfers between your own accounts. They move money, they are not spending, and keeping them doubles the damage.
- Fill the category column. Start with six to nine broad categories; fine detail can wait.
- Add up each category for the year and divide by twelve.
- Check the grand total against the money that actually left your accounts, and chase any gap before trusting the numbers.
What does a worked example look like?
Say a two-person household finds these totals for the year. The figures are made up to show the arithmetic.
| Category | Last 12 months | Monthly average |
|---|---|---|
| Groceries | $7,320 | $610 |
| Dining out | $2,160 | $180 |
| Gas and transit | $3,000 | $250 |
| Utilities and internet | $2,640 | $220 |
| Subscriptions | $540 | $45 |
| Medical and pharmacy | $1,380 | $115 |
| Everything else | $2,400 | $200 |
| Total | $19,440 | $1,620 |
Now adjust only for known changes. If the utilities bill is going up by $20 a month, add $240 to that line and the plan becomes $19,680 for the year, or $1,640 a month. If a subscription ends, take its $12 a month off the same way. Leave every other line alone unless you have a reason.
What if one category looks too big to be true?
Open that category and sort it by amount. Large lines are usually either a one-off (a laptop, a repair) or a miscategorised payment. Mark true one-offs separately so they do not inflate next year's monthly figure, but keep them in the record, because most households have a few every year.
How do you turn the totals into next year's plan?
- Fixed lines (rent or mortgage, insurance, internet): copy last year's amount and update for any known change.
- Variable needs (groceries, gas): use the monthly average, and look at your highest month to see how far it swings.
- Lumpy yearly costs: divide by twelve and set that amount aside every month.
- Wants (dining out, hobbies): decide deliberately, starting from the real total.
- A small cushion line, so one surprise does not break the whole plan.
Write the plan in the same categories as the report. If the labels differ, you will never be able to compare plan against actual.
When does a spreadsheet stop being enough?
A sheet works well for one year if you categorise as you go. It gets tedious when four accounts need re-importing every month. SpendixAI, built around India and INR, is not set up for dollar-based households, but its Report builder (filter and group spend over any period) shows the same idea: whatever tool you use, you want the category-by-period view to come from the data without retyping.
A short checklist before you finish
- Twelve full months included, every account covered.
- Transfers and card payments removed.
- One-offs flagged, not deleted.
- Category totals match the money that left your accounts.
- Plan built in the same categories, then reviewed at the end of each quarter.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

