Skip to content
← For small businesses

Enter your idea

For small businesses: Accounting features

Categories

(thinking…)

Aged Receivables report: Include reporting on 'time-to-pay'

To be able to view at a glance the 'period taken from a customer to pay invoices' from the Due Date to when the funds have reached the supplier's bank account. This is instead of exporting the Xero report in an excel sheet and then adding a formula to calculate the difference between the two dates. Surely with all the information already stored in the Xero account, this option shouldn't be too difficult to add. Thank you.

8 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Monica Rossi shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Jo Russell commented  ·   ·  Report

    Each Contact header shows the average number of days that debtor has made payments in the past. This would be useful information to include on the Aged Receivables report when reviewing the likelihood that debtors invoices will be paid on the due date.
    E.g. some clients only pay at the end of the month, whether the due date is the 20th or not. Knowing which clients will be paying 10 days after their due dates would help with cashflow forecasting, as would knowing which clients always pay on the due date.
    Cashflow forecasting could then be more accurate if the biggest invoice due on the 20th is marked as more likely to be paid on the 31st.

  • Josh Moore commented  ·   ·  Report

    I would like to be able to filter the Aged Receivables Summary report to only show clients with overdue invoices. I have a long list of clients who pay their invoices on time. They appear in the "Current" column, however, I would like the option of viewing the Aged Receivables Summary report with ONLY clients with overdue invoices showing. This means we can focus quickly on who needs to be followed up, by what amounts and how far they're overdue.

    The Aged Receivables Detail report has the option of filtering by due date, but the summary report does not.

    In addition, Xero currently assigns any invoice that is due today to the "< 1 Month" column, but I think it should actually be assigned to "Current", until it is overdue. An invoice that is due today isn't yet overdue, so should still be in "Current".

    My ideal then is to have the option to hide the "Current" column and hide all clients who only have figures in the "Current" column.