A downloadable Excel import template is attached at the bottom of the page.

Rules. (Required fields are highlighted with a Red background colour)


Field NameDescriptionRulesException HandlingValues to be placedDefault Values
Field Type
CodeThis field contains the code, which is a unique identifier, of the initiativeMust be an existing code in the systemIf there is no code or the code entered cannot be found, the system will display an error messageN/AN/A
Variable Character
SiteThis field contains the Site name where the Initiative is locatedMust 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/AN/AVariable Character
Cashflow NameThis field contains the name of the Cashflow itemThis field is requiredIf a user enters a Cashflow name that does not exist, the system will import as a new Cashflow itemThe Cashflow name entered from the import fileN/AVariable Character
Cashflow CategoryThis field contains the Category that the Cashflow item is underMust 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/AN/AVariable Character
[Month][Year]These columns contain the Actual values for each month where the Cashflow forecast value is realised as a Cashflow Actual valueN/A
If there are no Actuals values entered, the system will consider the actual values for the periods as 0Values will be displayed as 0
0.00
Numeric