ENRO · All articles

How to build a construction receivables aging report

Sort unpaid invoices by due date, explain disputed balances and avoid double-counting receipts.

By ENRO team

A receivables aging report groups unpaid amounts by how late they are. Choose a reporting date and calculate lateness from the invoice's agreed due date, not whichever date makes the balance appear newer.

An example at 31 October

Invoice A has ₹2 lakh outstanding and was due on 20 October: 11 days overdue. Invoice B has ₹3 lakh outstanding and was due on 15 September: 46 days overdue. Invoice C is ₹1 lakh and is due on 10 November: not due yet. These illustrative balances total ₹6 lakh, of which ₹5 lakh is overdue.

If ₹50,000 of invoice A has already been received and allocated, its outstanding balance becomes ₹1.5 lakh. Do not retain the full invoice value in aging and also show the receipt as an unrelated positive figure.

Fields that make the report actionable

  • Customer, project, invoice reference and issue date.
  • Contractual due date and reporting date.
  • Invoice value, allocated receipts, agreed credit adjustments and balance.
  • Not-due, 1–30, 31–60, 61–90 and over-90-day buckets.
  • Dispute reason, promised payment date and follow-up owner.

Bucket boundaries are a reporting choice, not a universal rule. State them consistently. Keep disputed amounts visible while explaining the dispute; removing them can make collection risk look artificially low.

Use the report in a collection review

Check the largest overdue balances first, confirm whether the invoice reached the right person and record what evidence is missing. A promised payment date is useful follow-up information, but it does not change the original due date.

Reconcile the total with the underlying receivables records. Review unallocated receipts separately because money received may not yet be matched to the correct invoice. Then compare expected collections with the cash forecast. A dashboard total without the invoice list cannot explain why collections are late.

Related guides

Weekly cash-flow example

Linking bills to projects