In This Article
Cashflow Forecast Data Import Template
Rules for Cashflow Forecast Data Import
Overview
The tables for One-off Benefit and One-off Cost have been moved to the Idea Cashflow tab (For more information on Idea Cashflow, please see the following link: Idea Cashflow). Cashflow values may be entered manually or imported in bulk using the import tool to populate the cashflow table.
Note: You need to have the necessary idea permissions to import forecast values to the Cashflow table
Navigation
To access the Import feature, please follow these steps:
- Click on the Imports/Exports tab (or click on More > Imports/Exports) from the menu bar above.
- The Import page is the default page that will appear when you click on the Imports/Exports module.
On the Imports/Exports page, you will find the options to 1Imports, Exports or Schedule Exports. The table presented below comprises the 2Name of the Import process, File Name, Requested Import Date, Last Updated file date, and Import Status, indicating the success or failure of the import process. At the top of the page, you can find buttons to 3Add a new import process, select 4Templates, and 5Refresh the import page.
Cashflow Forecast Data Import Template
To access the Cashflow template to import the forecast data, follow the following steps:
- After clicking on the Templates button, select the Cashflow Forecast Data template from the drop-down list. This will open to the cashflow forecast data import excel file, where you can enter the necessary details for importing the cashflow forecast values.
- The Cashflow Forecast Data Import template file will be displayed similar to the screenshot below.
The provided template contains columns for the user to input the Idea Code, the corresponding Site, the Cashflow Name and the respective Cashflow Category. The Start and End date monthly periods for forecast on the Excel file are pre-populated. The pre-populated monthly periods on the Excel are for the next 12 months from the first forecast month of the idea. For example, the cashflow start date of the above idea is in April 2024, which is considered the first forecast month. The monthly periods on the actuals template will be from April 2024 to April 2025.
Note: To edit the excel template, you may need to first download the file. 3. After you have completed filling the excel file with the required details, save and close the file.
4. To import the file, click on +Add button located at the top of the Imports/Exports screen.
5. This will open the Add Import screen, similar to the screenshot, below to import the file.
6. In this screen, select the 1Import Type from the drop-down menu (in this case it will be Cashflow Forecast Data option) then click 2Select Files to select the import file from your file location. After the file has been selected, click 3Save to load the import file to the Cashflow section.
7. Once the file has been successfully loaded, the Status will display as Complete (if the status still displays as Processing, click on the Refresh button located on the top-right corner).
Note: Forecast values are displayed in blue font on the Idea Cashflow table. If there are current/existing forecast values in the Idea Cashflow, the imported values will override the existing values.
Importing cashflow forecast values to a cashflow table that already has an annual growth rate set will add or update the data without triggering an automatic recalculation of the cashflow values. A recalculation is triggered when a cashflow forecast value is manually changed or a change in the existing annual growth rate.Rules for Cashflow Forecast Data Import
For the import of the forecast cashflow values to be successful, the following rules need to be adhered to:
- The user must have the necessary idea permissions (eg Idea Owner, viewing permissions).
- The owner/facilitator of the idea has this permission granted by default.
Note: for rules on permissions for cashflow forecast data import, please see the following article: Cashflow Forecast Data Import Permissions
The link to the Rules and Sample article on the Cashflow Forecast Data Import can be accessed through this link: Cashflow Forecast Data Import Template Rules and Sample