Description
Show the auditors that your year-end receivables are real and collectable: for each customer, the balance at 31 December, cash received in January and February that clears it, what is still unpaid and the days outstanding – with a provision flag.
- Automatic summary: Balances tested, Cleared after year-end, % cleared, Still unpaid, Consider provision
- Calculated for you: Total received after YE, Still unpaid, Days outstanding, Status
- Colour-coded status and progress highlights
- Example rows and a step-by-step "How to Use" sheet
Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.
Payment & Security
Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.