Fill out the import template for the rental module (commercial)
In this guide, we will go through the most common questions/challenges that arise when filling out the import file for the rental module.
Table of Contents
It is possible to create rental objects, tenants and tenancies manually in LAFT, but the easiest and most common way to register this is via an Excel import. In the template, you fill in the information in one place, and then send the file to support@laft.io.
When importing data, it is important that you use the latest version of our import template: Download it here
When the rental template is to be imported by us into LAFT, it is important that all the information filled in the template is correct, and that it is filled in according to the template's requirements and explanations.
Only the columns for the name of the rental object are mandatory to fill in (and the building ID if you want to link the rental object to an existing building in LAFT).
There are two different templates based on whether you already have buildings in LAFT that you want to link rental objects to, or whether you want to create new buildings in addition to rental properties.
A rental object must be linked to a building. You can link multiple rental objects to one building, or have one rental object per building. If you subscribe to IK-Bygg (Internal Control) and want to perform condition analysis on rental objects, a building must correspond to a rental object (alternative 1), as it is only a concept for buildings in IK-Bygg. We are working on creating a solution that allows you to use IK-bygg questions on all object types in LAFT, and the goal is for this to be completed in the second half of 2025.
Option 1: Create each rental object as a separate building
This is ideal if your property department wants to carry out internal inspections/condition assessments on each rental object (apartment, etc.). If you wish to do this, leave column A in the template blank. Then, upon import, a completely new building will be created in LAFT for this rental object.
NB! As mentioned above, we are working on a solution that allows you to conduct condition assessments with IK-bygg questions on all object types. The work is scheduled to be completed in the second half of 2025.
Example:
The rest of the columns must also be filled in. The yellow and green ones are information that is stored on the rental properties and tenants respectively in the rental module. The red ones are about the tenancy.
Option 2: Have multiple rental objects associated with one building
NB! As mentioned above, we are working on a solution that allows you to conduct condition assessments with IK-bygg questions on all object types. The work is scheduled to be completed in the second half of 2025.
Then you will only be able to perform an internal inspection/condition assessment of the building as a whole. If the building to which the rental objects belong already exists in LAFT, enter the ID number of the building in column A on all rental properties that are to be linked to this building. The ID number can be found in the building overview under Settings > Buildings > Overview. If the building is not entered in LAFT, do this first, and then enter the ID number in the template.
Example: The building Eksemplengata 123 already exists in LAFT, and has ID 43932
By following this example, all rental properties will be associated with Example Street.
It is important to note that the text you write in the name of rental object column is what will be visible to the property manager in all overviews in the system, so it is important that this contains the address + apartment number, or something else that makes it easy for you to recognize the rental object.
Once a decision has been made on whether to choose option 1 or 2, you can proceed with filling out the template.
In several of the yellow columns, which deal with the rental object, there are drop-down menus from which you must select content. The drop-down menus appear by clicking on the arrows in the cell (see explanation in the “Data” sheet).
In the Tenant column, it is also important to note how to write the tenant's name. By hovering the mouse over the field, an explanation will appear:
For the name to appear correctly in the rental module, it must be written like this. If there are multiple people living in the same rental object, they can be separated with a colon like this: Normann, Ola:Nordmann, Kari
If you want to include other information about the tenant that is missing in the template, such as the tenant's email, it is possible to add your own columns.
The columns for the period of the tenancy must also be filled in if a tenant is written on the same line in the template. The lease period from indicates the move-in/takeover date, and if the tenancy is ongoing (without an end date), the column for “Lease period to” can be left blank.
The columns that deal with regulation must also be filled in. If you are unsure when the rental object was last regulated, you can set today's date. This will ensure that future regulation is correct.