The ideal file size for import is 500,000 records. While other sizes will import correctly, this size offers the best performance. Follow the mappings in the Mapping Specifications Guide for the given tax year, ensuring all lines of the import file are in ASCII format. If using a delimiter (Tab, Pipe, or Tilde), ensure the file contains only 1 type of delimiter.
Sort the source file according to the mapping selection: PayerCd, Recipient (all keys, ignoring TINtype, CustomerID). If the map selection includes all 4 keys, sort the file by RecipTIN, TINtype, security group, and name. If the map selection is CustomerID, sort by PayerCd and CustomerID.
Don't include invalid data in the source file. For instance, if the field value is 0, 1, or 2, don't send 5 as a value unless you have set up a client-Xref to translate 5 to 0, 1, or 2.
Ensure data consistency across all fields. For example, if you have 12 detailed transactions for the same form, provide the tax location in all rows or key fields like DistCd for a Form 1099-R.
When creating a source file in Excel, avoid using quotation marks around string values and don’t include extra tabs, as these can cause issues when importing the data. Additionally, ensure that leading zeros aren't missing in your file.
Use SFTP for transfer and automatic import. Send only the data and exclude the header row from the file.
Review the Mapping Specifications Guide and check your source file data for compliance with the specifications.