How to Read an AR Aging Report (and Collect From Slow-Paying Accounts)

An accounts receivable aging report sorts every unpaid customer invoice into buckets by how long it's been outstanding — usually 0-30, 31-60, 61-90, and 90+ days — so you can see at a glance who owes you money, how much, and how overdue it is. Read it correctly and it tells you exactly who to call first, when a statement is enough, and when a customer has crossed from "slow payer" into a credit risk you need to cut off before the balance grows.

What Is an Accounts Receivable Aging Report?

An accounts receivable aging report is a list of every open customer balance, grouped into time buckets based on how many days have passed since each invoice's due date, so a business can prioritize collection efforts by risk instead of working through balances in whatever order they happen to sit on a screen.

You only need this report if you actually sell on credit — house accounts, contractor accounts, or wholesale terms where a customer walks out with product before you've been paid for it. If every sale is cash or card at the register, there's nothing to age. The moment you extend terms, this report becomes one of the numbers you should be checking as often as your daily sales total.

How Do the Aging Buckets Work?

Standard aging buckets run in 30-day windows from the invoice due date, not the invoice date. A net-30 invoice that's 10 days late shows up in the 31-60 bucket, not the 0-30 bucket — the clock starts when payment was due, not when the sale happened. That distinction matters: it's the difference between an account that looks fine and one that's already a week into being a problem.

• 0–30 days past due: Current-ish. No action beyond your normal terms and, if you send them, routine reminders.
• 31–60 days past due: Past due. Send a statement and a direct reminder — this is where most legitimately slow payers still sit.
• 61–90 days past due: Seriously late. This calls for a phone call, not another email, and it's worth pausing new orders on the account until it's addressed.
• 90+ days past due: High risk. Treat it as a collections case — a written demand, a negotiated payment plan, or a decision to stop selling to that account on credit.

How Do You Calculate Days Sales Outstanding (DSO)?

Days Sales Outstanding tells you, on average, how long it takes to collect after a sale: DSO = (Total Accounts Receivable ÷ Total Credit Sales for the Period) × Number of Days in the Period. If you offer net-30 terms, a healthy DSO sits close to 30-40 days. A DSO climbing past 50 on net-30 terms is a sign that collections are slipping, not that your customers are unusually slow this month — it's worth tracking DSO alongside the retail KPIs you already check every morning.

Which Slow-Paying Accounts Should You Call First?

The oldest balance isn't always the most urgent one. A $200 invoice sitting at 95 days is a smaller problem than a $4,000 invoice at 75 days, even though the first one is technically older. Work the report by combining age and exposure, not age alone.

• Largest dollar balance in the oldest bucket — dollars at risk matter more than days on the calendar.
• Accounts sitting at or over their approved credit limit, even if their balance isn't the oldest on the list.
• Repeat offenders — customers who are late every single cycle, not just this one.
• Accounts that just placed a new order while an older balance is still open — stop and resolve the old balance before shipping the new one.

How Do Statements and Reminders Keep Collections Moving?

A statement lists every open invoice on an account in one document, so a customer sees the full picture instead of a single overdue bill. A reasonable cadence: a friendly reminder around day 7 past due, a full statement at day 30, a phone call at day 45, and a firm final notice at day 60 with a payment deadline attached. The point of the cadence is consistency — customers pay the accounts that consistently ask, and deprioritize the ones that don't.

Statements themselves are a receivables feature, not a marketing send. If you want automated text or email reminder sequences layered on top of manual statements, that runs through a Messaging plan, starting at $49.99/month — worth it once you have enough overdue accounts that manual follow-up is falling behind.

When Should You Stop Selling on Account?

Extending credit past a clear stop point is how a slow-paying customer becomes a bad debt. Set the line before you need it, not while you're on the phone with an overdue account.

• The account has crossed 90 days past due with no payment plan in place.
• The customer is at or over their approved credit limit.
• Two or more promised payment dates have passed without a payment.
• A previously reliable account suddenly stretches from net-30 to net-75 with no explanation offered.

How Do You Actually Pull and Work an Aging Report?

• 1. Pull the report as of a single date — pick the same day each week or month so the buckets are comparable over time.
• 2. Sort by the oldest bucket first, then by balance size within that bucket.
• 3. Cross-check each flagged account against its credit limit and terms before deciding who to call.
• 4. Work the list top to bottom: call first, then follow with a statement or written reminder.
• 5. Log the promise-to-pay date on the account, and check it on that date — not weeks later.

How Does Retailer OS Track Receivables Aging?

Retailer OS keeps customer accounts with credit terms, contract pricing, and receivables aging inside the same system that rings the sale — as part of retail operations management, not a wholesale ledger exported to a spreadsheet. Put a wholesale or contractor account on terms, assign it a sales rep, and the open balance ages automatically as invoices go unpaid. Statements pull every open invoice on an account into one document so you can send a single reminder instead of chasing invoices one at a time.

There's no general ledger inside Retailer OS — vendor bills and customer receivables are tracked directly in the product, while a daily sales journal per channel, plus received purchase orders as bills, goes to QuickBooks Online overnight. That keeps your books current without asking you to reconcile a second AR system by hand.