Sage 300 CRE Year-End Video Tips & Tutorial
Sage Certified Consultant, Olivia Roemer, shares Sage 300 Construction and Real Estate video series for year-end tasks in the software. Close out the year in Sage 300 CRE correctly with these helpful tips. In this tutorial video, you will learn how to print your 1099s using Sage Aatrix. In case you missed Part I: How to Prepare your 1099s Prior to Printing, you can watch it here.
Part II – How to Print your 1099s Using Sage Aatrix
In Part 3 of this 5-part series, Olivia will show you how to prepare and print your W-2s in Sage software.
Video Series: Sage 300 CRE Tasks for Year-End
- How to Prepare Prior to Printing your 1099s
- How to Print your 1099s Using Sage Aatrix
- How to Prepare for and Print your W-2s
- How to Prepare and Print your Quarterly and Annual Payroll Returns
- How to Close the Year in Sage 300 Construction and Real Estate
How to Print your 1099s Video Transcript:
To start the 1099 process in Sage 300 CRE open the Accounts Payable module, navigate to Tasks, Government eFile and Reporting and then select Form 1099 (USA). As the federal and state government reporting forms are updated, the software will issue a new update to give you access to the most current forms. When they forms update box appears click the Automatic Update box. Based on network security setting, you might need to be logged in as an administrator to run the update. Then the following box will appear. Hit next. The system will not update all the forms to the latest version. After the update is complete hit the close button.
You will then need to reopen the Form 1099 (USA) task. The following box will appear. Based on your data folder setup you may have two options to select. You can run your report by Vendor or by Fiscal Entity. If you have more than one legal entity within your data folder it is best to run your 1099s by Fiscal entity. If you only have one legal entity but multiple departments it is best to run your 1099s by vendor. Then select the form you want to print. Most of your vendors will receive the Form 1099-MISC. Then choose the reporting year for the 1099s you want to print. Enter the minimum reporting amount in the box shown. If you have entered your Federal ID number in your GL Setting this will prepopulate for you, otherwise you will need to enter your ID number in the box shown. Then hit next.
The window will then display all of the vendors that have the “Vendor Receives a Form 1099” checkbox checked. Hit next. Then hit the generate button. The following box will appear. You have a few options here. You can do a test run with the first 25 vendors, process a test run for all your vendors or start processing your 1099s without a test run. Make your selection and then hit next. For this videos I have chosen to start processing my 1099s.
A box will appear displaying your Federal ID number, if it is incorrect this is your final opportunity to make any corrections. Hit next. Then you will see a box that displays your company name address and contact information. Make sure that the box is filled out completely and hit next.
Then a box will appear asking you whether you are filing on behalf of your company or employer or if you are a third party. In most instances you will be filing on behalf of your company or employer. Hit next.
The next box to appear is the state and local tax entity boxes. If you must report to any state or local government your 1099s, make sure the appropriate tax account numbers are filled out in this box. Hit next.
Then the system will ask you whether or not your recipients have elected to only receive their 1099 forms electronically. There is a cost associated with the electronic delivery of your 1099s to vendors. You can print your 1099s on the forms for free. Hit next.
Then you will be asked how you would like the federal id and social security numbers displayed on the 1099 recipient copies and whether or not you would like zeros or blanks displayed for no reporting amount. I recommend printing zeros in lieu of leaving an item blank. Hit next.
If you have multiple Accounts payable data files, you have the option to combined the data files into one 1099 filing report. Make the appropriate selection for your business and hit next.
The software will then display an Excel like grid with all the 1099 vendors. Confirm that the information listed is accurate. If not, you can make any corrections inside the grid. Once you are finished reviewing or making corrections, hit the green arrow to advance to the next step. The software will now confirm that you are not missing any information, if errors are found make the necessary corrections in the grid. Keep hitting the green arrow to advance through to the next section.
The following box will appear. You have two options available to you, a paid and a free option for your 1099s. For $1.99 per recipient, Aatrix will print and mail the 1099 form to your vendors. They will also electronically file the form 1099 to the federal government and if required the appropriate state agency. If you would rather print the 1099s yourself, select the Other Options button. You can efile your federal 1099s for free. If required, you can efile the state form for a fee of $0.69 per recipient or you can print the state forms for free. Check the appropriate boxes. Then hit next for the following three windows.
The system will ask you if you would like to separate each form with a divider sheet. Select your option of chose and hit next. A box will appear that will summarize your selections, if everything is correct, hit next.
A window will appear that shows the state copies of the 1099 form, if applicable. Hit the Print Final button. Then hit the green arrow to proceed to the next step.
Then your 1096 form will display, hit print final and then next step.
A window will appear that shows the 1099 recipient copies. Hit the Print Final button. The official 1099 recipient forms will print. Then hit the green arrow to proceed to the next step.
A window will appear that shows your copies of the 1099 recipient form. Hit the Print Final button. Then hit the green arrow to proceed to the next step.
A window will appear that shows the federal copies of the 1099 form. Hit the Print Final button. Then hit the green arrow to proceed to the next step.
Then the copy of your 1096 form will display, hit print copy and then next step.
Then the 1099 instructions form will display. Stick the 1099 recipient copies into your printer so the instructions can print on the backside of each form. Hit the print final button and once finished hit the next step button.
Lastly the efile window will pop-up. Login and finish the efile process.
You have now completed your 1099s.