Accounts Payable - Print T5018 Forms

Pgm: T5018 – Statement of Contract Payments; standard Treeview path: Accounts Payable > Utilities > Print T5018 Forms

This utility is used to print T5018 forms. These are applicable in Canada for government reporting. For all applicable vendors, the ‘Report T5018’ box should be checked on the Vendors tab of the Maintain Vendors screen (standard Treeview path: Accounts Payable > Setup > Maintain Vendors - Vendors tab).

Business Number

Enter/select the business number of the company being used to print the T5018 forms.

Company

Enter/select the company being used to print the T5018 forms.

Transmitter Acc No

Enter the transmitter CRA account number (up to 15 alphanumeric characters). This field is required when creating an XML file.

Transmitter RepID

Enter the transmitter representative identifier (up to 8 alphanumeric characters), which is a unique number used to identify each submission filed to the CRA. This field is required if using the Represent a client (RAC) application. If not provided, the XML tag will not be printed when creating an XML file.

From Date, To Date

Enter/select a date range over which to print the T5018 forms.

From Legal Entity Type, To Legal Entity Type

Enter/select legal entity type(s) for which to print the T5018 forms.

From Vendor, To Vendor

Enter/select vendor (s) for which to print the T5018 forms.

Cutoff Amount

If a cutoff amount is entered, any statements with a lesser amount will not be printed.

Use Check Release Date – Checkbox

Check this box to use the check release date to determine which contract payments are included in the T5018 forms. Leave this box unchecked to use the check post date to determine which checks are included. By default, this box is unchecked.

Print Company Legal Name – Checkbox

Check this box to print the company's full legal name in the XML file and the T5018 report.

A company's legal name is provided in the Legal Name field on the Company Setup screen in the General Ledger module (standard Treeview path: General Ledger > Setup > Maintain Companies - [Company Detail]).

NOTE: The T5018S (summary) report already prints both the legal name and company name in the report.

Create XML File – Checkbox

Check this box to create an XML file of the report.

Original, Amended - Radio Buttons

These two radio buttons are used to select whether to print an XML with Report Type Code "O" or "A" (O = Originals and A = Amendments). This is to specify whether this is an original submission to CRA or an amendment filed thereafter.

Print Type

Use this drop-down menu to select the print option for the T5018 forms. Options available are "Print on Pre-Printed Form" and "Print on Blank Page". The "Print on Pre-Printed Form" option is selected by default.

If "Print on Blank Page" is selected, T5018_BOX prints data in CRA format. If "Print on Pre-Printed Form" is selected, T5018 prints data in a pre-defined format.

Similarly, for summary reports, if "Print on Blank Page" is selected, T5018S_BOX prints data in CRA format and if "Print on Pre-Printed Form" is selected, T5018S prints data in a pre-defined format.

Refer to Accounts Payable - Printing Options for T5018 Forms for detailed examples of using these options.

[Print] - Button

Use this button to print the report.

XML File Key Details

This section includes key details about the fields generated on the XML file, including those required by the CRA.

1. As of 2025, the “layout-topologies.xsd” layout file has been replaced by the form type “T619_T5018.xsd” in the first line of the XML file.

2. Transmitter Account Number: This field is required when creating an XML file.

3. Transmitter Rep ID: This field is required if using the Represent a client (RAC) application.

4. Transmitter Contact Email: A transmitter contact email is required by the CRA. This will be printed between the tags <cntc_email_area></cntc_email_area> in the <CNTC> section of the file.
   Users must set up an email ID in the Email field in the General Information section on the Company Setup screen in the General Ledger module (standard Treeview path: General Ledger > Setup > Maintain Companies - [Company Detail]). For more information, please refer to General Ledger - Maintain Companies.

5. Recipient's Last Name: Under the section <T5018Slip> within <RCPNT_NM>, the surname tag <snm></snm> will print the first 20 letters of the recipient’s last name.

6. Recipient First Name: Under the section <T5018Slip> within <RCPNT_NM>, the given name tag <gvn_nm></gvn_nm> will print the first 12 letters of the recipient’s first name if available. If the given name is not available, then an empty string will be printed as <gvn_nm/>.

7. Partnership filer identification number (FIN): The <ptnrp_filr_id/> tag is for amendments only and is removed for original filings with type “0” in the report type code (i.e., it is removed above the <rpt_tcd>0</rpt_tcd> tag).

For more information, please refer to T5018, Statement of Contract Payments - Canada.ca.

Sample T5018 XML File