Free tool, no sign up

How many W-9s do you still have to collect?

Turn a vague sense of vendor gaps into a daily request rate you can actually staff before January 31.

The 1099-NEC deadline does not move and neither does the arithmetic behind it. Every reportable vendor without a signed W-9 on file is a name, an address and a TIN you do not have, and each one takes a request, at least one chase, a TIN check and a filing step. Multiply the gap across a book of clients and the January workload becomes a number rather than a feeling.

This planner turns your vendor gap into requests per working day. Run it in November, when the answer is comfortable, rather than in the third week of January when it is not. If the daily figure looks impossible, that is useful information in November and merely alarming in January.

Only clients with vendors likely to cross the reporting threshold.

Check the vendor ledger rather than guessing from memory.

Count only complete forms with a name, address and TIN you can read.

Count real working days, minus whatever holidays your clients take.

Include the second ask, the TIN check and saving the form where you can find it.

Your result

W-9s still missing across the book

62

Each one is a vendor you cannot file for without backup withholding risk.

Total hours to close the gap

7.2

Labor for requests, chases, TIN checks and filing the completed forms.

Vendors to clear per working day

2.1

The steady rate that gets you to zero on the deadline, not before it.

Minutes per working day on W-9 work

14

Block this in your calendar now or it will eat your January close.

The daily rate assumes you start today, so every week you wait raises it, and vendors who have already stopped working for the client are the slowest to reply.

Why the gap is always bigger than clients think

Ask an owner whether they have W-9s and the answer is usually yes. Open the vendor ledger and you find a plumber paid three times in June with no form, a photographer paid through a personal account, and two vendors whose forms are three years old and now carry a stale address. The share on file is a measured number, not a remembered one, so pull it from the ledger before you run this.

The vendors hardest to reach are the ones no longer working for your client, which is exactly the group least motivated to reply. Sort your missing list by last payment date and start with the oldest relationships. Those are the requests that need the most lead time and the most nudges.

Working backward from January 31

If the planner tells you that you need to clear four vendors a day for six weeks, you have a staffing plan and a start date. If it says twelve a day, you either start earlier, split the work, or agree with certain clients now that some vendors will go to backup withholding rather than to a rushed and wrong filing.

The best version of this plan starts in November with a single request per client covering their whole vendor gap, then runs on scheduled nudges through December. January then becomes TIN matching and filing rather than a hunt. That is the difference between a deadline you manage and a deadline that manages you.

Questions about this calculator

How do I find the share already on file?

Run the vendor list for each client, filter to those crossing the reporting threshold, and match it against your stored forms. Count a form as on file only if the name, TIN and address are legible and current. Anything older than a few years deserves a refresh request.

Should I include vendors below the threshold?

It is usually safer to collect a W-9 from any vendor before the first payment rather than deciding later who crossed the line. This planner counts only likely reportable vendors so the daily rate stays realistic, but a collect first policy prevents next January from looking like this one.

What if a vendor simply will not respond?

Document every request you made and the dates, then discuss backup withholding with the client before payments continue. Your job is to make the gap visible early and in writing. A vendor who ignores three requests in December is not going to answer on January 30.

More free tools and working documents

Turn that figure into a shorter month end chase

Whether the result was a yearly chase cost or a stack of W-9s per working day, the lever is the same: fewer manual asks per missing item. A short demo sets one of your clients up end to end, from the standing document list through the nudge schedule to the exception page that ships with the report. The figure on this page stays yours whatever you decide.