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 |
5 | E | 2 | Numeric (no decimals) | Yes | |
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 |
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 | Numeric (StdReg_xxx.xls) | ||
Project | 25 | Y | 4 | Numeric (StdReg_xxx.xls) | |
Payment terms | 26 | Z | 4 | Numeric (StdReg_xxx.xls) | |
27 | AA | 1 | String | ||
GrossSum | 28 | AB | 20 | Numeric (three decimals) | |
Extra | 29 | AC | 1 | String | x |
*For ledger vouchers **For ledger vouchers
Last updated