I recently discovered that Xero is displaying incorrect values for three key ratios in the Executive Summary report. The incorrect ratios are:
- Gross profit margin
- Net profit margin
- Average debtors days
These ratios are incorrect in the Executive Summary report within Xero and are also incorrect in exported PDFs.
Here is the Executive Summary report displayed in Xero:
Here is the same report in Excel with the correct values:
The issue does not appear to be affecting all Xero accounts. To be safe, I recommend that all Xero advisors double-check the ratios in the Executive Summary report by exporting to Excel first before publishing PDF reports. You can also turn off the ratios entirely by opening the "Show" drop down list and selecting "Summary only".
I've reported this issue to Xero support and I've been told that the Product Team is aware of the issue and is working on a fix. However, the solution involves rewriting the reports framework and will not be complete until "the middle of this year".
If you are also experiencing problems with the Executive Summary report, please let me know via the comments below. I'm interested to know if this is an isolated bug or if it is a more common issue.