Adding a cash flow statement
Financial statements are managed and maintained in Application settings.
If you want to add a custom financial statement, proceed as follows.
Cash flow statement configuration
Procedure
1. In the navigation panel, click Application settings.
2. In the data panel, under Company settings, click Financial statements.
3. Click 
at the top.
at the top.A predefined statement appears, which you can amend as required.
4. Enter a Name for your financial statement and in Configure, specify whether your statement is Cash flow or Profit & Loss.
 | The cash flow statement shows four different line types: • Aggregated lines: used to aggregate cash flow lines to a higher level. • Mandatory lines: are always active and have a predefined business logic which can’t be altered. • Fixed lines: can be activated or deactivated but have a predefined business logic which can’t be altered. Dynamic lines: can be created by the system administrator in the pick list. |
5. To add an entry, click Add (
).
).A new row appears in the statement of which you can further configure details on the right.
Until you configure it further, the line is temporarily showing a placeholder text:
Field | Description |
|---|---|
Cash flow line | Expand the drop-down box to select the appropriate cash flow entry from the list. Depending on where you are adding the entry, various options become available. An item can be selected only once for a financial statement. |
The following lines only become available after selecting a cash flow line. | |
Forecast from source | Click the slide button to enable forecast from source. If this option is selected, the assets using this financial statement will retrieve forecasting assumptions from the source data. In Data Management, the data uploader or importer can upload or import the forecast data entity along with the relevant fields. |
Input method | Select the appropriate input method: • Property • Rentable unit type • Contract This allows a user to provide data in Income & Expenditure on different levels. |
Event | A financial statement distinguishes 11 types of events, which are part of the cash flow structure configuration: Continuous events • Perpetuity - A cash flow that repeats indefinitely. The cash flow date is calculated by offsetting the cash flow month with the cash flow period. The cash flow period is a number (1, 2, 3…) combined with the pick list value for the base unit of time. The cash flow method can be set to in advance or in arrears. • During vacancy - A cash flow that occurs during the vacancy period. Depending on the length of the vacancy, this may result in one or multiple cash flows. The method is the same as for perpetuity. • While rented – A cash flow that occurs during the rented period. Depending on the contract length, this may result in one or multiple cash flows. The method is the same as for perpetuity. Recurring events • On turnover - A cash flow that occurs when a contract expires. • On relet - A cash flow that occurs when a rentable unit (RU) is relet. • On renewal / review - A cash flow that occurs when a contract expires and the current lessee decides to renew the contract. Alternatively, the contract may be reviewed. In both cases, the contract must be re-evaluated. • On privatization – A cash flow that occurs when RUs are privatized. Variable events • Variable – A cash flow that occurs on the specified cash flow dates. These dates are either provided via source data or entered manually in REM. Single events • On reference date – A cash flow that occurs on the reference date of the process instance. • On start privatization – Typically matches the forecast start date. However, if the start of privatization is delayed due to restrictions, the start date may be later. • On termination date – A cash flow that occurs on the end date of the forecast period. |
Allocation key | Select the appropriate allocation key: • Initial ERV • m2 GFA • m2 ITZA • m2 NFA • Per unit Cash flows and profit & loss are calculated at the contract level. If the calculation method is missing or does not include an allocation key (e.g., per annum), the allocation key is used to distribute property-level cash flows to the underlying contracts. |
Cash flow month | This option is only available for continuous events. The selected calendar month is used in combination with the cash flow period to determine the cash flow dates during the forecast period. Cash flows are always calculated on the first day of the month when the payment method is in advance, and on the last day of the month when the payment method is in arrears. |
Payment method | Select the appropriate payment method: • In advance • In arrears |
Cash flow period | This option is only available for continuous events. The combination of the cash flow period and base unit of time determines the frequency in which a cash flow is calculated |
Calculation method | This option is only available for continuous or recurring events. The calculation method serves as a default value for income & expenditure. Select the appropriate calculation method: • Per annum (only for continuous events) • Per quarter (only for continuous events) • Per month (only for continuous events) • Per week (only for continuous events) • m² GFA (only for recurring events) • m² GFA p.a. (only for continuous events) • m² GFA p.q. (only for continuous events) • m² GFA p.m. (only for continuous events) • m² GFA p.w. (only for continuous events) • m² NFA (only for recurring events) • m² NFA p.a. (only for continuous events) • m² NFA p.q. (only for continuous events) • m² NFA p.m. (only for continuous events) • m² NFA p.w. (only for continuous events) • m² ITZA (only for recurring events) • m² ITZA p.a. (only for continuous events) • m² ITZA p.q. (only for continuous events) • m² ITZA p.m. (only for continuous events) • m² ITZA p.w. (only for continuous events) • per unit (only for recurring events) • per unit p.a. (only for continuous events) • per unit p.q. (only for continuous events) • per unit p.m. (only for continuous events) • per unit p.w. (only for continuous events) • % ERV • % PGI • % VPV • % Tax value • % Rebuild value • % initial ERV • % initial PGI • % initial VPV • % Tax value • % Rebuild value |
Index method | Select the appropriate index method: • Regulated contract • Passing rent indexation • Market rent • Exploitation cost • Construction cost • Sale amount • Market value |
6. Click Save at the top to save and apply your changes.
| | Your statement is immediately active and available for use. If necessary,there are options available for managing your financial statements. • Click the Recycle bin icon (  ) behind a cash flow line to delete it• Click Revert at the top to undo your changes |
General ledger configuration
Account mapping is done by adding general ledger accounts under a cash flow and/or profit and loss line. Actuals can be imported using source data for the combination of a property and general ledger. If the forecasting level in the process configuration is set to general ledger, then data entry in the income and expenditure screen is also done at the general ledger level.
7. Click 
to add a general ledger entry.
to add a general ledger entry.8. Expand the Select... box to assign the general ledger entry.
9. By default, the input method and allocation key are inherited from the cash flow statement but can be modified for a specific general ledger.
10. The following cash flow lines require a forecasting ledger:
◦ Financial vacancy
◦ Rent-free
◦ Cash incentive
◦ Surrender premium
◦ Recovery line (both reimbursed income and recoverable operating expenses)
◦ Forward funding
◦ Part sale receipt
A forecasting ledger allows the creation of multiple general ledgers for actuals, but only one general ledger for forecasting.