What Is an Accounts Receivable Aging Report?

An accounts receivable aging report is a simple list of who owes you money, how much they owe, and how long each invoice has been unpaid. This guide explains what the report is, how to read it, how to build one, and how to use it to get paid faster.

If you send invoices, you need this report. It turns a pile of unpaid invoices into a clear picture. You can see at a glance which clients pay on time, which are a little late, and which need a firm call today. Without it, you are guessing. With it, you know exactly where your money is.

By the end of this guide, you will know the five aging buckets, how to sort invoices into them, what each bucket tells you, and what action to take for each one. You will also learn the common mistakes that make aging reports useless, and how a tool like InvoiceChaser can build the report for you from a simple CSV file.

Why an Aging Report Matters

Your business runs on cash, not on invoices. An invoice is a promise to pay. It is not money in the bank. The gap between the promise and the payment is where small businesses get into trouble. Rent is due. Payroll is due. Suppliers want to be paid. If your clients pay late, you may not have the cash to pay your own bills on time.

An aging report closes that gap in your mind. It shows you the real state of your money. It tells you how much is owed in total, and how much of that total is fresh and how much is old. A business with $20,000 owed is in good shape if $18,000 of it is current and $2,000 is 30 days late. The same business is in trouble if $12,000 of it is more than 90 days late. The total is the same. The risk is very different.

The report also helps you spot patterns. One client who is always 30 days late is a pattern. Three clients who all went quiet in the same month is a pattern. A sudden rise in the 61–90 day bucket may mean your invoicing process broke, or a big client is in trouble. You cannot see these patterns by looking at invoices one at a time. The report makes them plain.

The U.S. Small Business Administration offers plain guidance for small firms on tracking money owed and managing cash flow. See the SBA business guide for general help, and the IRS small business center for record-keeping rules that apply when you track invoices and payments.

How an Aging Report Works

An aging report groups unpaid invoices by age. Each invoice goes into one bucket based on how many days have passed since its due date. Most reports use five buckets. These buckets are the standard in small business accounting, and most tools use the same five.

The five buckets are:

• Current: The invoice is not yet due. The client still has time to pay.
• 1–30 days past due: The invoice is a little late. This is the most common bucket. Most of these invoices will be paid with a gentle reminder.
• 31–60 days past due: The invoice is clearly late. It needs a firm follow-up and a phone call.
• 61–90 days past due: The invoice is seriously late. It needs a final demand and a decision about next steps.
• 90+ days past due: The invoice is very old. It may never be paid in full. It needs outside help or a write-off decision.

Each bucket shows two things: the number of invoices in it, and the total dollars in it. Some reports also show each client separately, so you can see which client owes what in each bucket. A client-level report is more useful than a total-only report, because you chase clients, not totals.

A Simple Example

Imagine you run a small design studio. You have five unpaid invoices. One is due next week for $500. One is 10 days late for $800. One is 40 days late for $1,200. One is 70 days late for $2,000. One is 120 days late for $3,000. Your aging report would look like this:

In this example, $7,000 of $7,500 is past due. That is a warning sign. Only $500 is current. The business needs to act on the old buckets now, not next month. The report makes that clear in seconds. Without it, the owner might look at five invoices and think, "That is not so bad." With it, the owner sees the real risk.

How to Build an Aging Report

You can build an aging report by hand, in a spreadsheet, or with software. The steps are the same in each case. The difference is how much time it takes and how often you will actually do it.

Step 1: List every unpaid invoice

Start with a full list of open invoices. For each one, you need the client name, the invoice number, the invoice date, the due date, and the amount still owed. If a client paid in part, list only the unpaid part. If an invoice is fully paid, leave it off the report. The report is about money still owed, not money already in.

Step 2: Work out the age of each invoice

For each invoice, count the days between the due date and today. If the due date is in the future, the invoice is Current. If the due date was 10 days ago, the invoice is 10 days past due. Use the due date, not the invoice date. An invoice sent 60 days ago with Net 90 terms may still be Current. An invoice sent 10 days ago with Net 7 terms is already late. The due date is what matters.

Step 3: Sort each invoice into a bucket

Put each invoice into one of the five buckets: Current, 1–30, 31–60, 61–90, or 90+. Be strict. An invoice that is 31 days past due goes in the 31–60 bucket, not the 1–30 bucket. Sloppy sorting hides real problems. If you sort by hand, check the border cases twice.

Step 4: Add up each bucket

Add the amounts in each bucket. Add the number of invoices too. Then add the buckets together for a grand total. Check that the grand total matches the sum of all open invoices. If it does not, an invoice is missing or counted twice.

Step 5: Review the report every week

A report you build once and forget is useless. Review it every week, on the same day. Look at what moved. Did an invoice move from 1–30 to 31–60? That client needs a call this week. Did a 90+ invoice get paid? Good — note what worked. A weekly review takes ten minutes and keeps small problems small.

If you use InvoiceChaser you can skip the hand work. Upload your invoice CSV, and it builds the aging report for you, with each invoice in the right bucket. You can see the report, download it, and use it to send the right reminder for each bucket. See pricing to find the plan that fits the number of invoices you send each month.

Why Each Bucket Needs a Different Action

The buckets are not just labels. Each one calls for a different action. Using the same action for every bucket wastes time on fresh invoices and waits too long on old ones.

For the Current bucket, do nothing except send a pre-due reminder three days before the due date. A short note — "Just a heads-up that invoice #1042 for $1,200 is due on May 10" — cuts late payment a lot. Do not chase an invoice that is not yet due. That annoys good clients.

For the 1–30 day bucket, send a friendly reminder. Most of these invoices will be paid with one note. The client forgot, or the invoice got lost. A short email with the invoice attached and a payment link solves it. If there is no reply after a week, add a phone call. For the exact words to use, see our invoice reminder email templates.

For the 31–60 day bucket, call the client. Email alone is no longer enough. Ask for a firm pay date. Offer a short written payment plan if cash is tight. Half now and half in two weeks is a common plan. Put the plan in writing the same day. If the client agrees to a plan and misses it, move to the next bucket's action at once.

For the 61–90 day bucket, send a final demand letter. State the full amount, the invoice number, the due date, and a firm deadline, usually 7 to 14 days. State what you will do if the deadline passes, such as pausing work or passing the debt to a collector. Keep the letter short and factual. Send it by email and by mail if you can.

For the 90+ day bucket, make a decision. You have three options: pass it to a collection agency, take legal action such as small claims court, or write it off as a bad debt. A collector takes a share, often 20% to 30%, of what it recovers. A write-off is a tax matter, so check the rules with your accountant. The IRS small business center has guidance on business bad debts and record keeping. Do not let a 90+ invoice sit with no decision. A decision, even a hard one, is better than silence.

How to Read the Report Like an Expert

A good report tells you more than the totals. It tells you where to act first. Start with the oldest bucket. The 90+ bucket is the most urgent, because old debts are the least likely to be paid. Then look at the 61–90 bucket, because those invoices will become 90+ soon if you do nothing. Then work your way down to the fresh ones.

Next, look at the share of each bucket. Add up the past-due buckets and divide by the total. If more than 20% of what you are owed is past due, that is a warning sign. If more than 10% is over 60 days late, that is a serious sign. These are rules of thumb, not laws, but they help you judge fast. A healthy business has most of its owed money in the Current and 1–30 buckets.

Then look at clients, not just buckets. One client with $10,000 in the 90+ bucket is a bigger risk than ten clients with $100 each in the 1–30 bucket. Sort the report by client total. The top three clients by amount owed deserve your time first. If one client is a large share of your total owed, that is a risk in itself. You depend on that client too much.

Also watch for movement. Compare this week's report with last week's. Are invoices moving down into older buckets? That means your chase is not working, or clients are getting slower. Are invoices moving out because they got paid? Good. Track the total past due each week in a simple line. A rising line means trouble is coming. A falling line means your chase plan works.

Common Mistakes That Ruin Aging Reports

The first mistake is leaving paid invoices on the report. A paid invoice that stays on the list makes the totals wrong and wastes your time. Update the report when payment arrives, not at the end of the month. If you use software, mark invoices paid the day the money lands.

The second mistake is using the invoice date instead of the due date to age the invoice. An invoice with Net 60 terms is not late 30 days after you sent it. It is Current until the due date passes. Aging by invoice date makes good clients look late and hides the real late ones.

The third mistake is lumping all clients together with no client detail. A total-only report tells you that $15,000 is owed. It does not tell you who owes it. You cannot chase a total. You chase a person. Always keep the client name and invoice number on the report.

The fourth mistake is building the report once a month. A monthly report is a history lesson. By the time you read it, a 30-day invoice is 60 days old. A weekly report is a tool. It catches problems while they are still small. Set a fixed day each week and do not skip it.

The fifth mistake is ignoring small amounts. A $50 invoice that is 120 days late is still a sign. It may mean your invoicing process has a hole, or that a client does not respect your terms. Small unpaid invoices add up. They also teach clients that small bills can be ignored. Chase them with the same steady process, even if the amount is small.

How Aging Reports Connect to Cash Flow

An aging report is a cash flow tool. It tells you what money should arrive, and when. If your Current bucket is $10,000 and your 1–30 bucket is $3,000, you can expect most of that $13,000 soon. If your 90+ bucket is $8,000, do not count on that money. Plan as if it may not come.

This matters when you plan spending. Do not hire, buy, or commit based on money that is 90 days late. Plan based on the Current and 1–30 buckets, and treat older buckets as a bonus if they pay. Many small businesses get into trouble by spending money they have invoiced but not yet received. The report stops that mistake.

The report also helps you talk to your bank or your accountant. A lender who sees a clean aging report — most money current, little old debt — will trust your business more. An accountant can use the report to set aside money for bad debts and to plan your taxes. Bring the report to every meeting about money. It is one of the most useful pages you own. To learn how unpaid invoices hit cash flow in detail, read how unpaid invoices hurt small business cash flow.

Frequently Asked Questions

How often should I run an aging report? Every week. A weekly report catches problems while they are small. A monthly report is too slow. Pick one day a week and review the report on that day without fail.

What is a good aging report to aim for? Most of what you are owed should be Current or 1–30 days past due. If more than 20% is past due, or more than 10% is over 60 days late, take action. These are rules of thumb. Your industry may differ, but the direction is the same: fresh is good, old is risky.

Can I build an aging report in a spreadsheet? Yes. List each unpaid invoice with client, invoice number, due date, and amount owed. Add a column for days past due and a column for the bucket. Sort and add up each bucket. It works, but it takes time each week. Software that builds it from your invoice file saves that time.

What should I do with a 90+ day invoice? Make a decision. Pass it to a collector, take legal action, or write it off. Do not leave it with no plan. Talk to your accountant before writing off a debt, because the tax rules matter.

Does an aging report replace sending reminders? No. The report tells you who to chase and how hard. The reminders do the chasing. Use them together: the report picks the target, the reminder does the work. Our guide to how to chase overdue invoices shows the steps for each bucket.

What if one client owes most of the total? That is a risk. Chase that client first. Also think about your terms for that client. Ask for a deposit on the next job, shorten their payment terms, or split large jobs into stages with payment at each stage. Do not let one client hold too much of your cash.

Key Takeaways

• An aging report groups unpaid invoices into five buckets — Current, 1–30, 31–60, 61–90, and 90+ days past due — so you can see where your money is at a glance.
• Age invoices by the due date, not the invoice date, and review the report every week on the same day.
• Each bucket needs a different action: a pre-due note for Current, a friendly reminder for 1–30, a call and a plan for 31–60, a final demand for 61–90, and a decision for 90+.
• Watch the share of old debt and the movement between buckets, not just the total owed, and chase your largest debtors first.
• Use the report to plan spending: count on Current and 1–30 money, and treat 90+ money as uncertain until it arrives.

!Accounts receivable aging report with five buckets

Image description: The image should show a clean table-style aging report with five columns labeled Current, 1–30 days, 31–60 days, 61–90 days, and 90+ days. Each column has a dollar total and a small bar showing its size. The Current column is green and tallest in dollars, while the 90+ column is red and smallest. A caption reads "Five buckets, one clear picture of who owes you what."