Page 1 of 1

Calculate tax after discount

Posted: Wed Nov 25, 2020 12:15 am
by quintal
I have looked all over and found some replies about this subject, but I still can't figure it out... Maybe I'm stupid, but I'll ask anyway...

I'm giving my clients a total discount of 25% on all purchases. This is what is shown now.
For instance; The price of the product is 22.95 minus 25% discount is 22.95 - 5.73 = 17.22 total incl. Tax.
This shows now:
Sub-Total: 18.66 (this is 22.95 without tax)
Discount: 4.66 (= 25% of 18.66)
Tax 23%: 4.29 (which is 23% over 18.66)
Total: 18.29

The problem is with the tax. This should not be 23% over 18.66, but should be 23% over 14 (18.66 - 4.66) and therefor should be 3.22, which than should bring the total to 17.22.
The way it is now, the client pays too much tax.

To be more clear, this is what it should look like:
Sub-Total: 18.66
Discount: 4.66
(Sub-Total 2: 14.00)
Tax 23%: 3.22 (which is 23% over 14)
Total: 17.22

Any solutions?? I am using version 2.3.0.2.

Re: Calculate tax after discount

Posted: Wed Nov 25, 2020 12:46 am
by ADD Creative
How are you applying the discount? With an extension?

Re: Calculate tax after discount

Posted: Wed Nov 25, 2020 11:21 pm
by Johnathan
Whichever extension you're using for a discount needs to have a Tax Class setting on it. If you set that to the same tax class then it should decrease the "Taxes" line item appropriately based on the sub-total + discount.