Understanding the movement report

Each record in the ASSVALMOVEMENT table stores movement data for a single asset valuation over a single accounting period. When movement data is calculated, a record is inserted for each accounting period in which depreciation occurred.

The Asset Movement report shows movement data for one or more selected valuations. For each asset, the report shows details for each accounting period for which movement data has been calculated. This table describes each column in the Asset Movement report, and how the values are calculated.

Column Description
Effective Date

EFFECTIVEDTTM

Effective date for the movement calculation. The effective date is set to the start date of the accounting period that is being processed.
Current Cost Period Start

CURRENTCOSTPS

The Current Cost Period Start column contains the value of the Current Cost Period End column from the previous period's movement record. In the first movement record for an asset valuation, the value will be zero.
Initial Cost

INITCOSTCP

For the first movement record created for an asset valuation, the Initial Cost column is set to the initial cost of the asset, as specified in the AssetValuation.InitialCost column for the valuation record. This ensures that a value exists for assets with an acquisition date before the first accounting period.
Capitalized Cost

CAPTCOSTCP

Total cost of all work orders completed within the current accounting period. The work orders must be closed and have an asset valuation type of CAPITA (capital expenditure).

The work order completion date (History.CompletedDateTime) is used to determine if a work order falls within the current period. All costs associated with the work order are included, even if the charge date is outside the accounting period.

Disposals

DISPOSALSCD

If an asset's disposal date (AssetValuation.DisposalDate) falls within the current accounting period, the Disposals column contains the value from this calculation:
WrittenDownValuePeriodStart +
AccumulatedDepreciationPeriodStart
Improved Value Prior to Revaluations

IMPVALPRIORTOREVALPE

The Improved Value Prior to Revaluations column contains the result of this calculation:
(CurrentCostPeriodStart + 
InitialCostCurrentPeriod +
CapitalisedCostCurrentPeriod) - 
DisposalsCurrentPeriod
Revaluation Accumulated Depreciation Written Back (Net)

REVALACCUMDEPRECWRTNBCKNETCP

Accumulated depreciation from the asset's acquisition date through the date of the last Net revaluation that occurred in the current accounting period.
Revaluation Increment/Decrement

REVALINCDEC

The value for this column is calculated using the last revaluation that occurred within the accounting period being processed. The calculation used depends on the revaluation method.
  • Net revaluation:
    (Revaluation.MarketValue - 
    ImprovedValuePriorToRevalPeriodEnd) 
    + RevalAccumDeprecWrittenBackNetCurrentPeriod
  • Gross revaluation:
    (Revaluation.MarketValue - 
    ImprovedValuePriorToRevalPeriodEnd) 
    + RevaluationAccumulatedDepreciationBroughtToAccount
Current Cost Period End

CURRENTCOSTPE

The Current Cost Period End column contains the value from this calculation:
ImprovedValuePriorToRevalPeriodEnd -
RevalAccumDeprecWrittenBackNetCurrentPeriod +
RevalIncrementDecrementCurrentPeriod
Accumulated Depreciation Period Start

ACCUMDEPRECPS

Accumulated depreciation from the asset's acquisition date through the start date of the current accounting period. The calculation of this value follows these steps:
  1. Get all depreciations from the ValuationDepreciation table where the CalculatedThroughDate is greater than or equal to the asset's acquisition date, and less than or equal to the start date of the current accounting period.
  2. Get all revaluations from the Revaluation table where the ValuedDateTime is greater than or equal to the asset's acquisition date, and less than or equal to the start date of the current accounting period.
  3. Combine the depreciation and revaluation records from steps 1 and 2 into a list and sort them based on the CalculatedThroughDate and ValuatedDateTime columns.
  4. Process each item in the combined list.

    If the item is a depreciation, its value is added to a running total called CalculatedDepreciationAmount.

    If the item is a revaluation, the CalculatedDepreciationAmount is reset. The value used depends on the revaluation method.

    • For Gross revaluations, the value is calculated by subtracting the market value (Revaluation.MarketValue) from the replacement cost (Revaluation.ReplacementCost).
    • For Net revaluations, the value is set to zero.

    After all items in the list are processed, the Accumulated Depreciation Period Start is set to the CalculatedDepreciationAmount.

Depreciation Current Period

DEPRECCP

Total depreciation calculated for the current accounting period. The calculation sums the calculated depreciation (ValuationDepreciation.CalculatedDepreciationAmount) for all depreciations that fall within the accounting period.
Disposals Depreciation Written Back Current Period

DISPDEPRECWRTNBCKCP

If an asset's disposal date (AssetValuation.DisposalDate) falls within the current accounting period, this column shows the sum of the calculated depreciation amounts for all depreciations between the acquisition date and the disposal date.
Revaluation Accumulated Depreciation Written Back

REVALACCUMDEPRECWRTNBCKGROSSCP

Accumulated depreciation from the asset's acquisition date through the date of the last revaluation, either Gross or Net, that occurred in the current accounting period.
Revaluation Accumulated Depreciation Brought to Account

REVALACCUMDEPRECBGHTTOACCTCP

The Revaluation Accumulated Depreciation Brought to Account is calculated for Gross revaluations that fall within the current accounting period. This column contains the difference between the asset's replacement cost (Revaluation.ReplacementCost) and its market value (Revaluation.MarketValue).
Accumulated Depreciation Period End

ACCUMDEPRECPE

Accumulated depreciation from the asset's acquisition date through the end date of the current accounting period. The calculation of this value follows these steps:
  1. Get all depreciations from the ValuationDepreciation table where the CalculatedThroughDate is greater than or equal to the asset's acquisition date, and less than or equal to the end date of the current accounting period.
  2. Get all revaluations from the Revaluation table where the ValuedDateTime is greater than or equal to the asset's acquisition date, and less than or equal to the end date of the current accounting period.
  3. Combine the depreciation and revaluation records from steps 1 and 2 into a list and sort them based on the CalculatedThroughDate and ValuatedDateTime columns.
  4. Process each item in the combined list.

    If the item is a depreciation, its value is added to a running total called CalculatedDepreciationAmount.

    If the item is a revaluation, the CalculatedDepreciationAmount is reset. The value used depends on the revaluation method.

    • For Gross revaluations, the value is calculated by subtracting the market value (Revaluation.MarketValue) from the replacement cost (Revaluation.ReplacementCost).
    • For Net revaluations, the value is set to zero.

    After all items in the list are processed, the Accumulated Depreciation Period End is set to the CalculatedDepreciationAmount.

WDV Period Start

WDVPS

Written down value from the last valuation history record prior to the start of the current accounting period. If no written down value has been calculated, then this column will contain the asset's initial cost.
WDV Period End

WDVPE

Last calculated written down value (WDV) that falls within the current accounting period. If a WDV has not been calculated within the period, then this column contains the same value as the WDV Period Start column.
Proceeds on Disposal

PROCONDISPCP

If an asset's disposal date (AssetValuation.DisposalDate) falls within the current accounting period, the Proceeds on Disposal column contains the asset's disposal value (AssetValuation.DisposalValue).
Profit/Loss on Sale

PLONSALECP

If an asset's disposal date (AssetValuation.DisposalDate) falls within the current accounting period, the Profit/Loss on Sale column contains the profit or loss (AssetValuation.ProfitLoss) from the disposal.