Skip to content
The title slide and first slides of the Savings Rate Calculator template

Savings Rate Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
7
Style
Modern
Difficulty
Beginner
Updated
November 16, 2026

Every slide (7)

Overview

Your savings rate is the share of income you keep rather than spend, and it is easier to improve once you can see it month by month. Add your after-tax income on one tab and your deposits on another. The Rate tab divides the two for each month, adds up the year and draws the result as a line next to a target you choose.

A tax refund or a freelance month can swing the rate, so the sheet keeps every source and every deposit as its own row. A second chart shows which accounts received the money, such as an emergency fund or a down payment. The Target tab holds a single percent that is entirely yours, with no recommended number built in, and the Saved against target figure shows the dollars above or below it.

Useful for

  • Find out what share of your income you really save
  • Watch the rate change once your pay or your budget changes
  • Compare each month with a personal savings goal

What's included

  • 5 tabs: Rate, Income, Savings, Target, How to use
  • Rate: a dashboard with 5 summary figures
  • Income: a table
  • Savings: a table
  • Target: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Income tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do you calculate savings rate?

Take the money saved during a period and divide it by the income earned during that same period. The Rate tab does this for each month and for the full year.

Is savings rate based on gross pay or pay after taxes?

Both are used, so pick one and stay with it. The sample uses income after taxes; choose one definition and keep it for every month so the rates can be compared.

What is a good savings rate?

It depends on your goals, your age and your expenses, so the sheet leaves the target to you. Set your own percent on the Target tab and read the gap.

  • #savings-tracker
  • #savings-rate-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More savings tracker templates

See all 22

Also in Finance

All finance templates
Get this template

Preparing your template…