1099-MISC Income Records (CSV)
The file you upload needs to be a Comma Delimited file (i.e. CSV format) and contain a data element for each column specified below. It should contain a minimum of 34 columns of data.
Column | Data Format | Required |
---|---|---|
Payer Entity ID | 9-digit Entity ID number for business being filed. Usually a Federal Employer Identification Number (FEIN) or Social Security Number (SSN), containing no dashes or spaces. | Yes |
Type of Entity ID | 3-digit number indicates the Entity ID Type. Please refer to Appendix A for Code List. | Yes |
Account Number | The 8-digit Withholding ID containing no dashes or spaces. | |
Tax Year | 4-digit value of year reported. | Yes |
Recipient Taxpayer Identification Number | 9-digit number for recipient Social Security Number, Individual Taxpayer Identification Number or Federal Employer Identification Number, containing no dashes or spaces. | Yes |
Taxpayer Identification Type | 3-digit number indicates the Recipient Identification Type. Please refer to Appendix A for Code List. | Yes |
Recipient Number | 20 characters max. | |
Recipient Last Name | 30 characters max. | Yes |
Recipient First Name | 20 characters max. | |
Recipient Middle Name | 20 characters max. | |
Recipient Name Suffix | 4 Characters Max | |
Recipient Address Line 1 | Apartment Number, Box Number, Street Address, or Unit and Box for U.S. Military Address, 50 characters max. | Yes |
Recipient Address Line 2 | Street Address if not on Address Line 1, 50 characters max. | |
Recipient Address Line 3 | Hamlet, Village or other information if it needs to appear before the City or Town, 50 characters max. | |
Recipient City/Town | City, Town, etc., APO, FPO, DPO for U.S. Military Address, 50 characters max. | Yes |
Recipient Governing District | U.S. States use 2 character abbreviation, Canadian Providences use 2 character abbreviation, Mexico Federal Districts use 3 character abbreviation, U.K. County use county name etc., U.S. Military Addresses use AE, AP, or AA, 30 characters max. | Yes |
Recipient Postal Area | U.S. Zip Code, Canadian/Mexico Postal Code, U.K. Postal Code, etc., 15 characters max. U.S. Military Address use 5-digit Zip Code. | Yes |
Recipient Country Code | 2 character country code as specified in EFW2 Publication 42-007. | Yes |
Rents (1099-MISC Box 1) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
Royalties (1099-MISC Box 2) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
Other Income (1099-MISC Box 3) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
Medical and Health Care Payments (1099-MISC Box 6) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
Non-Employee Compensation (1099-MISC Box 7) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
Gross Proceeds Paid to an Attorney (1099-MISC Box 14) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
State Tax Withheld (1099-MISC Box 16) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. You must obtain a PA Other Income Withholding Account ID, If reporting greater than zero or if you are filing the upload from the Account Panel. | Yes |
State Income (1099-MISC Box 18) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
The fields below (Payer Name and Address) are not required for payers who have a PA Employer Account ID. | ||
Payer Name | Business Name, 50 characters max. | Yes** |
Payer Address Line 1 | Apartment Number, Box Number, Street Address, or Unit and Box for U.S. Military Address, 50 characters max. | Yes** |
Payer Address Line 2 | Street Address if not on Address Line 1, 50 characters max. | |
Payer Address Line 3 | Hamlet, Village or other information if it needs to appear before the City or Town, 50 characters max. | |
Payer City/Town | City, Town, etc., APO, FPO, DPO for U.S. Military Address, 50 characters max. | Yes** |
Payer Governing District | U.S. States use 2 character abbreviation, Canadian Providences use 2 character abbreviation, Mexico Federal Districts use 3 character abbreviation, U.K. County use county name etc., U.S. Military Addresses use AE, AP, or AA, 30 characters max. | Yes** |
Payer Postal Area | U.S. Zip Code, Canadian/Mexico Postal Code, U.K. Postal Code, etc., U.S. Military Address use 5-digit Zip Code, 15 characters max. | Yes** |
Payer Country Code | 2 character country code as specified in EFW2 Publication 42-007. | Yes** |
The file you upload needs to be a Comma Delimited file (i.e. CSV format) and contain a data element for each column specified below. It should contain a minimum of 34 columns of data.
Column | Data Format | Required |
---|---|---|
Payer Entity ID | 9-digit Entity ID number for business being filed. Usually a Federal Employer Identification Number (FEIN) or Social Security Number (SSN), containing no dashes or spaces. | Yes |
Type of Entity ID | 3-digit number indicates the Entity ID Type. Please refer to Appendix A for Code List. | Yes |
Account Number | The 8-digit Withholding ID containing no dashes or spaces. | |
Tax Year | 4-digit value of year reported. | Yes |
Recipient Taxpayer Identification Number | 9-digit number for recipient Social Security Number, Individual Taxpayer Identification Number or Federal Employer Identification Number, containing no dashes or spaces. | Yes |
Taxpayer Identification Type | 3-digit number indicates the Recipient Identification Type. Please refer to Appendix A for Code List. | Yes |
Recipient Number | 20 characters max. | |
Recipient Last Name | 30 characters max. | Yes |
Recipient First Name | 20 characters max. | |
Recipient Middle Name | 20 characters max. | |
Recipient Name Suffix | 4 Characters Max | |
Recipient Address Line 1 | Apartment Number, Box Number, Street Address, or Unit and Box for U.S. Military Address, 50 characters max. | Yes |
Recipient Address Line 2 | Street Address if not on Address Line 1, 50 characters max. | |
Recipient Address Line 3 | Hamlet, Village or other information if it needs to appear before the City or Town, 50 characters max. | |
Recipient City/Town | City, Town, etc., APO, FPO, DPO for U.S. Military Address, 50 characters max. | Yes |
Recipient Governing District | U.S. States use 2 character abbreviation, Canadian Providences use 2 character abbreviation, Mexico Federal Districts use 3 character abbreviation, U.K. County use county name etc., U.S. Military Addresses use AE, AP, or AA, 30 characters max. | Yes |
Recipient Postal Area | U.S. Zip Code, Canadian/Mexico Postal Code, U.K. Postal Code, etc., 15 characters max. U.S. Military Address use 5-digit Zip Code. | Yes |
Recipient Country Code | 2 character country code as specified in EFW2 Publication 42-007. | Yes |
Rents (1099-MISC Box 1) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
Royalties (1099-MISC Box 2) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
Other Income (1099-MISC Box 3) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
Medical and Health Care Payments (1099-MISC Box 6) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
Non-Employee Compensation | Enter 0.00 for this field. | Yes |
Gross Proceeds Paid to an Attorney (1099-MISC Box 10) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
State Tax Withheld (1099-MISC Box 15) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. You must obtain a PA Other Income Withholding Account ID, If reporting greater than zero or if you are filing the upload from the Account Panel. | Yes |
State Income (1099-MISC Box 17) | Numeric only including 2 decimal places. Do not report negative figures, minimum value 0.00, maximum value 999999999.99. | Yes |
The fields below (Payer Name and Address) are not required for payers who have a PA Employer Account ID. | ||
Payer Name | Business Name, 50 characters max. | Yes** |
Payer Address Line 1 | Apartment Number, Box Number, Street Address, or Unit and Box for U.S. Military Address, 50 characters max. | Yes** |
Payer Address Line 2 | Street Address if not on Address Line 1, 50 characters max. | |
Payer Address Line 3 | Hamlet, Village or other information if it needs to appear before the City or Town, 50 characters max. | |
Payer City/Town | City, Town, etc., APO, FPO, DPO for U.S. Military Address, 50 characters max. | Yes** |
Payer Governing District | U.S. States use 2 character abbreviation, Canadian Providences use 2 character abbreviation, Mexico Federal Districts use 3 character abbreviation, U.K. County use county name etc., U.S. Military Addresses use AE, AP, or AA, 30 characters max. | Yes** |
Payer Postal Area | U.S. Zip Code, Canadian/Mexico Postal Code, U.K. Postal Code, etc., U.S. Military Address use 5-digit Zip Code, 15 characters max. | Yes** |
Payer Country Code | 2 character country code as specified in EFW2 Publication 42-007. | Yes** |
**Note: Payer Name and Address fields are required only when the Account Number is not entered.