TIN ComplianceA resource from TIN Comply
Calculator

Vendor file health check

Drop in a CSV or paste rows of vendor names and TINs and get a report of what will fail before it reaches the IRS: bad formats, missing numbers, duplicates, leading zeros lost to a spreadsheet, business names paired with SSN-formatted numbers, and never-issued EIN prefixes. Everything runs in your browser. Nothing is uploaded.

Basis Format rules from SSA and IRS TIN structure; duplicate and pattern checks are heuristics, not IRS resultsPrivacy runs in your browser; nothing you enter is sent or stored
Header row expected. The tool looks for columns named like name, vendor, payee, legal name and tin, ein, ssn, tax id. It never leaves this page.

What it checks

CheckWhat it catchesFix
Missing TINBlank or placeholder values (000000000, 999999999, "N/A", "APPLIED FOR")Solicit a W-9; withhold 24% until received
Not nine digitsEight digits (a leading zero stripped by Excel), ten digits, lettersRestore the leading zero from the source document; re-key
Invalid SSN structureArea 000, 666 or 900–999; group 00; serial 0000Cannot be a valid SSN; check whether it's an EIN or a typo
Never-issued EIN prefixTwo-digit prefixes the IRS has never assignedTypo, or the number is an SSN entered in EIN format
Business name with SSN formatNames containing LLC, Inc, Corp, Co., Ltd, LP, PLLC, PC, Trust with a ###-##-#### numberLikely a disregarded LLC or sole proprietor: line 1 should be the owner's name
Duplicate TIN, different namesThe same nine digits on two or more vendor recordsMerge duplicates; if the names are unrelated, one of them is wrong
Same name, different TINsOne vendor name with two numbersUsually an SSN and an EIN for the same person; keep the pair that matches
Sequential or repeated digits123456789, 111111111 and the likePlaceholder data; solicit the real TIN

A file that passes every check can still mismatch at the IRS, because the checks here are about structure and the IRS match is about whether the name and number belong together. That step is what IRS TIN matching does.