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