Calculation of Cannabis Excise Duties in SAGE X3

Excise duty needs to be paid by cannabis distributors who supply packaged cannabis products to their customers. The excise duty is calculated based on the sales price of product that is charged to customer. Panni has built functionality in SAGE X3 to calculate the excise taxes/duties payable and this document would explain how the excise taxes/duties payable are calculated in SAGE X3.

Product Identifier field in Products Master

Any packaged cannabis product that can be classified within the following product types would be considered excise-dutiable at the time of product delivery:
  • Cannabis Oil
  • Cannabis Extracts
  • Edible Cannabis
  • Cannabis Topicals
In SAGE X3, Panni has provided an additional tab called ‘Excise Tax’ where the type of cannabis product can be defined under the ‘Product Identifier’ field: word-image

Excise Tax Rates Table

Let us name the rates used for calculating the three components of excise taxes as below.
Excise tax component Rate
Flat-rate cannabis duty R1
Flat-rate additional cannabis duty R2
Adjustment to additional cannabis duty R3
The rates used for calculation of the three components of excise taxes would be based on the province of delivery address and the type of cannabis product delivered. In SAGE X3, Panni has developed an Excise tax rates table where user can define the excise tax rates based on province of delivery and packaged cannabis product type. word-image Initial data entry on this table would be a one-time activity. The data in table would later need to be updated only when there are changes in the rates provided by Canada Revenue Agency. word-image

THC in mg

For any packaged cannabis product that exists in a lot, Quality Control process would need to be done. In the Quality control process, there would be a technical sheet associated with every packaged cannabis product that exists in a lot. This technical sheet would be filled in by the person who performs the quality control on the product-lot. One of the questions in the technical sheet would be THC in mg per unit of the product.

Sales Delivery

When the Sales Delivery is created, the excise taxes would be calculated for every line in the Sales Delivery. The rates used for calculation (R1, R2, R3) would be selected based on the product on the line and province of delivery address in the Sales Delivery. The THC (in mg per unit) would be fetched from the quality control record of the product-lot combination. The three components of excise taxes would be calculated and displayed (on a per unit basis) in every line of the Sales Delivery.

Automatic Journal

Sales Delivery Automatic journal would record the total excise taxes as Credit Excise Tax (Contra revenue) and Debit Excise Tax Payable.

Transforming businesses since 2009

For over a decade, Panni has helped companies transform their businesses to lead, innovate and be profitable. With the right combination of technology and experienced developers and consultants, we help companies with Change Management to achieve the organizational objectives. We believe in long-term relationships with our clients and provide top-notch support with fast turnaround times.

Looking for ERP advice?