The report provides a view of the currency translation process in your system by capturing the source accounts in local currency, translation rates, and the translated amount in the reporting currency
Prerequisites
This information is only available if the Consolidation procedure was run with the Audit parameter set to TRUE.
The system requires these member tags for the report:
| Dimension | Element | Tag |
| Account | Cash Flow | #CashFlow |
| Account | Net Income | #NetIncome |
| Account | Balance Sheet | #BalanceSheet |
| Currency | All Currency | #AllCurrency |
| Entity | Total Group (Main entity structure) | #TotalGroup |
| Scenario | All Scenarios | #AllScenarios |
| Scenario | Actual | #Actual |
Note: Member tagging is done within the Anaplan Financial Consolidation Model Manager.
Access the report
To access the report:
- Select the Explorer module.
- Expand the Global > Consolidation > Reports > Web Reports folders.
- Right-click the Audit – Conversion report and select Open. Alternatively, double-click the report to open it.
Note: Your administrator may have moved the report to another location, or it may be started as part of a process.
Parameters
The key parameters of the report are:
| Variable Name | Value |
| Entity | Select an Entity member. |
| Currency | Select the required currency. |
| Account | Select an Account member. |
| Movement | Select a Movement member. |
| Period | Select a Period member. |
| Scenario | It defaults to the Scenario tagged as #Actual. |
View the report
Once you have selected the parameters, the report displays:
| Dimension | Member(s) |
| Account | An drillable view of the account selected. Expand the accounts to view the different ways the values are translating depending on Conversion Rule and Property settings. |
| Movement | The Movement set for the conversion rule. |
| Audit | The Audit member where the data is located. |
| Intercompany | The Intercompany member where the data is located. |
| Local Currency | The local currency of the Entity selected. |
| Value | The value being converted. |
| Formula | The formula used for the conversion. |
| Formula Value | The resultant value derived from the formula. For example, if it's [Average] * - 1 and the average rate is 1.138000696, the formula value will be -1.138000696. |
| Converted Value | Value * Formula Value. |
| Conversion Rule | The Conversion Rule set for the account. |
| Reporting Currency | The Currency parameter selected when running the report. |
