How to: Generate a 1099 CSV File (Cross Projects)

You may generate a 1099 CSV file only if you wish to manually edit and upload your file.

Single Project

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

2020-11-11 17_39_59-https___demo2.gslate.com_#_accountingReports_AccountingReport

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

2020-11-30 13_35_36-https___demo2.gslate.com_#_accountingReports_AccountingReport

Step 3: Select VENDOR CHECK REGISTER (CROSS PROJECTS) from the Report Type drop down menu.

2020-11-30 13_35_10-https___demo2.gslate.com_#_accountingReports_AccountingReport

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

2020-11-11 17_42_44-https___demo2.gslate.com_#_accountingReports_AccountingReport

Use the Date filters, not Effective Date.

Step 5: Select the projects from the Projects filter.

2020-11-30 13_32_17-Inbox - laura.walton@gslate.com - Outlook

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

2020-11-11 17_47_24-https___demo2.gslate.com_#_accountingReports_AccountingReport

Step 7: Select T4A/1099 TRANSACTIONS EDIT LIST BY VENDOR TRIAL BALANCE (CROSS PROJECT) from the Report Type drop down menu.

2020-11-30 13_31_34-https___demo2.gslate.com_#_accountingReports_AccountingReport

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

2020-11-11 17_42_44-https___demo2.gslate.com_#_accountingReports_AccountingReport

Step 9: Select the projects from the Projects filter.

2020-11-30 13_32_17-Inbox - laura.walton@gslate.com - Outlook

Step 10: Click QUEUE REPORT.

Step 11: Click VIEW REPORTS MONITOR.

2020-11-30 12_50_30-Calendar - laura.walton@gslate.com - Outlook

Step 12: Download the PDFs of the reports.

2020-11-30 13_00_44-https___demo2.gslate.com_#_accountingReports_AccountingReport

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

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

Step 15:  Verify that the T4A/1099 Transactions Edit List by Vendor Trial Balance (Cross Project) 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 16:  If eligible payments are not found in the 1099 Edit List they will need to be updated with an appropriate 1099 code. Go to the invoice 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.

2020-11-30 12_36_28-Inbox - laura.walton@gslate.com - Outlook

Step 17:  Once all vendors and transactions have been verified and coded properly, click + to the right of Accounting Reports on the left navigation.

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

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

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

Step 21: Click QUEUE REPORT.

Step 22: Click VIEW REPORTS MONITOR.

Step 23:  Save the EXCEL file to your local hard drive.

If you would like GreenSlate to print and send out your 1099s,  follow the steps linked here. Contact 1099@gslate.com if you have questions.

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.