Skip to content
1099 Income Tracker cover: a sample sheet with paid by clients, set aside for tax and clients and a bar chart, beside the Dashboard, Clients and Payments tabs

1099 Income Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Freelancers and contractors whose several clients issue 1099 forms will get the most from this tracker. The Clients tab lists each client, the service they buy, the status of their form and the share of each payment you want to set aside. The Payments tab works out the set-aside amount on every payment, and the Dashboard shows money received, money set aside, client count, forms still missing and two charts, by client and by service.

Begin by adding your clients and the percentage you want to hold back, then log each payment the day it lands. Compare the Dashboard with your bank statements at month end, since a client's form can show a different total from your own records. The percentages are a planning choice, so ask a preparer what amount your situation needs.

Useful for

  • Tracking payments from several freelance clients
  • Setting money aside each time a client pays
  • Checking which clients have not sent a form yet

What's included

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

Do I always get a 1099 from each client?

Not always. Clients send a form only in certain cases, and the rules depend on how they paid you and how much. Keep your own payment record for every client, whether or not a form turns up.

Why does the set-aside column use a percentage?

It lets you choose a share for each client and watch the money held back for tax build up as payments come in. The percentage is your own planning figure, not a tax rate, so confirm the amount with a tax preparer.

A form shows a different total than the sheet. What now?

Compare the form with your invoices and bank deposits. Ask the client to correct it if the figures differ, and note the gap until your preparer has settled it.

  • #tax-tracker
  • #1099-income-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tax tracker templates

See all 70

Also in Finance

All finance templates
Get this template

Preparing your template…