- The DSO result
- The cash collected during the month versus the Cash Target set
- An Aged Debt Analysis, showing largest accounts first.
- Send a one page Debtors Summary at month end, comparing actual results with previous month and with any budgets made, to all managers and directors for action on major problems and trends.
This is a good prompt for talking to key customers about their payment dates.
If you improve the Debtors asset gradually, month after month, the faster cash soon shows in a healthier balance sheet.
A useful calculation is to compare the cost of the resources needed against the benefits of the extra cash being produced.
See the Quick step guide for a step by step approach to these procedures.
How to calculate your Days Sales Outstanding (DSO)
Your current days sales outstanding (DSO) is calculated by dividing the total amount owed to you by your sales per day. Your sales per day is calculated by dividing your annual turnover on credit terms by 365, the number of days in the year. e.g. To calculate the Sales per Day (when annual turnover is £1,000,000): £1,000,000 divided by 365 equals 2739.7
To calculate DSO (based on example above and when amount owed is £10,000)
£10,000 divided by 2,739.7 equals 3.65
Your reduced, improved DSO is calculated by multiplying the total amount owed to you by the percentage improvement in your collections activity (say 10 to 20%) and then taking the resultant figure away from the total amount owed to you before repeating the above calculation.
The increase in your cash flow is calculated by multiplying the total amount owed to you by the percentage improvement in your collections activity.
The reduction in the cost of your borrowing is calculated by multiplying the increase in your cash flow, above, by the percentage interest rate for borrowing money (say 5%).