Blog

How to read an A/R aging report (and what to do with each column)

By Apsis team · October 26, 2026

If you bill other businesses, some of your money is always sitting in other people's accounts payable queues. That's normal on net-30 terms. The question is whether it's sitting there the way you expect, or quietly drifting. The accounts receivable aging report, usually just called "the aging," is the one page that answers that.

It looks like a dull table. It's actually one of the most useful reports a small consulting firm, agency or professional-services shop can look at, and it takes about ten minutes a week once you know how to read it.

What the aging report is

The aging lists every unpaid invoice, grouped by customer, and sorts the balances into buckets by how late they are. A typical layout looks like this:

• Current: not yet due.
• 1–30 days past due
• 31–60 days past due
• 61–90 days past due
• Over 90 days past due

Each customer gets a row, each bucket gets a column, and there's a total at the bottom. Some reports age invoices from the invoice date instead of the due date. Check which one yours uses, because on net-30 terms the difference is a full month.

Read it top-down first

Before you look at any one customer, look at the totals row. Ask two questions:

• How much is owed in total? Compare it to roughly one month of billing. If you invoice about $40,000 a month on net-30, having around $40,000 outstanding is about what you'd expect. Having $90,000 outstanding means something is slowing down.
• How much of it is current? In a healthy B2B firm, most of the balance sits in Current and 1–30. If a big share has moved to the right, cash is going to feel tight soon, even if sales look fine.

What to do with each bucket

Current

Nothing to chase. Just make sure each invoice actually reached the right person. For business clients, that often means accounts payable, not the person you did the work for. A wrong contact is one of the most common reasons a good client pays late.

1–30 days past due

Most of these are paperwork, not refusal. The invoice is waiting for an approval, a PO number, or the next check run. A short, friendly reminder with the invoice number, amount and how to pay clears most of them. If a client always lands here, ask their AP team when they run payments and time your invoices to fit.

31–60 days past due

Time for a personal note or a phone call, not another automatic email. Ask a direct, polite question: "Is anything holding up invoice 1042?" Sometimes there's a real issue, like a disputed line or a missing document, and you'd rather hear about it now. This is also a good moment to send a statement, so the client sees everything that's open in one place.

61–90 days past due

Now it's a business decision. Talk to the decision-maker, agree on a date or a payment plan, and write it down. Think hard before starting new work for a client in this bucket. Doing more work for someone who isn't paying only makes the number bigger.

Over 90 days past due

The longer an invoice sits, the less likely it gets paid in full. Decide what you're going to do: keep pursuing it, settle for part of it, or write it off. If you write it off, record it properly as a bad debt rather than deleting the invoice, so your books still show what happened. Your CPA can tell you how it affects your taxes.

Warning signs to watch week to week

• A client sliding one bucket to the right each week. That's a trend, not a hiccup. Call them before it reaches 60 days.
• Partial payments with no explanation. Often a sign of a disputed line item. Find out which one.
• One client making up a large share of the total. Concentration is a risk even if they always pay. If they're slow for one quarter, you'll feel it.
• Old small balances that never go away. A $45 short payment from March clutters the report and hides real problems. Collect it, credit it, or write it off.
• Payments you've received but not recorded. If deposits aren't matched to invoices, the aging is wrong, and you may end up reminding a client who already paid.

A ten-minute weekly routine

1. Record any payments that came in, so the report is accurate.
2. Look at the totals: total owed and how much is current.
3. Scan for any client that moved a bucket to the right since last week.
4. Send a personal note or make a call for anything past 30 days.
5. Send statements to clients with more than one open invoice.
6. Note anything over 90 days to decide on at month-end.

Pair this with a month-end close (see our month-end close checklist for a small firm) and you'll rarely be surprised by your cash.

How Apsis helps

In Apsis, Receivables shows aging on its overview, so you can see who owes what and how late it is without running a separate report. Invoices carry your payment terms (due on receipt, Net 14, Net 30, or custom) and can send up to four automatic reminders that stop when the invoice is paid or credited. You can print or email customer statements with your logo, and each customer's page shows their outstanding balance alongside contacts, invoices, payments and a timeline of emails and reminders. When a balance isn't coming, you can give a credit or write it off from one place, and write-offs go to a Bad Debt Expense account by default.

Your CPA gets a free accountant seat to review it with you. Apsis is $19/month for your first company with three users, after a 30-day free trial. It doesn't run payroll, so if you have employees, keep your payroll service and record payroll in your books. Try Apsis free for 30 days.