Contractor Has Not Sent a W-9: Backup Withholding and a Chase List

It is November, you paid a contractor more than a couple of thousand dollars this year, and you still do not have a W-9 from them. You asked once in the spring. They said they would send it. They did not.

A missing W-9 feels like a paperwork annoyance. In practice it can be a money problem, because without a taxpayer ID you may face backup withholding on payments to someone who crossed the reporting threshold. This guide shows the cost in numbers and gives you a chase list you can copy today.

Record-keeping guidance only, not tax or legal advice. Rules and rates change; confirm them with the IRS or your accountant.

What a W-9 actually gives you

A W-9 is the contractor’s own statement of the details you need to file a form: legal name, business name, federal tax classification, mailing address and taxpayer ID. Without it you are guessing at names and numbers, and a guess on a tax form is a problem.

What the missing form can cost: a worked example

Fictional numbers, with an assumed 24% withholding rate stored in a Settings cell:

Contractor Paid this year W-9 on file Over threshold? Exposure
Tom Reyes $2,100 No Yes $504
Dana Kim $6,400 No Yes $1,536
Marcus Webb $900 No No $0
Maya Ortiz $3,000 Yes Yes $0

Tom: $2,100 × 24% = $504. Dana: $6,400 × 24% = $1,536. Marcus is below the threshold, so there is nothing to chase urgently, though you should still collect his form. Total exposure across the two contractors who are over the line and missing a W-9: $2,040.

The formula is one line, assuming total paid in C, W-9 status in D, threshold test in E, and rate in Settings:

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

Seeing a dollar figure beside each name changes behaviour. A form request becomes something you do today.

The chase schedule

Log three dates and let the sheet do the arithmetic:

  1. Date first requested (column F).
  2. Reminder due = =F2+14.
  3. Final notice due = =F2+28.

Add a status column:

=IF(D2="Yes","Received",IF(TODAY()>G2,"OVERDUE - follow up",IF(TODAY()>F2,"Waiting","Not requested")))

Conditional formatting turns OVERDUE rows amber. When you mark the W-9 as received on the roster, the row clears itself, and the list is finished when it is empty.

How to ask so people actually reply

Copy-ready chase list

  1. Filter your roster for anyone over the threshold with no W-9.
  2. Send the request today and log the date.
  3. Set the reminder for two weeks out.
  4. Hold further payments or ask your accountant about withholding if the form still has not arrived.
  5. When the form arrives, update the roster the same day and store the PDF securely.
  6. Before filing, check that every name and ID on your forms matches a W-9.

To see how this sits inside a full yearly process, including the threshold test that tells you who is over the line in the first place, read the main guide: 1099 contractor payment tracker spreadsheet for Excel and Google Sheets. If you are unsure who needs a form at all, start with which contractors need a 1099-NEC.

The 1099 Contractor Payment Tracker includes a W-9 Chase List tab that does exactly this: it shows who to chase, when the follow-up is due, flags the row amber the day it goes late, and prices the withholding exposure beside each name. It works in Excel and Google Sheets.

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

Frequently Asked Questions

What happens if a contractor never sends a W-9?

Without a taxpayer ID you cannot complete the form accurately, and if the contractor is over the reporting threshold you may be required to apply backup withholding on payments, then deposit it with the IRS. Rules and rates are set by the IRS and change, so confirm the current requirements with your accountant.

What is the backup withholding rate?

The rate is set by the IRS and has been 24% in recent years. Keep the rate in a Settings cell in your tracker rather than typing it into formulas, and confirm it for your filing year.

When should I ask for a W-9?

Before the first payment. Making it part of onboarding is far easier than chasing it in December, and it gives you the legal name, entity type and taxpayer ID you need to file.

How often should I follow up on a missing W-9?

A simple pattern is an initial request, a reminder after about two weeks, and a final notice after about four, with each date logged. Log the date you first asked, because a documented request is useful evidence if the form is never returned.

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