Financial Movements Report

The ‘Financial Movement Report’ is your principal method of extracting information from the financial transactions ledger within the Metrix Asset Management system. Using the ‘Financial Movement Report’ will export a summary of your asset component capital value to a single CSV file, and supports the following features:

Info

This data export can be found under the ‘Finance’ section of the Reports Generation page, titled ‘Financial Movement Report’.

Reporting Period Definition

The ‘Financial Movement Report’ is a special, in that it supports reporting dates as a date range - that is, an ‘opening date’ and a ‘closing date’. This allows organisations to specify the period through which they wish to summarise their portfolio’s capital value movements via the financial transactions ledger.

The selected dates are INCLUSIVE - start of the day for the ‘opening date’ and the end of the day for the ‘closing date’. A transaction’s ‘Posting Date’ mandates if it falls inside a selected reporting period.

Transaction Type Specification

The ‘Financial Movement Report’, will include the ‘Opening’ & ‘Closing’ capital valuations (gross and accumulated depreciation value) position for each asset component. For users wanting to understand the financial ‘Movements’ that caused the change in capital value throughout their opening/closing period, the system includes the sum of all postings made to each configured transaction type.

Each transaction type (and transaction type effect) will constitute a report column - the value contained representing the sum of all transactions posted to that specific transaction type throughout the report period.

Users can choose to exclude any transaction types that they know have zero movements throughout the period to simplify the export, however by default, all transaction types are included.

Explicit Financial Re-Categorisation Summary

The ‘Financial Movement Report’ will export a single row per asset component except in the event of a financial re-categorisation occurring within the report period. In these cases, a row to summarise movements for each affected finance category will be exported.

If an asset component has undergone a financial re-categorisation during the selected reporting period (opening/closing dates), then those components will be displayed across two (2) export rows. One row will pertain to the financial movements that occurred whilst the component was assigned to the original finance category, including the financial ‘write-off’ against that category. Then, another row will pertain to the financial movements that occurred whilst the component was assigned to the new finance category, including the financial ‘write-on’ to that category.

Report Category Inclusion/Exclusion Options

This report type has support for report categories (tags). Where supported, users will be presented with an option to include or exclude various report category tags for the data export. If an asset or asset component has been tagged with the respective report category, it will be populated in an additional export column.