QUICK TAKEAWAY
Primary Insight: An accounts receivable aging report is an early-warning system rather than a collections list, and the number that predicts a cash shortfall is the share of your balance sitting past 60 days, not the total owed.
Key Fact: The IRS allows a bad debt deduction only in the year a debt becomes worthless, and only after you can show you took reasonable steps to collect it. Your aging report and collection notes are that documentation.
Best Suited For: Owners of California businesses doing $1M to $20M in revenue who invoice on terms and review receivables less than once a month.
Your accounts receivable aging report is not a collections list. Most business owners treat it as one, scanning for the largest overdue invoice and calling that customer. That reading is backward. The report’s real value is predictive: it tells you what your bank balance will look like in 30, 60, and 90 days, and it tells you now, while there is still time to act on it.
Receivables fail quietly. Revenue looks strong, the profit and loss statement looks healthy, and nothing on the income statement signals distress. Meanwhile the average invoice takes a week longer to collect than it did last quarter, and that week is worth real money sitting in someone else’s bank account instead of yours.
This post covers what the aging buckets actually signal, how to calculate days sales outstanding and translate a change in it into dollars, the concentration risk most aging reports obscure, what to actually do about balances that have already aged, and the point at which an unpaid invoice stops being a receivable and becomes a tax question.
What an accounts receivable aging report actually shows
An accounts receivable aging report sorts every unpaid customer invoice into columns by how long it has been outstanding, typically current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90. Every accounting system produces one. QuickBooks Online generates it under Reports as the A/R Aging Summary or the A/R Aging Detail.
The summary view gives you one row per customer and one total per bucket. The detail view lists every open invoice. Owners tend to look at the summary, see a total that roughly matches expectations, and move on. The information that matters sits in how that total is distributed.
Two businesses can carry an identical $600,000 in receivables. In the first, 85% is current and the remainder is barely past due. In the second, a third of the balance is more than 60 days old. Same number on the balance sheet, two completely different businesses.
The share of receivables past 60 days matters more than the total balance
The percentage of your receivables sitting past 60 days is the single most useful figure on the report, because collection becomes measurably harder the longer an invoice ages. An invoice at 90 days has usually been disputed, forgotten, or deprioritized by someone who has decided not to pay you on schedule.
Track that percentage every month and watch the direction rather than the level. A business where past-60 receivables move from 8% to 14% over two quarters has a developing problem even if the total balance is flat, and even if nobody has stopped paying entirely.
| Aging bucket | What it usually signals | What it calls for |
| Current | Normal terms and a healthy invoicing process | Nothing beyond routine follow-up |
| 1 to 30 days | Administrative delay on the customer’s side | Automated reminder, no escalation |
| 31 to 60 days | The invoice is not in the customer’s payment queue | Direct contact with whoever approves payment |
| 61 to 90 days | An unresolved dispute, a cash problem at the customer, or a broken internal process | Owner or controller involvement, and a decision on continuing work |
| Over 90 days | Collection is uncertain and the receivable may be overstated on your balance sheet | A documented decision: write off, escalate, or settle |
The last row is the one owners skip. A receivable that will never be collected still sits in your assets, inflating your balance sheet and, if you report on the accrual method, your taxable income.
How to calculate days sales outstanding, and what a rising DSO costs you
Days sales outstanding measures how long it takes on average to collect a dollar of credit sales. Divide your receivables balance by credit sales for the period, then multiply by the number of days in that period.
DSO = (Accounts receivable ÷ Credit sales for the period) × Days in the period
A worked example makes the cost visible. Consider a hypothetical Central Valley contractor comparing two consecutive quarters.
| Prior quarter | Current quarter | |
| Credit sales | $1,290,000 | $1,350,000 |
| Accounts receivable at period end | $455,000 | $612,000 |
| Days in period | 91 | 91 |
| Days sales outstanding | 32.1 days | 41.3 days |
Sales grew 4.7%. Receivables grew 34.5%. Days sales outstanding rose by a little over nine days, and at current daily credit sales of roughly $14,800, those nine days represent approximately $135,800 in additional cash tied up in receivables that was not tied up the previous quarter.
That $135,800 never appeared on the income statement. The business booked more revenue and looked more profitable. It simply had less money, which is the same mechanism behind most of the cash flow leaks that surface at growing companies.
Customer concentration is the risk your aging report hides
Concentration risk appears when one customer accounts for a disproportionate share of what is past due, and a summary aging report presents that customer as just another row. A business with $180,000 past 60 days spread across fourteen customers has a process problem. A business with $180,000 past 60 days owed by a single customer has a counterparty problem, and the two call for completely different responses.
Sort the aging detail by customer within the past-due buckets every month, then calculate what percentage of total past-due receivables your largest single customer represents. Once that figure climbs above roughly a quarter of the past-due balance, the exposure deserves a decision rather than another reminder email.
That decision usually involves work in progress. Continuing to deliver for a customer who has stopped paying converts a collection problem into a considerably larger one. The terms of any change to a customer relationship are worth reviewing with your attorney before you act.
How to reduce aging receivables once they have already built up
Reducing aged receivables takes three moves in a specific order: collect what is still collectible, remove the upstream causes that produced the aging, and use whatever leverage you hold before the work is finished. Most businesses attempt only the first, which is why the same balances reappear two quarters later.
Run a written escalation ladder instead of ad hoc follow-up
An escalation ladder assigns a specific action, on a specific day, to a named person, so collection stops depending on whoever happens to remember. The ladder matters more than the wording of any individual message, because consistency is what teaches a customer where your invoices sit in their payment queue.
| Timing | Action | Who owns it |
| Invoice date | Invoice delivered to the confirmed billing contact with the PO or job reference attached | Bookkeeper |
| 3 days after invoice | Confirm the invoice was received and accepted into the customer’s accounts payable system | Bookkeeper |
| 5 days before due | Courtesy reminder sent before the invoice is late, not after | Automated |
| 5 days past due | Direct email to the accounts payable contact with the invoice re-attached | Bookkeeper |
| 20 days past due | Phone call to whoever approves payment, not whoever processes it | Controller or office manager |
| 45 days past due | Owner-to-owner contact with a documented request for a specific payment date | Owner |
| 60 days past due | Decision meeting: hold new work, offer a payment plan, settle, or escalate | Owner and controller |
Two details make the ladder work. Every contact goes in writing, or gets summarized in writing afterward, which produces the same record you would need if the balance eventually has to be written off. And each step names a person rather than a department, because shared responsibility is how invoices drift.
Fix the causes that sit upstream of the invoice
Most aging is created before anyone chases anything. The invoice went to the wrong person, arrived without a purchase order number, described the work in language the customer’s project manager could not match to an approval, or simply went out three weeks late. None of that is a collections problem, and no amount of follow-up will fix it.
- Confirm the billing contact and delivery method for every customer at least annually, since accounts payable staff turn over more often than your sales contacts do.
- Match the invoice to the customer’s approval process, which usually means including the purchase order, job, or contract reference they need in order to route it internally.
- Invoice on a fixed schedule rather than when someone gets to it, because every day of internal delay is a day added to your DSO before the customer has done anything at all.
- Bill progressively on longer engagements, so that one disputed item cannot hold up months of completed work.
- Set deposit and retainer terms at the point of sale, where you hold the most leverage you will ever have with that customer.
The first three are ordinary bookkeeping and accounting execution. The last two are terms decisions only the owner can make, and they reduce aged receivables more reliably than any collection effort applied after the fact.
Use the leverage you have while you still have it
Leverage in receivables is perishable. It peaks before you deliver and falls close to zero once the work is complete and the customer already has what they wanted. A hold on new work, a pause on scheduling, or a delayed release of deliverables moves a balance faster than a fourth reminder email, and it is the option you forfeit by waiting.
Payment plans are worth more than they appear. A signed schedule that recovers a balance over three months converts an uncertain receivable into a predictable one, and the first missed installment usually tells you whether the customer intends to pay at all. Partial recovery also carries a tax consequence worth knowing: for a business on the accrual method, the portion ultimately forgiven may be deductible as a partially worthless business bad debt.
Some remedies are time-sensitive in ways that are not obvious from the aging report. Construction and certain other trades have statutory collection rights whose deadlines run from events early in a project rather than from the date an invoice goes unpaid, so the conversation with your attorney belongs well before a balance reaches 90 days. The same applies to contractual late fees and interest, where what you can actually enforce depends on the language in your agreement.
When an unpaid invoice becomes a deductible bad debt
An unpaid invoice becomes a deductible business bad debt in the year it becomes worthless, which the IRS defines as the point when the facts and circumstances indicate there is no reasonable expectation of repayment. Per IRS Topic No. 453, you do not have to wait until the debt is due to make that determination, and you do not have to go to court if a judgment would be uncollectible.
You do have to document. The IRS requires you to establish that you took reasonable steps to collect before a debt can be treated as worthless. Your aging report, your record of contacts, and your internal escalation notes are what satisfy that standard, which is a practical reason to keep collection activity written down rather than handled by phone and forgotten.
Whether the deduction is available at all depends on your accounting method, and the difference is significant.
| Accrual method | Cash method | |
| Was the revenue already in income? | Yes, when the invoice was issued | No, only when collected |
| Bad debt deduction available on an uncollected invoice? | Yes, in full or in part | Generally no |
| Why | The amount was included in gross income, so the write-off reverses income already taxed | The income was never recognized, so there is nothing to deduct |
The IRS states the rule directly: to deduct a bad debt you must have previously included the amount in your income or loaned out your cash, and a cash method taxpayer generally cannot take a bad debt deduction for unpaid fees and similar items of taxable income. Business bad debts may be deducted in full or in part, but only to the extent the amount was included in gross income in the current or a prior year.
For a business on the accrual method, the write-off decision carries a real tax consequence, which makes its timing worth discussing before year end rather than during the return.
Nonbusiness bad debts follow a stricter rule and must be totally worthless to be deducted at all. That distinction rarely applies to customer receivables in an operating business, though it matters for loans an owner has made personally.
Build the receivables review into your month-end close
A receivables review belongs in your month-end close as a standing step rather than as a reaction to a cash shortage. For most businesses in this range the review takes under thirty minutes and produces four numbers:
- Total accounts receivable, compared to the same month last year
- Percentage past 60 days, tracked as a trend rather than a single reading
- Days sales outstanding for the period, calculated the same way every month
- Largest single past-due customer as a share of total past-due receivables
Keep those four numbers on one page, month over month, for a rolling twelve months. Direction is more informative than any single reading, and a trend line makes an argument to a lender or a board that a snapshot cannot.
Assign the review to a specific person with the authority to act on what it shows. A report that gets produced but never owned is the most common failure here, and it explains why receivables problems surface at businesses whose bookkeeping is otherwise accurate but who have no controller-level oversight.
Frequently asked questions about accounts receivable aging reports
What is a good accounts receivable aging percentage?
A healthy accounts receivable aging distribution generally keeps the large majority of the balance in the current and 1 to 30 day buckets, with past-60 receivables in the single digits as a percentage of total AR. The right target varies by industry and by the payment terms you extend, so your own twelve-month trend is a more reliable measure than any universal benchmark.
How often should a business review its AR aging report?
Reviewing the AR aging report monthly as part of the close is the minimum for most businesses doing $1M to $20M in revenue. Businesses with long project cycles, concentrated customers, or terms beyond net 30 benefit from a weekly look at the past-due buckets, since the cost of catching a problem late scales with invoice size.
Can I write off an unpaid invoice on my taxes?
Writing off an unpaid invoice as a business bad debt is available only if the amount was previously included in your gross income, which generally means the business reports on the accrual method. Cash method businesses generally cannot deduct uncollected receivables, because the revenue was never recognized as income in the first place.
What is the difference between an AR aging summary and an AR aging detail report?
An AR aging summary shows one line per customer with totals in each aging bucket, while an AR aging detail report lists every individual open invoice with its date and age. The summary is the right view for spotting trends and concentration, and the detail is what you need before contacting a customer about a specific balance.
How can I get customers to pay faster?
Getting customers to pay faster depends more on invoice mechanics and consistent follow-up than on the payment terms themselves. Confirm the billing contact and include whatever reference number the customer’s approval process requires, invoice on a fixed schedule rather than ad hoc, send a reminder before the due date instead of after it, and apply the same escalation steps on the same days to every account.
Does a high DSO always mean a collections problem?
A high days sales outstanding figure does not always indicate a collections problem, because DSO reflects the payment terms you extend as much as how well you enforce them. A business offering net 60 terms will show a structurally higher DSO than one on net 15, so the more useful question is whether your DSO is drifting away from the terms you actually granted.
Receivables Are a Management Problem Before They Are a Collections Problem
By the time an unpaid invoice feels urgent, most of the leverage is already gone. The signal was available months earlier, in a report that was already being generated, and it went unread because nobody had been assigned to treat it as a forecast rather than a list.
Businesses that handle receivables well are not more aggressive about collections. They review the same four numbers every month, they notice direction before magnitude, and they make write-off and escalation decisions on a schedule instead of under pressure. That is ordinary controller work, and it is usually the piece missing at companies whose books are otherwise in good shape.
At MBS Accountancy, we help California business owners doing $1M to $20M in revenue build the reporting rhythm that turns receivables from a quarterly surprise into a managed number. If your aging report is something you open only when cash gets tight, that is worth a conversation.
Ready to talk about your situation? Schedule a free 20-minute call.