Spreadsheets

Expense-to-income ratio: formula and what the result means

Expense-to-income ratio explained: the one-cell formula, a worked example at three spending levels, and what the number does and does not tell you.

Editorial illustration for Expense-to-income ratio: formula and what the result means

The expense-to-income ratio is your total spending in a period divided by your income for the same period, shown as a percentage. In a sheet it is one cell: =total expenses / income. If you spend ₹56,000 against income of ₹80,000, the ratio is 0.70, or 70 percent. This is a personal budgeting ratio, not the expense ratio that mutual funds quote.

What is the one-cell formula?

With the month's first date in B1, income for that month in B2, and your log with Date in A, Type in C and Amount in D, the ratio is: =IF($B$2=0,"",SUMIFS($D$2:$D$500,$C$2:$C$500,"Expense",$A$2:$A$500,">="&$B$1,$A$2:$A$500,"<"&EDATE($B$1,1))/$B$2). Format the cell as a percentage. The IF guard stops a divide-by-zero error if income is blank. If you already have a total spend cell, such as B3, the formula shrinks to =B3/B2.

What does the number mean at different levels?

The ratio is a description, not a grade. Say your hypothetical income for a month is ₹80,000. Here is how three results read, using the same income.

Spending (₹)RatioPlain reading
44,00055%Under half of income is left after spending
64,00080%Little room; one extra bill can push it over
84,000105%Spending exceeded income; the gap came from savings or borrowing

Ratios above 100 percent are not mistakes. They tell you that something other than this month's income paid for the month, which is worth knowing. No threshold applies to everyone. A household with a large fixed rent in an expensive city and one living with family will naturally sit at different levels.

Which expenses should I include?

  • Everyday spending: food, transport, bills, shopping.
  • Fixed commitments: rent, EMIs, insurance premiums, school fees, society maintenance.
  • Annual or occasional costs spread across the months, or listed in the month they occur, applied consistently.
  • Cash spending you record by hand; unrecorded cash makes the ratio look lower than reality.

Leave out transfers between your own accounts and, if you count card purchases, the bill payment that settles them. Decide how you treat regular investments and apply the same rule every month; the ratio is only useful if its definition does not shift.

How do I calculate it for a quarter or a year?

Add up spending and income over the whole period first, then divide once. Say a hypothetical April to June has expenses of 52,000, 61,000 and 49,000, which total 1,62,000, against income of 78,000 in each month, which totals 2,34,000. The ratio is 1,62,000 divided by 2,34,000, about 69.2 percent. Averaging the three monthly ratios gives the same answer here only because income is equal each month; with uneven income the totals-first method is the one to trust.

What are the traps?

  • Using gross income for one month and take-home for another.
  • A bonus or irregular receipt in one month that makes the ratio fall sharply.
  • Refunds recorded as income when they should reduce the expense instead.
  • Comparing your ratio with a friend's, which tells you little.

How can I use the ratio day to day?

Use it as a monthly health check next to your category totals. If the ratio rises, open the category table and find which line moved. Compare it with the same month last year to account for seasonal costs. When the log is built from statements, SpendixAI can show overview and category reports and let you download a CSV, so you spend the time reading the ratio and not producing it.

  • Income and expenses for the same period.
  • One definition of income, one list of what counts as expense.
  • IF guard for blank income.
  • Twelve-month trend, not just this month.
SPENDIXAI JOURNAL

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

Explore your reports