An $80,000 accounts receivable balance can look reassuring until you discover that a substantial portion was due several weeks ago, one customer is disputing an invoice, and another has missed two promised payment dates.
An accounts receivable aging report helps separate money that is still within agreed payment terms from balances that need attention. For business owners making decisions about payroll, purchases, and upcoming tax payments, that distinction matters more than the total receivables balance alone.
At the beginning of the year, reviewing unpaid invoices also helps prevent last year’s collection problems from becoming part of this year’s routine. Older balances deserve a decision about what happens next, rather than another month on the report.
What Does an Accounts Receivable Aging Report Show?
An accounts receivable aging report organizes unpaid customer balances into time categories, usually showing amounts that are current, 1–30 days overdue, 31–60 days overdue, 61–90 days overdue, and more than 90 days overdue.
A summary report shows balances by customer. A detailed report allows you to investigate individual invoices, including their dates, amounts, and outstanding balances.
Before interpreting those categories, confirm how your software calculates aging. An invoice that is 45 days old is not necessarily 45 days overdue. If the customer has 60-day payment terms, that invoice may still be current.
For collection purposes, aging based on the contractual due date helps distinguish genuinely late payments from balances that are not yet due. Intuit’s guidance, for example, distinguishes current amounts from past-due amounts using the transaction’s due date.
How to Read an AR Aging Report
Start with the report date, the aging settings, and the total outstanding balance. Then look at how much has moved beyond its due date.
Consider this simplified example:
| Aging category | Outstanding balance | Share of total |
| Current, not overdue | $42,000 | 52.5% |
| 1–30 days overdue | $18,000 | 22.5% |
| 31–60 days overdue | $10,000 | 12.5% |
| 61–90 days overdue | $6,000 | 7.5% |
| More than 90 days overdue | $4,000 | 5.0% |
| Total accounts receivable | $80,000 | 100% |
Illustrative figures only.
Here, $38,000 is overdue, representing 47.5% of the total balance. Of that, $20,000 is more than 30 days past due.
Those figures give the owner a better starting point than “customers owe us $80,000.” They still do not explain when the money will arrive.
The next step is to review the customer and invoice details. The $10,000 in the oldest category could be spread across several accounts, or one customer could owe that entire amount across the two oldest categories. Each situation calls for different follow-up.
Confirm that the balances are accurate
Before contacting customers, check for payments that have arrived but have not been applied, pending credit memos, duplicate invoices, and incorrect due dates.
Reconcile the aging total to the corresponding accounts receivable ledger balance using consistent dates and report settings. Differences can arise from reporting settings or entries that affect the general ledger without flowing through the customer subledger.
This review protects the customer relationship as well as the books. Asking a customer to pay an invoice they already settled creates avoidable friction and wastes collection time.
Accounts Receivable Aging Analysis: Look Beyond the Oldest Column
The oldest invoices deserve attention, but a useful accounts receivable aging analysis also examines how balances are changing.
A customer whose invoices regularly move from current to 1–30 days overdue may be developing a payment pattern that needs addressing. Waiting until the account reaches 90 days overdue allows several billing cycles to accumulate.
Look at both dollar amounts and percentages. If new sales increase sharply, the overdue percentage may fall even though the amount of overdue debt has not improved.
Customer concentration also matters. A business might have relatively few overdue invoices but still depend heavily on one customer’s payment to cover the next payroll. That exposure deserves more attention than the invoice count suggests.
Keep collection notes alongside the report. Useful notes identify:
- The reason payment is delayed.
- The person responsible for resolving the issue.
- Any amount the customer disputes.
- The promised payment date and next follow-up date.
“Customer contacted” does not tell the owner much. “Invoice approved; payment scheduled for January 29; confirm receipt January 30” gives the team something specific to manage.
Track Days Sales Outstanding Alongside Aging
Days sales outstanding, or DSO, estimates how long a business takes to convert credit sales into cash. It provides a broader collection trend, while the aging report identifies the invoices requiring action.
A common calculation is:
DSO = (Average accounts receivable ÷ net credit sales) × days in the period
Use receivables and credit sales from the same period. A simple average receivables balance uses the beginning and ending balances divided by two; cash sales should be excluded from net credit sales.
For example, average receivables of $60,000 and net credit sales of $150,000 over a 90-day period produce a DSO of 36 days:
($60,000 ÷ $150,000) × 90 = 36 days
That does not mean every customer pays in 36 days, or that invoices are 36 days overdue. It is an overall collection measure.
Compare DSO with your payment terms, prior periods, and relevant industry patterns. Seasonal sales, changing customer terms, and large shifts in sales volume can affect the result. There is no single target that suits every business.
If DSO rises while more invoices move into older aging categories, investigate the underlying accounts. If DSO improves but several old balances remain untouched, those accounts still need a collection decision.
Build an Accounts Receivable Collection Process With Clear Ownership
An effective accounts receivable collection process begins before an invoice becomes overdue.
Confirm the billing contact, purchase order requirements, payment terms, and any documentation the customer needs to approve payment. A correct invoice sent to the wrong person can sit unpaid while both sides assume someone else is handling it.
Once an invoice is issued, use a consistent follow-up schedule. Reminders should include the invoice number, balance, due date, and a convenient way to pay. Automated reminders can support routine follow-up, while unresolved accounts may need a direct conversation.
Resolve the reason for nonpayment
A missing purchase order, a service dispute, and a customer’s cash shortage require different responses.
If documentation is missing, provide it and confirm that the invoice can proceed through approval. If part of the bill is disputed, clarify the disputed amount and request payment of the undisputed portion under the agreed terms.
When a customer requests installments, document the amounts and dates. Assign someone to monitor the arrangement. A payment plan that nobody follows up on can become another open-ended promise.
Decide when the account needs escalation
The person sending reminders should know when to involve the owner or account manager.
Repeated broken promises, an increasing unpaid balance, or requests for more work while older invoices remain unresolved may warrant a review of future credit terms. Depending on the agreement, options could include deposits, milestone billing, or a limit on additional credit.
Keep those decisions coordinated. Collection efforts become harder when one person requests payment while another continues approving new work without reviewing the account.
Make Overdue Invoice Management Part of Cash Planning
An aging report tells you what remains unpaid. Your cash forecast needs a realistic estimate of what will be collected and when.
For significant overdue invoices, base the expected receipt date on current information: approval status, customer communication, payment history, and unresolved disputes. Avoid putting every overdue invoice into next week’s receipts.
Keep uncertain collections visible rather than quietly treating them as dependable cash. If a large payment is essential to meeting an upcoming obligation, review what happens if it arrives later than expected.
Strong overdue invoice management also means distinguishing collections from accounting cleanup. A lower receivables balance could reflect customer payments, credit memos, or write-offs. Only the payments bring cash into the business.
An Old Invoice Is Not Automatically a Tax Deduction
An aging report can identify invoices that need a bad-debt review, but reaching 90 days overdue does not automatically make a balance deductible.
For unpaid customer invoices, tax treatment depends partly on the accounting method used for tax purposes. A cash-method business generally cannot deduct unpaid fees or similar income it never recognized. An accrual-method business may qualify for a deduction when previously included income becomes uncollectible and the applicable requirements are met.
The IRS requires support for worthlessness and reasonable collection efforts. Age alone is not sufficient evidence.
Keep invoices, correspondence, dispute records, and collection notes. Review questionable balances with your accountant before making year-end adjustments. An accounting allowance or book write-off does not, by itself, establish a tax deduction.
Frequently Asked Questions
What is the difference between outstanding and overdue invoices?
Outstanding invoices are unpaid invoices, including those still within their payment terms. Overdue invoices remain unpaid after their due dates. An invoice can therefore be outstanding without being late.
How do you calculate accounts receivable aging?
For an unpaid invoice, compare the report date with the payment due date. If payment is past due, place the remaining balance in the appropriate overdue category. An invoice 20 days past its due date belongs in the 1–30 days overdue category. Confirm your software’s aging basis before interpreting the results.
What is a good accounts receivable aging percentage?
There is no universal percentage. Payment terms, industry practices, and billing timing affect the distribution. Review the share of receivables past due, the actual dollars involved, and whether older balances are increasing compared with your own history.
What is a good days sales outstanding number?
A useful DSO target reflects your agreed payment terms and business model. A company offering net-15 terms should assess collection speed differently from one offering net-60 terms. Review trends consistently and investigate deterioration rather than relying on a single benchmark.
How do you collect overdue invoices without damaging customer relationships?
Start with an accurate balance and a clear, professional reminder. Confirm receipt of the invoice, identify any approval issue or dispute, and request a specific payment date. Consistent follow-up is easier to manage than allowing balances to build and then making an urgent demand.
How often should a small business review its AR aging report?
For a business that regularly invoices customers, a weekly review is a practical starting point. Review large or high-risk accounts more frequently when cash commitments depend on them. Include a fuller reconciliation and trend review in the monthly accounting close.
Turn Accounts Receivable Reporting Into Follow-Through
Better accounts receivable reporting should leave you with more than an updated total. You should know which invoices require action, who owns that action, and which payments can reasonably support the coming weeks’ commitments.
A well-maintained accounts receivable aging report gives those conversations a factual starting point. The improvement comes from resolving billing problems, following up on promises, and adjusting credit decisions when payment patterns change.
Prudent Accountants helps business owners improve bookkeeping, understand receivables, and connect financial reporting with cash flow and tax planning.
Contact Prudent Accountants to discuss your accounts receivable reporting and build a clearer picture of the payments your business is waiting on.
0 Comments