A predefined Cash Flow Schema is given with a predefined calculation Rule (Cash Flow Rule) and row format.
Of it is possible to Clear the schema but both the Rule and the Row format must be redone.
The configuration of the Existing or New Schema can count upon this Setting Screen to determine the Data Flows from the Profit and Loss and Balance Sheet in the Cash Flow Schema.
Cash Calculation Logics
Any Cash Flow Account is calculated as the Difference between a Total Amount(+) and another Total Amount(-). The Calculation of such Total Amounts is driver by Matrixes that you need to configure. In the configuration process you need to choose :
> the destination Cash Flow Account Item
> the source Accounts from the Group Chart of Accounts that contribute to the calculation
> the Movement that contribute to the calculation
This Screen provides the capability to setup such Matrixes. The calculation will be performed clicking the Calculate Cash-Flow Button in the Cash Flow Report. Please see the Reporting Section.
How to Setup Matrix (+) and Matrix (-)
> Click the (+) or (-) Button on the Cash Flow Item Row you want to configure.
> You will be prompted pop-up to choose the Accounts from the Group Chart of Accounts and the Movement
You will see in the Right report the result of such choice. Clicking on the Left Report Master Icon you can focus on the configuration of a single Cash Flow Item.
Notices
> To remove an Account from the Matrix simply un-tick the check-box
> The Green Flag reports a configuration has been done for such Cash Flow Account : of course Calculated Cash Flow Items (in Bold) must not be configured.
> By default the only Movements that can contribute to the Cash Flow Calculation are Closing and Opening plus Increase, Decrease and Other Changes but you can easily include other Movements changing the Screen selection.
Some Sample from the Sample above :
The 015 CF Item is calculated as the difference between the Closing Movement of the Selected Accounts and the Opening Movement of the same
The 075 CF Item is calculated as the sum of the Increase(+) and Other Changes (+/-) Movements of the Selected Accounts (the Matrix(-) is empty)