Cost & Depreciation Movements Report

This report prints detailed information about the asset cost and depreciation expenses up to the current period end. The report can display either tax or accounting values.

Header Details

Report process date and time
Page number
Current period end date
Sort order

Asset Details

This information displays for each asset (grouped using the selected profile):

Note: This is based on the Print by Summary option not being selected. The report prints displays the cost values on one line and depreciation values on a second line.

Asset Code and Subcode
Date of last purchase
Date of last disposal
Opening cost
Current period purchases
Current period disposals
Current period revaluations
Current period adjustments
Current period transfers
Current period write-offs
Closing cost
Asset description
Depreciation Code (based on report period and depreciation Effective Date
Accumulated depreciation
Current period depreciation
Current period depreciation on disposal
Current period depreciation on revaluation
Current period depreciation on adjustment
Current period depreciation on transfer
Current period depreciation on write-offs
Closing depreciation
Closing Book Value

You can select several profiles before running the report to determine the sort order of the output:

Sort by Analysis Group
Sort by Asset Code
Sort by Location
Sort by Profit Centre
Sort by Trees

Sub-totals display using the selected profile and a grand total displays at the end of the report. If the option to Print by Summary is selected, only totals print on the report.

Parameters

You can set these parameters for the report:

Asset Code From

Enter the first asset code in the range of asset codes to include in the report.

Asset Code To

Enter the last asset code in the range of asset codes to include in the report.

Leave the Asset Code From field empty and enter zzzzzzzzzzzz in this field to include all asset codes in the report.

Profit Centre From

Enter the code or name of the first profit centre in the range of profit centres to include in the report.

Profit Centre To

Enter the code or name of the last profit centre in the range of profit centres to include in the report.

Leave the Profit Centre From field empty and enter zzzzzzzzzzzz in this field to include all profit centres in the report.

Analysis Group From

Enter the code of the first analysis group assigned to assets to include in the report.

Analysis Group To

Enter the code of the last analysis group assigned to assets to include in the report.

Leave the Analysis Group From field empty and enter zzzzzz in this field to include all analysis groups in the report.

Location From

Enter the first location in the range of locations to include in the report.

Location To

Enter the last location in the range of locations that you want to include in the report.

Leave the Location From field empty and enter zzzzzz in this field to include all locations in the report.

Exclude Zero Value Rows

Select this option exclude assets that have no opening or current year values, for example assets that were disposed or written off in prior years.

Exclude Prior 0 CBV

Select this option exclude assets whose book value was reduced to zero in a prior year, for example assets that were disposed, written-off, or fully depreciated in prior years.

Print by Summary

Select this option include only a summary of costs and depreciations in the report

Period End Date

Enter the last day of the period for which to generate the report.

Print Taxation

Select this option to include tax values in the report.

Custom Heading

Enter text in this field that prints under the report header.

Note: Unless this level of detailed breakdown is required, use the Balances tab on the Fixed Asset View form to reconcile your Closing Code and Accumulated Depreciation to the corresponding general ledger accounts.