A working-capital problem rather than a collections one. Worth checking how many of these invoices were late leaving you.
DSO here is simple: debtors divided by daily invoiced value. The most common cause of a large gap is not slow payers but invoices raised a fortnight after the work was delivered.
It compares what was delivered against what was invoiced over a period, to find work that was done and never billed.
In most services businesses this is the single largest revenue leak, and it is invisible because nobody looks at delivery and billing side by side.
Take a quarter. List completed milestones and approved billable hours, then list what was invoiced. The difference is the candidate list.
Go through it line by line. Some will be legitimately unbilled — deliberately written off, or awaiting a milestone. The rest is money you did the work for.
It will not tell you whether it is still billable. Invoicing work from eight months ago is a commercial decision and sometimes a bad one.
It also cannot find work that was never recorded anywhere.
Look for patterns rather than individual misses. If unbilled work clusters on one project manager or one client, that is a process problem rather than an oversight.
Out-of-contract support time is the most commonly missed category, because it is recorded in a support tool that billing never reads.
A quarter to start. Further back is usually harder to bill.
It varies, but it is almost never zero.
No.
Half an hour on your own figures, and an honest answer about the parts Treepie does not improve.