Account Mapping

Purpose

Account Mapping Rules are defined to map/copy from a source dataset, single account or group of accounts to another dataset, considering the combination of movement and dataset.

Account Mapping allows to map a group of accounts to another account or the same as source account but also allows the user to slice a more detailed chunk of the data definition to its dataset and the transaction movement.

Scenarios using this rule type are Building Indirect cash flow by mapping BS & PL to Cashflow

Prerequisites

Account mapping requires defined Dataset, Account, and Flow type fields that are based on the tagged Model used for this calculation.

Account mapping rules Read and aggregate values for specific Dataset, Account, and Flow, in the INPUT section and post the aggregated data to Output dataset, Account, and Flow in the OUTPUT.

Source data for fields other than Dataset, Account, and Flow are identified from Rule Header Filters.

Source data for Time and Version have a special application:

1. Input data can also be fetched from a different Time period than one passed on Rule filters by using the offset function.

2. Input version can be different from the Rule filters by using Lookup or Presetting specific member.

3. Other fields can be filtered with Applicable to, under Update list option.

4. Output data for dimensions other than Dataset, Account, and Flow are identified from Calculation Filters Post to, under Update list window.

5. Calculation filters are either passed as "Fixed Values" or "Context member" or a combination.