Depreciation and Sale of Assets

This template is designed to produce a summary report to tie out book and tax depreciation information.  It is not designed to calculate detailed depreciation expense.  A schedule of assets disposed of during the year can also be generated to facilitate the reconciliation of the net assets per book and net assets per tax.

Entering Information

All of the information needed to generate a depreciation reconciliation is entered on the Input worksheet. 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.
Enter the information as indicated in the input tables.  Additional lines for other categories can be inserted if needed, by clicking the asterisk (*).
On the second worksheet “Input Sale of Assets," enter the information needed to generate a schedule of assets sold.
The box in the upper-left corner of the worksheet displays the asset categories shown on the Input sheet.  There are also four other categories in the box.  If you add additional categories on the first Input worksheet, you should rename these other categories to provide a complete list to use in the sale of assets schedule.
Depreciation and Sale of Assets