When payroll is due next Thursday and your bank balance is thin, an unpaid invoice on a spreadsheet is useless. Managing cash flow for a growing business means knowing exactly who owes you money—and how many days that cash has been sitting on their books.
Many small finance teams wait until cash runs tight to check on outstanding payments. By then, you are already playing catch-up. A structured accounts receivable (AR) aging report turns this reactive scramble into a predictable, weekly routine.
What is an AR aging report?
An AR aging report is a standard financial document. It categorizes your outstanding customer invoices by the number of days they have been unpaid. Instead of looking at a single lump sum of total accounts receivable, this report breaks your receivables down into time-based columns—commonly referred to as "buckets."
Most accounting platforms, like QuickBooks Online or Xero, generate these reports automatically. The report typically organizes your outstanding balances into five columns:
- Current: Invoices that are not yet due.
- 1–30 days past due: Invoices that missed their due date by up to a month.
- 31–60 days past due: Invoices that are one to two months overdue.
- 61–90 days past due: Invoices that are two to three months overdue.
- 91+ days past due: Invoices that are severely delinquent and at risk of becoming bad debt.
For a finance manager or founder, this report serves as a diagnostic tool. It shows you the exact health of your cash flow. If most of your outstanding receivables sit in the younger buckets, your collection process is healthy. If the balance tilts toward the older buckets, your cash is trapped—and you need to change your approach.
A quick worked example
Let us look at a typical scenario for a business with $50,000 in total outstanding accounts receivable.
| Customer | Total Owed | Current | 1–30 Days | 31–60 Days | 61–90 Days | 91+ Days |
|---|---|---|---|---|---|---|
| Customer A | $10,000 | $10,000 | $0 | $0 | $0 | $0 |
| Customer B | $25,000 | $0 | $20,000 | $5,000 | $0 | $0 |
| Customer C | $15,000 | $0 | $0 | $0 | $10,000 | $5,000 |
| Total | $50,000 | $10,000 | $20,000 | $5,000 | $10,000 | $5,000 |
In this illustrative example, Customer A is in good standing. Customer B has a small amount drifting into the 31–60 days bucket. Customer C represents a significant risk, with $15,000 past the 60-day mark.
Here is how to handle each of these buckets to keep your cash flowing.
The 0–30 days bucket: maintaining momentum
Invoices in this bucket are either not yet due or only slightly overdue. This is the preventative stage. Your goal here is to make payment as friction-free as possible so invoices do not slide into the next category.
Often, delays in this stage happen because of simple administrative errors. A customer might not have received the invoice—or the invoice might lack the purchase order (PO) number their accounts payable department requires.
To keep this bucket dominant, establish these habits:
- Send invoices immediately: Do not wait until the end of the month to bill for completed work. Send the invoice the moment the milestone is met or the product is delivered.
- Include clear payment terms: State the exact due date on the document. Avoid vague terms like "upon receipt" if you actually expect payment within 15 days.
- Offer digital payment options: Provide ACH and credit card payment links directly on the invoice. If a customer has to print a paper check to pay you, you will wait longer.
The 31–60 days bucket: early intervention
When an invoice crosses the 30-day mark, it enters the first stage of delinquency. The customer has missed their initial payment window. It is time for polite but firm follow-up.
At this stage, the delay is usually due to oversight, a misplaced email, or a minor dispute. Your communication should assume the customer simply forgot.
Your action plan for this bucket should include:
- Automated email reminders: Set up your system to send a gentle reminder three to five days after the due date, followed by another at 15 days past due.
- A quick check-in call: If the automated emails go unanswered, have a team member call the client's AP contact. Ask a simple question: "Did you receive invoice #104, and do you need any additional information to process it?"
- Confirming receipt: Ensure the invoice did not get stuck in a spam filter—or sit on the desk of a manager who left the company.
The 61–90 days bucket: escalating the outreach
Invoices that reach this bucket are significantly overdue. This is no longer a simple oversight. The customer may be experiencing cash flow issues of their own—or there may be a deeper dispute about your services.
At this point, automated emails are no longer enough. You must transition to direct human intervention.
Take these steps immediately:
- Pick up the phone: Call the decision-maker directly, not just the general accounts payable inbox. Secure a firm commitment on when the payment will be processed.
- Pause ongoing work: If your contract allows, pause services or shipments for this client. Let them know politely that you cannot perform additional work until the outstanding balance is cleared.
- Offer a payment plan: If the customer is facing temporary financial hardship, negotiate a structured payment plan. Receiving $1,000 a week for five weeks is better than waiting indefinitely for a $5,000 lump sum.
The 91+ days bucket: mitigating bad debt
This is the high-risk category. Once an invoice is more than 90 days overdue, the likelihood of collecting the full amount drops significantly. Every week that passes makes collection less likely.
At this stage, you must protect your business from total loss. You are no longer trying to maintain a warm customer relationship—you are trying to recover capital.
Your options for the 91+ days bucket include:
- Sending a formal demand letter: Have your legal counsel or executive team draft a formal letter stating that you will pursue legal action or collections if payment is not received by a specific date.
- Using a collections agency: If the customer remains unresponsive, you may need to hand the account over to a professional collection agency. Be prepared to forfeit a percentage of the recovered funds (often 20% to 50%) as their fee.
- Writing off the balance: If the customer has gone out of business or the cost of collection exceeds the value of the invoice, you may need to write the balance off as bad debt. Work with your CPA to ensure you claim the appropriate tax deduction for the write-off.
How to simplify your AR tracking with LedgerFlow
Managing these buckets manually using spreadsheets and email reminders takes hours of manual work. It also leaves too much room for human error.
LedgerFlow helps small finance teams keep their AR aging reports clean. The platform syncs with QuickBooks Online and Xero to give you a clear, real-time view of your outstanding balances. Instead of manual follow-ups, you can set up automated payment reminders that nudge customers as soon as they slide into a new aging bucket.
By automating the early stages of collections, your finance team can spend less time sending emails and more time resolving the complex payment delays that impact your bottom line.
If you want to spend less time managing spreadsheets and more time growing your business, consider trying a dedicated AR tool. LedgerFlow offers a simple, clear way to track your invoices and automate your payment reminders.
FAQs
What is a healthy percentage for the 91+ days AR aging bucket?
Ideally, your 91+ days aging bucket should represent less than 5% of your total outstanding accounts receivable. If this percentage grows larger, it indicates a systemic collection issue or potential bad debt that could impact your operational cash flow.
How often should a finance manager review the AR aging report?
For companies with 5 to 50 employees, a weekly review is best practice. This frequency allows you to spot overdue invoices early enough to intervene before they slip into older, harder-to-collect buckets.
What is the difference between AR aging and the AR turnover ratio?
The AR aging report is a detailed breakdown showing exactly how long specific unpaid invoices have been outstanding. The AR turnover ratio is a high-level metric that measures how many times a company collects its average accounts receivable balance during a specific period.