Processing 1099 and T5018 Forms

Comsense Enterprise can help you streamline your 1099 and T5018 forms for IRS and CRA purposes.

Enterprise refers to these forms generically as Contract Payment Forms. The system generates the 1099 or T5018 report for those suppliers that are designated as 1099 suppliers, and where payments to that supplier exceed an amount you can specify.

Configuration - Supplier

On the Supplier window, on the Profile tab you can identify the supplier as a 1099 supplier, add their Identifier, and select which box of the Contract Payment Form their amount should appear in.

Supplier - Commercial Interior Installers window showing the location of the 1099 supplier checkbox, Identifier field, and Contract Payment Box field.

Configuration - Report Management

In Report Management window you can specify defaults for the report, by division. Open Report Management at Reports > Report Management. In the treeview on the left portion of the window, locate the division you wish to work with, and select Type - ContractPaymentForm. This will open the settings for the report for this division on the right portion of the window.

Expand the options of the report by clicking the plus sign at the left side of the Contract Payment Form row. Ensure that the Visible and Print Dialog Visible options are checked on the Contract Payment Form row.

The list of parameters that appear when the row is expanded are optional parameters that can be configured here in the Report Management window as defaults, and when the parameter has the Visible option checked, it will also appear and be editable when printing the report.

For example, you may want to set a default Minimum Amount to $600. The user can override this amount when running the report if the parameter is set to visible. The Minimum Amount parameter is used to filter which suppliers will be included by default when running the Contract Payment report. 

Since this report is designed to print on the pre-printed government forms, alignment is important. The four page margin variables allow you to make adjustments to the alignment of the form. It is important that the sum of the top and bottom margins equal 0.5" and the sum of the left and right margins equal 0.5" when making adjustments to the margins. 

Report Management window.

Ensure that the appropriate security roles have access to the report. The roles can be seen at the bottom right corner of the window.

Running the Report

To run the report navigate to Reports > Reports and choose Contract Payment Form. 

The Generate Report dialog will appear and display Criteria at the top, with Parameters below.

Generate Report window.

Verify the Company and Year selected are correct.

The number of suppliers selected automatically will be displayed. This list can be viewed and modified by clicking the button that appears when you hover your pointer over the Selected count. Suppliers who have the 1099 box checked on their profile and have been paid an amount that exceeds the specified Minimum Amount are automatically included on the report.

Click Preview toolbar item to preview the report, and Print to print out the report. 


Have more questions? Submit a request