Click main image to view in full screen.
Bad Debt Provision Calc Template – Excel XLSX
Excel (XLSX)
BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT
- Bad Debt Calc
- Liability
- Contingency
DEBT EXCEL DESCRIPTION
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
ABOUT THE AUTHOR
Finance Leader
Over 15 years Experience
Qualified Finance Professional
Ask the Author a Question
You must be logged in to contact the author.
