Rounding issue with Woocommerce tax reports

Hi there!

I understand your concern. To assist you better, could you please provide more information on the exact total tax amount appearing in the tax report instead of the 699.66 €? Additionally, could you please share a screenshot of the tax report so that we can further investigate?

Also, could you clarify whether you are adding prices inclusive of tax or exclusive of tax? Please go to WooCommerce → Settings → Tax → Tax Options, and check which option is selected for “Prices entered with tax”:

1. Yes, I will enter prices inclusive of tax
2. No, I will enter prices exclusive of tax

The more information we have, the more accurately we can assist you. In the meantime, you can read this on how WooCommerce calculates tax:
https://github.com/woocommerce/woocommerce/wiki/How-Taxes-Work-in-WooCommerce

Thank you

Its appearing as 699.76 € in the tax reports. The difference is 0,10 €.

Image – https://ibb.co/cFBYgGN

Tax report – https://ibb.co/wdbdQtw

All the prices are inclusive of tax except the shipping where tax is added to the shipping cost.

The difference is a bit strange. Numbers are same everywhere but the calculations does not match.

Hello GoGoNano,

Thank you for your reply.

To better understand the calculations, could you share the following screenshots?
1- Total Sales from WooCommerce Analytics.
2- Tax options page.
3- 22% Tax configuration from Tax Settings.

You have mentioned the term “Total net sale”. Please note that Total Sales and Net Sales are different terms. For clarification, I suggest you read this guide.

Once I have more information, I will be in a better position to assist you further.

Best regards.

Thank you for getting back so quickly, appreciate it.

1. Total Sales – https://ibb.co/BPSTVP2

Here comes another issue. Both total sales and net sales amount, including the tax amount here is wrong. Analytics have counted order made 31.11 as 1.12 order. So theres one extra order that should not be included into December analytics.
Can be seen here – https://ibb.co/j6mbHQs
Whenever I click to check the orders, theres 6 of them, not 7. So 55.04 € should be excluded from Total Sales from those reports. That’s the reason I used Woocommerce reports instead of Analytics info.

2. Tax options page – https://ibb.co/Y8ZVLTS

3. Tax rate configuration – https://ibb.co/Ss9tF5z

Hope this information helps out. If any additional details are needed, please let me know.

Hi @digitaltrade,

Thank you for sharing the screenshot! Based on what you’ve shared, I can confirm that the “Round tax at subtotal level, instead of rounding per line” option is currently unticked. This means that WooCommerce is calculating and rounding taxes on a per-line basis, which is likely causing the minor discrepancy you’re seeing in your tax reports. Why This Happens:

When taxes are calculated per line:

• WooCommerce calculates the tax for each line item individually.
• Each tax amount is rounded to two decimal places before being added to the total tax.
  This can result in small differences (like €0.01 or €0.10) compared to calculating and rounding taxes at the subtotal level.

Example Scenario:

Let’s say you have two line items:

• Item 1: €50.35 x 22% = €11.077 → Rounded to €11.08
• Item 2: €120.75 x 22% = €26.565 → Rounded to €26.57
• Total Tax (Per Line): €11.08 + €26.57 = €37.65

If you were to calculate tax at the subtotal level:

• Subtotal: (€50.35 + €120.75) = €171.10
• Tax: €171.10 x 22% = €37.642 → Rounded to €37.64

The difference arises because rounding is applied at different stages, and this adds up across multiple line items. How to Resolve This:

If you’d prefer to avoid these small discrepancies, you can enable the “Round tax at subtotal level, instead of rounding per line” option. This will calculate the tax for the entire order subtotal first, round it once, and then apply it, ensuring consistent totals.

To enable this:

1. Go to WooCommerce → Settings → Tax.
2. Check the box for “Round tax at subtotal level, instead of rounding per line”.
3. Save changes.

Keep in mind that this will change how taxes are displayed and calculated moving forward, and it may affect existing reports slightly.

Let me know if you have any further questions or need additional help!