Monitoring of Accounts Receivables: 6 Techniques

For effective management and control of receivables, the following techniques are used by the Credit Manager in monitoring the status and composition of accounts receivables:- 1.  Ratio Analysis for Control of Receivables 2. ABC Analysis of Receivables 3. Discriminate Analysis and Credit Scoring 4. Credit Utilization Report 5. Cost-Benefit Analysis of Collection Expenses 6. Measuring Day’s Sales in Terms of Debtors.

Technique # 1. Ratio Analysis for Control of Receivables:

The analysis of receivables can be done with the help of ratios given below for efficient management of debtors balances:

(a) Debtors Turnover Ratio:

(b) Average Credit Period (in days):

(c) Debtors to Current Assets Debtors:

(d) Debtors to Total Assets Debtors:

(e) Bad Debts to Sales:

(f) Bad Debts to Debtors:

The above formulae can be used to analyze the efficiency in management of receivables and to analyze the trend over a period of time.

Ageing Schedule:

The ageing schedule of debtors is prepared basing on the collection pattern. The total debtors balances are classified according to their age i.e. the outstanding period for which the amount is uncollected. The ageing schedule provides useful information for assessing the company’s liquidity position, efficiency of credit control department, efficiency in collection of receivables, comparison with previous ageing schedules etc.

The age analysis of debtors may be used to help decide what action to take about older debts. For better control on collection of receivables, ageing schedule is prepared and analyzed for identifying the overdue amounts. Ageing schedule of receivables is prepared according their period of outstanding, for example, less than 30 days, 31-45 days, 46 – 60 days, 61-75 days, 76-90 days, above 90 days etc.

The ageing schedule of debtors can be prepared manually or by computer. Preparation of the schedule requires to go back to the date on which invoice is raised. The schedule is used for identifying the quality accounts, overdue accounts and trouble some accounts. The age schedule can also incorporate the details of individual accounts, region wise accounts, industry sector wise accounts etc.

Illustration 1:

 

 

 

 

 

 

 

Illustration 2:

 

 

 

 

 

 

 

 

 

Technique # 2. ABC Analysis of Receivables:

The ABC analysis technique mainly framed for effective control of inventory. The application of the same technique to manage the debtors balances will also give good results for the firm with huge number of accounts.

The application of the technique is explained with the help of the following table:

It is seen from the above table that only 20% of the total accounts represents the 70% of total debtors balance and a close scrutiny of these accounts and realization of dues in time will cost only moderately and improves the efficiency of debtors collection and also improve the liquidity of the firm and avoids unnecessary blockage of funds in debtors balances which can be invested elsewhere to obtain the opportunity cost of funds. To large extent it avoids the administration costs also.

Category B debtors balances needs moderate control and Category C balances, though large in number, but are very less in amount to the proportion of total debtors and the managerial attention should not be diverted to these balances. However, it also requires moderate attention for efficient management of debtors.

Technique # 3. Discriminate Analysis and Credit Scoring:

Discriminate Analysis:

It is an important tool used for discriminating between good and bad accounts taking into account the readily available information from financial data relating to size of firm, acid test ratio, creditors payment period etc.

Credit Scoring:

It is a technique used in discriminating between good and bad accounts based on past repayment and default experience relating a particular customer. The credit scoring is given for each such customer and credit facility is extend if he exceeds the cut-off score.

Technique # 4. Credit Utilization Report:

The total limit of credit offered to each customer and the extent to which it is utilized will be reviewed on periodical basis to observe the extent to which total limits being utilized. All this information is presented in a report form called ‘credit utilization report’.

An example of the report is given below:

Illustration 3:

This report will also contain the other information, such as day sales outstanding and so on. This report will reveal the following:

(a) The number of customers who might want more credit.

(b) The extent to which the company is exposed to debtors.

(c) The tightness of the credit policy.

(d) The degree of exposure to different customers.

Technique # 5. Cost-Benefit Analysis of Collection Expenses:

A firm has to incur some routine costs like sending reminders, telephone expenses, expenses incurred for personal visits to customers’ places, commission and fees payable to collection agencies, legal expenses etc.

When the firm incurs more costs on collection of debts, there is likely to be less amount of debts turn into bad debts and vice versa. If the firm goes on increasing the cost of collection of debts, after- some point, there would not be further decrease of bad debts. The point is called ‘saturation point’ as shown in figure 16.1, if the firm incurs collection expenses beyond this point, cannot benefit the firm in reducing its bad-debt losses.

Technique # 6. Measuring Day’s Sales in Terms of Debtors:

The total debtor represented by day’s sales is calculated in the following three ways:

Debtors Turnover Method:

The days sales in debtors ratio represents the length of the credit period taken by customers.

Illustration 4:

Ajanta Ltd. made sales of Rs. 30,00,000 for the year 2009 and its corresponding debtors is Rs. 4,90,000. Calculate the debtors turnover in terms of days.

Solution:

Count Back Method:

This method is based on the assumption that the debtors balance relating to the most current period sales.

Illustration 5:

Arvind Ltd. has a debtors balance of Rs. 15,00,000 as on 31-3-2009. Sales in March – Rs. 7,00,000, February – Rs. 5,00,000, January – Rs. 8,00,000.

Partial Month Period:

This method analyses each months sales and the unpaid portion. These are aggregated together to get days sales of debtors.

Illustration 6:

Citizen Ltd. has a debtors balance of Rs. 12,00,000 for the year ended 31-3-2009. Data related to the previous months is presented as follows:

The partial month method not only provides the overall debtors ageing figure but also provides month-wise debtors outstanding.