Bad Debt Reserve Calculator

Bad Debt Reserve Calculator

Can be used in any industry. This spreadsheet should be updated monthly by your accounting staff.

Using the balances from your accounts receivable (current, over 30, over 60, etc. ) and applying a reserve percentage, the sheet will calculate how much you should have set aside. As well there is a section for specific reserve, for clients who you may want to reserve a larger amount.

Simple to use, but takes the hassle out of understanding how to calculate the monthly reserve amount.


Industry ,
Summary Spreadsheet to calculate general accounts receivable reserve based on a percentage as well as adding in specific reserves for clients. Should be updated monthly to determine if you have enough AR reserve on the books.
Screenshots / Pictures Bad Debt Reserve Analysis
Use Cases , , , , , ,

You must log in to submit a review.