The purpose of this template is to compute the adjustment for vacation and bonus accruals and other accruals for which the recurring item exception election has been made.
Entering Information
All of the information needed to produce the calculations is entered on the Input worksheet in the input table. The yellow highlighted cells are calculated fields, and no data should be entered in these cells. Gray cells are not calculated fields, but data should not be entered in these cells.
Additional lines can be inserted into the tables, as needed. To add lines, click the asterisk (*) in the left column.
Enter the following information for each type of expense listed:
Account number (optional)
Ending book balance
Amount paid within required time period
The following expenses are listed:
Advertising
Benefits
Bonuses
Charitable contributions
Commissions
Deferred compensation
Directors' fees
Discounts
Fees
Insurance
Interest
Payroll
Payroll taxes
Severance
Vacation
Workman's compensation
Others (list) – (Insert additional lines as needed.)
Inventory Reserves and Real Property Taxes
Special rules apply to inventory reserves and real property taxes.