How to interpret your bulk check results

Interpreting the codes and headers

Bulk results come back number-coded.

The IRS result has a list of numeric codes that mean the following:

0 - Name/TIN combination matches IRS records
1 - Missing TIN or TIN not 9-digit numeric
2 - TIN not currently issued
3 - Name/TIN combination does NOT match IRS records
4 - Invalid request (i.e., contains alphas, special characters)
5 - Duplicate request
6 - TIN and Name combination matches the IRS SSN records
7 - TIN and Name combination matches the IRS EIN records
8 - TIN and Name combination matches the IRS SSN and EIN records

For other lists, you will get a range of numbers:

• A zero or blank box means that there were no potential matches found on that list for that name.
• Any other number, for example, a 6 means we found that many (6) potential matches.
• To get results that are more detailed on the lists you will need to run a real-time check manually.

List of header abbreviations and which list each header corresponds to:

• OFAC: OFAC/SDN List
• NV: Nevada GCB Excluded Person List
• MS: Mississippi Gaming Commission Exclusion List
• IL: Illinois Gaming Board Exclusion List
• MO: Missouri Gaming Commission Exclusion List
• NJ: New Jersey Casino Control Commission Exclusion List
• DPL: Denied Persons List
• EPLS: Excluded Person List
• HHS: Health And Human Services List
• PEP: Central Intelligence Agency
• FBIMWT: FBI: Most Wanted Terrorists
• FBIWCC: FBI: White Collar Crime
• FBIAVC: FBI: Additional Violent Crimes
• FBICA: FBI: Crime Alerts
• FBICAC: FBI: Crimes Against Children
• FBICC: FBI: Cyber Crimes
• FBICEI: FBI: Criminal Enterprise Investigations
• FBIDT: FBI: Domestic Terrorism
• FBISI: FBI: Seeking Information
• FBISTI: FBI: Seeking Terror Information 
• FBITMW: FBI: Ten Most Wanted
• FBIVCM: FBI: Violent Crimes - Murders
• FSE: Foreign Sanctions Evaders List
• GIIN: IRS FATCA GIIN List
• EUS: EU Sanctions List
• DFTO: Department of State
• DTC: Arms Export Control Act List
• FFI: Foreign Financial Institutions Subj. 561 List I
• EO: IRS Exempt Originations List
• ISA: Iranian Sanctions Act List
• SSI: Sectoral Sanctions Identifications List
• UVL: Unverified List
• EAR: Entity List
• PLC: Palestinian Legislative Council List
• UKE: Ukraine-Russia Related Sanctions List

Opening the file in Excel

The bulk results will open in Notepad by default. Follow these steps to open the file in Excel without dropping any leading zeros.

1. In Excel, go to File. Select the downloaded bulk results file then click the All Files dropdown and select CSV file. Click Open.
   
   
   
   
2. To ensure that the data is formatted properly, select Delimited at the Choose the file type that best describes your data option and select the checkbox for My Data Has Headers. Click Next.
   
   
   
   
3. Leave the Tab checkbox at the Delimiter option selected. Click Next.
4. Highlight all the fields, then select Text in the Column data format section. This will prevent leading zeroes from being dropped. Click Finish.