An accounts receivable aging report sorts what your customers owe by how long it has been outstanding. Most accounting systems can build it two different ways, and which one you are holding is a report setting rather than anything the numbers announce. Age it from the invoice date instead of the due date and the whole first column is money that is not late at all.
That single setting decides whether you are holding a collections worklist or a picture of something else entirely. Read properly, the report tells you who to call, which credit limits to change, and what to reserve against. What it does not tell you is what you can deduct, and that gap is where the expensive mistakes live.
What an Accounts Receivable Aging Report Shows
At its simplest: one row per customer, one column per age band, and a grand total that should agree to the gross accounts receivable balance in your general ledger. That is the figure before the allowance for credit losses, the estimate of what you do not expect to collect, is deducted from it. Detail versions break each customer down to individual invoices, which is the version you want when you are about to pick up the phone.
Your accounting system builds it from the open-invoice subledger, the detailed list of unpaid invoices sitting behind the single accounts receivable figure, so preparing one is a matter of choosing the parameters rather than assembling the data. If you are building it by hand, the inputs are the same five fields the system uses: customer, invoice date, due date, original amount, and payments and credits applied to that invoice. Anything else on the report is derived from those.
The report does three jobs, and they are not the same job in different clothes.
- Collections worklist. Age plus balance tells your team who to contact and in what order. This is the only use most businesses make of it.
- Credit file. Where a customer sits over several months tells you whether the terms you granted still fit how it pays, which is a limit set once rather than a call made monthly.
- Allowance input. Loss rates applied by age band are the ordinary way to estimate what a receivables book is really worth, which is the use that ends up in the financial statements.
Confusing the three is the common failure. A report good enough to plan calls from is not automatically good enough to book an allowance from. The allowance use adds a requirement collections does not, because the loss rates you apply have to have been built on the same aging basis the report is run on.
Aged by Invoice Date or by Due Date
Start here, because the answer renumbers every column. Invoice-date aging counts from the day the invoice was issued. Due-date aging counts from the day payment became due, so nothing lands in a past-due column until the terms have run out.
Only one of those is the basis the credit losses standard uses in its own illustration. That illustration runs on customer terms of 30 days, with balances sorted as current, 1 to 30 days past due, 31 to 60 days past due, 61 to 90, 91 to 120, and more than 120 days past due (FASB Accounting Standards Update 2025-05). Every band there is measured from the due date, and the same logic applies to a collections list: an invoice inside its terms is not a call to make.
So check which basis the report was run on before you act on it. If your system supports both bases, run past-due aging for collections and for the allowance, and keep invoice-date aging for a different question worth answering: how long your own team takes to get an invoice out the door after the work becomes billable.
How to Read It in Order
Most people open the report and go straight to the oldest column. Three checks come before that one, and skipping them is how businesses chase balances that were never really receivable.
- Tie the total. The aging total should agree to the accounts receivable control account, the single general ledger account the customer subledger rolls up into. If it does not agree, stop reading; you are looking at a different ledger than your balance sheet is.
- Look at concentration before age. Sort by total balance, not by age. A book where three customers hold most of the balance is a different risk from the same total spread across two hundred accounts, and the aging columns will not show you that on their own.
- Read the movement, not the snapshot. Compare this month's columns to last month's. A total that holds steady while balances migrate rightward is a deteriorating book with a flat headline.
Two things can make the report lie before you get that far, and both sit upstream of it: cash that arrived and was never applied to an invoice, and short payments that are disputes rather than refusals to pay. Neither is fixed by reading harder, and both are worked through in accounts receivable best practices before the due date.
What Counts as a Good Aging Percentage
No published benchmark survives the trip between industries, customer types and payment terms, so a borrowed target for "percent current" is worth less than your own trend line. Anyone quoting a universal figure is quoting a habit, not evidence.
What does transfer between books is the shape of the risk. In the illustrative example published with the 2025 credit losses amendment, the entity's historical credit loss rate runs from 0.3% on current balances to 8% at 1 to 30 days past due, 26% at 31 to 60 days, 58% at 61 to 90 days, 82% at 91 to 120 days, and 99% beyond 120 days past due (FASB Accounting Standards Update 2025-05). Those figures are one hypothetical entity's own loss history inside a teaching example, and they are not a benchmark for yours.
The direction is what generalizes. Money in the oldest column tends to be worth a fraction of its face value, and the fall is steep rather than gradual. That makes your own roll rate the figure worth tracking: the share of each bucket that fails to clear and reappears one column older next month. It comes off two consecutive reports, it is yours rather than borrowed, and it moves before the total does.
Which Aging Date the Allowance Is Built From
The July 2025 amendment to the credit losses standard added a shortcut open to every entity and a further election open only to entities that are not public business entities, which in practice means most privately held companies. Both are narrower than they look. They reach only accounts receivable and contract assets that arose from revenue contracts with customers, and only while those balances are current, which the amendment tests over a one-year period unless the operating cycle is longer (FASB Accounting Standards Update 2025-05). A contract asset here is a right to payment for goods or services already handed over where that right still depends on something other than the passage of time.
Both take effect for annual reporting periods beginning after December 15, 2025, and interim reporting periods within those annual periods, with early adoption permitted (FASB Accounting Standards Update 2025-05). One consequence of that further election gets missed, which is what it does to the balances it does not clear.
That election is open only to an entity that has also taken the shortcut, and it lets that entity take account of collections received between the balance sheet date and the day its financial statements are available to be issued, or an earlier date it selects. Amounts still uncollected at that date are graded on their delinquency status as of that date, not as of the balance sheet date. The later the date sits inside that window, the older every surviving balance has become. In the standard's own case where the entity looks through May 31, everything still outstanding has passed 120 days and picks up the 99% rate (FASB Accounting Standards Update 2025-05).
That is a real trade rather than free relief. In the standard's own illustration the same book gives an allowance of $20,646 under the shortcut alone, $21,392 when the entity looks through March 1, and $17,357 when it looks through May 31 (FASB Accounting Standards Update 2025-05). A later date clears more of the book to nothing and re-ages whatever is left into the most expensive column, so the aging report you run at the balance sheet date is not the one the allowance is finally built from.
The Allowance Is Not a Tax Deduction
Book and tax part company here, and the split surprises people who have just finished a careful allowance. A deduction is allowed for any debt that becomes worthless within the taxable year, and where a debt is recoverable only in part, a deduction may be allowed in an amount not in excess of the part charged off within that year (26 U.S.C. 166). Sitting in an old aging bucket is not the same as being worthless, so no bucket boundary triggers a deduction on its own.
What counts is evidence. In determining whether a debt is worthless in whole or in part, all pertinent evidence is considered, including the value of any collateral securing the debt and the financial condition of the debtor. Where the circumstances indicate that a debt is worthless and uncollectible and that legal action to enforce payment would in all probability not result in the satisfaction of execution on a judgment, showing those facts is sufficient (section 1.166-2(a) and (b)). You do not have to sue before you write off. You do have to be able to explain why you stopped.
The Rule That Catches Written-Off Fees
One subsection decides whether a fee you have given up on is deductible at all. Worthless debts arising from unpaid wages, salaries, fees, rents and similar items of taxable income are not allowed as a deduction unless the income those items represent was included in the return of income for the year the deduction is claimed or for a prior year (section 1.166-1(e)).
Read that against a business reporting on the cash basis. The fee never went into income, so writing the invoice off the aging report produces no deduction at all. The economic loss is real and the deduction is simply not there to take, which is a conversation worth having with a client before they build a plan around it.
Producing the Report for Client Firms
If your firm produces the aging report as a client deliverable, it is a work product with standing decisions behind it rather than an export button. Three things need one house answer, applied to every client.
Fix the aging basis. A partner comparing two clients' reports built on different bases is comparing nothing, and the mismatch usually surfaces in the month nobody has time to unpick it.
Fix the cut-off. An aging dated the last day of the month but generated on the fifth, with cash applied through the fifth, is not the report the client's lender believes it is holding, and the difference is invisible on the page.
Fix the treatment of credits and unapplied cash. Decide whether they net into the current column or sit on their own line, write the decision down, and keep it the same every month, because a report that quietly nets is the one that hides a collections problem from the person paying for the report. That standing decision is part of what makes client accounting services repeatable at volume rather than a monthly negotiation.
Where to Start
Open your current aging report and do four things before you plan a single call. Check which basis it was run on. Tie the total to the control account. Sort by balance to see where the exposure really sits. Put last month's columns beside this month's. Only then read the oldest column.
Once the report is trustworthy, decide which of its three jobs you are doing that day. Collections, credit and the allowance all need the same clean data and lead to completely different actions.
Accountably places trained offshore accountants and tax preparers inside US CPA and EA firms, ramped on your software and SOPs in about 3 to 4 weeks, so receivables work like this runs on a schedule instead of whenever April lets go. Since 2022 that is 20+ US firms and 30+ placements. Don't trust us. Test us. Run the Free 40-Hour Proof Pilot on a real block of your own work and let your reviewer grade the output before anything client facing depends on it.