When two months have the same total, compare the category mix before you decide nothing changed. A total of ₹52,000 can hide ₹6,000 moving out of groceries and into eating out and travel, and that shift usually means a change in routine, not a change in prices. The total only tells you how much; the mix tells you how.
What does the side-by-side look like?
Here are two hypothetical months, both totalling ₹52,000.
| Category | Month A | Month B | Change | Share of month A | Share of month B |
|---|---|---|---|---|---|
| Rent and bills | ₹24,000 | ₹24,000 | ₹0 | 46.2% | 46.2% |
| Groceries | ₹14,000 | ₹8,000 | -₹6,000 | 26.9% | 15.4% |
| Eating out | ₹4,000 | ₹7,000 | +₹3,000 | 7.7% | 13.5% |
| Travel | ₹2,000 | ₹5,000 | +₹3,000 | 3.8% | 9.6% |
| Shopping | ₹5,000 | ₹5,000 | ₹0 | 9.6% | 9.6% |
| Other | ₹3,000 | ₹3,000 | ₹0 | 5.8% | 5.8% |
| Total | ₹52,000 | ₹52,000 | ₹0 | 100% | 100% |
Check month A: 24,000 plus 14,000 plus 4,000 plus 2,000 plus 5,000 plus 3,000 is 52,000. Month B: 24,000 plus 8,000 plus 7,000 plus 5,000 plus 5,000 plus 3,000 is also 52,000. The three changes, minus 6,000, plus 3,000 and plus 3,000, cancel exactly. A total-only view would call this a flat month.
Why can a total hide a real change?
Because a category going down can be paid for by another going up. Money that leaves the kitchen shows up in restaurants and railway tickets. If you watch only the total, a budget alarm stays silent. If you watch the mix, you notice that eating out nearly doubled, from ₹4,000 to ₹7,000, and travel went from ₹2,000 to ₹5,000.
Is it a real shift or a one-off?
Ask three questions of the categories that moved.
- Did something happen that month? A trip, guests at home, a family function or a relative's visit would explain travel and eating out together.
- Did you stop doing something? If groceries fell by ₹6,000, did you really cook less, or did quick-commerce or restaurant orders replace shop-bought food?
- Did the categories get mixed up? Meals on a trip may be filed under eating out, while a bulk grocery order for the month may have landed in a different month.
What if the groceries fall was not real?
Check your own statements. If a large grocery purchase happened on the 30th of month A and the 2nd of month B, month A is overstated and B is understated, even though the household bought the same food. A way to test this is to compare groceries over the two months together: ₹14,000 plus ₹8,000 is ₹22,000, an average of ₹11,000, close to what you may normally spend.
A useful habit is to write one sentence under each changed category: what happened, and whether you expect it to continue. A line such as travel up ₹3,000 because of a cousin's wedding trip, one-off, takes ten seconds and saves you from re-deriving the story three months later. Without the note, a mix change becomes a mystery by the time you look at it again.
How do I view the mix without much work?
Put two months side by side with the category, amount and share for each, and sort by the size of the change. In SpendixAI the 25 ready-made reports are grouped by question and the Report builder lets you filter and group by month and category, which gives you this view without a hand-built sheet. Spreadsheet users can do the same with SUMIFS for each category and month.
Questions to ask of every month
- What is the total, and how does it compare with last month?
- Which three categories changed the most in rupees?
- Do the changes cancel each other out?
- Is there an event that explains them?
- Will I plan next month with the new mix or the old one?
Useful ideas start with a clearer picture of your own spending.
Explore your reports


