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
-
Robert Illingworth
commented
Many items on our inventory require six decimal places as does our electricity bill.
-
Allen Bronton
commented
Maybe the Xero team wants to chime in on this issue for once?
-
Allen Bronton
commented
It is only my distain of the bloatware of QB that we remain. Xero adds these little niceties but never fixes the main issue. To me this is like adding more boat bumpers on a boat with a leak that keeps the bilge pump running. Eventually the pump will give up and the boat will sink. Do you think management will fix it in time? Not me, this has been a problem for much longer than I have used this **** app.
-
Tino van Nieuwburg
commented
EDI Invoices supplied to Coles, Woolworths and Aldi need to match and align to the cent with the PO of the supermarket, otherwise they are rejected.
-
Dianne Howell
commented
Chicken Transport business where delivery of 'eggs' are valued at $0.00196 ea (five decimal places) I can not use XERO but have to use Qk Books invoicing and then import then over as a record only (Invoices are sent via Qk Books) The client is paying for two subscriptions !! XERO & Qk Books
-
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!