Savings rate is (income minus expenses) divided by income. In Excel, with income in B2 and expenses in C2, type =(B2-C2)/B2 and format the cell as a percentage. If income is 70,000 and expenses are 52,500, the savings rate is 25 percent. Wrap it in IFERROR to avoid a divide-by-zero error in months with no income.
What does the layout look like?
Keep your transactions in one sheet called Log, with Date in A, Type in B (Income or Expense) and Amount in C as positive numbers. On a second sheet, put the first day of each month down column A, income in B, expenses in C, savings in D and the rate in E.
How do I pull monthly income and expenses?
- Income in B2: =SUMIFS(Log!$C$2:$C$1000,Log!$B$2:$B$1000,"Income",Log!$A$2:$A$1000,">="&$A2,Log!$A$2:$A$1000,"<"&EDATE($A2,1))
- Expenses in C2: the same formula with "Expense" in place of "Income".
- Savings in D2: =B2-C2
- Rate in E2: =IFERROR(D2/B2,"")
- Fill each formula down for the months you need.
The EDATE part gives the first day of the next month, so each row counts dates from the start of its month up to, but not including, the start of the next. That handles months of different lengths without any extra work.
How do I handle a month with zero income?
Dividing by zero returns #DIV/0!. IFERROR replaces it with whatever you choose; here, an empty text. The cell stays blank and the chart or average skips it. Zero is a poor substitute because it would suggest you saved nothing, when the truth is that the rate is undefined. Another choice is =IF(B2=0,"",D2/B2), which does the same job and shows only your own intent.
What does a worked example show?
| Month | Income (₹) | Expenses (₹) | Savings (₹) | Rate |
|---|---|---|---|---|
| Apr | 70,000 | 52,500 | 17,500 | 25.0% |
| May | 70,000 | 63,000 | 7,000 | 10.0% |
| Jun | 90,000 | 54,000 | 36,000 | 40.0% |
These figures are hypothetical. If a month's expenses exceed its income, the rate turns negative, which is useful information, not an error.
Should I average the monthly rates?
There are two ways, and they give different answers. A simple average of the three monthly rates above is (25 plus 10 plus 40) divided by 3, which is 25 percent. A weighted rate adds total savings and divides by total income: 60,500 divided by 2,30,000, about 26.3 percent. In Excel the first is =AVERAGE(E2:E4), which skips blank text cells, and the second is =SUM(D2:D4)/SUM(B2:B4). The weighted figure treats a big-income month as bigger, which better matches your actual savings over the period.
For an April to March view, put the twelve months of the financial year in column A and add a total row beneath. The year's savings rate is then =SUM(D2:D13)/SUM(B2:B13), which smooths out a month with a festival bonus or a school fee. If your income is steady, the monthly figure is enough. If it is lumpy, such as a business owner's receipts, lean on the yearly figure.
What mistakes should I watch for?
- Income and expenses in the same column with different signs, while your formula expects positive numbers.
- Text dates, which SUMIFS will skip silently.
- Reimbursements recorded as income, which inflate the rate.
- A half-finished month, which gives a misleading rate until the month ends.
- Ranges that end before the last row of the log.
What next?
Once the rate works, add a twelve-month view and a chart, so the trend is visible. If you find that keeping the log is harder than the formula, SpendixAI lets you import statements and view reports and a dashboard from them; Pro adds budgets and savings goals. The formula here still helps you check any figure you see.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


