Money tips

Is spending really up? Compare per-day figures before blaming a category

Before blaming a category, check that months of different length are comparable by working out spend per day, with Australian-dollar examples.

Editorial illustration for Is spending really up? Compare per-day figures before blaming a category

Before you decide a category has grown, convert both months to a per-day figure. February has 28 days and March has 31, so March can look more expensive in every category without anyone spending any differently.

How big is the month-length effect?

Three extra days is about 11% more days than 28. If you spend A$24 a day on groceries in both months, February comes to A$672 and March to A$744. A comparison of the totals would say groceries rose A$72 when nothing at all changed.

Now try a real-looking case. Groceries came to A$672 in February and A$713 in March.

MonthDaysGroceriesPer day
February28A$672A$24
March31A$713A$23

The total is up A$41, but the per-day figure is down A$1. The category did not drive an increase; the calendar did.

How do you do the per-day check?

  1. Total the category for each month.
  2. Divide each total by the number of days in that month.
  3. Compare the per-day figures.
  4. Only chase categories whose per-day figure moved.

What about pay cycles and weekends?

Per-day figures remove month length but not rhythm. If you are paid fortnightly, some months hold three pay days, and anything you do straight after pay lands three times. Likewise a month with five weekends may show more outings. Compare like with like: for a closer look, use four-week windows instead of calendar months, so that each window holds the same number of weekends and pay days.

  • Calendar months are easy to read but have uneven lengths.
  • Four-week windows are even, but they drift against the calendar.
  • Fortnight windows line up with a fortnightly pay cycle.
  • Whichever you choose, use the same one every time.

Public holidays and school holidays can matter too. A month with a long weekend away has the same number of days as any other but a very different spending shape, so note the holidays beside the day count. When a month has one, expect travel, fuel and eating out to move and judge them with that in mind.

Which categories are most affected?

Everyday categories such as groceries, fuel and takeaway scale with days. Fixed bills such as rent, phone and insurance do not, so dividing them by days is pointless. Look at total fixed costs separately, and use the per-day check only for flexible categories.

What if the per-day figure is up too?

Then there is a real change. Suppose March per-day had been A$26 instead of A$23. That is A$3 a day more, or about A$93 across 31 days (3 times 31), and you should open the lines and ask what is different: new shops, new habits or higher prices on the same items.

Here is how it plays out for a year. A sheet with twelve rows and a per-day column makes the shape obvious: a category that sits around A$23 to A$25 a day in every month is stable, however the totals bounce between A$644 and A$775. A category that steps from A$23 to A$28 in March and stays there is a real change. That step, not the bouncing, is what you are looking for.

A tidy habit

  • Write the day count next to each month in your sheet.
  • Add a per-day column for flexible categories.
  • Keep a note of pay days and public holidays in each month.
  • Re-check any category that stays up on a per-day basis for two months.

SpendixAI is built around India and INR, so we are not offering it as a tool for Australian dollar budgets; a spreadsheet with a day-count column is all this method needs.

SPENDIXAI JOURNAL

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

Explore your reports