Configuring T5018 Reporting

To configure the T5018 reporting functionality in your system, you need to perform the tasks described in this chapter.

Enabling the Canadian Localization Feature

In MYOB Acumatica, you need to enable the Canadian Localization feature on the Enable/Disable Features (CS100000) form to be able to configure T5018 vendors and transmitters.

You configure the T5018 reporting once. Then over a calendar year, you record your payments to T5018 vendors. At the end of the year (if you are using a calendar-year basis) or at the end of the reporting period, you report payments by generating an electronic file in XML format on the Create T5018 E-File (AP507600) form and submit it to the Canada Revenue Agency (CRA).

In this topic, you will read about how to configure T5018 reporting.

Specifying the Canadian Localization for Needed Companies

When the Canadian Localization feature is enabled, on the Company Details tab of the Companies (CS101500) form, the system administrator must specify Canada in the Localization box for each company to which the Canadian localization will be applied.

Specifying Canadian Tax Reporting Settings

When the Canadian localization is specified for a company, the system administrator must specify the following settings on the Canadian Tax Reporting tab, which appears on the Companies (CS101500) form:

  • Year Type: The type of year for T5018 reporting—Calendar Year or Fiscal Year. By default, Fiscal Year is selected. You can change the year type if no T5018 file has yet been prepared for the selected company.
  • Program Number: The recipient's program account number that will be used as the Account Number in a T5018 submission file in the T5018 Summary section. This value consists of 15 alphanumeric characters.
  • Transmitter Number: The transmitter number that will be used in a T5018 submission file in the T619 section when a T5018 file is generated on the Create T5018 E-File (AP507600) form. This value consists of 8 alphanumeric characters.

On the Canadian Tax Reporting tab of the Accounts Payable Preferences (AP101000) form, the system administrator must specify the threshold amount to be used on the Create T5018 E-File (AP507600) form. The default value in the Threshold Amount box is 500, but it can be overridden depending on the provincial and federal GST or HST rates.

Specifying the Tax Registration Number at the Company and Branch Level

When the Canadian localization is specified for a company, the system administrator must specify a tax registration ID number for the company by filling in the Tax Registration ID box on the Company Details tab (Tax Registration Info section) of the Companies (CS101500) form. This tax registration ID will be used when generating a T5018 file on the Create T5018 E-File (AP507600) form.

If your organization files taxes for each company branch—that is, if the company's type is With Branches Requiring Balancing—and the File Taxes by Branch check box is selected for the company on the Company Details tab of the Companies form, you can specify a tax registration number for each branch on the Taxes tab of the Branches (CS102000) form. If no tax registration number is specified for a branch, the number specified at the company level is used.

The tax registration numbers specified on the Companies and Branches forms appear next to the corresponding taxes on the following reports:

Tip:
You can run Canadian versions of multiple reports for which a localized version exists in the system. For a report that has a localized version, the Localization box appears on the report form. To run a Canadian version of the report, you select Canada in the Localization box, specify the report parameters, and click Run Report on the report form toolbar.

Configuring a Canadian Tax Agency

You use the Vendors (AP303000) form to create a Canadian tax agency. When creating an agency, you must specify Canada in the Country box (General tab) of the form. For more details about creating a tax agency, see Tax Agency: To Set Up a Tax Agency for VAT.

Configuring Printing Parameters for Taxes

On the Printing Parameters tab of the Taxes (TX205000) form, you should specify short and long tax labels to be shown in printable versions of the following reports run from the corresponding processing forms:

If you want to have the long and short tax labels printed on the listed reports that are run from the site map, you should manually add the needed reports to the site map.

Tip:
You can run Canadian versions of multiple reports for which a localized version exists in the system. For a report that has a localized version, the Localization box appears in the Selection area of the report form. To run a Canadian version of the report, you select Canada in the Localization box, specify the report parameters, and click Run Report on the report form toolbar.

Configuring T5018 Vendors

You use the Vendors (AP303000) form to set up each T5018 contractor (which is defined in the system as a vendor) as follows:

  1. If a contractor does not have a vendor account in the system, you create a new vendor account and do the following:
    1. You click Enable T5018 Reporting on the More menu. The system automatically selects the T5018 Vendor check box in the Vendor Properties section on the General tab.
    2. In the T5018 Box drop-down list, you select the T5018 box that is applicable to the contractor by default.
  2. Depending on the T5018 box you have selected, you specify the contractor's SIN (if Individual is selected) or CRA RZ Program Account (if Corporation or Partnership is selected).
  3. Whether the vendor is new or existing, on the Purchase Settings tab, in the Tax Zone box, you specify the contractor's tax zone.

The system uses the contractor's name, address, and CRA RZ Program Account or SIN to fill in the elements in the electronic XML file when it is generated on the Create T5018 E-File (AP507600) form.