AR Aging: The Cash You Earned but Can't Spend

You closed the deal, delivered the work, and sent the invoice. On paper, you made money. In your bank account, nothing changed. That gap between invoiced revenue and collected cash is where working capital disappears.

According to CFO Dive, average days sales outstanding (DSO) has climbed to 59 days across industries. That means the typical business waits nearly two months after invoicing before cash arrives. For finance teams managing payroll, vendor payments, and growth investments, those 59 days aren’t just a metric. They’re a liquidity problem.

Your accounts receivable aging report holds the answer to how much cash is stuck and where to focus collection efforts. But most finance teams treat it as a backward-looking scorecard rather than an operational tool for freeing working capital.

What Your AR Aging Report Actually Tells You

An AR aging report groups outstanding invoices by how long they’ve been unpaid. The standard buckets are Current (not yet due), 1 to 30 days past due, 31 to 60, 61 to 90, and 90-plus. Most accounting systems generate this automatically, but the value isn’t in the report itself. It’s in knowing what to do with it.

The distribution matters more than the total. A company with $500,000 in receivables might look healthy. But if $150,000 of that sits in the 61 to 90 day bucket and another $80,000 is past 90 days, nearly half of that “revenue” is at serious collection risk.

According to Resolve, companies that maintain AR over 90 days above 22% of total receivables experience write-off rates three to four times higher than those with better aging profiles. The aging distribution is a leading indicator of bad debt, not a lagging one.

Here’s what each bucket should trigger:

• Current: No action needed, but verify invoices were received and acknowledged
• 1 to 30 days: Automated reminder. Confirm the customer received the invoice and has no disputes
• 31 to 60 days: Direct phone call. Loop in the account manager. Something is wrong
• 61 to 90 days: Escalate to AR manager. Negotiate a payment plan if needed
• 90-plus days: Executive review. Assess whether this receivable is realistically collectible

The mistake most teams make is treating every bucket the same. A friendly reminder at 45 days requires a different tone, urgency, and contact person than one at 15 days.

Why Does DSO Keep Rising?

DSO isn’t climbing because customers suddenly decided to pay slower. It’s climbing because of process gaps on both sides of the invoice.

Invoicing delays create collection delays. If your team takes five days after project completion to send an invoice, you’ve already added five days to your DSO before the payment clock even starts. In our experience working with mid-size businesses, late invoicing is the single most common and most fixable contributor to high DSO.

Unclear payment terms cause confusion. When the contract says Net 30 but the invoice doesn’t specify a due date, customers default to their own payment cycle. For many large buyers, that cycle is 45 to 60 days regardless of what your terms say. The gap between your terms and their behavior is pure DSO inflation.

Inconsistent follow-up lets invoices age silently. Without a structured collection cadence, overdue invoices pile up until someone notices during month-end close. By then, a 15-day overdue invoice has become a 45-day problem, and the collection conversation is harder.

Disputes sit unresolved. A customer withholds payment because one line item is wrong. Instead of resolving the dispute and collecting the undisputed portion, the entire invoice ages. One $200 dispute can freeze a $20,000 payment for weeks.

The Compounding Cost of Aging Receivables

Every day an invoice ages past its due date costs more than the previous day. The relationship between aging and collectibility isn’t gradual; it falls sharply after 90 days.

According to Resolve, roughly 70 to 80% of invoices aged 90 days past due are still collectible. That sounds reasonable until you see the trajectory: at six months, collectibility drops to 45 to 55%. At twelve months, it’s 20 to 30%. Write-off rates jump from 15 to 25% at the 90-day mark to 40 to 60% beyond 120 days.

Consider a company with $2 million in total receivables and this distribution:

Bucket	Amount	Est. Collection Rate	Expected Cash
Current	$1,000,000	98%	$980,000
1-30 days	$400,000	95%	$380,000
31-60 days	$300,000	85%	$255,000
61-90 days	$200,000	75%	$150,000
90+ days	$100,000	50%	$50,000
Total	$2,000,000		$1,815,000

That $185,000 gap between what you invoiced and what you’ll likely collect isn’t visible on your income statement until you write it off. But it’s real, and it’s already affecting your cash position.

The cost goes beyond bad debt. While that cash sits in receivables, you’re financing your operations from other sources. If you’re drawing on a credit line at 8% to cover the gap, $500,000 in overdue receivables costs you $40,000 per year in interest alone.

How Fast Should You Follow Up on Overdue Invoices?

Speed is the single biggest lever in collections. Contact within 24 hours of a missed payment has a 65% success rate. At three days, that drops to 45%. At seven days, 30%. By fourteen days past due, the success rate falls to just 15%. Every day of delay makes the next conversation harder and the outcome less certain.

This doesn’t mean aggressive calls on day one. It means a structured, predictable cadence:

1. Day 1 past due: Automated payment reminder with invoice attached. Polite, factual, no urgency language
2. Day 7: Second reminder. Ask if there’s a reason for the delay. Provide payment options
3. Day 14: Phone call from AR staff. This is a conversation, not a demand. Identify blockers
4. Day 21: Escalation email copying the account manager and customer’s procurement lead
5. Day 30: AR manager calls. Discuss payment plan if the full amount is a problem
6. Day 45-plus: Review the account for credit limit adjustment and consider involving leadership

A cadence that runs consistently trains customers to expect follow-up and prioritize your invoices. Sporadic outreach signals that late payment carries no consequences.

Five Controls That Actually Reduce DSO

Reducing DSO isn’t about working harder on collections. It’s about fixing the upstream problems that create aging receivables in the first place.

1. Invoice on completion, not on a schedule. If you batch invoices weekly or monthly, you’re building DSO into your process. Invoice the day the work is done or the goods ship. For recurring services, invoice on the first business day of the billing period, not the last.

2. Validate invoices before sending. The number one reason customers delay payment is invoice disputes: wrong PO number, incorrect billing address, missing line items. Review invoices against the contract and purchase order before they go out. A five-minute check saves weeks of aging.

3. Offer early payment incentives. A 2% discount for payment within 10 days (2/10 Net 30) sounds expensive until you calculate the alternative. If your average invoice ages to 55 days and you’re financing that gap at 8%, the cost of waiting exceeds the discount. Early payment incentives shift cash collection forward by 20 to 40 days for participating customers.

4. Run credit checks before extending terms. New customers, customers with a history of late payment, and customers in volatile industries should start with shorter terms or prepayment requirements. Adjust terms based on actual payment behavior, not relationship length.

5. Separate dispute resolution from payment collection. When a customer disputes one line item on an invoice, collect the undisputed amount immediately. Don’t let a $500 discrepancy freeze a $15,000 payment. Track disputes separately and resolve them on their own timeline.

Reading Your Aging Report: What to Prioritize

Your AR aging report is only useful if it drives action. Here’s a framework for turning the report into a weekly operating rhythm.

Start with concentration risk. If three customers represent 60% of your receivables, your cash position depends on their payment behavior. Flag any high-concentration customer that moves from Current to 1 to 30 days. Their invoices get priority attention.

Watch for bucket migration. The most dangerous signal isn’t a large 90-plus balance. It’s a growing 31 to 60 day bucket. That means invoices that should have been collected are aging, and today’s 31-day problem becomes next month’s 61-day problem. Track the trend, not just the snapshot.

Compare aging to terms. A customer on Net 60 terms showing up in the 1 to 30 bucket isn’t overdue. A customer on Net 15 in the same bucket is already a problem. Your aging report should adjust for contractual terms, not just invoice date.

Flag repeat offenders. Some customers pay late systematically. They aren’t having cash flow problems. They’re managing their own working capital at your expense. These customers need a terms conversation, not a collections call. Consider adjusting their credit terms, requiring deposits on new orders, or adding late payment fees to future contracts.

Review write-off history. If you’re writing off receivables from the same customer segment, industry, or deal type, the problem isn’t collections. It’s your credit approval process. Use aging data to refine who gets credit and on what terms.

Frequently Asked Questions

What is a good DSO for a business?

A DSO of 30 days or less is considered efficient for most B2B companies, meaning cash arrives within one billing cycle. However, “good” depends on your industry and payment terms. The real benchmark is how your DSO compares to your stated terms. If you offer Net 30 and your DSO is 55, you’re collecting 25 days late on average, which signals process gaps.

How often should you review your AR aging report?

Weekly is the minimum for companies with consistent invoice volume. The aging report drives collection actions, and reviewing it monthly means overdue invoices have already aged an additional 30 days before anyone notices. Pair the weekly review with a structured follow-up cadence so the report triggers action, not just awareness.

What percentage of receivables past 90 days becomes uncollectible?

Write-off rates for invoices past 90 days typically range from 15 to 25%. Beyond 120 days, that rate jumps to 40 to 60%. At twelve months past due, only 20 to 30% of outstanding invoices are realistically collectible. The steep drop-off after 90 days is why early, consistent follow-up matters more than aggressive late-stage collection efforts.

How do early payment discounts affect working capital?

A standard 2/10 Net 30 discount (2% off for payment within 10 days) costs about 36% annualized if every customer takes it. But most companies see 20 to 40% participation rates, and the cash acceleration benefit often outweighs the discount cost. For businesses financing receivables through credit lines at 8 to 12%, the math usually favors the discount.

What causes DSO to increase even when sales are stable?

Rising DSO with stable sales usually points to process issues: invoicing delays, unresolved disputes freezing payments, inconsistent collection follow-up, or customer mix shifting toward slower-paying accounts. It can also signal that your payment terms are misaligned with customer expectations. The fix is almost always operational, not financial.

How Tier2 Keel Tracks Receivables from Invoice to Settlement

The collection gaps described above often start with disconnected systems. When invoicing lives in one tool, payment tracking in another, and aging reports in a spreadsheet, the delays between them create the blind spots where receivables age unnoticed.

Tier2 Keel manages the full billing lifecycle in a single system. When you create an invoice, the system starts tracking its aging immediately. Payment terms are set per customer, so your aging report reflects actual contractual due dates rather than a generic 30-day assumption. When payments arrive, they’re matched to invoices automatically, and the aging report updates in real time.

Because Keel connects invoicing to the rest of your business operations (projects, contracts, service delivery), your finance team can see not just what’s overdue but why. If a customer is withholding payment because of a service dispute, that context is in the same system, not buried in someone’s email.

See how Keel handles billing and settlement or book a walkthrough with our team.

The next time you pull your AR aging report, don’t just scan the totals. Look at the distribution across buckets, identify which invoices migrated from last week, and check whether your follow-up cadence matches what each bucket actually requires. That cash is already earned. The question is how quickly you collect it.