Wrong price with different tax-rate

  • Resolved quinox

    (@quinox)


    9 years, 10 months ago

    Hello,

    I think i’ve might find a bug in calculation taxes with different tax-zones in WooCommerce 2.6.4. This problem started after upgrading to this version and after upgrading “WooCommerce Price Based on Country”.

    It seems to do the following:
    Price with 21% VAT (€369) : 121 x 119 = €362,90 German price, instead of €369,-

    I already cleared WC Transient but nothing helps. The only thing what helps, is disabling the Tax, but that’s not an option because the tax have to be on the invoice which is automatically generated in the shop.

    I’m using the default Twentyeleven theme.

    Regards,

    Roland de Lepper

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Oscar Gare

    (@oscargare)

    9 years, 10 months ago

    Hi Roland ,

    read this topics:
    https://wordpress.org/support/topic/tax-included-amount-incorrect-weird-behaviour-enetering-prices/

    and

    https://wordpress.org/support/topic/shipping-with-vat/

    Regards.

    Thread Starter quinox

    (@quinox)

    9 years, 10 months ago

    Hi,

    Thank you for your quick reply.

    I’ve read those posts, but I still doesn’t get it.

    I enter the prices incl VAT of my product. I set my price manually for the countries and not by exchange rate.
    – NL €319,- incl VAT (21%)
    – DE €369,- incl VAT (19%)

    The shop price have to be listed €369 incl VAT for Germany, not €362,90. That’s why i’ve entered the price €369,- in the products for Germany.

    This was working correct. Only after the update of WooCommerce and your plugin, something has changed.

    Note: While i’m writing this reply, I think I get it now. But it’s not logical to put a different price at your product, then is shown on the shop and checkout.

    Please your reply on this.

    Regards,

    Roland de Lepper

    Plugin Author Oscar Gare

    (@oscargare)

    9 years, 10 months ago

    Hi,
    older versions of PBC not works fine with price with tax included, PBC 1.6 fix this issues.

    This is a example of WooCommerce and PBC tax logic :
    Your base country is ES and tax 21%
    tax for DE 19%
    tax for NL 21%

    All prices are set with tax include and show in frontend with tax include:

    Price for DE 100 (incl tax 21% for ES, your base country)
    Price for NL 110 (incl tax 21% for ES, your base country)

    Price display for a customer from DE
    100 – (100 * 0,21 (ES tax) ) = 79
    Add DE taxes
    79 + (79 * 0,19 (DE tax ) ) = 94,01

    Thread Starter quinox

    (@quinox)

    9 years, 10 months ago

    Hi Oscar,

    I’ve installed PBC 1.6.2. The version which works correct for me is version 1.5.8.

    I’ll try to understand it.
    So I have to put a different price at the products page in WooCommerce then is shown on the website for the countries who have a different tax-rate then the default 21% ??
    Example:
    369:119×121 = 375,20. Shop-price is listed as 369.

    This looks correct but the calculation of the tax is wrong.
    Should be: 369 :100 x19 = 70,11
    Is now: 58,92
    I’m missing 3% Tax!!

    The amount of tax is listed on the invoices, so it’s important this is calculated correctly.

    The price for the German customers (19%) have to be listed as €369

    Regards,

    Roland de Lepper

    Plugin Author Oscar Gare

    (@oscargare)

    9 years, 10 months ago

    Hi Roland,
    check your tax settings,
    can you link a sreenshots with your tax settings and your pricing zones?

    thanks

    Thread Starter quinox

    (@quinox)

    9 years, 10 months ago

    Hi Oscar,

    I’ve put the images on my test environment. (server may be a bit slow)

    http://webinweb.nl/wordpress0930/screen-shot-2016-10-13-at-10-13-24

    http://webinweb.nl/wordpress0930/screen-shot-2016-10-13-at-10-12-10

    Regards,

    Roland

    • This reply was modified 9 years, 10 months ago by quinox. Reason: Image not visible
    Plugin Author Oscar Gare

    (@oscargare)

    9 years, 10 months ago

    What is your shop base country and your settings for Price Entered with tax and Display prices in shop?

    Thread Starter quinox

    (@quinox)

    9 years, 10 months ago

    Hi Oscar,

    All translated from Dutch:

    – Shop base country -> The Netherlands

    – Price entered with tax -> Yes, I want prices including Taxes

    – Display prices in shop -> Including Taxes

    Regards,

    Roland

    Plugin Author Oscar Gare

    (@oscargare)

    9 years, 10 months ago

    Hi Roland,
    how WooCommerce works with your settings in frontend for a DE customer:

    Price (inc 21% VAT of NL) 369

    For a DE customer WooCommerce calculates the price included VAT for DE (21%):

    First, calculate prices without taxes:
    369 / 1.19 (19% of NL VAT ) = 310.0840336134454

    Second, adds DE VAT (21 %) and display price inc VAT to customer
    310.0840336134454 * 1.21 = 375,2016806722689

    Thread Starter quinox

    (@quinox)

    9 years, 10 months ago

    Hi Oscar,

    Yes, that’s what i’ve did (please see my previous post).

    This looks like it’s right, but it isn’t. The tax calculation is wrong.

    Should be: 369 :100 x19 = 70,11
    Is now: 58,92
    I’m missing 3% Tax!!

    The amount of tax is listed on the invoices, so it’s important this is calculated correctly.

    Regards,

    Roland

    Plugin Author Oscar Gare

    (@oscargare)

    9 years, 10 months ago

    Hi Ronald,
    Read my last post. 58.92 tax amount is OK
    Should be: : 369 :100 x19 310.0840336134454 x 0.19 = 70,11 58,91596638655463

    • This reply was modified 9 years, 10 months ago by Oscar Gare.
Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Wrong price with different tax-rate’ is closed to new replies.

Tags