AR Aging for Service Businesses: A Simple Weekly Review Rhythm

An aging report groups unpaid invoices by how long they have been outstanding, usually current, 1–30 days, 31–60, 61–90, and over 90. The buckets are not just categories. They approximate the probability of being paid without effort, and that probability drops noticeably as invoices move right.

Which is why movement between buckets is the signal, not the totals. A balance that holds steady while individual invoices slide rightward is a worse position than a growing balance where everything stays current. The totals hide that; the movement does not.

Same day each week, about fifteen minutes. The consistency matters more than the day.

1. Total outstanding, compared to last week

Up or down, and roughly why. Up because you invoiced more is fine. Up because nothing was collected is not, and those two look identical if you only check the number.

2. What crossed a bucket boundary

The core of the review. Invoices that moved from current into 1–30, or from 31–60 into 61–90. Each crossing is a small escalation, and catching it in the week it happens means a light-touch follow-up rather than an uncomfortable conversation two months later.

3. Concentration

Is one client a large share of what is outstanding? A balance spread across fifteen clients is a collections rhythm question. The same balance concentrated in one client is a risk question, and it deserves different attention.

4. The genuinely old items

Anything past 90 days usually has a reason that is not slow payment: a dispute nobody resolved, an invoice that never reached the right person, work the client believes was not completed, or a payment that was made and never applied. These need diagnosis rather than another reminder, and sending a fourth statement for an invoice the client disputes actively damages the relationship.

5. Assign the follow-up

Every overdue item gets a name and a next action before the review ends. A review that produces awareness but no assignment is a report you looked at.

Before building a rhythm on the aging report, it is worth confirming the report is real. These problems are common and they all produce the same outcome: chasing clients who do not owe you money.

• Payments received but not applied. The money is in the bank and the invoice still shows as open, because the payment was recorded as generic income rather than applied to the invoice. The most common cause, and the most damaging to relationships.
• Credits and write-offs never recorded. An amount you agreed to waive is still sitting in the aging report as collectible.
• Invoices issued outside the system. A quick invoice sent from email or a template and never entered into the books. It is owed and it is invisible.
• Deposits applied to the wrong invoice. Common on project work, and it makes two invoices wrong at once.
• Disputes not flagged. An amount under discussion showing as straightforwardly overdue, so it gets chased as though it were.
• Negative accounts receivable. A negative balance almost always means payments applied without matching invoices. It is a reliable sign the receivables ledger has not been maintained.

If several of these apply, the aging report needs cleanup before it needs a rhythm. Why a current-looking file can still be unreconciled covers how a file gets into this state.

Over a few months the aging report starts describing the business rather than just the balance:

• Everything is slightly late. Usually a terms or invoicing-timing problem rather than a client problem. If invoices go out on the 15th for work finished on the 1st, you have added two weeks to every collection cycle yourself.
• Specific clients are consistently late. That is a terms conversation, and for some businesses a deposit-requirement conversation.
• Disputes cluster around one service. Often an expectation-setting or scope-documentation problem upstream, showing up as a receivables problem downstream.
• The balance grows with revenue. Expected up to a point. If it grows faster than revenue, collection is slowing while you are getting busier, which is the setup for a cash squeeze during a good quarter.

That last pattern is the one that catches growing firms out. Cash-flow surprises covers the other signals that tend to accompany it.

Weekly review handles the operating rhythm. The monthly close is where receivables get a structural look: is the ledger accurate, are credits recorded, is anything genuinely uncollectible still sitting there, and was everything delivered actually invoiced.

That last question is worth repeating, because it is the one thing an aging report structurally cannot tell you. Work that was delivered and never invoiced does not appear anywhere — not in receivables, not in revenue. It looks exactly like a quieter month. The month-end close checklist covers where that check belongs in the sequence, and what monthly bookkeeping includes covers where receivables tracking sits in ongoing scope.

Lynn Solutions keeps the receivables ledger accurate: payments and credits applied correctly, disputes flagged rather than aged silently, invoices entered, and an aging report that reflects what is actually owed. Where receivables tracking is in scope, that includes surfacing the patterns above rather than leaving you to find them.

We do not perform collection activity, and past a certain point the question stops being a bookkeeping one entirely. Formal collection remedies are subject to legal requirements and belong with an attorney.

Ongoing receivables support sits within monthly bookkeeping and finance operations. Where the question moves from "what is outstanding" to "what does this mean for cash over the next quarter," that is CFO and advisory support, which works best layered on books that are already reliable. This comes up most often with professional services firms, where receivables and payroll timing drive most of the cash picture.