Bug found
Dear Xero,
I have found in the 'Payable invoice Detail' (and I believe it would occur in all applicable reports) that the 'Unit Price inc. GST' is rounded off to 2d.p. and is used to calculate the Invoice 'Gross' amount.
This means that analysing data using the 'Unit Price ex. GST' gives incorrect results.
Hence, if it is possible, please show allow Xero to calculate the 'Unit Price Inc. GST' amount up to 4 or even 6 d.p. so significant differences are not shown when volumes are high eg. >100.
I understand this might be unneccessary for display purposes in some instances, however, it would be helpful for these calculated numbers to be more-accurate than 2d.p. in Xero Reports.
Thanks for your consideration.
Hi Callum, thanks for sharing your feedback with us. We appreciate you highlighting this calculation behaviour in your Payable Invoice Detail report.
If you believe this might be a bug or unexpected behaviour, we recommend raising a case with our support team. They’ll be able to investigate the rounding you’ve described and work with you to determine if there’s an underlying issue and the best next steps for your organisation.