Skip to content
The title slide and first slides of the W-2 and 1099 Form Tracker template

W-2 and 1099 Form Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Employees with more than one job and freelancers who work with several clients use this W-2 and 1099 form tracker to know what to expect. The Forms tab lists each payer, form type, deadline, receipt date, status, amount and saved path. The Follow-ups tab logs each time you chase a form. The Dashboard counts forms by type, shows how many are late and totals income on the forms already in hand.

In January, add a row for every payer who paid you. Mark each form Waiting, then switch it to Received when it comes and save its location. If a deadline passes, switch to Late and log the call or email on the Follow-ups tab. Compare the amount on each form with your own income records before you file.

Useful for

  • Know which forms are still missing in February
  • Keep a record of who you chased and when
  • Match form totals to your own income records

What's included

  • 4 tabs: Dashboard, Forms, Follow-ups, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Forms: a table
  • Follow-ups: 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 Forms 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

When do I get my W-2 and 1099 forms?

Employers and payers have a deadline to send most forms near the end of January. Brokers and some partnerships send later. Check IRS guidance for the exact dates each year, and list them as the payer's deadline in the sheet.

Who do I contact when a 1099 never shows up?

Contact the payer first, and log the contact. Note what you were paid in your own files, since you still report the income. A tax professional can advise if the form never arrives.

How do I know which tax forms to expect?

Think of every job, client, bank, brokerage and benefit that paid you in the year. Last year's return is a good guide. Add a row for each, then update the status as forms arrive.

  • #tax-tracker
  • #w2-and-1099-form-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…