Import configuration lists

This article lists the columns you can use when you import the values of configuration lists, such as tags, types, categories, sources, departments and services from a CSV file, and how Kompass decides whether a row updates an existing record or adds a new one. For how the Import dialog works, see Import records from a CSV file. Developers using the API can find the same columns in the API reference.

Where to import

Open Configuration, open the list, and choose Import above it. For holidays, open Calendars and choose Import above the holidays. The calendar shown does not limit the import: each row's calendar column, or the holiday its id matches, decides which calendar it changes, so one file can cover several calendars. See Add public/ bank holidays. Departments and services are not Configuration lists, so they cannot be imported in Kompass yet; developers can import them through the API. See Configuration: client and expense lists.

How rows are matched

  • Kompass first looks for a value with this id and this name, then for a value with the same name, ignoring capital letters, and finally for a value with this ID alone. A row with an ID and a new name renames that value.
  • A row without an id that matches nothing adds a new value. A row whose id is not found and whose name matches nothing is reported as an error.
  • Before you import a file exported from another Kompass site, remove its id column or clear those cells. IDs differ between sites, so an ID from the other site can match a different value here and rename it.
  • Project categories, departments and services are the exception: they match on the id only, so a row without one adds a new value.
  • Holidays match on the id when it is filled in, and only otherwise on the calendar, day and name together (ignoring capital letters). Clear the id column in a file exported from another Kompass site, since IDs differ between sites. A row cannot move a holiday to another calendar, give a holiday the same day and name as another one on its calendar, add or change a holiday before today, or change a holiday that is already before today. A row for a past holiday that changes nothing is accepted and left as it is.

Reading the column tables

Required marks a column a new record needs. A row that updates an existing record only changes the columns in your file, so you can leave the others out. Finds the record marks a column Kompass uses to find the existing record a row updates. Column names must match exactly, including underscores. Where a column only takes certain values, the description lists them. A column marked Needs an extra permission is only accepted from users who have that permission; for anyone else the import reports it as an unknown column. The Download template button in the Import dialog gives you the header row for your own permissions.

Abandoned reasons

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the reason, as shown in Kompass.
details_required No No Whether abandoned notes are required for this reason.
start No No First day the reason can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the reason can be chosen. Leave empty to keep it available.

Bill payment tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the bill payment tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the bill payment tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the bill payment tag can be chosen. Leave empty to keep it available.

Bill tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the bill tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the bill tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the bill tag can be chosen. Leave empty to keep it available.

Client categories

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the category, as shown in Kompass.
start No No First day the category can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the category can be chosen. Leave empty to keep it available.

Client tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the client tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the client tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the client tag can be chosen. Leave empty to keep it available.

Client types

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the type, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the type can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the type can be chosen. Leave empty to keep it available.

Contact sources

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the source, as shown in Kompass.
details_required No No Whether additional details are required for this source.
start No No First day the source can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the source can be chosen. Leave empty to keep it available.

Contact tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the contact tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the contact tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the contact tag can be chosen. Leave empty to keep it available.

Contact titles

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Title, such as Mr, Mrs or Dr.
start No No First day the title can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the title can be chosen. Leave empty to keep it available.

Departments

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
billable No No Whether this department is billable.
colour No No Color on dashboard charts, as a hex code such as #FF5733.
end No No Date the department stops being used.
gross_margin No No Target gross margin percentage.
name No No Department name. Required for a new department.
org_id No No Kompass ID of the organization the department belongs to.
org_name No No Name of the organization to attach the department to.
start No No Date the department starts being used, such as 2026-01-31.

Equipment categories

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the equipment category, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the equipment category can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the equipment category can be chosen. Leave empty to keep it available.

Equipment owners

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the equipment owner, as shown in Kompass.
start No No First day the equipment owner can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the equipment owner can be chosen. Leave empty to keep it available.

Equipment tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the equipment tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the equipment tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the equipment tag can be chosen. Leave empty to keep it available.

Expense tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the expense tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the expense tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the expense tag can be chosen. Leave empty to keep it available.

Expense types

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the expense type, as shown in Kompass.
details No No Extra details for the expense type.
category No No Billable, non-billable, or leave empty for either. Accepted values: B, N.
start No No First day the expense type can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the expense type can be chosen. Leave empty to keep it available.
org_id No No Not used. Kept so older import files still load; new types belong to the current organization.

Holidays

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
calendar Yes Yes Name of the calendar the holiday belongs to. It must match one existing calendar.
day Yes Yes Date of the holiday, such as 2026-12-25.
name Yes Yes Name of the holiday.

Invoice tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the invoice tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the invoice tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the invoice tag can be chosen. Leave empty to keep it available.

Leave types

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the leave type, as shown in Kompass.
label No No Label shown on the Schedule.
category No No Whether the type counts as annual leave, sick leave or neither. Blank means no category. Accepted values: A, S.
start No No First day the leave type can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the leave type can be chosen. Leave empty to keep it available.

Payment tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the payment tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the payment tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the payment tag can be chosen. Leave empty to keep it available.

Project categories

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
billable No No Whether this category is billable.
colour No No Color on the Schedule, as a hex code such as #FF5733.
end No No Date the category stops being used.
name No No Category name. Required for a new category.
org_ids No No Kompass IDs of the organizations that use this category, separated by commas.
start No No Date the category starts being used, such as 2026-01-31.

Project confirmations

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the confirmation, as shown in Kompass.
stage No No Order confirmation stage: U, P or C. Accepted values: U, P, C.
start No No First day the confirmation can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the confirmation can be chosen. Leave empty to keep it available.

Project sources

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the source, as shown in Kompass.
details_required No No Whether additional details are required for this source.
start No No First day the source can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the source can be chosen. Leave empty to keep it available.

Project tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the project tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the project tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the project tag can be chosen. Leave empty to keep it available.

Purchase order tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the purchase order tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the purchase order tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the purchase order tag can be chosen. Leave empty to keep it available.

Quote item tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the quote item tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the quote item tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the quote item tag can be chosen. Leave empty to keep it available.

Sales order tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the sales order tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the sales order tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the sales order tag can be chosen. Leave empty to keep it available.

Services

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
billable No No Whether this service is billable.
colour No No Color on dashboard charts, as a hex code such as #FF5733.
department_id No No Kompass ID of the department the service belongs to. Or use department_name.
department_name No No Name of the department for a new service. Needs org_id too. Or use department_id.
end No No Last day the service is used, such as 2026-01-31.
gross_margin No No Target gross margin percentage.
name No No Service name, as shown in Kompass.
org_id No No Kompass ID of the organization the service belongs to. Needed with department_name.
start No No Date the service starts being used, such as 2026-01-31.

Supplier tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the supplier tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the supplier tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the supplier tag can be chosen. Leave empty to keep it available.

Task tags

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the task tag, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
start No No First day the task tag can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the task tag can be chosen. Leave empty to keep it available.

Task types

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
name Yes Yes Name of the task type, as shown in Kompass.
colour No No Color as a hex code, such as #FF5733.
billable No No Whether tasks of this type are billable.
start No No First day the task type can be chosen, such as 2026-01-31. Leave empty if it has no start date.
end No No Last day the task type can be chosen. Leave empty to keep it available.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us