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

-
Sharon Lyon commented
Your about the only software company that doesn't have that flexibility, its VERY basic request.
-
Leanne Sheehan commented
We sell units in excess of 100,000 (and we expect the volume to increase) at a unit price of .06525. The inability to cope with these decimal places means each invoice will have rounding errors. This will be significant over the course of the financial year.
-
Albert Goodman commented
I have a client that requires up to 8 decimal places - so any increase on 4 would be great :)
-
Mark Beever commented
Our printing company sends us monthly invoices with Ink usage into the 5th decimal place.
Every purchase order i have made for them is wrong as it rounds upwards for the unit count but its all i can do in order to be able to pay them. -
Mohammed Shaaz Salam commented
One of our Vendor invoices us with 6 decimal places which results in books no tallying. need 6 decimal places on invoices as well as bills
-
Wan Adham Ismail Wan Ahmad commented
One of our vendors quoted in Five decimal places which result to not tally between our Purchase Orders and vendor's invoice. Four decimal places is not enough.
-
Shahna Nixon commented
This is vital for both invoices and purchases for us, as we use units in 000's. So a price of $32.46 per thousand needs to be entered as a unit cost of 0.03246 Four decimal places is just not enough
-
Deliana Jooste commented
our client work with Trust money and get audited on yearly basis, money received from client should balance to the cent.
-
Vanessa Dionisio commented
It seems that this problem has been raised so many times and this thread has been going on for years. When will Xero ever address it? I never had this problem before because we usually deal with 2 dp only. However, I have now signed up a manufacturing client and they use 6 dp for raw materials. I am unable to help them nor justify why Xero only uses 4 dp. :(
-
Hazel Chia commented
It is good to fix the decimal points of the unit price to 6 digits.
-
Ha Nguyen commented
We also need this function, the unit price limits at 4 decimal numbers create the difference between the total value in Xero and the actual value of the PO or invoice.
-
Roslyn Zillman commented
Time and time again when entering supplier quantities and want to use the unit price it only has 4 decimal places. Is there any way to increase this to more than 4 so I don't have to add a useless line just for rounding to match the supplier invoice. This happens in particular with Fuel invoices and also entering Levies for Commodity payments. It would be great to have something in settings if some businesses don't want so many but kind of frustrating and time consuming so would be appreciated if Xero can change this. I've put up with it for years but today felt the need to finally say something. Seems crazy the maths isn't balancing. Fingers crossed this is a simple fix and can happen soon.
-
Allen Bronton commented
Doing a simple search for "decimal" on this site shows there are several ideas that are all requesting the same or very similar functionality. Perhaps an admin can consolidate these to show the true number of those voting for this?
-
Aamir Khan commented
Quantity section of the invoice, there are 4 decimal places. Increase the decimals to 6 decimal places
-
Tim Cockfield commented
Been said before but I'll say it again... when dealing with anything other than small numbers, 2 decimal places is a problem. Our solution at the moment is to enter a unit of one and manually calculate the price of all the units combined, but information is lost doing this because we can't readily see the number of units from the GL
-
Allen Bronton commented
I'm afraid you may be right. About 5 years ago I tried Xero and had this issue but there was no response so I changed to Microsoft Dynamics Business Central. BC is an outstanding system but for too complex for my needs. I returned to Xero because I forgot about this problem. Now, with great frustration I am trying to be patient and see if this gets solved or I'll have to find an alternative. I know QBO goes out to 5 or 6 dp but not a big fan of Intuit.
-
Charles Bradshaw-Smith commented
Hello Xero,
Are you reading this thread at all or are we wasting our time leaving constructive comments to help improve your product?
Pretty please respond.
-
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.
-
Allen Bronton commented
Many businesses like mine in the U.S. cannot use Xero because of this restriction. We price in basis points 1/100th of a percent which goes to 4 decimal places but then we bill quarterly so dividing by 4 causing the price to go to 6 decimal places. Currently, we have to manually calculate the total or migrate away to QBO if we want to automate the process.
-
Jon Marks commented
Please implement for sales, bills/purchase orders and product, inventory items.
When I want to process my production and reduce the quantity of the raw materials consumed in the production of a finished goods, the purchase unit price is to 7 decimal places as the items are stocked in g and purchased in kg. Rounding causes differences. I would also need the name decimal places for making product, inventory item adjustments when reducing the qty of each product and increasing the qty of the finished product that was produced. Currently this cost price is only 2 decimal places.