Form 1042-S Excel Template & Import Checker
Download a practical 1042-S spreadsheet for collecting data, then check your saved CSV for common input problems before preparing the official filing format.
Check your 1042-S input file
Download Excel intake template CSV header template
Your selected CSV is read within this page. No file is sent to 1099ERICH's servers. Save your Excel workbook as CSV UTF-8 before checking.
What this 1042-S checker validates
This is an Excel-compatible intake template and local data pre-check, not the official IRS IRIS import schema. It flags missing recipient/withholding-agent details, duplicate or invalid 10-digit unique form IDs, gross income errors, questionable Chapter 3/Chapter 4 rates and exemption-code combinations, and possible country-code format problems. It cannot determine tax treaty eligibility or whether all reporting codes are correct.
For an official upload, use the current IRS 1042-S specifications for the actual tax year. This tool does not produce an IRS-ready submission file.