A downloadable Excel import template is attached at the bottom of the page.
Rules. (Required fields are highlighted with a Red background colour)
Field Name | Description | Rules | Exception Handling | Values to be placed | Default Values | Field Type |
Code | This field contains the code, which is a unique identifier, of the initiative | Must be an existing code in the system | If there is no code or the code entered cannot be found, the system will display an error message | N/A | N/A | Variable Character |
Site | This field contains the Site name where the Initiative is located | Must be an existing Site name in the system | If there is no Site name or the Site name entered does not exist, the system will display an error message | N/A | N/A | Variable Character |
Cashflow Name | This field contains the name of the Cashflow item | This field is required | If a user enters a Cashflow name that does not exist, the system will import as a new Cashflow item | The Cashflow name entered from the import file | N/A | Variable Character |
Cashflow Category | This field contains the Category that the Cashflow item is under | Must be an existing Cashflow Category in the system | If there is no Cashflow Category or the Cashflow Category entered does not exist, the system will display an error message | N/A | N/A | Variable Character |
[Month][Year] | These columns contain the Actual values for each month where the Cashflow forecast value is realised as a Cashflow Actual value | N/A | If there are no Actuals values entered, the system will consider the actual values for the periods as 0 | Values will be displayed as 0 | 0.00 | Numeric |