Measurements/KPI used in Credit Management/Credit Control
Published by slang March 23rd, 2006 in Credit ManagementGO TO MAIN PAGE FOR ALL ARTICLES ON CREDIT MANAGEMENT
As mentioned in my earlier articles, Top management must review and reinforce the importance of certain measurements used in Credit management.. What are they?
Measurements in Credit Management includes the following :
- Days Sales Outstanding (DSO)
- Aged analysis of Overdues,
- Overdues as a % of Total debtors,
- Disputed Debts (including Debit notes ) as a % .
For the methodology and computation of DSO, please refer to my article on Cash Conversion Cycle, We shall now discuss the following usefulness of using DSO as the measurement in Credit Management.
1. Days Sales Outstanding:
We must not narrow ourselves by thinking that DSO can only be apply to a company. The following illustrations show otherwise.
In fact, we can create a “football league” table using DSO which will assist us to narrow down to the model champion or the culprits..
DSO: By Company or By Total Group
| Company A | Company B | Company C | Total Group | |
| Actual | 80 | 90 | 100 | 95 |
| Budget | 60 | 75 | 80 | 75 |
DSO: By Department or By Overall Company
| Department A | Department B | Department C | Overall Company |
|
| Actual | 80 | 90 | 100 | 95 |
| Budget | 60 | 75 | 80 | 75 |
DSO: By Salesperson or By Salesperson Group
| Salesperson A | Salesperson B | Salesperson C | Salesperson Group | |
| Actual | 80 | 90 | 100 | 95 |
| Budget | 60 | 75 | 80 | 75 |
DSO: By Projects
| Project A | Project B | Project C | Overall Project |
|
| Actual | 80 | 90 | 100 | 95 |
| Budget | 60 | 75 | 80 | 75 |
2. Aged Analysis of Overdues:
Use to calculates the quality of overdues. Ideally, overdues should only be restricted to 1-30 days. However, this is really not possible, hence we need to understand whether the overdues are improving or deteriorating by reviewing the overdue ageing analysis schedule:
Assuming total debtors totaled $3,000,000 of which $1,000,000 is current (1-30days). The remainder of $2,000,000 is overdue. Therefore, we need to analyse the $2,000,000 into further ageing bucket like for the following example:
Total overdue 1-30days 31-60days 61-90days 91-120days 121+days
$3,000,000 $1,000,000 $500,000 $300,000 $200,000 $1,000,000
3. Overdues as % of total debtors:
Just a calculation of the value of Overdues as a% of total debtors at a certain cut off say month end.
It is important to combine this overdues as % of total debtors and further break down into an Aged analysis of overdue schedule in order to make these two ratios more meaningful.
4. Disputed Debts
We must not underestimated disputed debts in credit management. Usually, these disputed debts will clogged up the cash in flows of the company. Always split up the total debtors by taking this disputed debts and then re-analyse the disputed debts as a % of total debtors and also as a number of days sales unpaid. Normally, these disputed debts are in the form of debit notes claim. Ultimately, once resolved, might be credited/deduced eventually from the amount owing by the debtors.
Other reports which assists in measurement of the progress of cash collections from trade debtors are as follows:
- Daily cash collection report: actual versus target,
- Summary of trade debtors by Department manager and by salesperson
- Summary of trade debtors by salesperson only
A Sample of Daily Collection Report to monitor cash collections for Companies with Branches:
CASH COLLECTION : ACTUAL VERSUS TARGET
| Department | Head Office | Branch A | Branch B | Week 1 | Week 2 | Week 3 | Week 4 | Total |
| Dept A: Actual | ||||||||
| Target Collections | ||||||||
| Dept B: Actual | ||||||||
| Target Collections | ||||||||
| Grand Total: Actual | ||||||||
| Total Target Collections | ||||||||
| Variance |
| Post-Dated Cheques | Week 1 | Week 2 | Week 3 | Week 4 | Total | |||
| Head Office | ||||||||
| Branch A | ||||||||
| Branch B | ||||||||
| Total |
We can actually summarized a trade debtors report to be presented to Top management which is as follows:
| SAMPLE OF A MONTHLY DEBTOR REPORT AS AT 31 st October 2005 |
|||||||||
| Budget |
This Month |
Last Month |
Previous Year |
||||||
| 1 | Days Sales Outstanding (DSO) |
69 | 67 | 65 | 77 | ||||
| 2 | Overdues % |
10% | 9% | 9% | 10% | ||||
| 3 | Aged Analysis of Overdues (%) |
Rm |
% |
Rm |
% |
Rm |
% |
Rm |
% |
| 31-60 | 100 | 4% | 100 | 4% | 100 | 4% | 100 | 4% | |
| 61-90 | 200 | 9% | 200 | 9% | 200 | 9% | 200 | 9% | |
| 91-120 | 300 | 13% | 300 | 13% | 300 | 13% | 300 | 13% | |
| 121-150 | 400 | 17% | 400 | 17% | 400 | 17% | 400 | 17% | |
| 151-180 | 500 | 21% | 500 | 21% | 500 | 21% | 500 | 21% | |
| 181-360 | 600 | 26% | 600 | 26% | 600 | 26% | 600 | 26% | |
| 360-450 | 150 | 6% | 150 | 6% | 150 | 6% | 150 | 6% | |
| 361-450 | 100 | 4% | 100 | 4% | 100 | 4% | 100 | 4% | |
| >451 | - | 0% | - | 0% | - | 0% | - | 0% | |
| Total Overdue >31 days onwards | 2,350 | 100% | 2,350 | 100% | 2,350 | 100% | 2,350 | 100% | |
| > 90 days - $ / % |
2,050 |
87% |
2,050 |
87% |
2,050 |
87% |
2,050 |
87% |
|
| 4 | Disputed Debts |
||||||||
| $ | 48 | 91 | 102 | 123 | |||||
| % of total debtors | 2% | 4% | 4% | 6% | |||||
| DSO | 1.5 | 2.8 | 2.7 | 4.6 | |||||
| Data |
|||||||||
| Total Debtors | 2,250 | 2,450 | 2,570 | 1,970 | |||||
| Overdue Debtors | 221 | 220 | 235 | 200 | |||||
| Sales | 1,100 | 1,320 | 930 | 870 | |||||
| Cash Collected | 1,000 | 1,200 | 1,100 | 900 | |||||
It is crucial that Senior management should consistently and constantly review the progress of credit management vide the aforesaid measurement or key performance indicators as this will inevitably affects the company’s Return on Investment Ratio ( ROI).
By getting the debtors to pay earlier will enhance ROI as:
- The investment in trade debtors is reduced,
- The returns or income is increased by lessening the interest cost of borrowing to finance debtors
Any provision or write off of bad debts will reduce the net income of the company.
If you found this post useful, keep updated with future posts by subscribing to FMAccounting (for free) through RSS or email.
Related Entries
- Credit Management:What is the KPA and KPI of a Credit Manager?
- Credit Management: Setting Up DSO Targets
- Credit Management: An Overview, its Importance and Characteristic of a Company having a well run credit management department
- Credit Management: Costs in Extending Credit & ROI on Receivables
- Cash Conversion Cycle: Methodology and Computation


No Responses to “Measurements/KPI used in Credit Management/Credit Control”
Please Wait
Leave a Reply