Invoices - Increase Unit Price field to six decimal places
Ability to increase unit price field to six decimal places.
Purpose: To make users easier when they have to input unit price with lots of decimal numbers
-
Ryo Kimura commented
I completely agree. I think most users need take so much time and stress to overcome this annoying issue
-
SIMON FRYER commented
I do not understand how Xero can keep ignoring this problem !!!!
-
Janne Butcher commented
We purchase Aviation Jet fuel by the litre, we are charged up to 6 decimal places. When that is out due to the limit enforced by xero that can add up to quite a number when we are dealing with millions of litres purchased.
-
Darran Strauss commented
I cant keep making manual adjustments to invoices so they line up with Recipient Created Tax Invoices.
Its so annoying!
Allow 6 decimals please please please ASAP! -
Michael Hood commented
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.
-
Wee Lee Chen commented
Lately, we have found that Xero's internal rounding mechanism creates problems for us when the units are not whole numbers. I have an invoice, where the pricing remains the same, but because we are billing for time, the system arbitrarily rounds up or down or sometimes not at all. (one item is correctly billed as $193.99, another is rounded up to $194.00 and yet another that confounds me is spread to four decimals $193.9933! and this is the system mucking around with my unit pricing - it is simply $193.99 in the system).
Ability to set our own number of decimals and fix the final number would help. I reached out to helpdesk and they are asking me to manually change the invoices in .pdf or .docx format. If it were for one invoice, yeah sure. But when you have a few hundred of them to deal with, no. And its been three days and still no solution or time frame for resolving this issue. Might have to bite the bullet and change software to one that causes less grief.
-
Telecia Lang commented
This is a must! A lot of suppliers, especially with energy bills, water bills etc they use more than just 4 decimal places.
We use suppliers with stickers and they go to 4 decimal places, when trying to push invoices across from an integrated service we have to alter every invoice.
Hoping for a positive outcome on this one! -
Charles Bradshaw-Smith commented
I have also now done a Trust Pilot review in response to their response to Michael Hood's on 10 June (see 4 July below). Let's see what they say to this...
-
SIMON FRYER commented
no interest from Xero on something that should be an easy fix !
-
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!
-
Joanna Johnson commented
I was just directed to this link by the support team....haha - obviously crickets on the extra decimal places..5 years this link has been active and nothing..
-
Allen Bronton commented
Yeah, I'm tired of waiting. I'm pretty sure it's been at least 5 years since I put in this request and I certainly wasn't the first.
Has anybody else done any research for an alternative?
-
Amanda Williams commented
Pointless commenting by the look of it; no responses from Xero?
-
Jayathu Deshapriya commented
Hello Xero, any news on this?
-
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.
-
Sarah Broughton commented
Could xero team update us all on this - its been a few years now...
-
Sylvie Moawad commented
Hi, any update on when this can be fixed?
I would think it's very basic and should have been programmed from the start.
It's the difficulty in getting responses (and then the slowness of the solution) that's pushing me look for an alternative to Xero. -
Charles Bradshaw-Smith commented
This really is ridiculous. A simple and necessary change that is stopping me scale up my Xero based service offering. I will have to look to integrate with another accounts package without this change. How do we escalate this ned?
-
Allen Bronton commented
I've seen this for years. I wonder if they even know this website still exists.
-
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!