It’s not a Debtors Database, we opted not to go for that yet as all I really needed was a simply calculation. However, it really depends on what you need.
I know Phocas offer a dedicated Debtor Database and I’m sure if you have multiple Credit Controllers or a large ledger it would be invaluable.
I’m working with a much simpler ledger but the ability to subscribe to reports to give me a snapshot each day of how my team are doing along with a breakdown of who is overdue is very useful to me.
As far as the calc, i’m using the standard Debtors/Rolling 12 Months Sales x 365
I’m exploring ideas though - one of which is a dynamic date range for the turnover per customer - this is quite complex though so i’m not sure on how feasible it is. Example if a customer has only traded for 7 days, has spent £100 and has 100% outstanding his calc would £100 / £100 x 7 = 7 days, a customer who has traded for 18 months, spends £1000 per month but has an invoice outstaning from say 13 months ago as well as the latest two months would show debtor days of £3000 / £13000 x 395 = 91 days, finally a customer who has an invoice outstanding for £1000 from 13 months ago but has not spent since would have debtor days of £1000 / £1000 * 395 = 395 days.
It’s still not perfect but would give a better view by customer.