When done well, your cash flow projections will help you understand whether your business is going to have enough working capital to keep operating and growing at the pace that you want it to. A cash flow forecast is frequently seen as the most important financial tool for growing your business. In the Cash Flow Forecast report, it is possible to input data in some of the forecast columns that are indicated with a reversed hatched area. For all planning reports, data entry is only possible when a single legal entity and the local currency are selected. Percentage change of Forecast x+y to budgetĬomment element of Cash Flow_measure dimensionĬell locking prevents the entry of data in fields that draw on multiple sources. Note: these columns appear only when Monthly checkbox has been activated in PoV area.Įlement of Month dimension related to settings in Year combobox. Input element of Cash Flow_measure dimension Total of forecast figures for planning scenario Forecast x+y Percentage change of Forecast x+y comparison to budget Stylesheet attribute of Version dimensionĭisplays the element selected in Comparison Forecast combobox if no forecast is selected, this column does not appear. Note: the month columns are only visible if the Monthly option in the PoV area is checked.ĬF Account dimension descendants of a preselected element, implemented with hierarchy and data filters. The screenshot below shows a report displaying Forecast 3+9 and Comparison Forecast 6+6, with the option Suppress Zero Lines selected.īelow are descriptions of the columns and rows in the Cash Flow Forecast Report. The columns and rows displayed in the report depend on the selections made in the PoV area. Switch between Name or ID_Name attribute of CF Account dimension. Show monthly values instead of a single value for the remaining forecast months.ĭescendants of the selected year in the range yyyy-01 - yyyy-12 OR yyyy-MM_YTD and yyyy-MM_YTG, depending on the selected forecast.ĭisplay the account number along with the account name in the row label column. Show adjustments for the version Forecast.Įnable entry on Adjustment in Cash Flow_measure dimension
Element of Month dimension related to settings in Year combobox.Previous year, Budget, Forecast x+y, Actual elements of Version dimension.Hide accounts not having any value in the current selection.ĭata filter factors the following elements: Select one forecast for comparison (or no forecast). LC is only available if a local currency is stored (not empty) in the Currency attribute for the selected element of the Legal Entity dimension.
The selection of local currency is only available for base elements or consolidated elements of the Legal Entity dimension having a common currency.Įlements of Currency dimension matching the pattern LC and elements starting with a > (e.g. Select local currency or one of the target currencies. Select one single legal entity or any consolidated element. Version dimension, filter for Stylesheet attribute equals FCĮlements matching the pattern yyyy or FYyyyy of Month dimension The available options are described below: The content of the report can be customized using the PoV options, which can be viewed by clicking the blue arrow at the top of the report.
#Cashflow forecast update#
Localized subtitle will update as PoV selections are madeĬlick on the arrow to display or hide point-of-view selections The heading area of the report displays the following fields: Field
The logo can be changed in Administration see Configuring Design Elements for more on report design. The screenshot below points out the heading area of the Cash Flow Forecast report.The report heading updates dynamically as various reporting options are selected. In this report it is possible to forecast amounts for a year on a single element or for single months.Īmounts can be shown in local currency or converted into one of the target currencies. It focuses on planning figures for several Forecast Version figures and compares these with other versions. This report shows financial amounts which are stored Profit and Loss and the Balance Sheet and will be displayed in Cash Flow cube via rules, only Adjustments are stored in the Cash Flow cube.
0 kommentar(er)
