Scope Accounting CSV Interface Format

General

The Scope Accounting CSV interface exports accounts receivables and payables to a CSV or Excel file.

CSV File Format: The character set used corresponds to the standard ISO-8859-1. The different entries of a line are separated by a semicolon “;”.

Receivables and payables are each written to separate files.

Charge lines are grouped by

Invoice
Shipment
General ledger
Cost center
Tax key

Escaping

If the semicolon ; or the quotation marks " are part of a fields value, the field will be put into quotation marks, and each quotation mark that is part of the fields value is escaped with an additional quotation mark.

In the examples the ';' in the beginning is the separator to the previous field, the ';' at the end the separator to the next field.

`Max Mustermann`	`;Max Mustermann;`
`Max; Mustermann`	`;"Max; Mustermann";`
`Max Muster"mann`	`;"Max Muster""mann";`
`Max; Muster"mann`	`;"Max; Muster""mann";`
`Max; Muster""mann`	`;"Max; Muster""""mann";`

Formats

Date	dd.MM.yyyy
Money	(-)n,n The decimal of the monetary amount (without currency code). Negative amounts will start with a minus sign, e.g. "-254,20". No thousands delimiter is used, e.g. "1300,00" instead of "1.300,00".
Exchange rate	A decimal to describe an exchange rate. Always in indirect quotation to local currency. E.g. "1,28" if 1 EUR = 1.28 USD, and EUR is the local currency. The decimal will always have at least one digit on each side of the dot. E.g. "1,0" instead of "1", and "0,78" instead of ",78". There are minimum 4 and maximum 6 digits after decimal delimiter.
Currency	Currency code with format according to ISO-4217, e.g. "EUR"

Columns

A booking line contains the following data:

	Name	Format	Example	Description
1	Voucher Type		IN	"IN" for Invoice "CN" for Credit Note "IC" for Invoice Cancellation "CC" for Credit Note Cancellation Note: Outgoing self-billing credit notes are exported with voucher type "IN" in the file for payables.
2	Debit / Credit		D	Debit / credit indicator "D" for Debit "C" for Credit
3	Invoice Date	Date	14.03.2022	Invoice Date
4	Economic Date	Date	28.02.2022	Economic date of the invoice, which is derived from economic date of the shipment. Exception: aggregated invoices and incoming invoices.
5	Booking Date	Date	01.03.2022	Booking date of the invoice. Usually equals the economic date, unless the month was closed when the invoice was finalized. In this case it is the first of the open month.
6	Due Date	Date	31.03.2022	Due date of the invoice
7	Account Number	Alphanumeric	47110	Debtor/creditor account number of the customer/vendor.
8	Invoice Number	Alphanumeric	202200045	Invoice number
9	Shipment Number	Alphanumeric	02.22.1.00031	Shipment number
10	House Document Number	Alphanumeric	FRA-12345678	House-AWB (air) / House-BL (sea) of the shipment
11	Transport document number	Alphanumeric	020-12345678	(Master-)AWB (air) / Ocean-BL (sea) of the shipment
12	Cost Center	Alphanumeric	1001	Cost center of the shipment
13	Local Currency Code	Currency	EUR	Currency code local currency
14	Local Total Net Amount	Money	2415,34	Amount local currency (net)
15	Local Total Tax Amount	Money	458,91	Tax amount local currency
16	Local Total Gross Amount	Money	2874,25	Amount local currency (gross)
17	Invoice Currency Code	Currency	USD	Currency code invoice currency
18	Total Net Amount	Money	2768,95	Amount invoice currency (net)
19	Total Tax Amount	Money	526,10	Tax amount invoice currency
20	Total Gross Amount	Money	3295,05	Amount invoice currency (gross)
21	Exchange Rate	Rate	1,1464	Exchange rate to local currency
22	Tax Key	Alphanumeric	EX3	Tax key as maintained
23	Tax Rate	Rate	19	Tax rate in percentage
24	General Ledger	Alphanumeric	15007	General ledger as maintained
25	Vendor Invoice Number	Alphanumeric		Vendor invoice number
26	Name (optional column)	Alphanumeric		Customer/vendor name
27	Street (optional column)	Alphanumeric		Customer/vendor street
28	ZIP (optional column)	Alphanumeric		Customer/vendor ZIP code
29	City (optional column)	Alphanumeric		Customer/vendor city
30	State (optional column)	Alphanumeric	IL	Customer/vendor state code
31	Country (optional column)	Alphanumeric	US	Customer/vendor country code
32	Tax ID (optional column)	Alphanumeric	DE123456789	Customer/vendor tax ID
33	Booking Text	Alphanumeric		Accounts receivable: <invoice number> + <white space> + <shipment number> Accounts payable: <internal invoice number> + <white space> + <external invoice number> + <white space> + <shipment number>
34	Origin	Alphanumeric	SCP	Fixed value “SCP”

Example

Example for an outgoing invoice to a customer:

Receivable CSV file

Example CSV File