Aged Creditor Report Template for Accounts Payable

Structure of the aged creditor report

The aged creditor report (accounts payable ageing) mirrors the aged debtor report but from the opposite side — it records what your company owes to each supplier, broken down by how far past the agreed payment terms each invoice has aged. Current amounts are those not yet due; subsequent columns show amounts overdue in 30-day increments up to 90+ days.

The report should include each supplier's agreed payment terms, so that an invoice from a supplier on 60-day terms does not appear as overdue when it falls in the 31–60 day column. Without terms data, the report overstates apparent lateness and distorts cash flow planning.

Columns to include in the template

• Supplier name and account reference
• Agreed payment terms
• Current (not yet due under agreed terms)
• 1–30 days overdue
• 31–60 days overdue
• 61–90 days overdue
• 91+ days overdue
• Total outstanding
• On-hold or disputed flag
• Next scheduled payment date

Cash flow planning and lender scrutiny

Lenders reviewing management accounts will compare the trade creditors balance in the balance sheet against the aged creditor total. A large and growing aged creditor balance — particularly with significant amounts in the 60+ day buckets — can indicate cash flow stress and may affect the risk assessment for a facility application.

Stretching creditors is a common short-term cash management technique, but it carries legal risk. Under the Late Payment of Commercial Debts (Interest) Act 1998, suppliers are entitled to claim statutory interest of 8% above base rate on overdue commercial debts, plus fixed compensation charges. For high-value supplier relationships, the reputational and legal cost of persistent late payment may outweigh the short-term cash benefit. Discuss your payment strategy with your accountant or finance director.