How to Process Electronic 1099 Files
Before you begin this process, make sure you complete the steps to Process 1099 Forms.
If you are submitting your 1099 information electronically to the IRS, there is no need to print the red copy of the 1099 or the 1096.
Only one file per State ID Number should be submitted to ETIDES. If there are multiple companies for the same State ID Number, combine all the 1099 information into one company. Do this while pulling the information by using the Add to Company option.
NOTE: The name control field is required when submitting electronic files. Make sure the name control field is filled in on all 1099 records. See Review 1099 Name Control Information
Do not open the electronic file generated in this step. If you open in Excel, the data may be change resulting in the file being rejected. If you need to open the file, open with NotePad.
There a four file types created in this process based on the field selections in Agency Mode and in Form Mode.
AGENCY MODE | FORM MODE | FILE CREATED | WHERE TO SUBMIT |
Federal | 1099 MISC | Federal MISC | IRS at https://fire.irs.gov/ |
Federal | 1099 NEC | Federal NEC | IRS at https://fire.irs.gov/ |
State/CSV | 1099 MISC | PA MISC | PA E-TIDES at https://www.etides.state.pa.us/ |
State/CSV | 1099 NEC | PA NEC | PA E-TIDES at https://www.etides.state.pa.us/ |
Federal Electronic 1099 Files
NAVIGATION: UTILITIES menu > Create 1099 File
- Company Information - If the correct company information is not displayed, enter it in the appropriate lines.
- This information is pulled from the SYSTEM menu > Company Information. Make sure to update for future 1099 processing.
- Verify the correct Federal ID is entered with no spaces or hyphen.
- Enter in your Contact name, phone number and email address. These are required fields. Electronic files without this information will be rejected.
- Agency Mode: select Federal
- Enter the year you are reporting the taxes for
- TCC: Enter your code given to you by the IRS
- Name Control: Enter your name control. (First four characters of company name or last name)
- Form Mode: Select 1099 MISC
- File Name: Click on the ... Browse to select a location to save the file
- Example: Documents\Horizon\
- Enter the file name. Example: IRS1099MISC-2021
- Save as type will be blank.
- Click the Save button to save the location and Name (this does not create the file).
- At top of the screen click CREATE FILE
- This will save in File Name like: C:\Users\”user”\Documents\Horizon\IRS1099MISC-2021
- At top of the screen click CREATE FILE
- Repeat the process to create the 1099 NEC file.
- Form Mode: Select 1099 NEC
- File Name: click in saved name and change MISC to NEC so it reads like C:\Users\”user”\Documents\Horizon\IRS1099NEC-2021
- At top of the screen click CREATE FILE
- Upload the files you created to the IRS Fire at https://fire.irs.gov/
Pennsylvania State Electronic 1099 Files
NAVIGATION: UTILITIES menu > Create 1099 File
- Company Information - If the correct company information is not displayed, enter it in the appropriate lines.
- This information is pulled from the SYSTEM menu > Company Information. Make sure to update for future 1099 processing.
- Verify the correct Federal ID is entered with no spaces or hyphen.
- Enter in your Contact name, phone number and email address. These are required fields. Electronic files without this information will be rejected.
- Agency Mode: select State/CSV
- Enter the year you are reporting the taxes for
- State Account: Enter your eight (8) digit state account withholding number with no dashes or spaces.
- The Type of Entry will prefill with 001.
- You should not change this unless you are a Sole Proprietor, in which case you would enter "002"
- Form Mode: Select 1099 MISC
- File Name: Click on the ... Browse to select a location to save the file
- Example: Documents\Horizon\
- Enter the file name. Example: PA1099MISC-2021.csv
- Save as type should be .csv
- Click the Save button to save the location and Name (this does not create the file).
- This will save in File Name like: C:\Users\”user”\Documents\Horizon\PA1099MISC-2021.csv
- At top of the screen, click CREATE FILE
- Repeat the process to create the 1099 NEC file.
- Form Mode: Select 1099 NEC
- File Name: click in saved name and change MISC to NEC so it reads like C:\Users\”user”\Documents\Horizon\PA1099NEC-2021.csv
- At top of the screen, click CREATE FILE
Upload File to PA E-TIDES
Upload the files you created at PA E-TIDES https://www.etides.state.pa.us/
MISC REPORTING
- Log into your E-Tides Account
- Go to File Upload
- Select Employer Withholding Tax; click NEXT
- Click on the blue words "Choose File to Upload" near the bottom of the screen
- A pop-up box will appear. Select “1099-MISC/1099-NEC Income Records (CSV)” click the Choose File button at the bottom. You may need to use the scroll bar to see this button.
- Browse for and select your file (from examples above PA1099MISC-2021.csv)
- Click Submit and Close. You will now see your uploaded file at the bottom of the screen.
- Select your file and click NEXT
- You will be required to enter the column headings of the file. It should look like this Example:
- Click NEXT at the bottom of the screen
- You should receive a message similar to the following:
Important: the Invalid records should be 0.
If not zero call your Horizon Support Representative. - If good, Click Insert Records.
NEC REPORTING
- Repeat Steps 1-12 for the NEC file.
- File from creation examples would be named PA1099NEC-2021.csv
Check Status of Upload
- You can check the status of your file by going to "View Filing History" on the left side of the E-Tides screen
Complete REV-1667 Form
- If you are submitting your W2s on E-Tides, do so before continuing.
- All W2s, 1099 MISC and 1099 NEC must be uploaded and inserted before continuing.
- Complete the REV-1667 form.
- The REV-1667 will be filled in from the uploaded files, you just need to check the amounts are included then submit.
How to Create and Upload the PA 1099 File