Tax rounding errors on Orders email

  • I’ve an issue with the latest Woocommerce since upgrading (or coincidence?) – I’ve products selling at ￡9.99 Inc tax, but *sometimes* the email Order confirmation shows as ￡10.00. Two separate orders can be shown differently for the same product, so not sure where to start. The transaction itself is fine.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support RK a11n

    (@riaanknoetze)

    Are you seeing any patterns between these orders? Are they ordering the same products? Using the same payment gateway? Are you still experiencing the same issue after deactivating all of your plugins (except WooCommerce) and switching to the default Twenty Sixteen theme?

    Thread Starter stevebower

    (@stevebower)

    It seems to be any product at that price, but not all orders – I had one of each this morning.
    The problem seems to be that make it work, the maths has to be WRONG.
    ￡9.99 price gives ￡8.325 product, ￡1.665 VAT (@20%). So, to get your ￡9.99, the product has to be rounded down, & the VAT rounded up, or vice versa. Either way, the inconsistent treatment of the third decimal place is bad maths, unless the second decimal place is taken into account, so it starts getting complicated.

    It started happening April 4th – was that the update?

    Plugin Contributor Mike Jolley

    (@mikejolley)

    If prices exclude VAT, yes but thats maths ?? 9.99 with tax can only be calculated with a cost of 8.325.

    Are you defining prices inc or ex tax?

    Thread Starter stevebower

    (@stevebower)

    Product prices were loaded as VAT inclusive to give the x.99 price point. Is there any reason for differences in calculations, or should we try ex-vat for the product Admin? (we’d still like to display inc VAT as it’s retail)

    Plugin Contributor Mike Jolley

    (@mikejolley)

    Inclusive is correct and how I would do it.

    Any differences at all between orders? Plugins which would affect it? I’ve not seen this issue – I run with the same setup usually as I’m UK based.

    Thread Starter stevebower

    (@stevebower)

    It’s still being erratic – 2 days, 2 orders, one at ￡9.99 on email, one at ￡10. Very strange.

    Plugin Contributor Mike Jolley

    (@mikejolley)

    Compare them; coupons used? Different shipping?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Tax rounding errors on Orders email’ is closed to new replies.