Report: Customer Payments [Closed Invoices] - Average days until paid (all customers)
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"
