Free AR Aging Report Generator
Enter your outstanding invoices to instantly generate an accounts receivable aging report. See your AR bucketed by 0–30, 31–60, 61–90, and 90+ days overdue. Spot high-risk invoices before they become write-offs. Free, no account needed.
How to Read Your AR Aging Report
Each bucket tells you a different story — and requires a different action.
Friendly reminder (1–2 days overdue). Assume oversight. Most invoices in this bucket resolve quickly with one follow-up.
Firm follow-up with a specific payment deadline. Mention late fees if your contract includes a clause. Ask if anything is blocking payment.
Final notice email. Prepare a formal demand letter. Apply late fees. Consider suspending services if ongoing work is involved.
Formal demand letter via certified mail. Consider small claims court (for amounts within your jurisdiction's limit) or a collections agency.
Making the Most of Your Weekly AR Review
Run your AR aging report every Monday. In 30 minutes, you can:
- Identify any invoices that moved into a worse bucket this week
- Prioritize by amount × days overdue — largest risk first
- Generate follow-up emails for each invoice that needs action using the reminder generator
- Calculate late fees for any invoices past your policy threshold using the late fee calculator
- Update your chase history log for any invoices where you sent a reminder
Frequently Asked Questions
What is an accounts receivable aging report?+
An AR aging report (also called an aging schedule) groups your outstanding invoices by how long they've been overdue. The standard buckets are: 0–30 days (current/low risk), 31–60 days (medium risk), 61–90 days (high risk), and 90+ days (very high risk). It tells you at a glance where your cash is tied up and which clients need immediate follow-up.
Why should freelancers and small businesses use AR aging reports?+
Aging reports help you prioritize collections. The longer an invoice goes unpaid, the harder it becomes to collect. A client in the 90+ bucket has a much lower recovery probability than one in the 0–30 bucket. Reviewing your aging report weekly lets you act before invoices become uncollectable — catching issues early when they're still easy to resolve.
How often should I run an AR aging report?+
Weekly is ideal for businesses with 10+ active clients. Monthly is a minimum for any business that invoices clients regularly. The goal is to catch overdue invoices early — an invoice 7 days overdue is much easier to collect than one at 60+ days. Run it every Monday as part of your weekly AR review.
What should I do with invoices in the 61–90 and 90+ day buckets?+
These need immediate, firm action. For 61–90 days: send a final notice email with a specific deadline and mention consequences (late fees, escalation). For 90+ days: send a formal demand letter via certified mail, then consider a collections agency or small claims court for amounts over $500–$1,000. Use the free payment reminder generator with the Final Notice or Escalation tone.
How is this free tool different from InvoiceGrid's paid tracker?+
This free tool generates a one-time aging report snapshot. InvoiceGrid Pro tracks your invoices continuously — it automatically calculates aging in real time, shows overdue status on a live Kanban board, logs every follow-up (chase history), and surfaces which invoices need attention today via the Today View. It's the difference between a monthly snapshot and a live dashboard.
What is accounts receivable days (DSO) and why does it matter?+
Days Sales Outstanding (DSO) measures the average number of days it takes to collect payment after an invoice is sent. A lower DSO means you collect faster. For freelancers, DSO above 45 days typically signals that follow-up is inconsistent. Your AR aging report feeds directly into DSO — a large 31–60+ bucket drags your DSO up.
Now you see the problem. What are you going to do about it?
An aging report shows you which invoices are overdue. But it doesn't chase them for you. The next step is turning those aging buckets into action — following up with the right message at the right time.
InvoiceGrid connects the dots: see your aging data, generate the follow-up email, and log every chase — all in one place.
Accounts Receivable Aging: The Complete Guide
An accounts receivable aging report is the most important financial report most small businesses never look at. It tells you where your cash is tied up, which clients are at risk of not paying, and exactly what action to take — at a glance. Here is how to use it effectively.
What is Days Sales Outstanding (DSO)?
Days Sales Outstanding (DSO) measures the average number of days it takes to collect payment after an invoice is issued. It is the headline metric derived from your AR aging report. Formula: (Total Accounts Receivable ÷ Total Credit Sales) × Number of Days.
For freelancers and small businesses, a DSO below 30 days indicates strong collections. DSO of 30–45 days is typical. Above 45 days suggests systematic follow-up problems. The best way to reduce DSO: shorten payment terms (Net 14 vs Net 30), send pre-due reminders, and follow up within 24 hours of the due date passing.
What a Healthy AR Aging Looks Like
In a well-managed AR portfolio, the majority of your outstanding balance should sit in the 0–30 day bucket. A rough benchmark for healthy AR:
- 0–30 days: 70–80% of total AR balance
- 31–60 days: 15–20% of total AR balance
- 61–90 days: 5% or less
- 90+ days: Under 3% — anything higher signals a collections process problem
If your 61–90 and 90+ buckets are large relative to total AR, you have a systematic follow-up gap — invoices are aging past the point where they're easy to collect without intervention.
The Most Common Causes of AR Aging Problems
- Delayed first follow-up.Waiting a week after the due date before chasing gives clients 7 free days of non-payment and signals that you're not watching closely.
- Invoiced to the wrong contact.The person you work with day-to-day is often not the person who processes payments. An invoice sitting in the wrong inbox ages silently.
- Missing PO numbers.Corporate accounts payable teams often won't process invoices without a purchase order reference. Always ask new clients if a PO is required.
- No systematic follow-up.Chasing based on memory rather than a schedule means the easy-to-chase clients get followed up while the awkward ones age.
- Net 30+ terms.Long payment terms push invoices into the 31–60 day bucket before they're even overdue. Consider Net 14 as your default.
How to Improve Your AR Aging Over 90 Days
Three changes reduce AR aging significantly without requiring new software: (1) shorten payment terms from Net 30 to Net 14; (2) send a pre-due reminder 3 days before every due date; (3) follow up within 24 hours of the due date passing — not 7 days later. Together, these three changes typically reduce average DSO by 15–25 days within 2–3 billing cycles.
For the systematic follow-up process, use the follow-up schedule planner to map the exact dates for each invoice. For clients in the 61–90 day bucket, see the overdue invoice letter templates. For 90+ day invoices, see what happens if an invoice is never paid.
One report shows today's damage. A live dashboard prevents tomorrow's.
This report gives you a snapshot. InvoiceGrid keeps it live — every invoice automatically bucketed by age, updated the moment you log a payment or send a chase. No manual updates, no spreadsheet.
- ✓Live AR aging dashboard — see every bucket update in real time
- ✓Chase history alongside each invoice — see what's been done and what's next
- ✓One-click reminder from any overdue invoice row without switching apps
Also useful: Payment reminder email generator · Follow-up schedule planner · Accounts receivable for freelancers · Which overdue invoice to chase first · How to track unpaid invoices