What is bad debt provision? This is a provision to cater for future potential liability occuring by some of your companies debt resulting in not being paid for and therefore incurring a loss
Why provide for bad debts? It is prudent to make a provision for any doubtful debts upon assessment of the likelihood of that debt not being paid. This will ensure that the future potential loss is already covered in the books and will not result in an expense in the future months or years.
It is very important and part of the IAS and IFRS standards to make a provision for bad / doubtful debts.
This template will allow you to effectively control and compute the debts in your Accounts Receivable aging and consider making a provision for bad/doubtful debts to ensure capturing the potential future liability in your books.
The template can be used on a monthly basis to review and revise your provision and always have the potential liability covered in the books.
It will help you assess debts in all aging categories for you to assess and determine whether a provision needs to be made for any of these debts
Simple and easy to use yet highly effective!
What is bad debt provision? This is a provision to cater for future potential liability occuring by some of your companies debt resulting in not being paid for and therefore incurring a loss
Why provide for bad debts? It is prudent to make a provision for any doubtful debts upon assessment of the likelihood of that debt not being paid. This will ensure that the future potential loss is already covered in the books and will not result in an expense in the future months or years
It is very important and part of the IAS and IFRS standards to make a provision for bad / doubtful debts.
This template will allow you to effectively control and compute the debts in your Accounts Receivable aging and consider making a provision for bad/doubtful debts to ensure capturing the potential future liability in your books.
The template can be used on a monthly basis to review and revise your provision and always have the potential liability covered in the books.
It will help you assess debts in all aging categories for you to assess and determine whether a provision needs to be made for any of these debts
Simple and easy to use yet highly effective!
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Debt Excel: Bad Debt Provision Calc Template Excel (XLSX) Spreadsheet, Excel Templates & Dashboards
This document is available as part of the following discounted bundle(s):
Save %!
Accounts Receivable Bundle
This bundle contains 2 total documents. See all the documents to the right.
Debt Loans Integrated Financial Model IPO Investment Banking Accounts Receivable
![]() |
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |