• Resolved crimsonhack

    (@crimsonhack)


    I recently created an online store with WooCommerce 3.2.6 but I noticed that it does not calculate taxes correctly.

    Here’s an example. In my case I have to apply 21% IVA on all my products, the products in the store already show the price with the tax applied but when I go to the cart is not displayed correctly the amount of tax.

    Product A costs 55 euros including IVA, then the IVA for that product would have to be 11.55 euros, but instead it says that it is 9.55 euros.

    How can I fix this?

Viewing 10 replies - 1 through 10 (of 10 total)
  • Zach W

    (@dynamiczach)

    Automattic Happiness Engineer

    Product A costs 55 euros including IVA, then the IVA for that product would have to be 11.55 euros, but instead it says that it is 9.55 euros.

    Can you send a screenshot of how you have your tax settings setup under “WooCommerce > Settings > Tax”?

    It looks like the system right now is subtracting the 9.55 from the 55 euros total (= 45.45 euros), then trying to apply the 21% IVA to the 43.45 euros price (= 9.5445 or 9.55), which is why you’re seeing the 9.55 euros amount.

    A tax rate is always a proportion of the cost price, not a proportion of the retail price, so:

    45.45 + ( 45.45 x 21% ) = 55.00

    Greetings,

    My cart is showing 0.00 tax while calculating shipping in the cart. Even if you go to checkout it remains 0.00. I have added the CSV file as well. Please help me with this. My product link

    @ameenkhan
    Best to start a new thread as your issue is likely to be different. The form is at the bottom of this page:
    https://wordpress.org/support/plugin/woocommerce/

    Please include screen shots, or links to screen shots, of your General settings, Tax options settings and tax rates table. I expect the issue will be on there somewhere.

    Thread Starter crimsonhack

    (@crimsonhack)

    @dynamiczach

    Here you have the screenshot. https://i.imgur.com/kSUiHxo.png

    It’s in Spanish, I guess it won’t be a problem, although I can translate it into English if you want.

    can you please send me the English one if possible 🙂

    Hi @crimsonhack, like Lorro and Zack already mentioned the calculation is right.

    tax = priceWithTax – ( priceWithTax / 1.21 )

    E.g.:

    55 – ( 55 / 1.21 ) = 9.54

    11,55 would be the tax for a product with a price of 55 excl. tax.

    @crimsonhack
    The tax calculation is correct. Your screenshot is not relevant or necessary. My request for screenshots was for @ameenkhan.

    @ameenkhan
    crimsonhack’s screenshot won’t help your issue. I have responded to your issue in your other thread:
    https://wordpress.org/support/topic/tax-shows-0-00-while-calculating-shipping-or-checkout/

    There should be only one issue per thread!

    Zach W

    (@dynamiczach)

    Automattic Happiness Engineer

    Here you have the screenshot. https://i.imgur.com/kSUiHxo.png

    Thanks @crimsonhack! I wanted to make sure you didn’t have any plugins adding anything to the tax settings before proceeding.

    I didn’t do a great job explaining the issue initially, sorry for that! What you’ll need to do is calculate your product prices without the 21%, and enter that amount for each product’s price, as the system will automatically apply the 21% amount to the customers who match it if it’s setup properly under WooCommerce > Settings > Tax > Standard Rates (tarifas estándar)

    However, your math doesn’t add up. If the products’ IVA needs to be 21%, you can either have the total including IVA be 55 (so the product’s price would have to be set to the 45.45 euros I mentioned in my initial reply – so 9.55 total IVA), or you can have the IVA amount on that product come to 11.55 euros, but then the total product price including the IVA cannot possibly be set at 55 and still have a 11.55 IVA cost, as that would actually increase the IVA amount from 21% to 26.58% (55 – 11.55 = 43.45 | 43.45 X 0.21 (21%) = 9.12 | 43.45 x 0.2658 (26.58%) = 11.55).

    I hope this helps clarify the options!

    Joel Williams

    (@joelwills)

    Automattic Happiness Engineer

    Hi there!

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, please start a new thread.

    Thanks!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘The tax is not calculated correctly’ is closed to new replies.