This template form enables you to adjust the calculated cash flow. These adjustments or reclassifications might be for presentation purposes or for non-cash items. Anaplan Financial Consolidation has two standard cash flow adjustment audit members, but you can add as many as you need.
Prerequisites
The system requires these member tags for the Cash Flow Adjustment input form:
| Dimension | Element | Tag |
| Account | Cash Flow | #CashFlow |
| Audit | Management Reporting | #ManagementReporting |
| Audit | Cash Flow Adjustments | #CashFlowAdjustments |
| DataView | All Dataviews (main root) | #AllDataViews |
| DataView | Value | #Value |
| Entity | Total Group (main root) | #TotalGroup |
| Intercompany | No Intercompany | #NoIntercompany |
| Intercompany | Total Group (main root) | #TotalGroup |
| Measure | Amount | #Amount |
| Movement | Closing | #Closing |
| 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: 2026 P3. |
| ValidationType_CFAdj | This can be set to:
|
Access the input form
To access the Cash Flow Adjustment input form:
- Select the Explorer module.
- Expand the Global > Consolidation > Input.
- Right-click the Cash Flow Adjustment form and select Open. Alternatively, double-click the form to open it.
Note: Your administrator may have moved the form to another location, or it may be started as part of a process.
Parameters
The key parameters of the input form are:
| Variable Name | Value |
| Entity | Select the name of the entity for the report. |
| Currency | Select the currency. |
| Period | It defaults to the value set in the global variable CurrentPeriod. |
| Scenario | It defaults to the scenario tagged as #Actual. |
Use the input form
Once you have selected the parameters, the input form displays:
- Rows display the accounts tagged as #CashFlow.
- Columns display Audit members. The Audit members displayed are:
- Immediate child members under the element tagged as #ManagementReporting. These are protected.
- Members under the element tagged as #CashFlowAdjustments.
- The #ManagementReporting parent.
- The first row under the #CashFlowAdjustments members should show a validation that the total CashFlow = 0. If it isn't, it displays that value in red.
Depending on the value of the ValidationType_CFAdj global variable, if set to:
- Error: It displays the error when trying to submit if the cash flow isn't 0 for any adjustments.
- Warning: Only a warning message is provided and the data will be submitted.
Note: If the Period and Scenario combination selected isn't open, the input form will be locked.
Read-only data in the form will be pulled from the intersection below:
| Dimension | Member |
| Account | The Aaccount defined in the row. |
| Audit | The audit member defined in the column. |
| Currency | The currency parameter selected. |
| DataView | The member tagged as #AllDataViews. |
| Date | The date parameter selected. |
| Entity | The entity parameter selected. |
| Intercompany | The member tagged as #TotalGroup. |
| Measure | The member tagged as #Amount. |
| Movement | The member tagged as #Closing |
| Scenario | The scenario parameter selected. |
| Extra Dimensions | Any extra dimensions, such as product or cost center are set to the default input member of the dimension. |
Data input into the form is submitted to the intersection below.
| Dimension | Member |
| Account | The account defined in the row. |
| Audit | The audit member in the column |
| Currency | The currency parameter selected |
| DataView | The member tagged as #Value. |
| Date | The date parameter selected. |
| Entity | The entity parameter selected. |
| Intercompany | The member tagged as #NoIntercompany. |
| Measure | The member tagged as #Amount. |
| Movement | The member tagged as #Closing |
| Scenario | The scenario parameter selected. |
| Extra Dimensions | Any extra dimensions, such as product or cost center are set to the default input member of the dimension. |
In an input form, if cells are:
- White: These cells are protected and can't be edited.
- Pale Yellow: These cells are editable. The movement classification allows input for that account.
- Dark Yellow: The movement classification requires intercompany input for that account.
Dropdown lists in an input template that are selectable are white with blue text.