Format AR10

The AR10 format is also known as GBAT10 or Mamut. The format is widely used for accounting exports in many systems.

Moment are transferring data as described in the table below

Configuration

To configure Xledger file export see the common explanation in here.

There are no additional fields to configure for this format.

File

The file is a CSV file where semi-colon (;) is used as the separator.

Format

• Date format: YYYYMMDD

• Decimal separator: . (period)

Columns

Description	Column Number	Column in Excel	Max length	Comment	Required
Identification	1	A	6	Always: GBAT10	Yes
Voucher no.	2	B	8	Numeric.
Voucher date	3	C	8	Date	Yes
Voucher type	4	D	3	Numeric (StdReg_xxx.xls)	Yes
Period	5	E	2	Numeric (no decimals)	Yes
Accounting year	6	F	4	Numeric (no decimals)	Yes
Account	7	G	4	Numeric (no decimals)	Yes
VAT Code	8	H	5	Numeric (StdReg_xxx.xls)	Yes
Balance	9	I	15	Numeric (two decimals)	Yes
Customer no.	10	J	9	Numeric (no decimals)	Yes*
Supplier no.	11	K	9	Numeric (no decimals)	Yes*
Contact	12	L	30	String	Yes**
Address	13	M	200	String
Postal code	14	N	30	String
Postal place	15	O	30	String
Invoice no.	16	P	25	String
KID	17	Q	30	String
Due date	18	R	8	Date
<N/A>	19	S		[Blank]
Bank account	20	T	20	String
Description General ledger	21	U	100	String
Description Ledger	22	V	100	String
Interest invoicing	23	W	1	Numeric
Department	24	X	6	Numeric (StdReg_xxx.xls)
Project	25	Y	4	Numeric (StdReg_xxx.xls)
Payment terms	26	Z	4	Numeric (StdReg_xxx.xls)
Gross	27	AA	1	String
GrossSum	28	AB	20	Numeric (three decimals)
Extra	29	AC	1	String	x

*For ledger vouchers **For ledger vouchers