How to Read an Accounts Receivable Aging Report
An aging report sorts every unpaid invoice by how late it is. Read it from the oldest column back, check how your system counts age, add the notes the report cannot hold, and give every column an action and a date.
Most new client conversations on my team begin with the same request: send us your aging. Before anyone discusses a single account I want the whole report, because it tells me more about how a company gets paid than a description of its credit policy does. The policy says what is supposed to happen. The aging report shows what did.
Most people who run the report every week read it the way it prints, alphabetically, top to bottom, with a glance at the total. A collector reads it from the right hand side, oldest money first, and asks one question of every balance: why is this still here? That habit is easy to learn, and it changes what you do on Monday morning. Here is how I would read yours.
Key takeaways
- An accounts receivable aging report lists every unpaid customer invoice and sorts the amounts into columns by age, usually current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due.
- Read it from the oldest column back toward current. The right hand side of the report is where money is being lost today, and the left hand side is where next quarter's problems begin.
- Check how your system counts age before you trust a column. A report aged from the invoice date makes a net 30 customer look a month late on the day the invoice comes due.
- The report does not show disputes, unapplied payments, broken promises or whether the customer is still ordering. Those belong in a notes column, and the columns mislead without them.
- Decide in advance what happens at each column: a call in the first week past due, a credit hold when a promise is missed, one final demand, and placement with a commercial collection agency at 90 to 120 days past due.
What's inside

What is an accounts receivable aging report?
An accounts receivable aging report lists every unpaid customer invoice and sorts the amounts into columns by age, usually current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due. It shows who owes you money, how much, and how late each balance is.
Every accounting system produces this report under a slightly different name: A/R aging, aged receivables, aged trial balance. The summary version gives each customer one line. The detail version lists every open invoice. Use the summary to find the problem and the detail to work it.
The report does two jobs, and it helps to know which one you are doing. Your accountant uses it to estimate how much of the receivables balance will never be collected, because older invoices are less likely to be paid, and sets the reserve for bad debt from that estimate. Your credit department uses the same page as a worklist: who to call, who to hold, who to place. This article is about the second job.
It pairs with days sales outstanding, which boils the same ledger down to one average. The average shows a trend. The aging report shows where the balance actually sits.
How do you read an aging report?
Start with the total row to see how much of your receivables is past due. Confirm whether age is counted from the invoice date or the due date. Then read the oldest column first, largest balance first, and write down why each amount is still unpaid. Then read across each customer's row for the pattern.
Start at the bottom. The total row shows the shape of your receivables: how much is current and how much sits in each past due column. In a business that collects well, the numbers shrink quickly as you move right, with most of the money in current and very little past 60 days. A bulge in a middle column means something changed about that many days ago.
Next, find out how your system counts age, because two reports with the same column headings can mean different things. Some systems age from the invoice date. On that setting a net 30 invoice lands in the 31 to 60 column the day after it comes due, and a customer who pays you exactly on time looks a month late. Other systems age from the due date, so the first past due column means what it says. Know which one you are reading before you pick up the phone. If you sell on several different terms, only due date aging lets you compare customers fairly. Our guide to business payment terms explains how the due date itself gets set.
Then go to the oldest column and sort it by amount, largest first. A collector starts here for a plain reason. Age tells you more than anything else about whether an invoice will be paid, and the largest old balances are where the next hour of work recovers the most. For each one, write down why it is still open. There are only a few possible answers. The customer disputes it, the customer has promised a date, the customer cannot pay, or nobody has asked lately. The last answer is more common than anyone likes to admit.
After that, read across each customer's row instead of down the columns. The pattern in the row tells you what kind of problem you have.
- Money in every column. The customer is paying, but always the oldest invoice and always late. This is a slow payer on a rolling delay, and the fix is a conversation about terms.
- One old invoice, everything else current. The customer has money and pays on time. Something is wrong with that one invoice: a missing purchase order, a short shipment, a price nobody agreed to. It needs someone in sales or operations more than it needs a collector.
- Old balances growing while new orders keep shipping. This is the row that should worry you. Your exposure rises every week, and the customer has learned that paying late costs nothing. It is the plain case for a credit hold.
- Everything old, nothing new. The customer has stopped buying and stopped paying. No future order gives you leverage, so waiting only costs you time.
What should you do at each aging bucket?
Give each column one action and one owner. Current: confirm large invoices were received and approved. 1 to 30 days past due: call and get a payment date. 31 to 60: hold new orders if a promise was missed. 61 to 90: send one final demand. Over 90: place the account.
The columns are only useful if each one triggers something. Most accounts reach us closer to 180 days past due than 120, which tells me that in a lot of companies the real effort starts in the last column. That is the reverse of what works. Here is the schedule I would attach, counting days past due from the due date.
- Current. Nothing is owed yet, so the job is to remove excuses. For a large invoice, confirm it was received, matched to the purchase order and approved for payment. A courtesy call now saves the "we never got it" conversation six weeks from now.
- 1 to 30 days past due. Call in the first week. Reach the person who releases payment, ask whether anything is wrong with the invoice, and get a date. Our guide to collection calls has the script, and the collection email templates give you the written confirmation.
- 31 to 60 days past due. By now a date has been promised and either kept or missed. If it was missed, hold new orders and tell both the buyer and the payables contact in writing what releases the hold. If a dispute has surfaced, hand it to the person who can settle it and set a deadline for the answer.
- 61 to 90 days past due. Reminders have run their course. Send one final demand letter with a specific date and a specific consequence, and mark that date on the report.
- Over 90 days past due. The date in your final demand has passed. Keep your word and place the account. Every week it sits here costs you more than a week did in any earlier column.
The day counts matter less than the principle. If you sell on short terms everything moves earlier, as my colleague Rodney Wild explained in his piece on net 15 payment terms. What matters is that no balance moves a column to the right without someone having acted on it. For the full sequence on one stubborn account, see what to do when a business will not pay its invoice.
What does an aging report not tell you?
The report shows amounts and age and nothing else. It does not show which balances are disputed, which accounts carry an unapplied payment or credit, which customers have broken a promise to pay, or who is still ordering. Those facts decide the next step, so record them in a notes column.
An aging report is arithmetic. It subtracts a date from today's date and puts a dollar amount in a box. Everything else a collector needs has to be added by a person.
Disputes. A disputed invoice ages exactly like an ignored one. On the page they look identical, and they need opposite treatment. One needs a credit memo or a corrected invoice from your side. The other needs pressure. Mark every dispute, who owns it and when it will be answered, so your collector is not pressing a customer who is waiting on you.
Unapplied payments and credits. Look for negative numbers. A payment that arrived without remittance detail often sits on the account as an unapplied credit while the invoices it was meant to pay keep aging. The customer shows 75 days past due and believes, correctly, that they paid. Clear these before anyone makes a call. Few things cost a credit department more standing with a customer than demanding money that is already in the bank.
Promises. The report has no memory. It cannot tell you that this customer promised payment on the 10th, again on the 24th and again last Friday. A promised date and a count of broken promises belong beside every past due balance, because the second broken promise tells you more than another 30 days of age does.
Short pays and leftovers. Small residual balances, a few dollars of freight or a discount taken after the discount date, collect in the oldest column and make it look worse than it is. Decide once whether to bill them or clear them, so the clutter stops hiding the invoices that matter.
Reissued invoices. When an invoice is credited and rebilled to fix an error, most systems give the new invoice today's date. The debt is as old as it ever was, but the report now shows it as current. One correction is housekeeping. If it happens often on the same account, look into why.
How often should you review the aging report?
Review the aging report every week, on the same day, with the person who makes collection calls and someone from sales. A monthly review is too slow, because an invoice can cross a full column between looks. End each review with a name and a date beside every past due balance.
Month end is when most companies look, because that is when the report prints for the close. For collection purposes it is the worst possible rhythm. An invoice that was eight days late at the last review is nearly forty days late at the next one, and it crossed a column without anyone deciding that it should.
A weekly review does not need to be long. Half an hour, the same day each week, the oldest column first. The person who makes the calls should be there, and so should someone from sales. Sales usually knows why an invoice is stuck, and needs to hear which accounts are on hold before promising anyone a delivery date. One rule makes the meeting worth having: no past due balance leaves the table without a name and a date beside it.
I will add something from our side of the desk. Our ideal placement is an account under 120 days past due. Most of the accounts that reach us are closer to 180. I read that two month gap as a review problem more than a decision problem. My sense is that hardly anyone chooses to wait. The account moves from one column to the next between looks, until somebody finally asks how long it has been there.
Which accounts on the aging report should go to a collection agency?
Place accounts that are 90 to 120 days past due, undisputed, and no longer answering or keeping promises. Age matters more than size, so do not wait for the oldest column to grow. Hold back invoices with a genuine open dispute and accounts on a payment plan the customer is keeping.
If you have followed the schedule above, the report makes this decision for you. An account that has had a call, a missed promise, a hold and a final demand, and is now past the date in that demand, has told you what more reminders will do. Age is the reason not to wait. I went through why in my article on what a realistic recovery rate looks like: a debtor pays the suppliers who press.
When there are several candidates, the order you place them in matters. Age, size, dispute status and whether the customer is still buying decide it, and how to place an account with a commercial collection agency walks through that triage and what to send with each file.
Just as important is what to hold back. I would not place these, at least not yet.
- An invoice with a real, unanswered dispute. If the customer says the goods were short and nobody on your side has checked, an agency will get the same answer you did. Settle it, or document why the customer is wrong, and then place it.
- An account on a payment plan the customer is keeping. It will look terrible on the report for months. If the payments arrive on the agreed dates, note the plan and leave it alone.
- A customer who has filed for bankruptcy. The claim follows a different process from that point, which our guide to customer bankruptcy covers.
- Amounts owed by individuals. We collect commercial accounts only. We do not collect consumer or retail debt.
Everything else in the oldest columns that is undisputed and unanswered is a candidate. Commercial debt collection by a licensed third party changes the customer's priorities in a way another statement from you will not. We take commercial accounts from $1,000 to hundreds of thousands of dollars, under 120 days past due, and we work on contingency: no recovery, no fee. For what happens next, see how long commercial debt collection takes.
How do you keep accounts out of the over 90 column?
Work the left side of the report. Get terms signed on a credit application before the first order, invoice the day you ship, call in the first week an invoice is past due, and hold orders when a promise is missed. If nobody has the hours, outsource those early contacts.
Placing old accounts fixes the right hand side of this month's report. It does nothing for next quarter's, because the over 90 column is filled from the left.
Three habits do most of the work. The first is getting terms agreed in writing before the first order ships. A customer who signed a credit application knows when payment is due and what follows if it is late, and an automated credit application gets that signature and the credit checks done before the order is released. The second is invoicing the day you ship, with the due date printed on the invoice. The third is the first week call. The earlier that first call is made, the less often an invoice reaches the later columns.
The third habit is the one that slips, because it is nobody's whole job. A controller who also closes the books makes collection calls when there is time, and there is never time in the week it matters. If that describes your company, accounts receivable outsourcing puts those early contacts on a schedule, made in your company's name by people whose only job is that follow up. Our article on when outsourcing your receivables makes sense is honest about when it does not.
C2C Resources has collected commercial accounts in all 50 states since 2002, about 25,000 claims a year, from our offices in Atlanta, Georgia and Metairie, Louisiana. We are certified by the Commercial Law League of America, endorsed by the International Association of Commercial Collectors, carry a $500,000 surety bond and hold collection licenses in the states that require them.
Want a second read of your aging report?
Send us your aging and whatever notes go with it. We will tell you which accounts are past the point where reminders work, which ones we would leave with you, and what we would expect before you place anything.
Frequently asked questions
What are the standard buckets on an accounts receivable aging report?
Most reports use five columns: current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90. Some systems add a 91 to 120 column before the last one. The widths are a setting you can change, so a business that sells on short terms can use narrower columns and see a problem sooner.
Should an aging report be aged by invoice date or by due date?
Aging by due date shows how late each invoice is against the terms you gave, which is what a collector needs. Aging by invoice date shows how long the invoice has existed, which makes customers on longer terms look later than they are. Check which one your system uses before you compare customers or act on a column.
Why does my aging report show a negative balance?
A negative number is a credit on the account: a payment that was received and not yet applied to an invoice, an overpayment, or a credit memo. Apply or resolve it before you contact the customer. Until you do, the invoices that payment was meant to cover keep aging and the account looks later than it is.
How is the aging report used to estimate bad debt?
Accountants assume a larger expected loss for each older column, since older invoices are less likely to be collected, and add up the results to set the allowance for doubtful accounts. The method and the figures are your accountant's call. The collection lesson is the same one: a balance loses value every time it moves a column to the right.
Should I write off everything over 90 days past due?
Not automatically. A write off is an accounting decision to make with your accountant, and age alone does not make a commercial debt uncollectible. Place the account with a commercial collection agency first. Writing a balance off your books is an accounting entry. It does not cancel what the customer owes, and money recovered afterward is still money in the bank.