Money tips

Yearly spending by category: building next year's plan in euros

Use twelve months of real transactions to build a yearly spending by category report in euros, strip out one-offs and set next year's monthly figures.

Editorial illustration for Yearly spending by category: building next year's plan in euros

The quickest route to a realistic plan is to total each spending category over the last twelve months, remove the genuine one-offs, and divide what is left by twelve. That gives you a baseline monthly figure for each category, built from what you actually spent rather than what you meant to spend.

What counts as a one-off?

A one-off is something you do not expect to repeat on the same scale next year: a house move, a washing machine that died, a wedding gift for a close friend. Be strict. Holidays, birthdays and annual bills do repeat, so they stay in. If you remove too much, the plan looks comfortable on paper and fails in practice.

How does the arithmetic work with a sharing couple?

Say two people pay household costs from a joint account and each keeps a personal card. Over twelve months the three sources add up to €31,200 of real spending, after removing transfers between the accounts. Inside that, they spot a house move (€1,900) and an oven replacement (€1,900), both one-offs. The baseline is 31,200 minus 3,800, which is €27,400. Divide by twelve and the baseline monthly spend is €2,283.33.

Now add what they already know about. A new gym membership of €45 a month and a childcare change costing €105 a month add €150, so the planning figure becomes about €2,433 a month, or €29,200 for the year.

StepAmountResult
Real spending over 12 months€31,200Starting point
Remove one-offs (move and oven)-€3,800€27,400
Divide by 12€27,400 / 12€2,283.33
Add known changes+€150 a month€2,433.33

How do you keep personal and shared spending apart?

Tag each transaction with whose it is, either in an extra column or as a prefix on the category. At year end you can total shared costs, then each person's own. That avoids the usual argument over whose card paid for the groceries and lets each person plan their own pocket money.

Which categories should you split further?

  • Food: groceries and eating out separately, because they respond to different decisions.
  • Transport: fuel or season tickets apart from occasional taxis.
  • Home: fixed bills apart from repairs.
  • Insurance and annual fees: pulled out so they can be spread over twelve months.
  • Gifts and celebrations: one line, because they cluster around the same few dates.

What if your income is not the same every month?

Plan the year's spending first and compare it with the lowest-income months, not the average. If a quiet month leaves you short, the plan needs either a buffer or a lower variable line. Build the buffer deliberately as its own category.

When should you move beyond a spreadsheet?

When keeping three sources up to date by hand takes more time than the planning itself. SpendixAI, built around India and INR, is not intended for euro-based banking, so treat it only as an example of what to look for: grouping spending by category over any period without retyping.

What if the plan does not fit your income?

Compare the planning figure of €29,200 with what you expect to earn after deductions. If income is €2,600 a month, or €31,200 a year, the plan leaves €2,000 a year for saving and surprises. If it were €2,300 a month, or €27,600, the plan is €1,600 short. Then you have three honest options: lower a variable category, delay a purchase, or earn more. Pick the category you control most easily, usually the wants, and change that first rather than trimming everything a little.

  • Write the shortfall as a single number.
  • Name the category you will reduce and by how much.
  • Check that the reduced figure is something you have actually spent less on before.
  • Revisit the plan after three months.

Quick checklist

  • Twelve months, every account, transfers removed.
  • One-offs listed with the reason you removed them.
  • Annual bills confirmed present.
  • Known changes added as separate lines.
  • Plan reviewed after the first quarter.
SPENDIXAI JOURNAL

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

Explore your reports