Accounts Receivable Summary: Aging, Turnover, and DSO

An accounts receivable summary is an internal report that lists every unpaid customer invoice in one place, grouped by customer, so you can see exactly how much money is owed to your business, who owes it, and how long it has been outstanding. It’s the working document behind cash-flow forecasting, collection priorities, credit decisions, and the receivables figure that eventually lands on your balance sheet. If your business invoices customers and waits to get paid, this is the report you’ll look at more often than almost any other.

What’s on the Report

Each line represents a single open invoice. At minimum, you’ll see the customer name, invoice number, invoice date, original amount, any partial payments or credits applied, and the current balance due. Payment terms sit alongside each entry. “Net 30” means the full amount is due within 30 days of the invoice date. “1/10 Net 30” offers a small discount, typically 1%, if the customer pays within 10 days, with the full balance due at 30. Those terms set the clock that determines whether an invoice is current or overdue.

Add up every open balance and you have your company’s gross accounts receivable on the reporting date. That total is the starting point for everything else the report feeds: the aging analysis, the allowance for doubtful accounts, and the receivables line on your financial statements.

The Aging Schedule

The aging schedule is the analytical layer that makes the raw list useful. Every outstanding invoice gets sorted into buckets based on how many days it has gone unpaid past its due date. A standard set looks like this:

  • Current: not yet due
  • 1–30 days past due: slightly overdue, usually still within normal payment lag
  • 31–60 days past due: requires follow-up
  • 61–90 days past due: signals a collection problem
  • Over 90 days past due: high risk of non-payment

The logic is simple. The older an invoice gets, the less likely you are to collect it. An invoice that’s 15 days late is probably stuck in someone’s approval queue. An invoice 90 days past due has a meaningfully lower chance of ever being paid. When a disproportionate share of your balance sits in the 61–90 day bucket, that’s a systemic issue rather than one bad customer. Usually it means credit terms are too generous, follow-up is too slow, or both.

The schedule also sets collection priorities. Instead of chasing every overdue invoice equally, your team can focus on the largest and oldest balances, where the dollars at risk are highest and the recovery window is closing.

Metrics That Come Out of It

Two numbers built from the AR data tell you more about collection efficiency than the raw balances alone.

Accounts Receivable Turnover Ratio

This measures how many times per period you collect the average receivable balance. Divide net credit sales by average accounts receivable for the period. A turnover of 12 means you’re collecting your average AR balance roughly once a month. A turnover of 6 means every two months, and cash is sitting on the table longer than it should.

Days Sales Outstanding

DSO translates collection speed into something more intuitive: the average number of days between making a sale and getting paid. Divide accounts receivable by net credit sales for the period, then multiply by the number of days in that period. Dividing 365 by your turnover ratio gets you to the same place.

A company offering Net 30 terms should see a DSO somewhere around 30 to 35 days. If yours is 55, customers are paying about three weeks late on average and you’re effectively financing their operations interest-free. The reasonable range varies by industry. Retail and e-commerce often run 20 to 30 days because card payments settle quickly. Manufacturing typically sees 45 to 60 days because B2B contracts involve longer payment cycles and multi-step approvals. Professional services usually land in the 30 to 45 day range.

Watching DSO month over month matters more than any single reading. A DSO that creeps up over several months is an early warning, even if the absolute number still looks fine. Something is shifting in your customer base, your collection process, or the economy, and the AR summary picks it up before it hits your bank balance.

Estimating What You Won’t Collect

Not every receivable turns into cash, and the aging schedule is the primary tool for estimating the shortfall. The traditional approach assigns an estimated loss rate to each aging bucket based on your company’s history. Current invoices might carry a 1–2% loss rate; invoices over 90 days past due might carry 40–50% or more. Multiply each bucket’s balance by its loss rate, sum the results, and you have the allowance for doubtful accounts.

That allowance is a contra-asset: it reduces the AR balance on your balance sheet so the reported figure reflects only what you realistically expect to collect. The expense that creates or adjusts the allowance is bad debt expense, and it hits the income statement in the same period as the revenue that generated the receivable. That keeps the books honest instead of showing revenue you’ll never see.

CECL for GAAP Reporters

If your company follows U.S. GAAP, the methodology changed under FASB’s Accounting Standards Update 2016-13, known as CECL (Current Expected Credit Losses). It took effect for SEC-reporting companies in 2020 and for all remaining entities, including private companies, in fiscal years starting after December 15, 2022. Under CECL, you estimate expected losses over the full life of a receivable at the time it’s recorded, using forward-looking information like economic forecasts rather than waiting for a loss event. The older “incurred loss” model only recognized losses when they became probable. Your AR summary and aging analysis need to feed into a CECL-compliant estimation process if GAAP applies.

How the Balance Lands on Financial Statements

On the balance sheet, accounts receivable sits in current assets because you expect to convert it to cash within one year.1LII / Legal Information Institute. Current Asset The reported figure isn’t the gross total from your AR summary. It’s net realizable value: gross receivables minus the allowance for doubtful accounts. If the summary shows $500,000 in outstanding invoices and your allowance is $20,000, the balance sheet reports $480,000.

Accounts receivable itself never appears on the income statement, but the revenue that created it does, and the bad debt expense that adjusts the allowance reduces net income in the period it’s recognized. That’s the matching principle in practice: the cost of extending credit gets booked alongside the revenue from the sales that generated the risk.

When an Invoice Won’t Be Paid

When a customer simply won’t pay, you may be able to deduct the loss. The IRS allows a deduction for business bad debts, wholly or partially worthless, but only if the amount was previously included in your gross income.2Internal Revenue Service. Topic No. 453, Bad Debt Deduction For accrual-basis businesses that condition is usually met, because revenue was recorded when the sale was made.

You have to take the deduction in the tax year the debt becomes worthless, and you need to show you took reasonable collection steps. Going to court isn’t required if you can demonstrate a judgment would be uncollectible anyway. The IRS looks at the surrounding facts to decide whether there’s no reasonable expectation of repayment.2Internal Revenue Service. Topic No. 453, Bad Debt Deduction

For partially worthless debts, the IRS may allow a deduction for the uncollectible portion, but only up to the amount you’ve actually charged off on your books during that tax year.3Office of the Law Revision Counsel. 26 U.S. Code 166 – Bad Debts Your AR summary and write-off procedures directly affect your tax position. Let a clearly uncollectible invoice sit on the books without writing it off and you may miss the deduction window entirely.

Collection Limits You Should Know

One point surprises many business owners. The Fair Debt Collection Practices Act, which heavily regulates how collectors contact debtors, applies only to consumer debts incurred for personal, family, or household purposes. It does not cover B2B collection.4Consumer Financial Protection Bureau. Fair Debt Collection Practices Act Procedures Business-to-business collection is still subject to general contract law and state regulations, but the specific call-timing rules and validation requirements of the FDCPA don’t apply.

Time limits matter if a dispute goes to litigation. Under the Uniform Commercial Code, an action for breach of a contract for the sale of goods must be filed within four years after the cause of action accrues, though the original agreement can shorten that period to as little as one year.5LII / Legal Information Institute. UCC 2-725 – Statute of Limitations in Contracts for Sale For services contracts and other commercial agreements, the applicable limitation period depends on state law. Letting an overdue invoice age for years without action doesn’t just reduce your odds of collection; it can eliminate your legal right to pursue it.

Keeping the Data Trustworthy

An AR summary is only useful if the underlying numbers are right, and accuracy requires internal controls. The most important one is segregation of duties. The person who creates invoices shouldn’t be the same person who records payments or authorizes write-offs. When one employee handles the whole cycle, errors go undetected and fraud becomes easier.

At minimum, keep these functions in separate hands:

  • Invoice creation, handled by billing or sales operations
  • Payment recording, handled by a different member of the accounting team
  • Write-off authorization, approved by a supervisor with no involvement in recording or collecting receivables

Reconcile monthly. The AR subsidiary ledger (the detail behind every customer invoice and payment) should tie to the general ledger control account each month. When the two don’t match, something went wrong: a missed payment, a duplicate entry, an unauthorized adjustment. Catching the gap quickly limits the damage. Customer statements sent directly to buyers add another layer. When customers see their own balance and flag a problem, you get an independent check from the party with the strongest incentive to catch overcharges.

Turning Balances Into Cash Faster

When the AR summary looks strong but the bank account feels tight, the problem is timing. Two tools are commonly used to close that gap.

Accounts receivable factoring involves selling your unpaid invoices to a third party at a discount. The factor advances most of the invoice value within 24 hours and collects directly from your customer. Fees generally run 1% to 5% of invoice value per 30 days, depending on industry, customer creditworthiness, and invoice volume. It isn’t cheap, but it turns a 45-day receivable into next-day cash when payroll or a supplier order can’t wait.

Receivables financing works differently. You use the invoices as collateral for a loan instead of selling them. You keep ownership, collect from customers yourself, and repay the lender as payments come in. The cost is typically lower than factoring, but you keep the collection work and the credit risk.

Both options depend on a clean AR summary. Factors and lenders will scrutinize your aging schedule, customer concentration, and dispute history before advancing funds. A messy report full of unresolved credits, disputed invoices, and stale balances won’t get favorable terms from anyone.