How to: Generate a 1099 CSV File (Single Project)

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 CHECK REPORTS from the Category drop down menu.

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

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

2020-11-11 17_41_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: Click QUEUE REPORT.

2020-11-11 17_44_33-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 ALL ACCOUNTS from the Report Type drop down menu.

2020-11-11 17_48_15-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: Click QUEUE REPORT.

Step 10: Click VIEW REPORTS MONITOR.

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

Step 11: Download the PDFs of the reports.

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

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

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

Step 14:  Verify that the T4A/1099 Transactions Edit List by All Accounts 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 15:  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 16:  Once all vendors and transactions have been verified and coded properly, click + to the right of Accounting Reports on the left navigation.

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

Step 18: Select T4A/1099 FINAL RUN (CREATE CSV FILE) ALL ACCOUNTS from the Report Type drop down menu. 

2020-11-30 12_42_28-C__Users_lwalton_Desktop_2020-11-30 12_36_28-Inbox - laura.walton@gslate.com - O

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

Step 20: Click QUEUE REPORT.

Step 21: Click VIEW REPORTS MONITOR.

Step 22:  Save the CSV file to your local hard drive.

If you would like GreenSlate to print and send out your 1099s,  forward the CSV file via email to 1099@gslate.com. Please include the contact name and address you would like printed on the 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.