Consumption Measurement are subject to property building or group and it is highly recommended that leases are imported in a separate sheet, where they are tied to a building or group by the corresponding ID. Certain headers are mandatory in order to import a consumption, but additional details can also be imported by optional headers.
Mandatory headers
Column title
Description
Allowed values
Entity ID
An entity ID of the corresponding entity type subject to the cunsumption
String
Entity Type
Type of entity
PROPERTY_BUILDING, PROPERTY_GROUP
Consumption type
Type of Consumption
electricity consumption,
heating consumption,
cooling consumption,
water consumption
Consumption value
Monthly consumption
Number
Measurement date
Starting date of the lease
Date* Format: 2019-12-24
* Attempting to import date values if alignment is left it will cause fail. Edit date formatting such that alignment is on the right side.