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
-
Chris Tay
commented
In the field of commodity semiconductor and components, some parts are priced and sold at 0.00x, so the 6 decimal places are needed when we calculate our margins.
-
Kathleen Robinson
commented
Milk prices, especially for processors whose pricing includes variables for constituents, are always calculated in pence - and fractions of a penny. Rounding gives an innacurate figure.
-
Cliona Redington
commented
I vote for this idea, it is a small addition but will benefit users greatly.
-
Robert Illingworth
commented
What's even worse is if you import an invoice using a CSV file from Excel, if any of the formulas in the spreadsheet return a number with more than four decimal places, it causes the invoice to lock up and be no longer usable!
-
Janne Butcher
commented
So, I thought I had a work around. We currently import our invoices, and these have been generated with the unit at 6 decimal places. Then I created an advanced invoice template and changed the unit amount to show to 6 decimal places instead of 4. However, when I tested it, guess what happened ..... nothing. Except now the invoice has 2 extra 0's in the unit rate!!! C'mon XERO do better.
-
Derek Harland
commented
Hard to believe this is still a problem **10 years later** ... prices (and quantities) should be able to be specified in finer grain than just 4dp.
-
Rob Gregoire
commented
Critical for us due to Inventory Management software integration
-
Michael Burlingame
commented
As a stakeholder operating at the intersection of high-volume data processing and financial compliance in the telecommunications space, I would like to formally request an enhancement to Xero’s decimal precision capabilities—specifically, increasing support from 4 to at least 6 decimal places for monetary and quantity fields.
Carrier agreements and roaming partnerships frequently mandate 6-decimal billing precision per ITU and GSMA frameworks (e.g., TAP, NRTRDE). Furthermore, compliance with IFRS 15, SOX, and regional telecom regulators often necessitates fully auditable, high-fidelity financial records that match partner-side expectations down to the decimal.
Failure to reconcile these differences due to system-imposed rounding limitations often results in:
• Billing disputes and payment delays
• Manual reconciliation overhead
• Exposure to compliance riskIn today’s data-intensive and compliance-driven economy, precision is not optional—it is fundamental. We believe this enhancement will further establish Xero as a platform that scales with the sophistication of global finance operations, including those in technically demanding verticals like telecommunications.
-
Kate Morris
commented
We cannot properly record our fuel purchases since the price per litre is 6 decimals ex: $1.049397. There is always rounding issues when Xero rounds the price to 4 decimals ex: $1.0493
-
Roland Atherton
commented
Phone Application allows you to enter unit prices at multiple decimal points, so that the total matches, but once you press “save” it rounds the decimal points to 2 and recalculates the total, leaving you with a transaction that won’t reconcile until you login on a computer and edit the unit prices again.
-
Robert Goynes
commented
It should be as easy as changing the format to F4.6
-
Didi Stiawan
commented
Xero
Please take serious for this issues. As company that uses Rupiah as base company transactions and with multiple currency, we need this very urgent. Rupiah is not strong currency, we need more than 6 decimals
-
Robert Illingworth
commented
This issue arises on both bills to pay and sales invoices. The workaround I use is to increase the number of items by a factor of ten (or a hundred in some cases) and then the unit price can be increased by the same factor. It works to produce an accurate total amount but it's not very satisfactory.
-
Charles Bradshaw-Smith
commented
Now Xero has implemented the new invoicing capability, surely it's time to get its maths right for us customers in industries that use 6 decimal places. Perhaps this is why competitor accounting packages are doing so well with their growth?
-
Janne Butcher
commented
We purchase fuel at 6 decimal places - this is causing loads of rounding and write offs!
-
Marianne Nair
commented
This is really important as a manufacturer to get the pricing correct. Having more decimal places means more accurate figures.
-
John Ian Mejia
commented
Bumping this. Having this not available in an accounting system is very ironic and a complete oversight... Ive seen posts regarding this issue for the past years. and the feature still haven't been updated. Having to adjust discrepancies when you're dealing with thousands in quantities for products.
please add this.
-
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.