Missing W-9 status
Identify payees whose onboarding record does not show a received/completed W-9.
Free local CSV cleanup
Vendor & Payee Data Cleanup Tool
Upload a vendor CSV, map your columns, and find records that are not ready for 1099 preparation. Your file stays on your computer.
✓ Browser-only file review1. Choose a CSV
2. Map the columns you have
Do not treat this as IRS verification. A record can pass local checks and still fail IRS TIN Matching or have a tax-classification issue requiring professional review.
What the audit looks for
Find the payees most likely to slow down filing season.
TIN formatting
Flag blank TINs, non-nine-digit values, letters, scientific notation, and spreadsheet damage.
Name consistency
Find blank names and the same TIN appearing with materially different name text.
Address completeness
Spot missing mailing fields before recipient statements and notices need to be sent.
After cleanup
Resolve missing W-9s, keep the corrected values in one master payee record, and use the pre-filing TIN cleanup and form-specific validators before filing.
Vendor cleanup FAQs
Does the vendor cleanup tool upload my CSV?
No. The file is read locally in your browser. The tool does not send the vendor list to 1099ERICH.
Can I use my own column names?
Yes. After the CSV is read, you can map your columns for payee name, TIN, W-9 status, classification, address, city, state, ZIP, and email.
Does it verify the TIN with the IRS?
No. It only checks local completeness and obvious formatting problems. Use IRS TIN Matching when eligible for a database match result.
What does the tool flag?
It can flag missing names, missing or obviously malformed TINs, scientific notation, missing W-9 status, missing classification, incomplete addresses, and duplicate TINs paired with different names.
Can I download the results?
Yes. The tool can create a CSV cleanup report containing the row number and issues found.
Free tool → complete workflow
Move from a free check to the complete 1099ERICH workflow.
The free tools help diagnose individual filing problems. 1099ERICH is the $299 Windows desktop workflow for importing CSV or Excel data, validating records, printing recipient copies, and creating IRIS-ready CSV files.
Windows desktopCSV + Excel importRecipient copiesIRIS-ready CSV$299