Accounts receivable aging groups unpaid customer invoices by how long they have been outstanding or overdue. It helps an owner see which expected receipts need attention. A sales total can look healthy while cash remains stuck in invoices, so this report belongs beside your bank balance and cash forecast.
The report is a starting point for action. It does not prove that every listed dollar will be collected. Confirm the due dates, resolve disputed charges and update your expected receipt dates before using the balance to support a funding decision.
How to build an accounts receivable aging report
Choose one reporting date. Export open invoices from your accounting system, then check customer names, invoice numbers, original amounts, remaining balances and due dates. Remove credits and payments that have already cleared but were not matched correctly. Keep a note explaining any adjustment.
Choose whether your buckets measure days since the invoice date or days past the due date. Label that choice clearly and use it consistently. A net-30 invoice issued yesterday is not overdue. Mixing the two methods can exaggerate collection problems.
| Bucket | What to check | Useful next action |
|---|---|---|
| Current | Invoice received and approved? | Confirm the expected payment date |
| 1–30 days overdue | Missing details or routine delay? | Send a polite reminder with the invoice |
| 31–60 days overdue | Dispute, approval issue or payment problem? | Contact the responsible person and document the response |
| More than 60 days overdue | Likelihood and timing of recovery? | Review next steps with your accounting or legal adviser |
Prioritize collection work without harming relationships
Sort by balance and delay, then assign an owner to each follow-up. Start with a neutral question: has the customer received everything needed to process payment? A missing purchase order or acceptance record can delay an otherwise willing payer. Fix the underlying issue before sending repeated reminders.
Keep a short contact log with the date, person reached, issue and promised next step. Confirm any revised arrangement in writing. Follow the applicable agreement and obtain advice before adding charges or taking legal collection action. This article does not set collection rules for your jurisdiction.
Turn invoice data into a cash forecast
Put expected receipts into the weeks when they are likely to clear, rather than the weeks you wish they would arrive. Consider a separate slower-collection scenario for uncertain accounts. Do not count the same invoice twice or treat an unapproved estimate as a completed sale.
For example, a hypothetical $12,000 receivable might include $7,000 with a confirmed payment date and $5,000 under dispute. A cautious forecast shows those separately. Paying next week’s payroll with the full $12,000 assumption could create a shortfall.
Our 13-week cash flow forecast explains how to place receipts beside expenses. The FDIC’s Managing Cash Flow education module offers further cash-flow learning.
When working capital may enter the discussion
If a profitable job creates a timing gap, compare the expected collection date with the cost and payment schedule of any funding offer. If invoices remain unpaid because customers dispute the work, resolve the dispute first. Financing does not make an uncertain receivable certain.
Read our working capital gap guide to separate a timing issue from a profit problem. Also review customer concentration: one large overdue account may matter more than many small current invoices.
Frequently asked questions
How often should a small business review aging?
A weekly review can be useful when cash is tight or invoice volume is high. Choose a regular cadence that fits your business and keep the reporting method consistent.
Does an overdue invoice mean the customer will not pay?
No. It may reflect a paperwork issue, dispute or delay. Investigate the reason and revise your forecast based on evidence.
Should I borrow against every unpaid invoice?
No. First assess collectability, timing, cost and the agreement’s requirements. A funding option must fit the underlying business need.
Build a clearer working capital plan
Scrumptious Enterprises LLC helps owners discuss working capital needs with a practical focus on cash flow. Book a conversation with your aging report and forecast ready. Funding eligibility and terms vary.




