How to import vouchers with Mamut GBAT10 format – Tripletex hjelpesenter

Supported file types for voucher import is CSV- and TXT-files.

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’s 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.

Description of file format

Columns with bold are required.

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	Insert T (TRUE) if Tripletex generates the VAT postings. Insert F (FALSE) to ignore the row.
28	Gross amount

Voucher number

Tripletex creates a 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 the 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.

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 has another import format for invoice import.

Mapping of VAT codes

Mapping means attaching external VAT codes to Tripletex VAT codes. This simplifies the import so that when you import a voucher where you used for example VAT code 1 in the external (other) system we will connect it to VAT code 0 in Tripletex which has the same effect.

The mapping of VAT codes is found in the section «VAT settings».

VAT code: Insert Tripletex VAT code
External VAT code: Insert VAT code from the other system

Skjermbilde 2024-11-22 kl. 10.43.14.png