Make a twelve-row table with Month, Income, Spend, Savings and Rate columns, fill it with SUMIFS formulas that read your expense log, then insert a combo chart with the rate as columns and a target as a line. The whole tracker takes about twenty minutes and updates whenever you add a row to the log. All amounts below are hypothetical.
What sheets and columns do I need?
- Log sheet: Date in A, Type in B (Income or Expense), Category in C, Amount in D, one row per transaction, amounts as positive numbers.
- Tracker sheet: Month in A, Income in B, Spend in C, Savings in D, Rate in E, Target in F.
- A target cell: put 20% in H1 and label it Target. The figure is only an example; use your own goal.
How do I set up the months and formulas?
- In Tracker A2 type the first month's date, for example 1-Apr-2026. In A3 type =EDATE(A2,1) and fill down to A13, so the list runs April to March.
- Format column A as Date with month and year display, using Format, Number, Custom date and time.
- In B2: =SUMIFS(Log!$D$2:$D$1000,Log!$B$2:$B$1000,"Income",Log!$A$2:$A$1000,">="&A2,Log!$A$2:$A$1000,"<"&EDATE(A2,1))
- In C2: the same formula with "Expense" instead of "Income".
- In D2: =B2-C2. In E2: =IF(B2=0,"",D2/B2). In F2: =$H$1.
- Select B2:F2 and drag the fill handle down to row 13. Format E and F as Percent.
| Month | Income (₹) | Spend (₹) | Savings (₹) | Rate | Target |
|---|---|---|---|---|---|
| Apr | 70,000 | 52,500 | 17,500 | 25% | 20% |
| May | 70,000 | 63,000 | 7,000 | 10% | 20% |
| Jun | 90,000 | 54,000 | 36,000 | 40% | 20% |
| Jul | 0 | 0 | 0 | blank | 20% |
Months not yet reached show income of zero and a blank rate, because the IF in column E returns empty text. A blank is not drawn on the chart, so future months do not appear as zero.
How do I add the chart with a target line?
- Select A1:A13, hold Ctrl, and also select E1:F13 so the chart gets Month, Rate and Target.
- Choose Insert, Chart. Sheets may guess a chart type; in the editor, set Chart type to Combo chart.
- Under Customise, open Series. Select Rate and keep it as Columns.
- Select Target and change its format to Line.
- Set the vertical axis to a percent format and give the chart a title such as Savings rate by month.
- Move the chart next to the table.
How do I read the tracker?
Columns above the line meet your target for that month, and columns below do not. One low month is a reason to look, not to worry. Check whether a large one-off bill, a festival month or an annual premium caused it. Also look at the total row: savings over the year divided by income over the year gives the whole-period rate, which is steadier than any single month.
What can go wrong?
- Dates typed as text in the Log, which SUMIFS ignores. Change them to real dates with Format, Number, Date.
- A Type column with variants such as Income and Salary. Standardise, or add a second SUMIFS row for each.
- Transfers between your own accounts logged as income and expense, which inflate both figures.
- A Log range that stops at row 1000 when your data grows past it.
- A chart range that includes the totals row.
When should I move beyond a sheet?
The tracker is only as good as the Log. SpendixAI can take over the Log: upload statements, choose the account, review the rows, and view overview and report pages from the result. Some people still keep this sheet for a custom chart; if so, SpendixAI can give you a CSV download to paste in.
- Log with real dates and positive amounts.
- Twelve months set with EDATE.
- IF guard on the rate column.
- Combo chart with Rate as columns and Target as a line.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


