Tripletex supports two types of GBAT10 import:
- Tripletex generates the VAT postings. The VAT code mapping in Tripletex maps the external VAT codes to Tripletex’ VAT codes. Rows with gross amount type = F are ignored. The gross amount (including VAT) is used for postings with VAT.
- Tripletex imports the VAT postings even if the gross amount type = F. Postings are imported without VAT codes. The postings will not affect the VAT return. The net amount (excluding VAT) is used.
Voucher number
Tripletex creates number series for each external voucher type. The base number for the number series is 1 000 000 + [voucher type] * 10 000. The number series’ name is: Mamut [voucher type]. The external voucher number will be added to the base number when the Tripletex voucher number is generated.
Example:
External voucher number: 100 001
External voucher type: 10
The Tripletex number series “Mamut 10” will be created with base number: 1 000 000 + 10 * 10 000 = 1 100 000.
Tripletex voucher number: 1 100 000 + 100 001 = 1 200 001.
Gross amount vs. net amount
The net amount (column 9) specifies the amount excluding VAT.
If Tripletex generates the VAT postings, the gross amount (column 28) specifies the amount including VAT.
IMPORTANT: The net and gross amounts must always balance (sum = 0).
Customer information
The customer number (or name) identifies a customer. The customer is created or updated.
Invoice information
Invoice information is ignored. Tripletex have another import format for invoice import.
|
Column |
Description |
Comment |
|
1 |
Identification |
Always GBAT10. Identifies the file format. |
|
2 |
Voucher number |
The voucher number will be added to the Tripletex number series base number. |
|
3 |
Voucher date |
Format: YYYYMMDD |
|
4 |
Voucher type |
A number series is created for each voucher type. |
|
5 |
Ignored. |
|
|
6 |
Ignored. |
|
|
7 |
Account number |
|
|
8 |
VAT code |
|
|
9 |
Net amount |
Ignored if Tripletex generates the VAT postings. |
|
10 |
Customer account number |
|
|
11 |
Supplier account number |
|
|
12 |
Customer/supplier name |
|
|
13 |
Customer/supplier address |
|
|
14 |
Customer/supplier postal number |
|
|
15 |
Customer/supplier city |
|
|
16 |
Ignored. |
|
|
17 |
Ignored. |
|
|
18 |
Ignored. |
|
|
19 |
Ignored. |
|
|
20 |
Ignored. |
|
|
21 |
Ledger description |
|
|
22 |
Ignored. |
|
|
23 |
Ignored. |
|
|
24 |
Project number |
Refers to the project’s external account number or the project number. |
|
25 |
Department number |
Refers to the department’s external account number or the department number. |
|
26 |
Ignored. |
|
|
27 |
Gross amount type |
T or F. If Tripletex generates the VAT postings, then F indicates that this row should be ignored. |
|
28 |
Gross amount |
Ordliste:
VAT – mva
VAT posting – mva-postering
Voucher – bilag
Gross – brutto
Net = netto
Customer – kunde
Supplier – leverandør
Ledger – reskontro
Department – avdeling