Accounting, Accounts Receivable, Bad Debt, CFO, Excel

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.

You must log in to submit a review.