CSV single entries export (file)

Tip

We recommend to use the JSON format. However, we recognize that using a CSV might be your only option, which is why a transformed version is offered alongside.

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-contactId",
"contact-externalId",
"contact-legalType",
"contact-firstName",
"contact-lastName",
"contact-companyName",
"contact-companyTaxNumber",
"contact-companyUid",
"contact-address-street",
"contact-address-houseNumber",
"contact-address-postalCode",
"contact-address-city",
"contact-address-country",
"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