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:
- Date first requested (column F).
- Reminder due =
=F2+14. - 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
- Attach the blank W-9 and say it is needed to issue their year-end form.
- Say what you will do without it: that you may be required to withhold on further payments.
- Make it one step: reply with the signed form, no portal or login.
- Put the request date and the person you sent it to in the sheet.
- Do not email taxpayer IDs back and forth in plain text. Use a secure method.
Copy-ready chase list
- Filter your roster for anyone over the threshold with no W-9.
- Send the request today and log the date.
- Set the reminder for two weeks out.
- Hold further payments or ask your accountant about withholding if the form still has not arrived.
- When the form arrives, update the roster the same day and store the PDF securely.
- 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.
Featured on ReadySheetGo
1099 Contractor Payment Tracker — $16.99
A missing-W-9 chase list with follow-up dates and priced withholding exposure. 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.