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

-
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!
-
Hazel Chia commented
so many ideas posted to increase decimal points but there is NO action taken by Xero, now I have to do extra work to maintain a set of manual invoices. POOR SERVICE
-
Susan Squire commented
We have electricity bills that use 5 decimal places every month and in the past payments per litre for milk was to 6 decimal places.
This would stop discrepancies of many £'s having to be entered as rounding errors and annual totals for products sold or paid for being correct. -
Susan Squire commented
We have electricity bills that use 5 decimal places every month and in the past payments per litre for milk was to 6 decimal places.
This would stop discrepancies of many £'s having to be entered as rounding errors and annual totals for products sold or paid for bring correct. -
Naga Krishnan commented
Does Xero have a roadmap for allowing 4+ decimal places?
-
Niagara Consulting commented
Need at lease 5 decimal places for the price.