Accruals – Tax Basis

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.