VAT Rounding Issues

This topic contains 3 replies, has 2 voices, and was last updated by  Peter Lloyd 18 hours, 40 minutes ago.

  • Author
    Posts
  • #1629

    anthony-fortec
    Participant

    We have just started to notice that we have a bit of an issue with VAT rounding problems on some orders. For example as follows:

    A customer has ordered 22x items at £1.35 each (inc VAT) – totalling £29.70.
    Ex VAT the product price is £1.125

    When Xeroom is posting the transactions to Xero, it is posting them as £1.13 each (ex VAT), totalling £24.86 (ex VAT) and £29.81 inc VAT.

    Is there any way Xeroom can post to Xero using ‘Tax Inclusive’ amounts, or ‘Tax Exclusive’ but use decimal places? We have gone onto Xero and manually corrected the invoice using tax inclusive amounts (i.e. posting 22x items at £1.35 each) which has corrected the invoice to £29.70.

  • #1630

    Peter Lloyd
    Keymaster

    Hi Anthony

    There is a rounding issue that we are aware of that arises and shows in the totals between the way Xero calculates and Woo calculates. We do use 2 decimal places in the posting. We have increased this to 4 in the new version 2.0.5 and also added a rounding ac so that any remaining differences in the totals no matter how samll can be posted to that. We have tested it with 25 items costing £0.0621 each which is similar to your test.

    Please wait for this to be released which should be in the next week or so.

    Pete

  • #1654

    anthony-fortec
    Participant

    Hi Pete, just wondering if you have any news on when to expect the new version? Thanks, Anthony

  • #1656

    Peter Lloyd
    Keymaster

    Hi Anthony – we hit some issues during stress testing which took a while to fix. I hope to release the final version at the end of this week.

    Thanks
    Pete

You must be logged in to reply to this topic.