Create T5018 E-File

Form ID: (AP507600)

Note:
This form appears in the system only if the Canadian Localization feature is enabled on the Enable/Disable Features (CS100000) form.

By using this form, you can generate a T5018 form in XML format to be submitted to the Canada Revenue Agency (CRA). You can also review the T5018 data that you submit to CRA in a human-readable format, view the previous years' submissions, and amend or cancel a T5018 report.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Prepare Report

Populates and saves the data for the T5018 report. When you click this button, the system shows the total of all the transactions for all the individual subcontractors on the Details tab.

This button is visible on the form if the original report (revision 1) has not been prepared. Once it has been prepared, the button becomes hidden.

Tip:
If you need to prepare another original report, you have to delete the already-prepared report.
Amend Report

Amends the current report revision. You click this button when you have added or voided any payment to a particular subcontractor and require an amended T5018 report.

This button appears on the form after the original report (revision 1) has been prepared. You can prepare an amendment by clicking this button after you submit the original report to the Canada Revenue Agency (CRA) by selecting the E-File Submitted to CRA check box and saving the changes on the form. Likewise, you will be able to prepare an amended report after the previously amended report has been submitted to the CRA.

View Validation Report

Runs the T5018 Preview Report (AP607600) for the transmitter, T5018 tax year, and revision that are specified on the current form. In this report, you can review the T5018 data prepared on the current form.

This button is available only if a specific revision number is selected in the Revision box of the Selection area.

Create E-File

Creates an electronic T5018 e-file. If a file is created for the first time, when you click this button, the system generates a report with the Original type.

If a file has been already created, when you click this button, the system will create a report with the Amended or Canceled type. Reports of these types will be generated one at a time or both at the same time, depending on the Total Service Amount for vendors after they have amended or voided their payments.

If the Total Service Amount has been changed for a particular vendor and the new amount is less than the Threshold Amount, the system will include the vendor in a cancellation report and amended summary. It only applies to already submitted T5018 e-files. If the new Total Service Amount is greater than the Threshold Amount, the system will include the vendor in an amended report and an amended summary.

The system generates an XML file with information for all vendors that are displayed on the Details tab. The generated file is attached to the current form, and you can review it by clicking Files on the form title bar.

This button is available only if a specific revision number is selected in the Revision box of the Selection area.

Selection Area

You can use the settings in this area to narrow the range of payments to T5018 vendors that are listed in the table. The elements of this area are summarized below.

Element Description
Transmitter

Required. The company filing T5018 returns whose information will be used to create the transmitter record in the file.

By default, the current company to which the user is signed in is selected in the box.

This box displays only companies and branches for which Canada is selected in the Localization box on the Companies (CS101500) form.

T5018 Tax Year

Required. The T5018 tax year.

If the year type selected on the Canadian Tax Reporting tab of the Companies (CS101500) form for the company is Calendar Year, the previous calendar year is specified in this box. If the year type is Fiscal Year, the system inserts the financial year whose end date is closest to the current business date but is earlier than it.

You can select a financial year from the company calendar of the company selected in the Transmitter box.

Revision

Required. The data prepared on the current form and shown on the Details and Summary tabs. This data will be exported as an XML file if you click Create E-File or displayed on the T5018 Preview Report (AP607600) form if you click View Validation Report.

Every time you save new data, the system creates a new revision. Each new revision contains data from the previous revision and all new transactions that were added in the system after the previous revision was created.

E-File Submitted to CRA

A check box that indicates (if selected) that the e-file with the T5018 data of the selected revision has been submitted to the CRA.

The check box is always selected and unavailable for the original report (revision 1) if an amendment (revision 2) has been created for the original report. To clear the check box for the amended report (revision 2), the you will have to delete the subsequent amended report (revision 3).

Filing Type Read-only. The type of the e-file shown for informational purposes.

The possible options are:

  • Original (default): The file will include the original T5018 slip.
  • Amendment: The file will include an amended T5018 return.
Threshold Amount

Read-only. The threshold amount of the T5018 file. The Details tab shows only payment transactions of T5018 vendors that are the same as or greater than the entered amount.

The value is copied from the Threshold Amount box on the Canadian Tax Reporting tab of the Accounts Payable Preferences (AP101000) form.

Once a T5018 report is prepared, you will not be able to override the value in the Threshold Amount box for already prepared reports with the Original, Amended, and Canceled types. The Threshold Amount box on the Accounts Payable Preferences (AP101000) form will still be editable.

From

Read-only. The start date of the reporting period.

When a new T5018 year is selected in the T5018 Tax Year box, the system populates this box based on the selected year and year type for the company specified as the Transmitter as follows:

  • If Calendar Year is selected in the Year Type box on the Canadian Tax Reporting tab of the Companies (CS101500) form, this box shows January 1 of the selected year.
  • If Fiscal Year is selected in the Year Type box on the Canadian Tax Reporting tab of the Companies (CS101500) form, this box shows the start date of the financial year in the company calendar.
To

Read-only. The end date of the reporting period.

When a new T5018 year is selected in the T5018 Tax Year box, the system populates this box based on the selected year and year type for the company specified as the Transmitter as follows:

  • If Calendar Year is selected in the Year Type box on the Canadian Tax Reporting tab of the Companies (CS101500) form, this box shows December 31 of the selected year.
  • If Fiscal Year is selected in the Year Type box on the Canadian Tax Reporting tab of the Companies (CS101500) form, this box shows the end date of the financial year in the company calendar.

Details Tab

This tab displays one row for each vendor that has the T5018 Vendor check box selected on the Vendors (AP303000) form and that has a payment during the selected year.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Vendor The identifier of the T5018 vendor.
Vendor Name The full name of the T5018 vendor.
Payer The company that paid the vendor. This column is always populated with the company that is selected in the Transmitter box in the Selection area.
Total Service Amount The sum of all amounts paid to the vendor for services.
Amount to Report

The sum of payments that include services only or mixed goods and services, which will be included in the T5018 report. Payments for goods only are excluded from this amount.

If you click this link, the system opens a separate page with the T5018 Report Details (AP407600) form. This form lists all the documents whose amounts are included in the report.

Report Type

The type of the T5018 report.

One of the following options is specified automatically by the system in this column:

  • Original: The vendor information is included in the original T5018 report when it is prepared for the first time.
  • Amended: The vendor information is included in an amended T5018 report that is prepared after amendments are made to the vendor payments and their new Total Service Amount is still greater than the Threshold Amount.
  • Canceled: The vendor information is included in a canceled T5018 report that is prepared after amendments are made to the vendor payments and their new Total Service Amount is less than the Threshold Amount.
Tax Registration ID The vendor's SIN or Program Account Number, which is specified on the General tab (Vendor Properties section) of the Vendors (AP303000) form.

Summary Tab

This tab displays summary information about the transmitter company and the contact.

Table 1. Settings SectionIn this section, you specify the settings for the generation of the T5018 file.
Element Description
Language

Required. The language that will be used for the Language of communication element in the T619 section of the T5018 file.

The following options are available:

  • English (default)
  • French
Program Number

Required. The program account number of the transmitter.

The number can be up to 15 alphanumeric characters. The default value is copied from the Program Number box on the Canadian Tax Reporting tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Transmitter Number

Required. The transmitter number that will be used in the Transmitter number element of the T619 section in the T5018 file.

This number can be up to eight alphanumeric characters. The default value is copied from the Transmitter Number box on the Canadian Tax Reporting tab of the Companies (CS101500) form for the company that is selected in the Transmitter box of the Selection area. If the Transmitter Number box on the Companies (CS101500) form is empty for the company, the default value is MM555555.

Table 2. Company SectionThis section holds information about the transmitter company.
Element Description
Company Name

Required. The full company name that will be used in the Transmitter name element of the T619 section in the T5018 file.

The default value is copied from the Company Name box on the Companies (CS101500) form for the company that is selected in the Transmitter box of the Selection area.

Address Line 1

The first address line of the company's address. This value will be used in the T5018 file as follows: in the Transmitter address element of the T619 section, and in the Payer address element in the T5018 Summary section.

The default value is copied from the Address Line 1 box on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Address Line 2

The second address line of the company's address. This value will be used in the T5018 file as follows: in the Transmitter address element of the T619 section, and in the Payer address element of the T5018 Summary section.

The default value is copied from the Address Line 2 box on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

City

The city of the company address. This value will be used in the T5018 file as follows: in the Transmitter city element of the T619 section, and in the Payer city element of the T5018 Summary section.

The default value is copied from the City box on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Province

The province of the company address. This value will be used in the T5018 file as follows: in the Transmitter province element of the T619 section, and in the Payer province element of the T5018 Summary section.

The default value is copied from the State box on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Country

The country of the company address. This value will be used in the T5018 file as follows: in the Transmitter country element of the T619 section, and in the Payer country element of the T5018 Summary section.

The default value is copied from the Country box on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Postal Code

The postal code of the company address. This value will be used in the T5018 file as follows: in the Transmitter postal code element of the T619 section, and in the Payer postal code element of the T5018 Summary section.

The default value is copied from the Postal Code box on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Table 3. Contact SectionThis section holds the information about the contact in the transmitter company.
Element Description
Name

Required. The full name of the transmitter's contact. This value will be used in the Contact name element in the T619 and T5018Summary sections of the T5018 file.

The default value is copied from the Attention box in the Main Contact section on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Contact Area Code

Required. The area code of the transmitter's contact. This value will be used in the Contact area code element in the T619 and T5018 Summary sections of the T5018 file. This value should be three numeric characters.

The default value is copied from the area code in the Phone 1 box in the Main Contact section on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Phone

Required. The phone number of the transmitter's contact. This value will be used in the Contact telephone number element in the T619 and T5018 Summary sections of the T5018 file. The allowed value is three numeric characters followed by - and then four more numeric characters.

The default value is copied from the phone number in the Phone 1 box in the Main Contact section on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Extension Number

The phone extension number of the transmitter's contact. This value will be used in the Contact extension number element in the T619 and T5018 Summary sections of the T5018 file.

The value can be up to seven numeric characters.

Email

Required. The email address of the transmitter's contact. This value will be used in the Contact e-mail address element in the T619 and T5018 Summary sections of the T5018 file.

The default value is copied from the Email box in the Main Contact section on the Company Details tab of the Companies (CS101500) form for the company selected in the Transmitter box of the Selection area.

Second Email The second email address of the transmitter's contact. This value will be used in the Contact e-mail address 2 element in the T619 and T5018 Summary sections of the T5018 file.