Inaccurate tax calculation

  • Resolved jltrctt

    (@jltrctt)


    1 year, 9 months ago

    I use GST and QST as taxes for Quebec sales in my online store and I notice that sometimes the calculated amount is not correct.

    This causes an import problem when I synchronize my sales with my accounting system.

    I have to manually adjust the amount to complete the synchronization. This is very time consuming.

    As you can see in the example above TVQ (QST) which is 9,975%, the amount calculated should be 62,34$ but WooCommerce put 62,35$ (0,09975*625=62,34$).

    Any way we can get that fixed?

Viewing 1 replies (of 1 total)

  • Hi there @jltrctt

    Thank you for reaching out about this! As I understand, the tax rates are rounded in a way that is not ideal.

    The actual tax calculation for WooCommerce does not round each line tax, WooCommerce does instead calculate tax for the invoice line as a whole.

    There has been some discussion already about the 0,01 price difference and you can have a look at this Github thread:

    https://github.com/woocommerce/woocommerce/issues/14458

    If you increase the number of decimals to?4?you should see that the calculated tax is 62,34$, instead of 62,35$ that is currently displayed. This may work for you.

    However, to avoid these types of rounding issues, you can use?tax-exclusive prices. Calculations are more straightforward when prices are exclusive of tax. Linked here is the related documentation.

    I trust that points you in the right direction, but if you have more questions, let us know. We’re happy to help.

Viewing 1 replies (of 1 total)
  • The topic ‘Inaccurate tax calculation’ is closed to new replies.