Skip to content
The title slide and first slides of the Savings Account Tracker template

Savings Account Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Most households keep money in more than one savings account: an emergency fund here, a vacation fund there, a home repair fund somewhere else. This tracker lists each account with its purpose, opening balance and APY, then builds every balance from the transactions you enter. Deposits, withdrawals and interest credits sit in one log, and the type decides whether an amount adds to or takes from the balance.

The Interest tab shows what the accounts hold in total, how much interest has been credited and an estimate of the interest for the next twelve months at today's balance and rates. A line chart tracks the combined balance month by month, and a column chart compares the accounts. The sample data covers five months and three accounts, including a vacation withdrawal and a repair that dipped into the home fund.

Useful for

  • Keep separate balances for each saving goal
  • Reconcile the sheet against a monthly bank statement
  • See how much interest the accounts earn each month

What's included

  • 4 tabs: Interest, Accounts, Transactions, How to use
  • Interest: a dashboard with 5 summary figures
  • Accounts: a table
  • Transactions: 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 Accounts 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 I track several savings accounts in one sheet?

Add one row per account on the Accounts tab, then log each transaction with the account name chosen from the dropdown. Balances are calculated from the log.

How do I record interest from my bank?

Add a transaction with the type Interest and the amount credited on the statement. It adds to the balance and to the interest earned total.

Why does the balance not match my bank?

Check the opening balance and look for a missing deposit, withdrawal or interest credit. Pending transactions that the bank has not posted also cause small differences.

  • #savings-tracker
  • #savings-account-tracker
  • #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…