Budgeting

Adding a new budget category mid-year without confusing history (Australia)

Adding a category such as Kids partway through a year pulls spending out of older lines. Use merchant rules and a totals check, with Australian dollar examples.

Editorial illustration for Adding a new budget category mid-year without confusing history (Australia)

When life changes and you add a category mid-year, such as Kids, the new line starts at zero, while older lines quietly shrink. Whether that is a mistake or a fact depends on what you did with the old rows. Decide on the rules first, apply them to merchants, and check that your total did not change.

What happens when I add a new category?

Say you start a Kids category in March for school costs, sports and clothes. Those purchases used to sit under Household and Clothing. From March they sit under Kids, so Household drops and Clothing drops, and it looks like you cut spending when you only moved it.

Write rules by merchant, not by memory

  1. List the merchants and purchase types that now belong to the new category.
  2. Write each rule in a single place, such as a table with Merchant and Category columns.
  3. Apply the rules to new rows from the start date.
  4. Decide whether to apply them to older rows too, and note your decision.

Keeping rules in a table makes the change visible and repeatable. If you decide to apply them to older rows, you can do it all at once and know what was changed.

A worked check in Australian dollars

Say that in February you spent $640 on Household and $210 on Clothing, a combined $850. In March you spent $480 on Household, $120 on Clothing and $255 on Kids, a combined $855. The new line looks large on its own, but the combined view shows only a $5 rise, because 855 minus 850 is 5. The overall total is the test: it should not jump when you only moved things.

MonthHouseholdClothingKidsTotal
February$640$210$0$850
March$480$120$255$855

How do I check nothing has gone missing?

  • Total all categories for a month before and after the change, using a SUMIFS or a pivot, and compare.
  • Look for rows with a blank category, which may have been dropped when you changed a list.
  • Compare the result with the bank statement total.

How do I stop the list growing out of control?

Add a category only when you will act on it. If seeing the figure never changes a decision, it belongs in a broader group. A short list is easier to keep consistent over years, and consistency is what makes history readable.

A note on tools

SpendixAI is built around India and INR, so it is not for Australian households. Its approach, with merchant defaults that remember where a merchant belongs and corrections that become history, is the kind of feature worth looking for when you compare tools.

Who else needs to know about the change?

If anyone else reads or edits the budget, tell them. A partner who keeps putting school costs into Household will undo your new category. Send a short message listing the new category, the date it starts and two examples of purchases that belong in it. Then check the first week's entries together.

  • List the new category and its start date.
  • Give two examples of what belongs in it.
  • Check the first week's entries.

Check one more thing at the end of the month: the number of rows with no category at all. A change to your list can leave a handful of purchases with nothing assigned, and they quietly drop out of every total. Filter for blanks, assign them and your totals will tie back to the statement.

Before you add one

  • Who or what the new category is for.
  • The date it starts.
  • The rule list and a before-and-after total.
SPENDIXAI JOURNAL

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

Explore your reports