Related topics

Report Definition Window

Interpreting Common Report Data

Columns on the Depreciation Expense Report

Depreciation Expense Report

Purpose

The Depreciation Expense report displays depreciation amounts that have been calculated for the selected assets. Along with essential asset data, the report shows figures for previous years' depreciation, current year-to-date depreciation, and total current accumulated depreciation. The system prints a separate Depreciation Expense report for each selected book.

To calculate depreciation, use the Depreciate option on the Depreciation menu.

  • Run this report monthly for any book that is posted monthly (for example, the Internal book).
  • Run the Depreciation Expense report from the Reports menu only after confirming all selected assets have been depreciated through the report date. If not, use the Depreciate command to calculate depreciation at the same time you generate the report to ensure the report accurately reflects depreciation as of the selected date. Select your preferred output: Window and Print can be combined, but Export to Excel can only be run by itself. See the Export to Excel section below.
  • If you calculate depreciation monthly, and you inadvertently skip a month, the amounts in the Depreciation This Run column will be greater than expected. You can view the correct monthly amounts by calculating depreciation for the previous month and then calculating depreciation again for the current month.

Export to Excel

Note: Export to Excel is a subscription feature. See Registration Status to learn more.

The Depreciation Expense report can be exported directly to Excel in a user-friendly format to simplify editing. Select the Export to Excel checkbox at the bottom of the Report Definition dialog to send the report directly to Excel.

Nearly all of the options and settings available when printing a report are also available when exporting to Excel. Below is a list of the differences.

Setup Report tab

Send To: Window and Printer cannot be used with Export to Excel

Configuration: Column wrapping and Asset count are disabled. Subtotal Options is disabled, with Details, subtotals, and totals being selected as the default.

Customize Report: When using Premier Depreciation or if the Sage Fixed Assets – Reporting module is installed, columns can be added to the report without adjusting the page width or the width of existing columns. Since it is an Excel file, the column width and page layout are automatically adjusted.

Tip: Selecting the Extended Asset Description option displays asset information in two rows in Excel, as in a printed report. However, when customizing the report by adding a Description column, all asset information is displayed on a single row.

Format Report tab

Report Orientation: This option is disabled since it is not needed in Excel.

Sort Options > Override Sort Specified in Group: Field and Order are available as sort options, but Subtotals and Page Break are disabled.