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
Account
7
G
4
Numeric (no decimals)
Yes
Balance
9
I
15
Numeric (two decimals)
Yes
Supplier no.
11
K
9
Numeric (no decimals)
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
GrossSum
28
AB
20
Numeric (three decimals)
Extra
29
AC
1
String
x
*For ledger vouchers **For ledger vouchers
Last updated