Reconcile Contractor Payments Before Preparing 1099-NECs

Create a copy of the complete calendar-year disbursement export. Include the paying legal entity, vendor ID, payment date, payment reference, invoice reference, gross payment, channel, reversal link, and expense description. Keep unpaid invoices in a separate reconciliation column so they do not silently become payments.

For 2026 payments, the general federal NEC reporting threshold is $2,000, subject to recipient and payment exceptions. Backup withholding can create a filing requirement regardless of the payment amount. Apply those rules after building the complete population, not by discarding every small transaction at export. See the IRS NEC instructions.

Keep separate payers separate throughout. A common software vendor ID is useful for finding records, but it does not turn two legal entities into one payer.

Compare your export with bank disbursements, card statements, and payment-platform activity. Start with counts as well as dollars: two missing $500 payments can be concealed by one duplicate $1,000 row. Identify import duplicates by a stable payment reference plus payer, rather than matching only an amount and date.

Give every difference a specific explanation. A voided check should link to its void record and, if applicable, its replacement. A payment entered twice should link to one actual disbursement. A payment outstanding at year end needs its delivery and timing facts reviewed; the bank-clearing date alone should not automatically move it to a different reporting year.

Your control total should explain the complete export. Keep excluded and unresolved transactions visible so that the final recipient total can be rebuilt without relying on someone's memory.

Use two review columns: payment treatment and recipient treatment. The first asks what was paid and through which channel. The second asks who received it and whether an exception applies. A vendor marked as a contractor may also receive rent, a refund, or a payment that belongs in a different workflow.

The IRS instructions exclude payment-card and qualifying third-party-network transactions from payer reporting on NEC/MISC and describe the general corporate exception and its exceptions. Do not infer federal tax classification from an LLC suffix. Use the supplied Form W-9 and investigate inconsistencies.

Fictional 2026 example. Cedar Works pays an individual consultant. All amounts below are invented, and the direct service payments have been confirmed as reportable compensation. No backup withholding occurred.

The raw payment export is $8,800: $4,200 + $1,800 + $1,000 + $1,800. Removing the $1,800 duplicate leaves $7,000 of actual disbursements. Separating the $1,000 card payment leaves a $6,000 NEC candidate total. The unpaid $700 invoice stays outside that calculation.

The worksheet therefore shows three useful numbers: $8,800 exported, $7,000 paid, and $6,000 in the reviewed NEC population. A single total would hide why these amounts differ.

Group approved transactions by paying entity and documented recipient, then sum the reportable compensation. Use an internal recipient key in the working file; restrict access to the separate file containing full TINs. Check whether two vendor IDs are the same documented recipient and whether one vendor ID was reused after a business ownership change.

Include a transaction count, included amount, channel-separated amount, other exclusions, and unresolved amount for each recipient. Do not report an unresolved amount as zero merely to complete an import. Resolve its treatment or document the filing decision with the person responsible for that determination.

Inspect totals just below the applicable threshold. An omitted second vendor record can change the filing result. Also review unusually large totals and totals that changed materially from the prior year; these are efficient places to find reconciliation errors.

Deliver the frozen transaction file, the recipient rollup, a list of decisions that changed totals, and the source documents needed to understand those decisions. Record the export date and the reporting year. A later payment import should produce a new version so the prepared forms can still be traced to the reviewed data.

Before importing, compare the number of proposed returns and aggregate compensation with the rollup. After import, compare them again and spot-check individual records. Matching an aggregate amount does not detect a payment assigned to the wrong recipient.

The downloadable worksheet supplies a small bridge you can complete for each payer. Finish that bridge first, then use the payment-method and W-9 guides to resolve the rows that still need attention.