Managing multiple savings goals can become difficult without a proper system to track your progress. Whether you are saving for a new car, home renovation, emergency fund, vacation, or any other financial goal, a structured savings tracker can help you stay organized and motivated.

This Savings Tracker Template in Google Sheets helps you track your savings goals automatically with formulas, progress calculations, and a visual dashboard.

With this template, you can:

• Track multiple savings goals in one place
• Monitor your current goal total automatically
• Compare saved amounts with target amounts
• Automatically identify completed goals
• Visualize progress using a dashboard and chart

In this tutorial, you’ll learn how to use the template and also how to build the entire savings tracker from scratch in Google Sheets.

Download the Savings Tracker Template

Click the button below to preview and download the template.

Preview & Download

How to Use the Savings Tracker Template

Step 1: Set Up Your Savings Goals

Open the Goals & Targets sheet, which is the first tab in the template.

In this sheet:

• Enter your savings goals in Column A
• Enter the target amount for each goal in Column B

The data entered in this sheet is used throughout the savings tracker.

Step 2: Enter Your Savings Transactions

Next, open the Data sheet.

You only need to enter values in the first four columns. The remaining columns are automatically generated using formulas.

Enter the following details:

• Column A: Date of savings
• Column B: Goal name
• Column C: Description
• Column D: Savings amount

The Goal Name column contains a drop-down list linked to the goals entered in the Goals & Targets sheet.

Automatically Generated Columns

As you add savings entries, the template automatically updates:

• 5th column: Current Goal Total (running total for each goal)
• 6th column: Target amount fetched from the Goals & Targets sheet
• 7th column: Goal completion status

Once a goal reaches its target amount, the corresponding row is automatically highlighted for quick identification.

Dashboard Overview

The Dashboard sheet provides a quick overview of your savings progress.

It displays the following fields:

Goal Name	Current Goal Total	Remaining	Progress (%)

The dashboard also includes a progress bar chart that visually displays:

• Total target amount
• Current savings progress
• Percentage completed for each goal

This makes it easy to track your savings progress at a glance and understand how close you are to reaching each financial goal.

Creating the Savings Tracker Template in Google Sheets

The following section explains how to build the entire Google Sheets savings tracker template from scratch, including the formulas and automation used in the template.

1. Create the Goals & Targets Sheet

Create a sheet named Goals & Targets.

In this sheet, create a table named Target with the following columns:

• Goal Name
• Target Amount

To convert a regular range into a table in Google Sheets:

1. Select the range
2. Right-click
3. Choose Convert to table

Google Sheets assigns a default table name such as Table1. Rename it to Target because the table name is used in the formulas later in this tutorial.

2. Create the Data Sheet

Create another sheet named Data.

In this sheet, create a table named Data with the following columns:

1. Date
2. Goal Name
3. Description
4. Amount
5. Current Goal Total
6. Target Amount
7. Goal Reached?

Set the Column Types

Click the drop-down arrow in each column header and select Edit column type.

Use the following column types:

Column	Type
Date	Date
Goal Name	Drop-down
Description	Text
Amount	Number
Current Goal Total	Number
Target Amount	Number
Goal Reached?	None

Create the Goal Name Drop-Down

In the Goal Name column, create a drop-down list using the Goal Name column from the Goals & Targets sheet as the source range.

Add the Formulas

Enter the following formula below the Current Goal Total header:

=ArrayFormula(
  MAP(
    Data[Goal Name], 
    LAMBDA(
      r, 
      SUMIFS(
        Data[Amount], 
        Data[Goal Name], r, 
        ROW(Data[Goal Name]), "<="&ROW(r)
      )
    )
  )
)

This formula calculates the running total for each savings goal.

Enter the following formula below the Target Amount header:

=ArrayFormula(
  XLOOKUP(
    Data[Goal Name], 
    Target[Goal Name], 
    Target[Target Amount],,0
  )
)

This formula fetches the target amount for each goal from the Goals & Targets sheet.

Enter the following formula below the Goal Reached? header:

=ArrayFormula(
  IF(Data[Current Goal Total]=0, FALSE, Data[Current Goal Total]>=Data[Target Amount]
))

This formula returns:

• TRUE when the goal target is reached
• FALSE when the goal is still incomplete

Highlight Completed Goals Automatically

To highlight completed goals automatically:

1. Select the data range below the header row (example: A4:G1000)
2. Open Conditional formatting
3. Select Custom formula is
4. Enter the following formula:

=$G4

Here, G4 represents the first cell in the Goal Reached? column.

When a goal is completed, the entire row is highlighted automatically.

3. Create the Dashboard Sheet

In the Dashboard sheet, enter the following headers in row 3:

Goal Name	Current Goal Total	Remaining	Progress (%)

Then enter the following formula in cell A4:

=ArrayFormula(
  LET(
    goals, FILTER(Target[Goal Name], Target[Goal Name]<>""),
    targets, FILTER(Target[Target Amount], Target[Goal Name]<>""),
    rc, MAP(goals, LAMBDA(g, SUMIF(Data[Goal Name], g, Data[Amount]))),
    bal, targets - rc,
    pct, IFERROR(rc / targets, 0),
    IF(IFNA(goals)="",,HSTACK(goals, rc, bal, pct))
  )
)

Format the last column as a percentage if required.

Create the Savings Progress Chart

Create a stacked bar chart using the dashboard data.

While configuring the chart:

• Use the Progress (%) column as labels for the Goal Total series
• Do not use the Progress (%) column as a separate series

Google Sheets may automatically add the Progress column as a series. If that happens, remove it and assign it as labels instead.

This creates a clean savings progress visualization where:

• The full bar represents the total target amount
• The filled portion represents the saved amount
• The progress percentage appears directly on the bar

Conclusion

This Savings Tracker Template in Google Sheets provides a simple and automated way to track your savings goals and monitor financial progress.

By combining formulas, conditional formatting, drop-down lists, and charts, the template helps you manage multiple savings goals efficiently without manual calculations.

Simply enter your savings transactions regularly, and the template automatically updates your totals, progress, and dashboard.

For more free automated templates, check out Free Google Sheets Templates (Fully Automated & Dynamic).