Map a W-9 to a 1099-NEC Preparation Worksheet

A W-9 requests a taxpayer identification number and related certifications from a U.S. person. It supplies evidence for recipient identity, federal tax classification and address. It does not show how much your business paid, whether the services were personal or business, or which payment channel you used.

Set up two source references in the preparation worksheet: the W-9 version used for the recipient and the reviewed ledger used for the amount. If a vendor changes an address or business structure, keep the prior document alongside the new one and record when the change applies. Do not overwrite the evidence supporting an already filed return.

Use the official W-9 and its instructions to resolve field questions. If the supplied information conflicts, ask the payee to clarify it rather than choosing the most familiar business name.

This is a preparation map, not an IRS upload template. Your software may use different field labels or separate street, city and postal-code fields. Check the field definition before placing the business name into a field that expects the recipient's tax name.

The W-9 instructions direct a sole proprietor to enter the individual name on line 1 and the business or DBA name on line 2. A disregarded entity generally supplies its owner's name on line 1 and its entity name on line 2; its tax classification follows the owner. The form also gives special instructions when an ownership chain contains another disregarded entity.

That distinction can explain why an invoice says one name while the tax document says another. It is not automatically an error. Preserve the relationship in the vendor file so another preparer can understand it without searching email.

An LLC can have different federal tax classifications. A corporate election, partnership classification or disregarded status affects the review. If line 1, line 3a and the TIN appear inconsistent, send the specific inconsistency back for clarification. Do not repair the W-9 yourself.

Fictional example. Morgan Lee supplies a W-9 for a sole proprietorship trading as North Field Design. The fictitious worksheet below intentionally omits a usable taxpayer number. The reviewed 2026 direct service-payment total is $6,250, and no federal income tax was withheld.

Importing only North Field Design because that is the name printed on invoices would discard the documented line-1 identity. Conversely, changing every invoice name is unnecessary. The worksheet connects the commercial name to the tax name while preserving both.

Keep incomplete documents in an exception queue. Examples include a missing TIN, two classification boxes checked, an unexplained change in owner, or a W-9 supplied by someone whose foreign status needs a different documentation review. A U.S. mailing address by itself does not establish that W-9 is the correct form.

The general corporate exception has payment-specific exceptions, including attorneys' fees. An exemption code should therefore be evaluated with the payment facts. See the IRS NEC instructions and the W-9 exemption instructions.

A missing or incorrect TIN also raises backup-withholding and notice questions. Assign those to the responsible tax or payroll reviewer promptly; do not invent a number, insert a sample TIN, or assume that leaving it blank resolves the issue. A name/TIN check, where used, is another control and does not establish the payment's tax treatment.

Review the generated recipient record after import. Confirm that the tax name and business name did not trade places, address components were not truncated unexpectedly, and the TIN type remained associated with the correct identifier. A spreadsheet that looks correct can still be mapped to the wrong software column.

Compare the compensation amount with the approved ledger reference, not the W-9. For 2026, the general NEC reporting threshold is $2,000, with exceptions; classify the payment and recipient before deciding whether a return is required. Store actual withholding independently from compensation.

Use the downloadable field map to record source locations and outstanding questions. Keep full TINs in the restricted source system rather than an ordinary email attachment or public example. The finished packet should show which evidence supplied each value and which questions were resolved before preparation.