Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

Trades Business 1099 Contractor Tracker (US)

A 1099 contractor tracker for a trades business: payments per contractor, your threshold, W-9 on file and a year-end list. XLSX with a blank copy.

ForSmall business

Dashboard tab: Paid to contractors $26,190, Reached threshold 5, Missing a W-9 2, Near your threshold 2; column and line chart of Counted per contractor ($); column chart of Paid by month ($); bar...Year-End List tab: columns Contractor, Counted ($), W-9 on file?, Address on file?, Ready?; 5 sample rows.Contractors tab: columns Contractor, Business name, Service, W-9 on file?, W-9 date, Address on file?, Form, Paid this year (auto) ($), Counted (auto) ($), Status (auto); 13 sample rows.Payments tab: columns Date, Contractor, Amount ($), Method, What for, Job, Count it?, Counts (auto), Unknown contractor (auto), Month (auto), Year (auto); 15 sample rows.

DashboardPreviews of the Dashboard, Year-End List, Contractors and Payments tabs with sample data, drawn from the file. Fonts and chart styling can differ in Excel, Numbers and Google Sheets.

View full size (opens image)

What's inside

Format
XLSX, CSV
Contents
6 tabs · 3 charts
Version
1.0 · Updated 7 Oct 2026
Licence
Commercial What this means
Checked
Checked before it ships
  • trades-business-1099-contractor-tracker-us.xlsxXLSX · 86 KB
  • trades-business-1099-contractor-tracker-us-blank.xlsxXLSX · 83 KB
  • trades-business-1099-contractor-tracker-us.csvCSV · 3 KB
  • LICENSE.txtadded to every download

About this item

A 1099 contractor payment tracker for a trades business. It has 6 tabs: Start Here, Dashboard, Contractors, Payments, Year-End List, Settings. Log every payment to a contractor; each one adds up against the reporting threshold you type in Settings, and you choose which payment methods count. Contractors shows what each person was paid this year and says At or over · no W-9, Near your threshold or Under your threshold. The Dashboard with 3 charts shows what you paid contractors ($26,190 in the sample data), how many are at or over your threshold and how many are still missing a W-9. Year-End List gathers everyone at or over the threshold, with what is still missing, ready to print. Payments has a Job column, and the Dashboard shows what you paid for each job. It does not store tax ID numbers. It tracks your numbers; it is not tax advice. You get two files: one with sample data so you can see it working, and a blank copy with the same formulas. Nothing is password-locked. Made for Excel (XLSX).

Reviews

No reviews yet.

You might also grab