JSON collective entries export (file)

Our file-based JSON export allows you to download journal entries in a structured form, best suited to integrate programmatically into your ERP or accounting systems.

• Financial amounts are exported as strings.
• Dates are exported as YYYY-MM-DD

Compared to the CSV export, the JSON export is more powerful and flexible. It allows you to consume more complex data structures and allows for processing payment advises and embeds files (if activated).

Example

JSON - Universal Accounting - Export
Accounts payables, receivables and credit card transactions using foreign currencies

Download

Your export will be a single *.json file, containing the following keys:

kontera-json-export.json

"konteraId": string,

"contact": {
  "name": string,
  "contactId": string,
  "externalId": string | null,
  "legalType": string,
  "firstName": string | null,
  "lastName": string | null,
  "companyName": string | null,
  "companyTaxNumber": string | null,
  "companyUid": string | null,
  "address": {
    "street": string | null,
    "houseNumber": string | null,
    "postalCode": string | null,
    "city": string | null,
    "country": string | null
  }
},

"paymentAdvises": [{
  "account": {
    "externalId": string | null,
    "number": string,
    "currency": string | null
  },

  "executionDate": string,
  "amount": string,
  "currency": string,

  "type": "qr" | "iban",
  "iban": string,
  "reference": string | null,
  "fee": "receiver-pays" | "sender-pays" | "splitted" | null,
  "message": string | null,

  "recipient": {
    "name": string,
    "street": string | null,
    "houseNumber": string | null,
    "postalCode": string | null,
    "city": string | null,
    "country": string | null
  }
}],

"invoice": {
  "number": string | null,
  "billingPeriod": {
    "from": string,
    "to": string
  } | null,
  "payableUntil": string | null,
  "qrReferenceNumber": string | null,
  "owner": string | null,
  "source": string | null,
  "sourceId": string | null
},

"entries": [{
  "entryId": string,
  "entryNumber": number,
  "type": string,
  "date": string,
  "lines": [{
      "lineId": string,
      "lineNumber": number,
      "creditDebit": "debit" | "credit",

      "amount": string,
      "currency": string,

      "amountInAccountCurrency": string | null,

      "account": {
        "externalId": string | null,
        "number": string,
        "currency": string | null
      },

      "tax": {
        "externalId": string | null,
        "code": string | null,
        "value": string
      },

      "originalAmount": string | null,
      "originalCurrency": string | null,

      "text": string | null,

      "dimensions": [{
        "externalId": string | null,
        "name": string,
        "type": string
      }]
  }]
}]

The following keys are optional:

kontera-json-export.json

"files": [{
  "konteraId": string,
  "name": string,
  "contentType": string | null,
  "contentAsBase64": string
}]