This report displays the Cash Flow account hierarchy in the rows and the Balance Sheet accounts in the columns. This enables you to view the balance sheet accounts that make up the cash flow accounts in a matrix. You can also expand the cash flow accounts in the rows to view the source movement for all calculated cash flow accounts in the report.
At the top of the Cash Flow Reconciliation report, there's a report that pulls in the Balance Sheet data for specific movements. You can view the difference between these amounts and the values in your cash flow. You can also set a tolerance, which decides if the difference will be shown in red, outside the input tolerance amount, or in green, inside the input tolerance amount.
Cash Validation section displays the value in the cash account in the balance sheet compared with the Cash at the end of the period in the Cash Flow.
You can also view data from your Balance Sheet for the Opening, Variation, Closing, and CTA movements. The Calculated Value is the total of the Cash Flow accounts for the Balance sheet account in the column. The difference is the difference between the variation (minus CTA) and the total of the Cash Flow accounts.
Note: This report is currently a starter kit. Some adjustments will need to be made for it to work in your environment. Those adjustments will be detailed in this article.
Prerequisites
The system requires these member tags for the report:
| Dimension | Element | SysName |
| Account | Balance Sheet | BalanceSheet |
You can set the SysName in the Attribute Maintenance administration form or from within MetaData Manager.
Access the report
The Cash Flow Reconciliation report is a starter kit. Contact Anaplan Financial Consolidation support team for a copy.
Parameters
The key parameters of the report are:
| Variable Name | Value |
| Entity | Select an Entity member. |
| Scenario | Select a Scenario member. |
| Currency | Select the required currency. |
| Date | Select a Date member. |
| Level | Select the level of Balance Sheet accounts in the hierarchy to display in the columns. |
