CashFlow
The Cash Flow rule is used to automate creation if a Indirect or Direct long term cash flow statement based on the Income Statement and the Balance Sheet.
- An overview of Automation and Business Rule options can be found in Business Rule Automation Overview.
1. Configure the CashFlow BusinessRule in Modeler
- Login modeler
- Add the corresponding accounts (here it doesn't have to be the leaf level accounts) for your CashFlow accounts. It will copy from your nominal accounts to the CashFlow accounts. The naming is not fixed and can be changed to your own preference.
- Save → CheckIn → Deploy
- Sign
- 1: keep the same sign
- -1: to revert
-
- Amount: the same amount of the selected source account
- Movement: only the movement of the period
- Previous_Period: only the value of the previous period
- Opening_Year: only the value of the opening year
1.1 If you want to change CashFlow Accounts to Your Own Preference
To change CashFlow Accounts to your company preference:
- Login Modeler → Account dimension → CheckOut
- Go to Hierarchy tab to setup the cashflow accounts' hierarchy.
- Save & CheckIn
- Go to List → CashFlow_Setup → CheckOut
-
- Data Type: Member
- Dimension: Account
- Hierarchy: Account
- Save → CheckIn → Deploy → Done.
2. Run CashFlow Rule in Excel
CashFlow rule is executed on demand from the menu in excel.
- Please configure ScenarioMbrs, TimeMbrs & EntityMbrs → click on OK (in below example:)
- Scenario = Budget
- Time = 2017
- Entity = All
- If you want to use Actual scenario for cashflow, please make sure the Actual scenario & period are open in Database Lock from Modeler. So any scenario/period need to be open for input for cashflow calculation.
3. CashFlow Reports in Excel
There are two build-in CashFlow reports:
- Budget Reports and Analysis → Report Template:
- CashFlow
- CashFlow_Indirect
- Use CashFlow as an example. Select it and click on Open.
- Click on the user:xxxx → Edit Report → This will open Report Wizard
-
- BusinessProcess - CashFlow (I want to see my CashFlow report, so I choose CashFlow as BusinessProcess; you can also do an extract to see your data is stored on what combinations of different dimensions, so you know what to choose for all the slicers.)
- BusinessRule - None
- TimeDataView - Periodic
- Click on Save Report to save it in Reports folder. Go to Report and Analysis, you will be able to access this saved CashFlow report again.