Progression calculates the average number of days it took a customer to pay as follows:
1. It calculates the number of days it took the customer to pay the current invoice by determining the number of days from invoice date to the final payment date.
2. It calculates the number of days it took the customer to pay all existing invoices excluding the current invoice. (The average days to pay YTD multiplied by the number of invoices paid YTD.)
3. It then adds the two totals together to receive the total number of days (the total now includes the current invoice.)
4. The new total number of invoices paid is calculated by adding 1 to the number of invoices paid YTD.
5. It then divides the total number of days by the total number of invoices to get the new average. (New total days divided by the new number of invoices equals the new average.)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.