Table of Contents |
---|
...
Accounts Example Tag CSV File
Example Import CSV File for importing Account with different Site Groups.csv
Note: Click on the link above, then click and click on to download the CSV file.
Explaining the Tag CSV File
Column/Row | Requirement |
---|---|
Column B | Organisation name, ie TRAINING ACADEMY |
Column D | Site Group Name, ie Local Authority |
Column F | Site Name, ie LA Dixon Control Centre |
Column H | Account Number (same as Column L), ie 1005682 |
Column I | Commodity, ie Electricity |
Column K | Budget Group Name, ie Budget 20/21 |
Column L | Account Number (same as Column H), ie 1005682 |
Column N | Target (leave blank if you want to use the same figure as the Budget, ie -5 |
Column O | Start Date of the Budget, ie 01/04/2020 |
Column P | End Date of the Budget, ie 01/04/2021 |
Columns Q to AB | The monthly Budget figures, ie 6975.68 |
Importing the Tag CSV File
...