SmartFusion Modules > Accounts Payable > Reports> Print Vendor's 1099s

Recent changes: 
6.225 
- New radio button added for FIRE and IRIS
- When the select process is Create and IRIS is selected on the radio group, will use the new format and create a CSV file for selected 1099 type.

6.205 - Fixed an issue where the Create File option was not recognizing the balances positive or negative amounts when entered via the Enter/Edit 1099 Balance screen.

6.202 - Added new 1099 address fields on the print 1099's report.
- Added new 1099 address fields on the print 1099's electronic file.

6.197 - Changed the tax year format on the printed 1099’s to show all 4 digits.

6.185 - Removed code where the participating state code was hard coded and made it look at the Participating1099States table. Removed Vermont from Participating1099States table.

Refer to bottom of page for changes prior to version 6.180

Introduction

The printing of 1099’s is designed to print on pre-printed laser stock, which could require printing three times. This includes one printing for the Internal Revenue Service copy, one printing for the recipient, and one printing for an internal file copy. The 1099 report itself is designed for the IRS copy (red-colored "A" form). Summary information needed for form 1096 can be optionally printed after the last 1099 is printed.

If your organization plans to submit 1099s on diskette for the IRS, you must first set up the 1099 Magnetic Media Information on page 2 of the Accounts Payable System file. The transmitter control code is also required which can be found in the Organization System Settings. If any of this is missing, an error file will be generated during the process which will instruct the user that the system file is missing information.

Federal versus State Filing

The original design for this process was to use the Combined Federal/State Filing option provided by the IRS. North Carolina has requested that they receive upload files separately and are more stringent in what is considered to be an acceptable format. Updates implemented for the 2020 tax year have incorporated NC requirements into the federal.

Explanation

Select process

  • Print 1099s
  • Create File for FIRE - There is both a "Participating State" export file and a "Non-Participating State" export file; Each export file is inclusive and contains records for all of the different types of 1099s
  • Create file for IRIS - There is a .csv export for each type of 1099

Select 1099 type - Allows the user to select the type of 1099s to be printed. The file creation selects all types and put's them into one file which is allowed by the federal and state governments.

  • Miscellaneous (MISC) - includes Legal, Medical, Other and Rent
  • Dividend (DIV)
  • Certain Government Payments (G) - includes Unemployment, RTAA, Agricultural and Grant
  • Interest (INT)
  • Non-Employee Compensation (NEC) - for 2020 and later
  • Pension Normal Distribution (R)
  • Real Estate (S)

Participating States - enabled for Create File for FIRE

  • Participating States are part of the "Combined Federal/State Filing Program" and a list can be found via the link to IRS Document p1220 below
  • “B” records will contain a state code and "K" records will be created for the "Participating State" file

Nonparticipating States - enabled for Create File for FIRE

IRIS filename - Enabled for Create File for IRIS

Show inactive vendors - controls whether inactive vendors are included in the vendor selection
Enter Vendor range to include
Enter Alpha Sort range to include
Enter Check Date range to include
Minimum 1099 amount to include - defaults to $10.00 for Dividend and Interest 1099s; defaults to $600.00 for all others
Include totals information for form 1096? - visible for 1099-MISC and 1099-G forms
Print 1096s - visible for 1099 forms
Report margins in inches - visible for Print 1099's - Top Margin, Left Margin (2" maximum)

Additional Notes

Sales tax amounts are not reported on the 1099-MISC.

References

IRS Publication 1220 Spec for Electronic Filing (October 2021) https://www.irs.gov/pub/irs-pdf/p1220.pdf
Page 45 - T Record
Page 50 - A Record
Page 73 - B Record
Page 113 - B Record specific to 1099-NEC
Page 138 - C Record
Page 140 - K Record
Page 142 - F Record

Test portal for NC: https://filencdor.ondemand.sas.com/eNC3Web/

FOR IRIS (Information Returns Intake System) Refer: [https://taxdataexchange.org/docs/iris/v2022/csv/Tax1099Nec.html]

Changes Prior to Version 6.180

6.178
- The screen will now populate the Participating States and Nonparticipating States values with values stored on Page 2 of the Accounts Payable System File
- If the Participating States and/or the Nonparticipating States values are changed at the time of printing, the new values will be stored on Page 2 of the Accounts Payable System File

6.174 
- Updated the core design of the 1099-NEC report from one that has a single detail section with layout functionality to one that has three detail sections
- Updated the data pull for the prior 1099 balances to use the new VendorPrior1099Balance table  

6.172 Supplemental - Added the ability to select top and left margins for all forms; Minor additional adjustments for the 1099-MISC and 1099-NEC

6.171 - Updated all of the 1099 report formats for the 2022 tax year  

6.149 - Changed the default threshold values for the different types of 1099s to be stored in the configuration table. The defaults will be 600 dollars for each type except for interest 1099s, which will be 10 dollars. If one changes the minimum amount to include and prints the 1099s, the value will be stored for the next printing of 1099s.

6.148 
- Updated the 1099-G report to print 3 vendors per page instead of 2 vendors per page.
- Options to adjust margins will now be included for the printed 1099-G report.

6.146 Supplemental - updated the "K" record in the 1099-NEC export to be in column 16-33 for the current year instead of 286-303 for the prior year (before 2021).  

6.145 Supplemental - Update the 1099-NEC report to place the State Id in Box 6.  

6.143 - Updated the 1099-NEC report to print 3 vendors per page instead of 2 vendors per page; Updated the 1099 export to match the IRS publication for October 2021.  
6.122/6.123 - Removed the "Combined Federal/State Filing Program" flag and state info for the 1099-NEC section of the export file; Corrected the "Combined Federal/State Filing Program" flag for the Non-Participating State export file  

6.121/6.122 - Incorporated North Carolina format requirements into the created electronic file  

6.118 - Added the 1099-G and 1099-R forms   

6.116 - Added Prior Year Non-Employee Compensation amounts to the 1099-MISC form and export  

6.115 - 2020 Updates for 1099-MISC and 1099-NEC  

6.114 - Added the ability to print 1096s

6.105 - Added the "Show inactive vendors" checkbox that allows users to include inactive vendors in the vendor number selection

6.91 - Corrected filter logic for Vendor Number criteria. Previously, it was excluding vendors with vendor numbers beginning zeroes.

6.65 - Change the processes to pull in vendors who had vouchers flagged for 1099s, but were not flagged as 1099 vendors

6.64 - On the file creation, it now creates 2 files, one for Participating States, and one for non-participating states  

6.41 - Added Foreign Transferor to the created File on this page.