AP Ageing Schedule template
Accounts payable ageing with Not due, 0-30, 31-60, 61-90 and over 90 day buckets. Paste vendor invoices and the ageing, bucket split and totals calculate automatically.
Available in the ZAF Template Library: search, click Insert, and the schedule lands in your workbook with live formulas.
- Paste open vendor invoices
- Days overdue computed from the due date
- Bucket split and totals
- Stretched-payables check before setting the NWC peg
Why it matters in due diligence
The accounts payable ageing schedule schedule is one of the analyses a buyer, lender or investment committee expects in a financial due diligence report. Built by hand, it means recreating the same layout, formulas and checks on every engagement. The ZAF version is formula-driven, so every number traces to an input cell and the checks tell you when something does not tie.
Build it from your trial balance instead
Inside ZAF Tools, Import and Map TB, AI Map and Build FS create the statements this schedule draws on. Run Full FDD then produces statements, commentary and management questions in one pass. See how Working capital & net debt works, or calculate the hours saved.
Comparing tools? See ZAF Tools vs cloud QoE platforms.
More from the template library
Insert this template from the ZAF ribbon
Book a 30-minute live demo on your own trial balance, or request a trial for your team.