Scrumptious Enterprises

Accounts Receivable Aging: Find Cash Tied Up in Unpaid Invoices

Use accounts receivable aging to spot overdue invoices, prioritize follow-up and improve your cash forecast before seeking working capital for your business.

Business owner reviewing organized invoices beside a laptop

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.

Scroll to Top