Your expense-to-income ratio is your spending divided by your income, shown as a percentage, and the same sum works for any single category. Rent of ₹15,000 against an income of ₹60,000 is a rent-to-income ratio of 25 percent. The number is only useful when you compare it with your own earlier months, because nobody else's household has your rent, family or city.
How do I calculate the shares?
Take a hypothetical monthly income of ₹60,000 and a month's categorised spending. Divide each category by the income and multiply by 100.
| Category | Spent | Share of income |
|---|---|---|
| Rent | ₹15,000 | 25 percent |
| Food and groceries | ₹9,000 | 15 percent |
| EMI | ₹6,000 | 10 percent |
| Transport | ₹3,000 | 5 percent |
| Utilities and phone | ₹3,000 | 5 percent |
| Eating out | ₹3,600 | 6 percent |
| Shopping | ₹4,200 | 7 percent |
| All expenses | ₹43,800 | 73 percent |
| Left over | ₹16,200 | 27 percent |
Check the arithmetic: 15,000 + 9,000 + 6,000 + 3,000 + 3,000 + 3,600 + 4,200 = 43,800, and 43,800 divided by 60,000 is 0.73. The left-over ₹16,200 is the other 27 percent. Whether that left-over becomes savings, a goal or an unplanned spend is a separate question that the ratio simply brings to your attention.
What does a share actually tell you?
- Fixed items such as rent and EMI together are 35 percent of income here (25 plus 10). That is the part that does not shrink when you try to cut back.
- Flexible items such as eating out and shopping together are 13 percent (6 plus 7). That is where a change of habit has room to work.
- The total tells you how much of each rupee you earned went out. It says nothing about whether that is good or bad on its own.
What percentage of income should I spend?
There is no honest standard answer. Households with the same income can have very different obligations, such as dependants, a loan, a city with high rent or none of those. Any rule that says spend a fixed percentage on a category is a rough guide for a generic person and may be wrong for you.
A better benchmark is your own history. Pull three to six months of categorised spending and work out each category's share every month. If rent is 25 percent in a normal month and 31 percent after a revision, that is a shift you can see and plan around. If eating out is 6 percent most months and 11 percent in a festival month, you know it was a pattern and not a surprise.
How do I do it in a spreadsheet?
If you keep a sheet with dates in column A, categories in column B and amounts in column C, put the month's income in a cell such as F1 and the category name in E2. Then a share is one formula.
- =SUMIFS($C$2:$C$500, $B$2:$B$500, E2)/$F$1 gives the share as a decimal. Format the cell as a percentage.
- =SUM($C$2:$C$500)/$F$1 gives the all-expenses ratio. The range must hold only that month's rows.
- Argument order for SUMIFS is the range to add first, then each range to test with its criterion.
When a sheet stops being enough, SpendixAI's overview and ready-made reports group categorised spending, and the Report builder lets you filter and group by category over a date range. You still supply your income figure for the ratio.
What should I do with the result?
- Calculate shares for three months, using the same definition of income each time.
- Mark each category as steady, creeping up, or jumpy.
- Pick one creeping category and decide whether the rise is a choice or a drift.
- Set a limit or a goal in rupees, not percentages, because percentages move with income.
- Review in a month and keep your own numbers as the reference.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


