Collections on a Connected Ledger: Turning AR Aging Into Cash You Can Forecast

Collections management is the process of getting customers to pay invoices on time: setting credit terms, sending reminders, escalating overdue accounts and recording promised payment dates. It is measured through days sales outstanding (DSO) and the accounts receivable aging report, and it feeds the cash forecast with expected inflows.

An aging report tells you what is already late. A collections process run well tells you when cash will actually arrive, which is the number the cash forecast needs.

How DSO and aging work

Days sales outstanding (DSO) = accounts receivable / credit sales for the period × days in the period. It estimates how many days, on average, it takes to collect a sale.

Best possible DSO = current (not yet due) receivables / credit sales × days. It is the DSO you would have if every customer paid exactly on terms.

Average days delinquent = DSO − best possible DSO. This isolates the part of DSO caused by late payment rather than by your payment terms.

The aging report groups open invoices by days past due, usually current, 1–30, 31–60, 61–90 and over 90. In QuickBooks Online this is the A/R Aging Summary or Detail report.

DSO on its own can mislead. A large sale at quarter end raises receivables and DSO even if every customer pays on time, and a slow quarter of sales can make DSO look worse when collections have not changed. Reading DSO next to best possible DSO and the aging buckets avoids most of those traps. Our free DSO calculator runs these numbers from your aging totals.

Why it matters now

Late payment is getting more common for small businesses. The Intuit QuickBooks 2026 Small Business Late Payments Report found that 59% of businesses have invoices overdue by 30 days or more, up from 47% the year before, and that businesses with unpaid invoices are owed $17.7K on average.

The cash impact shows up in the Federal Reserve Banks' 2025 Report on Employer Firms. In the 2024 Small Business Credit Survey of 7,625 employer firms, 51% cited uneven cash flow as a financial challenge, up from 44% in 2023; the survey's definition of uneven cash flow includes collecting on receivables.

Example: Northfield Components (hypothetical)

Northfield Components is an illustrative company, not a real one. It sells on net-30 terms. Credit sales for the last quarter (90 days) were $4,500,000, and receivables at quarter end were $1,500,000.

DSO: $1,500,000 / $4,500,000 × 90 = 30 days.

Best possible DSO: current receivables of $900,000 / $4,500,000 × 90 = 18 days.

Average days delinquent: 30 − 18 = 12 days. On net-30 terms, a 30-day DSO looks fine, but 12 of those days come from customers paying late.

To turn the aging into a forecast, apply a collection rate to each bucket for the next 30 days. The rates below are assumptions for illustration; in practice, set them from your own payment history by bucket.

The expected-cash column is balance × rate: $900,000 × 85% = $765,000, $360,000 × 70% = $252,000, and so on. The total, $1,113,000, is 74.2% of receivables. That figure, not the $1,500,000 balance, is what belongs in next month's cash forecast.

The table also shows where effort pays. The 1–30 bucket holds $360,000, and moving its collection rate from 70% to 85% would bring in another $54,000 ($360,000 × 15%) within the month. The over-90 bucket is small and unlikely to pay; it needs a decision on reserves or collection agency referral, not more reminder emails.

A collections cadence

Before the due date. Send the invoice promptly with clear terms and a payment link. A reminder a few days before the due date catches invoices that were lost or stuck in the customer's approval process.

1–30 days past due. Automated reminder on day 1, a second around day 7, then a phone call from the account owner. Ask for a specific payment date and record it.

31–60 days past due. Escalate to the customer's finance contact. Confirm there is no dispute; if there is, route it to whoever can resolve it, because disputes do not get paid until they are closed.

61–90 days past due. Consider credit holds on new orders, a payment plan, or both. Involve sales leadership.

Over 90 days past due. Decide on reserve, write-off or third-party collection. Review credit terms for that customer.

Every week. Review promised-to-pay dates against actual receipts. A customer who misses a promise moves to the next escalation step.

Connecting collections to the cash forecast

The cadence produces two useful data points the aging report lacks: promised payment dates and each customer's actual payment pattern. Feeding both into the cash forecast replaces a single bucket-level assumption with customer-level expected dates. That makes the receipts side of cash runway tracking much more reliable, and it keeps the runway forecasting model from treating every open invoice as cash on its due date.

Where Tech for CFO fits

InflowWatch is our receivables app, available now for QuickBooks Online. It reads your open invoices from QuickBooks, builds a prioritized worklist of who to chase and when, sends automated reminders, and tracks DSO. For comparisons with other options, see our roundup of QuickBooks receivables tools.

Checklist

1. Calculate DSO, best possible DSO and average days delinquent for the last quarter.
2. Measure your historical collection rate for each aging bucket.
3. Forecast next month's receipts by bucket instead of using the full receivables balance.
4. Set a written escalation cadence with owners and dates for each bucket.
5. Record promised payment dates and review misses weekly.