top of page
Hands using a calculator beside a printed invoice and charts.

Accounts Receivable Aging: Find the Cash Hidden in Unpaid Invoices

1 day ago
3 min read

By Leyda Lazo, SHRM-SCP | Human Capital Consultants International (HCCI)


HCCI Insights · November 14, 2026 · Cash Flow & Financial Strategy


An accounts receivable aging report helps you separate invoices that are current from amounts that need collection attention or accounting review. Use it to investigate unpaid balances, not to assume every recorded dollar will arrive on time.


What the numbers need to tell you


Aging depends on accurate invoice dates, due dates, payments, credits, and customer records. A balance may remain open because of a dispute, a missing purchase-order number, an unapplied payment, or a real inability to pay. Each situation needs a different next step.



Three practical steps


  • Reconcile the receivables listing to the general ledger. Resolve unapplied receipts and credits before asking customers to pay balances that may already have been settled.

  • Prioritize significant overdue invoices and document the reason, responsible contact, promised action, and realistic collection date. Separate disputed amounts from routine reminders.

  • Give the accountant evidence about doubtful balances for assessment under the applicable reporting basis. Keep cash forecasts realistic while collection and accounting decisions are being reviewed.


A closer look at the decision


The collections conversation should begin with an accurate balance and a specific request. A customer disputing delivery needs a different response from a customer waiting for a corrected invoice. Ask whether the invoice reached the right contact, whether required supporting documents were included, and whether any agreed credit is missing. Then update the forecast with the expected collection date and the uncertainty around it. Do not let a confident verbal promise erase a long history of delays. Accounting and the commercial contact should agree what has been confirmed and what remains an assumption.


A hypothetical example


Imagine a $60,000 receivables report with $18,000 overdue. Of that overdue balance, $5,000 was paid but not applied, $7,000 is disputed, and $6,000 requires ordinary follow-up. Treating the whole $18,000 as one collection problem would miss both a bookkeeping correction and a commercial decision.


Turn the analysis into a cash decision


Write down the amount, expected date, and confidence level behind the cash assumption. Separate a confirmed obligation from discretionary spending and a verified receipt from a hopeful collection date. This makes the discussion more useful than debating whether the bank balance feels comfortable. Management can then see which decision is available now and which depends on information that has not yet been confirmed.


Compare at least one reasonable downside case with the base case. Change the assumption that matters to this decision rather than applying an arbitrary percentage to every line. Show the resulting low cash point and the actions available before it occurs. Confirm any financing or commercial alternatives instead of assuming they will be available. Keep the scenario clearly labeled as a planning exercise, not a prediction or a promised outcome.


A question owners ask


How often should this cash assumption be reviewed?


Use a frequency that matches the business’s cash cycle and the significance of the decision. A fast-changing collection or payment situation may need weekly attention, while a stable longer-term assumption may need less frequent review. Revisit it promptly when the underlying facts change. The purpose is timely decisions, not producing a new spreadsheet when nothing meaningful has changed.


The point to keep in view


An aging bucket is a starting point for investigation, not proof that an invoice is collectible or uncollectible.


Your next step


Update the relevant cash assumption using verified records and put the resulting decision on the next financial review agenda. Identify the amount at stake, the timing, and the response if the assumption changes. That creates a practical basis for spending and funding decisions.


Keep this review proportionate to the amount and the decision involved. Start with the most significant uncertainty, resolve it with the appropriate records and adviser, and document the conclusion. A focused review that produces an explained number and a clear next action is more useful than collecting additional reports without resolving the original question.


Have a question about organizing your company’s accounting function? Contact HCCI to discuss the support you need and the scope of an appropriate engagement.



Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
bottom of page