
Review accounts receivable aging by checking that the invoice list is accurate, then prioritizing balances by due date, size, dispute status, and likelihood of collection. Contact customers using the terms you agreed to, record each response, and use realistic expected payment dates in your cash forecast. The report is a collection worklist, not a promise that every dollar shown will arrive this month.
What does an aging report show?
An accounts receivable aging report groups unpaid customer invoices by how long they have been outstanding. Common buckets include current, 1–30 days, 31–60 days, and older. The exact bucket is less important than the invoice date, due date, customer, amount, and status behind it. A balance can look old while still being within agreed terms.
Run the report as of a specific date and keep that date on the copy you review. If you compare two months, use the same rules for each. Our free monthly reporting guide explains how an aging report fits with the other numbers an owner should review after the books close.
Can you trust the balances?
Check that bank and payment accounts are reconciled and that customer payments have been applied to the right invoices. Unapplied deposits, duplicate invoices, credits sitting in the wrong account, and payments recorded against the wrong customer can make a collection call embarrassing and unnecessary. Fix the record before telling someone they owe you money.
Look at a sample of large and old balances against the actual invoices and customer correspondence. If an invoice was disputed or replaced, the report should reflect the resolution. The monthly bookkeeping close gives this review a reliable place in the schedule rather than leaving it for a cash emergency.
Which invoices deserve attention first?
Sort by business impact, not just age. A large invoice one day past its due date may matter more to cash flow than several small invoices a month old. A disputed invoice needs a different action from one the customer simply overlooked. Flag balances with promised payment dates, missing purchase-order references, or work that has not been accepted.
Do not send the same reminder to everyone in an aging bucket. The owner of a customer relationship should know whether the invoice needs a corrected document, a call, or a straightforward nudge. If many invoices are consistently late, look at how they are issued and whether the due date and payment instructions are clear.
What follow-up should happen?
Begin with the agreement and the invoice. Confirm the customer received it and that the amount, scope, tax treatment, and payment instructions match what was approved. For a routine late payment, a concise reminder with the invoice number, due date, amount, and secure payment route is usually more useful than a vague demand.
Record the date of contact, who responded, any dispute, and the next promised action. Assign a follow-up owner and date so the conversation does not disappear into an inbox. If there is a disagreement, resolve the substance before repeating the reminder. For persistent nonpayment, discuss next steps with an appropriate professional rather than treating a blog checklist as legal advice.
How does the report help with cash planning?
Use expected collection dates, not the total receivable balance. An invoice due tomorrow may arrive late; a disputed invoice may not arrive until a correction is accepted. Combine the aging report with known payment behavior and current customer communication. Then compare expected receipts with payroll, bills, loan payments, and other near-term cash needs.
For a simple hypothetical example, imagine the aging report shows 30,000 in unpaid invoices. If 10,000 is disputed and another 8,000 is not due for three weeks, treating the full 30,000 as next week's cash would mislead the owner. A forecast might include only the amount with a credible near-term payment date and keep the rest visible as uncertainty. This is where fractional CFO support can connect clean bookkeeping with decisions.
What should a monthly review look like?
- Reconcile payment accounts and apply customer payments.
- Review credits, deposits, and invoices that may have been replaced or disputed.
- Sort the aging report by due date, amount, and customer.
- Assign a next action and owner to meaningful balances.
- Update expected receipt dates in the cash forecast.
- Look for repeated delays caused by invoicing or contract terms.
Keep notes beside the invoices or in the customer record. A spreadsheet of follow-ups that is not connected to the source can become another stale report. For bookkeeping clients, Pinstripe Ledger presents the monthly business snapshot; the detailed invoice work still needs to be done in the accounting workflow.
| Invoice condition | First check | Likely next step |
|---|---|---|
| Newly overdue, no dispute | Was the invoice received? | Send a concise reminder. |
| Disputed | What amount or scope is questioned? | Resolve and document the correction. |
| Paid but still showing | Is the payment unapplied? | Correct the accounting record. |
| Repeatedly late | Are terms and process clear? | Review billing cadence and terms. |
Frequently Asked Questions
Is an old invoice automatically overdue?
No. Compare the invoice due date with the customer's agreed terms. Age since invoice date and lateness are different measures.
Should I delete an invoice that will not be collected?
Do not delete it just to make the report look better. Discuss the appropriate accounting treatment with your bookkeeper and tax professional, and keep an audit trail of the decision.
How often should I review aging?
Monthly is a useful baseline after the books close. A business with many invoices or tight cash needs may need a weekly collection review.
Does the aging report replace a cash forecast?
No. It shows unpaid invoices, while a forecast considers when cash may actually arrive and which payments will leave the business.
If unpaid invoices are hard to explain or follow up, contact Pinstripe. We can help organize the books and make the report useful for action.
Free download, no email required
Year-End Close & 1099 Kit
A November-to-January close timeline, the 1099 rules in plain English, and a vendor tracker that flags who needs a form.
How to use it