Hello Guru,
To get background info on the issue, please see below:
Calculating the vaping duty - Excise duty for vaping products - Canada.ca
we have to add the Excise tax amount to our Products when importing or selling
the amount of excise tax varies for items based on the weight or volume of the vaping liquids, so it's not a fixed percentage like PST or GST/HST
How should this be configured into NetSuite? I believe there should be a best practice solution for implementing this since this would be an issue for all companies that import or sell alcohol or vaping products at least in Canada.
How we handled this?
currently, for the sales process, the excise tax amount is added to our base price, and for the purchase process, we configured it as a landed cost template.
The first issue we faced was that sales revenue was affected due to the baking excise tax amount in the base price. consequently, all native reports showed an "inflated amount", so we did some customizations to get valid reports to see the Net sales revenue (excise tax excluded), and a custom formula field was created to calculate the sales amount without excise tax. (for sales transactions), which itself was very cumbersome and challenging. considering the fact that formula fields are not available on the report builder!
The other issue we faced is related to Stamping. manufacturer or packager has to stick a state stamp on the products' package for excise tax, and the number of used stamps is the basis to calculate the amount we got from our customers under the excise tax and we have to pay the government. B600 purpose is to calculate how much $ excise duty is owing to the CRA along with a summary detail of raw material movement represented in mL.
(Reporting and remitting the vaping duty - Excise duty for vaping products - Canada.ca)
the second issue came up on samples /defectives, which are packed and stamped but we don't earn any $ amount if we don't exclude them somehow from our inventory, we have to pay CRA for them while we didn't get anything.
we ultimately want it off of our inventory since it's not sellable and will never be sellable. However, CRA mandates that we keep a log of this and treat it as inventory even though it is not in our inventory anymore. As of now, we use Inventory adjustment daily for adjusting the inventory, This seems not to be a best practice solution since IA is mainly for covering discrepancies between physical inventory and system inventory and is mainly used after cycle counting.
Please let me know if you have any questions.
Thanks