Enter your idea

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. :(

It is good to fix the decimal points of the unit price to 6 digits.

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.

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.

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?

Quantity section of the invoice, there are 4 decimal places. Increase the decimals to 6 decimal places

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

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.

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.

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.

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.

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.

Really hoping that this becomes a possibility as when dealing with large numbers, a few extra decimal places makes a huge difference in the accuracy of the billing!

Curious to know why it would be so hard to provide that option?

I have also raised a support case CX0013184989 for this and it has been passed to a specialist for further assistance.

Fingers crossed.

I strongly support this idea to stay within UK law!

I am importing energy invoices from a specialist app into Xero via a CSV file. I need UnitAmount to use 5dp. I wish I could reduce my UnitAmount to 4dp but I cannot legally. Energy in UK use tariffs that are quoted in pence per kWh to 3 decimal places. So in pounds (£) 5dp are required by the time the UnitAmount has been divided by 100. I do not want to be outside government regulations. If after import, I edit the draft invoice line and add back the 5th dp to UnitAmount, it correctly calculates the Total - so it can't be a big change to make please.

This is very frustrating, I sell screws, when I create a part and price it at 0.124 (£12.40/100) the quote/order/invoice comes out at £0.12 (£12.00/100) this can be a considerable loss in some cases, we now have to manually put the price in to 3 decimal points !!!

I also support this idea. It would be great to increase the decimals more than 4 decimal places by automatically.

There are many different scenarios where a unit price that is limited to four decimal places is too restrictive for bills and invoices.

For example, unit prices that have been converted from a foreign currency, share dividends and many others.

Why not make it unlimited?

This is somethng that is needed sooner reather than later, as we use a seperate CRM package that deals with products to 4 decimal places and when syncing the invoices across into Xero they come in with 2 decimal places and it causes grief to us and our clients

I support this idea. It would be great to increase the decimals up to 6 decimal places.