Indexation Export

The ‘Indexation Export’ is a helper utility report that generates a valid Transaction Import Template with pre-populated indexation transaction types based on supplied metrics. Using the ‘Indexation Export’ will generate a CSV file that conforms with the import requirements of the financial ledger transactions import process within the Metrix Asset Management system, including the following columns:

  • Component ID,

  • Posting Date,

  • Finance Category ID, and

  • Column headers and transaction values for the indexation-gross and indexation-accumulated depreciation transactions.

The ‘Indexation Export’ requires the following information. Each is discussed below.

Warning

Merely exporting the report will NOT post the indexation transactions to the financial transactions ledger. Users must follow the appropriate import steps, with the generated file, to recognise these movements within the system.

‘Indexation At’ Date

This is the date at which you wish to calculate the indexation from. The chosen date value controls:

  • ‘When’ components are considered to be linked to Finance Categories.
  • ‘When’ to calculate each components capital value (gross and accumulated depreciation) at.

Finance Categories

This is the array of finance categories for which you wish to calculate and export indexation movements for. Any component linked to one of the included finance categories at the supplied ‘Indexation At’ date value, will be included in the export results.

Indexation Rate

This is the desired rate of indexation (supplied as a percentage) to be applied across the selected Finance Categories. Once supplied, the system will perform the following calculations:

Indexation (Gross)

$$ [Component Gross Value] \times ( [Indexation Rate] \div 100 ) $$

Indexation (Accumulated Depreciation)

$$ [Component Accumulated Depreciation Value] \times ( [Indexation Rate] \div 100 ) $$

The above gross and accumulated depreciation values are calculated as at the supplied ‘Indexation At’ date value. The indexation rate is divided by 100 to convert it to its decimal implication.

Posting Date

This is the date that will be pre-populated into the posting_date column of the exported template. If the generated report is used to import the indexation transactions, this will be the ‘Posting Date’ for the resulting financial transaction ledger entries.