To find which category is pushing your spending up, put two comparable periods side by side, list the total for each category in both, and subtract. The category with the biggest rupee difference, not the biggest total, is the one that moved. This takes about fifteen minutes once your transactions are categorised.
Why is the biggest category usually not the culprit?
Rent is the largest line for many people, and it sits there unchanged. A spending increase hides in a smaller line that grew, like eating out or fuel. Comparing totals shows you where money goes; comparing differences shows you where it changed.
A worked example with made-up numbers
Say a delivery rider compares March and April.
| Category | March | April | Change |
|---|---|---|---|
| Food | ₹8,200 | ₹9,100 | +₹900 |
| Fuel | ₹4,500 | ₹5,700 | +₹1,200 |
| Shopping | ₹3,000 | ₹4,900 | +₹1,900 |
| Bills and rent | ₹6,000 | ₹6,000 | ₹0 |
| Other | ₹2,300 | ₹2,000 | -₹300 |
| Total | ₹24,000 | ₹27,700 | +₹3,700 |
The changes add up: 900 + 1,200 + 1,900 + 0 - 300 = 3,700. Shopping alone explains ₹1,900, a little over half of the rise, so that is the first place to look. Fuel is second, and for a rider it may be a work cost that came with extra trips rather than a lifestyle change.
How do you make the comparison fair?
- Use the same number of days. A 31-day month against a 28-day month hides a difference of three days of spending.
- Compare like with like: festival months against festival months if you can.
- Separate one-off items such as an annual insurance payment, or they will look like a rise.
- For gig work, put work costs in their own category so a busy month does not look like a spending problem.
What if your categories are messy?
Then the comparison is only as good as the labels. Spend ten minutes cleaning: look at the largest uncategorised items and the category called Other, and fix those first. In SpendixAI, corrections you make become history for similar merchants next time, and you can add your own categories, so a category like Fuel for work can sit apart from personal travel.
How do you do this in a spreadsheet?
With dates in column A, categories in B and amounts in C, put the start and end dates for each period in cells and use SUMIFS for each category:
- March total for Food: =SUMIFS($C$2:$C$500,$B$2:$B$500,"Food",$A$2:$A$500,">="&$F$1,$A$2:$A$500,"<="&$F$2)
- April total for Food: the same formula, pointing to the April start and end cells.
- Change: April minus March, in a third column. Sort by that column, largest first.
When typing every UPI debit becomes tedious, SpendixAI can import statements and has the dashboard, insights and a Report builder where you can filter and group by category and date range; use the same two periods and read the difference yourself.
What if two categories moved at once?
Rank the changes by rupee size and work down the list until you have explained most of the rise. In the example, shopping and fuel together explain 1,900 + 1,200 = ₹3,100 of the ₹3,700. Two categories explaining about 84 per cent of a rise is a good place to stop, and the remaining ₹600 is not worth an evening. Then write one sentence per category: what happened, and whether it will repeat next month.
Keep the comparison table somewhere you can find it, so that next month you can add a column instead of starting again. Three columns of history show a trend, and two show only a jump.
What do you do with the answer?
- Decide whether the rise was a one-off or a new habit.
- If a habit, pick a monthly limit for that category that you can actually keep.
- Check again in a month using the same two-period comparison.
Freelancers can run this on income-matched weeks instead of calendar months, since payouts do not follow the calendar.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


