Import suppliers, purchase orders and bills
This article lists the columns you can use when you import suppliers, purchase orders, bills and bill payments 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 Suppliers, Purchase Orders, Bills or Bill Payments, choose Actions, then Import. Purchase orders, bills and bill payments also have Import Allocations for their lines.
How rows are matched
- Suppliers: a row with an
id updates that supplier. Otherwise Kompass looks for a supplier with exactly the same name, including capital letters. A row that matches nothing adds a new supplier.
- Purchase orders, bills and bill payments: a row with an
id updates that record; a row without one adds a new record.
- Allocations: a row with an
id updates that line; a row without one adds a line. Put 1 or yes in the delete column to remove a line.
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.
Suppliers
| 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. |
address_country |
No |
No |
Two-letter country code, such as GB or US, or the country name. |
address_line1 |
No |
No |
First line of the supplier's address. |
address_line2 |
No |
No |
Second line of the supplier's address. |
address_postal_code |
No |
No |
Postal or ZIP code of the supplier's address. |
address_state |
No |
No |
State, province or county of the supplier's address. |
address_town |
No |
No |
Town or city of the supplier's address. |
email |
No |
No |
Email address for the supplier. |
name |
No |
Yes |
Supplier name, as shown in Kompass. |
notes |
No |
No |
Free-text notes about the supplier. |
org_id |
No |
No |
Kompass ID of the organization the supplier belongs to. Or use org_name. |
org_name |
No |
No |
Name of the organization the supplier belongs to. Or use org_id. |
phone |
No |
No |
Contact phone number. |
tags |
No |
No |
Tag names separated by commas, or a list in square brackets such as ["Design, Build"] for a name that contains a comma. The record gets exactly these tags; an empty cell removes them all. |
udf |
No |
No |
Custom field values. Copy the format from an export of this list. Leave the column out to keep the current values. |
udf_schema_id |
No |
No |
ID of the custom field set to use. Leave empty for the default set. |
unanet_code |
No |
No |
Supplier code in Unanet. |
website |
No |
No |
Supplier website address. |
Purchase orders
| 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. |
amount_net |
Yes |
No |
Authorized value of the order, net of tax. |
amount_tax |
No |
No |
Tax on the order. |
date |
Yes |
No |
Date of the order, such as 2026-01-31. |
notes |
No |
No |
Free-text notes about the order. |
reference |
No |
No |
Reference. Leave empty to number it automatically. |
status |
No |
No |
D for draft, I for issued, C for closed. Accepted values: C, D, I. |
supplier_id |
No |
No |
Kompass ID of the supplier. |
tags |
No |
No |
Tag names separated by commas, or a list in square brackets such as ["Design, Build"] for a name that contains a comma. The record gets exactly these tags; an empty cell removes them all. |
Bills
| 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. |
amount_net |
Yes |
No |
Net amount of the bill. |
amount_tax |
No |
No |
Tax on the bill. |
date |
Yes |
No |
Date of the bill, such as 2026-01-31. |
notes |
No |
No |
Free-text notes about the bill. |
purchase_order_id |
No |
No |
Kompass ID of the purchase order the bill relates to. |
reference |
No |
No |
Reference. Leave empty to number it automatically. |
supplier_id |
No |
No |
Kompass ID of the supplier. |
tags |
No |
No |
Tag names separated by commas, or a list in square brackets such as ["Design, Build"] for a name that contains a comma. The record gets exactly these tags; an empty cell removes them all. |
Bill payments
| 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. |
amount_net |
Yes |
No |
Net amount of the payment. |
amount_tax |
No |
No |
Tax on the payment. |
date |
Yes |
No |
Date of the payment, such as 2026-01-31. |
notes |
No |
No |
Free-text notes about the payment. |
purchase_order_id |
No |
No |
Kompass ID of the purchase order the payment relates to. |
reference |
No |
No |
Reference. Leave empty to number it automatically. |
supplier_id |
No |
No |
Kompass ID of the supplier. |
tags |
No |
No |
Tag names separated by commas, or a list in square brackets such as ["Design, Build"] for a name that contains a comma. The record gets exactly these tags; an empty cell removes them all. |
Purchase order allocations
| 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. |
amount_net |
Yes |
No |
Net amount of the line, before tax. |
amount_tax |
No |
No |
Tax on the line. |
nominal_account_id |
Yes |
No |
Kompass ID of the nominal account the line posts to. |
purchase_order_id |
Yes |
No |
Kompass ID of the purchase order the line belongs to. |
quote_item_id |
Yes |
No |
Kompass ID of the quote item the line is for. |
delete |
No |
No |
Put 1 or yes to delete the matching record. |
Bill allocations
| 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. |
amount_net |
Yes |
No |
Net amount of the line, before tax. |
amount_tax |
No |
No |
Tax on the line. |
bill_id |
Yes |
No |
Kompass ID of the bill the line belongs to. |
nominal_account_id |
Yes |
No |
Kompass ID of the nominal account the line posts to. |
quote_item_id |
Yes |
No |
Kompass ID of the quote item the line is for. |
delete |
No |
No |
Put 1 or yes to delete the matching record. |
Bill payment allocations
| 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. |
amount_net |
Yes |
No |
Net amount of the line, before tax. |
amount_tax |
No |
No |
Tax on the line. |
bill_id |
Yes |
No |
Kompass ID of the bill the line pays. |
bill_payment_id |
Yes |
No |
Kompass ID of the bill payment the line belongs to. |
nominal_account_id |
Yes |
No |
Kompass ID of the nominal account the line posts to. |
quote_item_id |
Yes |
No |
Kompass ID of the quote item the line is for. |
delete |
No |
No |
Put 1 or yes to delete the matching record. |