Skip to content
/kontera/dev

Specification

All exports using Universal Accounting consist of the following fields / data. Please reference the individual formats to get an example of a specific export structure.

General

Section titled “General”
konteraId
Requiredtype: string

Id of a business transaction. It is possible, to link back to kontera via this ID, just use https://app.kontera.ch/invoices/:konteraId

  • Type: string

Invoice

Section titled “Invoice”

Information about the receipt / invoice are summed up in the invoice object. This is an optional field and might be null.

invoice
Optionaltype: object
number
Optionaltype: string
  • CSV-Header: invoice-number
date
Optionaltype: string
  • CSV-Header: invoice-date
  • Date in ISO-format YYYY-MM-DD
payableUntil
Optionaltype: string
  • CSV-Header: invoice-payableUntil
  • Date in ISO-format YYYY-MM-DD
billingPeriod
Optionaltype: object
from
Requiredtype: string
  • CSV-Header: invoice-billingPeriod_from
  • Date in ISO-format YYYY-MM-DD
to
Requiredtype: string
  • CSV-Header: invoice-billingPeriod_to
  • Date in ISO-format YYYY-MM-DD
qrReferenceNumber
Optionaltype: string
  • CSV-Header: invoice-qrReferenceNumber
  • 🇨🇭-only
  • accounts-receivables only
owner
Optionaltype: string
  • CSV-Header: invoice-owner
source
Optionaltype: string
  • CSV-Header: invoice-source
sourceId
Optionaltype: string
  • CSV-Header: invoice-sourceId
postingType
Requiredtype: enum

The type of posting for this invoice.

  • CSV-Header: invoice-postingType
  • Allowed values:
    • accounts-payable (supplier invoice)
    • accounts-receivable (customer invoice)
    • direct-posting (direct booking)

Contact

Section titled “Contact”
contacts
Requiredtype: array
contactId
Requiredtype: string

Unique ID within kontera. You must provide this value together with an externalId generated by your system if you have added contacts into your system and are re-importing those contacts, to avoid duplication.

  • UUID
  • CSV-Header: contact-contactId
externalId
Optionaltype: string

Internal ID of your project in your accounting system. kontera uses this ID to uniquely identify your project, and will reference it in the export.

  • Min: 1 character
  • Max: 36 characters
  • CSV-Header: contact-externalIdd
legalType
Requiredtype: enum

Describes the type of legal entity the contacts represents.

  • Allowed values:
    • company
    • person
  • CSV-Header: contact-legalType
supplierType
Optionaltype: enum

Describes what kind of contact it is. Used by certain accounting systems with split contact pools.

  • Allowed values:
    • accounts-payable
    • accounts-receivable
  • CSV-Header: contact-supplierType
companyName
Optionaltype: string

Required if legalType = company

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-companyName
companyUid
Optionaltype: string

Company UID.

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-companyUid
companyTaxNumber
Optionaltype: string | null

VAT Number of your company. null if empty.

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-companyTaxNumber
firstName
Optionaltype: string

Required if legalType = person

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-firstName
lastName
Optionaltype: string

Required if legalType = person

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-lastName
address
Optionaltype: object
street
Optionaltype: string

Name of street.

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-address
street
Optionaltype: string

Name of street.

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-address-street
houseNumber
Optionaltype: string

House number.

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-address-houseNumber
postalCode
Optionaltype: string

Postal code / ZIP code.

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-address-postalCode
city
Optionaltype: string

Name of city.

  • Min: 1 character
  • Max: 255 characters
  • CSV-Header: contact-address-city
country
Optionaltype: string

Country.

  • 2-letter ISO3166 code
  • CSV-Header: contact-address-country

Employee

Section titled “Employee”

Information about the employee who paid the receipt out of pocket. This object is only present when the receipt was paid by an employee (payment type expenses-employee), otherwise it is null. JSON export only.

employee
Optionaltype: object
employeeId
Requiredtype: string

Unique ID of the employee within kontera.

  • UUID
firstName
Requiredtype: string
  • Example: Fernando
lastName
Requiredtype: string
  • Example: Alonso
email
Requiredtype: string
  • Example: fernando@example.com
mobile
Optionaltype: string | null

Mobile phone number of the employee. null if empty.

  • Example: +41761234567

Payment Advises

Section titled “Payment Advises”
paymentAdvises
Requiredtype: array
account
Requiredtype: object
number
Requiredtype: string
  • Example: 2000 / 1020
externalId
Optionaltype: string
currency
Optionaltype: string

3-character ISO currency code.

executionDate
Requiredtype: string
  • Date in ISO-format YYYY-MM-DD
amount
Requiredtype: string
  • Example: 25.50
currency
Requiredtype: string

3-character ISO currency code.

type
Requiredtype: enum

What kind of payment it is.

  • Allowed values:
    • qr, swiss qr bill
    • iban, iban payment
iban
Requiredtype: string

IBAN of the recipient.

reference
Optionaltype: string

Reference number of the payment (SCOR).

fee
Optionaltype: enum

Who pays the fee. May be null, in case of domestic payments.

  • Allowed values:
    • receiver-pays
    • sender-pays
    • splitted
message
Optionaltype: string
recipient
Requiredtype: object
name
Requiredtype: string
  • Example: bexio ag
street
Optionaltype: string
  • Example: Debit-Credit-Street
houseNumber
Optionaltype: string
  • Example: 12
houseNumber
Optionaltype: string
  • Example: 12
postalCode
Optionaltype: string
  • Example: 8000
city
Optionaltype: string
  • Example: Zurich
country
Optionaltype: string

Country.

  • 2-letter ISO3166 code

Entries

Section titled “Entries”

Journal entries are collected in the entries array.

entries
Requiredtype: array
entryId
Requiredtype: string

Unique identifier of a journal entry.

  • CSV-Header: entry-entryId
  • Example: K-XYZ-1
entryNumber
Requiredtype: number

Number of a journal entry within the transaction.

  • CSV-Header: entry-entryNumber
  • Example: 1
type
Requiredtype: enum
  • CSV-Header: entry-type
  • Allowed values
    • profit-loss-to-payment (direct)
    • profit-loss-to-collective-account (to collective account)
    • collective-account-to-payment (from collective account)
    • fee-to-payment (fee)
date
Requiredtype: string
  • CSV-Header: entry-date
  • Date in ISO-format YYYY-MM-DD

Lines

Section titled “Lines”
lines
Requiredtype: array
lineId
Requiredtype: string

The unique identifier of the journal entry line.

  • CSV-Header: entry-lineId
  • Example: K-XYZ-C-1
lineNumber
Requiredtype: number

The number of the journal entry line.

  • CSV-Header: entry-lineNumber
  • Example: 1
creditDebit
Optionaltype: string
  • Note: Not applicable for CSV. It is split in debitAccount + creditAccount (see account for reference)
  • Allowed Values:
  • credit
  • debit
amount
Requiredtype: string
  • CSV-Header: entry-amount
  • Example: 25.50
currency
Requiredtype: string

Matches the lead currency of your accounting system. 3-character ISO currency code.

amountInAccountCurrency
Optionaltype: string

Depending on your accounting system, certain accounts might be in other currencies than your lead currency. If this is the case, and the currency used in the journal entry line (which matches the lead currency of your accounting system) does not match the account, this amount represents the value of the transaction in the currency of the chosen account.

  • Note: Not applicable for CSV
  • Example: 30.25
account
Requiredtype: object
number
Requiredtype: string
  • CSV-Header: debitAccount-number / creditAccount-number
  • Example: 2000 / 1020
externalId
Optionaltype: string
  • CSV-Header: debitAccount-externalId / creditAccount-externalId
currency
Optionaltype: string

3-character ISO currency code.

tax
Optionaltype: object
code
Optionaltype: string
  • CSV-Header: entry-tax-code
  • Example: VB77
externalId
Optionaltype: string
  • CSV-Header: entry-tax-externalId
  • Example: 1
  • Corresponds to externalId that was given during import.
value
Optionaltype: string

Value of tax, given in % (0-100).

  • CSV-Header: entry-tax-value
  • Example: 7.7
type
Optionaltype: enum
  • CSV-Header: entry-tax-type
  • Allowed values:
    • unknown
    • pre-tax
    • pre-tax-original-production
    • reverse-charge-pre-tax
    • sales-tax
originalAmount
Optionaltype: string

The amount that was specified on the original invoice / receipt.

  • CSV-Header: entry-originalAmount
  • Example: 30.25
originalCurrency
Optionaltype: string

The currency that was specified on the original invoice / receipt. 3-character ISO currency code.

text
Requiredtype: string
  • CSV-Header: entry-text
  • Content can be configured via Settings -> Accounting system
dimensions
Requiredtype: array
name
Requiredtype: string

Name der Dimension.

  • CSV-Header: entry-dimensions-{number}-name
externalId
Optionaltype: string

  • Corresponds to externalId that was given during import.

  • CSV-Header: entry-dimensions-{number}-externalId

type
Requiredtype: enum

Files

Section titled “Files”
files
Optionaltype: array
konteraId
Requiredtype: string
name
Requiredtype: string

Name of the uploaded file.

  • Example: Swisscom.pdf
contentType
Requiredtype: string
  • Example: application/pdf
contentAsBase64
Optionaltype: string

Content of the file as base64 encoded string. This field is only present if file export is enabled in the configuration. If not present, use the konteraId to download the file via the public API endpoint GET /api/public/v1/documents/files/:konteraId/download.