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 it | Partner B calls it | Household name | Notes |
|---|---|---|---|
| Groceries | Kirana | Groceries | Milk and vegetables stay as a sub-category |
| Fuel | Petrol | Fuel | Covers both car and two-wheeler |
| Eating out | Restaurants | Eating out | Includes delivery |
| Society | Maintenance | Housing | Rent and maintenance are sub-categories |
| Medical | Pharmacy | Health | Doctor visits and medicines as sub-categories |
Step 3: Do one rename pass
- Choose a calm half hour and agree the final table first.
- Rename or merge categories in your tracker, one pair at a time.
- Reassign old transactions from the retired names to the household name.
- Check that no transaction is left in a category you meant to remove.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


