Enter your idea

Xero already calculates the average number of days a business takes to pay each supplier (you can see it on individual contact records under "Bills"). But there's no way to pull this into a single report across all suppliers.

This matters because the UK Government's Fair Payment Code (which replaced the Prompt Payment Code in December 2024) requires businesses to provide evidence of their payment performance from their accounting software when applying for an award.

The Code has three tiers: Gold (95% of invoices paid within 30 days), Silver (95% within 60 days, with 95% to small businesses within 30 days), and Bronze (95% within 60 days).

There are now over 600 awardees and growing. As more UK businesses apply, they need to demonstrate their payment track record with data from their accounting system.

For Xero users, that currently means exporting data and manually calculating it in a spreadsheet, which is time-consuming and clunky given the data already exists within Xero, not to mention that it requires an independent accountant to verify the data.

What we need:
A report (or an addition to the existing Aged Payables reports) that shows:

Each supplier contact name
Average days to pay (from invoice date to payment date)
Number of invoices paid in the period
Percentage of invoices paid within 30 days
Percentage of invoices paid within 60 days
Date range filter so users can select the reporting period

This would give Xero users the evidence they need to apply for the Fair Payment Code, and it would help any business wanting to monitor how quickly they're paying their suppliers as part of good cash flow management.

The data is already in Xero. This is about making it accessible in a report rather than buried in individual contact records.