Leases are subject to property units and it is highly recommended that leases are imported in a separate sheet, where they are tied to a unit by the corresponding ID. Certain headers are mandatory in order to import a lease, but additional details can also be imported by optional headers.
SkenarioLabs Analytics assumes there is maximum one active lease per a unit. If a unit ID and an activation date are imported via Excel so that a lease with corresponding values is already in the database, the existing lease is updated.
Column title | Description | Allowed values |
---|---|---|
Unit ID | A unit ID of the unit subject to the lease contract | String |
Rent | Monthly rent | Number |
Activation date | Starting date of the lease | Date |
* Attempting to import a renovation with an incompatible part will not raise an error, but the renovation is changed to Miscellaneous repair. Furthermore, importing a renovation for a non-existing part will not raise an error, but the renovation is changed to Part change (thus creating the part).
Column title | Description | Allowed values |
---|---|---|
Notice period duration | Lease notice period in days | Integer |
Tenant | Free description of a tenant | String |
Lease type** | Continuous or fixed term lease contract | Until further notice, Fixed length |
Expiration date | Expiration date of a fixed term lease | Date |
First possible termination date | First possible expiration date of a continuous lease contract | Date |
**Lease type is assumed to be continuous if lease type is not given.