What Is an Accounts Receivable Aging Report and How Do You Read One?
Sam's List Editorial | 2026-07-28
What Is an Accounts Receivable Aging Report and How Do You Read One? An accounts receivable aging report is a list of every unpaid customer invoice, sorted by how long it has been outstanding. It groups balances into age buckets, typically current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90, so you can see not just how much you are owed but how long you have been waiting for each piece of it. Your accounting software can produce one in a click. Most owners have never opened it. That is a shame, because it is the single most actionable report a small business has, and unlike the profit and loss it tells you something you can do something about this week. What the Report Actually Contains Every aging report has the same anatomy: one row per customer, columns for each age bucket, and a total. Some versions break out individual invoices under each customer, which is the more useful view once a customer has more than one open item. Here is a simplified example for a business with 148,000 dollars outstanding. Customer Current 1-30 31-60 61-90 90+ Total Northside Property Mgmt 18,000 16,000 14,000 0 0 48,000 Grantham Medical 12,000 0 0 0 0 12,000 Vertex Offices 9,000 9,000 0 0 0 18,000 Lakeshore Retail 4,000 4,000 4,000 4,000 22,000 38,000 31 other accounts 21,000 8,000 3,000 0 0 32,000 Total 64,000 37,000 21,000 4,000 22,000 148,000 The total is the least interesting number on the page. Everything useful is in the distribution. How to Read the Buckets Current is money not yet due under your terms. A healthy business has most of its balance here. If yours does not, you have either a collections problem or terms that do not match how your customers actually pay. 1 to 30 days past due is normal friction. Invoices get routed to the wrong person, approvals wait for someone's return from vacation, a check cycle runs twice a month instead of weekly. This bucket rarely requires action beyond a reminder. 31 to 60 days past due is where the report earns its keep. An invoice at this age is still a reminder rather than a confrontation, and the customer relationship is intact. Every dollar you collect here is a dollar that never enters the difficult buckets. If you only have fifteen minutes a week for receivables, spend all of it here. 61 to 90 days past due means something specific has gone wrong. A dispute you were not told about, an invoice that never arrived, a customer with a cash problem of their own, or a purchase order requirement nobody communicated. Find out which. The answer determines whether this is a paperwork fix or a credit risk. Over 90 days...
