How Do You Read an Accounts Receivable Aging Report?

Reading one aging summary, customer by customer

Illustrative example, invented for this guide: one company’s aging summary at month-end, aged by due date. Four customers owe $75,700 between them.

• Customer A: $42,000, with $30,000 current and $12,000 in 1–30. A healthy account with one invoice slipping; one call this week.
• Customer B: $18,500, all in 31–60. One column means one event: an invoice, or several from the same month, held for one reason. Find out which before anyone sends a reminder.
• Customer C: $9,000, with $2,000 current, $3,000 in 1–30, nothing in 31–60 and $4,000 in 61–90. If the month in between was paid, the customer is paying and skipping one invoice. Ask what is wrong with that invoice, not whether the customer has cash.
• Customer D: $6,200, all over 90 days, with nothing newer. A dispute nobody settled, or a customer who stopped buying. It needs a decision this week.

That is four different conversations, and one reminder sent to all four answers none of them. The column totals alone, $32,000 current, $15,000 in 1–30, $18,500 in 31–60, $4,000 in 61–90 and $6,200 over 90, would hide that the whole 31–60 column is one customer.

Should invoices age from the invoice date or the due date?

Age the call list from the due date, and measure how long cash is out from the invoice date. Due-date aging asks how late a customer is against what it agreed to; invoice-date aging asks how long the money has been out of the company, whatever the terms said.

The choice moves invoices between columns. On net 30, an invoice sent 45 days ago is 15 days past due: 1–30 on a due-date report, 31–60 on an invoice-date report. With mixed terms, invoice-date aging makes a net-60 customer paying on day 55 look late. For fleet and contract accounts, the fuller version reads each invoice against each account’s own terms. Software lets the user pick: Zoho Books’ help describes an “Aging By” setting to “Generate the report based on the Invoice Due Date or the Invoice Date.” Ask the bookkeeper which one the report uses before comparing months.

One trap applies to both. A voided and reissued invoice, to add a missing PO number for example, carries a new date and lands back in the current column. The OCC handbook lists “Re-aged receivables for which the probability of collection is reduced” among the receivables commonly designated ineligible for lending. Write the original date on the reissued invoice and age it from there.

Which accounts do you call first?

Sort the aging detail by dollars past due, largest first, and work it in this order. Every call gets the same note: the date, who answered, what they said, the date they promised, and the next date to look.

• First, the largest balances in 1–30. They are the most recoverable past-due dollars on the report, and a missing PO number or a lost invoice is still easy to fix.
• Second, anything crossing a column line this week, from 31–60 into 61–90 or from 61–90 into over 90. The next column is harder to collect from.
• Third, customers with balances in more than one past-due column. That is a pattern, so the call is about the account: what is held, why, and who on the customer’s side can release it. Lenders read it the same way; the OCC handbook describes cross-aging, the practice of making all of one customer’s receivables ineligible for the borrowing base “if a specified proportion of the total accounts receivable from that party is delinquent.”
• Fourth, everything over 90 days, where each invoice gets a decision rather than another reminder: a written payment plan, a final letter, a referral to the company’s attorney or a collection agency, or a write-off the accountant reviews. Collection rules differ for business and consumer debts and from state to state, so ask the attorney before anyone outside the company contacts a customer. This guide is not legal advice.
• Disputes go to whoever can settle them: the project manager, estimator or technician who knows the job, with a date to answer by. A payment reminder on a disputed invoice gets the same reply every week.

One named person owns the list, with time on the calendar for it. The owner approves payment plans and write-offs above a dollar amount the owner sets, so nothing leaves the report without a name next to it.

What the aging report does not show

The aging lists invoices that exist and are still open. Money can be owed and missing from it, or gone from it without ever being collected:

• Unbilled work. A finished job with no invoice is not a receivable yet, so it appears in no column; the OCC handbook lists unbilled accounts receivable among the receivables commonly designated ineligible for lending. Count finished jobs that have not been invoiced separately, every week.
• Disputes. A questioned invoice sits in the same column as one the customer simply has not paid. Keep the dispute note on the invoice itself, with the name of the person settling it.
• Short-pays. A partial payment posted as paid in full closes the invoice, and the gap leaves the report. Posted as a partial payment, the remainder stays in its column and keeps aging.
• Unapplied payments and credits. A payment not matched to its invoice leaves the invoice looking open while a credit sits elsewhere on the account. Whether credits print can be a setting; Zoho Books’ help lets the user choose whether to display credit notes.
• Write-offs and credit memos. Once credited or written off, an invoice is gone. The OCC handbook calls this dilution: “Returns and allowances, disputes, bad debts, and other credit offsets create dilution.” Pull the month’s credit memos and write-offs as their own list, with who approved each one and why.

So a short aging is not proof of good collections: the money may have come in, or moved off the report without coming in. An insurance aging in a dental office has its own version of the same problem, with claims never sent and denials written off.

How often should an owner look, and what should move?

Weekly, on a fixed day, for the owner; daily or every other day for whoever makes the calls. The owner needs the summary, last week’s copy beside it, and five questions. Save each month-end aging as a PDF too, so there is something to compare against next quarter.

• Did last week’s 1–30 dollars turn into cash, or move into 31–60?
• Does every dollar in 61–90 and over 90 have a name and a next date next to it?
• Did any customer move a column to the right with no note saying why?
• Did the total grow faster than this month’s billing? If receivables rise while sales are flat, collection is slowing somewhere.
• Did anything leave the report as a credit, a write-off or a reissued invoice, and who approved it?

Some movement is healthy: on net 30, the current column turns over within a month. What should not happen is a dollar drifting right with nobody’s name next to it. The strain is common. In the Federal Reserve Banks’ 2025 Small Business Credit Survey of employer firms with 1 to 499 employees, 50 percent cited uneven cash flow as a financial challenge, an answer the report says includes collecting on receivables.

How to turn the aging into next month’s collections forecast

A forecast needs one number per column, from the company’s own history: of the dollars in that column at a month-end, what share was in the bank a month later. Take a past month-end’s aging detail, mark each invoice paid or unpaid as of the next month-end, and total the paid dollars by the column each one sat in. Do it for three recent month-ends and average them. No published figure replaces this, because the shares depend on the company’s own customers and terms.

Illustrative example, the same invented company. Its last three months averaged 80 percent of current dollars collected by the next month-end, 70 percent of 1–30, 50 percent of 31–60, 30 percent of 61–90 and 5 percent of over 90. A call found that Customer B’s $18,500 is one disputed invoice, so it stays out until the dispute is settled:

• Current: $32,000 × 80% = $25,600.
• 1–30: $15,000 × 70% = $10,500.
• 31–60: $18,500, all disputed, so $0 until it is settled.
• 61–90: $4,000 × 30% = $1,200.
• Over 90: $6,200 × 5% = $310.

The forecast is about $37,600, with another $18,500 riding on one conversation. Set it beside next month’s payroll, rent and supplier bills. If they are covered only when Customer B pays, that dispute is the most valuable call of the month, and the owner knows it four weeks early. On net 30, invoices sent next month mostly come due after it ends, so they stay out; a company that bills due on receipt adds its usual same-month payments. At month-end, compare the forecast with actual deposits and update the shares.

When the routine is enough, and where the Review fits

If every past-due dollar has a name and a next date, credit memos have reasons, finished work is invoiced within a day or two, and the forecast lands near actual deposits, the routine works and there is nothing here to buy.

Where nobody can say why the oldest invoices are open, the Revenue Review counts this under the Invoice → Payment hand-off. From read-only exports of the aging detail, invoices, payments, credit memos and the list of finished jobs, it rebuilds the days from invoice to cash by customer and lists short-pays, reissued invoices, unexplained write-offs and finished jobs never invoiced, in dollars. It gives no legal or tax advice. It takes two weeks and ends in a written report the company keeps.

The next step is a free 20-minute call, where we say whether the routine above, kept in-house, is enough.