Cash doesn't flow automatically when customers say "yes"—it flows when customers actually pay. And between the invoice date and the bank deposit, your cash sits trapped in accounts receivable. For most small business owners, this waiting period is where profitability quietly evaporates.
An aging report tells you how long invoices have been outstanding. A collections strategy tells you what to actually do about it. The gap between the two is where most businesses lose 10-15% of their annual cash flow.
What is AR Aging and Why It Matters More Than You Think
An accounts receivable aging report categorizes your outstanding customer invoices by time periods since their due dates:
- Current: Due within 30 days (or not yet due)
- 30 days past due: 31-60 days overdue
- 60 days past due: 61-90 days overdue
- 90+ days past due: More than 90 days overdue
These buckets tell you immediately which customers need urgent attention versus which are on track. But here's what most owners miss: an aging report only tells you what happened. It doesn't tell you why payment was delayed, which accounts are becoming riskier, or what your team should do next.
According to recent data, 56% of U.S. small businesses report invoices overdue by more than 30 days. For businesses with thin margins—contractors, service providers, small manufacturers—a 60-day delay on a $10,000 invoice can force you to borrow against a line of credit just to meet payroll.
From Invoice to Cash: Understanding Days Sales Outstanding
The aging report is a snapshot. Days Sales Outstanding (DSO) is the metric that drives behavior change.
DSO measures how many days it takes your business to collect payment after a sale. The formula is simple:
DSO = (Accounts Receivable / Total Credit Sales) × Number of Days in Period
For example, if you have 100,000 (annualized $1.2M), your DSO is:
(100,000) × 30 = 15 days
If that same business has 50,000, DSO jumps to 30 days. Same AR balance, half the revenue—now you're waiting twice as long for payment.
Why DSO Matters More Than AR Turnover Ratio
Accounts receivable turnover is the inverse metric:
AR Turnover = 365 / DSO
If your DSO is 45 days, your turnover is 8.1 times per year. A turnover of 8x sounds healthy. But when you say "our DSO is 45 days," suddenly the cash-flow reality hits: customers take 6 weeks to pay.
DSO is the metric that connects to your bank account. It's the number your lender cares about. It's the number that determines whether you need working capital financing or not.
According to recent industry data:
- The median DSO across B2B businesses is 56 days
- A healthy DSO for most small businesses is 30-45 days
- An AR turnover ratio above 7 reflects efficient collections; below 5 means your process needs work
The wider the gap between your payment terms and your actual DSO, the larger your working capital problem. If you offer Net-30 but collect in 56 days, you're funding your customers' cash flow for an extra 26 days per cycle.
Building an Effective Collections Strategy: Beyond Automated Reminders
The moment an invoice is due—not 7 days after, not 14 days after—your collections process should activate. Here's a collections schedule that works:
Day 0-1 (Due Date)
Send a courteous automated payment reminder with the invoice number, amount, due date, and payment options. This catches the 10-15% of invoices missed due to inbox clutter, not unwillingness to pay.
Day 7-10 (First Follow-Up)
Send a friendly but direct email. Use a tone that assumes the customer forgot, not that they're avoiding you. Include a phone number and ask if there are any issues with the invoice. This catches disputes, billing questions, and payment authorization problems before they turn into 60-day delays.
Day 30-45 (Second Follow-Up)
Shift to a firmer tone. Reference your previous communication and ask for a specific payment date—not "when can you pay?" but "I expect payment by [specific date]." Escalate to the customer's owner or CFO if needed.
Day 60+ (Third Follow-Up)
Make a phone call. Not an email. Disputes that are 60+ days old rarely resolve themselves, and email stops working at this point. Discuss payment plans, payment allocation to older invoices, or a credit hold on new orders until the account is settled.
Day 90+ (Collections or Write-Off)
Evaluate whether to refer to a collection agency (typically costs 25-50% of the collected amount) or write off the bad debt for tax purposes. Most businesses should cut the cord by 90 days or escalate to legal action.
This schedule is consistent, not optional. The companies that reduce DSO by 40% don't do it through automation alone—they do it through discipline. They follow the schedule even when the customer calls and promises to pay "next week." They know that 26 follow-ups beats 1 professional reminder service.
The Data Inside Your Aging Report
Once you have aging data, use it to:
Identify at-risk customers: If a customer with a $50,000 annual contract is 45+ days past due, this is not a "collection issue"—it's a credit risk. Consider limiting future orders to prepayment or COD.
Segment your collection efforts: Customers past 30 days need phone calls. Customers past 60 days need escalation. Customers who are consistently on-time need you to leave them alone and invest your energy elsewhere.
Project cash flow: If 40% of your annual revenue is currently 30+ days past due, you can't budget for next month until you resolve it. Your DSO tells you how many days of operating expenses you need to fund from cash reserves or credit lines.
Spot industry patterns: Construction customers might consistently run 45-60 days late because that's when their own customers pay them. Retail customers might be faster. Tech startups might be slower. Once you understand the pattern, you can adjust payment terms at the contract stage instead of chasing collections afterward.
The Accounting Treatment of Doubtful Accounts
From a bookkeeping perspective, uncollectible receivables need accounting treatment:
- Allowance for doubtful accounts: Each period, estimate what percentage of AR will never be collected (typically 1-5% depending on industry and aging pattern) and record an expense for that amount. This more accurately represents your real cash position.
- Write-off: When a debt becomes uncollectible, write it off against the allowance. This clears the AR from your balance sheet.
- Tax deduction: Businesses using the accrual method can deduct bad debts if they've previously included them in income. Cash-method businesses can't deduct them (because they never included the income in the first place).
A business that collects 95% of invoiced revenue on the accrual method is different from one that collects 90%. The 5% miss means you're carrying dead AR on your books, overstating profitability on paper while understating cash on hand.
Automation That Actually Works
Aging reports and collection workflows should be automated. Your accounting system should automatically:
- Generate an aging report weekly or daily
- Flag customers who slip past their due date
- Send templated follow-up emails on schedule
- Track responses and touchpoints so you know which customers have been contacted and when
But automation is a tool, not a strategy. A business that sends 5 automated reminders to someone who has no intention of paying is wasting time. The businesses that win on collections do the hard work: they call customers, they negotiate payment plans, they identify bad customers early and adjust terms, and they have owners or CFOs reviewing the aging report weekly—not monthly.
Forecasting with Confidence: Using DSO to Project Cash
If your DSO is 45 days, every dollar of revenue takes 45 days to become cash. For a business doing $50,000 in monthly revenue, this means:
- Month 1 revenue ($50,000) won't fully convert to cash until 45 days into Month 2
- You're funding payroll from Month 2 revenue while still waiting on Month 1 cash
- Operating a seasonal business with 50% of revenue in Q4? Your Q1 payroll depends on Q4 being collected
DSO is the bridge between accrual accounting (which your business runs on) and cash accounting (which your bank cares about). If you don't know your DSO, you're flying blind on working capital.
Keep Your Finances Organized from Day One
Cash flow management starts with clear invoicing, consistent follow-up, and honest aging analysis. Beancount.io's plain-text accounting approach gives you complete transparency over what's been invoiced, what's been collected, and what's at risk. With version control baked in, you have a permanent record of when each invoice was due, when payment arrived, and what adjustments were made.
Plain-text accounting forces you to face your AR aging honestly—there's no hiding slow collections in a fuzzy accounting system. Get started with Beancount.io and build a business that gets paid on time.