This input form enables you to capture the Acquisition Balance Sheet information of a newly acquired subsidiary.
The currency you can use depends on the local currency of the company you choose in the Investment Registry. Additionally, if the local currency of the subsidiary differs from the main reporting currency in your system, the main reporting currency will also be visible. This currency automatically converts at the rate entered into the Investment Registry.
The Acquisition Balance Sheet is stored in the Value Dataview and the Business Acquisition Movement member.
Prerequisites
The system requires these member tags for the input form to work.
| Dimension | Element | Tag |
| Account | Balance Sheet | #BalanceSheet |
| Currency | Main Reporting Currency | #MainReportingCurrency |
| DataView | Value | #Value |
| Entity | Total_Group (your main root entity structure) | #TotalGroup |
| Intercompany | No Intercompany | #NoIntercompany |
| Measure | Amount | #Amount |
| Movement | Business Acquisition | #Business Acquisition |
| Scenario | Actual | #Actual |
Note: Member tagging is done within the Anaplan Financial Consolidation Model Manager.
The system also requires Global Variables for the input form.
| Variable Name | Value |
| CurrentPeriod | <Name of the Current Period>, for example: 2021 P3. |
You must ensure that Audit members are set as the p_Audit property in the entity dimension. Data input into the Balance Sheet Continuity Schedule is input to the Audit member set on the selected Entity parameter.
Access the input form
You can access the Acquisition Balance Sheet – Investment Registry input form through a link in the Investment Registry.
You can't access this form directly as it requires information from the Investment Registry, such as Acquisition Date and Rate.
To use the standard version of the Acquisition Balance Sheet, refer to the input form here.
Use the input form
Once you open the input form, it displays:
- Rows display the account tagged as #BalanceSheet.
- Columns display the subsidiary's local currency and the main reporting currency. Main reporting currency column is displayed if the local currency of the subsidiary and the main reporting currency are the same.
If the local currency of the subsidiary and the main reporting currency aren't the same, the local currency of the subsidiary will be available for input, and the main reporting currency will automatically be calculated based on the rate entered into the Investment Registry.
Both the reporting currency and the selected Entity's local currency are displayed. If the selected period and scenario combination isn't open, the input form will be locked.
Data input into the form is submitted in this format:
| Dimension | Member |
| Account | It's the member under #BalanceSheet. |
| Audit | It's the Audit member set as the Audit property of the Entity, p_Audit. |
| Currency | It's the local currency of the subsidiary as well as the main reporting currency if it's different than the subsidiary's local currency. |
| DataView | It's the member tagged as #Value. |
| Date | It's the Date parameter entered into the Investment Registry.. |
| Entity | It's the subsidiary member in the Investment Registry. |
| Intercompany | It's the member tagged as #NoIntercompany. |
| Measure | It's the member tagged as #Amount. |
| Movement | It's the member tagged as #Business Acquisition. |
| Scenario | It's the Scenario parameter selected in the Investment Registry. |
| Extra Dimensions | It's any extra dimensions, such as, Product, CostCenter are set to the default input member of the dimension. |
