Taxe report & DB are not reflecting to what is charged on order page

  • Resolved lenamtl

    (@lenamtl)


    3 years, 1 month ago

    Taxes report and DB data is not ok compare to order page
    I’m refering to this page page=wc-admin&path=%2Fanalytics%2Ftaxes

    The store owner need to generate a report for taxes.
    In Canada / QC we have 2 taxes

    The report from this page is different from order page or from DB

    Report data:
    TVQ 174,23
    TPS 87,33

    DB data (this is corresponding to the DB)
    from wc_order_tax_lookup
    TVQ 174,226346
    TPS 87,3315

    Real Data from order page (this is different from report and DB)
    Real amount charged to customer (this has been check 4 times to make sure there is no error)
    TVQ 174,25
    TPS 87,44

    So what can I do to get a report based on what was really charged to the customers.
    I cannot do manual copy paste from each order page this is not making sense.

    Any help is welcome, I don’t mind to make a PHP script and get data from DB manually I need a fix asap.

    *Note the way it calculate the taxes on order page is good I made a few spot check.

    • This topic was modified 3 years, 1 month ago by lenamtl.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi @lenamtl,

    This is about how taxes are rounded and there was a long discussion here: https://github.com/woocommerce/woocommerce/issues/14458 and also https://github.com/woocommerce/woocommerce/pull/14475.

    There is a clarification on how WooCommerce does its tax calculations here: https://github.com/woocommerce/woocommerce/wiki/How-Taxes-Work-in-WooCommerce

    Thanks.

    Thread Starter lenamtl

    (@lenamtl)

    Hi,

    The problem is not really or not only the rounding (I saw all the issues)
    The problem is that the report is not consistent and display different taxes amount.

    As I mentionnd the taxes applied to the order seems ok.

    At the end of the month the report won’t display accurate values taxes should be consistent everywhere otherwise this is not making sense.

    Same problem on revenu analytic report there is only one column for the taxes which is the total of taxes this is not making sense.

    To my opinion each order amount should be saved in order table including all different taxes the same amount that was charged (already rounded) so this way when doing a report we will get the exact same amount.

    I just don’t understand how to make precise report and this is a very big problem as we cannot copy paste order data to make everything balance at the end of the month.

    • This reply was modified 3 years, 1 month ago by lenamtl.
    Mirko P.

    (@rainfallnixfig)

    Hey @lenamtl,

    Thanks for getting back.

    If you believe there is something wrong with the reports other than the rounding as already explained, you may bring this to the attention of the core developers and check their feedback: in that case, you can open a new Github issue here: https://github.com/woocommerce/woocommerce/issues

    Thanks.

    Thread Starter lenamtl

    (@lenamtl)

    Yes I already done that.

    This is a real problem because doing query to the DB does not reflect what is charged to customer…

    So in fact the report display the value from DB correctly
    But this is not what was charged to the customer.
    So we should have extra column that saved exacts taxes amount charged per taxe this way at least this will balance…

    Mirko P.

    (@rainfallnixfig)

    Hi again,

    Yes I already done that.

    Thanks for that. Developers will provide feedback directly on the Github issue you opened here: https://github.com/woocommerce/woocommerce-admin/issues/7828. Feel free to start a new topic on this forum if you have any other questions.

    Thanks.

    • This reply was modified 3 years, 1 month ago by Mirko P..
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Taxe report & DB are not reflecting to what is charged on order page’ is closed to new replies.