Hello,
we need to apply the correct tax rate in Germany based on products that are being shipped.
The tax rate for shipping costs depends on the products that are in this order.
Example 1 - 19% tax rateItems with only 19 % tax rateShipping cost tax rate: 19%
Example 2 - 7% tax rateItems with only 7% tax rateShipping cost tax rate: 7%
Example 3 - 7% and 19% tax rateItem one:
- Gross price (incl. Tax): EUR 119
- Tax rate: 19%
- Net price: EUR 100
- Tax: EUR 19
Item two:
- Gross price (incl. tax): EUR 214
- Tax rate: 7%
- net price: EUR 200
- tax: EUR 14
Shipping cost:
- Gross price: EUR 5
- Calculation:
- Total netto order without shipping: EUR 300 (100+200)
- Share to apply 19% tax rate: 100/300
- Share to apply 7% tax rate: 200/300
- Gross share for 19%
- 100/300 * 5 EUR = 1.666667 (Gross shipping)
- Tax rate: 19%
- Tax: 0,266139775910364
- net: 1,400560224089636
- Gross share for 7%
- 200/300 * 5 EUR = 3.333 (Gross shipping)
- Tax rate: 7%
- Net: (3.333/1.07) = around 3.11
- Tax (7%) = around 0,218
How can we achieve this in the best possible way? I believe there must be a standard as it is a common used case.
Thanks