Skip to content
← Share and support customer ideas for Xero

Settings and activity

1 result found

  1. Reporting - Show average Days to Pay by customer

    139 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

    27 comments  ·  For small businesses » Accounting features  ·  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
    submitted  ·  AdminHannah G (Admin, Xero) responded

    Hi community, thanks for your interest in this idea. Just wanted to pop in here to share, for those who aren't already aware, that you can export the Receivable Invoice Summary report. The report has a 'Last Payment Date' column that you can add to it which is useful for finding customers who habitually pay late so that you can take appropriate action.

    To be transparent, building a feature to show the average days to pay by customer isn't on our roadmap at this time, but we'll be sure to update this idea if that changes in future.

    An error occurred while saving the comment
    Howard Robbins commented  · 

    There is a workaround you can do that is a good substitute until they implement this feature. Export the 'Receivable Invoice Summary' report. The report has a 'Last Payment Date' column that you can add to it. Then if you subtract the last payment date from the invoice date you will get the days to pay. Make a unique customer list and average the results over a period you determine when you set the date range for the report e.g. 1 year, 2 years, 5 years.

    Howard Robbins supported this idea  ·