Skip to content
The title slide and first slides of the Contractor Payments 1099 Tracker template

Contractor Payments 1099 Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Small business owners, landlords and nonprofits that hire independent workers use this tracker to prepare for the January form deadline. The Contractors tab lists each person or business, the service, the W-9 status and the amount paid by methods other than card, then flags who is over the threshold you enter. The Payments tab holds each invoice and how it was paid. The Dashboard totals spending by service and by payment method.

Ask each contractor for a W-9 before paying them, and mark the status in red until it arrives. Enter every payment as it goes out, with the invoice number. The reporting threshold is an input cell because the figure and the rules are set by the IRS and can change; check them each year. A tax professional can confirm which payments count and which forms you must file.

Useful for

  • Know who needs a 1099-NEC before January
  • Chase missing W-9 forms from new contractors
  • Show a bookkeeper a clean list of payments by contractor

What's included

  • 4 tabs: Dashboard, Contractors, Payments, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Contractors: 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 Contractors 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 payments to independent contractors?

Keep a row for every payment with the date, contractor name, service, how it was paid and the amount. Total each contractor at year end. This workbook does that with the Payments tab and a formula on the Contractors tab.

Who needs a 1099-NEC?

It depends on what you paid a contractor for the year and how you paid. The threshold is set by the IRS and can change, so enter the current figure in the threshold column and check the IRS instructions. A tax professional can confirm your own case.

What is a W-9 and when should I ask for it?

A W-9 is the form where a contractor gives you their name and taxpayer details so you can report payments later. Ask for it before the first payment and mark it on the Contractors tab. Keep the forms in a secure place and not in the spreadsheet.

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

Also in Finance

All finance templates
Get this template

Preparing your template…