If you have ever looked at your bank balance and thought, “But we have plenty of sales,” you have already met the problem an accounts receivable (A/R) aging report is designed to solve. Revenue is great, but revenue you cannot collect on time does not pay payroll, rent, inventory, or taxes.
An A/R aging report turns your unpaid invoices into a simple, time-based scoreboard. It shows exactly who owes you money, how much, and how late it is. Used well, it becomes one of the most practical cash-flow tools a business owner can review weekly.
What an accounts receivable aging report is
An accounts receivable aging report is a list of all unpaid customer invoices (and sometimes unapplied credits) grouped into “aging buckets” based on how many days they have been outstanding.
Think of it like the “produce drawer” in your fridge. Fresh items go in front where you will use them first. The older items need attention now, before they spoil. In A/R terms, “spoilage” is bad debt, meaning you never collect.
What it typically includes
- Customer name (and sometimes contact info)
- Invoice number and invoice date
- Due date (based on your payment terms, like Net 15 or Net 30)
- Invoice amount and remaining balance
- Days past due (or days outstanding)
- Aging bucket total by customer and for the entire company
Most accounting systems generate this automatically. The value is not the report itself. The value is what you do with it.
How aging buckets work
Aging buckets are time ranges. Businesses commonly use five columns:
- Current (not past due yet, or 0 to 30 days depending on the report style)
- 1 to 30 days past due
- 31 to 60 days past due
- 61 to 90 days past due
- 91+ days past due
There are two common ways software defines these buckets:
- By days past due: The clock starts after the due date. This is my preference for collections because it aligns with your credit policy.
- By days outstanding: The clock starts at the invoice date. This can be useful for internal tracking, but it is less precise if different customers have different terms.
A simple example
Let’s say you invoice a client on May 1 with Net 30 terms. The due date is 30 days later (often around May 31, depending on how your terms are defined and how days are counted).
- If today is June 10, that invoice is about 10 days past due and lands in the 1 to 30 bucket.
- If today is July 5, it is about 35 days past due and lands in 31 to 60.
If you are building an aging report manually in a spreadsheet, the formula is straightforward: Days past due = Today’s date minus Due date. Then assign a bucket based on the result.
How to read the report
When you first open an aging report, it is tempting to zoom in on the biggest balance. Instead, scan it in this order:
1) Start with totals by bucket
This answers the real question: How much of our A/R is getting old? If your “Current” column is shrinking and the 31 to 60 and 61 to 90 columns are growing, collections likely needs attention now.
2) Identify concentration risk
Look for customers who make up a large portion of total receivables. One slow-paying large customer can create a cash-flow crunch even if everyone else pays on time.
3) Look for patterns
A single invoice that drifts into 31 to 60 happens. A customer who is always in 31 to 60 is effectively asking you to finance their business. That may be acceptable if it is priced in and controlled, but many owners never make that decision on purpose.
4) Compare the report to the story
If sales thinks a customer is “great” but the aging report shows persistent 60+ day balances, you have a mismatch worth addressing. Collections is not just an accounting task. It is a pricing, terms, and relationship management task.
5) Separate disputes from delinquency
One of the fastest ways to clean up your follow-up is to label what is truly late versus what is legitimately in dispute. A past-due invoice with a clear dispute and an owner on it is a different situation than a past-due invoice where nobody is responding. Track disputes, credit memos, and short pays with notes so your “late” list does not become a mix of real problems and accounting noise.
How to prioritize collections
The best collections process is boring, consistent, and documented. Your aging report tells you where to spend your limited time.
Priority order I recommend
- Invoices that are about to roll into the next bucket (for example, at 28 to 30 days past due). A small nudge now can prevent a receivable from becoming “someone else’s problem” later.
- High-dollar invoices in the 1 to 30 bucket. These have the best chance of being resolved quickly, and the cash impact is immediate.
- Any invoice in 31 to 60. This is often the “danger zone” where disputes harden and customers start treating your bill as optional.
- 61 to 90 and 91+. These require escalation and a decision: negotiate, set a payment plan, pause service, or route to collections or legal counsel depending on your business model.
Actions by bucket
- Current: Confirm invoice receipt, make it easy to pay (link, ACH details), verify the right approver is looped in.
- 1 to 30: Friendly reminder, resend invoice, confirm there is no PO mismatch or missing documentation.
- 31 to 60: Direct call, ask for a specific pay date, resolve disputes on the phone, confirm payment method.
- 61 to 90: Escalate to decision-maker, consider pausing new work or shipments, request partial payment now plus a schedule.
- 91+: Final demand process, evaluate collections agency, small claims, attorney letter, or write-off policy.
Owners sometimes worry that stronger collections will “hurt the relationship.” In my experience, clear payment expectations often improve relationships because they reduce awkwardness and prevent surprise escalations.
What healthy aging looks like
There is no universal perfect ratio because industries and billing cycles differ. A subscription business billing monthly will look different than a construction firm waiting on draw approvals. But in general, healthy A/R has three traits:
Most receivables are current
A strong report is weighted heavily toward “Current” and “1 to 30.” That suggests customers generally pay within terms, and your invoicing and follow-up processes are working.
Very little sits at 60+
Balances in 61 to 90 and 91+ should be the exception, not a normal part of your month-end close. When 60+ grows, the odds of non-collection often rise and the amount of time required to recover the cash increases.
Old balances are explainable
Healthy businesses can usually explain their outliers in one sentence: “That one is a documented dispute we expect to resolve next week,” or “That customer is on a signed payment plan.” Unhealthy aging is full of vague stories like “They are usually good for it” without a date, a plan, or a next step.
Red flags to watch
Aging reports often warn you before the bank account does. Here are the signals I would not ignore.
The 31 to 60 bucket keeps rising
This is a classic early warning sign. It can mean your follow-up is inconsistent, your invoicing is delayed, or customers are feeling pressure and stretching payables.
Customers pay slower as sales grow
If revenue is up but DSO is rising, you can end up growing yourself into a cash crunch. More sales can mean more cash tied up in receivables, especially if you are paying vendors and payroll before customers pay you.
One or two customers dominate A/R
If a single customer makes up a large share of your total receivables, their payment habits become your cash-flow reality. That is not always wrong, but it is a risk you should manage intentionally through tighter terms, deposits, progress billing, or credit limits.
Old invoices are messy
When 90+ balances exist because of preventable issues like missing purchase orders, unclear deliverables, incorrect bill-to addresses, or unapproved change orders, that points to process gaps. Process gaps create disputes, and disputes create delayed cash.
Credits and deductions pile up
Unapplied credits, partial payments with no notes, or repeated short pays can hide the true aging picture. If customers are constantly deducting for “issues,” you may have a service, fulfillment, or contract clarity problem, not just a collections problem.
Habits that keep aging down
You do not need an aggressive collections personality. You need a predictable system.
- Invoice fast: Bill as soon as the work is delivered or milestones are met. Delayed invoicing is self-inflicted aging.
- Make payment easy: Offer ACH, card, and clear remittance instructions. Reduce friction.
- Confirm receipt: A quick “Did this land with the right person?” email prevents week-long delays.
- Set a weekly A/R review: Even 20 minutes every week beats a panicked month-end scramble.
- Align sales and finance: Sales should know who is past due before they promise new work or flexible terms.
- Create an escalation path: Decide in advance what happens at 30, 45, 60, and 90 days.
If you are an owner wearing too many hats, delegate the first-level follow-up and keep escalation decisions (pause service, payment plans, write-offs) with leadership.
Quick FAQ
How often should I review my A/R aging report?
Weekly is ideal for most small and mid-sized businesses. If cash is tight or you have a few large customers, review it twice a week until things stabilize.
Is “Current” the same as “not due yet”?
Usually, yes. But some reports define “Current” as 0 to 30 days from invoice date, even if the invoice is technically past due under Net 15 terms. Double-check how your accounting software labels buckets.
When does an invoice become bad debt?
There is no single day count, but the likelihood of collecting often drops as invoices age, especially after 90 days. The right answer depends on your industry, your contract rights, and your collections options. What matters is having a clear policy for escalation and write-offs.
What is the difference between an aging report and DSO?
DSO (days sales outstanding) is a single metric that estimates how long it takes you to collect receivables. An aging report is the detailed list that shows which invoices are driving that number.
Does the aging report affect revenue recognition?
Not directly. Revenue recognition is about when revenue is earned under your accounting method and policies. Aging is about how quickly cash is collected. Mixing the two is a common source of confusion for newer owners, especially when sales look strong but cash is tight.
A final perspective
I grew up around a business where cash flow could swing based on weather, timing, and who paid on time. That experience taught me something simple: the businesses that sleep better are not always the ones with the biggest sales. They are the ones with the clearest visibility into their receivables and the discipline to act early.
If you take one action after reading this, make it this: open your A/R aging report, sort by oldest first, and pick your top five outreach targets for this week. Small, consistent moves here protect your cash flow far more than most people expect.
