Format AR10
Last updated
Was this helpful?
Last updated
Was this helpful?
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
To configure Xledger file export see the common explanation in .
There are no additional fields to configure for this format.
The file is a CSV file where semi-colon (;) is used as the separator.
Date format: YYYYMMDD
Decimal separator: . (period)
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
Yes
5
E
2
Numeric (no decimals)
Yes
6
F
4
Numeric (no decimals)
Yes
Account
7
G
4
Numeric (no decimals)
Yes
8
H
5
Yes
Balance
9
I
15
Numeric (two decimals)
Yes
10
J
9
Numeric (no decimals)
Yes*
Supplier no.
11
K
9
Numeric (no decimals)
Yes*
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
23
W
1
Numeric
24
X
6
Project
25
Y
4
Payment terms
26
Z
4
27
AA
1
String
GrossSum
28
AB
20
Numeric (three decimals)
Extra
29
AC
1
String
x
*For ledger vouchers **For ledger vouchers
Numeric ()
Code
Numeric ()
Numeric ()
Numeric ()
Numeric ()