How to export master data?
You can use JustOn's invoice CSV export to export master data to your accounting system. Master data refers to account-related data like customer name, address, tax ID, debtor/creditor number, etc. Accounting systems usually handle master data separately and can therefore not import it together with invoicing data. For transferring master data, you produce specifically configured CSV files from invoices.
Data transfer to accounting systems
Irrespective of the bookkeeping data generation features you apply, your organization usually delivers the relevant invoicing data to an (external) accounting system like DATEV, SAP or Microsoft Dynamics. Invoicing data refers to the actual business transactions that state the realized revenues or charged taxes and their corresponding booking accounts, as represented in booking details. Accounting systems expect specifically formatted CSV files in order to import this data. To support this, JustOn provides a flexible CSV export mechanism, which allows you to configure and execute booking details exports according to your needs.
If your target accounting system is DATEV, you may consider using DATEV Unternehmen online. JustOn supports the automatic transfer of invoicing data to this platform.
In addition, your business may require to export master data to your accounting system. Master data refers to account-related data like customer name, address, tax ID, debtor/creditor number, etc. Accounting systems usually handle master data separately and can therefore not import it together with invoicing data. For transferring master data, you use JustOn's export mechanism to produce specifically configured CSV files from invoices.
Delivering bookkeeping data to accounting systems
In broad strokes, here is how to proceed:
-
If required, add custom fields to relevant objects.
The target system may expect specific data. To hold this data, create the corresponding fields on the invoice or business entity.
-
Create a dedicated JSON configuration for your master data exports.
The JSON configuration must describe the intended structure of the output CSV.
For details, see Defining CSV File JSON Configuration.
-
Create a dedicated CSV export configuration for your master data exports.
Make sure to
- use a descriptive name
- set
Invoice CSVas the export format - specify the Salesforce record ID of the JSON configuration file
For details, see Defining Export Settings.
As an example, take the master data exchange format for DATEV. In order to generate a CSV export that is compliant to the DATEV CSV format for debtors/creditors, you must
- Add custom fields to relevant objects
- Create a specific JSON export configuration
Required fields for DATEV debtors/creditors export configuration
The JSON example configuration requires additional custom fields:
| Object | Field | Data Type | Possible Value/Description |
|---|---|---|---|
| Business Entity | ClientNumber__c |
Text (255) | The client number (Mandantennummer) for this business entity. |
| Business Entity | ConsultantNumber__c |
Text (255) | The number of this business entity's tax consultant (Beraternummer). |
| Invoice | Export_DebtorNo__c |
Formula (Text) | ONB2__Account__r.DebtorNo__c |
| Invoice | Export_AccountAccountName__c |
Formula (Text) | IF (ONB2__Account__r.IsPersonAccount, ONB2__Account__r.FirstName + " " + ONB2__Account__r.LastName, ONB2__Account__r.Name) |
| Invoice | Export_AccountVATID__c |
Formula (Text) | ONB2__Account__r.VatNumber__c |
| Invoice | Export_AccountBillingStreet__c |
Formula (Text) | ONB2__Account__r.BillingStreet |
| Invoice | Export_AccountBillingPostalCode__c |
Formula (Text) | ONB2__Account__r.BillingPostalCode |
| Invoice | Export_AccountBillingCity__c |
Formula (Text) | ONB2__Account__r.BillingCity |
| Invoice | Export_Account_IBAN__c |
Formula (Text) | ONB2__Account__r.BankAccount__c |
For help about creating fields, see Managing Object Fields.
JSON export configuration for DATEV debtors/creditors CSV
To produce a DATEV debtors/creditors-compliant CSV file, you can use the following JSON export configuration.
Make sure to set the correct start of the fiscal year (field 13 in headerRow1, 20200101 in this example) as well as the correct G/L account length (field 14 in headerRow1, 4 in this example).
{
"rows":{
"headerRow1": [
"EXTF",
"700",
"16",
"Debitoren/Kreditoren",
"4",
"TimeStamp",
"",
"RE",
"UserName",
"",
"businessentity.ConsultantNumber__c",
"businessentity.ClientNumber__c",
"20200101",
"4",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
"headerRow2": [
"Konto",
"Name (Adressattyp Unternehmen)",
"Unternehmensgegenstand",
"Name (Adressattyp natürl. Person)",
"Vorname (Adressattyp natürl. Person)",
"Name (Adressattyp keine Angabe)",
"Adressattyp",
"Kurzbezeichnung",
"EU-Land",
"EU-UStID",
"Anrede",
"Titel/Akad. Grad",
"Adelstitel",
"Namensvorsatz",
"Adressart",
"Straße",
"Postfach",
"Postleitzahl",
"Ort",
"Land",
"Versandzusatz",
"Adresszusatz",
"Abweichende Anrede",
"Abw. Zustellbezeichnung 1",
"Abw. Zustellbezeichnung 2",
"Kennz. Korrespondenzadresse",
"Adresse Gültig von",
"Adresse Gültig bis",
"Telefon",
"Bemerkung (Telefon)",
"Telefon GL",
"Bemerkung (Telefon GL)",
"E-Mail",
"Bemerkung (E-Mail)",
"Internet",
"Bemerkung (Internet)",
"Fax",
"Bemerkung (Fax)",
"Sonstige",
"Bemerkung (Sonstige)",
"Bankleitzahl 1",
"Bankbezeichnung 1",
"Bank-Kontonummer 1",
"Länderkennzeichen 1",
"IBAN-Nr. 1",
"IBAN1 korrekt",
"SWIFT-Code 1",
"Abw. Kontoinhaber 1",
"Kennz. Hauptbankverb. 1",
"Bankverb 1 Gültig von",
"Bankverb 1 Gültig bis",
"Bankleitzahl 2",
"Bankbezeichnung 2",
"Bank-Kontonummer 2",
"Länderkennzeichen 2",
"IBAN-Nr. 2",
"IBAN2 korrekt",
"SWIFT-Code 2",
"Abw. Kontoinhaber 2",
"Kennz. Hauptbankverb. 2",
"Bankverb 2 Gültig von",
"Bankverb 2 Gültig bis",
"Bankleitzahl 3",
"Bankbezeichnung 3",
"Bank-Kontonummer 3",
"Länderkennzeichen 3",
"IBAN-Nr. 3",
"IBAN3 korrekt",
"SWIFT-Code 3",
"Abw. Kontoinhaber 3",
"Kennz. Hauptbankverb. 3",
"Bankverb 3 Gültig von",
"Bankverb 3 Gültig bis",
"Bankleitzahl 4",
"Bankbezeichnung 4",
"Bank-Kontonummer 4",
"Länderkennzeichen 4",
"IBAN-Nr. 4",
"IBAN4 korrekt",
"SWIFT-Code 4",
"Abw. Kontoinhaber 4",
"Kennz. Hauptbankverb. 4",
"Bankverb 4 Gültig von",
"Bankverb 4 Gültig bis",
"Bankleitzahl 5",
"Bankbezeichnung 5",
"Bank-Kontonummer 5",
"Länderkennzeichen 5",
"IBAN-Nr. 5",
"IBAN5 korrekt",
"SWIFT-Code 5",
"Abw. Kontoinhaber 5",
"Kennz. Hauptbankverb. 5",
"Bankverb 5 Gültig von",
"Bankverb 5 Gültig bis",
"Leerfeld",
"Briefanrede",
"Grußformel",
"Kundennummer",
"Steuernummer",
"Sprache",
"Ansprechpartner",
"Vertreter",
"Sachbearbeiter",
"Diverse-Konto",
"Ausgabeziel",
"Währungssteuerung",
"Kreditlimit (Debitor)",
"Zahlungsbedingung",
"Fälligkeit in Tagen (Debitor)",
"Skonto in Prozent (Debitor)",
"Kreditoren-Ziel 1 Tg.",
"Kreditoren-Skonto 1 %",
"Kreditoren-Ziel 2 Tg.",
"Kreditoren-Skonto 2 %",
"Kreditoren-Ziel 3 Brutto Tg.",
"Kreditoren-Ziel 4 Tg.",
"Kreditoren-Skonto 4 %",
"Kreditoren-Ziel 5 Tg.",
"Kreditoren-Skonto 5 %",
"Mahnung",
"Kontoauszug",
"Mahntext 1",
"Mahntext 2",
"Mahntext 3",
"Kontoauszugstext",
"Mahnlimit Betrag",
"Mahnlimit %",
"Zinsberechnung",
"Mahnzinssatz 1",
"Mahnzinssatz 2",
"Mahnzinssatz 3",
"Lastschrift",
"Verfahren",
"Mandantenbank",
"Zahlungsträger",
"Indiv. Feld 1",
"Indiv. Feld 2",
"Indiv. Feld 3",
"Indiv. Feld 4",
"Indiv. Feld 5",
"Indiv. Feld 6",
"Indiv. Feld 7",
"Indiv. Feld 8",
"Indiv. Feld 9",
"Indiv. Feld 10",
"Indiv. Feld 11",
"Indiv. Feld 12",
"Indiv. Feld 13",
"Indiv. Feld 14",
"Indiv. Feld 15",
"Abweichende Anrede (Rechnungsadresse)",
"Adressart (Rechnungsadresse)",
"Straße (Rechnungsadresse)",
"Postfach (Rechnungsadresse)",
"Postleitzahl (Rechnungsadresse)",
"Ort (Rechnungsadresse)",
"Land (Rechnungsadresse)",
"Versandzusatz (Rechnungsadresse)",
"Adresszusatz (Rechnungsadresse)",
"Abw. Zustellbezeichnung 1 (Rechnungsadresse)",
"Abw. Zustellbezeichnung 2 (Rechnungsadresse)",
"Adresse Gültig von (Rechnungsadresse)",
"Adresse Gültig bis (Rechnungsadresse)",
"Bankleitzahl 6",
"Bankbezeichnung 6",
"Bank-Kontonummer 6",
"Länderkennzeichen 6",
"IBAN-Nr. 6",
"IBAN6 korrekt",
"SWIFT-Code 6",
"Abw. Kontoinhaber 6",
"Kennz. Hauptbankverb. 6",
"Bankverb 6 Gültig von",
"Bankverb 6 Gültig bis",
"Bankleitzahl 7",
"Bankbezeichnung 7",
"Bank-Kontonummer 7",
"Länderkennzeichen 7",
"IBAN-Nr. 7",
"IBAN7 korrekt",
"SWIFT-Code 7",
"Abw. Kontoinhaber 7",
"Kennz. Hauptbankverb. 7",
"Bankverb 7 Gültig von",
"Bankverb 7 Gültig bis",
"Bankleitzahl 8",
"Bankbezeichnung 8",
"Bank-Kontonummer 8",
"Länderkennzeichen 8",
"IBAN-Nr. 8",
"IBAN8 korrekt",
"SWIFT-Code 8",
"Abw. Kontoinhaber 8",
"Kennz. Hauptbankverb. 8",
"Bankverb 8 Gültig von",
"Bankverb 8 Gültig bis",
"Bankleitzahl 9",
"Bankbezeichnung 9",
"Bank-Kontonummer 9",
"Länderkennzeichen 9",
"IBAN-Nr. 9",
"IBAN9 korrekt",
"SWIFT-Code 9",
"Abw. Kontoinhaber 9",
"Kennz. Hauptbankverb. 9",
"Bankverb 9 Gültig von",
"Bankverb 9 Gültig bis",
"Bankleitzahl 10",
"Bankbezeichnung 10",
"Bank-Kontonummer 10",
"Länderkennzeichen 10",
"IBAN-Nr. 10",
"IBAN10 korrekt",
"SWIFT-Code 10",
"Abw. Kontoinhaber 10",
"Kennz. Hauptbankverb. 10",
"Bankverb 10 Gültig von",
"Bankverb 10 Gültig bis",
"Nummer Fremdsystem",
"Insolvent",
"Mandatsreferenz 1",
"Mandatsreferenz 2",
"Mandatsreferenz 3",
"Mandatsreferenz 4",
"Mandatsreferenz 5",
"Mandatsreferenz 6",
"Mandatsreferenz 7",
"Mandatsreferenz 8",
"Mandatsreferenz 9",
"Mandatsreferenz 10",
"Verknüpftes OPOS-Konto",
"Mahnsperre bis",
"Lastschriftsperre bis",
"Zahlungssperre bis",
"Gebührenberechnung",
"Mahngebühr 1",
"Mahngebühr 2",
"Mahngebühr 3",
"Pauschalenberechnung",
"Verzugspauschale 1",
"Verzugspauschale 2",
"Verzugspauschale 3"
],
"invoiceRow":[
"Export_DebtorNo__c",
"Export_AccountAccountName__c",
"",
"",
"",
"",
"",
"",
"",
"Export_AccountVATID__c",
"",
"",
"",
"",
"",
"Export_AccountBillingStreet__c",
"",
"Export_AccountBillingPostalCode__c",
"Export_AccountBillingCity__c",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"Export_Account_IBAN__c",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
]
},
"rowOrder":["headerRow1","headerRow2","invoiceHeaderRow","invoiceRow"],
"columns": {
"headerRow1": {
"index": {
"1":{"forceQuotes":true}
}
},
"invoiceRow": {
"index": {
"2":{"forceQuotes":true},
"3":{"forceQuotes":true},
"4":{"forceQuotes":true},
"5":{"forceQuotes":true},
"6":{"forceQuotes":true},
"7":{"forceQuotes":true},
"8":{"forceQuotes":true},
"9":{"forceQuotes":true},
"10":{"forceQuotes":true},
"11":{"forceQuotes":true},
"12":{"forceQuotes":true},
"13":{"forceQuotes":true},
"14":{"forceQuotes":true},
"15":{"forceQuotes":true},
"16":{"forceQuotes":true},
"17":{"forceQuotes":true},
"18":{"forceQuotes":true},
"19":{"forceQuotes":true},
"20":{"forceQuotes":true},
"21":{"forceQuotes":true},
"22":{"forceQuotes":true},
"23":{"forceQuotes":true},
"24":{"forceQuotes":true},
"25":{"forceQuotes":true},
"29":{"forceQuotes":true},
"30":{"forceQuotes":true},
"31":{"forceQuotes":true},
"32":{"forceQuotes":true},
"33":{"forceQuotes":true},
"34":{"forceQuotes":true},
"35":{"forceQuotes":true},
"36":{"forceQuotes":true},
"37":{"forceQuotes":true},
"38":{"forceQuotes":true},
"39":{"forceQuotes":true},
"40":{"forceQuotes":true},
"41":{"forceQuotes":true},
"42":{"forceQuotes":true},
"43":{"forceQuotes":true},
"44":{"forceQuotes":true},
"45":{"forceQuotes":true},
"46":{"forceQuotes":true},
"47":{"forceQuotes":true},
"48":{"forceQuotes":true},
"49":{"forceQuotes":true},
"52":{"forceQuotes":true},
"53":{"forceQuotes":true},
"54":{"forceQuotes":true},
"55":{"forceQuotes":true},
"56":{"forceQuotes":true},
"57":{"forceQuotes":true},
"58":{"forceQuotes":true},
"59":{"forceQuotes":true},
"60":{"forceQuotes":true},
"63":{"forceQuotes":true},
"64":{"forceQuotes":true},
"65":{"forceQuotes":true},
"66":{"forceQuotes":true},
"67":{"forceQuotes":true},
"68":{"forceQuotes":true},
"69":{"forceQuotes":true},
"70":{"forceQuotes":true},
"71":{"forceQuotes":true},
"74":{"forceQuotes":true},
"75":{"forceQuotes":true},
"76":{"forceQuotes":true},
"77":{"forceQuotes":true},
"78":{"forceQuotes":true},
"79":{"forceQuotes":true},
"80":{"forceQuotes":true},
"81":{"forceQuotes":true},
"82":{"forceQuotes":true},
"85":{"forceQuotes":true},
"86":{"forceQuotes":true},
"87":{"forceQuotes":true},
"88":{"forceQuotes":true},
"89":{"forceQuotes":true},
"90":{"forceQuotes":true},
"91":{"forceQuotes":true},
"92":{"forceQuotes":true},
"93":{"forceQuotes":true},
"96":{"forceQuotes":true},
"97":{"forceQuotes":true},
"98":{"forceQuotes":true},
"99":{"forceQuotes":true},
"100":{"forceQuotes":true},
"102":{"forceQuotes":true},
"103":{"forceQuotes":true},
"104":{"forceQuotes":true},
"107":{"forceQuotes":true},
"133":{"forceQuotes":true},
"134":{"forceQuotes":true},
"136":{"forceQuotes":true},
"137":{"forceQuotes":true},
"138":{"forceQuotes":true},
"139":{"forceQuotes":true},
"140":{"forceQuotes":true},
"141":{"forceQuotes":true},
"142":{"forceQuotes":true},
"143":{"forceQuotes":true},
"144":{"forceQuotes":true},
"145":{"forceQuotes":true},
"146":{"forceQuotes":true},
"147":{"forceQuotes":true},
"148":{"forceQuotes":true},
"149":{"forceQuotes":true},
"150":{"forceQuotes":true},
"151":{"forceQuotes":true},
"152":{"forceQuotes":true},
"153":{"forceQuotes":true},
"154":{"forceQuotes":true},
"155":{"forceQuotes":true},
"156":{"forceQuotes":true},
"157":{"forceQuotes":true},
"158":{"forceQuotes":true},
"159":{"forceQuotes":true},
"160":{"forceQuotes":true},
"161":{"forceQuotes":true},
"162":{"forceQuotes":true},
"165":{"forceQuotes":true},
"166":{"forceQuotes":true},
"167":{"forceQuotes":true},
"168":{"forceQuotes":true},
"169":{"forceQuotes":true},
"170":{"forceQuotes":true},
"171":{"forceQuotes":true},
"172":{"forceQuotes":true},
"173":{"forceQuotes":true},
"176":{"forceQuotes":true},
"177":{"forceQuotes":true},
"178":{"forceQuotes":true},
"179":{"forceQuotes":true},
"180":{"forceQuotes":true},
"181":{"forceQuotes":true},
"182":{"forceQuotes":true},
"183":{"forceQuotes":true},
"184":{"forceQuotes":true},
"187":{"forceQuotes":true},
"188":{"forceQuotes":true},
"189":{"forceQuotes":true},
"190":{"forceQuotes":true},
"191":{"forceQuotes":true},
"192":{"forceQuotes":true},
"193":{"forceQuotes":true},
"194":{"forceQuotes":true},
"195":{"forceQuotes":true},
"198":{"forceQuotes":true},
"199":{"forceQuotes":true},
"200":{"forceQuotes":true},
"201":{"forceQuotes":true},
"202":{"forceQuotes":true},
"203":{"forceQuotes":true},
"204":{"forceQuotes":true},
"205":{"forceQuotes":true},
"206":{"forceQuotes":true},
"209":{"forceQuotes":true},
"210":{"forceQuotes":true},
"211":{"forceQuotes":true},
"212":{"forceQuotes":true},
"213":{"forceQuotes":true},
"214":{"forceQuotes":true},
"215":{"forceQuotes":true},
"216":{"forceQuotes":true},
"217":{"forceQuotes":true},
"220":{"forceQuotes":true},
"222":{"forceQuotes":true},
"223":{"forceQuotes":true},
"224":{"forceQuotes":true},
"225":{"forceQuotes":true},
"226":{"forceQuotes":true},
"227":{"forceQuotes":true},
"228":{"forceQuotes":true},
"229":{"forceQuotes":true},
"230":{"forceQuotes":true},
"231":{"forceQuotes":true}
}
}
},
"useASCII":false,
"markAsExported":false,
"columnSeparator":";",
"useCRLF":true,
"fileName": "EXTF_Export_[SettingName]_[Today].csv",
"aggregate":{},
"options":{
"decimalSeparator":",",
"groupingSeparator":".",
"dateFormat":"ddMMyyyy",
"timeFormat":"yyyyMMddHHmmssSSS",
"language":"de"
}
}