Cash Flow
Cash flow reports are financial statements that provide summaries of how the cash flows in and out of a business during a specific period.
You can calculate the cash flow for one fiscal calendar per entity.
You must specify the cash flow statement at the beginning of the first fiscal period of the calendar.
When you generate the cash flow for a different fiscal calendar, the value for the cash at the beginning of the period remains available because of the periodic storage.
Unlike in the Main cube, in the Cash Flow cube, there are no opening balances at separate levels for each fiscal calendar.
This table shows an example of the monthly cash flow for two calendar types for entity A:
| Calendar type | Cash type | Fiscal period 1 | Fiscal period 2 | Fiscal period 3 | Fiscal period 4 | Fiscal period 5 | Fiscal period 6 |
|---|---|---|---|---|---|---|---|
| Regular calendar | Cash at the beginning of the period | 100 | |||||
| April of the previous year | Cash at the beginning of the period | 120 | |||||
| Changes | 10 | 20 | -10 | 50 | 60 | -80 | |
| Cash at the end of the period | 110 | 20 | -10 | 170 | 60 | -80 |
This table shows an example of the year-to-date cash flow for two calendar types for entity A:
| Calendar type | Cash type | Fiscal period 1 | Fiscal period 2 | Fiscal period 3 | Fiscal period 4 | Fiscal period 5 | Fiscal period 6 |
|---|---|---|---|---|---|---|---|
| Regular calendar | Cash at the beginning of the period | 100 | 100 | 100 | 100 | 100 | 100 |
| April of the previous year | Cash at the beginning of the period | 0 | 0 | 0 | 120 | 120 | 120 |
| Changes | 10 | 30 | 20 | 70 | 130 | 50 | |
| Cash at the end of the period | 110 | 130 | 120 | 290 | 350 | 270 |