Canadian Sales Tax in M3

This document presents an overview of the solution for managing Canadian taxes.

Outcome

After reading this document, you understand how to use the functional solution in M3 for managing European VAT to manage Canadian tax on purchases, the setup required, and how it affects the user workflow.

Use this information to define the components required, such as VAT codes, and to troubleshoot.

Before you start

Not applicable.

About Canadian Taxes

Follow these steps - Activities in M3

  1. Select Tax Method for Division

    For Canadian divisions, select tax method 4 in 'Company. Connect Division' (MNS100/G). This tax method defines that sales tax on supplier invoices will be calculated using the M3 solution for VAT whereas Vertex will calculate sales tax on customer invoices.

  2. Define Accounting Rules for Sales Tax

    Account entries for sales tax on purchases can at present be created for accounting event AP10 only, that is, when manually entering supplier invoices in 'Supplier Invoice. Record' (APS100).

    The following accounting types are used to record sales tax:

    • 211 for GST or HST (also used for VAT)
    • 212 for PST or QST (also used for VAT)
    • 217 for self-assessed PST

    Define accounting rules AP10-211, AP10-212 and AP10-217 in 'Accounting Rule. Set' (CRS395). Each accounting rule contains the accounting string to apply when recording the tax. Since there is a separate accounting type for each kind of sales tax, these taxes can be recorded separately. The accounts selected for accounting types 212 and 217 could be either expense accounts or accounts labeled as VAT accounts in 'Accounting Identity. Open' (CRS630), depending on whether the PST is reclaimable. For more information about accounting rules, see Accounting Rules Setup and Usage.

  3. Enter Tax Registration Numbers

    For suppliers, enter their respective tax registration number per state in 'Supplier Tax Number. Open' (CRS628). For Canadian sales tax, the M3 state is synonymous to province. Although the field reserved for the tax registration number is called 'PST/QST registration number', it can be used for any kind of tax registration number. You access (CRS628) by selecting the 'Tax numbers' option for the supplier in 'Supplier. Open' (CRS620/B).

  4. Define Retrieval of VAT Codes per Supplier

    Predefine where M3 will retrieve the VAT code when you create a purchase order for a specific supplier by selecting one of the following alternatives in the 'Tax applicable' field in 'Supplier. Define Purchase & Financial' (CRS624/F):

    • 0 = No tax calculated.
    • 1 = The VAT code is retrieved from the combination of item and warehouse in 'Item. Connect Warehouse' (MMS002). If there is no VAT code there, M3 regards the item as a non-taxable good. If the item itself is not connected to a warehouse in (MMS002), M3 searches for a VAT from the item in 'Item. Open' (MMS001) instead.
    • 2 = The VAT code is retrieved from the following tables in the following order: the combination of item and warehouse in (MMS002), the item in (MMS001) and the supplier in (CRS624) or 'Supplier. Open/Division' (MFS620/E). If no VAT code is found in the first table, the search continues in the following tables.
  5. Define VAT Codes

    Define the tax rates per VAT code in 'VAT Code. Open' (CRS030). Each VAT code basically defines which method to use to calculate the tax and which tax rate percentage to apply. We recommend that you define VAT codes to use for sales tax as combined VAT (VAT method 2) or compound VAT (VAT method 3). Enter the GST or HST tax rate in the 'VAT rate 1' field and the PST or QST tax rate in the 'VAT rate 2' field. You can select a check box indicating that the VAT code is used to calculate self-assessment tax for VAT codes belonging to VAT method 2 or 3. The VAT code with ID 0 is predefined; it cannot have a VAT rate and it is used to indicate that no VAT or sales tax is to be calculated. A VAT code for HST would be defined as a VAT code for GST with only one VAT rate.

    Examples of VAT Codes for Sales Tax:

    ID Description VAT rate 1 VAT rate 2
    1 GST only 6.00 0.00
    2 GST 6%, PST 7% 6.00 7.00
    3 GST 6%, self-assessed PST 7% 6.00 7.00
    4 PST 7%, no GST 0.00 7.00
    5 GST 6%, PST exempt 6.00 0.00
    6 GST 6%, QST 8% 6.00 8.00
    7 Self-assessed PST 5%, no GST 0.00 5.00
  6. Define Tax Exceptions

    Predefine whether and how to replace the VAT codes that would normally be retrieved by M3 by other VAT codes in 'VAT Exception. Open' (TXS020) in specific situations. The automated use of such replacement VAT codes enables you to comply with the Canadian sales tax legislation in complex tax scenarios involving sales. For example, if a supplier is a registrant in a specific province - that is, the supplier is registered with an official tax registration number there – and the company has entered the tax registration number for that province in (CRS628), another VAT code with another tax rate could automatically be applied when placing a purchase order for that supplier. For details, see VAT Exemptions.

Activity description

  1. Create Purchase Order

    When you create a purchase order for a supplier, M3 Business Engine automatically proposes a VAT code for the good ordered based on the search path indicated by the 'Tax applicable' field for the supplier and the tax exceptions defined in (TXS020).

  2. Record Supplier Invoice

    When you then record the supplier invoice in 'Supplier Invoice. Record' (APS100), you can manually change the VAT code on the invoice header as well as the VAT amounts, for example, by selecting VAT code 0 to indicate that the items referred to are tax exempt. If the invoice consists of several lines with different tax types or tax rates, you manually enter the invoice lines on the coding panel and select the corresponding VAT code for each one.

    If the invoice does not include any provincial sales tax but you know that the company is required to pay the tax, you select a VAT code for self-assessment tax. Two types of account entries for sales tax can be created; the first one is the debit or expense transaction based on accounting type 211 for GST or HST or 212 for PST or QST and the second is a credit transaction for any offset self-assessment PST based on accounting type 217. In other words, it works similarly to the recording of EU VAT, with the difference that EU VAT is recorded based on accounting types 211 and 212 only.

  3. Declare Sales Tax

    You declare the GST sales tax using the functionality for declaring European VAT, as described in Reconciling and Declaring VAT. The tax declaration is created in 'VAT Run. Open' (TXS100). The report template used determines which accounts and VAT codes are included in the report. The same functionality can also be used to create reports with PST.

Related topics