Accounts Receivable Aging Explained for Small Businesses
Updated
Sending an invoice is the easy part. Knowing which invoices are late, by how much and who to follow up with first is where many small businesses lose track, and lose cash. An accounts receivable aging report answers those questions on one page. This guide explains how aging works, how to set it up, and a simple weekly routine for using it.
What "accounts receivable" means
Accounts receivable (AR) is money customers owe you for work already invoiced. It's earned but not yet collected. For a freelancer or small service business, AR is usually just a list of open invoices.
What an aging report shows
An aging report groups every unpaid balance by how many days past its due date it is. A common set of buckets:
| Bucket | Meaning |
|---|---|
| Current | Not yet due |
| 1–30 days | Up to a month overdue |
| 31–60 days | One to two months overdue |
| 61–90 days | Two to three months overdue |
| 90+ days | More than three months overdue |
At a glance you can see how much is owed, how much is late, and how late. In general, the older a balance gets, the harder it tends to be to collect, which is why the buckets help you decide who to chase first.
Step 1: Get due dates right
Aging is measured from the due date, not the invoice date. So every invoice needs:
- An issue date
- Payment terms (for example 15 or 30 days)
- A due date = issue date + terms
Calculate the due date with a formula rather than typing it by hand, and use the same default terms for most customers so nothing slips.
Step 2: Track payments, including partial ones
Customers don't always pay in one go. For each invoice, record:
- Amount invoiced
- Amount paid so far (and the date of each payment)
- Balance = invoiced − paid
The balance, not the original amount, is what goes into the aging buckets. A $1,000 invoice with $600 paid shows $400 outstanding.
Step 3: Decide each invoice's status
Three statuses cover most cases:
- Paid: balance is zero.
- Open: balance owed, not yet past the due date.
- Overdue: balance owed and past the due date.
Then calculate days overdue as "as-of date − due date" for overdue invoices only. The as-of date is usually today, but you can set it to a month-end date to see the report as it stood then.
Step 4: Handle overpayments as credits
Sometimes a customer pays more than they owe, by paying twice or rounding up. Don't let that show as a negative balance mixed in with everything else. Record it as a customer credit, show it separately, and either apply it to their next invoice or refund it.
Step 5: Keep "Overdue" off the customer's copy
Your internal tracker should say "Overdue". The invoice you send a customer usually reads better with neutral wording: Balance due, Paid or Credit. Polite, factual reminders tend to get a better response than a document stamped in red.
A weekly AR routine (15 minutes)
- Update payments. Mark everything received since last week.
- Look at the 1–30 bucket. Send a friendly reminder with the invoice attached.
- Look at 31–60. Follow up personally by phone or a direct message, and confirm they received the invoice and nothing is disputed.
- Look at 61–90 and 90+. Decide on next steps: a payment plan, pausing work, or professional advice on formal collection. Late fees, interest and collection practices depend on your state's rules and your agreement with the client, so check your local rules and contract terms before charging fees or escalating.
- Check credits. Apply or refund any customer credits.
- Glance at the monthly trend. Compare what you invoiced with what you collected.
Invoiced vs collected: the number to watch
Two monthly figures tell you a lot:
- Invoiced: total of invoices issued that month (by issue date).
- Collected: payments received that month (by paid date).
If invoiced keeps running ahead of collected, AR is growing and cash is getting tied up, even if sales look healthy.
Common mistakes
- Aging from the invoice date instead of the due date.
- Ignoring partial payments, so a mostly paid invoice looks fully overdue.
- Letting overpayments hide as negative balances.
- Typing due dates by hand and getting them wrong.
- Only checking AR at tax time instead of weekly.
A ready-made tracker
If you'd rather not build this yourself, our Invoice Tracker Spreadsheet ($12, for Google Sheets & Microsoft Excel), one of our business spreadsheet templates, includes:
- An invoice log with automatic due dates from your payment terms
- Partial payments, balance and Paid/Open/Overdue status, with overpayments shown as customer credits
- Days overdue and aging buckets (Current, 1-30, 31-60, 61-90, 90+)
- A 1-page printable invoice (up to 10 line items per printed invoice) that fills in line items, service date and service address from the log and shows customers Balance due / Paid / Credit, never "Overdue"
- A dashboard with total owed, customer credits, overdue count, and monthly invoiced (by issue date) vs collected (by paid date, capped at the invoice amount) for the year you choose
The bottom line
An accounts receivable aging report turns a pile of invoices into a short to-do list: who owes what, how late it is, and who to contact first. Get the due dates right, track partial payments and credits, and spend 15 minutes on it every week.
This article is general information, not legal, accounting or financial advice.