Skip to content
Efidis
Efidis

Customers and salesUpdated 12 min read

What getting paid late costs: DSO and a collections plan

3D illustration of a neighborhood shop, delivery boxes and an invoice beside a lilac hourglass representing the wait for payment.
In this article

For every

$100

you are owed

you really keep

$68

Where the other $32 go each year

  • $24InterestFinancing receivables at 24% a year
  • $7Invoices never paid1% of credit sales (Atradius, 2026)
  • $1Hours chasing payments29.5 hours a month at 10 per hour
  • $32Lost per year160,000 on 500,000 in receivables (example)

Selling on terms means lending your customer money interest-free. Until the invoice is paid, someone is financing that sale: your cash, your credit line or your own supplier. This article puts numbers on that loan and gives you four tools: the DSO formula, the cost of each day an invoice is late, an accounts receivable aging template and a collections playbook with messages you can copy.

Every figure in the examples is illustrative and has no currency: swap in your own. Figures from studies come with their source and year.

Late payment is the rule, not the exception

Atradius's 2026 Payment Practices Barometer for North America found that seven in ten companies deal with customers who pay late, and that overdue invoices average 23% of B2B receivables. In the US alone, it's 22%. The same study has some good news: most overdue invoices get paid within a month of the due date. What you chase in the first few weeks comes in; what you let age comes in far less often.

Latin America looks worse. Coface's 2026 payment survey for the region, published in June, found that 79% of companies experienced late payments over the past year (up from 77% in 2025). The average credit term was 56 days, and customers paid an average of 33 days past that. A typical invoice took close to three months to turn into cash.

The takeaway isn't to stop offering terms. Atradius reports that North American companies make 43% of their B2B sales on credit; it's part of selling to other businesses. The takeaway is to measure what it costs you and to have a method for collecting before the invoice gets old.

Step 1: calculate your DSO

Days sales outstanding (DSO) tells you how many days, on average, it takes to collect on a credit sale. The standard formula is:

DSO = ending accounts receivable ÷ credit sales for the period × days in the period.

  • Ending accounts receivable: what customers owe you on the last day of the period, overdue or not.
  • Credit sales: only sales invoiced on terms. Leave out cash sales; they'd lower the number without you collecting any faster.
  • Days in the period: 30 for a month, 90 for a quarter, 365 for a year. Use the same period for sales.

Worked example

A distributor (example) made 900,000 in credit sales over the last 90 days and has 500,000 in receivables today. Its DSO is 500,000 ÷ 900,000 × 90 = 50 days. Its terms are net 30, so on average it collects 20 days later than agreed.

To read the result, compare it with your terms, not with other companies. A Commerce Bank guide (2026) offers a rule of thumb: DSO should land within 5 to 10 days of your standard terms. On net 30, anything under 40 is fine; 50 means somebody isn't following up.

One caveat: DSO also moves with sales. Sell less and it rises even if you collect at the same pace. Calculate it monthly and watch the trend.

Step 2: what each day of delay costs you

Receivables that haven't come in are financed by something. If you carry a working capital loan, a line of credit or a business card balance, that rate is your cost. If you have no debt, use what the cash would earn in a safe investment, or the early-payment discount a supplier would give you. The daily cost formula is:

Cost per day = receivables × annual rate ÷ 365.

For the distributor in the example, at 24% a year (example; plug in the APR on your own borrowing): 500,000 × 0.24 ÷ 365 = 329 a day. Over a year, that's about 120,000 in interest for carrying those receivables.

The distributor's bill (example)

Credit sales in 90 days
900,000
Receivables outstanding today
500,000
Days sales outstanding
50 days
Agreed payment term
30 days
Days collected late
20 days
Annual rate on the credit line
24%
Cost per day of that balance
329
Interest per year from late payment
120,000
Illustrative figures, no currency. Swap in your own and the bill works the same way.

More useful than the total is how much cash you free up by cutting days. The example's daily credit sales are 900,000 ÷ 90 = 10,000. Every day of DSO you cut is 10,000 that lands in the bank and stays there. If the distributor goes from 50 to 35 days, it frees up 150,000 once and saves 150,000 × 0.24 = 36,000 a year in interest.

MetricFormulaExample
Credit sales per dayCredit sales ÷ days900,000 ÷ 90 = 10,000
DSOReceivables ÷ credit sales × days500,000 ÷ 900,000 × 90 = 50
Cost per dayReceivables × rate ÷ 365500,000 × 0.24 ÷ 365 = 329
Cash freed by cutting 15 daysDays cut × sales per day15 × 10,000 = 150,000
Annual interest savedCash freed × rate150,000 × 0.24 = 36,000

And that's only the interest. It leaves out the invoice that never gets paid: Atradius reports that US companies often write off 1% to 2% of their B2B invoices as bad debt (2026). It also leaves out the hours someone spends chasing payments, and the order you couldn't fill because there was no cash to restock.

Step 3: build your accounts receivable aging report

DSO is an average, and averages hide the problem. An accounts receivable aging report shows it: one customer per row, with their balance split by how old the invoices are. This template ages by invoice date. On net 30, the 0–30 column is current and everything else is past due. If your terms differ, shift the buckets.

Customer (example)0–3031–6061–90Over 90Total
Customer A100,00020,00000120,000
Customer B60,00030,0000090,000
Customer C45,00025,00020,000090,000
Customer D70,00020,0000090,000
Customer E10,00015,00030,00055,000110,000
Total285,000110,00050,00055,000500,000
% of total57%22%10%11%100%

How to read it

  • Start with the over-90 column. In the example, a single customer holds all of it. Before you extend that customer more credit, they need a payment plan.
  • Next, look for customers in two or more past-due buckets (C and E). They're falling behind; they didn't just miss one invoice.
  • Compare the past-due share with last month. Here it's 43% (110,000 + 50,000 + 55,000 out of 500,000). If it rises two months in a row, the problem is your process, not one customer.
  • Sort by the oldest bucket, not by total balance. The customer with the biggest balance is usually your best buyer, not your worst payer.

To build it, you need a list of open invoices with customer, invoice date and remaining balance. From there, a spreadsheet can calculate each invoice's age (today minus the invoice date) and drop it in the right bucket. The formula is the easy part. The hard part is keeping the list current: every payment that doesn't get posted means calling a customer who already paid. To keep payments up to date, reconcile the bank against your invoices; to review receivables every week alongside sales and cash, use the Monday dashboard.

Step 4: a staged collections playbook

Collecting shouldn't depend on someone remembering. A playbook spells out what happens at each stage, through which channel and who does it. Here are five steps with sample messages; adjust the days to your terms and the tone to your customer.

  1. 3 days before the due date: a text or WhatsApp reminderThis isn't collections; it's service. The account owner sends it. Message: "Hi [name], quick reminder that invoice [number] for [amount] is due on [date]. If you need a copy or our payment details, I can send them right here. Thanks!"
  2. 1 day past due: an email noticeSend it to the accounts payable contact with the invoice attached. Subject: "Invoice [number] due [date]". Body: "Hi, we haven't received payment yet for invoice [number] for [amount], which was due yesterday. The invoice and our payment details are attached. If it's already been sent, could you forward the remittance so we can apply it?"
  3. 7 to 15 days past due: a phone call and a payment dateA call, not another message. The goal is to hang up with a specific date and amount. Confirm it afterward in writing: "[Name], thanks for your time today. Just confirming you'll send [amount] for invoice [number] on [date]. I'll check in that day."
  4. 30 days past due: a formal notice and credit on holdAn email signed by the owner or the AR lead: "Hi, invoice [number] for [amount] is now 30 days past due. Until the balance is current, new orders will ship on prepayment. We'd like to work this out: can we set up a payment plan this week?" Give the sales rep a heads-up before it goes out.
  5. 60 to 90 days past due: a written payment plan or outside collectionsEither you sign a plan with dates and amounts, or the account goes to an attorney or a collection agency. Message: "Hi, the balance of [amount] is now [days] days past due. If we don't have a signed payment plan by [date], we'll refer the account to an outside agency." Only send it if you'll follow through.

Two rules make the playbook work. First, every message includes the invoice number, amount and date, so the customer doesn't have to look anything up. Second, the sales rep knows what stage each customer is in before the visit. Nothing strains a relationship faster than a rep taking an order the same day AR puts the account on hold.

How many hours manual collections cost

Interest isn't the only cost. Someone matches bank payments to invoices, sends the reminders and calls the customers who owe. With 120 customers on terms (example), a normal month looks like this:

TaskBy handWith a system and AI
Matching payments to invoices120 invoices × 5 min = 10 hReviewing what the system couldn't match: 1 h
WhatsApp and email reminders120 customers × 2 reminders × 3 min = 12 hSent automatically: 0 h
Calls to late payers40 customers × 15 min = 10 hAI makes the calls; your team handles 6 cases × 15 min = 1.5 h
Total per month32 h2.5 h

That frees up 29.5 hours a month. If an hour of the collector's time costs the company 10 (salary plus benefits and payroll taxes, divided by monthly hours), that's 29.5 × 10 × 12 = 3,540 a year, before the interest from step 2.

A system can run steps 1 to 3 of the playbook on its own: the WhatsApp reminder, the email notice and the first call, which an AI voice agent can already make. Steps 4 and 5 need a person, because putting credit on hold or sending an account to collections changes the relationship with the customer.

Step 5: before you extend credit to a new customer

The best overdue invoice is the one you never create. According to Atradius, around one in five North American companies protects itself with credit insurance or bad debt reserves (Atradius, 2026); if you have neither, your only filter is the one you apply when you open the account. Use it when raising a credit limit, too:

  • You verified the legal name, tax ID and that the business is in good standing with the state or public registry.
  • You called two trade references and asked how much credit they extend, on what terms and whether the customer pays on time.
  • You pulled a business credit report, with the customer's written authorization where required.
  • You asked for recent financial statements if the requested limit is large relative to your monthly sales.
  • You set a low starting limit and short terms, with a review at three months based on payment history.
  • The terms are signed: payment terms, credit limit, late fees where your state allows them and what happens if they fall behind.
  • You have the name, email and phone number of the person who pays, who is rarely the person who buys.
  • You know how they want invoices: whether they require a PO number, a signed handover document, a supplier portal or a cutoff date.
  • You decided on security based on the limit (a personal guarantee, a letter of credit or a deposit) and have it signed.
  • There's a record of who approved the credit and based on what.

Item 8 heads off late payments nobody intended: an invoice without a PO number or past the cutoff rolls into the next payment run and adds 30 days.

When the playbook isn't worth setting up

Measuring and collecting in stages takes someone's time. Don't set up the whole thing if:

  • You sell almost everything for cash or prepayment. With no receivables there's nothing to chase; checking the few credit accounts by hand is enough.
  • You have few customers on credit and they all pay on time. Calculate DSO every quarter and come back to the playbook if it rises.
  • The delays come from a single very large customer. A conversation with management and a written payment agreement will do more than a sequence of messages.
  • Your financing rate is low and delays are short. The cost per day may be lower than the hours of whoever collects: run the numbers before adding work.

Why your receivables age even when you collect

When DSO creeps up, the cause is usually inside the company, not the customer. These three come up most often:

  • Invoices go out late. If you bill two weeks after delivery, the clock starts two weeks late. Track the days between delivery and invoice. If you work by site visits, invoice from the signed service order the same day.
  • Nobody owns collections. When AR belongs to everyone, the step 1 reminder never goes out and the first contact happens at 30 days.
  • Sales reps can't see receivables. They keep selling on terms to a customer with 90-day invoices because that information lives in someone else's spreadsheet.

All three come down to timely information: invoices generated at delivery, an open-invoice list updated with every payment, and each customer's balance in front of whoever visits them. Run the numbers on this month: calculate your DSO, multiply your receivables by your rate and divide by 365. That's the daily cost of changing nothing. If invoices go out late because someone retypes the order, start with what manual data entry costs.

Sources

  1. Coface, "Latin America: companies are tightening credit in the face of rising late payments" (2026 payment survey), 2026 (opens in a new tab)
  2. Atradius, "B2B payment practices trends in North America 2026" (Payment Practices Barometer), 2026 (opens in a new tab)
  3. Atradius, "B2B payment practices trends in the US 2026," 2026 (opens in a new tab)
  4. Commerce Bank, "Days Sales Outstanding: Definition, formula and how to reduce it," 2026 (opens in a new tab)
See how we work in route-based distribution

Frequently asked questions

Get paid sooner, without chasing customers

Efidis builds your company's app so reps know who owes what before they take the next order. On the call we'll look at your aging report and where collections slow down.