GUIDE

How to Read an Accounts Receivable Aging Report

An accounts receivable aging report is the clearest single snapshot of where your money is and how long it has been sitting out there. If you've never looked at one, the first time you do you'll probably find a few surprises.

Most freelancers and small-team owners track invoices loosely — a mental list, a folder, maybe a spreadsheet. That works fine when you have three clients. When you have ten or fifteen open invoices at any point, the aging report is the tool that tells you, at a glance, which money is simply waiting and which is at risk.

In short: an AR aging report lists every unpaid invoice grouped into time buckets — Current, 1–30 days past due, 31–60, 61–90, and 90+ days past due. The bucket a balance sits in tells you exactly what action to take, from a friendly nudge at 1–30 days to a formal final notice or collections referral at 90+. Run it weekly and act on anything that has moved into a later bucket since last time.

What is an accounts receivable aging report?

Accounts receivable (AR) is the money clients owe you for work you've already delivered but haven't been paid for yet. An accounts receivable aging report groups those outstanding balances by how long they have been unpaid, using standardized time buckets.

The “aging” part is straightforward: each invoice ages from its due date. The older it gets, the harder it typically is to collect — and the more urgently it needs attention.

For a freelancer or small agency, the report usually looks like a simple table: one row per client (or per invoice), and a column for each time bucket. The totals at the bottom of each column tell you how much money is sitting in each stage of lateness.

You don't need accounting software to build one. A spreadsheet updated once a week does the job entirely. The only numbers you need are: who owes you money, how much, and when the invoice was due.

The standard aging buckets — and what each one means

Every AR aging report uses the same five buckets. Here's what each one signals.

Current — not yet past the due date. These invoices are healthy. The client has time to pay and there is nothing to do except make sure the invoice was actually received and that a payment link is included.

1–30 days past due — recently late. Most invoices in this bucket are simply forgotten: buried in an inbox, waiting in an approval queue, or overlooked after a busy week. A short, friendly reminder is usually all it takes. This is not a cause for alarm, but it is a prompt to act.

31–60 days past due — meaningfully late. An invoice at this stage has survived at least one follow-up cycle without being paid. The tone of your outreach needs to shift from friendly to firm. Phone outreach becomes appropriate alongside email. If you have a late fee in your contract, it likely applies now.

61–90 days past due — seriously overdue. At this point the invoice has been outstanding for two to three months. The probability of collecting without escalation drops noticeably with every week that passes. A formal final notice, a pause on any active work for that client, and a hard payment deadline are warranted.

90+ days past due — at-risk. An invoice past 90 days has a materially lower chance of being collected through normal channels. This is collections territory: a demand letter, small-claims filing, or a debt recovery agency. It is also the point at which writing the balance off as a bad debt may be the honest accounting move, even if you keep pursuing it.

A sample AR aging report

Here's what a small agency's AR aging report might look like in a given week.

| Client | Invoice | Amount | Current | 1–30 | 31–60 | 61–90 | 90+ | |---|---|---|---|---|---|---|---| | Acme Co. | #1041 | $3,200 | $3,200 | — | — | — | — | | Blue Fox Ltd | #1033 | $1,800 | — | $1,800 | — | — | — | | Greenfield Studio | #1027 | $950 | — | — | $950 | — | — | | Kelsey Ryan | #1019 | $2,400 | — | — | $2,400 | — | — | | Marsh & Co. | #1008 | $600 | — | — | — | $600 | — | | Old Harbor Inc. | #0991 | $1,100 | — | — | — | — | $1,100 | | Totals | | $10,050 | $3,200 | $1,800 | $3,350 | $600 | $1,100 |

Reading across the totals row, you can see at a glance that $3,200 is healthy, $1,800 needs a nudge, $3,350 needs a firmer conversation, $600 is approaching collections territory, and $1,100 is already there.

That bottom row is where the actionable intelligence lives. The client-level rows tell you exactly who to contact and with what tone.

What action to take per bucket

The power of the aging report is that it removes the guesswork from follow-up. Each bucket has a clear, appropriate response.

Current — no action required yet. Confirm the invoice was delivered and includes a working payment link. That's it. Chasing a client before an invoice is due erodes goodwill for no benefit.

1–30 days — a friendly reminder. A short note along the lines of “just making sure this reached you” is enough. Most invoices in this bucket clear within a day or two of being nudged. For ready-to-use wording at this stage, the overdue invoice email templates post has copy-paste versions for each level of urgency.

31–60 days — firm follow-up with a payment link. Be direct: state the invoice number, the amount, the number of days past due, and the payment method. If your contract includes a late fee, reference it here without apology — it was agreed in advance. For guidance on setting a fair and enforceable fee, how much late fee to charge on an invoice covers the standard rates and the clause to put in your contract.

61–90 days — final notice, escalation, and paused work. Send a formal notice with a hard deadline. Consider switching channels — a phone call or a WhatsApp message often gets a response that email has stopped producing. If you're doing ongoing work for this client, pausing until the invoice is resolved is a legitimate and appropriate step. At this stage you should also be thinking about whether you want to continue the relationship at all.

90+ days — collections or write-off. Once an invoice crosses 90 days, your options are collections (a recovery agency typically takes 20–40% of what they recover), small-claims court if the amount is under your jurisdiction's limit, or a formal demand letter from a lawyer. For the full escalation path and what to say at each stage, what to do when a client won't pay walks through the entire process from first chase to final resolution.

Rule of thumb: if more than 20% of your total receivables sit in the 61-day-or-older buckets, your follow-up process has a gap. The goal is to keep the overwhelming majority of outstanding AR in Current and 1–30 days.

How AR aging connects to DSO and cash flow

The aging report and your Days Sales Outstanding (DSO) number tell you the same story from two different angles.

DSO gives you a single average: how many days, on average, does it take you to collect payment? The aging report shows you the distribution behind that average — which clients and invoices are pulling it up.

If your DSO is creeping higher month over month, running an aging report will almost always identify the culprits. It might be one large client who consistently pays at 45 days. It might be a cluster of small invoices that slipped through the cracks during a busy period. Knowing which is which changes how you respond.

For a full walkthrough of how to calculate DSO and drive it down, how to reduce days sales outstanding covers the formula with a worked example and seven specific tactics to lower it.

The cash-flow connection is direct: an invoice aging from the 1–30 bucket into the 31–60 bucket is money that was supposed to be in your account this month sitting in someone else's. At scale, those aging balances are the difference between covering payroll, paying contractors, and running your business comfortably — or scrambling.

How often to run the report (and what to do with it)

Weekly is the right cadence for most freelancers and small agencies. Monthly is too slow — an invoice can move from 1–30 to 61–90 days within a single billing cycle if you aren't watching. Daily is unnecessary unless you have a large volume of invoices.

A useful weekly routine takes about ten minutes:

  • Pull the report and scan the bucket totals.
  • Identify any invoice that has moved to a later bucket since last week.
  • Send the appropriate follow-up for each one — matched to the bucket it now sits in.
  • Note any invoice that has been in the 90+ bucket for more than 30 days and decide whether to escalate or write off.

That rhythm — run, scan, act — is what keeps AR from quietly piling up into a problem.

The hardest part for most people is the follow-up step: remembering to send each message on the right day, for every invoice, every time. That consistency is exactly what tends to fall apart when you're deep in a project. This is where invoice reminder software earns its keep: once an invoice is set up, InvoiceSnooze runs the follow-up cadence — day 3, day 7, day 14 — automatically, stops the moment a client pays, and flags anything that needs a human call. If you'd rather see each message before it goes out, you can review and approve them individually before they send.

For freelancers specifically, keeping every invoice on a consistent follow-up schedule — and being able to see, at a glance, what's current versus overdue — is what invoice reminder software built for freelancers is designed to handle. You can start free and have your first reminder cadence running in a few minutes.

Frequently asked questions

What is an accounts receivable aging report? An AR aging report is a list of every unpaid invoice you have outstanding, grouped by how long each one has been past its due date. The standard buckets are Current (not yet due), 1–30 days past due, 31–60 days, 61–90 days, and 90+ days. It's the clearest single-page view of which money is on its way, which is at risk, and which needs immediate action.

How often should I run an AR aging report? Weekly is the right frequency for most freelancers and small agencies. Running it monthly is too slow — an invoice can age through two buckets in a single month. A ten-minute weekly review lets you catch new overdue balances while they're still easy to collect and act before anything drifts into the 61–90-day danger zone.

What percentage of AR in the 90+ bucket is a warning sign? As a rough guide, when more than 15–20% of your total outstanding receivables sit in the 90+ bucket, it usually points to a systemic collections problem rather than one slow client. At that level, it's worth looking not just at individual clients but at your follow-up process, payment terms, and client intake habits. A healthy AR aging report keeps the vast majority of balances in Current and 1–30 days.

What's the difference between an AR aging report and a DSO calculation? DSO (Days Sales Outstanding) is a single average number: how many days it takes you to collect payment across all invoices in a period. The AR aging report shows the distribution underneath that number — which specific clients and invoices are driving the average up or down. They complement each other: DSO tells you if there's a problem; the aging report tells you exactly where it is.

Can I build an AR aging report without accounting software? Yes. A simple spreadsheet with five columns — client name, invoice amount, due date, days past due, and a bucket classification — gives you everything you need. Sort by days past due, sum each bucket, and you have a functional aging report. The only discipline required is updating it consistently, which is easier to maintain when it's a fixed ten-minute weekly task.

When should I send an overdue invoice to collections? Most small-business guidance points to 90 days past due as the standard threshold for collections referral, after a formal final notice has been sent and the deadline has passed with no payment. Before that point, direct follow-up — especially a phone call or switching to a different channel — has a meaningfully higher chance of recovering the balance without giving up 20–40% to a collections agency.

Let the reminders send themselves

InvoiceSnooze runs this exact cadence automatically — in a tone that still sounds like you.

Start free — no card required