Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

Compound Tax (often refereed to as Stacked Tax or Tan-On-Tax) is a tax calculation where the total cost of the product or service is taxed at one rate, and then the total of that amount, including the first tax amount, is taxed a second time. In Quebec and Prince Edward Island (PEI) in Canada, the General Sales tax is calculated and added to the price of the product. Then the Quebec or PEI Provincial Tax rate is calculated for that total amount, which is added to the previous total.

(grey lightbulb) The phrases [Compound Tax] and [Staked Tax] are used interchangeably throughout this document. 


Info
titleExample

Below is an example of a compound (stacked) tax calculation using Quebec Canada Tax Rates where the QST is stacked on top of the GST.

Product = $100

GST = 5%

QST = 9.975%

General CalculationActual Calculation
Product Price$100
+ Product Price x GST+ $100 x 0.05
+ (Product Price x GST) x QST+ ($100 x 0.05) x 0.09975
Total $115.47


The first assumption in configuring Compound (Stacked) Tax is that you will must have at least 2 Taxes assigned to the Tax Category. Most Compound (Stacked) Tax scenarios involve only 2 Taxes however you could technically stack as many Taxes on top of each other as required. In the Calculation Example above we used Quebec Canada Tax Rates to illustrate the calculation. Below we will show you how to configure the Quebec Taxes in a Compound (Stacked) Tax scenario.

...


Configuring Compound (Stacked) Tax

  1. Create the 2 Taxes that will be added the Tax Category

    Info
    titleNOTE

    For more information on creating Taxes please see the Taxes topic


  2. Create the Tax Category that will hold both Taxes created in (1) above and add both Taxes to the Tax Category

    Info
    titleNOTE

    For more information on creating a Tax Category please see the Tax Category topic


  3. The Tax Category - Taxes module should now look very similar to below, with both Taxes having a Stacked Order Index of 0.
    CDR2Cloud - Tax Category TaxesImage Added

    Info
    iconfalse
    titleStacked Order Index

    (lightbulb) The Stacked Order Index determines the sequence in which the multiple Taxes are calculated. A Stack Order Index of 0 indicates that the Tax will be calculated first and as a standard Tax. If all Taxes have a Stacked Order Index of 0 then they are all treated with the same priority and are all calculated as a Standard Tax. 

    If Tax A has a priority of 0 and Tax B has a priority of 1 as follows:

    TaxStacked Order IndexOrder
    Tax A0calculated 1st - (price x Tax A)
    Tax B1calculated 2nd - (price x Tax A) x Tax B

    Tax A will be calculated first, then Tax B will be calculated as a Stacked Tax on the result.


  4. Set the Stacked Order of the tax you would like to be calculated last to 1 by clicking the Image Addedbutton next to the Stacked Order Index. 
    Clicking theImage Added button immediately saves the stacked Order Index changes. The Taxes in your Tax Category should now look as follows:
    CDR2Cloud - Stacked Order IndexImage Added
  5. You can now assign the Tax Category to as many customers as you need to. The Taxes will be calculated as demonstrated in the Calculation Example at the top of this page.






Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.
Related articles

Filter by label (Content by label)
showLabelsfalse
max5
spacesCDR2CLOUD
showSpacefalse
sortmodified

...

reversetrue
typepage
cqllabel in ( "tax" , "taxcategory" ) and type = "page" and space = "CDR2CLOUD"
labelstax taxcategory


Info
iconfalse
titleTAX & TAX CATEGORY TOPICS

Page Tree
expandCollapseAlltrue
rootTax & Tax Categories
spacesCDR2CLOUD