• Resolved Gr1f

    (@gr1f)


    Hi,

    I am seeing an issue where the tax calculated seems to be incorrect when user is shipping to anywhere with 19% IVA, Germany/Cyprus in my case
    Tax options are as follows:
    Prices entered with tax: yes, I will enter prices inclusive of tax
    Calculate tax based in: Customer Shipping Address
    Shipping Tax Class: Standard
    Rounding: on – Round tax at subtotal level, instead of rounding per line
    Additional Tax Rates: Reduced rate / Zero Rate (but none are specified)
    Display Prices in the shop: Including Tax
    Display prices during cart and checkout: Including Tax
    Price display suffix: incl VAT
    Display tax totals: Itemized

    When I place an order for a €20,00 product these are the values calculated:

    Cost: 16,53€
    Qty × 1
    Total 16,53€
    19% IVA 3,14€
    This would amount to €19,67 where it should amount to €20,00

    If I manually use this formula which I found from a support response on this forum:
    tax_amount = price – ( price / ( ( tax_rate_% / 100 ) + 1 ) )

    It calculates the correct values:
    IVA €3.19.
    The net price before IVA €16.81.
    Total €20,00

    So something is not right.

    So far I have taken the following steps:
    Staging site
    Changed theme to Storefront

    Active Plugins:
    Breeze?by Cloudways – 2.1.9
    Phone Orders for WooCommerce?by AlgolPlus – 3.9.0
    SEUR Oficial?by José Conti – 2.1.1
    WooCommerce Stripe Gateway?by WooCommerce – 8.4.0
    WooCommerce?by Automattic – 9.0.2

    WooCommerce version:9.0.2
    WooCommerce Legacy REST API package:?The Legacy REST API plugin is not installed on this site.
    WordPress version: 6.5.5
    WordPress memory limit: 512 MB


    Any help is apreciated

    The page I need help with: [log in to see the link]

Viewing 12 replies - 1 through 12 (of 12 total)
  • Hi,

    I think there is a general calculation problem since 9.1.

    We had a 494,89€ of Shipping costs and a 91,96€ Tax when the settings are 4.06 € shipping and 21% tax.

    I reverted to previous version (8.9.3) and everything is fine now. I would suggest to do so till they solve it with a new revision.

    Hey there, @gr1f! Thanks for contacting us. I’m happy to help you.

    I tried to replicate this issue on my website by using the settings you shared, but I got the correct calculation.

    Can you please share screenshots of how you have this set up so we can take a look?

    I recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.

    We need screenshots of:

    • WooCommerce > Settings > general
    • WooCommerce > Settings > Taxes
    • WooCommerce > Settings > Taxes > Standard Rates
    • If you have reduced rates and zero rates, please also share those
    • Checkout page showing the taxes on your end

    Do you have any plugins or custom code that affect taxes or product prices in general?

    Looking forward to your reply.

    Have a wonderful day!

    Hey, @taisa1984!

    We had a 494,89€ of Shipping costs and a 91,96€ Tax when the settings are 4.06 € shipping and 21% tax.

    I reverted to previous version (8.9.3) and everything is fine now. I would suggest to do so till they solve it with a new revision.

    While we are aware of an issue with the shipping on 9.0 and 9.0.1 (which was rolled back on 9.0.2), we are not aware of it impacting taxes.

    Per WordPress forum guidelines, would you mind opening up a new thread for this so that we can keep things organized and offer more personalized support for you? We’ll be happy to help you out with this over there!

    Have a wonderful day!

    Thread Starter Gr1f

    (@gr1f)

    Hi, Sure.

    There are no reduced or zero rates

    All plugins bar what I’ve listed above are inactive. There are no added functions.

    Here are the screenshots

    • This reply was modified 8 months, 1 week ago by Gr1f.

    Hey, @gr1f!

    Thank you for the screenshots and information.

    To confirm is the issue happening only with Germany/Cyprus? Or does it happen with other places too?

    On the taxes screenshot I see you have set up the taxes for several countries, but then you have an universal taxes set to priority 1, which can cause conflicts.

    I believe the universal taxes (*) is there so all other countries not specified have 21% taxes, correct? If so, please set it as a lower priority and check if the issue persists.

    You can find more about this in this guide.

    Please let us know how it goes ??

    Looking forward to your reply.

    Have a wonderful day!

    Thread Starter Gr1f

    (@gr1f)

    Hi, thanks for your reply.

    I set the “*” tax rate to priority 2 but now it’s taxing the products twice:

    ProductSubtotalDiscovery Kit??×?1 23,14€

    Subtotal 23,14€

    Shipping SEURCLASSIC:?<bdi>7,70€</bdi>

    Total <bdi>30,84€</bdi><small>(includes?4,19€?19% IVA,?4,63€?21% IVA)</small>

    Plugin Support omarfpg a11n

    (@omarfpg)

    Hi @gr1f, as per our documentation:

    Priority?– assign a priority to the tax rate. Only the 1st rate that matches per priority will be used. Specify a different priority per rate to define multiple tax rates for a single area. 1 is the highest priority, and will be considered before 2, which will be considered before 3, etc.?Here’s a detailed practical example.

    If you have two different priorities, then it’ll pick up both. Kindly set the priority the same for all, as you had them before.

    Regarding the 19% tax, let’s continue focusing on the root issue for it. Can you tell if this calculation issue is only for this one? It’s really odd. Have you tried with other country codes and it does the calculations as expected? Have you changed other country codes to 19% to test, or the Germany code to other than 19% to test?

    Kindly let us know.

    Thanks!

    Thread Starter Gr1f

    (@gr1f)

    Other issues are arising.
    If I add products to the basket and go to checkout, then I change location to say Germany or Cyprus the totals are changing. The totals should remain the same as they are totals Inc VAT. I didn’t notice this before I reported the above but it might give us a clue…

    I think I’m going to have to roll back to 8.9.3

    • This reply was modified 8 months, 1 week ago by Gr1f.
    Thread Starter Gr1f

    (@gr1f)

    Here’s are screen shots of what I mean.

    Spain, all OK €20.00 incas expected
    Germany with 19% VAT has changed the Price to 19.67. Not as expected it should remain as €20.00
    Finland with 24% has also changed the Price
    Thread Starter Gr1f

    (@gr1f)

    OK, I think I know what’s going on with the last issue.
    https://www.ads-software.com/support/topic/tax-rates-not-properly-displayed/

    The site originally had Hello Child theme that I disabled as it was causing a Privacy Policy issue on ApplePay via WooCommerce Stripe Plugin where it was asking for Privacy Policy opt-in. Changing to Main Hello theme fixed this but that was missing the functions.php mod:
    add_filter(‘woocommerce_adjust_non_base_location_prices’, ‘__return_false’);

    This is what has been causing the issue. As I inherited the website with no documentation I was not aware of the custom code. I’ll now add the above to functions.php which should at least fix the pricing issues.

    Thanks for your help.

    Thread Starter Gr1f

    (@gr1f)

    The issue is now resolved. Thanks for your help.

    • This reply was modified 8 months, 1 week ago by Gr1f.
    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @gr1f

    I’m glad you were able to find a solution to your inquiry here and thanks for sharing it with the community too! ??

    Should you have further inquiries, kindly create a new topic here.

    Thanks!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Incorrect tax calculation for 19% IVA’ is closed to new replies.