A busy calendar does not guarantee cash in the bank. A consulting firm may finish several projects in November while still waiting for payment on September invoices.
An accounts receivable aging report shows who owes money, how much remains unpaid, and which balances are overdue. It helps turn a long invoice list into a clear follow-up plan.
Before year-end, that plan deserves attention. Client approvals, office closures, and staff leave may affect payment timing. Start early so there is time to resolve questions before December ends.
Table of Contents
What Is an Accounts Receivable Aging Report?
This report groups unpaid customer balances by age. When it uses due dates, it separates amounts that are still current from those that are past due.
Accounts receivable means money customers owe for goods or services already billed on credit. For a service business, that could include a monthly retainer or a completed project milestone.
The report is a snapshot as of a chosen date. A summary shows balances by customer. A detail report shows the individual invoices behind those totals.
Intuit’s guide to running an accounts receivable aging report explains both views. Use the summary to spot concerns, then open the details before contacting a client.
How Do You Read the Aging Categories?
Common categories include the following:
- Current: Invoices that are not yet past due.
- 1–30 days past due: Balances that recently passed their payment deadline.
- 31–60 days past due: Older balances that need closer attention.
- 61–90 days past due: Long-outstanding amounts that may need a different follow-up approach.
- More than 90 days past due: The oldest group in this example.
Check the settings before relying on these labels. Some systems allow different intervals or an invoice-date basis. For collections, make sure the view clearly identifies overdue amounts.
For example, an invoice dated November 1 and due December 1 is not late on November 20. Its invoice age and days past due tell different stories.
Oracle’s explanation of aging calculations shows how the selected date and due date determine the category. It also explains why partial payments and credits affect the remaining balance.
A Simple Service Business Example
Assume a design agency reviews its books on November 30. All amounts below are hypothetical. Its unpaid balances total $30,000:
- Current: $18,000.
- 1–30 days past due: $6,000.
- 31–60 days past due: $4,000.
- 61–90 days past due: $2,000.
- More than 90 days past due: $0.
The overdue balance is $12,000. That equals 40% of total receivables: $12,000 divided by $30,000, multiplied by 100.
However, 40% is a finding to investigate, not a universal pass-or-fail score. Payment terms, disputes, client mix, and past trends all matter.
Next, the agency checks the invoices. A $4,000 balance is missing a purchase order. Another client has promised to pay $6,000 in early December. The oldest $2,000 remains disputed.
Each balance needs a different action. Resending the same reminder to every client would miss those differences.
Step 1: Confirm That the Balances Are Correct
Clean up the records before sending collection messages. An incorrect reminder can create confusion and damage trust.
First, check for payments already received but not matched to invoices. Then review partial payments, duplicate invoices, approved credits, and billing errors.
Use the same reporting date when comparing the aging total with the accounts receivable balance in the books. Ask your bookkeeper to investigate differences in settings or entries.
Keep later payments separate from the historical snapshot. For instance, a December payment should not disappear from your November 30 review without an explanation.
NumberSquad’s tax-ready financial reporting guide explains why accurate records support useful reports. The same foundation matters when deciding which clients need follow-up.
Step 2: Prioritize More Than the Oldest Invoice
Age matters, but it should not be the only factor. Also consider the amount owed, the reason for delay, and the next approval date.
A large invoice missing one document may be easier to resolve than a small balance under dispute. Meanwhile, a newer invoice may need attention before its approver leaves for the holidays.
For each priority balance, record:
- The invoice number and remaining amount.
- The due date and days past due.
- The billing contact and decision-maker.
- The reason for delay, if known.
- The next action and person responsible.
- The agreed payment date, if confirmed.
This turns the report into a working list. It also prevents several team members from contacting the same client without context.
Step 3: Resolve Billing Questions Before Holiday Closures
In November, ask clients about their December invoice cutoffs and approval schedules. Check whether they need a purchase order, time records, or proof that a milestone is complete.
Do not assume every client closes for the same holidays. Ask about the dates that affect your own invoices.
For an overdue payment, keep the message specific:
“Hello Alex, our records show a remaining balance of $2,400 on invoice 184, due November 15. Could you confirm receipt and the expected payment date? Please let us know if you need any supporting documents.”
If the client reports an error, verify it before continuing reminders. If the amount is disputed, document the concern and assign someone to resolve it.
The goal is a clear next step. A vague promise to “look into it” still needs a follow-up date.
Step 4: Update Your Cash Forecast With Realistic Dates
An unpaid balance is not a confirmed bank deposit. Move collection information into your forecast only with clear assumptions.
In the agency example, the client expects to pay $6,000 in early December. The agency can use that date in its main forecast if the promise is credible. It should also test what happens if payment arrives later.
The disputed $2,000 needs a more cautious assumption. Avoid depending on it to cover an essential payment before the dispute is resolved.
NumberSquad’s November and December cash flow guide explains how expected receipts fit alongside payroll, contractor payments, and January needs.
Update the forecast when payment clears. If a client misses a promised date, revise the plan and follow up.
A Practical November and December Review Schedule
Use this schedule as a starting point, then adjust it to your billing cycle.
Early November: Review open balances and correct errors. Confirm billing contacts and holiday approval schedules.
Each week in November: Resolve missing documents and contact overdue accounts. Record payment promises and check whether clients meet them.
Early December: Review upcoming due dates and client cutoffs. Send invoices promptly when the contract allows billing and the work meets the agreed milestone.
Before client closures: Confirm unresolved approvals and expected payment dates. Update the cash forecast for any changes.
At year-end: Save a dated report for the closing review. Discuss old, disputed, or doubtful balances with your accountant. Do not remove invoices simply to make the report look cleaner.
Mistakes That Can Weaken Your Collection Process
Treating every open invoice as late. Current balances still have time left under the agreed terms.
Counting the original invoice amount after a partial payment. Follow up on the correct remaining balance.
Stopping after one reminder. Assign a next action so unresolved items do not disappear from view.
Offering discounts automatically. A discount reduces what the business receives. Review the cost and get approval before changing the agreement.
Assuming age proves a debt is uncollectible. An older balance needs investigation. Age alone does not settle its accounting or tax treatment.
Frequently Asked Questions
How often should a small business review unpaid invoices?
A weekly review can be useful when the business invoices regularly or depends on a few large payments. Adjust the frequency to your billing volume and cash needs.
Does an aging report show cash available to spend?
No. It shows unpaid customer balances. Cash becomes available only when payments arrive and clear, subject to any restrictions or other commitments.
Should I follow up before an invoice is overdue?
You can confirm receipt or check approval requirements before the due date. Keep the message courteous and consistent with the agreed terms. Do not describe a current invoice as late.
Does collecting an old invoice create new profit?
Under accrual accounting, collecting an invoice generally reduces receivables and increases cash. Revenue may already have been recorded. Cash-basis treatment differs, so confirm your reporting method with your accountant.
End the Year With a Clear Follow-Up Plan
The most useful review ends with action. Confirm the balance, identify the obstacle, assign an owner, and set the next date.
Start with your largest or most time-sensitive unresolved invoices this week. Then use what you learn to update the cash forecast.
If your balances are difficult to trust, NumberSquad can help with bookkeeping and financial reporting. Accurate records give your business a stronger starting point for year-end decisions.
