How can we solve this tax issue? Is there a way I'll use different % of taxes?

  • VRTO
    Asked on August 30, 2020 at 4:41 PM

    (4) And last a question about the tax (VAT) - BTW used in the Product List.

    I can choose for a tax percent (VAT-BTW) in the Product List. Right so I choose for 6%.
    But in my country we'll have to use different VAT ranges. So for some products you'll have to pay 6% and for other ones it's 21%. On the same invoice!

    In my invoice I have Cola Zero (that's 6% tax) but also a bottle of wine (and that's 21% tax). And this will differ for each product. 
    How can we solve this tax issue? Is there a way I'll use different % of taxes?

    1598801879BTW Screenshot 10

     

  • Mike_G JotForm Support
    Replied on August 30, 2020 at 4:52 PM

    The tax percentage options may only be different based on the address or location your respondents entered/selected in an address field (you will need to have an Address field on your form to set this up) or the selection they made on a drop-down field.

    1598818953zt200830 161252 Screenshot 10

    You may not be able to set different tax rates per product. A workaround that I can only think of is instead of using the Tax option of the Product List, you can use the Shipping option.

    1598819136zt200830 162034 Screenshot 21



  • VRTO
    Replied on August 30, 2020 at 5:22 PM

    Thanks Mike_G for your kind answer. 
    But I'm afraid that's not the point... 

    As far I can see the tax solution you'll propose is depending of the location of the customer. So when his address is country A the tax will be (example) 2% and when he is from country B the tax will be 7%.

    What I'm talking about is all our customers are from the same country and the same state, but the tax is different from product to product. So also NOT various taxes for the SAME product. 

    Example:
    Bread : tax is 6%
    Juwels: tax is 21%
    Beer: tax is 21%
    Vegetables: tax is 6%
    Fruit: tax is 6%
    Wines: tax is 21% 
    etc... etc...

    So that's the point. Even in different drinks it depends what kind of drink it is for the % of tax.
    I know it, it's not easy to handle. Even not for us in our country :-) Many international invoice programs will get in trouble with this... :-)

    Will there be a way to solve this?

    I was also thinking to create 2 different forms. One with Product List on 6% tax, the other form with 21% tax. And then a third form with using iFrames to embed form 1 and form 2. But will be that a solution? Then I can not have calculation fields what will count both totals together etc... ?

    Thanks !

  • Mike_G JotForm Support
    Replied on August 30, 2020 at 8:00 PM

    I would like to apologize for any confusion.

    Yes, the option to set different tax rates per product is not possible under the Tax feature (Tax tab) of the Product List. However, we might be able to achieve your requirements if we will set shipping for each product instead.

    On the form, we can change the text for the Shipping fee to "Tax" and it will appear like this:

    1598829120zt200830 190429 Screenshot 10

    However, although we can format the Product List of the PDF Invoice like this on the PDF Editor page,

    1598829735zt200830 191419 Screenshot 21

    1598829802zt200830 191454 Screenshot 32

    we still cannot update the word "Shipping" to make it "Tax" on the PDF Invoice and that, I think, is the issue with the workaround I suggested.

    We can send a feature request to our developers on your behalf to allow making updates to the texts in the payment field of the PDF Invoice, however, we cannot guarantee that it will be implemented anytime soon.

    As for creating 2 forms, one for each product tax rate, that might work since you can pass the value of a field in a form into another form after submission. The only issue that I'm seeing with this workaround is how the invoice will be created since the order information will be on different forms.


  • VRTO
    Replied on August 31, 2020 at 3:32 AM

    I found a solution and work around... :-) 

    When I use the shipping module, I have to calculate for each product individual the amount of the tax.

    So when the price for one bottle is 1,00 € and the tax is 21%, then the amount will be 0,21 € for each bottle. And I put this exact amount in the Shipment conditions for 'cost for the first item' as well for 'extra costs for items'.

    1598858100Schermafbeelding 2020 08 31 om Screenshot 10

    ALSO I have to tell to the tax module that this specific product (PRO Jupliler at 21% tax) is free of charge, so no tax (I know it looks weird) 

    If not the general tax of 6% will also calculated extra for this item. Then it's double: 6% (tax) and 21% (shipping) :-)

    1598858268Schermafbeelding 2020 08 31 om Screenshot 21

    At the invoice, when I calculate, then I will get two amounts at the end:
    - Taxes for 6% (BTW 6%)
    - Taxes for 21% (Verzendopties - shipping costs)

    That's correct, so this can work.

    Only thing is that the word "Shipping" at the end should be replaced with the word "BTW 21%".  

    1598858775rekening Screenshot 32In the language version I'll use the word Shipping is already translated by Jotform into "Verzendopties". So in the code this word is already stored somewhere in the code. Right ? 
    Can it not be replaced within my CSS with another word? So some extra CSS that will replace the word 'Verzendopties' by the word 'BTW 21%'?

    For me it's no problem cause shipping costs itself for the real shipping of goods I'll never use... :-)  

    And once this has done then my problem is solved !!!

    Thanks !


  • VRTO
    Replied on August 31, 2020 at 3:35 AM

    UPDATE !!! 

    I just discovered I can change the word "Verzendopties" myself with "BTW 21%".

    So SOLVED !!!

    Now I'm going to test the layout of the invoice-PDF.