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, and view the previous years' submissions.

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
Create T5018 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 T5018 E-File

Creates an electronic T5018 e-file.

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 whose information will be used to create the transmitter record in the file.

By default, the current company filing T5018 returns 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 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, which will be exported as an XML file or displayed on the T5018 Preview Report (AP607600) form.

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.
Filing Type The type of the e-file. The following options are available:
  • Original (default): The file will include the original T5018 slip.
  • Amendment: The file will include an amended T5018 return.
Threshold Amount

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 default value is 0.0, but you can override this value. When you save a new revision, this value is also saved and becomes read-only.

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 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 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 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 form, this box shows the end date of the financial year in the company calendar.
Previous Submitted Revision Read-only. The ID of the latest revision before the currently selected one that has the E-File Submitted to CRA check box selected. This value shows the revision that will be used as the Original submission if Amendment is selected in the Filing Type box.

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.
Amount The total amount of the vendor's documents.
Tax Registration ID The vendor's SIN or Program Account Number, which is specified on the General tab (Vendor Properties section) of the Vendors 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 Payer column on the Details tab of the current form.

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 Payer column on the Details tab of the current form. If the Transmitter Number box on the Companies 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 Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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 form for the company selected in the Payer column on the Details tab of the current form.

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.

The allowed value is up to 60 alphanumeric characters.