You have finished the work and sent the invoice. Your books show money owed to the business, but that money is not available to pay next week’s bills yet.
An accounts receivable aging report helps you see which customer balances are still open and how far past due they are. For a small business that invoices clients, it can turn an uncomfortable pile of unpaid invoices into a manageable follow-up list.
The goal is practical: know which records need attention, which customers need a conversation, and which payments you can reasonably include in your cash plan.
What an accounts receivable aging report tells you
Accounts receivable, often shortened to A/R, is money customers owe for invoiced goods or services. An aging report organizes those open balances into time periods so you can distinguish amounts that are not yet due from overdue amounts.
A summary report shows customer totals. A detail report lets you investigate the individual invoices behind those totals. Intuit’s guide to A/R aging reports explains these two views in QuickBooks Online.
The report answers “What remains unpaid?” It does not guarantee when a customer will pay.
How to read the aging columns
When aging is based on invoice due dates, common columns include:
Current: The payment deadline has not passed.
1–30 days: The balance is up to 30 days past due.
31–60 days: The balance is between 31 and 60 days past due.
61–90 days: The balance is between 61 and 90 days past due.
91+ days: The balance is more than 90 days past due.
Check your report’s settings before interpreting the labels. For example, an invoice issued 40 days ago with payment due 10 days ago belongs in the 1–30 days overdue column when the report uses due dates. “Current” does not mean the invoice was created this month. Intuit explains the difference between current and past-due balances.
A simple example: $9,000 owed is not $9,000 available
Imagine a small service business with these fictional customer balances:
Client A: $4,800 current, with payment expected within two weeks.
Client B: $2,700 that is 18 days overdue, with no confirmed payment date.
Client C: $1,500 that is 47 days overdue because of an unresolved invoice question.
The total is $9,000, but each balance needs a different next step. Confirm Client A has the invoice, ask Client B about payment timing, and resolve Client C’s question. Do not automatically enter all $9,000 as money arriving this month.
This distinction makes the report useful: it helps you move from a total on the page to specific conversations and more realistic estimates.
A weekly routine for reviewing overdue invoices
1. Check the records before contacting customers
Review recent deposits, partial payments, credits and duplicate invoices. Confirm that received payments were applied to the correct invoices. A customer should not receive an overdue reminder for something they already paid.
Use a consistent report date. If you compare A/R aging with your balance sheet, review the dates, aging method and accounting basis. Intuit’s report-matching guidance explains why those settings matter.
2. Choose a short, useful follow-up list
Look at the amount owed, days overdue, promised payment dates and unresolved questions together. An older small balance may need attention, while a larger recently overdue payment may affect your next payroll.
Give each selected invoice one owner and one next action. “Call the billing contact to confirm receipt” is more useful than “Follow up sometime.”
3. Make the conversation clear and courteous
Include the invoice number, remaining balance, original due date and a copy of the invoice. Ask whether the customer needs anything to process payment and request an expected payment date.
If an invoice is disputed, record the specific issue and who will resolve it. Repeated reminders will not fix a missing purchase order or an unanswered question about the work.
4. Record the outcome and the next check-in
A short note can capture the date contacted, customer response, promised payment date, staff owner and next review date. Keep this beside your invoice records so another team member can understand what happened.
A promise to pay is useful information, but it is not a received payment. Update the balance when payment is actually recorded.
5. Look for recurring problems
If several customers need replacement invoices, review your delivery process. If approvals repeatedly stall, confirm the correct billing contact and required reference information before sending the next invoice.
Use the patterns to improve your routine. An aging report works best when someone turns its information into a clear next step.
Use the free Cash Flow Snapshot to plan ahead
Once you have reviewed expected payment dates, try A+’s free 30-Day Cash Flow Snapshot. Enter your available cash, the payments you realistically expect to receive, upcoming cash outflows and an optional cash cushion.
Using the example above, $5,000 in available cash plus $4,800 in expected receipts, minus $7,000 in upcoming payments, produces an estimated ending balance of $2,800. Adjust expected receipts to explore what happens if a payment is delayed.
The tool estimates your ending position; it does not track each payment date. A positive ending balance can still hide a shortfall before a bill is due. Our 30-day cash flow planning guide helps you consider that timing.
Common questions
How often should I review the report?
A weekly check is a useful starting routine for many invoice-based businesses. Review more frequently when a few large payments determine whether upcoming bills can be covered.
Does an old invoice automatically become a write-off?
No. Age alone does not settle whether an amount is collectible or how it should be recorded. Investigate the balance and review the appropriate treatment with your accountant.
Can I start without buying another tool?
Yes. Start with the reporting available in your existing accounting system. A maintained spreadsheet can also list open invoices, due dates, outstanding balances and follow-up notes. Its usefulness depends on keeping those records accurate.
Build a routine you can keep using
Accountability Plus offers bookkeeping, financial organization and QuickBooks guidance to help small businesses understand their numbers and improve their processes.
If overdue invoices are hard to track or your reports do not match what you expect, email A+ for a consultation. We can discuss your current records and the practical next steps toward clearer financial information.