AR/AP Ageing Template
A full Receivables Ageing and a full Payables Ageing sheet, each with 4-bucket ageing, DSO/DPO, and a combined Summary sheet.
No sign-up or email required. Real Excel formulas, not a screenshot.
What this template does
- ✓Buckets every open invoice and bill into 0-30 / 31-60 / 61-90 / 90+ days overdue.
- ✓Calculates DSO (Days Sales Outstanding) on the receivables side and DPO (Days Payable Outstanding) on the payables side.
- ✓Rolls both up into one Summary showing the DSO-minus-DPO gap — the number of days cash is tied up in receivables beyond the credit taken from suppliers.
What’s inside
Receivables Ageing
4-bucket ageing (0-30 / 31-60 / 61-90 / 90+) and DSO, built from sample open invoices.
Payables Ageing
The same 4-bucket ageing structure and DPO, built from sample open bills.
Summary
Both totals and turnover figures side by side via live cross-sheet references, plus the DSO-minus-DPO working-capital gap.
Read Me
The workbook's own documentation and a link back to the full guide.
How to use it
Replace the sample invoices and bills with your own open items. Every ageing bucket, DSO, DPO and the Summary sheet recalculate automatically.
Want the full walkthrough?
The guide explains every formula in this workbook step by step, with a worked example.
Go deeper
Advanced Excel for Finance & Business
This template is one piece of a bigger workflow. The course builds the whole thing with real datasets, step by step, with a graded assessment and a verifiable certificate.