When you rename a budget category, the old rows keep the old name and the new rows get the new one, so one line of spending turns into two. Keep a small mapping table that links every old name to its current name, and look the new name up in a helper column. History stays readable without rewriting a single old row.
Why does a rename make history unreadable?
Say you spent on Eating Out for ten months and then renamed it Restaurants and Takeout. Your January to October rows say one thing, your November rows say another, and a sum by category shows two small lines instead of one big one. A year-end chart looks like you stopped eating out in October.
Build a mapping table
On a separate tab named Map, list every category name you have ever used in column A and the name you want it to roll up to in column B.
| Old name (column A) | Current name (column B) |
|---|---|
| Eating Out | Restaurants and Takeout |
| Restaurants and Takeout | Restaurants and Takeout |
| Groceries | Groceries |
| Misc household | Household |
| Household | Household |
Each current name maps to itself, so the lookup always finds something.
Add a helper column with one formula
- Leave the original Category column alone. It is your record of what you typed at the time.
- Add a column called Rolled-up Category beside it.
- In its first row enter =IFERROR(VLOOKUP(D2, Map!$A$2:$B$60, 2, FALSE), "Unmapped"), where D2 holds the typed category.
- Copy the formula down.
- Build your budget totals from the Rolled-up column, not from the original.
The FALSE argument asks for an exact match. Any name not in the table shows as Unmapped, so a typo becomes visible instead of vanishing.
What about splitting one category into two?
A split cannot be done with a name lookup alone, because the old rows do not say which half they belong to. Keep the old category as it was up to the date of the split, and start the new two from that date. A note on the Map tab with the effective date makes this clear to anyone reading later.
A worked check in dollars
Say Eating Out held $1,430 from January to October and Restaurants and Takeout held $310 for November. A sum on the rolled-up column should show $1,740 for the year. If it does not, check that every row has a mapping. The arithmetic, 1,430 + 310 = 1,740, is your test.
Where an app handles it differently
In SpendixAI, which is built around India and INR rather than the US, categories sit in a tree with sub-categories and your corrections become merchant defaults, so the same merchant lands in the same place next time. Check how any tool you use treats renames before you rely on it.
How do I keep names stable in future?
Most renames happen because the first names were too specific or too vague. Pick names that describe a purpose, not a brand or a mood: Transport rather than Gas and Uber, Household rather than Target runs. Purpose names survive changes in where you shop, so they rarely need renaming. Write a one-line description for each so that you and your partner place purchases the same way.
- Name by purpose, not brand.
- Write one line per category.
- Review names once a year, not monthly.
Before you rename
- Write the new name next to the old in the Map tab.
- Add an effective date for any split.
- Rerun your year total and compare it with the figure before the change.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

