Skip to content
← Reports & tax

Enter your idea

'Reports - Generate a report listing each individual client and their average debtor days.' has been merged into this idea

Reports & tax: Reporting

Categories

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.

220 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
Accepted  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

Thanks for everyone's feedback and the strong support for a report that shows average days to pay by customer. We know this visibility is important for businesses wanting to identify habitual late payers and make better credit and cash flow decisions.

Right now, we've begun work to develop reports that improve visibility of payment performance. Our immediate focus on the supplier side and a new Supplier days to pay detail report that'll show historical payment behaviour across suppliers.

Once that’s rolled out, we’ll begin work on additional reports for customer payment performance, which will solve the needs in this idea.

I'll be back to update you all here as work for customer reports gets underway. 🙂

Show previous admin responses (2)

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
  • Paul Fogg commented  ·   ·  Report

    Surely this can be actioned as the information is stored in the customer section - can't believe this is a hard one to fix!

  • Myra Sheehy commented  ·   ·  Report

    This feature really needs to be enabled. Crazy that the average days is available to view in the client card but no report can be generated

  • Kay Boucker commented  ·   ·  Report

    Is there a report we can run showing the average time to pay for our customers who have paid an invoice in the last financial year?

  • Yvonne Kent commented  ·   ·  Report

    I have requested an average debtors days report previously, yet XERO still have not actioned or advised when this will be available.

    As below must business use this type of report to understand how customers honour their trading terms

  • Graeme Towers commented  ·   ·  Report

    With the right existing report and a bit of excel manipulation I'm getting a result I can work with - so how about it Xero

  • Sarah Cavenagh commented  ·   ·  Report

    The Customer Contacts page shows the days that "they pay in" which is described as "The average number of days between when invoices are issued and when they're paid". Can this be very simply pulled into the Invoices>Awaiting Payment report as a column, possibly next to the Expected Date? Please add to the roadmap! Thanks

  • Matt Leech commented  ·   ·  Report

    A report showing all customers payment performance with deatials of average terms and average time to pay (aka Days Beyond Terms).

    So many people are asking for this report but you have ignored them time and time again. Even to the extent you have blocked future comments. This in itself is disgraceful. You ask for comment, ignore it, then block people from further comment!

  • Joanne Yeow commented  ·   ·  Report

    Has this been actioned yet? When availble, please also enable the average debtor day be viewed at the Debtor's contact ledger. Thank you.

  • Andrew Brindley commented  ·   ·  Report

    This is a no-brainer and a featured report that should be out of the box. The competition has it; come on, Xero!

    Yes, you can report on customer debtor days in QuickBooks by using the "Accounts Receivable Aging Detail" report; this report shows you a breakdown of customer balances categorized by how long each invoice has been outstanding, allowing you to calculate the average debtor days for your customers..

  • Verity Lamb commented  ·   ·  Report

    Why cant you produce a list of time taken to pay, you used to?!

    Yes, but then you moved us from Sage to Xero.......

  • Julie Sutton commented  ·   ·  Report

    The most ridiculous point about this is that the field is in the system on each clients CONTACT record - yet they cant seem to pull together a simple report that pulls this field out of each clients record ....

    You couldn't make this stuff up .....

  • Neil Huntington commented  ·   ·  Report

    Av. Days to pay is a fundamental requirement in accounting, on the same spreadsheet as current, 31-61 Days, 61-90 Days and older
    lets hope we can have this report soon !

  • Yolanda Leon commented  ·   ·  Report

    Agree with this Idea. I believe it's imperative to get this in Xero. It's a very helpful insight for a business to know average pay by their clients and average pay to their suppliers to be able to take decisions to keep a healthy cashflow. Currently I need to make it manually, checking one by one for our stakeholders which takes me ages.

  • Julie Sutton commented  ·   ·  Report

    Tim - yep totally crazy! Weve been lookng at laternaitve systems to move to and when demo'd the sales teams cannot believe why I would even ask if this report is avaialable as "of course it is" .. haha - if only - welcoem to the world of Xero!

    And yes - I spend probably 2-3 hours a week checking up between the outstanding invoices screen and each inidividual customer record for average payment days then updating as neccessary.

    Such a waste of time for somethnig that would be so simple to implement.

    It all adds up - I'm currently working on a costed business case to move to an altentive platform and its crazy when I look at the cost of the wasted hours in Xero for this along with so many other issues

  • Tim Sneller commented  ·   ·  Report

    The AVERAGE DAYS TO PAY is SHOWN on the customer details screen, but if you have a large number of customers, extracting and using that data is painful.

    The LAST payment date does not really help. A customer may have paid their last invoice LATE or EARLY, which skews the information. What is needed is a REPORT/EXPORT of the AVERAGE days to pay, which is shown on each customer tab, but is not available in any reports (AFAICS).

    If a customer ALWAYS pays late, then I need to reduce their credit terms, or even ask them for payment with order.

    FURTHER to this, on the outstanding invoices screen, where it is possible to enter an EXPECTED payment date, why can that not default to "Invoice Date + Avg days to pay".

    This is however made MUCH more difficult, because the customer name is not exported on every line.

  • Ben Spence commented  ·   ·  Report

    Where are we with this please xero? Surely it's a fundamental function of accounting software, average time to pay report for all your clients.

  • Julie Sutton commented  ·   ·  Report

    @ashleigh - you don't - its a line by line report. All you can do is work out the days for each invoice then average them out at the end. Its a rubbish workaround that Xero thinks is acceptable! Crazy omission that should be standard in any accounting package

← Previous 1 3