Is Your Accounts Receivable Aging a Q4 Problem You Haven't Seen Yet
Is Your Accounts Receivable Aging a Q4 Problem You Haven't Seen Yet
By Donna Harris, MBA, MAcc, CEO of Bookkeeping Made Simple
Q4 cash-flow problems often begin in Q3.
Not because something suddenly goes wrong on October 1, but because unpaid invoices quietly age while the business owner is focused on serving customers, managing employees, and finishing the year strong.
Your accounts receivable aging report is one of the clearest tools you have for seeing that pressure before it reaches your bank account.
It can show you:
Which invoices are likely to be collected soon
Which customers need a follow-up now
Which balances may not turn into Q4 cash at all
Whether your cash-flow forecast is based on reality or optimism
If you operate a small business, accounts receivable at year end deserves more attention than simply looking at the total amount customers owe you. The age of those receivables matters just as much as the balance.
And remember: your P&L is an output, not the work. A report can show revenue that has been earned, or invoices that have been recorded, without telling you whether the cash is actually coming in. That requires reviewing the underlying details.
What an accounts receivable aging report actually shows
An accounts receivable aging report organizes unpaid invoices by how long they have been outstanding. The exact labels vary by accounting system and payment terms, but most reports include these categories:
An aging report is not just a list of customers who owe money. It is a timeline of your expected cash, and a warning system for invoices that may never become cash without action.
You can learn more about the basic structure of an aging report from Stripe’s accounts receivable aging guide or review QuickBooks’ instructions for running an A/R aging detail report.
Why balances over 60 days need attention now
A 61-day-old invoice is not simply a 31-day-old invoice with more time attached.
As a receivable ages, several things can happen:
The customer may have cash-flow problems of their own.
The invoice may be disputed, forgotten, or missing required documentation.
The person who approved the work may no longer be available.
Your team may lose track of follow-up.
The customer may become accustomed to paying late.
The invoice may no longer be a priority in the customer’s budget.
That is why balances past 60 days deserve active attention, especially as Q4 approaches. The longer you wait, the fewer realistic collection opportunities remain before the end of the year.
The collection window shrinks quickly in Q4. Customers may be closing their own books, managing holiday schedules, approving budgets, or delaying payments until January. If a Q3 invoice is already 60 or 90 days old in September, waiting until December to make contact may leave you with very few options.
This is particularly important if your Q4 expenses include:
Payroll increases or year-end bonuses
Inventory purchases
Equipment or technology investments
Estimated tax payments
Seasonal marketing
Holiday or year-end operating costs
A receivable is not useful for paying those expenses until it is collected.
How to use A/R aging as a Q4 cash-flow forecast
Start by running your accounts receivable aging report as of the most recent date available. Review it by customer and by bucket, not just as one total.
Then ask four questions.
1. How much is likely to be collected in the next 30 days?
Current balances and recently overdue invoices may represent your most realistic near-term cash opportunity. Confirm that the invoices are accurate, have been received, and include clear payment instructions.
For larger balances, do not wait until the due date has passed. A simple message can prevent a delay:
> “Hi [Name], I’m confirming that you received invoice [number] for [amount]. It is scheduled for payment on [date]. Please let me know if you need anything from us to keep it moving.”
2. Which balances need a direct conversation?
For invoices that are 31–60 days past due, email alone may not be enough. Call the customer or schedule a brief conversation.
You can say:
> “I’m following up on invoice [number], which is now [number] days past due. We want to make sure there isn’t a dispute or missing document holding up payment. Can you confirm the expected payment date?”
The goal is not to sound aggressive. The goal is to replace uncertainty with a specific next step.
If the customer cannot pay the full balance immediately, ask what they can pay, when they can pay it, and whether a written payment plan makes sense. Document the agreement and follow up when promised.
3. What is sitting in the 61–90-day bucket?
This category requires a more deliberate decision. A customer with a balance in this range may still pay, but you should not treat the full amount as guaranteed Q4 cash.
Consider:
Whether the customer has disputed the invoice
Whether all work was completed according to the agreement
Whether the customer has responded to prior reminders
Whether additional work is being provided without payment
Whether a credit hold or deposit requirement is appropriate
A firmer message might look like this:
> “Your account has an outstanding balance of [amount] related to invoice [number]. Please arrange payment by [date] or contact us by then to discuss a payment plan. Until the account is brought current, we may need to pause additional work.”
Use language that reflects your contract, customer relationship, and business policies. If the balance is material, you may also want legal or collections advice.
4. Can you realistically count on the 90+ day balances?
Be conservative.
A 90+ day receivable may eventually be collected, but it should not be the foundation of your Q4 spending plan. Separate what you hope to collect from what you can reasonably expect to collect.
For each 90+ day customer, decide whether to:
Make one final, clearly documented collection attempt
Resolve a legitimate dispute
Offer a settlement that protects your cash and time
Establish a formal payment plan
Refer the account to a qualified collections professional
Discuss a potential write-off with your accountant
Do not continue providing unlimited work to a customer with a severely overdue balance simply because the customer relationship feels uncomfortable to address. Your receivables are part of your business resources. Managing them is responsible business ownership.
Why September is a high-return month for collections
By mid-September, you still have time to influence what becomes Q4 cash.
That makes reviewing and clearing receivables one of the highest-return financial tasks you can take on before October 1. You may not need a new sale, a new marketing campaign, or a complicated financial strategy to improve cash flow. You may need to collect money your business has already earned.
A practical September process looks like this:
Run the current A/R aging report.
Review every balance over 30 days.
Identify the ten largest or most collectible accounts.
Assign a specific person to contact each customer.
Confirm invoice delivery, accuracy, and payment status.
Resolve disputes quickly.
Record promised payment dates.
Follow up consistently.
Update your Q4 cash-flow forecast based on realistic collection timing.
Stop treating doubtful receivables as available cash.
Review the report weekly as Q4 progresses. A/R aging is not a one-time report; it is a management tool.
What if the aging report is unreliable?
Your collection strategy depends on the report being accurate.
If customer payments have not been applied correctly, invoices are duplicated, credit memos are missing, or accounts have not been reconciled, the aging report may not reflect what customers truly owe. That can lead you to chase the wrong balances: or miss the right ones.
This is another reason a P&L is an output, not the work. Financial software can produce a report instantly. Reliable financial information requires the investigation and reconciliation behind that report.
Bookkeeping Made Simple provides ongoing bookkeeping and accounting services designed to give small-business owners current, usable financial information. If your books are behind or unreliable, our bookkeeping cleanup services can help establish a dependable starting point. Cleanup options are available at $997, $1,997, and $3,500, depending on the complexity and condition of the records.
Once your receivables are accurate, you can build a Q4 cash-flow forecast that supports real decisions: not assumptions.
Start Q4 with fewer surprises
Your accounts receivable aging report is telling you something right now.
It may be telling you that cash is on the way. It may be showing you that several customers need a personal follow-up. Or it may be revealing that part of your expected Q4 cash should be removed from the forecast until there is evidence it will be collected.
The important thing is to look before October begins.
A clear receivables picture gives you time to collect, negotiate, adjust spending, plan for financing, and make decisions from information rather than hope.
Ready to understand what your books are really saying before Q4? Book a Financial Clarity Call with Bookkeeping Made Simple.
