Testing 1099 XML files

Suzette Ciplickas Updated by Suzette Ciplickas

For more information on the nodes in the file refer to IRS-variable Definitions.xsd

For more information and to make sure that my file is right refer to the individual form .xsd files. For example: IRS-Form1099NECType.xsd

Opening the xml file in Notepad++ is the easiest way to read the file.

The file is laid out in sections. You can click on the + and expand the sections or collapse each section.

Each Section has a beginning and ending.

The beginning of each file, IRTransmissionManifest, will be the same for all form types

The IRSubmission1Grp follows the IRTransmissionManifest. The FormTypeCd will change for each form type. The IRSubmission1Grp is for each form type and Issuer.

TransmitterGrp

The TransmitterGrp is the Transmitter Information from Step 1 of MM

MailingAddressGrp

Throughout the file we will have address's. Transmitter address, Issuer Address and Recipient Address. All address's have a MailingAddressGrp the MailingAddressGrp contains ForeignAddress or USAddress.

The following items will have a MailingAddressGrp: TransmitterGrp, IssuerDetail, RecipientDetail.

MailingAddressGrp consist of US Address and Foreign Address. Only one address type will be used im the MailingAddressGrp . Depending on the type of address. If it's a US Address than the Foreign Address group will be removed. If it's a Foreign Address than the US Address group will be removed.

This example the Transmitter has a US Address and BusinessName with one line for the business name.

This example the Transmitter has a Foreign Address and BusinessName with two lines for the business name.

VendorGrp

The VendorGrp will always be the same - the information is hard coded in the file.

IRSubmission1Grp

The IRSubmission1Grp is per Client and Form Type

IRSubmission1Grp consist of the following groups:

⦁ IssuerDetail (Client Information)

⦁ ContactPersonInformationGrp

⦁ IRSubmission1FormTotals

⦁ IRSubmission1Detail - RecipientDetail and Form Information

The IRSubmission1Grp is for each Payer and Form Type. The example below has 2 payers in the file.

For example if I have selected the following to be in a file: Client1 Form 1099Misc, Client1 Form 1099NEC, and Client2 Form 1099Misc than I would have 3 IRSubmission1Grp in the file.

PersonName or BusinessName

The IssuerDetail and RecipientDetail have similar items

The PersonName or BusinessName will be in the group - Not Both.

PersonName or BusinessName is determined on the type of TIN.
The TIN type is stored in TINSubmittedTypeCd - the values can be: INDIVIDUAL_TIN (SSN), BUSINESS_TIN (EIN), UNKNOWN (APPLED FOR)

⦁ TIN is an SSN : PersonName is used and BusinessName is removed

⦁ TIN is an EIN: BusinessName is used and PersonName is removed

⦁ TIN is APPLIED FOR IssuerDetail (Client Information): BusinessName is used and PersonName is removed

⦁ TIN is APPLIED FOR RecipientDetail on the Form Individual name (first/MI/Last): PersonName is used and BusinessName is removed

⦁ TIN is APPLIED FOR RecipientDetail on the Form Name is on one line: BusinessName is used and PersonName is removed

IssuerDetail

IssuerDetail has the Payers/Client Information.

ContactPersonInformationGrp

IRSubmission1FormTotals

IRSubmission1Detail - RecipientDetail and Form Information

How did we do?

Contact