Working capital, decided by humans.
Back to all articles
§Fundamentals

Reading your AR aging report: the cash flow signal hiding in plain sight.

Most operators look at the AR aging once a month, glance at the totals, and move on. The buckets are telling you something more useful, about your customer mix, your collection process, and how much working capital you actually need.

MGBy Marco García
5 min

An accounts receivable aging report, the AR aging, sorts your unpaid invoices by how long they've been outstanding. Current, 1–30 days, 31–60, 61–90, and over 90. Most accounting systems generate it in a few clicks. Most operators read it only for the total, which leaves the more useful operating signal unread.

Three things are visible in the aging report that aren't visible anywhere else on the financials: which customers are slow, how much liquidity is locked up at any given moment, and whether the operation is trending toward or away from a cash crunch. None of those show up cleanly on the P&L.

What each bucket actually represents

The Current bucket is invoices not yet due, a healthy operation has the largest balance here. The 1–30 bucket is invoices in the first month of being late on stated terms; some of this is normal payment-cycle drift and not a concern. The 31–60 bucket is where the conversation should already have happened with the customer.

The 61–90 bucket is collection territory: at this point the receivable is materially impaired in operational terms, even if the customer eventually pays. Anything past 90 days carries real default risk and should be on a separate working list, not part of operating cash planning.

What a healthy distribution looks like

There is no universal ratio, but a useful benchmark for B2B operations on net-30 to net-60 terms: roughly 60–70% of the total balance in Current and 1–30, 20–25% in 31–60, and 10% or less past 60 days. Sustained deviation from this shape, particularly the 60+ bucket creeping above 15% of the total, is a leading indicator that the customer mix has shifted toward late payers.

The shape matters more than the absolute number. A growing receivables balance with a stable distribution usually means the business is growing. A flat receivables balance with the buckets sliding rightward is the more dangerous scenario, and it tends to go unnoticed until payroll is due.

Concentration is its own metric

Read the report not just by age, but by customer. If one customer represents more than 25% of the total balance, the AR aging is also telling you about concentration risk: a delay or default from that single customer would translate directly into a liquidity event, regardless of the rest of the book.

This is one of the first things the desk reviews when underwriting a factoring facility. Concentration isn't disqualifying, every operator has anchor customers, but it changes the structure of the line and the advance rate.

Using the aging to size working capital

Multiply your monthly operating outflows (payroll, materials, fixed overhead) by your average days-to-pay across the customer base. That figure is approximately the working capital the operation needs to carry without external financing. If your AR aging shows the average days-to-pay drifting from 35 to 50, the working capital requirement just rose materially, even though revenue may not have moved.

Most operators size their bank line for the business they ran two years ago. The AR aging is the document that tells you whether that line still fits. If the 31–60 and 61–90 buckets are growing relative to Current, the line is undersized, and a receivables-based facility may be the more accurate match.

What to do with the report this week

Pull the aging at end of month. Calculate the percentage of total balance in each bucket. Compare against the prior three months. If the 60+ bucket has grown by more than two percentage points in any of those months, the shape is moving in the wrong direction, and the conversation with those specific customers (or with a financing desk that funds against those receivables) should happen this week, not next quarter.

If the desk can be useful, the AR aging is the document to send first. It tells the underwriter most of what they need to know in two pages.