How to: Generate and Reconcile a 1099 Final Processing Report Excel File (Single Project)

You must generate a 1099 Final Processing Report Excel file in order to process your 1099s.

Single Project

Step 1:  Click + to the right of Accounting Reports on the left navigation.

Step 2: Select CHECK REPORTS from the Category drop down menu.

Step 3: Select VENDOR CHECK REGISTER from the Report Type drop down menu.

Step 4: Enter the date range for the applicable 1099 year.

Use the Date filters, not Effective Date.

Step 5: Click QUEUE REPORT.

2020-11-11 17_44_33-Inbox - laura.walton@gslate.com - Outlook

Download the Vendor Check Register report, save and proceed to step 6.

Step 6:   Select T4A/1099 REPORTS from the Category drop down menu

Step 7: Select 1099 FINAL PROCESSING REPORT from the Report Type drop down menu.

Step 8: Enter the date range for the applicable 1099 year.

Step 9: Click QUEUE REPORT.

Step 10: Click VIEW REPORTS MONITOR.

Step 11: Download the Excel file of the 1099 FINAL PROCESSING REPORT.

Open your Vendor Check Register Report and compare to the 1099 Final Processing Report.

Review the Vendor Check Register for total payments in excess of $600.00 to an individual vendor.

Any vendors with payments of $600.00 or more should have their corporate status verified and a W-9 form on file. 

Verify that the 1099 Final Processing Report includes all vendors with payments of more than $600.00 and that they have complete and accurate Name, Address and Fed ID# information filled in.

Step 12:  If eligible payments are not found in the 1099 Final Processing Report they will need to be updated with an appropriate 1099 code. Go to the transaction and modify the 1099 code to update the report.

To update 1099 coding, go to the specific transaction and click EDIT or you can click edit from the General Ledger and make updates to several transactions at once then save.

 

Step 13:  Once all vendors and transactions have been verified and coded properly, follow the steps linked here to have GreenSlate to print and send out your 1099s.

If you would like to print your 1099s yourself, follow the steps linked here.  Contact Support if you do not have access and we will be happy to get you set up on the application.