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||All Industries, Financial Model|
|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|
|Use Cases||Accounting, Accounts Receivable, Bad Debt, CFO, Excel, General Ledger, Month End|
You must log in to submit a review.