Skip to content
The title slide and first slides of the 529 Plan Tracker template

529 Plan 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

Each child has a different college year and a different head start, so this tracker keeps them on separate rows. Beneficiaries holds the college start year, a savings goal, the opening balance, the amount you plan to add each year and the return you assume. It adds the deposits logged on Contributions, shows the balance now and the share of the goal, counts the years to go and projects the balance when college starts.

Projection blends all children into one line and shows money put in against projected balance for each of the next 18 years. The sample has an oldest child about ten years from college who is $24,600 short of a $90,000 goal at a 6 percent return. State plans differ in limits, fees and tax rules, so the sheet takes your assumptions and assumes nothing about them.

Useful for

  • Give each child their own goal and see who is behind
  • Test how a higher yearly deposit closes the gap
  • Log gifts from grandparents next to parent deposits

What's included

  • 4 tabs: Beneficiaries, Contributions, Projection, How to use
  • Beneficiaries: a table with 4 summary figures
  • Contributions: a table
  • Projection: a table with 3 summary figures
  • 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 Beneficiaries 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 my 529 plan contributions?

Record each deposit with its date, the child and who paid it. Add the opening balance when you start, and the total shows your balance from contributions. Your plan statement shows the market value.

How much will my 529 plan be worth by college?

It depends on the starting balance, yearly deposits, years to go and the return you assume. Enter them on the Beneficiaries tab and the projection updates; real returns will differ.

Can grandparents contribute to a 529 plan?

Many plans accept deposits from anyone, but rules and gift tax limits vary. Check your state plan and the IRS, and log the source in the From column.

  • #investment-tracker
  • #529-plan-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…