Quebec Sales Tax Change Guide

Effective January 1, 2011

Additional Info (in this topic)
Creating New records for OLD Rates
Using the Tax Recode Utiltity
Overriding the Header Tax Group

This document applies to WinSol Versions 2-4 and PointForce Enterprise Versions 5-6.

This document is a guide only:

The intention is to assist you with the file maintenance that will be necessary to accommodate the tax changes for new Quebec orders, invoices and credit notes going forward from January 1, 2011.

This document points out the implications these changes have when invoicing pre-January orders (which need the new tax rates applied) and when issuing Credit Notes for Invoices dated prior to January 1 (which need the old tax rates applied).

It is your responsibility to review and understand the new tax rulings and set up the tax tables within your system, as they pertain to your company.

Quebec Provincial Sales Tax Rate will increase from 7.5% to 8.5% on January 1, 2011.

The Maintain Tax Codes (IN05), Maintain Tax Groups (IN06) and Maintain Product Tax Exceptions (IN07) programs used by the WinSol and PointForce Enterprise (PFE) tax routines are user assigned so it is difficult to dictate exactly what to change in a generic document such as this. It is important for you to understand how the tax routines work. For an overview of the tax set up in PFE, please see the Overview of Tax Set Up in Enterprise topic.

Implementing a tax rate change involves more than just loading in the new rate. While that works perfectly for new invoices and credit notes, care must be taken when issuing a credit note after January 1 for an invoice that was processed prior to January 1; those credit notes need to calculate QST at the old 7.5% rate.

There are a couple of ways to approach implementing this tax rate change:

Option 1:

    One option is to process those credit notes in an isolated batch. You can then temporarily change the QST tax rate in IN05 back to 7.5%, process the credits through to IN44 and then change the rate back to 8.5%.

Option 2:

    Use existing tax records for the NEW rate; create new tax records for the OLD tax rate to be used on credit notes. To go directly to this procedure, click here.

Option 3:

    For users with the Tax Recode Utility (CC55), create new tax records for the NEW tax rate and recode the Tax Group in the Customer Master, Ship-To Master and Open Order file to the new Tax Group. This leaves the old tax records in place to be automatically assigned when credit notes are generated from Invoice History. To go directly to this procedure, click here.


Back to top

 
Creating New Tax Records for the OLD Rates (Option 2)

In this option as soon as you change the tax rate in your existing tax record, tax will begin calculating at the new rate on invoices and credit notes processed after January 1. You will create new Tax Codes, Tax Groups and Tax Exceptions pointing to the OLD tax rate that will be used on credit notes for sales made prior to January 1. You will manually override the Tax Group on these credit notes to get the tax to calculate at the old rate.

What to do on January 1, 2011:

  • Be sure all December invoices and credit notes have been processed and there are no open invoicing cycles: IN42/IN43/IN44.

  • In program IN05, change the rate for your QST Tax Code from 7.5% to 8.5%.

  • Begin January invoicing.

  • Reminder: In program IN05, DO NOT include the rate in the Tax Code Description fields. This is because when older invoices are reprinted, the Tax description (which comes from IN05) will not match the Tax value (which is picked up from Invoice History and would have been calculated at the rate effective at that time).

What to Consider AFTER January 1, 2011:

Pay special attention when issuing credit notes to Quebec customers after January 1 for invoices issued prior to January 1. First check if the original invoice was dated prior to January 1, 2011. If it was, then taxes were calculated on the original invoice using the old rates. Taxes on the credit note must match taxes on the original invoice.

  • Set up a new Tax Code (in IN05) for the old QST rate for 7.5%.

  • Set up a new Tax Group (in IN06) for your Quebec customers that will charge GST & QST@ 7.5% (and, if applicable, for customers charged QST only).

  • If you have exceptions in IN07, then you may need to add new records to control the exceptions for your new Tax Groups.

  • In Enter Invoices/Direct Bills/Credits (IN41), override the Tax Group in the header of the credit note to a Tax Group that stores the OLD rates to facilitate calculating tax at the old rate on that credit note.

Credits created using IN41 Auto Credit or Use RMA:

If using Auto Credit or Use RMA, the Tax Group assigned to the credit note defaults from Invoice History to the Tax Group on the original invoice (which now points to the NEW Tax Rate). The Tax Group in the header of the credit note will need to be overridden to a Tax Group that points to the OLD Tax Rate.

  • Overriding the Header Tax Group - for information related to overriding the Header Tax Group, an Overriding the Header Tax Group section is included at the end of this topic.

  • **TIP** Always check the calculated taxes in Folder 4 before you exit the credit note. If there is any doubt as to whether or not the Tax Group is set properly in the detail line, you can check the Tax Group in the More Details window in Folder 3 and revise if required.

RMA’s for Multiple Products Returned:

When using Return Merchandise Entry (IN67) to create an RMA you are selecting invoice detail lines from which goods are being returned. Be sure to check the invoice date (shown in the invoice display list box) and do not mix products belonging to a pre-January invoice with a post-January invoice on the same RMA.

  • When the RMA is turned into a credit note, the appropriate Tax Group will need to be assigned to each credit note. You may wish to add a comment on the RMA if the original invoice was pre-January as a reminder to override the Tax Group in IN41.

Accounts Payable – Input Tax Credit:

When invoices are entered into AP30 for a domestic vendor, the program applies the current tax rate to the entered invoice amount and calculates the Input Tax Credit amount included in the invoice total; this becomes the default GL distribution value to the Input Tax Credit account. The Tax Code that points to the tax rate is identified in program CC00-Accounts Payable, for Input Tax Credit 1 and Input Tax Credit 2.

  • It is very likely that you will still be entering December invoices into AP30 after January 01. For those invoices, the Input Tax Credit amount(s) will be calculated at the new rate and, therefore, will not match the actual tax charged on the invoice. In those cases, simply override the system generated GL distribution amount for tax in Folder 2.

  • Alternatively, you could choose to change the Tax Code(s) in CC00-Accounts Payable temporarily to a code that points to the old tax rate, process those pre-January invoices in a separate batch and then change the Tax Code(s) back.


Back to top

 
Using the Tax Recode Utility (Option 3)

In this option you will leave your existing Tax records for QST in place to be used when credit notes are generated from Invoice History for sales made prior to January 1. You will not need to override the Tax Group to get tax on the credit note to calculate at the same rate as on the original invoice.

You will create new tax records for the NEW tax rate and use the Tax Recode Utility (CC55) to recode the Tax Group in the Customer Master, Ship-To Master and Open Order file to the new Tax Group. Tax on new orders and on outstanding orders invoiced after January 1 will calculate at the new rate.

NOTE: In July, 2010, the Tax Recode Utility (CC55) was made available for purchase; some users may not have this program.

What to do PRIOR to January 1, 2010:

  • Review your existing Tax Codes, Tax Groups and Product Tax Exceptions to familiarize yourself with your company’s codes and tax setup.

  • Confirm that the Province/State field is set to "QC" for your Quebec customers in the Customer Master (SU13) and Ship-To Master (SU14). This is important because the Province Code is used by the Tax Recode Utility to identify these customers.

  • Leave your QST Tax Code @ 7.5% (in IN05) and your Tax Group for Quebec customers (in IN06) alone. These original Tax Rates and Tax Groups will be used for Credit Notes generated from Invoice History on pre-January 01 sales.

  • Set up a new Tax Code (in IN05) for QST @ 8.5%.

  • Set up a new Tax Group (in IN06) for your Quebec customers that are charged GST & QST @ 8.5% (and, if applicable, for customers charged QST only).

  • If you have exceptions in IN07, then you may need to add new records to control the exceptions for your new Tax Groups.

After the new Tax Codes, Tax Groups & Exceptions are set up in the Live Company:

  • If you wish, refresh your Test Company and test the new Tax set up. For details on refreshing your test company, see the Refreshing a Test Company topic.

  • Note: For Enterprise 6.1 users maintaining Customer data with iTopia, contact smbsupport@tecsys.com to confirm this step.

  • For Quebec customers, their Tax Group needs to be recoded in SU13 for Customer Master, in SU14 for Ship To addresses and on all of their outstanding orders and quotes entered into the system prior to January 1.

  • Run the Tax Recode Utility (CC55) in your Test Company and then process invoices to test the tax calculation. Be sure to invoice old orders to be sure they are taxed at the new rates and credit an old invoice to be sure they credit at the old tax rates.

  • Alternatively, you can enter a test order in the Live Company, override the Tax Group to the new Tax Group and check in Folder 4 that the tax calculated properly.

What to do ON January 1, 2011:

  • Be sure all December invoices and credit notes have been processed and there are no open invoicing cycles: IN42/IN43/IN44

  • Do not enter any Quebec orders for January unless you are prepared to manually override the Tax Group in the order header.

  • If applicable, shut down any processes that would feed an auto-generate order/invoice process. For example, Evolve, Order Stream, Radio Beacon, EDI, etc.

  • Confirm all of your new Tax Codes, Tax Groups and Tax Exceptions do exist in your Live Company.

  • Run the Tax Recode Utility (CC55) for applicable Quebec customers to change their Tax Group from the OLD Tax Group to the NEW Tax Group.

  • Begin January orders and invoicing.

  • Remember to turn any auto-generate order processes back on.

  • **TIP** You can spot check that the appropriate taxes are being calculated in Folder 4 of OE30/IN41/RS41.

What to Consider AFTER January 1, 2011:

Pay special attention when issuing credit notes to Quebec customers after January 1 for invoices issued prior to January 1. First check if the original invoice was dated prior to January 1, 2011. If it was, then taxes were calculated on the original invoice using the old rates. Taxes on the credit note must match taxes on the original invoice.

  • Credits created using IN41-Auto Credit:

    When using Auto Credit, the Tax Group assigned to the credit note header and detail lines defaults from Invoice History to the Tax Group on the original invoice. No overriding of the Tax Group should be required.

  • Credits created using IN41-Use RMA:

    When using Use RMA, the Tax Group on the original invoice detail line is passed to the RMA detail line and subsequently passed to the credit note detail line. That means taxes on the credit note will match taxes on the original invoice. However, the Tax Group in the generated credit note header is set to the Customer’s current Tax Group (from SU13/SU14). This will need to be overridden if you ADD any product or supplementary charge detail lines to the credit note after the Use RMA generation.

  • Credits created Manually in IN41:

    When creating a credit manually, the Tax Group in the Credit Note header will default to the Customer’s current Tax Group (from SU13/SU14). This needs to be overridden to the Tax Group that was used on the original invoice.

  • Overriding the Header Tax Group:

    For information related to overriding the Header Tax Group, an Overriding the Header Tax Group section is included at the end of this topic.

    **TIP** Always check the calculated taxes in Folder 4 before you exit the credit note. If there is any doubt as to whether or not the Tax Group is set properly in the detail line, you can check the Tax Group in the More Details window in Folder 3 or in the Supplementary Charge record and revise if required.

  • RMA’s for Multiple Products Returned:

    When using IN67 to create an RMA you are selecting invoice detail lines from which goods are being returned. Be sure to check the invoice date (shown in the invoice display list box) and do not mix products belonging to a pre-July invoice with a post-July invoice on the same RMA. When that RMA turns into an order/invoice/credit note, it should not have mixed taxes on it.

    • When the RMA is turned into a credit note, the appropriate Tax Group will need to be assigned to each credit note. You may wish to add a comment on the RMA if the original invoice was pre-January as a reminder to override the Tax Group in IN41.

  • Accounts Payable – Input Tax Credit:

    When invoices are entered into AP30 for a domestic vendor, the program applies the current tax rate to the entered invoice amount and calculates the tax amount included in the invoice total; this becomes the default GL distribution value to the Input Tax Credit account. The Tax Code that points to the tax rate is identified in program CC00-Accounts Payable, for Input Tax Credit 1 and Input Tax Credit 2.

    • Quebec users should change the Tax Code for Input Tax Credit 2 to point to your new QST Tax Code.

    • It is very likely that you will still be entering December invoices into AP30 after January 1. For those invoices, the Input Tax Credit 2 amount will be calculated at the new QST rate instead of the old QST rate and, therefore, will not match the actual tax charged on the invoice. In those cases, simply override the system generated GL distribution amount for tax in Folder 2.

    • Alternatively, you could choose to change the Tax Code in CC00-Accounts Payable temporarily to a code that points to the old QST rate, process those pre-January invoices in a separate batch and then change the Tax Code back.


Back to top

 
Overriding the Header Tax Group

The Tax Group is stored in the order/invoice/credit note header. It is also stored in the product or supplementary charge detail line record if it was overridden on the detail line on the original invoice or if the product/supplementary charge qualified for Exception tax rules in IN07 on the original invoice.

If you return to Folder 1 after one or more detail lines have been created and override the Tax Group to a code that points to the desired tax rates, you will be prompted as follows (note that references to codes HST and GST are for example only):

image

"Lines Flagged as Override" refers to a Tax Override Flag stored in each detail line. On the original invoice:

  • If the Tax Group on the detail line on the original invoice was manually overridden, then the Tax Override Flag=Y.

  • If the product had Exception tax rules applied from IN07, then the Tax Group is different on that detail line but the Tax Override Flag is NOT set on the original invoice.

If using Auto Credit, the Tax Group and Tax Override Flag will be copied from Invoice History into the credit note detail lines the same as they were on the original invoice. If you choose Keep Override, the detail lines where the Tax Override Flag = Y (ie, manual overrides) will retain the Tax Group from the original invoice. All other detail lines will be taxed per the Tax Group entered on the Credit Note header.

If using Use RMA, program IN67 copied the Tax Group from Invoice History and set the Tax Override Flag=Y for ALL product detail lines on the RMA; that Tax Group and Tax Override Flag is passed to each detail line on the Credit Note created from the RMA. If you choose Keep Override, then the Tax Group will not be changed on any of the detail lines (because they are all flagged Tax Override=Y; those detail lines will retain the Tax Group from the original invoice).

If you are entering the credit note manually, then taxes are assigned according to the Tax Group in the credit note header and the Exceptions in IN07.


Back to top