Share your ideas for improving. Vote on ideas and discuss them with the MYOB product development team.

Product Ideas

Report: Customer Payments [Closed Invoices] - Average days until paid (all customers)

Trusted Cover User

126Posts

26Kudos

2Solutions

126 Posts
Trusted Cover User
Australia

I would like MYOB to be able to tell me my total average debtors 'days to pay invoices' figure, for a chosen period of time. 

 

The 'Customer Payments [Closed Invoices]' report lists the 'days 'till paid' for each invoice and then an average for that customer, but not a total for all customers.

 

I know that there is a standard formula for working out debtor days, but this only works correctly if you have a business that sells fairly consistently throughout the year.  I work in agriculture and 80% of the business income comes in over a 5 month period.  This makes the debtor days formula result inconsistent.

 

MYOB knows exactly how long each invoice takes to pay and the average days to pay for all invoices would be quite a simple calculation for MYOB. 

 

I suggest that the report 'Customer Payments [Closed Invoices]' has a total line at the bottom that shows the average debtor days for all the customers listed in the report.

 

"Average Debtor Days Report"

Current Status: Open
Last Changed: May 2015

Hello @DeannaK, Thank you for your suggestion for the customer payments report. I can see how this would be helpful for users to have this information made available. I encourage any one that would like to see this implemented to vote and post relevant comments.

 

 

5 Comments
KattC
790 Posts
Former Staff

Hello @DeannaK, Thank you for your suggestion for the customer payments report. I can see how this would be helpful for users to have this information made available. I encourage any one that would like to see this implemented to vote and post relevant comments.

 

 

Chuck_Mak
Partner
103 Posts
Partner

The average days to pay is already shown in the customer cards so I would think pulling the data into a report format should be pretty easy for MYOB.

Steven_M
45,180 Posts
Former Staff

Hi @Chuck_Mak

 

Thank you for your thoughts in regards to this report. it has been passed it to the required team.

TracyStinson72
2 Posts
Cover User

Hi

This would be extremely useful for me as I am trying to create a report like this as we speak and can't get an average with all customers included.

cambrian
Experienced User
44 Posts
Experienced User

Agree, It would be great to have tis as an option on the insights page as it is a KPI that many business work to.
Potentially nice to see overall / by sales rep/ and possibly have an option to customise and include a customer (I am thinking here cash sales)
Generally this would be measured on the last day of each month and charted