Accounts Receivable Aging Report Explained
You did the work and sent the invoice, but the money has not arrived. An accounts receivable aging report shows exactly who owes you, how much and for how long, sorted so the oldest debts jump out. Here is how to read one, build a simple version yourself and turn it into a weekly habit that gets you paid faster.
Key takeaways
- An accounts receivable (AR) aging report lists unpaid customer invoices grouped by how long they have been outstanding.
- The usual groups, or "buckets," are current, 1 to 30 days past due, 31 to 60, 61 to 90 and over 90 days.
- The older an invoice gets, the harder it usually is to collect, so the report tells you where to focus first.
- Reviewing it weekly and following a clear collection routine helps protect your cash flow.
For many small businesses, the biggest cash problem is not a lack of sales. It is sales that have not turned into money yet. A client says the payment is "in the system," another is waiting for a manager's approval, and a third has simply forgotten. Each one feels small. Together, they can leave you short when rent or payroll is due.
December makes this sharper. Clients slow down for the holidays, finance teams close for a week or two and invoices can sit untouched until January. Running your aging report in early December gives you time to chase what is owed before everyone disappears.
A quick note: this article is general information, not accounting, legal or tax advice. Rules on late payment, interest and writing off bad debts differ by country, so check with an accountant or the official guidance where you are.
What an accounts receivable aging report is
Accounts receivable is the money customers owe you for goods or services you have already delivered and invoiced. An aging report takes every unpaid invoice and sorts it by how long it has been outstanding, usually measured from the due date, though some businesses measure from the invoice date.
The result is a table with one row per customer and columns for each age group. At a glance you can see who pays on time, who is slipping and which balances need attention today.
The standard aging buckets
- Current: invoices that are not yet due.
- 1 to 30 days past due: often just a reminder away from payment.
- 31 to 60 days past due: time for a firmer, more personal follow-up.
- 61 to 90 days past due: a real warning sign that needs direct action.
- Over 90 days past due: serious risk. Decide on next steps, from a payment plan to formal collection.
You can adjust the buckets to suit your terms. If you invoice on 14-day terms, you might prefer 1 to 14, 15 to 30 and so on. What matters is using the same buckets every time so you can compare week to week.
How to read an aging report
Looking at the report is easy. Reading it well means asking a few specific questions.
- Check the total. How much money is owed to you in all? Compare it with last week or last month. A rising total with flat sales means customers are paying more slowly.
- Look at the oldest buckets first. Anything over 60 days deserves a name, a reason and a next action.
- Spot concentration. If one customer makes up a large share of what you are owed, a single late payment from them could hurt your cash flow.
- Find patterns. Do the same customers always drift into the 31 to 60 bucket? That suggests a process problem on their side or yours, such as missing purchase order numbers.
- Check for errors. Old balances are sometimes caused by disputes, wrong amounts or payments that were received but not matched to the invoice. Clean these up so the report shows reality.
Common mistake
Only looking at the total. A healthy-looking total can hide one large invoice that is four months old. Always read the oldest buckets customer by customer, not just the bottom line.
A simple aging report template
Most invoicing and accounting tools can produce an aging report for you. If yours does not, or you want a quick manual version, this spreadsheet layout works well. The names and amounts below are made up for illustration.
| Customer | Current (example) | 1 to 30 days (example) | 31 to 60 days (example) | 61 to 90 days (example) | Over 90 days (example) | Total (example) | Next action |
|---|---|---|---|---|---|---|---|
| Northside Dental | $1,200 | $0 | $0 | $0 | $0 | $1,200 | None, not yet due |
| Harbor Events Ltd | $0 | $2,400 | $1,100 | $0 | $0 | $3,500 | Call accounts payable this week |
| Greenway Cafe | $0 | $0 | $0 | $650 | $900 | $1,550 | Owner meeting, propose payment plan |
To build it, list every open invoice with its customer, amount and due date. Add a column that calculates days past due (today's date minus the due date), then use that number to place each invoice in the right bucket. A pivot table or simple sum by customer gives you the summary view above.
Pro tip
Add a "Next action" and "Last contact" column to your report. It turns a list of numbers into a to-do list and stops two people on your team chasing the same customer on the same day.
Useful numbers to track alongside the report
- Share of receivables over 60 days: the amount in the 61 to 90 and over 90 buckets divided by total receivables. Watch whether it rises or falls over time.
- Average days to pay by customer: how long each customer usually takes from invoice to payment. It helps you set terms and forecast cash.
- Days sales outstanding (DSO): a common measure of how quickly you collect, usually calculated as receivables divided by credit sales for a period, multiplied by the number of days in that period.
There is no single "right" level for these numbers. Compare them with your own past results and your payment terms.
Turning the report into a collection routine
An aging report only helps if it leads to action. The simplest way is to match each bucket with a standard response, then work through the report on the same day every week.
Current: prevent problems
Send clear invoices with the due date, amount, payment methods and any reference the customer needs, such as a purchase order number. A friendly reminder a few days before the due date works well for customers who often pay late.
1 to 30 days: a polite nudge
Send a short reminder with the invoice attached. Many late payments are simple oversights. Keep the tone warm and assume good intent.
31 to 60 days: personal follow-up
Pick up the phone or write directly to the person who approves payments. Ask whether there is a problem with the invoice and agree a specific payment date. Write it down in your report.
61 to 90 days: firm and clear
Send a formal reminder stating the amount, the original due date and what happens next, such as pausing further work. Offer a payment plan if the customer is struggling but willing.
Over 90 days: decide
Decide whether to keep chasing, use a formal process such as a letter before action or a collection service, or accept the loss. In some countries you may have a legal right to charge interest on late commercial payments; check the official rules where you and your customer are based. If you think a debt cannot be recovered, talk to your accountant about how to record it.
Example
Imagine Tomas, who runs a small video production studio. In early December his aging report shows $4,000 in the 31 to 60 bucket, almost all from one events client. He calls their accounts team and learns the invoice was missing a purchase order number, so it was sitting in a queue. He reissues it the same day, and it gets paid before their office closes for the holidays. Without the report, he might not have noticed until mid-January. (Tomas and his numbers are made up for illustration.)
Common mistake
Continuing to deliver work for a customer whose balance keeps aging. It feels awkward to pause, but every new invoice adds to the risk. Agree on a clear policy, such as pausing new work once a balance passes a set age, and share it in your terms upfront.
Reducing late payments before they happen
The best aging report is a short one. A few habits keep more invoices in the "current" column:
- Set clear terms in writing before the work starts, including due dates and what happens if payment is late.
- Invoice promptly. The day the work is done is better than the end of the month.
- Make paying easy. Offer more than one payment method and include payment links where your tools allow it.
- Ask for deposits on large or long projects, and consider milestone billing.
- Check new customers. For big orders, ask for references or start with smaller amounts until trust is built.
- Plan around holidays. In late November and early December, ask clients when their finance team closes so you can invoice in time.
If slow payments are a constant cash squeeze, some businesses look at financing options such as invoice factoring, but fixing your terms and routine usually comes first.
Your AR aging action plan
- Run an aging report from your invoicing tool or build one in a spreadsheet
- Use consistent buckets: current, 1 to 30, 31 to 60, 61 to 90 and over 90 days
- Add "Next action" and "Last contact" columns
- Review the oldest buckets first, customer by customer
- Match each bucket with a standard follow-up message or call
- Clean up errors, disputes and unmatched payments
- Block 30 minutes on the same day every week to work the report
- Contact clients about holiday office closures before mid-December
Frequently asked questions
How often should I run an accounts receivable aging report?
Weekly works well for most small businesses. If you have only a few large invoices, every two weeks may be enough. Before the holidays or a big expense, run it more often.
Should aging start from the invoice date or the due date?
Either can work, but be consistent. Measuring from the due date shows how late customers are. Measuring from the invoice date shows total time to get paid. Many tools let you choose.
What should I do with invoices I will never collect?
Once you have made reasonable efforts, talk to your accountant about writing the debt off. The rules for recording bad debts and any tax treatment vary by country, so get advice for your situation.
Is an aging report useful for freelancers?
Yes. Even with a handful of clients, a simple list of unpaid invoices sorted by age makes it much easier to follow up on time and plan your cash.
Related reading
The bottom line
An accounts receivable aging report shows who owes you money and for how long, sorted so the oldest and riskiest balances stand out. Build or run one, read the oldest buckets first, and pair each bucket with a clear follow-up step.
Set aside 30 minutes each week, especially in the run-up to the holidays, and you will turn more of the money you have already earned into cash in the bank.
