Bad Debt Provision Calculator – Excel Template

Calculate a bad-debt provision from your receivables aging using a rate for each age band, with per-customer overrides.

• Automatic summary: Total receivables, Total provision, Provision as % of receivables, Net receivables
• Calculated for you: Total owed, Calculated provision, Final provision, Provision %
• 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.