Xeroom – Full Xero Accounts Integration with WooCommerce › Forums › Xeroom Support Forum › VAT Rounding Issues
- November 23, 2018 at 9:30 am #1629
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.
- November 23, 2018 at 2:57 pm #1630
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.
- December 11, 2018 at 6:24 pm #1654
Hi Pete, just wondering if you have any news on when to expect the new version? Thanks, Anthony
- December 12, 2018 at 2:58 pm #1656
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.
You must be logged in to reply to this topic.