Health and family

Two category lists, one household: how couples merge categories

When each partner built a different category list, map Groceries to Kirana and Fuel to Petrol, and rename once so household reports add up.

Editorial illustration for Two category lists, one household: how couples merge categories

When each partner has built their own category list, build one mapping table that lists each old name next to the single name you will use from now on, then do one rename pass. Groceries and Kirana become one category, Fuel and Petrol become one. After that, household reports add up properly, because the same kind of spending is no longer split across two names.

Why different lists cause trouble

Two partners rarely name things alike. One writes Groceries and the other Kirana; one writes Fuel and the other Petrol. Reports then show two smaller bars where one big bar should be, and nobody can tell what the household really spent on food or transport. Combining totals by hand every month is slow and error-prone.

Step 1: Print both lists side by side

Export or copy each partner's categories into one sheet, with one column per person. Add a third column for the count of transactions in each category, if your tracker shows it. Categories with few or no entries can probably be dropped.

Step 2: Build the mapping table

For each pair, choose the name that both of you understand quickly and that will still make sense in a year. Where two categories are really different, keep both, and where one is a part of another, make it a sub-category.

Partner A calls itPartner B calls itHousehold nameNotes
GroceriesKiranaGroceriesMilk and vegetables stay as a sub-category
FuelPetrolFuelCovers both car and two-wheeler
Eating outRestaurantsEating outIncludes delivery
SocietyMaintenanceHousingRent and maintenance are sub-categories
MedicalPharmacyHealthDoctor visits and medicines as sub-categories

Step 3: Do one rename pass

  1. Choose a calm half hour and agree the final table first.
  2. Rename or merge categories in your tracker, one pair at a time.
  3. Reassign old transactions from the retired names to the household name.
  4. Check that no transaction is left in a category you meant to remove.
  5. Both partners use only the new list from the next entry onwards.

In SpendixAI you can create custom categories and sub-categories with a colour, and corrections you make become history for future categorisation, so the tool starts to follow your naming. You can also add merchant aliases so the same shop is recognised under different names. Check how your own tool handles a renamed category before you start, in case it only changes new entries.

A worked example: do the totals add up?

Say Groceries shows ₹9,200 and Kirana shows ₹4,800 for the month. Combined, groceries came to 9,200 + 4,800 = ₹14,000. Fuel ₹5,500 and Petrol ₹3,000 combine to ₹8,500. Before the merge, the biggest single bar in the report was Fuel at ₹5,500. After the merge, Groceries at ₹14,000 is clearly the biggest category in the household. These figures are made up, but a change in the ranking is what the merge is for.

What should you do about edge cases?

Some spending fits two places: a pharmacy visit for a child can be Health or Children. Write a one-line rule for each, such as 'anything medical goes to Health, even for the children'. Put those rules on the mapping page so the next person to enter an expense does not have to guess.

Should old data be changed too?

Ideally yes, at least for the last three to six months, so that month-to-month comparisons make sense. If that is too much work, draw a line: from this month onwards the new list applies, and older reports are read with the mapping table beside them. Just note the change date on the table so nobody is confused by a sudden jump in a category.

Keeping the list consistent

  • Keep the mapping table somewhere both of you can open it.
  • Review the list every six months and remove unused categories.
  • Add a new category only when you have three or more entries for it.
  • If you import statements, check the first month's categories after the rename.
SPENDIXAI JOURNAL

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

Explore your reports