Fix request: Detailed Excel export omits tax corrections, causing incorrect net revenue and VAT totals
Hello Mews team,
Following your support team's investigation, we are requesting a correction to the Detailed Excel export of the Order items report.
Confirmed issue
Support confirmed that zero-gross tax-correction entries are included in Mews Operations but excluded from the Excel export. Although each entry has a gross amount of €0.00, it contains non-zero net revenue and VAT components that must be included for accurate reporting.
As a result, the exported net revenue and VAT totals do not match the PMS or the underlying closed bills, even though gross totals remain unchanged.
Support also verified the accounting configuration and confirmed that the PMS totals and underlying bill records are correct.
Business impact
We rely on Excel exports for accounting reconciliation. Omitting these entries produces incomplete net revenue and VAT figures and requires manual reconciliation against the on-screen report.
Requested correction
Please include all tax-correction entries in the Detailed Excel export, including those with a zero gross amount but non-zero net and VAT components. Exported totals should match Mews Operations when using identical report settings and filters.
Given that this is a confirmed omission affecting financial reporting accuracy, we ask that it be handled as a reporting defect rather than solely as a product enhancement request. Highlighting the discrepancy would not resolve the underlying inconsistency.
Please confirm whether this can be escalated to the engineering team, along with an estimated resolution timeline and any interim workaround that provides a complete, reconcilable Excel export.
Thank you.