Skip to content
← Reports & tax

Enter your idea

Reports & tax: Reporting

Categories

(thinking…)

Reporting - Show average Days to Pay by customer

Ability to show average days to pay by customer.

Purpose: User can sort into the customer that habitually pay late and take appropriate action.

178 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

AdminXero Team (Admin, Xero) 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
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.

Show previous admin responses (1)

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
  • Lesley Christian commented  ·   ·  Report

    This is a standard accounting report that is required.

    I'm astounded that we have to use a workaround because the accounting software doesn't provide this. We have to export data to Excel and add a formula to calculate this average days to pay figure for us.

    The Business Snapshop gives a snippet of average days to pay but it is not based on each customer invoice, it is across everything that you have outstanding in accounts receivable:

    'How we calculate the average days

    (Average accounts receivable / Sales) x Days in period'

    This is a very generic piece of information and doesn't empower you to target any customers for persistently paying 'x' number of days past the invoice due date

  • Claudia Ossa commented  ·   ·  Report

    This is highly needed in order to take appropiate action towards a potential revision of client account terms.

  • Melissa Macare commented  ·   ·  Report

    Want to be able to forecast cash flow based on customers' historical payment patterns rather than due date of invoices.

  • Hayley Young commented  ·   ·  Report

    A new 'payment date' field on reports. This would allow users to calculate average time to pay (defined as: number of days between invoice date and payment date).

    Alternatively a new report which does this.

  • Emma Goodin commented  ·   ·  Report

    Report contact payment time frames to capture clients who regularly take a certain timeframe to pay invoices. For example repeat offenders who pay after the due date. The financial year would be a good reporting time frame.

  • Jennie Niccol commented  ·   ·  Report

    I am needing days taken to pay for each invoice. I don't just want average days to pay. I'm interested in the history over time.

  • Christine Ashton commented  ·   ·  Report

    Want to be able to forecast cash flow based on customers' historical payment patterns rather than due date of invoices.

  • Dale Ogden commented  ·   ·  Report

    Say I've just been granted the task of paying off bills as per the accounts payable aging summary, but the business has both written and unwritten agreements with some of our creditors regarding the actual pay-by dates that aren't reflected in the invoices.

    Some are okay with a 90-day wait, some need it by the end of the week, and since a lot of them use the standard 20th-of-next-month script on their invoices (Or, more bewilderingly, the same date that the invoice was issued) it's a bit tricky for someone fresh to the role to keep up.

    Which leads to my question: The supplier page gives a good indicator as to when to pay (See attached), is there a way to place that onto the aging summary for each of the suppliers? Perhaps in a separate column?

  • Charles Hewitt commented  ·   ·  Report

    We like to understand how effective the different stage of our account receivable process is, to do this we need to know the proportion of invoices that are paid at each stage:
    Average proportion paying within a range of days for a given reporting period ie 35% < 5 days, 30% 6-30 days, 15% 31-60 days, 10% > 60 days etc

2 Next →