Introducing Playbooks. One Place to Teach Stuut How to Run Your AR.

Read More

How collections managers use DSO to identify at-risk accounts and improve collections

Ben Winter
COO
Table of contents

See Stuut in action

Get a personalized demo of Stuut and see how it can help with AR automation.

Get started

TL;DR: Your CFO reviews DSO as a board metric, but for collections managers, it is a daily operational tool for spotting accounts about to go delinquent before they show up in your 60-day aging bucket. By segmenting your portfolio by individual account DSO, tracking shifts over time, and automating routine follow-ups on low-risk accounts, you can redirect your effort toward complex, high-value accounts that actually need human judgment. Stuut customers see an average 37% reduction in past-due AR by combining DSO-driven prioritization with autonomous collections execution.

Your aging report tells you who is already late, but it does not tell you who is about to be late. Most AR teams run their daily workflow out of the aging buckets, chasing the 90-day accounts while the 30-day accounts quietly deteriorate, and by the time those customers appear in your problem list, you have already lost the window to intervene early.

Days Sales Outstanding (DSO) fills that gap. When you track it at the account level rather than the company level, it becomes a predictive tool that reveals which customers are slowing down, which accounts need a phone call today, and which routine invoices an AI can cover so you can focus on the ones that actually require your judgment.

Understanding DSO: A collections manager's guide

The sections below define the core DSO formulas, calculation approaches, and benchmarks your team uses every day.

Setting your DSO target by industry

DSO benchmarks vary by industry, so do not compare yourself to a cross-industry average. Manufacturing and industrial distribution companies typically target DSO between 35 and 50 days. The right target for your portfolio is your payment terms plus the collection lag your team actually achieves. For context on where mid-market companies in your revenue range typically land, the DSO by company size benchmarks break this down by segment.

Optimal DSO calculation frequency

DSO formulas vary depending on the lookback period used for the sales denominator, and this creates real confusion about whether numbers across periods are comparable. The two most common approaches:

  • Monthly snapshot: DSO = (Ending AR / That month's credit sales) x 30. Simple, but distorted by seasonal revenue swings. A low-sales month makes DSO look artificially high.
  • Rolling 30-day: DSO = (Current AR / Credit sales over the last 30 days) x 30. More stable because the sales figure is always a consistent window, which makes month-over-month comparisons meaningful.

For daily operational use, a rolling calculation is often more reliable because it smooths out distortion from monthly sales variance and tells you whether your collection velocity is improving or declining independent of whether your sales team had a strong month. Run the snapshot calculation for board reporting and the rolling calculation for your daily workflow decisions.

DSO support for payment arrangements

When a customer is on a structured payment plan, their account DSO may not function as a typical risk signal. An account making consistent payments against a larger balance according to agreed terms should be tracked separately against the terms of the arrangement rather than triggering outreach based on DSO alone.

DSO's impact on your daily collection tasks

Leadership traditionally views DSO as a CFO metric, but for the collections manager on the ground, it is an early warning system. The daily grind of sending invoices, making calls, matching payments, and chasing short-pays rarely feels connected to that single top-line number, and the disconnect happens because companies track DSO in aggregate.

When your CFO says DSO is 52 days, that figure includes your fastest payers, your most reliable accounts, and your chronic late-payers, all averaged together. The slow accounts hide behind the good ones, and the only way to surface the risk is to disaggregate the number down to the individual account level.

DSO: Spotting at-risk accounts

At the account level, DSO shifts from a lagging performance metric into a leading indicator. For example, an account that consistently paid in 28 days and is now running at 41 days may indicate something changed before that invoice ever goes 30 days past due. It could be an AP contact change, a cash flow problem at the customer, or a dispute they have not bothered to communicate. Either way, you know to act now rather than in three weeks when it shows up in the 60-day bucket, and using DSO to improve collections means treating it as a trend line for each account rather than a static company-wide score.

DSO vs. aging reports: What each reveals

You need both metrics in your workflow, but they answer different questions. The table below outlines when to use each one, along with two other metrics your AR Director may reference in performance reviews.

Metric What it measures Strengths Limitations
DSO Average days to collect a receivable Tracks trends over time, works at account level Large invoices or seasonal sales spikes can distort it
Aging report How long open invoices have been outstanding Shows current overdue balances by bucket Backward-looking only, does not show payment trajectory
CEI (Collection Effectiveness Index) Percentage of collectible AR actually collected in a period Shows team performance against collectible universe Requires accurate identification of disputed vs. collectible invoices
ADD (Average Days Delinquent) Days past due after terms expire Focuses on overdue period only Does not reflect accounts paying slowly but still within terms

Use your aging report for daily prioritization of overdue accounts and use account-level DSO to catch payment slowdowns before they become overdue. Understanding how these metrics work together makes your morning review significantly more targeted.

How to segment your portfolio by DSO

Running DSO as a single company-wide number hides account-level detail. You need account-level detail to make decisions, and segmenting your portfolio by account-level DSO lets you allocate follow-up time based on actual risk rather than invoice age alone.

Measure segment-specific DSO

The standard DSO formula is straightforward: divide your total accounts receivable by total credit sales, then multiply by the number of days in the period.

Standard DSO formula:

DSO = (Accounts Receivable / Total Credit Sales) x Number of Days

The problem is that a single large account paying slowly can inflate your portfolio DSO and make your overall picture look worse than it is. To avoid this, calculate sales-weighted DSO at the segment level by following these steps:

  1. Calculate DSO individually for each account.
  2. Multiply each account's DSO by its share of total AR (its weight).
  3. Sum the weighted values across all accounts in the segment.

The weighted approach prevents a single large account from distorting the segment average. When you segment by industry, by sales region, or by payment terms, the weighted approach gives you an accurate picture of each group's payment behavior rather than a number distorted by your largest accounts. For a step-by-step DSO improvement process, segmented DSO is the foundation of every subsequent action.

Identify high-DSO vs. low-DSO accounts

A practical threshold for high versus low DSO starts with your standard payment terms. Compare each account's actual collection days against your contractual expectation, then flag the gap. Accounts paying well within terms need minimal manual attention, while accounts running significantly beyond terms need active follow-up regardless of where they fall in your aging report. The principle applies whether your terms are Net 30 or Net 60: the gap between contracted terms and actual payment behavior is your risk signal, not the absolute number of days.

Target accounts for fastest DSO reduction

The fastest DSO improvement often comes from high-value accounts with modest delays rather than from pursuing your most severely delinquent accounts. For example, a customer with $200K outstanding and a modest overdue gap may represent far more recoverable cash than a customer with $5K outstanding and a long overdue history. Priority sequence: large balance, small payment gap first, and low balance, large payment gap last. Your DSO benchmarks by company size will help you calibrate what normal looks like for your segment before you start stacking priorities.

Using DSO trends to flag at-risk accounts

The snapshot value of DSO on any given day matters less than the direction of travel. An account whose DSO is rising signals deterioration, while an account whose DSO is declining signals improvement. The trend gives you the signal, and responding to the trend early is what separates proactive collections from reactive invoice chasing.

Interpret DSO shifts to flag risk

When you see a meaningful upward shift in an account's DSO, the first question to ask is whether the shift is tied to a specific invoice or reflects a broader change in payment behavior. For example, an account that historically paid before the due date and is now consistently paying after it may signal that something changed, even if nothing is technically overdue yet. This is the window to make a relationship call rather than a collections call, and the distinction matters for how the conversation lands. "We noticed your recent invoice hasn't cleared. Is there anything we can help resolve?" often surfaces an AP contact change, a system migration, or a budget hold long before it becomes a formal dispute.

DSO red flags for at-risk accounts

Several patterns in your account data commonly indicate a customer is moving toward serious delinquency:

  • Broken promise-to-pay pattern: A customer committed to a payment date and missed it for the second consecutive month.
  • Sudden partial payments: A customer who always paid in full is now sending short-pays without remittance detail.
  • Extended response lag: Contact cadence has stretched from next-day response to several days without acknowledgment.
  • AP contact change without notice: Bounced email addresses on previously reliable accounts indicate internal turnover at the customer.
  • Accelerating DSO: An account's DSO rose significantly in a short period with no change in invoice terms or sales volume.

Flagging at-risk accounts with rising DSO

When an account triggers one of these patterns, log it immediately in your ERP with a risk tag and assign a follow-up task. If your ERP supports customer notes or account annotations, update the field with the date, trigger pattern, and planned action. This creates an audit trail if the account escalates to a credit hold or dispute, and it ensures the situation does not live only in your personal spreadsheet.

Stuut's real-time monitoring detects payment anomalies automatically and alerts your team when patterns that require intervention appear, freeing you from manually scanning the aging report for these signals every morning.

Prioritizing follow-up efforts based on DSO

Not every overdue account deserves the same response. The sections below cover how to triage based on risk, balance, and payment pattern.

Target high-risk accounts with DSO

High-risk accounts, meaning those with rising DSO trends combined with large open balances, require human attention. These are the accounts where a call from someone who knows the relationship is more effective than any automated email. Complex deductions, payment plan negotiations, and accounts approaching credit limit violations all require your judgment, your institutional knowledge of that customer, and your ability to read tone in a conversation.

AI typically requires human judgment for complex disputes involving negotiation or legal escalation. The value of automation is that it clears the routine volume so you have the capacity to handle these accounts properly, which is the actual goal of a well-run AR function.

Identify your top call accounts

A practical framework for determining which accounts need a phone call versus an email:

  • Call: High-balance accounts with rising DSO trends or a missed promise-to-pay.
  • Call: Accounts where the last two email reminders went unanswered.
  • Email: Accounts slightly past due with a strong payment history and consistent response to written reminders.
  • Automated follow-up: Accounts pre-due or minimally overdue, with low balances and a reliable payment pattern.

That last category is where most of your portfolio likely sits, and it is where automation creates the most immediate relief.

Automate routine follow-ups on low-DSO accounts

The accounts in your long tail, the customers you simply do not have time to contact because your team is occupied managing the high-touch accounts, are not inherently risky. Many of them would pay faster with a timely reminder. They go untouched because there are only so many hours in a collections day.

Stuut handles this coverage automatically. The AI monitors invoice due dates, contacts customers before invoices go overdue, and sends reminders across email, SMS, and AI-powered voice. When you arrive each morning, the exception dashboard shows only the accounts that need human attention, because everything routine has already been handled.

This approach enabled Bishop Lifting to manage accounts across 45 branches, resulting in a 35% reduction in overdue receivables and $3M in working capital improvement. The AR team did not shrink. They shifted from covering routine accounts to focusing exclusively on complex and high-value situations.

Translate DSO data into leadership actions

The following sections cover how to present DSO insights to leadership and build a structured improvement plan.

How to present DSO to AR leadership

When you report DSO to your AR Director or Controller, frame it around movement and cause rather than the raw number. The structure that works:

  • Current state: Portfolio DSO is 48 days, up from 43 days last quarter.
  • Root cause: Seven accounts representing 34% of AR balance are driving the increase, concentrated in one segment.
  • Blockers: Three accounts have disputed invoices pending resolution from the sales team. Two have AP contact routing issues.
  • Plan: Resolving the three open disputes would improve DSO based on their share of the overall portfolio balance.

This format shows you understand the drivers, not just the number, and it makes clear what action is needed from whom.

Develop DSO-based action plans

A structured DSO improvement playbook covers six areas:

  1. Identify invoice delivery failures: Confirm invoices are reaching the correct AP contact in the correct format. Delivery failures are the most common and most fixable cause of payment delays.
  2. Clarify payment terms at order entry: Misaligned expectations between what sales promised and what AR invoices for create disputes that inflate DSO. Standardize terms documentation with your sales team.
  3. Segment the long tail: Identify accounts with low balances and a history of slow payment, then assign these to automated follow-up so they do not continue to age without contact.
  4. Escalate stalled disputes: Any dispute that remains unresolved for an extended period needs a cross-functional owner. Flag these to the AR Director with a specific resolution date request.
  5. Revisit credit terms for chronic late-payers: Accounts with DSO consistently far above their payment terms are candidates for shorter terms, prepayment requirements, or reduced credit limits.
  6. Measure on a rolling basis: DSO calculated on a rolling basis rather than at month-end gives you actionable data during the period rather than a post-mortem after it closes.

For more workflow steps, the DSO improvement checklist covers each of these areas in detail.

Quantify collections' financial gains

To translate DSO improvement into a dollar figure your CFO will respond to, multiply your average daily revenue by the number of DSO days reduced. Bishop Lifting demonstrated this directly: by reducing overdue receivables by 35%, the company unlocked $3M in working capital across 45 branches and enabled its team to manage 50% more accounts per employee.

DSO mistakes that slow collections teams

Certain common missteps undermine collections performance. The sections below identify the most costly errors and how to avoid them.

Why company DSO misses risks

A single aggregate DSO figure is one of the most misleading numbers in your reporting package. When you average DSO across all customers, strong payment behavior from your top accounts masks deteriorating behavior in others, and you can report improving DSO at the company level while individual account risk is building underneath it.

Break DSO down by account, by segment, and by payment terms group before drawing any conclusions. The accounts receivable software comparison between major platforms specifically highlights this as a capability gap in older systems.

How neglecting small accounts hurts DSO

The smaller accounts you cannot reach given your team's capacity are a silent DSO drag. They do not generate enough individual urgency to land on your daily call list, but their collective impact on portfolio DSO is real and cumulative. Every week they go without a follow-up is another week of receivables sitting uncollected.

Traditional AR platforms require your team to execute the tasks generated by the system. Stuut is designed to automate outreach across the portfolio because the AI handles outreach autonomously rather than generating a task list for a human to execute, and you can see how this compares in the Stuut vs. HighRadius feature comparison or the Stuut vs. Versapay comparison.

PerkinElmer's experience illustrates the scale of what becomes possible with autonomous coverage. Their team reduced overdue invoices from 50% to 15% in one year and collected $300M.

The danger of stale DSO data

When you calculate DSO from batch-processed cash application, it is always stale. If your team manually matches payments infrequently, your DSO figure may not reflect recent payment activity, which means you might follow up on an invoice that was already paid or miss an account whose payment just bounced.

Stuut's cash application matches incoming payments to open invoices in real time and posts entries back to your ERP immediately, achieving a 95%+ automated match rate in typical implementations. Your DSO calculation reflects current payment activity, so your prioritization decisions at the start of each day are based on current data.

Book a demo with the team to see how Stuut handles routine account follow-ups autonomously and gives your team real-time DSO visibility across the full portfolio. To see what a full deployment looks like in practice, read how Bishop Lifting reduced overdue receivables by 35% and improved cash flow across 45 branches in six weeks.

FAQs

What is the standard formula for calculating DSO?

DSO = (Accounts Receivable / Total Credit Sales) x Number of Days in the period. A rolling calculation based on recent sales activity can help smooth distortion from monthly sales variance.

What is a good DSO target for manufacturing and distribution companies?

Manufacturing and distribution companies typically target DSO between 35 and 50 days, depending on standard payment terms. If your DSO is running significantly above your stated payment terms, that gap represents collectible cash you can recover through improved follow-up coverage.

How much does Stuut typically reduce past-due AR for customers?

Stuut customers see an average 37% reduction in past-due AR, and Bishop Lifting reduced overdue receivables by 35% within six weeks of go-live. Results vary by portfolio mix and existing AR process maturity, and averages are calculated across Stuut's live customer base.

How long does it take to integrate Stuut with an existing ERP?

Stuut integrates via API without modifying your ERP configuration and completes standard onboarding in 3 to 4 days, with full go-live within 6 to 10 days. Integration timing depends on data quality and configuration complexity.

Key terms glossary

Days Sales Outstanding (DSO): The average number of days it takes to collect payment after a sale is made, calculated as (AR / Credit Sales) x Days. Tracked at the account level, it reveals payment trend changes before invoices become overdue.

Sales-weighted DSO: A variation of standard DSO that weights each account's DSO by its share of total AR, preventing large accounts from distorting the portfolio average and giving a more accurate picture of each customer segment's payment behavior.

Cash application: The process of matching incoming customer payments to the correct open invoices in the ERP and posting them to the AR subledger. Manual cash application is a common source of stale DSO data and month-end close delays.

Aging bucket: A grouping of open invoices by how long they have been outstanding (0 to 30 days, 31 to 60 days, 61 to 90 days, 90+ days). Aging buckets show current overdue status but do not reveal whether an account's payment behavior is improving or deteriorating.

Ben Winter

COO

Ben brings over a decade of go-to-market and operations expertise to building AR automation that actually works. He was VP Marketing at Fairmarkit (where he met Tarek) and GTM executive at Waldo before co-founding Stuut. He focuses on operations, product, and marketing—ensuring the platform integrates seamlessly with existing ERP systems and delivers results in days rather than months.

Frequently asked questions  about DSO

Is a higher or lower DSO better?
Lower is better because it means cash reaches your account faster. A DSO of 35 days is better than 55 days if your payment terms are the same.
Does DSO include current AR?
Yes. DSO reflects the total dollar amount you're owed from outstanding invoices, including invoices that aren't yet due.
How does bad debt affect DSO?
Writing off bad debt reduces your AR balance, which artificially lowers DSO even though no cash was collected. Ensure your AR figure is net of bad debt reserves for accurate measurement.
Should I calculate DSO monthly or annually?
Both. Annual DSO tracks long-term trends, while monthly DSO helps you spot process problems quickly and take corrective action before they compound.
What's the difference between DSO and CEI?
DSO measures collection speed in days. CEI measures collection quality as a percentage. A company can have low DSO but poor CEI if they're writing off accounts aggressively.
Can I reduce DSO without upsetting customers?
Yes. Proactive communication before due dates, helpful reminders, and fast dispute resolution improve customer experience while accelerating payment.

Related posts

Setup time to learn more