Skip to content

Financial Management and Strategic Management · Management of Receivables

Monitoring Receivables: Ageing Analysis and Days Sales Outstanding

Updated 4 October 2026 · Fact-checked

Monitoring receivables means tracking how fast customers pay. The main tools are average collection period (days sales outstanding), the ageing schedule, which groups debtors by how overdue they are, and the collection experience matrix. You compute DSO as receivables ÷ credit sales × days, then compare it with the credit period.

Understand Monitoring Receivables: Ageing Analysis and DSO

Giving credit is only half the job. You must also check that customers pay on time. Slow payment blocks cash, raises financing cost and increases bad debts. Monitoring receivables means measuring this regularly and acting early.

The simplest tool is the average collection period (ACP), also called days sales outstanding (DSO). It tells you how many days, on average, a rupee of credit sales stays unpaid. If your credit period is 30 days and DSO is 45, customers are paying late on average.

DSO is only an average. It can hide a few very old debts behind many prompt payers. The ageing schedule fixes this. It lists receivables in age bands, such as 0-30, 31-60 and 61-90 days, and shows the share of the total in each band. A large share in older bands is a warning sign. It also points to the specific customers to chase.

A third tool is the collection experience matrix (collection pattern). It shows what percentage of a month's credit sales is collected in the month of sale, the next month, and so on. It tracks each month's sales separately, so it is independent of changes in the level of sales. DSO and the ageing schedule are both affected by sales fluctuations. The ageing schedule looks at outstanding balances at a date. The matrix looks at the collection pattern of each month's sales.

In exams you usually compute DSO or ACP, build or read an ageing schedule, and comment on the result. Always end with an interpretation.

Key rules to remember

Average collection period / DSO
DSO = (Average receivables ÷ Credit sales) × Number of days
Use credit sales only. Use 365 days unless the question says 360. If only one receivables balance is given, use that balance.
Receivables turnover ratio
Receivables turnover = Credit sales ÷ Average receivables
Number of times receivables are collected in the year.
DSO from turnover
DSO = Number of days ÷ Receivables turnover
Gives the same answer as the direct formula.
Ageing schedule share
Share of a band (%) = Receivables in band ÷ Total receivables × 100
Compare the older bands with the credit terms.
Collection matrix
Collection in a month = Σ (Sales of month t−k × % collected after lag k), with k = 0, 1, 2, ...
Lag 0 is the share of the month's own sales collected in the month of sale. Add collections from each month's sales falling in the month asked.
Receivables balance from DSO
Receivables = (DSO × Credit sales) ÷ Number of days
Use when DSO is given and you need the investment in receivables.

How to solve Monitoring Receivables: Ageing Analysis and DSO questions

Use this order for any question on monitoring receivables.

  1. 1Read the question and note the tool asked: DSO, ageing schedule or collection matrix.
  2. 2Separate credit sales from cash sales. Ignore cash sales in DSO and turnover.
  3. 3Note the number of days to use (365, 360 or as given) and whether average or closing receivables apply.
  4. 4Compute the figure in steps: write the formula, substitute, then calculate.
  5. 5For an ageing schedule, total each band and find each band's percentage of the total.
  6. 6For a collection matrix, apply the collection percentages to each month's sales and add by month.
  7. 7Compare the result with the credit period or the previous period.
  8. 8Write a one or two line interpretation and a suggested action, such as tighter follow-up of old balances.

Quickest way: Fast route for MCQs and written answers

When to use it: Use under time pressure, for both the 30 marks of MCQs and the descriptive part.

  1. MCQs: first check the days basis (360 or 365) and whether sales are credit sales. Most wrong options come from using total sales.
  2. Estimate DSO mentally as receivables ÷ sales, then multiply by days. Eliminate options far from your estimate.
  3. If DSO is higher than the credit period, the answer to 'are customers paying late' is yes, by the difference in days.
  4. Written answers: write the formula first, then the substitution, then the answer with the unit (days or ₹). Each earns step marks.
  5. Always add a final line of interpretation. A correct number without comment can lose marks.

Common mistakes in Monitoring Receivables: Ageing Analysis and DSO

  • Using total sales instead of credit sales in the DSO formula.

    Students take the first sales figure in the question.

    Fix: Scan for cash sales or the percentage of credit sales. Deduct cash sales before computing.

  • Using the wrong number of days, such as 365 when the question says 360.

    Habit from other chapters.

    Fix: Underline the days basis in the question and use it throughout.

  • Stopping at the DSO figure without comparing it with the credit period.

    Students stop after the calculation.

    Fix: Compare DSO with the credit period. If DSO is higher, state the days of delay. If it is lower, state that customers pay early.

  • Mixing up the ageing schedule and the collection matrix.

    Both use time and percentages.

    Fix: Remember: ageing schedule is outstanding balances at one date by age band. Matrix is the collection pattern of each month's sales over later months.

  • Calculating band percentages on the wrong total.

    Students divide by sales instead of total receivables.

    Fix: Divide each band by the total outstanding receivables, so the percentages add to 100.

  • Adding collections wrongly in a matrix by applying the wrong lag.

    Confusion about which month's sales a percentage belongs to.

    Fix: Draw a small grid: rows are sales months, columns are collection months. Fill it, then add the column.

Worked examples

Example 1

A firm has annual sales of ₹60,00,000, of which 80% are on credit. Average receivables are ₹6,00,000. Its credit period is 30 days. Taking 360 days in a year, compute the DSO and comment.

Show the solution
  1. Credit sales = 80% × ₹60,00,000 = ₹48,00,000.
  2. Receivables turnover = ₹48,00,000 ÷ ₹6,00,000 = 8 times.
  3. DSO = 360 ÷ 8 = 45 days.
  4. Check by direct formula: (₹6,00,000 ÷ ₹48,00,000) × 360 = 0.125 × 360 = 45 days.
  5. Compare with credit period: 45 − 30 = 15 days late on average.

Answer: DSO is 45 days. Customers pay 15 days later than the 30-day credit period, so the firm should tighten follow-up and review its collection policy.

Example 2

At 31 March, a firm's receivables are: 0-30 days ₹4,00,000; 31-60 days ₹3,00,000; 61-90 days ₹2,00,000; over 90 days ₹1,00,000. Prepare the percentage ageing schedule and comment. Credit terms are 30 days. Assume ageing is measured from the invoice date.

Show the solution
  1. Total receivables = 4,00,000 + 3,00,000 + 2,00,000 + 1,00,000 = ₹10,00,000.
  2. 0-30 days: 4,00,000 ÷ 10,00,000 = 40%.
  3. 31-60 days: 3,00,000 ÷ 10,00,000 = 30%.
  4. 61-90 days: 2,00,000 ÷ 10,00,000 = 20%.
  5. Over 90 days: 1,00,000 ÷ 10,00,000 = 10%.
  6. Total = 100%.
  7. Since ageing is measured from the invoice date, balances older than 30 days are past the 30-day credit terms. These are 30% + 20% + 10% = 60% of the total.

Answer: Only 40% of receivables are within the 30-day terms. 60% are past the credit terms, and 30% are older than 60 days. The firm should chase the 61-90 and over-90 balances first and consider a provision for the oldest.

Exam tips

  • Check whether the question gives credit sales. If only total sales and a credit percentage are given, compute credit sales first.
  • Show both the formula and the substitution. Step marks depend on this.
  • When asked to 'discuss' monitoring tools, cover DSO, ageing schedule and collection matrix, with one line on the strength and limit of each.
  • In difference questions, give two or three clear points: basis of measurement, what it shows, and the main limitation of the tool.
  • End calculation answers with a comment on whether collection is better or worse than the credit period.

Practice questions from Management of Receivables

Monitoring Receivables: Ageing Analysis and DSO in other exams

The same ground in other exams, if you are preparing for more than one or want another angle on it.

Monitoring Receivables: Ageing Analysis and DSO: frequently asked questions

What is the formula for days sales outstanding?

DSO = (Average receivables ÷ Credit sales) × Number of days. Use 365 days unless the question says 360. It is the same as the average collection period.

What is the difference between an ageing schedule and a collection experience matrix?

An ageing schedule groups outstanding receivables at a date by how old they are. A collection matrix shows what share of each month's sales is collected in the same and later months. The first shows current balances. The second shows collection behaviour over time.

Why is DSO not enough to monitor receivables?

DSO is an average, so a few very old debts can be hidden by many prompt payers. It can also move with changes in sales, as the ageing schedule does too. The collection matrix is not affected by sales changes because it tracks each month's sales separately, and the ageing schedule shows which balances are old and which customers to chase.

Should I use closing or average receivables for DSO?

Use average receivables if the question gives opening and closing balances or says average. If only one balance is given, use it as stated in the question.