Settings and activity
2 results found
-
108 votes
An error occurred while saving the comment An error occurred while saving the comment 
Michael Hood
commented
I was asked to do a Trustpilot review where I mentioned the 4dp issue - just search for Xero on trustpilot - my review's on 10 June - they then responded which only made it worse!
An error occurred while saving the comment Michael Hood
commented
The oldest comment on this thread is April 20, 2022
Just in case anyone has only come upon this issue since then, that was the first comment after Xero redesigned this part of their "support" website when previous threads were deleted.
I first came across this issue (and the old thread) in mid-2021 and it wasn't anywhere near new then.
An error occurred while saving the comment Michael Hood
commented
Xero is great in a lot of respects - but issues like this, and even more so the lack of response, is what would prevent me from recommending Xero to others.
I would have thought this should be a trivial issue to fix. If you upload invoices from CSV, you can use more than 4 decimal places and the invoice will be calculated correctly taking all those decimal places into account - so the calculation itself is not the problem. You can print it, send it, allocate payments to it...
But, if you do anything to alter that invoice, even if it's just something like changing the print template, the invoice will be re-calculated but only using 4 decimal places and if the amounts are large enough, this will produce a VAT discrepancy which is a bit of a nightmare to correct (if you can be bothered).
If this is actually a difficult issue to fix, then why aren't Xero communicating with us to explain why, so that we at least understand.
Not good enough!
An error occurred while saving the comment Michael Hood
commented
This has been an issue for many years - Xero have never shown any intention of implementing an increase beyond the current 4dp.
If you upload an invoice CSV file with 5dp on the unit price, then the invoice will correctly calculate amounts - BUT if you do any kind of change to that invoice (e.g. merely change the print template), then it will re-calculate but only with 4dp on the unit price. With large enough amounts this will lead to the VAT being incorrect.
One workaround (fiddly) is to change units (e.g. £/mWh rather than £/kWh) but then your quantity may require more than 4dp and so you'd be back at the start.
Michael Hood
supported this idea
·
-
26 votesMichael Hood
supported this idea
·
As an "addition" to Wee Lee Chen's comment - in a similar way you sometimes get interesting results when crediting a whole invoice - the amounts don't always exactly match the invoice! so a unit price (in the invoice) of for example 0.8657 may end up in the "matching" credit note as 0.8656
I suspect that in an invoice the calculations are done "forwards"; i.e. quantity x unit price = net amount + VAT = gross amount with rounding done along the way.
Whereas in the associated credit note I think it starts from the gross amount and calculates "backwards" which with roundings can produce a slightly different unit price.