How to: Generate and Reconcile a 1099 Final Processing Report Company Excel File (Cross Projects)

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

Cross Projects

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

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

Step 3: Select VENDOR CHECK REGISTER (CROSS PROJECTS) 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: Select the projects from the Projects filter.

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 COMPANY  from the Report Type drop down menu.

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

Step 9: Select the projects from the Projects filter.

Step 10: Click QUEUE REPORT.

Step 11: Click VIEW REPORTS MONITOR.

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

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

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 Company 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 13:  If eligible payments are not found in the 1099 Final Processing Report Company 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 find specific transactions an All Transactions with 1099 Filter (Cross Projects) can be generated. Detailed instructions on how to generate this report are available by clicking here.

To update 1099 coding, click here for step by step instructions to edit a specific transaction.

Or you can click here to make several changes from the General Ledger at once then save.

Step 14:  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.