Accounts receivable aging

An accounts receivable aging report lists every unpaid customer invoice grouped by how long it has been outstanding, usually current, 1-30, 31-60, 61-90 and over 90 days.

It shows which customers are paying slowly before cash gets tight. The older an invoice gets, the less likely it is to be collected in full.

Example

A contractor has $12,000 outstanding. $7,000 is current, $3,000 is 31-60 days old and $2,000 is over 90 days. The $2,000 is the one to call about today, and the one to consider writing off if it never arrives.

Common mistake

Reading the total and ignoring the buckets. A large total of current invoices is healthy. The same total weighted toward 90+ days is a cash problem.

How to use it

Check it monthly. Follow up on anything past terms, and decide in advance when an old invoice becomes a bad-debt write-off.

How to read the buckets

Start with the current column, which should hold most of your balance in a healthy business. Then look at 31-60 days, where slow payers show up first. Anything past 60 days deserves a phone call rather than another email, and anything past 90 days needs a decision: keep chasing, offer a payment plan or write it off. Compare each month with the one before. A balance that is creeping from one bucket to the next tells you more than any single snapshot.

What to do with an old invoice

First confirm the invoice is correct and that the customer received it. Many old invoices are old because of a wrong address, a missing purchase order number or a dispute nobody noticed. If the customer is simply late, follow your terms: a reminder at the due date, a call a week later, then a written notice. If a balance will not be paid, record it as bad debt in the period you decide it is uncollectible, so your profit and loss shows the real result.

A simple monthly routine

Run the report on the same day each month, after payments are recorded and the bank account is reconciled. Sort by customer and look at the largest balances first. Write a short note beside each overdue invoice, such as who you contacted and what they said. Next month, check whether the note led to a payment. A routine this small catches most collection problems early, because nothing sits unnoticed for more than one cycle. It also gives your bookkeeper and your CPA a clear record if a balance has to be written off. Keep customer terms consistent too: if some customers get net 15 and others net 60 with no reason, your aging report will be hard to read and harder to enforce.

How it connects to cash flow

An aging report is a preview of your bank balance. Invoices in the current bucket will likely turn into cash soon, while the older buckets are cash you should not plan on. Pair the report with your upcoming bills to see whether a gap is coming. Your bookkeeper can run it in your accounting software every month and flag the customers that need attention, so slow payment becomes a routine task instead of a surprise.

Want your books kept this way every month?

A dedicated Mispar bookkeeper keeps your records current and tax-ready, from $229/mo. Book a free consultation to see how it works for your business.