Receivables ageing model
Build ageing buckets from invoice ledger and rank the collection by worklist rather than age.
This is synthetic data, my clients can run their data on it.
- How much cash is outstanding?And how much of it is already overdue.
- How long does it take to get paid?Days sales outstanding, month by month.
- Who is driving the overdue balance?Top debtors and segments, ranked by exposure.
- Is collection getting better?Change the as-of date and the whole book re-ages.
430 invoices, 41 still open. Darker is older. Total open $417K.













