How can I clean up bad taxpayer data before filing 1099s?

To clean up bad taxpayer data before filing 1099s, focus on getting each payee’s legal name, TIN, and address aligned with IRS records before you generate the forms. A practical cleanup process:

1) Standardize your source data

• Make sure each vendor/payee has:
  • Legal name as shown on their tax return
  • Tax ID type: SSN, EIN, or ITIN
  • Tax ID number
  • Mailing address
  • Entity type if you track it
• Remove duplicates caused by variations like:
  • “ABC Co.” vs “ABC Company, Inc.”
  • different spellings, punctuation, or extra spaces

2) Validate TINs

• Check for obvious issues:
  • wrong length
  • missing digits
  • nonnumeric characters
  • invalid SSN patterns
• If possible, run a TIN matching service or IRS-authorized validation process to confirm the name/TIN combination.

3) Confirm names against W-9s

• Compare your records to the vendor’s latest Form W-9.
• If the W-9 is missing or outdated, request a new one.
• Pay special attention to:
  • individual vs business name
  • disregarded entities
  • DBA names not matching the legal name

4) Clean addresses

• Standardize address formatting:
  • street abbreviations
  • suite/unit numbers
  • ZIP+4 if available
• Verify missing or invalid addresses so forms and copies get delivered correctly.

5) Flag mismatches

Create a cleanup report for records where:

• name/TIN don’t match
• TIN is missing or malformed
• duplicate payees exist
• address is incomplete
• W-9 is missing or stale

6) Fix upstream records

• Update the source system, not just the 1099 file.
• If you correct a vendor record, apply the fix consistently across AP, ERP, and tax reporting systems.

7) Reconcile payment data

• Make sure only reportable payments are included.
• Exclude:
  • corporations when exempt
  • payments below reporting thresholds
  • non-reportable transaction types
• Check for split payments or duplicate invoices.

8) Use a final pre-filing QA pass

Before filing:

• compare report totals to your GL/AP totals
• review all records with edits or overrides
• scan for blank TINs, invalid TINs, and duplicate forms
• verify form type and box amounts for each payee

9) Handle missing or bad data early

If a payee refuses to provide proper TIN info, consider IRS backup withholding requirements and document your outreach attempts.

A simple cleanup checklist

• Legal name matches W-9
• TIN present and valid format
• Name/TIN combination verified
• Address complete and standardized
• Duplicates removed
• Record marked reportable/non-reportable correctly
• Totals reconciled before filing

If you want, I can also give you:

1. a 1099 data cleanup spreadsheet template, or
2. a step-by-step validation workflow you can use in Excel, SQL, or your AP system.