|All Industries, Financial Model|
|Accounting, Accounts Receivable, Bad Debt, CFO, Excel, General Ledger|
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.