An accounts receivable aging report is a snapshot of every unpaid invoice you are owed, sorted by how long each one has been outstanding. It is the single most useful tool a finance or collections team has for answering two questions at once: who owes us money, and how worried should we be about getting it back.
What exactly is an AR aging report?
The report lists each customer and breaks their open balance into columns called aging buckets. Every invoice is placed in a bucket based on the number of days since it became due. Add up a column and you can see, at a glance, how much of your money is fresh and how much has gone stale. Most teams run it at month-end, but the healthiest teams look at it weekly.
The standard aging buckets
Almost every aging report uses the same five columns:
- Current — invoices that are not yet past their due date. This is money working exactly as it should.
- 1–30 days — recently overdue. Usually an oversight, a lost invoice, or a payment run that has not cleared yet.
- 31–60 days — the first real warning sign. Something is slowing the payment down and it deserves a human touch.
- 61–90 days — genuinely late. The longer a balance sits here, the lower the odds it is paid in full.
- 90+ days — seriously delinquent. These accounts are candidates for escalation, payment plans, or handoff to a collections agency.
The core rule collectors live by: the older the receivable, the harder it is to collect. Invoices lose a meaningful share of their value with every month they age past due, which is why the goal is always to move money leftward into Current.
How do you read one?
Start with the totals row. What percentage of your total AR is Current versus overdue? A healthy book keeps the large majority in Current and 1–30. Then scan the far-right columns first — the 61–90 and 90+ buckets are where cash is quietly slipping away. Sort customers by the size of their overdue balance so you spend your time on the accounts that move the needle. A handful of large, aging invoices usually matter far more than a long tail of small ones.
What each bucket tells you to do
- Current: nothing urgent — but a friendly reminder a few days before the due date prevents tomorrow's problem.
- 1–30: send a polite reminder and confirm the invoice was received and approved.
- 31–60: pick up the phone. Find out whether there is a dispute, a missing PO, or a cash-flow issue.
- 61–90: escalate to a manager, put the account on credit hold, and agree a firm payment date in writing.
- 90+: decide between a structured payment plan, a final demand, or third-party collection — and reserve against the balance in your books.
Common mistakes to avoid
- Only running it monthly. By month-end an invoice can already be 30 days gone. Weekly reporting catches problems while they are still cheap to fix.
- Ageing from the invoice date instead of the due date. If your terms are net 30, an invoice is not overdue on day one — mixing the two inflates your buckets and hides the real risk.
- Ignoring credits and unapplied cash. Unapplied payments and open credit memos make customers look delinquent when they are not, and burn goodwill when you chase them.
- Treating every bucket the same. A 90-day balance needs a different conversation than a 15-day one. One-size-fits-all reminders train customers to ignore you.
- Never reconciling to the general ledger. If the aging total does not tie to your AR control account, someone is working from the wrong number.
How the aging report drives collections
The aging report is not just a scorecard — it is a worklist. Each bucket maps to a specific action, so your team can start every day by working the oldest, largest balances downward. Track the trend over time: is the 90+ bucket shrinking? Is your Days Sales Outstanding (DSO) falling? Those movements tell you whether your collections process is actually working.
Building the report by hand in a spreadsheet is where most teams lose the plot — it is stale the moment cash posts. FulcrumGrid Collection produces a live aging report automatically from your invoices and payments, then turns each bucket into scheduled reminders and prioritized follow-ups, so the report and the work behind it stay in sync without a single formula to maintain.
Frequently asked questions
What is the difference between the Current and overdue buckets?
Current invoices are not yet past their due date, so the money is on schedule. Overdue buckets (1–30, 31–60, and beyond) count the days since the invoice became due — the further right, the higher the collection risk.
How often should I run an AR aging report?
Month-end is the minimum, but weekly is far better. Reviewing it every week lets you catch a slipping account while the balance is small and the customer still remembers the invoice.
Should invoices age from the invoice date or the due date?
From the due date. If your terms are net 30, an invoice issued today is Current, not overdue. Ageing from the due date keeps your buckets honest and your risk picture accurate.
What does a 90+ day balance mean for my business?
It signals serious delinquency and real risk of non-payment. These accounts usually warrant a payment plan, a credit hold, a final demand, or handoff to collections — and often a bad-debt reserve in your books.
FulcrumGrid Collection
Put your receivables on autopilot
Let FulcrumGrid Collection build your aging report and chase every overdue invoice for you, automatically.