Credit Management:Setting Up DSO Targets

Setting DSO target for Cash Collection

What if my director said to me,“I want you to achieve only 70 Days Sales Outstanding for this coming month September 2005.” How then do I calculate the cash required to achieve 70 DSO?

Illustration:
Assuming that for August 2005’s DSO is 75 days and the scenario is as below:

To achieve a target of DSO for 70days for September 2005,I need to:

(a)take September 05 sales as intact 30DSO
plus
(b)whole month of August 2005 sales alone 31DSO
and leave
(c) another 9 days sales in July 2005. 9DSO
———–
70 DSO
++++++

So,my collections should be:
(i) to collect all outstanding receivables remaining in June’2005 (13 DSO) $650,000
(ii) to collect 22 days of receivables of July’2005 (22/31*1,000,000) $677,420
Grand Total Collection to achieve above-said 70 DSO $1,327,420

+++++++++
Well what if I cannot make it?

I then need to be more aggressive in the collections for the old debts or from litigation cases. This should help me to achieve the desired DSO.

• Credit Management:Costs in Extending Credit &ROI on Receivables
• Credit Management:What is the KPA and KPI of a Credit Manager?
• Performance Management/Measurements/KPI used in Credit Management/Credit Control
• Credit Management:An Overview,its Importance and Characteristic of a Company having a well run credit management department
• Cash Conversion Cycle:Methodology and Computation
• ALL TOPICS COVERED UNDER THE HEADING-CREDIT MANAGEMENT/CREDIT CONTROL
• What Are The Roles/Function Of Credit Management Department