PayPal calculates VAT on original price, not discounted price

  • PetraTest
    Asked on August 26, 2016 at 6:42 AM

    Hi

    We have customers complaining that they pay to much in VAT when they use a coupon code to get a discount. PayPal seems to calculate the VAT based on the ordinary price and not the lower, discouted price.

    Can you check this, please?

  • Rose
    Replied on August 26, 2016 at 7:43 AM

    Let me some time to investigate another possible way for it. I will get back to you soon. 

  • Rose
    Replied on August 26, 2016 at 8:44 AM

    Thank you for your understanding and patience for waiting. 

    The VAT value is calculated based on non-discounted price on payment tool. If your customer would like to pay vat value according to discounted prices, you need to configure it with condition logic and pass the value to a payment tool. 

    Here is the results of my work to meet your requirement. 

    1. You need to use a DropDown/Radio/CheckBox field to specify your product(s). I declared only one product with a price of $100 on my work and I chose Radio Button field.

    PayPal calculates VAT on original price, not discounted price Image 1 Screenshot 180

    2. You need to use three calculation widgets to calculate vat and total. To drop calculation widget to your form, you just need to search it on "More Field" and then just drag and drop it to the form. 

    PayPal calculates VAT on original price, not discounted price Image 2 Screenshot 191

    3. To calculate Vat value, you need to configure it as you see below. Please note that, the rate value for vat  that I specified is %10. You need to change 0.1 part on the calculation to your vat rate. For example, If your vat rate is %20, you need to change to 0.2, etc. 


    PayPal calculates VAT on original price, not discounted price Image 3 Screenshot 202
    PayPal calculates VAT on original price, not discounted price Image 4 Screenshot 213


    4. You need to indicate shipping value in calculation widget as below. In other words,You just need to enter its value.

    PayPal calculates VAT on original price, not discounted price Image 5 Screenshot 224

    PayPal calculates VAT on original price, not discounted price Image 6 Screenshot 235


    5. Now the time is to calculate total value. You need to Add up prices of vat, shipping and product. 

    PayPal calculates VAT on original price, not discounted price Image 7 Screenshot 246

    PayPal calculates VAT on original price, not discounted price Image 8 Screenshot 257

    Until here, we make calculations based on no- discount situation. 

    Now, you need to built conditions for discounted calculations. 

    1. First Add a TextBox Field to allow your user to enter a coupon code. 


    PayPal calculates VAT on original price, not discounted price Image 9 Screenshot 268

    2. Click Coupon field >> Arrow  PayPal calculates VAT on original price, not discounted price Image 10 Screenshot 279 >> Conditional Logic  PayPal calculates VAT on original price, not discounted price Image 11 Screenshot 2810

    3. Choose Update/Calculate Condition

    PayPal calculates VAT on original price, not discounted price Image 12 Screenshot 2911

    4. Set your condition based on the idea of  if a user enter a coupon code, vat and total values are calculated according to price after discount.

    For example, I declared two coupon codes having same discount amount which is $50 in my example. Because of the same amount, I just set coupon code condition in the same logic but if your coupon code values are different than each other, you may need to duplicate conditions for all coupon values. I indicated coupon codes in my example as " abc " and "def" but you can of course choose whatever you want.

    Conditions For Vat Field :


    PayPal calculates VAT on original price, not discounted price Image 13 Screenshot 3012

    PayPal calculates VAT on original price, not discounted price Image 14 Screenshot 3113


    Conditions For Total Field :

    PayPal calculates VAT on original price, not discounted price Image 15 Screenshot 3214


    PayPal calculates VAT on original price, not discounted price Image 16 Screenshot 3315


    Now, the problem is how to pass this calculation to a payment field. Following user guidances comes to your rescue. 

    https://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field


    After following  above steps, you will see a similar screen as below regarding the result of them. 

    PayPal calculates VAT on original price, not discounted price Image 17 Screenshot 3416


    Hope, these would help you. 

    If you need any further assistance by our side, please do not hesitate to contact us. 

  • PetraTest
    Replied on August 26, 2016 at 9:29 AM

    I do not want to calculate VAT myself, or in Jotform, but leave that to PayPal. But they dont seem to get the right amount from you, that is what the customer actually is paying, with the discout deducted, in order to calculate the correct VAT.
    PayPal calculates based on 139 instead of 127.

    PayPal calculates VAT on original price, not discounted price Image 1 Screenshot 20

  • Welvin Support Team Lead
    Replied on August 26, 2016 at 10:31 AM

    Would you mind letting us know your tax rate(s)? I have tested your form and selected the UK as my country, here's the calculation in Paypal:

    PayPal calculates VAT on original price, not discounted price Image 1 Screenshot 20

     

    Is this not correct? 

  • PetraTest
    Replied on August 29, 2016 at 4:06 AM

    Yes, so far it is correct. It is in the next step where PayPal calculates the VAT that it is wrong. The tax rate is 25% (Swedish tax) to all purchases within EU. 25% of 127 is 31,75, but PayPal adds 34,75 which is based on the original price without the discount (139). This meas that the customer pays 3€ too much, in this case - the difference is bigger whe the discounted amount is larger.

    PayPal calculates VAT on original price, not discounted price Image 1 Screenshot 20

     

  • Rose
    Replied on August 29, 2016 at 7:50 AM

    It seems that it is a PayPal issue more than a Jotform issue. 

    I do not want to mislead you. Since; I don't know how you set up your tax rate on your PayPal account. Moreover, I do not know if there is any option to calculate Vat value according to discounted price rather than original one. 

    However, The solution I provide you above will works for your situation. You can make tax rate on your Paypal account as " 0" base and calculate tax rate on the form and then pass the amount to Paypal Payment Tool. 

    If you need any further assistance by our side, please let us know.