Budgeting

Biggest movers: the five categories that changed most

Find which spending category increased the most month over month by sorting for absolute and percent change, and see why the two lists differ, with ₹ examples.

Editorial illustration for Biggest movers: the five categories that changed most

To find the biggest movers, put last month and this month side by side, then sort twice: once by the change in rupees and once by the change in percent. The two lists rarely match. The rupee list shows where the money moved, and the percent list shows where behaviour changed.

Build the two-column table

Here are hypothetical figures for seven categories.

CategoryLast monthThis monthChange in ₹Change in %
Travel₹2,000₹9,000+₹7,000+350%
Dining out₹3,000₹4,500+₹1,500+50%
Groceries₹8,000₹9,200+₹1,200+15%
Subscriptions₹500₹1,500+₹1,000+200%
Utilities₹3,200₹2,400−₹800−25%
Health₹1,000₹600−₹400−40%
Fuel₹4,000₹4,400+₹400+10%

Percent change = (this month − last month) ÷ last month. Travel: (9,000 − 2,000) ÷ 2,000 = 350%. Subscriptions: (1,500 − 500) ÷ 500 = 200%.

Why do the two lists differ?

Sort by the size of the rupee change, ignoring direction, and the top five are Travel (₹7,000), Dining out (₹1,500), Groceries (₹1,200), Subscriptions (₹1,000) and Utilities (₹800). Sort by percent change and the top five are Travel (350%), Subscriptions (200%), Dining out (50%), Health (40%) and Utilities (25%). Groceries appears in the first list only, Health in the second only.

  • Large categories rarely show big percentages. Groceries added ₹1,200 but that is only 15% of ₹8,000.
  • Small categories jump easily. Subscriptions tripled for ₹1,000, which is 200%, and nobody's budget collapses over that.
  • Falling categories count too. Utilities fell by ₹800, which is as large a move as an increase of ₹800.

What does the small category that jumped 200% deserve?

A quick look, not alarm. ₹1,000 more in subscriptions is probably a new plan or an annual renewal that landed. Check what it is and whether it repeats. If it repeats every month, the yearly cost is 12 × 1,000 = ₹12,000, which is worth a decision. If it is a one-off, note it and move on.

Which five should you actually act on?

  1. Start with the rupee list, because only big rupee moves change your month.
  2. Scan the percent list for small categories that are growing fast, since they may grow further.
  3. Ask whether each mover is a one-off, such as a trip, or a new regular habit.
  4. Pick one or two to act on. Trying to fix five at a time rarely works.

Doing it in a spreadsheet

With last month in B2:B20 and this month in C2:C20, in D2 put =C2-B2 and in E2 put =IF(B2=0,"new",(C2-B2)/B2). In F2 put =ABS(D2) and in G2 put =IF(ISNUMBER(E2),ABS(E2),"") so that rises and falls are ranked alike. Then sort the table by column F for the rupee list and by column G for the percent list. Excel 365 and Google Sheets can also do it with SORT.

Setting a floor to cut the noise

A category that moves from ₹100 to ₹300 shows +200% yet changes your month by ₹200. To stop tiny categories from dominating the percent list, ignore any category where both months are below a floor, say ₹500. You can also compare this month against the average of the last three months, which makes a one-month jump stand out more clearly than a month-on-month comparison does.

Where to get the numbers

Pull each month's category totals from your records. If you keep them in SpendixAI, the Report builder can filter and group a period by category, and you can download the result as a CSV to paste into the sheet above. The sorting habit is the same wherever the numbers come from.

SPENDIXAI JOURNAL

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

Explore your reports