How to use an accounts receivable aging report

01

Prepare a dependable report

Choose a report date and reconcile invoices, payments and credits with your records. List the customer, invoice number, due date, open amount and known dispute or payment status. Make sure partial payments and credits are applied or separately identified before grouping balances.

Group invoices as current, 1–30 days overdue, 31–60 days overdue and older, or use buckets suited to the business. Calculate days from the due date and state the convention on the report. An invoice can be unpaid without being overdue.

02

Read the balances

Hypothetical example: on the report date, a business has $20,000 in open invoices: $12,000 current, $5,000 one to 30 days overdue and $3,000 more than 30 days overdue. The overdue balance is $8,000, or 40% of the $20,000 open balance. The current $12,000 should not be described as late.

The $8,000 is an outstanding balance, not a forecast of cash that will certainly arrive. Check whether any amount is disputed, already paid but unmatched, or affected by a credit before deciding on a next step.

03

Assign follow-up and update the forecast

Give each overdue item an owner, next action and review date. Confirm the invoice and customer history before contacting the customer; resolve disputes through the appropriate people. Record payment commitments as estimates until cash arrives.

Review recurring delays by customer or cause, such as missing purchase order details or an incorrect billing contact. Use the evidence to adjust expected receipt dates in the cash forecast, while keeping uncertain amounts visible.

04

Use age with context

An older balance deserves investigation, but age alone does not explain the cause or establish whether it can be collected. A large customer may have a single disputed invoice while another has many small overdue balances caused by incorrect references. Review both the amount and the number of invoices, and record the reason for each exception.

Compare reports at the same point in successive periods using unchanged bucket definitions. If total receivables have grown, an increase in overdue dollars may reflect a larger sales base; compare the overdue share as well. Avoid drawing conclusions from the percentage alone when invoice terms or the customer mix have changed.