AR aging guide

Accounts Receivable Aging Report: Example and Action List

See how an AR aging report groups past-due balances, then turn the report into an invoice-by-invoice follow-up queue.

By Rollevo

Start with a report you can trust.

An accounts receivable aging report groups outstanding invoices by how long they have been overdue. The exact buckets depend on the accounting system. Before setting priorities, check that invoice dates, due dates, credits, and payments are recorded consistently.

1. Confirm what is actually outstanding.

Look for payments waiting to be matched, credit notes not applied, duplicate invoices, and balances already under dispute. Separate those items before treating every open line as a follow-up task.

2. Add context to the balance.

For each account, record the AP contact, the last interaction, any document requested, the promised payment date, and the owner of the next action. A balance alone cannot tell you whether an invoice was never received or is waiting for approval.

3. Prioritize deliberately.

Consider the age and size of the balance alongside the actual blocker and customer context. A recent, material invoice missing one document may call for a different next step than an old invoice with an unresolved commercial dispute.

4. Give the next step a date and an owner.

  • Missing purchase order: ask the internal account owner for the reference.
  • Invoice not received: verify the destination and resend through the approved channel.
  • Payment promised: record the amount and date, then verify receipt.
  • Billing disputed: document the issue and route it for a decision.

5. Separate activity from outcomes.

Report reminders sent, replies received, and blockers resolved separately from money received. Confirm payments against the accounting records. Keep promises in their own column until the cash is verified.

This is an operational starting point. The right priorities depend on your records, customers, and agreed policies.

Example aging report and follow-up queue

On a November 17 report, an invoice due November 3 with $3,000 still open is 14 days past due. Put it in the 1–30 day bucket. If AP is waiting for a PO, mark the next action as “send PO,” name the owner, and set a follow-up date.

For QuickBooks Online, see Intuit’s instructions for matching reports at the same as-of date. Use the weekly accounts receivable report template to turn that snapshot into a weekly brief and the unpaid invoice workflow to act on the aging list.

Let’s take the next step

Less chasing.
More room to move.

Tell us what’s outstanding. Start with a written AR review.

Get an AR review