Skip to article content
Data preparation

FILING WORKFLOW

Duplicate Vendors in Your 1099 Data: Find Them Before Import

Distinguish duplicate profiles from duplicate payments and create a traceable, reviewed filing population.

Published 4 min read

Source review: · Updated

Filing guide
In this guide

Duplicate vendor profiles can create two opposite 1099 problems: one taxpayer's payments may be split across records, or the same payment may be counted twice. Both can survive a quick visual review of a vendor list.

Resolve duplicates before creating the final filing population. Your task is to establish the correct taxpayer and payment history, while preserving enough detail to explain every consolidation.

Separate profile duplicates from payment duplicates

A profile duplicate means the accounting system has more than one vendor record for the same reviewed taxpayer. The payments under those profiles may all be legitimate and need to be brought together for the applicable payer and reporting category.

A payment duplicate means one transaction appears more than once in the source data. Adding the copies together overstates the history. The right repair is to retain the valid transaction once, with a documented reason for excluding the repeated entry.

Do not let a “remove duplicates” command decide between these cases. Two rows can look similar while representing two actual payments. Two very different vendor names can point to the same taxpayer.

Create a candidate list

Look for repeated or closely related names, taxpayer information within authorized records, addresses, contact details, and vendor references. Search for common variations such as initials, a trade name, a changed business name, or a location added to the profile name.

Treat these matches as review signals. A shared address may belong to separate taxpayers. A changed name may reflect a real entity change. Even a shared TIN needs review in context rather than an automatic merge across every record and account.

Keep the candidate list scoped by payer and tax year. The same payee receiving payments from two different reporting payers is not automatically a duplicate filing problem.

Compare current and relevant historical tax documentation with the vendor profiles. The IRS W-9 instructions distinguish the taxpayer name from a business or disregarded-entity name, a common reason profiles look different even when they concern the same taxpayer.

Resolve conflicting documentation with the appropriate contact through an approved secure process. Record which document supports the decision and who reviewed it. Avoid silently replacing one taxpayer's identifying information with another's to make the records match.

If the facts suggest a sale, restructuring, or other change in taxpayer identity during the year, route the allocation question for tax review. Similar branding does not establish that the whole year's payments belong on one return.

Reconcile the transactions before combining totals

Use payment references, dates, amounts, source systems, and supporting records to test for repeated transactions. Account for voids, reversals, and reissued payments without assuming that every matching amount is a duplicate.

For example, suppose two profiles for the same reviewed payee contain $4,200 and $3,100 of legitimate service payments. Their combined source history is $7,300 before any reporting exclusions or adjustments. If a separate export repeats a $700 payment already included in those totals, the repeated row does not raise the source history to $8,000.

That example assumes the identity and transaction review supports those conclusions. Document the evidence rather than using the arithmetic as proof of which row is valid.

Create a crosswalk instead of erasing history

Assign one reviewed filing-payee reference where consolidation is appropriate, and link every contributing source vendor profile to it. Preserve the original references, combined totals, exclusions, reviewer, and decision date.

The crosswalk lets a reviewer trace a proposed return back to all relevant profiles. It also gives the accounting team a basis for improving future vendor setup without destroying the original transaction trail.

Keep amounts separated by reporting category and box. A single payee may have distinct reportable payment types; resolving duplicate profiles does not mean every amount belongs on one form or in one box.

Run a final population check

Compare recipient counts before and after review and explain the changes. Reconcile the payment totals after duplicate-transaction removal. Review any profile that was excluded entirely and confirm that its valid activity was retained where appropriate.

Check the final preparation file against the crosswalk before import or entry. If you find the problem after a return has already been submitted, preserve the filing evidence and review the appropriate correction path instead of treating it as a simple pre-import cleanup.

Bring reviewed payee records to E-File Magic

Turn the cleaned vendor list into a filing batch with E-File Magic's Spreadsheet & CSV import. Map the approved legal names, identifiers and reconciled NEC or MISC amounts, then check imported counts against your crosswalk. The import creates records; it does not decide which source vendors are the same taxpayer. For verified recipient details, optional Bulk TIN Matching adds a name-and-number check before you release the filing order.

PUT YOUR GUIDE INTO PRACTICE

Put your filing plan into practice.

Start with your reviewed records, or contact our team to confirm the services your filing needs.

The official reference

IRS instructions for this guide

Preview here, or save a copy for later.

Choose the tax year of the return you’re preparing or correcting.

3 PDFs for tax year 2026.

Instructions for Forms 1099-MISC and 1099-NEC

December 2026 editionPDF · 306 KBContinuous use

Form W-9 and taxpayer instructions

March 2024 editionPDF · 138 KBInstructions included in form

Instructions for the Requester of Form W-9

March 2024 editionPDF · 186 KBContinuous use

W-9: W-9 is not an annual return. These are the revisions available during the selected year; use the current W-9 for a new request.

Browse the instruction library

Need another form or year? Explore the full library. Edition dates reflect the IRS publication and may differ from the tax year.

Sources & further reading

Official references used in this guide. Check the applicable form revision and current instructions for your filing year.

  1. IRS instructions: W9
  2. IRS: about form w 9 (opens in a new tab)
  3. IRS instructions: 1099MEC
All articles