Which Contractors Need a 1099-NEC? A Threshold Test With a Worked Example

You have a list of everyone you paid this year and a nagging feeling that some of them need a form. The question “which contractors need a 1099-NEC” comes down to a short test you can run on each person in about a minute, and a spreadsheet can run it on all of them at once.

This is a record-keeping walkthrough, not tax advice. Thresholds and exceptions change, so confirm the current rules for your filing year with the IRS or your accountant.

The four-question test

For each person or business you paid, ask:

  1. Did I pay them for services in the course of my business? Personal payments are generally out of scope.
  2. Are they a corporation? Payments to corporations are often exempt, with notable exceptions such as attorneys. Check the entity type on their W-9.
  3. Did I pay them by card or through a payment app? Those payments are generally reported by the processor, so they come off your total.
  4. Does the remaining total for the calendar year reach the threshold? For this example we assume $2,000, and the figure lives in one spreadsheet cell so you can change it.

Only someone who passes all four gets a form.

Worked example: five contractors

Fictional numbers, assumed $2,000 threshold:

Contractor Entity Paid Method Reportable total Result
Maya Ortiz Sole proprietor 4 × $750 ACH $3,000 Form required
Tom Reyes Sole proprietor 6 × $350 Check $2,100 Form required
Priya Shah Sole proprietor 12 × $150 ACH $1,800 Below threshold
Jordan Lee Sole proprietor $1,400 + $900 ACH + card $1,400 Below threshold
Harbor Law Law firm $5,000 Check $5,000 Form required

Two results surprise people. Tom’s payments are small individually, but the yearly total is what counts, so he crosses the line. Jordan was paid $2,300 in all, but $900 went through a credit card, so the amount you would report is only $1,400 and he stays below.

The formulas

Assume the ledger has contractor in column B, amount in C, method in D, and a helper column F holding the reportable amount:

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

On a summary tab, total per contractor:

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

Then test against the Settings cell:

=IF(B2>=Settings!$B$2,"Form required","Below threshold - no form")

Copy the formula down the roster and you have a verdict for everyone. Change the threshold cell and every verdict re-decides itself.

Common mistakes

Copy-ready year-end checklist

  1. Export every payment from your bank, cards and payment apps.
  2. Group payments by payee.
  3. Tag each payment with its method.
  4. Remove card and payment-app payments from the reportable column.
  5. Total by payee and compare with the threshold.
  6. Record entity type and W-9 status for every payee over the line.
  7. Request any missing W-9 immediately.
  8. Put the filing deadline on your calendar.

The full build, with the roster, ledger and verdict columns wired together, is covered in the main guide: 1099 contractor payment tracker spreadsheet for Excel and Google Sheets.

The 1099 Contractor Payment Tracker runs this exact test automatically: it categorises each payment, excludes card and payment-app amounts, and gives each contractor a plain-English verdict such as “Threshold met - 1099-NEC required” or “Below threshold - no form required”. It works in Excel and Google Sheets.

General information only, not tax, legal or accounting advice.

Frequently Asked Questions

Which contractors need a 1099-NEC?

Generally, the people and unincorporated businesses you paid for services in the course of your business, once the total paid to them during the calendar year reaches the reporting threshold. Payments to corporations are often exempt, with notable exceptions such as attorneys, and card or payment-app payments are reported by the processor instead. Confirm the current threshold and exceptions with the IRS or your accountant.

Is the 1099 threshold per payment or per year?

Per year, per contractor. You add up everything you paid one contractor in the calendar year and compare the total with the threshold. Six payments of $350 total $2,100 and cross a $2,000 threshold even though each payment is small.

Do I send a 1099 if I paid someone less than the threshold?

Usually no form is required below the threshold, but keep the payment records and the W-9 anyway. Totals can change if you pay the same contractor again before year end, and records support your business deductions.

What if I do not know whether a contractor is a corporation?

Ask for a W-9. It states the entity type and taxpayer ID, so you are deciding from evidence rather than guessing. A tracker with an entity-type column on the roster makes the exemption call visible at year end.

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