Budgeting

Keeping budget history readable when category names change (Europe)

Category names change as life changes. A version table with effective dates and an INDEX and MATCH lookup keeps old months comparable; examples in euros.

Editorial illustration for Keeping budget history readable when category names change (Europe)

A budget category list that never changes is rare. You move, have a child, change jobs. The trick is to treat names as labels with start dates rather than as permanent truths. Keep a version table, look each row up against it and your old months stay comparable.

Why not simply edit the old rows?

Editing history feels thorough but removes your record of what you decided at the time. If you later wonder why spending moved in spring, the original labels would have told you. A lookup layer keeps the original and adds a current view, so you have both.

A version table

Old labelCurrent labelChanged from
CarTransport1 July
Public transportTransport1 July
NurseryChildcare1 September
GroceriesGroceriesAlways

Column C is a note for you. It does not drive the lookup, but it explains the change when you read the table later.

The lookup formula

Put the typed category in column D of your data and the lookup in column E: =INDEX(Map!$B$2:$B$60; MATCH(D2; Map!$A$2:$A$60; 0)). The 0 at the end asks for an exact match. In a euro-region setup Excel often wants semicolons, as shown; in other settings use commas. Wrap it in IFERROR(...; "Unmapped") to find names missing from the table.

A worked example in euros

Say in your data Car totalled €210 and Public transport €45 for the first half of the year, and Transport €255 appeared in the second half. After the mapping, first half Transport is 210 + 45 = €255. Both halves read the same, so you see a flat line, which matches reality. Before the mapping, the first half looked like two small categories and the second like a surprise.

What if two names mean different things?

  • Keep them apart in the Map tab and add a new current label for each.
  • Do not map a name to something broader unless you are sure you will never need the finer detail.
  • If you need both views, add a second column for a broader group.

How often should I change names?

As rarely as you can. A good rule is to review names once a year, at a quiet time such as the end of December, and make all changes in a single session. That way you have one clean cut-off, instead of five small ones through the year.

A note on tools

SpendixAI is built around India and INR, so it is not for European households. It does offer a category tree with sub-categories and merchant defaults, which is the kind of structure worth looking for in any tool.

Should I keep a change log?

Yes, a short one. A tab named Changes with three columns, date, what changed and why, takes seconds to update and answers the question you will ask in a year: why does this line stop in June? It also makes it easier to share the sheet with a partner, who can see the history without asking you.

  • Date of change.
  • What was renamed, merged or split.
  • The reason, in one sentence.

When you read the data later, remember that the original column reflects what you chose at the time, while the rolled-up column reflects how you want to see it today. Both are useful, and keeping them side by side is what makes a historical comparison honest instead of tidy-looking and wrong.

Before the next change

  • Add the new label to the Map tab with a date.
  • Check the total of a past month.
  • Make any other changes in the same sitting.
SPENDIXAI JOURNAL

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

Explore your reports