AR Ageing Schedule template
Accounts receivable ageing with Not due, 0-30, 31-60, 61-90 and over 90 day buckets. Paste customer 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 customer invoices
- Days overdue computed from the due date
- Bucket split and totals
- Provisioning discussion for balances over 90 days
Why it matters in due diligence
The accounts receivable 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.