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:
"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 Accounts payables, receivables and credit card transactions using foreign currencies