Skip to content

CSV single entries export (file)

The Universal Accounting CSV format allows to export your journal entries as comma-separated values. Some things to note:

  • Financial amounts are exported as strings.
  • Dates are exported as YYYY-MM-DD
  • Our CSV uses a comma (,) as delimiter.

Headers

The CSV is structured a bit differently compared to the default JSON export. The headers are automatically derived, and look like this:

headers.txt
"konteraId",
"invoice-number",
"invoice-billingPeriod",
"invoice-currency",
"invoice-date",
"invoice-payableUntil",
"invoice-qrReferenceNumber",
"invoice-owner",
"invoice-source",
"invoice-sourceId",
"contact-name",
"contact-externalId",
"entry-entryId",
"entry-entryNumber",
"entry-type",
"entry-date",
"entry-lineId",
"entry-lineNumber",
"entry-debitAccount-externalId",
"entry-debitAccount-number",
"entry-debitAccount-currency",
"entry-creditAccount-externalId",
"entry-creditAccount-number",
"entry-creditAccount-currency",
"entry-amount",
"entry-currency",
"entry-tax-value",
"entry-tax-code",
"entry-tax-externalId",
"entry-originalAmount",
"entry-originalCurrency",
"entry-text"
"entry-dimensions-{number}-name",
"entry-dimensions-{number}-externalId",
"entry-dimensions-{number}-type",

Example

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