Working with GST Tax Exemption Status (MGTX)

Purpose: Use the GST Tax Exemption Status to define tax exemptions for items based on their status in particular provinces.

Overview: The Canadian GST (Goods and Service Tax) is a federal tax; the PST (Provincial Services Tax) is a province-level tax. You can use CWDirect to calculate either, both, or neither of these taxes based on the shipping address on the order.

You can specify a GST rate:

• as a default in the System Control file

• for each SCF in the SCF file

• for each postal code in the Postal Code file

You can specify a PST rate:

• for each SCF in the SCF file

• for each postal code in the Postal Code file

The GST rate defined in the SCF file, if any, overrides the rate from the System Control file, and the GST or PST rates defined in the Postal Code file, if any override the rates defined in the SCF file.

In addition to defining rates for each of these taxes, you must define a method for computing them. You define these methods in the SCF and, optionally, the Postal Code files. To define specific items as exceptions to the PST and GST methods for a province, you use the Work with GST Tax Exemption Status function.

You can also define an exemption or exception for a specific customer. See Customer Service Working with Customer Tax Status.

For more information:

• Fulfillment Working with SCF Codes (WSCF)

• Customer Service Setting Up the Postal Code File (WZIP)

• item exemptions in U.S. states: Working with Item Tax Exemptions (WITX).

 

Note: If you are using this function to define tax exceptions for items, you should set the GST Item Status Default (A91) field in the System Control file to B (calculate both GST and PST tax).

In this topic:

• Calculation Methods and Exemptions

• If You Tax Freight and Handling

• Work with GST Tax Exemption Status Screen (Selecting an Item)

• Work with GST Tax Exempt Status Screen

• Create GST Tax Exempt Status Screen

• Change GST Tax Exemption Status Screen

• Display GST Tax Exempt Status Screen

Calculation Methods and Exemptions

To understand the effect of different tax exemptions, it is useful to look at the calculation methods that may apply to GST and PST.

Method	Description	Calculation/Example (where the order total subject to tax = ORDER)	Example with Exemption Type of G or P
G	Calculate the GST on the order, including freight and handling, if applicable. Add this amount to the order total, then calculate the PST on the result.	Calculation: ORDER * GST rate = GST amount GST amount + ((GST amount + ORDER) * PST rate) = order tax Example: The order total subject to tax = $10.00 GST rate = 10% PST rate = 5% $10 * 10% = $1.00 GST amount $1 GST amount + (($1 + $10) * 5%) = $1 + ($11 * 5%) = $1.60	G = GST only; the amount subject to PST is 0 Example: $10 * 10% = $1.00 GST amount $1 GST amount + (($1 + 0) * 5%) = $1 + ($1 + 5%) = $1.05 P = PST only; the amount subject to GST is 0 Example: 0 * 10% = 0 GST amount 0 GST amount + ((0 + $10) * 5%) = 0 + ($10 * 5%) = $.50
P	Calculate the PST on the order, including freight and handling, if applicable. Add this amount to the order total, then calculate the GST on the result.	Calculation: O * PST rate = PST amount PST amount + ((PST amount + O) * GST rate) = order tax Example: (with same assumptions as above) $10 * 5% = $.50 PST amount $.50 PST amount + (($.50 + $10) * 10%) = $.50 + ($10.50 * 10%) = $1.55	G = GST only; the amount subject to PST is 0 Example: 0 * 5% = 0 PST amount 0 PST amount + ((0 +$10) * 10%) = 0 + ($10 * 10%) = $1.00 P = PST only; the amount subject to GST is 0 Example: $10 * 5% = $.50 PST amount $.50 PST amount + (($.50 + 0) * 10%) = $.50 + ($.50 * 10%) = $.55
S	Calculate GST and PST separately; neither tax is subject to the other.	Calculation: (O * GST) + (O * PST) Example: (with same assumptions as above ($10 * 10%) + ($10 * 5%) = $1 + $.50) = $1.50	G = GST only; the amount subject to PST is 0 Example: (0 * 10%) + ($10 * 5%) = $.50 P = PST only; the amount subject to GST is 0 Example: ($10 * 10%) + (0 * %) = $1.00

If You Tax Freight and Handling

You can tax freight and handling on orders as well as merchandise. In order to tax freight and/or handling, you must set the Tax on Freight (B14) and/or Tax on Handling (B15) fields in the System Control file to Y. You must then set the corresponding fields in the SCF or Postal Code files for the location where you tax freight or handling to Y as well.

An item tax exemption by province affects the calculation of tax on freight and handling for items shipped to that province. Assuming that GST and PST normally apply to the order, the system uses the following logic to calculate tax on freight and handling:

Order-level freight method:

• If all items on the order are exempt from PST, the system does not calculate PST on freight or handling.

• If at least one item on the order is subject to PST, the system calculates PST on freight and handling.

• If all items on the order are exempt from GST, the system does not calculate GST on freight or handling.

• If at least one item on the order is subject to GST, the system calculates GST on freight and handling.

Line-level freight method:

• If the item is exempt from PST, the system does not calculate PST on freight or handling for that line.

• If the item is exempt from GST, the system does not calculate GST on freight or handling for that line.

• If the item is subject to PST, the system calculates PST on freight and handling for that line.

• If the item is subject to GST, the system calculates GST on freight and handling for that line.

The system determines the freight method on an order from the source code. See Marketing Working with Source Codes (WSRC).

You can also flag a special handling code as exempt from tax. See Customer Service Establishing Additional Charge Codes (WADC).

Work with GST Tax Exemption Status Screen (Selecting an Item)

Use this screen to select an item for creation, review, change or deletion of GST tax exemption status.

How to display this screen: Enter MGTX in the Fast path field at the top of any menu or select Work with GST Tax Exemption Status from a menu.

OER0398 ENTER Work with GST Tax Exemption Status 6/13/97 8:48:25 Mail Order Item . . F3=Exit F12=Cancel F21=Print list F24=Select company

Item field: Use the item field to enter the item code that you want to work with. This is a 12-position, alphanumeric field. Item codes are defined in and validated against the Item file; see Performing Initial Item Entry (MITM).

Work with GST Tax Exempt Status Screen

Purpose: Use this screen to select an item tax exemption by province to work with, or to create a new record.

How to display this screen: Enter a valid item code at the Work with GST Tax Exemption Status Screen (Selecting an Item).

OER0057 DISPLAY Work with GST Tax Exempt Status 6/13/97 9:07:07 Mail Order Item . : BOOKCASE SOLID MAPLE BOOKCASE Opt Prov Sts Type options, press Enter. 2=Change 4=Delete 5=Display AB G MB G NF N NS N SK P YT P F3=Exit F6=Create F12=Cancel

Field	Description
Item	The code that represents the item subject to tax exemption by province. Item codes are defined in and validated against the Item file; see Performing Initial Item Entry (MITM). Alphanumeric, 14 positions; display-only.
Item description (Unlabeled field to the right of the item code)	The description associated with the item. Alphanumeric, 40 positions; display-only.
Prov (Province)	A code that represents the province where a tax exemption applies for this item. Alphanumeric, 2 positions; optional.
Sts (Status)	A code that represents the override tax status for the item in this province. Valid values are: B = Calculate both GST and PST G = Calculate GST only N = Calculate neither GST or PST P = Calculate PST only Alphanumeric, 1 position; optional.

Screen Option	Procedure
Change GST tax exemption	Enter 2 next to a province to advance to the Change GST Tax Exemption Status Screen.
Delete a GST tax exemption	Enter 4 next to a province to delete it.
Display a GST tax exemption	Enter 5 next to a province to advance to the Display GST Tax Exempt Status Screen.
Create a tax exemption record	Press F6 to advance to the Create GST Tax Exempt Status Screen.

Create GST Tax Exempt Status Screen

Purpose: At the Work with GST Tax Exempt Status Screen, press F6.

OER0060 ENTER Create GST Tax Exempt Status 6/12/97 15:59:01 Mail Order Item . . . . . . . : BOOKCASE SOLID MAPLE BOOKCASE Province . . . . . . Override tax status . (G=GST, P=PST, B=Both, N=Neither) F3=Exit F12=Cancel

Field	Description
Item	The code that represents the item subject to tax exemption by province. Item codes are defined in and validated against the Item file. Alphanumeric, 14 positions; display-only.
Item description (Unlabeled field to the right of the item code)	The description associated with the item. Alphanumeric, 40 positions; display-only.
Province	A code that represents the province where a tax exemption applies for this item. Alphanumeric, 2 positions. Create screen: required. Change screen: display-only.
Override tax status	A code that represents the override tax status for this item in this province. Valid values are: B = Calculate both GST and PST G = Calculate GST only N = Calculate neither GST or PST P = Calculate PST only Numeric, 1 position; required.

Change GST Tax Exemption Status Screen

To change: Enter 2 next to a tax exemption record at the Work with GST Tax Exempt Status Screen to advance to the Change GST Tax Exemption Status screen. You can change only the Override Tax Status field on this screen. See Create GST Tax Exempt Status Screen for a field description.

Display GST Tax Exempt Status Screen

To display: Enter 5 next to a tax exemption record at the Work with GST Tax Exempt Status Screen to advance to the Display GST Tax Exempt Status screen. You cannot change any information on this screen. See Create GST Tax Exempt Status Screen for field descriptions.