Post by makauro » Sat Jul 03, 2021 5:23 pm

I am having problems calculating tax. What i am trying to do is following: Article A cost 40 bucks. Then a Customs excise tax is applied of 40%. Then VAT of 12.5% is applied. When i use a tax rate with two tax classes, then both rates are applied to the cost. However, i need VAT to be applied to Cost + excise tax.
so take cost, add excise duty and then add VAT which is calculated from total of cost+VAT.
Was trying this with standard feature without extension.

I am using opencart 3.0.2.0
Last edited by makauro on Sun Jul 04, 2021 2:48 am, edited 1 time in total.

Newbie

Posts

Joined
Sat Jul 03, 2021 5:05 pm

Post by ADD Creative » Sat Jul 03, 2021 8:10 pm

makauro wrote:
Sat Jul 03, 2021 5:23 pm
I am having problems calculating tax. What i am trying to do is following: Article A cost 40 bucks. Then a Customs excise tax is applied of 40%. Then VAT of 12.5% is applied. When i use a tax rate with two tax classes, then both rates are applied to the cost. However, i need VAT to be applied to Cost + excise tax.
so take cost, add excise duty and then add VAT which is calculated from total of cost+VAT.
Was trying this with standard feature without extension.

I am using opencart 3.0.2.0
In OpenCart tax is always calculated on the net price. If all your products have the 40% excise tax applied you could set the VAT rate to 17.5% (which is 12.5 + 40%).

If some products don't have the excise tax they you may be able to this by having different combinations of different Tax Classes and Tax Rates that account for each situation.

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by makauro » Sat Jul 03, 2021 8:32 pm

I think using 17.5 as VAT will not work. Article A cost 40.00. Then the Duty excise Tax of 40% (for vehicles & Parts) is applied. Article A is now 56.00. And next the 12.5 % VAT is applied to the 56.00 which makes it a total of 63 bucks.

Newbie

Posts

Joined
Sat Jul 03, 2021 5:05 pm

Post by mikeinterserv » Sat Jul 03, 2021 9:23 pm

40% TAX
Your business is to help corrupt people profit so well ?

Active Member

Posts

Joined
Thu May 28, 2020 6:55 am
Location - Wales

Post by makauro » Sat Jul 03, 2021 9:32 pm

40% Duty. Simple system... No income Tax.. no road tax.. All paid from import taxes from luxury items.

Newbie

Posts

Joined
Sat Jul 03, 2021 5:05 pm

Post by makauro » Sat Jul 03, 2021 10:46 pm

Thanks to ADD Creative. For some reason my for logic part of the brain was in holiday... of course 17.5% works. Simply created new tax rate saying 12.5 but using 17.5 which is applied on tax class used for vehicles.

Newbie

Posts

Joined
Sat Jul 03, 2021 5:05 pm

Post by straightlight » Sun Jul 04, 2021 2:42 am

makauro wrote:
Sat Jul 03, 2021 10:46 pm
Thanks to ADD Creative. For some reason my for logic part of the brain was in holiday... of course 17.5% works. Simply created new tax rate saying 12.5 but using 17.5 which is applied on tax class used for vehicles.
Now that the issue has been solved, please add: [SOLVED] at the beginning of the subject line on your first post.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 97 guests