Budgeting

Merging categories without wrecking your history

Combining two categories is simple in principle but can distort trends if done carelessly; here is how to merge while keeping past reports meaningful.

Editorial illustration for Merging categories without wrecking your history

A tidy move with a hidden catch

Merging two categories feels like pure housekeeping. “Tea” and “Coffee” become “Hot drinks”, the list gets shorter, and everyone is happy. The catch is what happens to trends. If last year’s coffee and tea figures were reported separately and this year’s appear combined, a chart that draws a line across the change can mislead, showing a jump that never occurred.

Handled with a little care, a merge can be clean. The care involves deciding what to do with the past.

Decide whether the past should change

You have two choices. In the first, the merge applies to all history: every old transaction under either old category now shows under the new one. Reports across time stay consistent, and trends remain comparable. In the second, the merge applies only from today, and older entries keep their old labels.

For most personal use, the first choice is better. Consistency across time is worth more than preserving an outdated distinction. The second is useful only if the old split carries information you want to retain, such as separate tax treatment.

Check what you are really merging

Before you merge, open both categories and look at their contents. A surprising number of problems come from assuming two categories are similar when they are not. A category called “Transport” might hold fuel and parking, while another called “Travel” holds long journeys and hotels. Combining them would mix daily routine with holidays.

A good test: could a single budget limit sensibly cover both? If not, keep them apart.

A step-by-step approach

Here is a safe order of operations.

  1. Export or note down the current totals for each category for the last twelve months.
  2. Decide on the name of the surviving category and, if needed, rename it to suit the merged content.
  3. Move the transactions from the retired category into the survivor.
  4. Update any rules or budgets that pointed at the retired category.
  5. Compare the new combined total with the sum of the old totals; they should match.

Step five is the check that makes the process safe. If the totals differ, something went missing or was double counted.

Illustrating the check

Suppose “Tea” totalled 1,800 over twelve months and “Coffee” totalled 3,300. After merging, “Hot drinks” should show 5,100. If it shows 4,700, then 400 went somewhere else, possibly into a default or into a rule that reassigned some entries. If it shows 5,500, some entries were counted twice.

Finding the discrepancy right away is far easier than discovering it months later when you wonder why the number looks odd.

Update the surrounding setup

Budgets and rules may refer to the old categories by name. After a merge, review them. A budget line for “Tea” that now points at nothing will report zero spending forever, giving false comfort. A rule that sends a particular merchant to the old category might still operate, quietly recreating the category you tried to remove.

Spend a few minutes scanning rules, recurring items and goals to make sure each points at the surviving category.

Leave a trail

Record what you did and when, even in one line. If someone else uses the tracker, tell them. A shared household with two people logging in different ways can easily recreate a merged category by accident.

After the merge

Take a look at next month’s report and confirm it reads well. If the new combined category feels too broad, you may have merged too eagerly, and you can split again. Categories are not carved in stone. The aim is a structure that is easy to use and honest to read, and it takes a few adjustments to reach it.

SPENDIXAI JOURNAL

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

Explore your reports