1099 Contractor Payment Tracker Spreadsheet for Excel and Google Sheets

It is Q4. You paid a handful of contractors this year, a designer here, a handyman there, maybe an attorney, and you just realised that January is coming and you have no idea who you owe a 1099 to. You are also fairly sure you never collected a W-9 from at least two of them.

A 1099 contractor payment tracker spreadsheet fixes this by answering two questions all year long: who do I owe a form to, and do I have their tax ID? This guide shows exactly how to build one in Excel or Google Sheets, with a fully worked example you can copy.

A note before we start: this guide organises your own payment records. It is not tax, legal or accounting advice, and it files nothing for you. Thresholds, rates and deadlines change, so confirm the current figures for your filing year with the IRS or your accountant.

Why a plain ledger is not enough

Most people start by typing contractor payments into a list. That records money. It does not tell you what to do about it, and the questions that matter are all calculations:

A tracker answers all of these with formulas, so nobody has to add columns at 11pm on January 30th.

The five tabs you need

You can build a useful tracker with five tabs.

1. Settings. Put every rule that can change in its own cell: the reporting threshold, your backup withholding rate, your tax year, and your filing deadline. Nothing is hard-coded anywhere else, so when a rule changes you update one cell and every verdict re-decides itself.

2. Contractor Roster. One row per contractor: legal name, business name, entity type (sole proprietor, LLC, corporation, attorney), W-9 on file (Yes/No), taxpayer ID on file (Yes/No), and mailing address.

3. Payment Ledger. One row per payment: date, contractor, amount, payment method, and category. Two helper columns do the work: Reportable amount (the amount, or zero if the payment method is a card or payment app) and Box (which form box the category belongs in).

4. 1099 Determination. One row per contractor with the running total, a threshold test and a plain-English verdict.

5. W-9 Chase List. Everyone over the threshold whose W-9 is missing, with the follow-up date and the withholding exposure.

Worked example: six contractors, one year

All names and numbers below are fictional and the threshold is an assumption set in Settings: $2,000 per contractor per year, with a 24% backup withholding rate. Confirm the figures for your own year.

Here is the ledger summarised by contractor:

Contractor Service Paid by Total paid W-9 on file
Maya Ortiz Graphic design ACH, 4 × $750 $3,000 Yes
Tom Reyes Handyman Check, 6 × $350 $2,100 No
Priya Shah Bookkeeping ACH, 12 × $150 $1,800 Yes
Lakeside Media Marketing PayPal goods & services $4,500 Yes
Jordan Lee Video editing ACH $1,400 + credit card $900 $2,300 Yes
Harbor Law Legal fees Check $5,000 Yes

Total paid across all six contractors: $18,700.

Step 1: strip out payments someone else reports

If you pay by credit card, debit card, or through a third-party payment network such as PayPal goods and services, Venmo business or Stripe, those payments are generally reported by the payment processor, not by you. Putting them on your own form as well would report the same money twice.

In the ledger, add a Reportable amount column. Suppose the payment method is in column D and the amount in column C:

=IF(OR(D2="Credit card",D2="PayPal G&S",D2="Venmo business",D2="Stripe"),0,C2)

In our example that removes Lakeside Media’s $4,500 and Jordan Lee’s $900 card payment, a total of $5,400, leaving $13,300 that is genuinely yours to report.

Step 2: total each contractor’s reportable payments

On the Determination tab, with contractor names in column A:

=SUMIFS(Ledger!F:F, Ledger!B:B, A2)

Where column F is the Reportable amount. The results: Maya $3,000, Tom $2,100, Priya $1,800, Lakeside $0, Jordan $1,400, Harbor $5,000.

Step 3: run the threshold test

Compare each total to the Settings cell. The threshold applies to the yearly total, not to any single payment, which is why Tom’s six $350 payments matter even though none looks big:

=IF(C2>=Settings!$B$2, "Over", "Below")

Maya, Tom and Harbor are over. Priya is below at $1,800. Jordan paid $2,300 in total, but only $1,400 is reportable because $900 went through a card, so he is also below. Lakeside is at $0 reportable.

Step 4: turn the number into a sentence

A number does not tell you what to do. A verdict does:

=IF(C2<Settings!$B$2,"Below threshold - no form required",IF(E2="No","THRESHOLD MET BUT NO W-9 ON FILE","Threshold met - 1099-NEC required"))

Where column E is “W-9 on file”. The Determination tab now reads: Maya, form required; Tom, threshold met but no W-9 on file; Priya, no form; Lakeside, no form; Jordan, no form; Harbor, form required.

That is 3 forms out of 6 contractors, and one of them, Tom, is a problem.

Step 5: price the missing W-9

If a contractor over the threshold never provides a taxpayer ID, you may be required to apply backup withholding. Put the rate in Settings and calculate your exposure:

=IF(AND(D2="Over",E2="No"),C2*Settings!$B$3,0)

Tom: $2,100 × 24% = $504 that you could be on the hook to withhold and send to the IRS. That number is what makes people pick up the phone. Add a date first requested column and a follow-up date (=F2+14, for a 14-day chase window) and the chase list builds itself.

Step 6: total the boxes

Each category belongs in a form box. Nonemployee compensation, which covers most services, goes in one box; rents, royalties and other categories go elsewhere, and attorney payments have their own treatment (an attorney’s own fee is different from settlement money passing through an attorney). Build a small mapping table of category to box, then use SUMIFS to total each box. In our example, Maya ($3,000), Tom ($2,100) and Harbor Law’s fee ($5,000) total $10,100 of nonemployee compensation, ready to transcribe once Tom’s W-9 arrives.

What else is worth tracking

Once the core works, a few additions pay for themselves:

A 10-minute year-end check you can copy today

  1. List every person or business you paid for services this year. Pull from your bank, card and payment-app statements.
  2. Mark who is a corporation, who is not, and who is an attorney.
  3. For each, mark whether you hold a signed W-9.
  4. Total payments by contractor, excluding card and payment-app payments.
  5. Circle anyone at or over the threshold.
  6. Circle anyone circled in step 5 with no W-9, and send the request today.
  7. Write your filing deadline on the calendar.

If you want to go deeper on any of these steps, these guides take each one on its own:

Skip the build

If you would rather not build and debug all of this, the 1099 Contractor Payment Tracker has it done: 12 linked tabs including a Dashboard, a 50-contractor roster, a 250-row payment ledger that categorises itself, a 1099 Determination tab with a plain-English verdict for every contractor, a W-9 chase list with follow-up dates and priced withholding exposure, box-by-box totals, a filing checklist with live countdowns, ten automatic year-end checks, a 15-question worker classification self-check, and a multi-year archive. It handles the card and payment-app exclusion automatically, ships with a complete fictional sample year, and works in Excel and Google Sheets with no macros or add-ons.

The bottom line

A 1099 contractor payment tracker earns its place by turning a pile of payments into decisions. Keep every rule in a Settings tab, strip out card and payment-app payments, total each contractor against the threshold, and let a verdict column say who needs a form. Chase every missing W-9 the day you notice it, because the cost of waiting shows up as withholding exposure. Build it from the formulas above or start from a finished template, but start before January.

This article is general information, not tax, legal or accounting advice. Confirm current thresholds, rates and deadlines with the IRS or a qualified professional.

Frequently Asked Questions

What should a 1099 contractor payment tracker include?

At minimum: a roster of every contractor with legal name, entity type, and whether you hold a signed W-9; a payment ledger with date, amount, payment method and category; a per-contractor total that compares the yearly sum to the reporting threshold; and a list of missing W-9s. Better trackers also separate card and payment-app payments, which are reported by the processor, and total each form box.

Is the 1099 threshold per payment or per year?

It is measured on the total you paid one contractor during the calendar year, not on any single payment. Six payments of $350 add up to $2,100 and cross a $2,000 threshold even though no single payment looks large. Always confirm the current threshold for your filing year with the IRS or your accountant, since it has changed over time.

When are 1099-NEC forms due?

Form 1099-NEC is generally due to the contractor and to the IRS by January 31 following the tax year, with the date shifting to the next business day when it falls on a weekend or holiday. Confirm the exact date for your filing year, and keep a deadline cell in your tracker so it counts down automatically.

Do I need a W-9 from every contractor?

Collect one before you make the first payment, because it holds the legal name, entity type and tax ID you need to file a form. If a contractor who crosses the reporting threshold never supplies a taxpayer ID, you may be required to apply backup withholding, so a missing W-9 is a money problem, not just a paperwork problem. Check current rules with your accountant.

Know Who You Owe a 1099 To, and Whose W-9 Is Still Missing

The 1099 Contractor Payment Tracker — 12 linked tabs and 2,785 working formulas for the money you pay out to contractors: a Dashboard showing forms required, reportable spend, W-9s outstanding and withholding at risk; a 50-contractor Roster; a 250-row Payment Ledger that categorises itself and automatically excludes card and third-party-network payments; a 1099 Determination tab that gives every contractor a plain-English verdict; a W-9 Chase List with follow-up dates and priced backup-withholding exposure; Box Mapping and per-box totals; a Filing Checklist with live deadline countdowns; ten automatic Year-End Close-Out checks; a 15-question Worker Classification self-check; and a Multi-Year Archive. Works in Excel and Google Sheets, no macros and no add-ons. Organises your records; not tax or legal advice.

View on Etsy — $16.99