What data is transferred to DATEV by default?

← Accounting Support FAQ

To seamlessly transfer invoice-based bookkeeping data to DATEV, JustOn integrates with JustOn Connector for DATEV. This is an add-on to JustOn that generates DATEV-specific ledger records from booking details (as created from invoices and invoice line items) and from expenses, and transfers them to DATEV Unternehmen online. Once there, these accounting documents and accounting document items can be used by any DATEV application that accesses the DATEV Cloud.

For details, see Data Transfer to DATEV.

The following tables show the default mapping between the relevant Booking Detail or Expense fields, the (intermediate) Accounting Document/Accounting Document Item fields and the target DATEV data structure.

Booking detail (produced from invoices and invoice line items)

Source	Booking Detail	Accounting Document	Accounting Document Item	DATEV
Invoice.Name	InvoiceNo	InvoiceId		invoiceId
dynamically set on creation	BookingPeriod	DocumentDate		date
Invoice.AccountName	AccountName	CustomerName		customerName
Invoice.BillingCity	BillingCity	CustomerCity		customerCity
Invoice.BankAccount	IBAN	IBAN		iban
Invoice.BankCode	BIC	SwiftCode		swiftCode
Account.ON_VATNumber Account.TaxNumber	VATId	VatId		vatId
InvoiceLineItem.PosTotalNet InvoiceLineItem.PosTotalTax	Amount		Amount	amount
InvoiceLineItem.GLAccount CollectiveAccount.Account	AccountNo		AccountNo	accountNo
Invoice.ON_BookingDate Invoice.Date	BookingDate		AccountingDate	date
Invoice.ON_BookingDate Invoice.Date Invoice.DeliveryDate	OriginalBookingDate DeliveryDate		DeliveryDate	deliveryDate
InvoiceLineItem.TaxRate	TaxRate		Tax	tax

JustOn Billing & Invoice Management can copy additional fields from the booking details to the accounting documents and accounting document items. This is done for all additional fields on the booking detail if a field with the same name exists on the corresponding target. For details, see Additional Fields.

Expense/expense item

Expense	Expense Item	Accounting Document	Accounting Document Item	DATEV
CurrencyIsoCode		Currency Code		currencyCode
ReceiptDate		Document Date		date
PayeeIBAN		IBAN		iban
ReceiptNo		InvoiceId		invoiceId
PaymentDate		Paid At		paidAt
Name		Internal Invoice Id		internalInvoiceId
SenderCity		Supplier City		supplierCity
PayeeName		Supplier Name		supplierName
PayeeBIC		SwiftCode		swiftCode
SenderTaxId		VatId		vatId
	GLAccount		AccountNo	accountNo
	GrossAmount		Amount	amount
	TaxRate		Tax	tax

Related information:

Enabling Data Transfer to DATEV
What dates are transferred to DATEV?