Scope CSV Interface Format

General

Scopes default text interface will export all voucher data in one file. For each voucher a set of lines is generated.

These are the main differences compared to the newer Scope Accounting CSV Interface Format (you can learn about here: Scope Accounting CSV Interface)

Such a set of lines consists of:

One line for the voucher itself, containing total amounts and general information of the voucher.
One line per charge line of the voucher, containing the charge lines information.
One line for each taxable (percentage > 0%) tax on the voucher, to correctly book tax amounts to tax accounts, if necessary. Reverse Charge charge is treated as 0%, and will not create such a line.

All lines will separate their different values with a semikolon ';'.

Escaping

If the semikolon ; 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.

Value	In Outputfile
`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";`

Voucher Types

To distinguish different voucher types the following table is used:

Voucher type	Code
Outgoing Invoice	AR_INV
Outgoing Invoice Cancellation	AR_INV_C
Outgoing Credit Note	AR_CN
Outgoing Credit Note Cancellation	AR_CN_C
Incoming Invoice	AP_INV
Incoming Invoice Cancellation	AP_INV_C
Incoming Credit Note	AP_CN
Incoming Credit Note Cancellation	AP_CN_C

Formats

Reoccurring formats:

Format	Meaning
Date	yyyy-MM-dd
Money	(-)n.n The decimal of the monetary amount (without currency code). E.g. "136.00" when the amount is 136 USD, but "136" when the amount is 136 JPY. 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".
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".

The Voucher Line

The voucher line will contain following data

#	Name	Format	Length	Example	Description
1	Identifier		1	V	To identify the line as a 'voucher line'. Always 'V'.
2	Number		128	AR-0029	The voucher number assigned by Scope upon printing/finalizing.
3	Account		16	15007	The debit/credit account number of the customer/vendor.
4	Type code	As per table	8	AR_INV	The type code as per table.
5	Voucher type		1	D	"A" for accrual vouchers "I" for internal vouchers "C" for cash register vouchers "U" for customs vouchers (ATLAS CusTax, EDec Acceptance) "K" for Kick-Back vouchers "S" for self-billing credit notes "D" for all other vouchers
6	Vendor reference		255	2001902	The vendors reference, as entered in the accounts payable editor.
7	Original number		128	AR-0028	Scopes original number, if this is a cancellation.
8	Document date	Date	10	2011-07-23	The document date. Outgoing voucher: when printed. Incoming Vouchers: as entered in the editor
9	Economic date	Date	10	2011-06-29	The economic date of the voucher. Derived from economic date of order, exception: Exception: aggregated invoices and incoming invoices.
10	Booking date	Date	10	2011-07-01	The booking date of the voucher. Usually equals the economic date, unless the month was closed when the voucher was finalized. In this case it is the forst of the open month.
11	Due date	Date	10	2011-08-02	The due date of the voucher.
12	Payment type		32	TRANSACTION	Either 'TRANSACTION', 'CASH', 'CHECK', 'DIRECT_DEBIT', 'CREDIT_CARD', 'DEBIT_CARD', 'UNKNOWN' or 'CORRECTION' In Mexico the values 'COMPENSATION' and 'NA' are also possible.
13	Payment reference		255	AHJ-2787	As entered by the user, if payment type is cash or check.
14	Exchange rate	Rate	32	1.36	The exchange rate as entered in the vouchers editor.
15	Currency	ISO-4217 code	3	USD	The currency code of the vouchers currency.
16	Net amount	Money	32	136.00	The net amount of the voucher, in the vouchers currency.
17	Total amount	Money	32	136.00	The total amount of the voucher, in the vouchers currency.
18	Net amount local	Money	32	100.00	The net amount of the voucher, in local currency.
19	Total amount local	Money	32	100.00	The total amount of the voucher, in local currency.
20	Owner code		128	RSIDUS	The code of the partner of the vouchers branch.
21	VatID		255	DE189271829	The VAT-ID number if the customer/vendor.
22	Address name 1		255	Riege Software	The first line of the voucher addresses name.
23	Address name 2		255		The second line of the voucher addresses name.
24	Address name 3		255		The third line of the voucher addresses name.
25	Address street 1		255	Mollsfeld 10	The first line of the voucher addresses street.
26	Address street 2		255		The second line of the voucher addresses street.
27	Address street 3		255		The third line of the voucher addresses street.
28	Address po box		255		The PO Box, if a PO-Box address.
29	Address country	ISO-3166	2	DE	The country code of the voucher addresses country.
30	Address ZIP		255	40670	The ZIP code of the vouchers address.
31	Address city		255	Meerbusch	The City of the vouchers address.
32	Origin voucher number		128	AR-0028	(Only available, if activated in the interface settings): Scopes original number, if this voucher relates to another one

The Charge Line

The charge line will contain the following data:

#	Name	Optional Column	Format	Length	Example	Description
1	Identifier			1	L	To identify the line as a 'charge line'. Always 'L'.
2	Account			32	5500	The general ledger account number.
3	Amount		Money	32	136.00	The charge lines amount in the vouchers currency.
4	Amount local		Money	32	100.00	The chage lines amount, in local currency.
5	Tax key			32	01	The tax key as per maintained tax key filter.
6	Order reference			255	AE-1900192	The reference of the order booked on.
7	Cost center			32	AEDUS	The cost center of the order booked on.
8	Economic date		Date	10	2011-06-29	The economic date of the charge lines order
9	Transport document number			35	020-12345678	Master-AWB (air) / Ocean-BL (sea) of the charge lines shipment or House-AWB, if present, else Master-AWB (air) / House-BL, if present, else Ocean-BL (sea) of the charge lines of the shipment
10	House document number			35	FRA-12345678	House-AWB (air) / House-BL (sea) of the charge lines shipment
11	Charge type code			6	AF
12	Charge type name			255	Air freight
13	Unit qualifier				KGM	Unit qualifier, if a rate is available in Scope. Otherwise empty · Weight units: GRM, KGM, TNE, LBR · Volume units: CMQ, DMQ, LTR, MLT, MTQ, INQ, FTQ
14	Base units				1.0	The base units for the given net rate
15	Net rate				1.50	The net rate to calculate the charge line amount
16	Line exchange rate				1.0	The exchange rate to convert the charge line amount into voucher currency.
17	Tax code				VAT	Scope tax code
18	Tax percentage				0.0	Tax percentage
19	Tax reason code				EX	Tax reason codes: · RC: Taxfree due to reverse charge EU · RC3: Reverse Charge Third Country · RCI: Reverse Charge India · 3C: Taxfree because the invoice is issued to third country · OS: Taxfree due to offshore tax relief agreement · EX: Taxfree due to export from EU to outside EU · IM: Taxfree due to import from outside EU to inside EU · 3T: Taxfree due to transport between two third countries. (Transport completely outside EU) · NT: A not taxable charge, or if no other reason can be specified · DT: Taxfree due to duties charge type · TX: Taxfree, because the charge is already a tax · BG: Taxfree due to transport of bonded goods · IN: Taxfree due to internal invoice · EMB: Taxfree because the invoice receiver is a diplomatic institution · BO: Taxfree due to Italian stamp duty taxes (Imposta di Bollo)

The Tax Line

The tax line will contain following data:

#	Name	Format	Length	Example	Description
1	Identifier		1	T	To identify the line as a 'tax line'. Always 'T'.
2	Account		32	15006	The tax account as per maintained tax key filter.
3	Tax key		32	19	The tax key as per maintained tax key filter.
4	Amount	Money	32	19.00	The tax amount in vouchers currency.
5	Amount local	Money	32	19.00	The tax amount in local currency.

Example 1

Example for an outgoing invoice to a local customer in local currency with one line VAT and one line tax-free.

Example 1

Example 2

Example for a tax-free outgoing invoice to a local customer in local currency. It shows the optional line level columns 11 to 19

Example 2

Scope CSV Interface Format

This accounting interface is also known as Scope CSV.

General

Escaping

Voucher Types

Formats

The Voucher Line

The Charge Line

The Tax Line

Example 1

Example 2