Skip to content
The title slide and first slides of the High Yield Savings Comparison template

High Yield Savings Comparison

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

Two savings accounts that advertise similar rates can pay very different amounts once a monthly fee, a minimum balance and your own deposits are counted. This sheet puts each account on a row and applies the same starting balance and monthly deposit to all of them, so the comparison is fair. It then works out twelve months of compounded interest, subtracts the fees and shows the balance you would have at the end.

The Compare tab ranks the accounts in a bar chart, names the one that earns the most and shows how far apart the best and worst accounts are. A minimum check flags any account where your balance falls short of the amount needed to earn the advertised APY. Rates are inputs, never built in, so update them whenever a bank changes its rate.

Useful for

  • Choose a home for an emergency fund by comparing five offers
  • Check whether a monthly fee cancels out a higher rate
  • Re-check your current bank against new accounts every year

What's included

  • 3 tabs: Compare, Accounts, How to use
  • Compare: a dashboard with 5 summary figures
  • Accounts: a table
  • 1 chart 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 is interest calculated on a savings account?

This sheet converts the APY to a monthly rate, adds your monthly deposit and compounds for twelve months. Your bank may credit interest daily or monthly, so the real figure can differ by a few cents.

Do monthly fees matter on a savings account?

On a small balance they can erase the interest. The Fees column multiplies the monthly fee by twelve and the Net column subtracts it.

Do savings rates change?

Yes, most savings rates are variable and move with the market and the bank. Update the APY column when your bank changes its rate.

  • #savings-tracker
  • #high-yield-savings-comparison
  • #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…