To find the category draining your budget, rank your categories three ways: by total spent, by how much each grew over recent months, and by how many transactions they have. The biggest category is not always the one to cut. The one that is growing quickly, or that fills your month with small payments, is often the real drain.
Set up the data first
Take three to six months of transactions, each with a date, an amount and a category. Fix obvious mistakes: card bill payments and transfers between your own accounts are not spending, and a refund should reduce the category it belongs to. If half your spending sits in 'miscellaneous', spend ten minutes sorting the biggest uncategorised lines first; otherwise the answer will be 'miscellaneous', which tells you nothing.
Rank by total, growth and count
- Total: add each category's spending across the period and divide by the number of months to get a monthly average.
- Growth: compare the first month or two with the last month or two. Note the change in rupees, not just in percentage, because a jump from ₹500 to ₹1,000 is less meaningful than ₹6,000 to ₹8,000.
- Count: tally the number of transactions in each category. A high count means many decisions, and many chances to leak.
- Share: divide each category's average by your total spending to see how much of the month it holds.
A worked example with made-up numbers
Say your monthly spending is about ₹48,000, excluding rent. Here are three categories.
| Category | Monthly average | Change over 4 months | Transactions a month |
|---|---|---|---|
| Food and groceries | ₹14,000 | +₹500 | 46 |
| Transport | ₹6,500 | +₹300 | 18 |
| Shopping | ₹9,000 | +₹4,500 | 22 |
Food is the largest, at ₹14,000, but it grew by only ₹500 and much of it is non-negotiable. Shopping is smaller at ₹9,000 but has doubled by ₹4,500 in four months, so if the trend continues it will overtake food. Transport is steady. The drain is shopping, not food, even though food is bigger.
If shopping were to climb by another ₹1,500 a month and stay there, the extra over a year would be ₹18,000. That is the arithmetic of a growth trend: small monthly increases stack.
Why is the largest category not always the one to cut?
Large categories are often essential. Cutting groceries by 20 percent may mean buying worse food or eating out more, which moves the money rather than saving it. A smaller category that is growing fast or is mostly optional gives more room with less pain. Ask of each category: how much of this is a need, how much is a habit, and how much is a leak?
What do I do once I know?
- Pick one category only, the one with the best mix of size, growth and optional spending.
- Write down one concrete limit and one change in routine to support it.
- Look at it again after a month and compare the average and the count.
- Leave the other categories alone for now.
With SpendixAI, the overview and the ready-made reports group spending by category, and the Report builder lets you filter and group the way this exercise does, with CSV download if you prefer to rank in a sheet. Reviewing categorised rows after each import keeps the data clean enough to trust.
What if two categories look equally guilty?
Compare movable rupees, not totals. Take each candidate's monthly average and ask how much of it is a need. If food is ₹14,000 and you judge two-thirds of it essential, only about ₹4,700 is movable, while shopping at ₹9,000 may be almost entirely movable. Also check for one-offs: a single ₹12,000 purchase can make a category look like a drain for one month, so glance at the typical month as well as the average.
A quick afternoon plan
- Thirty minutes to clean up categories.
- Thirty minutes to compute total, growth and count.
- Fifteen minutes to choose one category and write one limit.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

