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. |
| 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. |
| 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. |
| 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. |