Is there a report I can check average payment time for our clients? or do I have to go through every single transaction and count?
Thanks!
Is there a report I can check average payment time for our clients? or do I have to go through every single transaction and count?
Thanks!
There is on report but if you have some Excel skills. Export the customer aged detail report to Excel and subtract INVOICE from PAYMENT will calculate the number of days and then use the AVG days formula at the end of the customer listing. Use an IFF formula to only calculate PAYMENT lines. I know this sound complicated but will save some time.
=if(d7="Payment",c9-c8,0)
I am also needing an avg days to pay for customers...where can this be found??
*Community Hub is the new name for Sage City