The System Management module is only available to users who have responsibility for maintaining master data for “slow moving dimensions”. For example Investment Vehicle or Investor.
Within System Management you can always access the this only documentation, by clicking on “Handbook”
System settings
System settings such as the first quarter of capital account data, snapshot facility start and reporting currency are set during implementation and should never be changed in a running system.
The default value for the projection period is 10 years. This is possible to change but should be done in consultation with your Apliqo support partner.
The main parameters which need to be updated on a quarterly basis are the current (last) quarter for which actual data is available for both fund level and asset level. These parameters are manual rather then being calendar based due to the variability of GP publishing schedules. In general the current last quarter parameter should be updated after all reports are finalised and the final snapshot has been run for a given reporting quarter. At this point the final quarter should be “rolled over” to the next quarter (otherwise data for the new quarter will be ignored by the model).
Snapshots
Using the Snapshot function copies all current data in the application to a timestamped read-only version. By switching the snapshot version in any report with this facility the user can “rewind” the portfolio to see values as they were for any previous reporting period.
Clicking the “Take Snapshot” button will launch a background process which takes approximately 1 hour to complete. In the meantime you can continue working. However, until the snapshot process has finished it is important that you do not change any of the system settings or run any version/scenario create or restore as this would result in a faulty or corrupted snapshot.
Dimension maintenance
The main dimension or masterdata maintenance activity is the creation of new investments and asset level information which is handled during the quarterly data updates. However, there are some other critical masterdata which may be updated infrequently (or possibly not at all). This module gives you the ability to self-administer such changes.
Currency
The currency maintenance gives you the ability to add additional currencies to the model or to change the reporting currency. A precondition of adding a currency to the model is that the currency must be the local reporting currency of at least one fund/investment.
??? BFO data => needs to be replaced
The reporting currency is selected by default in all reports and all KPI calculations and analysis rollups are based on reporting currency.
Although it is possible to change the reporting currency from EUR to USD in practice this would never be performed on a running model as reporting currency is a key up front decision during implementation. Note that updating the reporting currency from this screen will also update the value in the system settings screen.
Investor
The investor maintenance screen gives you the ability to add (or remove) investors.
??? => GFX not available on Demo, need to be done
An investor must be created before any investment shareholding can be entered. Deleting an investor will also delete all data belonging to the investor, including in saved snapshots. This function should only be used to remove investors that were added in error.
Investment vehicle
The investment vehicle/entity type maintenance screen gives you the ability to add (or remove) investment vehicles.
Deleting an investment vehicle will also delete all data belonging to the vehicle, including in saved snapshots. This function should only be used to remove types that were added in error.
Scenarios
Scenarios are a special type of version which allow assumptions in the model to be played with to see the impact on valuation and cashflows.
All changes in the model are always performed on the Current version. However, using the scenario functionality allows the user to first back up current assumptions and masterdata and then restore the current assumptions after scenario analysis. Likewise it is possible to prepare different sets of assumptions as a named scenario and replace the current version with the selected scenario and see the impact on the portfolio.
Important
Before a new scenario is created, best save the current state of the data as a “base line” the user can always revert to and maintain all the changes since the last snapshot.
FX data and currency rates
These screens allow the user to load currency rates from online financial market data hubs. Historic rates are updated automatically on a monthly cycle. However, should you want to update rates manually this facility is also available on demand.
Region & Sector Spit
Region and sector split can be managed fund by fund in the fund setup and quarterly data input sections. This screen provides an interface to be able to update splits for all investments in one location.
For any fund with asset level data the region and sector splits are always calculated from the asset level data.
Shareholding
This screen provides an interface to be able to view and update the shareholding matrix for all investments in one location.
Projections
projection assumptions
Projection Assumptions can be managed fund by fund in the fund setup and quarterly data input sections. This screen provides an interface to be able to update projection assumptions for all investments in one location.
Statistical tables
This report provides a read only view of the distillation of the Preqin dataset into statistical tables by performance quartile which is used in the cashflow projection model.
Measure descriptions
This interface allows to maintain their own display captions for reporting accounts and KPIs in multiple display languages.
