Accounts Receivable Aging Report and How to Use It Weekly

You sent the invoices, the sales look healthy on paper, and yet the bank balance keeps shrinking toward payroll. The gap between what customers owe you and what has actually landed is where most small businesses run short, and the accounts receivable aging report is the one document that shows that gap clearly enough to act on.

The owners I keep books for who stayed solvent through slow quarters share one habit. They open the aging report every Monday morning, spend fifteen minutes on it, and make at least three phone calls before lunch. This article shows how to read the report, what each column is telling you, and a weekly routine you can copy without hiring anyone.

What an accounts receivable aging report actually shows

An aging report lists every unpaid invoice and sorts it into buckets by how long it has been outstanding. Most accounting software, including QuickBooks, Xero, FreshBooks and Wave, produces one with two clicks. The standard layout looks like this:

"Current" means the invoice is not yet due. The other columns count days past the due date, not days since the invoice was sent. That distinction matters. A Net 30 invoice sent on March 1 only enters the 1 to 30 day bucket on April 1, so if your terms are long, the report can look cleaner than your bank account feels.

The two numbers to pull out first

Before reading line by line, calculate the share of your total receivables that is more than 60 days late. In the example above, $2,150 out of $14,450 is 15 percent. Under 10 percent is healthy for most service firms. Between 10 and 20 percent means collections need attention this month. Above 20 percent usually means a structural problem with terms, billing accuracy or a single large customer.

The second number is concentration. If one customer makes up more than 30 percent of everything owed, as Kessler Builders does here at 68 percent, your cash flow depends on one accounts payable clerk somewhere else. That is worth knowing before you plan any purchase.

A weekly routine for the aging report that takes 15 minutes

Monthly reviews are too slow. By the time a month-end report shows a 45 day old invoice, it has been drifting for six weeks. Here is the Monday routine I set up for clients:

1. Run the report as of today, sorted by total balance. Largest balances at the top so your time goes where the money is.
2. Check the 1 to 30 day column for anything new. An invoice that just went past due is the cheapest one to collect. A polite email on day 3 gets paid far more often than a firm call on day 50.
3. Call, do not email, anything in the 31 to 60 day column. At this stage the invoice is often stuck: wrong purchase order number, sent to an old address, waiting on a signature. A two minute call finds the blocker.
4. Write a specific next action beside every line over 60 days. Payment plan, stop work, final notice, or write off. Never leave it as "follow up."
5. Compare totals to last Monday. If the over 60 total grew, find out why before you spend on anything optional this week.

Reading the aging report for warning signs

The buckets tell a story if you look at movement rather than single snapshots. Three patterns deserve immediate attention.

A good customer sliding one bucket per month

When a client who always paid in 25 days starts paying at 40, then 55, they are usually short on cash themselves. This is the moment to tighten terms, ask for partial payment on new work, or shorten their credit limit. Waiting until they hit 90 days often means waiting in line with every other creditor.

Current column shrinking while totals stay flat

If total receivables hold steady but less of it is current, you are billing less while old debt sits. That is an early signal of the slowdown covered in our guide to early warning signs of cash flow problems, and it usually shows up here weeks before it shows up in the profit and loss statement.

Where common collection advice goes wrong

The usual advice is to send automated reminders at 7, 14 and 30 days past due and let software handle collections. I disagree, at least for businesses with fewer than 200 active customers.

Automated reminders work well for small consumer balances. For business clients, they tend to land in a shared inbox that nobody owns, and after the second identical email, the recipient's filter learns to ignore you. In the books I have kept, a single personal call at day 10 recovered more late money than three automated emails combined. The call surfaces the real reason for the delay, and most delays are paperwork, not unwillingness.

Use automation for the first nudge only. After that, a human with a name should handle it. If you need more reasons why faster collection beats borrowing, our piece on why collecting receivables faster beats any short-term loan runs the numbers.

Turning the aging report into a cash forecast

The aging report also feeds your cash projection. Apply a realistic collection rate to each bucket rather than assuming every dollar arrives:

• Current: expect about 95 percent within the next 30 days
• 1 to 30 days: about 85 percent
• 31 to 60 days: about 70 percent
• 61 to 90 days: about 50 percent
• Over 90 days: 25 percent at best, and plan as if it is zero

Applied to the example table, $14,450 owed turns into roughly $10,800 of cash you can reasonably count on next month. That is a $3,650 difference, enough to cover a month of rent for many small shops. Plug the adjusted figure into the forecasting method from forecasting cash flow without a finance degree and your projections stop being optimistic by default.

Track your own rates for six months and replace these defaults with real ones. A plumbing contractor I worked with collected 98 percent of current invoices but only 30 percent of anything over 60 days, which told him to stop extending credit past one job to any new client.

When to stop work or write off a balance

Every business needs a written rule, decided calmly, before a customer is 90 days behind. A reasonable starting rule: pause new work once any balance passes 45 days late without a payment plan, and send a final written notice at 75 days. At 120 days, decide between a collections agency, which typically keeps 25 to 40 percent of what it recovers, small claims court, or writing off the debt.

Writing off is not failure. It cleans the report so the remaining numbers mean something, and in many jurisdictions it lets you recover sales tax you already paid on the invoice. Ask your accountant how bad debt is handled where you file.

Frequently asked questions

How often should I run an accounts receivable aging report?

Weekly is the right rhythm for most small businesses. A monthly review lets invoices drift six weeks before anyone notices. If you invoice daily or carry more than 50 open invoices, a quick look twice a week is worth the time.

What is a good percentage of receivables over 90 days?

Aim for under 5 percent of total receivables in the over 90 day bucket. Anything above 10 percent usually means a billing process problem or a customer who will not pay without escalation. Review those accounts one by one rather than as a group.

Do lenders look at the aging report?

Yes. Lenders offering a line of credit or invoice financing often request it, and many will not count invoices older than 90 days toward your borrowing base. A clean report with little in the oldest buckets makes approval easier and can raise the limit you are offered.