Configuring CRA Reporting

To configure the CRA 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 and T4A vendors and transmitters.

You configure the CRA reporting once. Then over a calendar year, you record your payments to T5018 vendors and to T4A 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 CRA E-File (AP507600) form and submit it to the Canada Revenue Agency (CRA).

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:

  • T5018 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.
  • Information Returns Account 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 or in the T4A file. 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 or in a T4A file when it is generated on the Create CRA 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 CRA E-File (AP507600) form. The default value in the Threshold Amount box is 500 for both T5018 and T4A, 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 CRA 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. On the General tab, you select T5018 in the CRA Reporting Type box.
    2. In the CRA Vendor Type box, you select the type of the vendor: Corporation, Partnership, or Individual.
  2. Depending on the vendor type you have selected, you specify the contractor's SIN (if Individual is selected) or CRA Information Returns Account Number (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 Information Returns Account Number or SIN to fill in the elements in the electronic XML file when it is generated on the Create CRA E-File (AP507600) form.

Configuring T4A Vendors

You use the Vendors (AP303000) form to set up each T4A 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. On the General tab, you select T4A in the CRA Reporting Type box.
    2. In the T4A Box, you select the type of payments, which an be one of the following: Box 20 - Self Employed Commissions, Box 28 - Other Income, or Box 48 - Fees for Services (default).
    3. In the CRA Vendor Type box, you select the type of the vendor: Corporation, Partnership, or Individual.
  2. Depending on the vendor type you have selected, you specify the contractor's SIN (if Individual is selected) or CRA Payroll Account Number (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.

Configuring Non-Stock Items and Item Classes

You use the Non-Stock Items (IN202000) form and Item Classes (IN201000) forms to set up specific non-stock items and item classes for CRA reporting.

To configure a non-stock item, you do the following:

  1. On the Non-Stock Items form, you select the needed item.
  2. On the General tab (Item Defaults section), you select the T5018 Service check box and save the changes.

    With this setting, when you create a document with this item selected for a line on the Bills and Adjustments (AP301000) form, the document amount will be included in the T5018 report.

To configure an item class, you do the following:

  1. On the Item Classes form, you select the needed item class.
  2. On the General tab (General Settings section), you select the T5018 Service check box and save the changes.

    With this setting, when you create a document with an item of this class selected for a line on the Bills and Adjustments form, the document amount will be included in the T5018 report.

The state of the T5018 Service check box of an item class defines the default setting for the items of this class. You can override this setting when creating a document. The system always checks the state of the T5018 Service check box for a particular non-stock item, not for an item class.

Tip: If a document that you create on the Bills and Adjustments form does not include non-stock items and you want this document to be included in the T5018 report, you should select the T5018 Service check box for each needed line on the Details tab.