Every Friday afternoon, small finance teams face the same pressure. You look at your cash balance, compare it to your upcoming payroll, and realize there is a gap. The revenue is on your books — but the cash is not in your bank account.
Unpaid invoices are the silent killer of growing businesses. To keep your operations running smoothly, you cannot treat all outstanding invoices the same way. A customer who is three days late requires a very different approach than one who is three months late.
This is where the accounts receivable (AR) aging report becomes your most important tool. It tells you exactly who owes you money, how much they owe, and how long they have been holding onto it.
What is an accounts receivable aging report?
An accounts receivable aging report is a standard accounting document that categorizes your outstanding customer invoices by the number of days they have been unpaid.
Typically, the report organizes your receivables into thirty-day increments, known as "aging buckets":
- 0 to 30 days (Current)
- 31 to 60 days (Slightly overdue)
- 61 to 90 days (Seriously overdue)
- 90+ days (High risk)
Most accounting platforms — such as QuickBooks Online or Xero — generate this report with a single click. If you do not use dedicated software, you can build one manually in Excel, though keeping it updated requires constant manual work.
For finance managers, this report is a diagnostic tool. It measures your collection efficiency. If too much of your cash is sitting in the older buckets, your cash flow will stall. By reviewing this report weekly, you can spot payment bottlenecks before they threaten your payroll or vendor payments.
A realistic example of an AR aging report
To see how this works in practice, let us look at a realistic example of a fictional business.
Imagine a professional services firm with $100,000 in total outstanding accounts receivable. (Note: These numbers are illustrative examples for this guide.)
| Customer Name | Total Outstanding | 0–30 Days | 31–60 Days | 61–90 Days | 90+ Days |
|---|---|---|---|---|---|
| Acme Corp | $40,000 | $40,000 | $0 | $0 | $0 |
| Baker Industries | $25,000 | $15,000 | $10,000 | $0 | $0 |
| Carter & Co. | $20,000 | $0 | $5,000 | $15,000 | $0 |
| Delta Ltd. | $15,000 | $0 | $0 | $0 | $15,000 |
| Total | $100,000 | $55,000 | $15,000 | $15,000 | $15,000 |
| Percentage | 100% | 55% | 15% | 15% | 15% |
In this example, 55% of the outstanding AR is current (0 to 30 days). This is healthy. However, Carter & Co. has a large balance in the 61 to 90 days bucket, and Delta Ltd. has $15,000 that is more than three months overdue.
This firm has a concentration risk. A single customer — Delta Ltd. — represents 15% of their total unpaid cash and is highly overdue. The finance manager must treat each of these customers differently based on their respective buckets.
The 0 to 30 days bucket: Keeping payments on track
Invoices in the 0 to 30 days bucket are either not yet due or only slightly past their due date. This is the "current" bucket.
Your goal here is prevention. You want to make payment as friction-free as possible so these invoices do not slip into the next category.
Action steps for this bucket:
- Send invoices immediately: Do not wait until the end of the month to bill your clients. Send the invoice as soon as you deliver the work or product.
- Provide clear payment options: Include direct payment links on your digital invoices. Offer ACH and credit card options so customers can pay with a click.
- Automate your reminders: Set up a polite reminder to go out three days before the due date, and another on the actual due date.
- Confirm receipt: For high-value invoices, send a quick automated note asking the client to confirm they received the invoice and that the billing details are correct.
The 31 to 60 days bucket: Friendly follow-ups and identifying friction
When an invoice crosses the 30-day mark, it is officially overdue. At this stage, you should assume the delay is an oversight or a minor administrative issue.
Perhaps the invoice went to the wrong email address, or the client's accounts payable manager was on vacation. Your tone should remain polite, helpful, and professional.
Action steps for this bucket:
- Send a soft email reminder: Send a brief email on day 32. Keep the tone friendly. Ask if they need another copy of the invoice or if they have any questions about the billing.
- Verify the contact details: Call or email your primary contact to confirm that the invoice reached the right person in their accounts payable department.
- Check for disputes: Sometimes, clients withhold payment because they are unhappy with a specific line item but fail to tell you. Ask directly if there is any issue with the work or the invoice details. Resolving these disputes early prevents long-term delays.
The 61 to 90 days bucket: Direct outreach and payment plans
Invoices in the 61 to 90 days bucket require active, direct intervention. Automated emails are no longer enough. At this point, the customer is intentionally delaying payment, or they are facing their own cash flow difficulties.
You must transition from passive reminders to direct, personal communication.
Action steps for this bucket:
- Pick up the phone: Email is easy to ignore. A phone call is not. Call the accounts payable department directly. If you cannot reach them, call your primary business contact at the company.
- Identify the decision-maker: Find out who actually approves the payments. It might be the CFO, the founder, or a department head.
- Offer structured payment plans: If the client is experiencing temporary cash flow issues, offer a compromise. Ask for a 50% partial payment immediately, with the remaining balance split over the next two months. Getting some cash now is better than getting nothing later.
- Pause ongoing work: If you provide recurring services, notify the client that you will pause work until they resolve their past-due balance. This often speeds up their internal approval process.
The 90+ days bucket: Final notices and bad debt write-offs
When an invoice is more than 90 days overdue, the likelihood of collecting it drops significantly. This is a critical stage. You must protect your business from bad debt while preparing for the reality that you might not collect the full amount.
Action steps for this bucket:
- Send a formal final demand letter: This is a formal letter stating that if they do not pay the balance by a specific date, you will take legal action or send the account to collections. Send this via certified mail so you have proof of delivery.
- Involve a collections agency: If the customer ignores your final demand, you may want to hand the account over to a third-party collections agency. Keep in mind that these agencies typically take a percentage of the recovered amount.
- Consider legal action: For very large balances, consult with your legal counsel to see if filing a lawsuit is financially practical.
- Write off the bad debt: If recovery efforts fail or cost more than the invoice is worth, write the balance off as bad debt. This cleans up your balance sheet and can provide a tax deduction for the uncollectible revenue.
How to simplify AR tracking with LedgerFlow
Managing these aging buckets manually in spreadsheets is time-consuming and prone to errors. Small finance teams often struggle to keep up with the constant back-and-forth emails and phone calls required to keep aging buckets clean.
LedgerFlow helps simplify this process. Our AR aging dashboard syncs directly with your QuickBooks Online or Xero account — giving you a clear, real-time view of your outstanding balances without manual data entry. You can set up automated, customizable reminder sequences that scale your outreach as an invoice moves from the 0-30 bucket to the 61-90 bucket.
If you want to spend less time chasing past-due invoices and more time growing your business, consider trying LedgerFlow to automate your collections.
FAQs
What is a healthy percentage for the 90+ days AR aging bucket?
Generally, a healthy business should aim to keep its 90+ days aging bucket under 5% to 10% of total outstanding receivables. Anything higher suggests that your collections process needs adjustment or that you may be extending credit to high-risk customers.
How often should a finance manager review the AR aging report?
You should review your AR aging report at least once a week. Regular weekly reviews allow you to catch overdue invoices early, trigger timely reminders, and maintain a steady, predictable cash flow.
What is the difference between AR aging and AP aging?
Accounts receivable (AR) aging tracks the money that customers owe to your business. Accounts payable (AP) aging tracks the money your business owes to suppliers and vendors. Both are essential for managing your overall working capital.
How do you calculate Days Sales Outstanding (DSO) using the aging report?
To calculate DSO, divide your total outstanding accounts receivable by your total credit sales over a specific period, then multiply that number by the number of days in that period. A rising DSO indicates that collections are slowing down across your aging buckets.