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

Retirement Account Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Retirement money tends to scatter across a workplace plan, an old employer rollover and a couple of IRAs. The Accounts tab lists each one with its type and owner, and works out the latest balance, the first balance on record and the change in both dollars and percentage. The Balances tab is where you add one row per account when each quarter closes, copied from the statement.

The Chart tab totals everything by quarter and splits the latest balances by type, so a shrinking old account or a fast-growing new one stands out. Sample data covers four quarter ends from December 2025 to September 2026. Change includes deposits and market moves together, so treat it as the change in balance, not as an investment return.

Useful for

  • Add up every retirement account for a household in one place
  • Record a quarterly balance without logging into five sites
  • Compare how much sits in 401(k)s and IRAs

What's included

  • 4 tabs: Accounts, Balances, Chart, How to use
  • Accounts: a table
  • Balances: a table
  • Chart: a dashboard with 4 summary figures
  • 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 all my retirement accounts in one place?

Make one row per account with its type and owner, then record each balance at a set time, for example on the final day of the quarter. Totals by quarter and by type give you the combined picture.

How frequently should I record my retirement balances?

Many people record them once a quarter, which is often enough to see the trend without reacting to daily swings. Use statement dates so the numbers are comparable.

Is a balance change the same as my return?

No. A balance rises when you deposit and when the market goes up, and falls on withdrawals and market drops. This sheet shows the change in balance; your provider reports investment return separately.

  • #investment-tracker
  • #retirement-account-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More investment tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…