What Is an Invoice Aging Report and Why Every Business Needs One
An invoice aging report — also called an accounts receivable (A/R) aging report — is a financial document that categorizes your outstanding invoices by how long they have been unpaid. Rather than showing a single total of money owed, an aging report breaks that number into time buckets: invoices not yet due (Current), 1-30 days overdue, 31-60 days overdue, 61-90 days overdue, and 90+ days overdue (Critical). This bucketed view is one of the most important cash flow management tools for freelancers, consultants, and small businesses because it shows not just how much you are owed, but how likely you are to actually collect it.
After running your aging report: The report tells you what to do — your action in each bucket should be different. Use our Invoice Follow-Up Email Generator to send the appropriately-toned email for each bucket: friendly for 1-30 days, professional for 31-60, firm for 61-90, and final notice for 90+.
How to Read Your Aging Report: What the Buckets Mean
Each aging bucket represents a different level of collection difficulty and requires a different response. Understanding what your bucket distribution tells you is the most valuable skill in accounts receivable management:
Current (Not Yet Due)
No action required. Consider sending a pre-due reminder 3 days before the due date — businesses that do this report 15-20% fewer late payments. A healthy aging report has the majority of its receivables in this bucket.
1-30 Days Overdue
Send a polite, friendly email reminder. Approximately 70% of invoices in this bucket pay within 5 business days of a reminder. The payment is likely just delayed — do not escalate until you have sent 2-3 reminders. No late fees yet unless your terms specify them from Day 1.
31-60 Days Overdue
Escalate to a phone call plus a firm-toned email. Request a specific payment commitment date in writing. Consider suspending new work for this client until the balance is resolved. Apply late fees if stated in your original payment terms. Recovery rate at this stage is approximately 60-70% with active follow-up.
61-90 Days Overdue — Critical
This is the most important bucket to act on immediately. Recovery rate drops sharply after 90 days — accounts in this range still have a 50-60% recovery rate with aggressive action, but that drops to below 40% once they cross into 90+. Send a formal escalation letter or final notice. Set a hard 7-day deadline. Apply all accrued late fees.
90+ Days Overdue — Refer to Collections
Recovery rate below 40-50%. Standard collection efforts have a high failure rate at this stage. Refer to a collections attorney or third-party agency. For amounts under $5,000-$10,000, small claims court is often the most cost-effective path. Consider writing off amounts under $200 as uncollectable.
What a Healthy Aging Report Looks Like
The distribution of your receivables across aging buckets is one of the most revealing indicators of your business's financial health and the effectiveness of your collection process. Here are the benchmarks used by accountants and bookkeepers to assess accounts receivable health:
- 80%+of total receivables in the Current or 1-30 day bucket — this is the target for a well-managed A/R portfolio
- Under 15%in the 31-60 day bucket — anything higher indicates your reminders are not aggressive enough
- Under 5%in the 90+ day bucket — if this exceeds 10%, you likely have systemic collection problems requiring process changes
- DSO 30-45Days Sales Outstanding (total receivables ÷ average daily sales) — industry standard is 30-45 days; higher indicates slow collections
Invoices in the 61-90 day bucket? Act immediately — this is the last stage with a reasonable recovery rate. Send a formal escalation letter with a hard 7-day deadline. Use our Invoice Escalation Letter Generator to create a professional formal notice, or our Final Notice Generator for accounts approaching 90 days.
How Often to Run an Aging Report
The frequency of your aging report depends on your invoice volume and payment terms. As a general rule, run your aging report at least as frequently as your shortest payment term. If your standard payment terms are Net 30, run an aging report every 2 weeks. If you use Net 15 terms, run it weekly.
Many small businesses find that the 1st and 15th of each month are natural aging report dates — they align with payroll cycles, which is when most businesses process payments. Running the report on these dates also makes it easy to compare month-over-month trends in your A/R health.
The value of regular aging reports is cumulative. A single report tells you your current status. Monthly reports over time reveal trends — are your 31-60 day totals growing? Are the same clients repeatedly appearing in the 60+ bucket? These patterns are more valuable than any single snapshot and enable proactive policy changes like requiring deposits, shortening payment terms, or pausing work for chronic late payers.
Need to add late fees to aging invoices? Only apply late fees if they were stated in your original payment terms. Use our Late Fee Calculator to calculate the legally compliant amount for Australia, US, UK, or Canada before including it in your collection communications. Applying an undisclosed late fee can undermine your legal position.
Using Aging Reports to Identify Problem Clients
One of the most powerful uses of regular aging reports is identifying chronic late payers before they become a significant financial liability. A client who consistently appears in the 31-60 day bucket is telling you something important about their payment behavior — and that information should inform how you structure future work with them.
Practical policy changes for clients who appear repeatedly in aging buckets beyond 30 days include requiring a 25-50% deposit before starting new work, shortening payment terms from Net 30 to Net 15 or Net 7, requiring credit card payment on file, and adding automatic late fee clauses to new contracts. These changes are far easier to implement proactively than to negotiate after a payment dispute.
Frequently Asked Questions
What is an invoice aging report?
An invoice aging report (also called an A/R aging report or accounts receivable aging schedule) categorizes your unpaid invoices by how long they have been outstanding. It groups invoices into buckets: Current (not yet due), 1-30 days overdue, 31-60 days, 61-90 days, and 90+ days. This report is a fundamental cash flow management tool that helps identify collection risks and prioritize action.
How often should I run an aging report?
Run aging reports at least monthly, ideally every 2 weeks for businesses with Net 30 payment terms, or weekly for those with Net 15 terms. The 1st and 15th of each month are natural reporting dates that align with typical business payment cycles. Regular reporting helps identify trends — not just your current A/R status.
What is a healthy accounts receivable aging ratio?
A healthy aging report has 80%+ of receivables in the Current or 1-30 day bucket, less than 15% in 31-60 days, and under 5% in 90+ days. If more than 20% of your total receivables are over 60 days old, your collection process needs immediate attention. Your Days Sales Outstanding (DSO) should ideally be between 30-45 days.
Which aging bucket should I prioritize for collections?
Prioritize the 61-90 day bucket. Invoices in this range are old enough to require escalated action but still have a 50-60% recovery rate with firm collection efforts. Once invoices cross into 90+ days, recovery rates drop below 40-50%. The 31-60 day bucket should receive active follow-up calls and firm emails. The 90+ bucket should be referred to a collections agency or attorney.
Can I track partial payments in this aging report?
Yes. Each invoice row has a Paid field where you can enter any amount already received. The tool automatically calculates and displays the outstanding balance — the amount still owed. This is especially useful for clients on payment plans or who have made partial payments without clearing the full invoice.
Is this aging report generator free to use?
Yes, completely free with no signup required. Add as many invoices as you need, see live bucket calculations, and download the formatted aging report as a text file. For automated aging reports, reminder scheduling by bucket, and collection tracking across all your clients, InvoiceFollowUps handles the entire process automatically.
Automate Your Entire A/R Process
InvoiceFollowUps auto-generates aging reports, sends bucket-appropriate reminders, and tracks collection progress — so you always know exactly what to do and when.
Related Free Tools
- Invoice Follow-Up Email Generator — send bucket-appropriate reminder emails for each aging stage
- Late Fee Calculator — calculate legally compliant fees for 31+ day overdue invoices
- Escalation Letter Generator — formal notices for 61-90 day invoices
- Final Notice Generator — demand letters for 90+ day invoices before collections referral
- Collection Timeline Generator — build a full action plan with dates for each collection stage