Getting started

Food, Dining and Eating Out: merging overlapping categories

How to merge overlapping expense categories like Food, Dining and Eating Out: pick one name, move past transactions, and stop reports splitting the same spend.

Editorial illustration for Food, Dining and Eating Out: merging overlapping categories

Pick the one category name that matches how you think, move the transactions from the others into it, and stop using the extras. Do this and a report that showed three half-sized lines for restaurant spending will show one honest line. The trick is deciding first what the names actually mean, because Food is sometimes groceries and sometimes dining.

How three near-identical categories happen

Most people inherit them. A spreadsheet from three years ago had Food. An old budgeting app had Dining. A bank's own export tagged some rows Eating Out. When all three are imported or created in the same tracker, they sit side by side and your spending gets spread across them without any pattern.

The damage is quiet. Say last month's totals look like this.

CategoryAmount
Food₹8,200
Dining₹3,400
Eating Out₹1,900
Total across all three₹13,500

A glance suggests you spent ₹8,200 on your biggest food category. In reality, ₹13,500 went on food of one kind or another, and if you set a budget for Dining at ₹3,000 you were already told you overspent when the true picture is different. The split makes every comparison unreliable.

First, check whether they really are the same

Do not merge on sight. Ask what each one holds, and look at the merchants inside. If Food contains the supermarket and the vegetable vendor, it is really Groceries, and merging it with Dining would blur two very different habits: cooking at home and eating out. In that case, rename Food to Groceries and merge only Dining and Eating Out.

  • Open each category and scan the merchants in the last month.
  • Note which hold restaurants and delivery apps, and which hold grocery shops.
  • If two categories contain the same sort of merchant, they are candidates for merging.
  • If one holds something different, rename it rather than merging.

Choosing the survivor

Keep the category with the most history, or the one with the clearest name, whichever is easier to explain. Then check three things on it: its colour, so charts stay readable, whether it carries any sub-categories, and whether any of your rules point to it. If your tracker lets you set a GST rate, tax flags or an accounting code on categories, make sure the survivor carries the settings you want, since the others will stop being used.

Sub-categories can keep detail without keeping three parents. Under one Eating out category you might keep Restaurants, Delivery and Tea and snacks. Reports can roll up to the parent when you want the big picture and drill into the sub-category when you want to know why.

Moving the past transactions

  1. Open the list of transactions filtered to the category you are retiring. The Report builder in SpendixAI lets you filter and group, which helps here.
  2. Change the category on those rows to the survivor. If there are many, work merchant by merchant rather than row by row.
  3. Fix any rules that still point at the old category. Otherwise next month's import will put rows right back where you just took them from.
  4. Run the same report as before. The three lines should now be one, and the total should equal what you saw earlier, ₹13,500 in this example.
  5. Stop using the old categories. Leave them empty, or tidy them away, depending on what your tracker allows.

Will the same thing happen again?

It can, if you add categories casually. Before creating a new one, search the list. Many duplicates exist only because the name was slightly different. When you correct a category on a transaction in SpendixAI, the correction becomes part of your history, so the survivor category gains strength over time and the dead ones fall out of use without any extra effort.

A five-minute tidy to repeat each quarter

  • Sort your categories by amount in the last three months.
  • Look at the smallest ones; they are often duplicates or leftovers.
  • Merge or rename anything that overlaps.
  • Check one report to be sure the totals still agree.

Fewer categories, with clear names, make every later decision quicker.

SPENDIXAI JOURNAL

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

Explore your reports