Every unpaid invoice is cash your business has earned but can’t use. Most customers pay a little late now and then; the real risk is the invoice that quietly slides from 30 to 60 to 120 days overdue while nobody is watching. An accounts receivable aging report is how you watch.

Use the free online calculator on this page or download the Excel template. Either way, a simple list of open invoices becomes a full aging report: balances by customer and age bucket, the share of receivables that’s overdue, your days sales outstanding (DSO), and a list of the ten largest overdue invoices so you know exactly who to call first.
Free, no sign-up. Works in Excel, Google Sheets and LibreOffice.
Free online A/R aging calculator
Prefer not to download anything? Enter your open invoices below and the aging report builds itself as you type. When you’re done, print it, save it as a PDF, download it as Excel, Word or CSV, or send it to your accountant or business partner with a share link. With a free account you can also save the report and open it again later.
3. Your aging report
Largest overdue invoices
Made with the free A/R aging tool at bookkeepingsheets.com
What is an accounts receivable aging report?
It’s a table that groups the money customers owe you by how long it has been overdue. The standard buckets are current (not yet due), 1–30 days, 31–60 days, 61–90 days and over 90 days past due. Each customer gets a row, so you can see at a glance who pays on time and who is drifting.
The older an invoice gets, the less likely it is to be paid in full. That’s why aging matters more than the total amount owed: $10,000 of receivables that are all current is healthy, while $10,000 that’s mostly over 90 days is a problem.
Accounts receivable aging report example
Here is a sample A/R aging report for a small business with six customers and $19,750 in unpaid invoices on the report date. Each invoice is placed in a column based on how many days it is past its due date. (The customers are made up for this example.)
| Customer | Current | 1-30 days | 31-60 days | 61-90 days | Over 90 | Total |
|---|---|---|---|---|---|---|
| Acme Plumbing | $2,400 | – | – | – | – | $2,400 |
| Brightline Dental | $1,850 | $1,200 | – | – | – | $3,050 |
| Cedar Ridge HOA | – | – | $3,600 | – | – | $3,600 |
| Delta Logistics | $4,100 | $2,250 | – | $950 | – | $7,300 |
| Evergreen Cafe | – | – | – | – | $1,780 | $1,780 |
| Fulton Realty | $980 | $640 | – | – | – | $1,620 |
| Total | $9,330 | $4,090 | $3,600 | $950 | $1,780 | $19,750 |
| % of total | 47% | 21% | 18% | 5% | 9% | 100% |
How to read this sample report
- 53% is overdue. Only $9,330 of the $19,750 is still current. The other $10,420 is past due, which is a lot for a business this size.
- Evergreen Cafe, over 90 days ($1,780): the oldest debt is the hardest to collect. Send a final notice, offer a short payment plan, and stop new work on credit until it is paid.
- Cedar Ridge HOA, 31-60 days ($3,600): one invoice that has slipped. A phone call usually works better than another email at this stage.
- Delta Logistics ($950 at 61-90 days): a big customer that pays most invoices on time but has one old one. That usually means a dispute or a missing purchase order, so ask what is holding it up.
- Acme Plumbing and Fulton Realty: healthy. No action needed beyond normal reminders.
A common goal for small businesses is to keep most of the balance in the current and 1-30 day columns and less than 10% over 90 days. You can rebuild this exact example in the online calculator above or in the Excel template, then replace it with your own invoices.
Detailed aging report sample (by invoice)
The table above is a summary aging report: one line per customer. Most accounting tools can also print a detailed aging report that lists every open invoice. Here is the same sample as a detailed report, with a report date of October 31, 2026 and 30-day payment terms. “Days past due” is the report date minus the due date, and that number decides the bucket.
| Customer | Invoice # | Invoice date | Due date | Days past due | Balance | Bucket |
|---|---|---|---|---|---|---|
| Acme Plumbing | 1041 | Oct 13, 2026 | Nov 12, 2026 | – | $2,400 | Current |
| Brightline Dental | 1029 | Sep 13, 2026 | Oct 13, 2026 | 18 | $1,200 | 1-30 days |
| Brightline Dental | 1044 | Oct 21, 2026 | Nov 20, 2026 | – | $1,850 | Current |
| Cedar Ridge HOA | 1012 | Aug 15, 2026 | Sep 14, 2026 | 47 | $3,600 | 31-60 days |
| Delta Logistics | 0998 | Jul 19, 2026 | Aug 18, 2026 | 74 | $950 | 61-90 days |
| Delta Logistics | 1031 | Sep 22, 2026 | Oct 22, 2026 | 9 | $2,250 | 1-30 days |
| Delta Logistics | 1046 | Oct 26, 2026 | Nov 25, 2026 | – | $4,100 | Current |
| Evergreen Cafe | 0975 | Jun 11, 2026 | Jul 11, 2026 | 112 | $1,780 | Over 90 |
| Fulton Realty | 1033 | Sep 26, 2026 | Oct 26, 2026 | 5 | $640 | 1-30 days |
| Fulton Realty | 1045 | Oct 23, 2026 | Nov 22, 2026 | – | $980 | Current |
| Total | $19,750 |
Use the detailed version when you are making collection calls, because it tells you exactly which invoice to ask about. Use the summary version for a quick health check or to share with a lender or partner.
Estimating bad debt from your aging report
Many businesses use the aging report to estimate how much of their receivables will never be collected (often called the allowance for doubtful accounts). The idea is simple: the older a balance is, the less likely it is to be paid, so you apply a higher loss rate to each older bucket.
The loss rates below are only an example. Your own rates should come from your history: look at how much of each bucket you actually ended up writing off in past years.
| Aging bucket | Balance | Example loss rate | Estimated uncollectible |
|---|---|---|---|
| Current | $9,330 | 1% | $93 |
| 1-30 days | $4,090 | 3% | $123 |
| 31-60 days | $3,600 | 10% | $360 |
| 61-90 days | $950 | 25% | $238 |
| Over 90 | $1,780 | 50% | $890 |
| Total | $19,750 | $1,704 |
In this example, about $1,704 (8.6%) of the $19,750 might never come in. More than half of that estimate comes from a single invoice: Evergreen Cafe’s $1,780 balance that is over 90 days old. That is why chasing the oldest invoices first usually protects the most cash. Talk to your accountant before booking an allowance or writing off a debt, since tax and accounting rules for bad debts differ.
What’s inside the template
- Start Here: business name, the report date, your aging bucket boundaries (30/60/90 by default, but you can change them) and an optional figure for credit sales over the last 90 days, used to calculate DSO.
- Invoices: room for 150 open invoices (insert more rows if you need them). You enter the customer, invoice number, date, payment terms and amount, plus any partial payments. The template calculates the due date, remaining balance, days past due and aging bucket. Two columns, Last contact and Next step, turn it into a simple collections log.
- Aging Report: six headline numbers, an aging table by customer with totals and percentages, and the ten largest overdue invoices with their next step.
Invoices more than 60 days past due are highlighted in orange; anything past your last bucket turns red. Fully paid invoices drop out of the report automatically.
How to use it
1. List your open invoices
Pull every unpaid or partly paid invoice from your invoicing tool or bookkeeping records. For each one, enter the customer name exactly the same way every time (“Summit Roofing Co.” and “Summit Roofing” would be treated as two customers), the invoice number and date, the payment terms in days (for example 30 for net 30) and the invoice amount.
2. Record payments as they come in
When a customer pays, type the amount in Amount paid on that invoice row. The balance updates, and once it reaches zero the invoice disappears from the aging report. Keeping the paid invoices in the list gives you a payment history per customer, which is useful when deciding on credit terms.
3. Set the report date
Ages are calculated as of the date on the Start Here sheet. Most businesses run an aging report at month-end, when they close the books, and again whenever they plan collection calls. Changing the date recalculates every invoice.
4. Read the report
Here’s what the aging table looks like for a small business with nine invoices, one of them already paid, as of October 31:
| Customer | Current | 1-30 | 31-60 | 61-90 | Over 90 | Total |
|---|---|---|---|---|---|---|
| Northwind Dental | $980 | $1,900 | – | – | – | $2,880 |
| Harbor Yoga Studio | $1,350 | – | – | – | – | $1,350 |
| Bright Bakery LLC | – | – | – | – | $3,200 | $3,200 |
| Summit Roofing Co. | $4,300 | – | $3,600 | – | – | $7,900 |
| Lakeside Realty | $2,100 | – | – | – | – | $2,100 |
| Pine Street Cafe | – | – | $890 | – | – | $890 |
| Total | $8,730 | $1,900 | $4,490 | – | $3,200 | $18,320 |
Three things stand out. Summit Roofing owes the most, but more than half of it isn’t due yet, and the overdue part is on a payment plan. Bright Bakery’s $3,200 is over 90 days old and needs attention now. And with $9,590 of the $18,320 total overdue, more than half of this business’s receivables are late, a clear sign that collections need a regular routine.
How the calculations work
Days past due is the report date minus the due date, and the due date is the invoice date plus the payment terms. An invoice that isn’t due yet counts as zero days past due and lands in Current.
Due date = Invoice date + Terms
Days past due = MAX(0, Report date - Due date)
Aging buckets come from a nested IF that compares days past due with the three boundaries on the Start Here sheet, so changing 30/60/90 to 15/30/45 relabels and regroups everything.
Customer totals use SUMIFS: for each customer and bucket, it adds up the balances of invoices whose days past due fall inside that bucket.
DSO (days sales outstanding) estimates how long, on average, it takes you to collect after a sale:
DSO = Total receivables / Credit sales in the last 90 days x 90
In the example, $18,320 of receivables against $48,000 of credit sales over 90 days gives a DSO of about 34 days. If your standard terms are net 30, a DSO close to 30 is good; a DSO that keeps rising from month to month is an early warning, even if no single invoice looks alarming.
A simple collections routine
- Before the due date: send a friendly reminder a few days ahead, with the invoice attached. Many late payments are simply forgotten invoices.
- 1–30 days late: a polite email, then a phone call. Ask whether there’s a problem with the invoice. Disputes are easier to fix early.
- 31–60 days late: call the person who approves payments, agree on a date and write it in Next step. Consider pausing further work or deliveries.
- 61–90 days late: send a formal written notice. Offer a payment plan if the customer is struggling but cooperative.
- Over 90 days: decide whether to escalate, for example through a collection agency or legal advice, or whether the amount may not be recoverable. Talk to your accountant about how to treat uncollectible invoices in your books and taxes.
Whatever routine you choose, the aging report makes it consistent: run it weekly, start at the top of the overdue list and update Last contact and Next step as you go.
Common mistakes
- Inconsistent customer names. Pick one spelling per customer and stick to it, or the report will split their balance across several rows.
- Forgetting partial payments. A customer who paid half an invoice still owes the other half, and that half keeps aging.
- Using the invoice date instead of the due date. An invoice on net 60 terms that’s 45 days old isn’t late. This template ages invoices from the due date, which is how customers and lenders usually read it.
- Running it only at year-end. By then, the 30-day problems have become 300-day problems.
Frequently asked questions
What is the difference between a summary and a detailed aging report?
A summary aging report shows one row per customer with their balance split into aging buckets (current, 1-30, 31-60, 61-90, over 90 days). A detailed aging report lists each open invoice with its invoice date, due date and days past due. They add up to the same total. See both versions in the sample report above.
How do I estimate bad debt from an aging report?
Multiply the balance in each aging bucket by a loss rate, using higher rates for older buckets, and add the results. With example rates of 1%, 3%, 10%, 25% and 50%, the $19,750 sample above gives an estimate of about $1,704. Base your real rates on what you have written off in the past. See the worked example.
Can I change the aging buckets?
Yes. Enter new boundaries on the Start Here sheet. The bucket labels, the invoice classifications and the report columns all update automatically.
How many customers does the report handle?
The aging table shows up to 60 customers with an open balance, in the order they first appear on the Invoices sheet, and the Invoices sheet holds 150 invoice rows, which you can extend by inserting rows. That covers most small businesses comfortably.
How does this relate to cash flow forecasting?
Your aging report tells you who owes you and how late they are. That’s exactly what you need to forecast collections realistically in a 13-week cash flow forecast: put each expected payment in the week you actually expect it, not the week it was due.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas, highlighting and report all carry over.
I already track income in a bookkeeping spreadsheet. Do I need this too?
If you get paid at the time of sale, probably not. If you invoice customers and wait to be paid, yes: a bookkeeping log like our small business bookkeeping spreadsheet records cash when it arrives, while the aging report tracks what’s still outstanding.
What is a good accounts receivable aging percentage?
There is no single rule, but many small businesses aim to have at least 80% of the balance current or less than 30 days late, and under 10% over 90 days. If the over-90 column keeps growing, tighten your payment terms or ask for deposits before starting work.
Is the aging report template free?
Yes. The Excel download and the online calculator are free, with no sign-up required.
This template and guide are for general record-keeping and educational purposes only and are not legal, tax or accounting advice. See our disclaimer.
Payment terms written in working days (“due in 10 business days”) skip weekends and holidays, so the due date is later than it looks. Our business days calculator gives the exact date.
Bookkeeping Kit Pro 2026 links your P&L, invoices, bills, bank rec, mileage and quarterly tax in one Excel workbook (works in Google Sheets). The free templates on this site stay free.
Comments
7 responses to “Free Accounts Receivable Aging Report Template (Excel) + Example”
[…] Free Accounts Receivable Aging Report Template […]
[…] Free Accounts Receivable Aging Report Template […]
[…] Free Accounts Receivable Aging Report Template […]
[…] Accounts Receivable Aging Report: Sample and Free Template […]
[…] start date: bank, credit cards, loans, equity, and open customer invoices and vendor bills (your A/R aging and A/P […]
[…] invoice tracker and an accounts receivable aging report overlap. The tracker is the day-to-day list of invoices, and the aging report is the summary view […]
[…] Free Accounts Receivable Aging Report Template […]