Spreadsheets

Monthly savings rate tracker with a chart in Google Sheets

Build a twelve-month savings rate tracker in Google Sheets from your expense log with SUMIFS, then add a combo chart with a target line.

Editorial illustration for Monthly savings rate tracker with a chart in Google Sheets

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?

  1. 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.
  2. Format column A as Date with month and year display, using Format, Number, Custom date and time.
  3. 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))
  4. In C2: the same formula with "Expense" instead of "Income".
  5. In D2: =B2-C2. In E2: =IF(B2=0,"",D2/B2). In F2: =$H$1.
  6. Select B2:F2 and drag the fill handle down to row 13. Format E and F as Percent.
MonthIncome (₹)Spend (₹)Savings (₹)RateTarget
Apr70,00052,50017,50025%20%
May70,00063,0007,00010%20%
Jun90,00054,00036,00040%20%
Jul000blank20%

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?

  1. Select A1:A13, hold Ctrl, and also select E1:F13 so the chart gets Month, Rate and Target.
  2. Choose Insert, Chart. Sheets may guess a chart type; in the editor, set Chart type to Combo chart.
  3. Under Customise, open Series. Select Rate and keep it as Columns.
  4. Select Target and change its format to Line.
  5. Set the vertical axis to a percent format and give the chart a title such as Savings rate by month.
  6. 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.
SPENDIXAI JOURNAL

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

Explore your reports