Skip to content
The title slide and first slides of the 401(k) Contribution Tracker template

401(k) Contribution Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

The Paychecks tab holds one row per pay date: gross pay, the percent you contribute, the dollars that comes to and the match your employer adds. The Match tab stores the terms from your plan, such as a 50 percent match on the first 6 percent of pay, and the yearly limit as a number you type in. Sample data runs through 23 biweekly paychecks, with a contribution raise in July.

Year Summary totals your contributions and the match, shows how much space remains below the cap and what share of it is used, then charts both by month. If you contribute less than the share your plan matches, the Match column shows money you are leaving behind. Update the limit each January from the IRS notice; the figure in the sample is only an example.

Useful for

  • See if your contribution is high enough to collect the full match
  • Check how much room is left under the yearly limit before a raise or bonus
  • Keep a paycheck-by-paycheck record for tax time

What's included

  • 4 tabs: Paychecks, Match, Year Summary, How to use
  • Paychecks: a table
  • Match: a table
  • Year Summary: a dashboard with 5 summary figures
  • 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 Paychecks 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 401(k) contributions?

Record each pay date with gross pay and the percent you contribute. Multiply the two for your contribution and add the employer match your plan states. Totals by month show how the year is going.

How does an employer 401(k) match work?

The plan states a match rate and a share of pay it applies to, for example 50 cents on each dollar up to 6 percent of pay. Contributing less than that share leaves part of the match unclaimed. The summary plan description has the exact terms.

Where do I find the 401(k) contribution limit?

The IRS publishes the limit each year, and your plan administrator can tell you if your plan sets a lower one. Type the current figure into the Match tab; this sheet does not assume a limit.

  • #investment-tracker
  • #401k-contribution-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…