Reporting: Customer Payment Performance - payment date and number of days late
Ability to generate a report where users’ can view contact payment activity
Purpose: Users’ can easily see which customer has good and bad credit performance, and manage customer relationships & debt.
Hi everyone, we appreciate the continued trend in support through this idea, and feedback to my last update. We recognise how valuable it is to have clear visibility of your customer payment performance, so you can quickly review payment dates and days late across customers without needing to check each contact individually.
We want to share that we’re currently working on reports to give businesses better visibility of payment performance, with our initial focus on the supplier side through a new 'Supplier days to pay detail' report showing historical payment behaviour across suppliers.
Once that’s rolled out, we’ll begin work on additional reports for the Sales side with customer payment performance.
I’ll return to share as work on customer reporting is picked up and progresses. Thanks
-
Hi everyone, we very much appreciate the feedback we've received to our update. We totally understand the need for this on the Sales side. To give a little more insight, we've started with the supplier side to meet the needs of the UK Fair Payment Code that requires businesses to provide evidence of their payment performance from their accounting software when applying for an award. As soon as this report is complete, we plan to move onto customer reports and I will be sure to share progress of this with you here. Thanks
-
Anne Lummis
commented
Totally agree with the other comments today. I'm really glad that Xero has now picked this up, but we don't need supplier reports, we need customer payment reports!
I do sometimes wonder how much Xero actually understands about running a business. Why on earth does Xero think supplier reports are a priority over customer payment reports?
-
kashif ahmed
commented
JD Furlong - has hit the nail on the head!
Xero reinventing the wheel - but starting from the wrong end!
-
Joanne Anderton
commented
I agree with JD, Supplier payment days is pointless for me, & whilst I'm pleased we will be getting Customer payment performance reports, I hope we don't have to wait too much longer?
-
JD Furlong
commented
Hi there,
Really glad that this is moving along.
Q - why are you starting with Suppliers. Surely as the business owner I know when I pay my suppliers, that's a controllable issue by my business. What's needed is insight into when customers pay, this helps manage cashflow.
Given that Xero's adverts are all about 'manage cashflow and get paid quicker' it strikes me as strange that you start on the opposite side, i.e. Suppliers, of what has been asked of you, which is customer pay dynamics.
Please can you explain?
JD
-
Atelier Accounts
commented
Yes, I do "Receivable Invoice Summary" add a column to "count days" from invoice date to payment date, then do an average from those figures. A real faff and time consuming but it works.
-
Stuart Mohamed
commented
Question for the 325 people who have voted for this. Seeing as Xero is pretending this is a non-issue and not worthy of an update, has anyone found a decent workaround to this yet? Are there existing reports in Xero that we can use in conjunction with one another to get the information we need?
-
Lisa Davies
commented
I feel this is very important to have for all businesses. If the information is available on each individual contact, why can't we access this information by downloading a quick report. It is very time consuming to have to manually report on this.
-
Damian Redenbach
commented
This information is already available in each customer profile, so it should be easy to add as a report
-
Andrew Brindley
commented
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.
-
Nicola Barnett
commented
How is this not a report in accounting software!
It's critical to businesses, which Xero is trying to make itself?It's a calculation isn't it?
-
Joe Warburton
commented
Not sure i can add any more to what Stuart said really. This seems such an easy fix that should already be standard.
-
Stuart Mohamed
commented
I can't imagine this would be very hard to do at all, nor very time consuming. Considering that Xero is already calculating it and posting it on the contacts page, is it really that much of a stretch to add this to the suite of reports already available?
A status update would be welcome please Xero.
-
Eve Anderson
commented
This feature is very important for categorising customers & credit control! Otherwise you have to click on all individually but this is so inefficient. It already calculates the average, we just need it in a report form!
-
Alan Gray
commented
Oh no - not another important feature that has been sitting in their in tray for a very long time!!
-
Jenna Ayling
commented
We really need this report function to become a reality! Being able to view the average days a customer takes to pay is a key element to credit control, and I don't want to have to go into each customer one by one to pull this information, it should be an optional column on any receivables report. Please make it happen.
-
Natalie Burkitt
commented
Also would be really keen to have this to be able to manage cashflows more effectively. Currently I've been to each customer card on Xero and typed it into Excel, but becomes out of date quickly and is incredibly time consuming. The information is there, so would be great if it could be built into a report.
-
Julie Sutton
commented
Been asking for this for 10 years now - really don't understand what is so complicated ....
Come on Xero - this is such a basic requirementAll we want is a report of a filed that already exists in Xero
-
Fern Bradford
commented
It would really help with reporting to be able to view customer debtor days per customer in one report. As we have a lot of clients it is not practical to go into each client to view the payment days. The average payment days on the executive report is not enough detail.
-
Vanessa Lim
commented
It's nice to be able to see how many days on average a customer takes to pay you but ideally, if we could have a report to extract this information for all customers so we can compare to payment terms, that would be even better in order to manage debt and giving customers a bigger or smaller credit limit. It will also inform on whether there's been a downward trend which could be a red flag on how well a company is doing.