How to read an accounts receivable aging report

What this guide explains

Learn what an accounts receivable aging report shows, how its buckets are calculated, and which source-data problems must be fixed before using the totals for customer follow-up.

• An AR aging report is a report-date snapshot of open customer balances grouped by how long each invoice is past its due date.
• Current means not yet due. Positive overdue balances then move through 1-30, 31-60, 61-90, and 91+ day buckets as the report date advances.
• This report includes credits and other negative balances in net outstanding, but keeps them outside positive aging buckets so they do not hide the gross amount that still needs follow-up.
• Customer, invoice number, due date, and outstanding amount are the minimum fields needed for a reproducible invoice-level schedule.
• Duplicate invoice keys, invalid dates, zero balances, mixed amount formats, and mixed currencies can make a polished total unreliable. Resolve these issues instead of guessing.

What the report is actually measuring

The report answers a narrow question: as of a chosen report date, which open invoices are not due yet and which are overdue? It is not a payment forecast or a verdict on whether an invoice will be collected. To reproduce a month-end report later, keep the source export and use the same report date, date format, amount format, and currency label.

• Net outstanding combines included positive invoices and credits.
• Gross positive overdue measures the positive invoice balances past due before credits are applied.
• The oldest positive overdue invoice can help order a review list, but it does not measure customer risk by itself.

How the aging buckets work

Days past due is the report date minus the invoice due date. A future or same-day due date stays Current. A positive difference determines the overdue bucket. The boundaries matter: an invoice 30 days late is in 1-30, while an invoice 31 days late moves to 31-60.

• Current: due on or after the report date.
• 1-30: one through 30 days past due.
• 31-60: 31 through 60 days past due.
• 61-90: 61 through 90 days past due.
• 91+: more than 90 days past due.

Why credits should be visible but not aged

A credit memo or unapplied payment is not a late positive invoice. Showing it separately preserves two useful views: the net balance carried for the customer and the gross positive overdue balance that still needs reconciliation or follow-up. Before contacting a customer, confirm whether a credit should be matched to a specific invoice in the accounting system.

• Do not assign a negative balance to an overdue bucket based only on its date.
• Do not use a customer-level credit to silently erase which positive invoices are old.
• Treat the browser report as a review aid; post allocations and corrections in the source accounting system.

Prepare a reliable open-invoice CSV

Export one row per open invoice whenever possible. Confirm that the outstanding amount is the remaining balance rather than the original invoice total, and choose a single date and amount format for the file. If the same customer-plus-invoice key appears twice, return to the source and determine whether it is a duplicate export row, an installment, or a line-level file.

• Customer: the name or stable account label used for grouping.
• Invoice number: the identifier used to find and reconcile the source record.
• Due date: the contractual date used to calculate days past due.
• Outstanding amount: the open balance as of the export, not automatically the original invoice amount.
• Currency: keep one currency per report because a label does not perform exchange-rate conversion.

Use the result as a review queue

Start by checking excluded rows and duplicates, then reconcile the net outstanding total to the source system. Review the oldest positive overdue invoices first only as a practical ordering method. Before any customer contact, verify recent payments, disputes, credits, and notes in the system of record.

• Download the issue CSV and resolve source-data errors before sharing the schedule.
• Compare customer totals with the invoice-detail rows rather than relying on a summary alone.
• Save the report date with exported results so another person can understand the snapshot.

Sources and further reading

• QuickBooks: Run an accounts receivable aging report — Official overview of aging periods, summary reports, and detail reports.
• Xero: Aged Receivables Summary report — Official report guidance for reviewing customer receivables by age.
• FreshBooks: Accounts Aging report — Official explanation of aging report columns and overdue balances.
• Journal of Accountancy: Doing accounts receivable aging reports in Excel — A spreadsheet workflow for creating an aging report from open receivables data.