Depreciation Expense Report: Report Columns

The Depreciation Expense report columns first identify the asset, then provide depreciable basis and depreciation expense figures. The column guidelines provided below apply to all books.

These standard columns appear in the Depreciation Expense report and need no explanation:

System Number

Extension

Property Type (PT)

[Placed] In-Service Date

Depreciation Method

Estimated Life (shown in years and months)

Acquired Value

Key Code

The following guidelines provide detail on the nonstandard columns that appear on the Depreciation Expense report.

Prior Through

This date is the previous through date (that is, the date of the next-to-last depreciation calculation). For example, if you calculated depreciation through 01/31/07 and then calculated depreciation through 02/28/07, the system displays 01/31/07 in the Prior Through column.

Prior Accumulated Depreciation

Prior accumulated depreciation includes all depreciation expense from the asset's placed-in-service date through the end of the fiscal year before depreciation was last calculated. For example, if depreciation was last calculated through 03/07, prior accumulated depreciation includes all depreciation expense from the asset's placed-in-service date through December 2006 (assuming a calendar year-end organization), including any beginning depreciation amounts.

Depreciation This Run

Depreciation this run is the amount that was calculated for the period between the next-to-last depreciation calculation (the Prior Through date) and the last depreciation calculation (the current through date). For example, if you calculated depreciation through 01/07 and then calculated depreciation through 03/07, the Depreciation This Run column includes depreciation for February and March 2007.

Current Year to Date Depreciation

Current year-to-date depreciation includes all depreciation expense from the beginning of the fiscal year containing the current through date up to and including the current through date. (The current through date is the last date through which you calculated depreciation.) For example, if the current through date is 03/07, the current year-to-date depreciation includes depreciation for January, February, and March 2007 (for a calendar year-end organization).

Current Accumulated Depreciation

Current accumulated depreciation includes all depreciation expense from the asset's placed-in-service date up to and including the current through date. (The current through date is the last date through which you calculated depreciation.) Current Accumulated depreciation equals the amount in the Prior Accumulated Depreciation column plus the amount in the Current Year-to-Date Depreciation column.

Percent Allocated

This column shows how the percentage of the asset’s cost and depreciation expense has been allocated.

Tip: To show the allocation of an asset’s cost among the G/L Asset Account numbers, you must run the report for a group that is sorted by the G/L Asset Account field. Alternatively, to show the allocation of an asset’s depreciation among the G/L Expense Account numbers, you must run the report for a group that is sorted by the G/L Expense Account field.