Posted by EQ Tech on Fri, Jan 22, 2021

Sage 300 and the New 1099 Forms

The IRS has introduced the new Form 1099-NEC for reporting independent contractor income, non-employee compensation.  The Form 1099-MISC is still in use, but only to report miscellaneous income and excluding non-employee compensation. 

Sage has updated their programs to work with the new 1099-NEC forms.  Here’s what you need to know:

1. Update your Sage 300 (Accpac) system to the latest product update.

  • Version 2021 – Product update 1
  • Version 2020 – Product update 4
  • Version 2019 – Product update 7
  • Version 2018 or older - contact Equation (support@equationtech.us) for a custom 1099-NEC form

2. Once your product update has been installed, go to AP Setup, 1099 / CPRS Codes:

Sage 300 1099 Codes

Enter your current 1099 code, and fill in the two new fields Tax Reporting Type and Amount Type.  Make sure to do this step for all of your 1099 codes.

3. When you are ready to print your 1099s, go to AP Vendor Reports, Print 1099/1096 Forms.

Sage 300 1099 forms

Select the Form 1099 and then enter the tax year 2020.  When you enter the Form Type 1099-NEC, Sage automatically populates the Use Form field to be AP 1099NEC-2020.RPT.  This is the new specification file that works with the new IRS forms.  When you change the Form Type to 1099-MISC the Use Form field updates to the new AP 1099MISC-2020.RPT form. 

Also note that the form types are sensitive to the tax year – if you enter 2019 for the tax year, you cannot select a Form Type 1099-NEC.  When you try to print, Sage will pop up with an error that says “Form 1099-NEC is not valid for the year 2019.”

4. Sage has the ability to e-file 1099s. Go to AP Periodic Processing / 1099 Electronic Filing.  Sage will create the file and then you can upload it to the IRS site with your FIRE account. Click here for information on FIRE accounts:  https://www.irs.gov/e-file-providers/filing-information-returns-electronically-fire

HOW TO EDIT 1099 VENDOR CODES OR AMOUNTS

At some point during year end processing, you may discover that the 1099 codes or amounts you’ve recorded for a vendor need to be edited or adjusted.

To Change a 1099 Code:

  1. Go to A/P Vendors and select Vendors
  2. Select the vendor with the issue
  3. Click on the Invoicing tab
  4. Choose the correct 1099 code
  5. Click on Save and then Close

To Allow Editing of 1099 Amounts:

  1. Go to A/P Set Up and select Options
  2. Select Transactions Tab
  3. Check of Allow Edit of 1099/CPRS Amounts
  4. Click Save and then Close 

To Update a Vendor’s 1099 Amount:

  1. Go to A/P Vendors and choose A/P 1099/CPRS Inquiry
  2. Filter to Vendor(s)
  3. Filter to the incorrect 1099 Code
  4. Click on the double arrows (Go option)
  5. Note the information for all entries listed
  6. Filter to the correct 1099 Code
  7. Click on the double arrows (Go option)
  8. Press the Insert key to add a new line
  9. Enter the appropriate information for the detail line
  10. Repeat the previous 2 steps for each detail line
  11. Filter to the incorrect 1099 Code
  12. Click on the double arrows (Go option)
  13. Press the Delete key to remove the incorrect detail lines individually

Contact us if you have questions or would like assistance with your year end processing.

Topics: Sage 300 (ACCPAC), Sage 300cloud, Sage 300 Tips & Tricks

Submit a Comment

Need Help Now?

Request a Call