Accounts Receivable Summary: Aging, Metrics, and Write-Offs

An accounts receivable summary is an internal report that lists every unpaid customer invoice your business is holding, grouped by customer and totaled to show how much cash is tied up in credit sales at a given date. It is the working document behind cash-flow forecasts, collection priorities, credit decisions, and the receivables figure on your balance sheet.

The report exists because you use accrual accounting. The moment you deliver a product or finish a service and issue an invoice, revenue hits the books and the unpaid balance becomes a receivable. If your business is on the cash method, you don’t record revenue until payment lands, so there is nothing to summarize.1Internal Revenue Service. Publication 538, Accounting Periods and Methods

What the Summary Contains

Each line on the report is a single open invoice. The standard fields are the customer name, invoice number, invoice date, original invoice amount, any partial payments or credits already applied, and the remaining balance due. Payment terms sit alongside those fields because they determine whether an invoice is current or late. Net 30 means the full amount is due within 30 days. 1/10 Net 30 offers a small discount, typically 1%, for payment within 10 days, with the full balance due at 30.

Add up every open balance and you get your gross accounts receivable at the reporting date. That gross number is the starting point for everything the summary is used for next.

The Aging Schedule

Sitting on top of the raw list is the aging schedule, which sorts every open invoice by how long it has gone unpaid past its due date. A standard set of buckets:

  • 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. An invoice 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 points to a systemic issue: terms that are too generous, follow-up that is too slow, or both.

The schedule also drives collection priorities. Rather than chasing every overdue invoice equally, you can focus on the largest and oldest balances, where the dollars at risk are highest and the window for recovery is shortest.

Key Metrics You Can Pull From the Summary

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

Accounts Receivable Turnover Ratio

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

Days Sales Outstanding

DSO translates collection speed into an average number of days between the sale and the payment. Divide accounts receivable by net credit sales for the period, then multiply by the number of days in that period. You can also divide 365 by the turnover ratio.

A company offering Net 30 terms should see DSO close to 30–35 days. If DSO is 55, customers are paying roughly three weeks late on average, and you are effectively financing their operations interest-free. Benchmarks vary by industry. Retail and e-commerce often run 20–30 days because card payments settle quickly. Manufacturing typically sees 45–60 days because B2B contracts involve longer cycles and multi-step approvals. Professional services tend to land in the 30–45 day range.

Tracking DSO month over month matters more than any single reading. A number that creeps up over several months is an early warning, even when the absolute value still looks reasonable.

Estimating What You Won’t Collect

Not every receivable turns into cash, and the aging schedule is the primary tool for estimating what will be lost. The traditional method assigns an uncollectibility percentage to each bucket based on historical experience. Current invoices might carry an estimated loss rate of 1–2%, while invoices over 90 days past due might carry 40–50% or more. Multiplying each bucket’s balance by its rate and adding the results gives you the allowance for doubtful accounts.

The allowance is a contra-asset account. It reduces the AR balance on your balance sheet so the reported figure reflects only what you realistically expect to collect. The offsetting entry is bad debt expense, which hits the income statement in the same period as the revenue that created the receivable.

The CECL Standard

If your company follows U.S. GAAP, the loss estimate has to be built under FASB’s Accounting Standards Update 2016-13, known as CECL (Current Expected Credit Losses). It took effect for SEC filers in 2020 and for all remaining entities, including private companies, in fiscal years beginning after December 15, 2022. CECL requires you to estimate expected losses over the entire life of a receivable at the time it is recorded, incorporating forward-looking information like economic forecasts. The old incurred-loss model only recognized losses when they became probable; CECL requires earlier, more comprehensive recognition. Your AR summary and aging analysis feed directly into that estimate.

How the Summary Flows Onto the Balance Sheet

Accounts receivable is listed as a current asset because you expect to convert it to cash within one year.2LII / Legal Information Institute. Current Asset The reported amount is not the gross total from your summary. It is the net realizable value: gross receivables minus the allowance for doubtful accounts. If your 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 is recognized. That is the matching principle: the cost of extending credit is recorded alongside the revenue from the sales that created the credit risk.

Deducting Uncollectible Invoices on Your Taxes

When a customer will not pay, the IRS allows a deduction for business bad debts, either wholly or partially worthless, but only if the amount was previously included in gross income.3Internal Revenue Service. Topic No. 453, Bad Debt Deduction For accrual-basis businesses this condition is usually met because revenue was recorded when the sale occurred.

Take the deduction in the tax year the debt becomes worthless, and be ready to show you took reasonable steps to collect. Going to court is not required if you can demonstrate a judgment would be uncollectible anyway; the IRS looks at facts and circumstances to decide whether there is no reasonable expectation of repayment.3Internal 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 have actually charged off on your books during that tax year.4Office of the Law Revision Counsel. 26 U.S. Code 166 – Bad Debts

That last point makes your write-off procedures a tax matter, not just an accounting one. If a clearly uncollectible invoice sits on the books without being charged off, you may miss the deduction window.

Legal Boundaries on Collecting

Two limits are worth knowing before you push a delinquent account further. First, the Fair Debt Collection Practices Act, which regulates how collectors can contact debtors, applies only to consumer debts incurred for personal, family, or household purposes. It does not cover business-to-business collections.5Consumer Financial Protection Bureau. Fair Debt Collection Practices Act Procedures General contract law and state rules still apply, but the specific FDCPA restrictions do not.

Second, statutes of limitations run against you. 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, and the original agreement can shorten that period to as little as one year.6LII / Legal Information Institute. UCC 2-725 – Statute of Limitations in Contracts for Sale For services contracts, the limitation period depends on state law. Letting an invoice age for years without action can eliminate your right to pursue it.

Controls That Keep the Summary Trustworthy

The report is only useful if the underlying data is right. The most important control is segregation of duties. The person who creates invoices should not be the person who records payments or authorizes write-offs. When one employee handles the whole cycle, errors go undetected and fraud becomes easier. At minimum, split invoice creation, payment recording, and write-off authorization across different people, with write-offs approved by a supervisor who has no role in recording or collecting.

The second critical control is reconciliation. The AR subsidiary ledger, which holds the detail for every customer invoice and payment, should be reconciled to the general ledger control account every month. When the two numbers disagree, something went wrong: a missed payment, a duplicate entry, or an unauthorized adjustment. Catching it early limits the damage.

Sending customer statements directly to buyers gives you a third check. Customers have the strongest incentive to flag overcharges, and their responses catch things your internal review will not.

Turning the Balance Into Cash Sooner

A healthy AR summary and a tight bank account are a timing problem. Two tools address it.

Factoring means selling unpaid invoices to a third party at a discount. The factor advances you most of the invoice value, often within 24 hours, then collects from your customer directly. Fees generally run 1% to 5% of invoice value per 30 days, depending on industry, customer credit, and volume. It is not cheap, but it converts a 45-day receivable into next-day cash.

Receivables financing uses the same 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 usually lower than factoring, but the collection work and the credit risk stay with you.

Either option requires a clean summary. Factors and lenders look at your aging schedule, customer concentration, and dispute history before advancing funds. Unresolved credits and stale balances will not attract favorable terms from either one.