Money tips

Spending is up: is it price, trips or basket size?

Once you know a category grew, split it into number of purchases, average purchase and largest purchase to see why, with a euro example.

Editorial illustration for Spending is up: is it price, trips or basket size?

Once a category has been identified as the one that grew, break it into three numbers: how many purchases, how large the average purchase was and which single purchase was biggest. Those three tell you whether the rise came from habits, prices or a one-off.

Why is the total not enough?

A total hides the story. A grocery bill that rose by €80 could mean you shop more often, buy more each time, or pay more per item. Each of these calls for a different response, and you cannot tell which from the total alone.

What are the three numbers?

  • Count of purchases: how often you spent in this category.
  • Average purchase: the total divided by the count.
  • Largest purchase: the biggest single line, which shows whether one item distorted the month.

Try it with invented figures for a household whose groceries rose.

MeasureLast monthThis month
Total groceries€620€700
Number of purchases1014
Average purchase€62€50
Largest purchase€118€96

The total rose by €80. But the average purchase fell from €62 to €50, so baskets are smaller, and the count rose from 10 to 14. That is a pattern of more frequent, smaller shops, and it is a habit rather than a price rise or a stock-up.

What does each pattern usually mean?

  1. More purchases and a smaller average: you are popping in more often, which tends to add impulse items.
  2. Same count and a bigger average: prices, brand switching or larger baskets.
  3. Same count and average but a bigger largest purchase: a single big item pulled the month up.
  4. Fewer but larger purchases: you may have stocked up or moved to a bulk shop.

None of this proves anything on its own, but it tells you which question to ask next. In the example, the sensible question is why four extra trips happened: a change in work pattern, someone eating at home more, or simply running out of things.

Who did you pay?

The merchant view is the fourth angle. List the five merchants you paid most often in the category last month and this month. A new name that appears four times is a clue. A familiar supermarket whose total rose while its count stayed flat is a price or basket story.

A related trick is to compare the largest purchase with the average. If the largest purchase is more than three times the average, one line may be doing the work. Here €118 against €62 is under twice the average, so no single line explains the change, which supports the habit reading over the one-off reading. Had the largest purchase been €310, you would look at that one line first.

When should you stop digging?

When you can explain the change in one sentence. 'Four extra small shops because of the new work schedule' is enough. If you cannot reach that sentence, you do not yet have a cause, and the right next step is to wait one more month and compare again rather than to act on a guess.

What to do next

  • Pick the category with the largest increase in euros.
  • Write down count, average and largest purchase for both months.
  • Read the five biggest merchants.
  • Change one thing and re-measure.

SpendixAI is built around India and INR; it keeps a possible-duplicate flag on imports and a report of same-amount charges to the same merchant within two days, which is the kind of check described above, but we are not suggesting it for euro households.

SPENDIXAI JOURNAL

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

Explore your reports