Description
Calculate an expected credit loss provision on receivables using loss rates by ageing bucket, add specific provisions for known problem customers and get the adjustment to book.
- Automatic summary: Total receivables, General (ECL) provision, Specific provisions, Total provision required, Coverage %, Adjustment to book (+ charge / − release)
- Calculated for you: Total balance, ECL provision, Total provision, Net receivable
- 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.