# complex tax calculation, how?

By
Tankgirl
on 2/24/14, 11:18 AM 1,511 views

I want to calculate a special tax on shipping costs.

Example:

Someone purchased two products: one product with 6% taxes and one with 21%

• Product one is 7,50 with 6% tax included
• Product two is 2,50 with 21% tax included

Total amount is 10.00 euro with tax included

• So 75% of the products are taxed with 6% tax
• and 25% of the producs are taxed with 21% tax

Shipping costs are 3,50 with tax included, but: 75% of 3,50 needs to be taxed with 6% tax and 25% of 3,50 with 21%tax

How do I do this?

Hi; Which accounting system are you using (Which Country) ?

Med Said BARA
on 2/24/14, 11:57 AM

I'm using Openerp 7.0, Dutch language (The Netherlands). I already have the 6% tax and 21% tax configured, but I want a special tax for shipping-costs. The amount of Tax on shipping-costs depends on what kind of products are being purchased.

Tankgirl
on 2/25/14, 4:42 AM

#### michel Guénard

--michel Guénard--

1058
| 5 5 8
VIROFLAY, France
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 6/18/14, 12:45 PM

Create a tax code (new and specific to your case) where the calculation will result from a python formula

Code Python (TVA Incl)

result = ((price_unit*0.75*0.06) + (price_unit*0.25*0.21))

where price_unit is the price of the product "Shipping to be invoiced" (to be created in your system)

André Schenkels
On 2/25/14, 5:30 PM

The easiest way would be to just create 2 shipping cost products 1 with 6% and one with 21%

But this will not be easy to fix. You will need to build a small module for this.

I think, the solution maybe in " Price List".

Med Said BARA
on 2/26/14, 4:34 AM

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

### Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

0 follower(s)

### Stats

 Asked: 2/24/14, 11:18 AM Seen: 1511 times Last updated: 3/16/15, 8:10 AM