How to Calculate the Average Collection Period: DSO Formula, Comparison with Payment Terms, Receivables Aging Table, Delays by Customer, Cost of Outstanding Receivables and Collection Acceleration Plan Training
How do you calculate the average collection period (DSO)? Comparison with payment terms, receivables aging, the cost of outstanding receivables and a collection plan: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is the average collection period?
- Lesson 2: How do you do the example calculation?
- Lesson 3: How do you compare the collection period with the payment term?
- Lesson 4: How do you build a receivables aging table?
- Lesson 5: How do you see delays by customer?
- Lesson 6: What is the cost of outstanding receivables?
- Lesson 7: How do you set up a collection acceleration plan?
- Lesson 8: How do you monitor the average collection period?
- What are the most common mistakes when measuring the collection period?
- How does NetKasam make collection tracking easier?
- Mini quiz: Test what you have learned
- Conclusion: Know how many days your money waits with the customer
- Frequently Asked Questions About the Average Collection Period
In a business that sells on credit, profit is realized not on the day the invoice is issued but on the day the money enters the cash account. When sales grow while cash shrinks, it is often because receivables are collected later. The average collection period shows in a single number in how many days, on average, a sale turns into money; compared with the payment term, it reveals how much of the money is waiting with the customer unnecessarily.
This article is not a narrative but an 8-lesson practical training. We will answer the question how to calculate the average collection period using an example business that makes ₺600,000 in credit sales per month: the definition and formula of the average collection period (DSO), comparison with the payment term, the receivables aging table, delay by customer, the financing cost of outstanding receivables, the effect of a collection acceleration plan and monitoring indicators. At the end there is a mini quiz and an answer key. All figures are example values chosen to demonstrate the method; follow the same steps with your own data.
What will you be able to do by the end of this training?
In short: You will calculate the average collection period, compare it with the payment term, break receivables down by age and by customer, find the cost of outstanding receivables and build a collection acceleration plan with figures.
- 01CalculateFind the average collection period from the receivables balance.
- 02CompareCompare the period with your payment term.
- 03AgeDivide receivables into bands by due date.
- 04Find the customerSee delay by customer.
- 05CostWork out the financing cost of outstanding receivables.
- 06AccelerateSet up a collection plan and measure its effect.
The 8 lessons of the training: (1) what the average collection period is, (2) the example calculation, (3) comparison with the payment term, (4) the receivables aging table, (5) delay by customer, (6) the cost of outstanding receivables, (7) the collection acceleration plan, (8) monitoring indicators.
Lesson 1: What is the average collection period?
In short: The average collection period (DSO) shows in how many days, on average, a sale made on credit is collected. The larger the value, the longer cash waits with the customer.
- Average collection period (days) = Period-end receivables balance ÷ Credit sales for the period × Number of days in the period
- Unnecessarily outstanding receivables = Period-end receivables − (Credit sales ÷ Number of days × Payment term in days)
- Financing cost = Unnecessarily outstanding receivables × Monthly financing rate
The numerator of the formula is the period-end receivables balance, and the denominator contains only credit sales; sales collected in cash or by card are not counted, because they do not create receivables. The receivables balance is taken from the total of open invoices in customer and supplier accounts, and credit sales from the total of credit invoices issued during the period. To keep account records accurate, see the article how to track customer and supplier accounts. The collection period is not calculated once and left; it is monitored as a trend, because its direction matters more than the number alone.
Lesson 2: How do you do the example calculation?
In short: If the receivables balance is ₺900,000, monthly credit sales are ₺600,000 and the period is 30 days, the average collection period is 900,000 ÷ 600,000 × 30 = 45 days.
The example business sells ₺600,000 per month on credit and has ₺900,000 in open receivables in its customer and supplier accounts at month-end. Calculation: 900,000 ÷ 600,000 = 1.5; 1.5 × 30 = 45 days. In other words, the money for a sale enters the cash account, on average, 45 days later.
| Data | Denomination |
|---|---|
| Monthly credit sales | 600.000 ₺ |
| Period-end receivables balance | 900.000 ₺ |
| Number of days in the period | 30 |
| Average collection period | 45 days |
The period used in the calculation affects the result: if you calculate with quarterly sales and the period-end balance (for example ₺1,800,000 in sales, ₺900,000 in receivables, 90 days), you get 900,000 ÷ 1,800,000 × 90 = 45 days; even if sales are constant, the result fluctuates if the balance at period-end is high or low. For seasonal businesses, calculating with the last three months' sales is more reliable. For how to set up credit sales and how to calculate the payment term surcharge, see the article how to calculate the payment term surcharge.
Product pageFree Bookkeeping SoftwareLesson 3: How do you compare the collection period with the payment term?
In short: Subtract the payment term in days from the average collection period to find the average delay. In the example, there is a delay of 45 − 30 = 15 days.
With a 30-day term, if all customers paid exactly on the due date, the average collection period would be 30 days; the receivables balance would also be 600,000 ÷ 30 × 30 = ₺600,000. Since the actual balance is ₺900,000, ₺300,000 is waiting unnecessarily. This difference comes from past-due receivables and term extensions.
| Indicator | Denomination |
|---|---|
| Payment term granted | 30 days |
| Actual average collection period | 45 days |
| Average delay | 15 days |
| Receivables expected with on-time collection | 600.000 ₺ |
| Actual receivables | 900.000 ₺ |
| Unnecessarily outstanding receivables | 300.000 ₺ |
The comparison also has another meaning, which is testing your customer policy: if the term is defined as 30 days but half of customers pay in 60 days, your de facto term policy is 60 days. In that case, either collection discipline must be established, or the term must be aligned with reality and reflected in pricing. To set a price difference by term, you can use the article how to calculate the payment term surcharge, and for the decision to give a discount for cash payment, the article how to calculate a cash payment discount.
Lesson 4: How do you build a receivables aging table?
In short: Divide receivables into bands by whether they are past due and by how much. In the example, 50% of receivables are not yet due and 50% are past due.
| Band | Credit | Share of total |
|---|---|---|
| Not yet due | 450.000 ₺ | %50,0 |
| 1 – 30 days past due | 270.000 ₺ | %30,0 |
| 31 – 60 days past due | 117.000 ₺ | %13,0 |
| More than 60 days past due | 63.000 ₺ | %7,0 |
| Total | 900.000 ₺ | %100 |
- Not yet due₺450,00050%
- 1 – 30 days past due₺270,00030%
- 31 – 60 days past due₺117,00013%
- More than 60 days past due₺63,0007%
Prepared with sample values. The brackets add up to ₺900,000.
Past-due receivables are 270,000 + 117,000 + 63,000 = ₺450,000. As they age, the likelihood of collection falls: the ₺63,000 that is more than 60 days past due may now become a matter for follow-up, a lawyer or a provision. Monitoring the bands in the same table every month shows whether a problem is new or old. To manage the collection process from start to finish, you can use the steps in the article how to follow up on receivables.
Lesson 5: How do you see delay by customer?
In short: Break the delay down by customer. Most of the total delay usually comes from a few customers.
| Customer | Credit | Share of receivables | Overdue | Past-due share of own receivables |
|---|---|---|---|---|
| M1 | 240.000 ₺ | %26,7 | 0 ₺ | %0,0 |
| M2 | 210.000 ₺ | %23,3 | 90.000 ₺ | %42,9 |
| M3 | 270.000 ₺ | %30,0 | 180.000 ₺ | %66,7 |
| M4 | 180.000 ₺ | %20,0 | 180.000 ₺ | %100,0 |
| Total | 900.000 ₺ | %100 | 450.000 ₺ | %50,0 |
240,000 + 210,000 + 270,000 + 180,000 = ₺900,000 in receivables; past due 0 + 90,000 + 180,000 + 180,000 = ₺450,000. 80% of past-due receivables (360,000 ÷ 450,000) come from M3 and M4; all of M4's receivables are past due. Looking by customer also makes the action clear: nothing is done for M1, a reminder goes to M2, and for M3 and M4 a payment condition is sought before any new shipment. To determine how much term to grant each customer, see the article how to set a customer risk limit. The article how to find and close reconciliation differences between accounts is also needed so that balances match on both sides; a balance that does not match is another cause of collection delay.
Lesson 6: What is the cost of outstanding receivables?
In short: The cost of the unnecessarily outstanding ₺300,000 at a monthly financing rate of 3% is ₺9,000.
Unnecessarily outstanding receivables are money the business has to finance from another source. At a monthly financing cost of 3% (an example rate calculated from loan interest and other costs), 300,000 × 3% = ₺9,000. Its annual equivalent is ₺108,000. This cost appears on no invoice; it quietly erodes profit. We explained how to find the financing rate in the article how to calculate the real cost of a business loan, and you can follow its place within overall working capital in the article how to calculate working capital.
Past-due receivables also carry a risk of non-collection. Since the likelihood of collection falls as they age, it is sensible to set an internal provision rule for receivables older than 60 days; the rate of the rule depends on the sector and your own collection history, which is why no fixed rate is given here. When financing cost and non-collection risk are considered together, the value of speeding up collection goes above the ₺9,000 in the example. For terms, reminders and the legal process related to collection, you can look again at the article how to follow up on receivables.
Lesson 7: How do you set up a collection acceleration plan?
In short: First collect half of the receivables more than 30 days past due, then 20% of the receivables 1 – 30 days past due. The period falls from 45 to 37.8 days.
- Half of receivables more than 30 days past due: The 31 – 60 day (₺117,000) and more than 60 day (₺63,000) bands total ₺180,000; these receivables are mostly with M3 and M4. With a payment plan and a shipment condition, half of it, that is ₺90,000, is collected.
- 20% of receivables 1 – 30 days past due: Phone calls and reminders are intensified; 20% of the ₺270,000 band, that is 270,000 × 20% = ₺54,000, is collected.
- Condition before a new shipment: A customer with past-due receivables gets a new shipment only after payment.
- Payment convenience: Options such as a payment link, bank transfer details and virtual POS are offered together with the invoice.
The numerical result of the plan is this: the receivables balance falls to 900,000 − 90,000 − 54,000 = ₺756,000. The new average collection period is 756,000 ÷ 600,000 × 30 = 37.8 days; this is a reduction of 7.2 days. The cash freed is ₺144,000, which means ₺4,320 in financing savings at a monthly cost of 3%.
- Starting receivables balance₺900,000
- Collection from receivables more than 30 days past due−₺90,000
- Collection from receivables 1 – 30 days past due−₺54,000
- New receivables balance₺756,000
Prepared with example values. Total: 900,000 − 90,000 − 54,000 = ₺756,000. New period: 756,000 ÷ 600,000 × 30 = 37.8 days.
Speeding up collection does not happen through reminders alone; the payment method also needs to be made easier. To compare credit card and payment link options, see the article how to choose online collection methods, and for the steps of taking payment by link, see the article how to take payments with Pay by Link. The article how to plan supplier payments is also useful for balancing payment plans and payments to suppliers; because while the collection period shortens, not making supplier payments at the same speed strengthens cash flow.
Recommended readingHow to Track Receivables?Lesson 8: How do you monitor the average collection period?
In short: Monitor five indicators in the same table every month: average collection period, average delay, share of past-due receivables, receivables older than 60 days and financing cost.
| Indicator | How it is calculated | Sample value |
|---|---|---|
| Average collection period | Receivables ÷ Credit sales × Days | 45 days |
| Average delay | Collection period − Payment term | 15 days |
| Share of past-due receivables | Past due ÷ Total receivables | %50,0 |
| Receivables older than 60 days | 60+ day band | 63.000 ₺ |
| Financing cost | Unnecessary receivables × Monthly rate | 9.000 ₺ |
- 45 daysaverage collection period (term 30 days)
- 50%past-due share of receivables
- ₺9,000monthly cost of unnecessarily outstanding receivables
- 37.8 daysperiod after the collection plan
The most important rule in monitoring is to read the period not from a single month but from the trend over several months. If the period lengthens two months in a row, a new customer group, a campaign payment term or a loosening of collection discipline is investigated. If the share of past-due receivables stays high while the period is constant, the problem lies with a single customer group. To read the report in a management meeting, a collection line can be added to the layout in the article how to prepare a weekly management report; to see its effect on cash flow, see the article how to prepare a cash flow statement.
What are the most common mistakes when measuring the collection period?
- Including cash sales in the denominator. The period comes out shorter than it is; only credit sales go into the calculation.
- Taking the wrong receivables balance. Unclosed advance and offset entries in customer and supplier accounts distort the balance.
- Looking only at the average. The average shows 45 days, but two customers pay more than 90 days late.
- Not seeing the term as it really is. The written term may be 30 days while the de facto term is 60 days.
- Not producing an aging table. Old receivables get lost among new ones.
- Not reminding before the due date. Delays caused by forgetfulness cannot be prevented.
- Not calculating the financing cost. The price of delay stays invisible, and collection is not treated as an urgent matter.
How does NetKasam make collection tracking easier?
- Customer and supplier account tracking. You see customer balances and open invoices in the account and separate out those past due (customer and supplier account tracking).
- Invoice tracking. You monitor the status of issued invoices and list unpaid invoices (invoice tracking).
- Online collection. You use credit card payments and the payment link (online collection).
- Cheque and promissory note tracking. You record deferred payments as cheques and promissory notes and monitor their due dates (cheques and promissory notes).
- Cash and bank. You post collections to cash and bank accounts and see the balances.
- Saved reports. You save the monthly report and export it to Excel (reports).
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If the receivables balance is ₺900,000, monthly credit sales are ₺600,000 and the period is 30 days, how many days is the average collection period?
- If the payment term is 30 days and the average collection period is 45 days, how many days is the average delay?
- If credit sales are ₺600,000, the term is 30 days and the period is 30 days, what is the receivables balance expected with on-time collection?
- If unnecessarily outstanding receivables are ₺300,000 and the monthly financing rate is 3%, how many ₺ is the monthly cost?
- If receivables are ₺756,000 and credit sales are ₺600,000 (30-day period), how many days is the new average collection period?
Answer key:
- 900,000 ÷ 600,000 × 30 = 45 days.
- 45 − 30 = 15 days.
- 600.000 ÷ 30 × 30 = 600.000 ₺.
- 300.000 × %3 = 9.000 ₺.
- 756,000 ÷ 600,000 × 30 = 37.8 days.
Frequently Asked Questions About the Average Collection Period
What is the average collection period?
It is the measure showing in how many days, on average, a sale made on credit is collected. It is also known as DSO.
How is the average collection period calculated?
The period-end receivables balance is divided by the period's credit sales and multiplied by the number of days in the period. For example, 900,000 ÷ 600,000 × 30 = 45 days.
Are cash sales included?
No. Sales collected in cash or by card do not create receivables; only credit sales go into the denominator.
What does it mean if the collection period is longer than the payment term?
It means customers, on average, pay after the due date. The difference is the average delay, and it creates a financing cost on outstanding receivables.
What is a receivables aging table?
It is a table in which receivables are divided into bands according to whether they are past due and by how much. It separates old receivables from new ones.
How is the cost of outstanding receivables calculated?
The unnecessarily outstanding receivable amount is multiplied by the monthly financing rate. For ₺300,000 and 3%, it is ₺9,000 per month.
What can be done to speed up collection?
Priority is given to past-due receivables, reminders are sent as the due date approaches, payment channels are made easier, and a new shipment to a past-due customer is made conditional on payment.
How often should these indicators be monitored?
Monthly. The number of past-due receivables, however, should be monitored weekly, because delays accumulate quickly.
Conclusion: Know how many days your money waits with the customer
The most useful thing you can do today is to find the total of open receivables in your customer and supplier accounts and last month's credit sales, and calculate the average collection period. The next step is to divide receivables into bands by due date and look at which customers the past-due receivables are concentrated in. A collection plan focused on a few customers often frees up cash in the first month.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.