Accounting GBAT10 export

GBAT10 is a file format for importing vouchers into an accounting system, mostly used in Norway.

Cardboard’s GBAT10 export allows you to import the payments done via Cardboard to accounting systems like Visma eAccounting, PowerOffice, Tripletex, and 24SevenOffice without setting up an accounting system integration.

This tutorial assumes that you have already configured Cardboard for accounting as described in Accounting settings in Norway.

Exporting

Your monthly payments can be exported from Cardboard to a GBAT10 file by following these steps:

1. Navigate to Accounting > Export.
2. Selecting the month you want to export.
3. Click the button labeled GBAT10.

Importing

How to import the GBAT10 file varies from accounting system to accounting system. Please refer to your accounting system's documentation if you don't find any specific instructions below.

Importing to Tripletex

In Tripletex, navigate to Voucher > Import and enter the following details:

1. Select “Mamut GBAT10” as the File type.
2. Select “UTF-8” as the Encoding.
3. Select “Let Tripletex generate VAT entries”, but deselect “External VAT code 1 specifies VAT codes in Tripletex without VAT”.
4. Make sure to fill in the correct “VAT settings” as explained in the section below and press “Save” on the bottom right of the screen.
5. Upload the file exported from Cardboard.
6. Press “Import” on the bottom left of the screen.

Tripletex VAT settings

Cardboard payments are associated with one of six different VAT codes: 1, 13, and 86-89. Due to special handling of VAT code 1 in Tripletex, Cardboard exports such payments with VAT code 101 instead, and you must therefore create a mapping from external VAT code 101 to VAT code 1 in Tripletex. All other VAT codes are mapped directly, thus resulting in the following VAT settings:

• VAT code 1 -> External VAT code 101
• VAT code 13 -> External VAT code 13
• VAT code 86 -> External VAT code 86
• VAT code 87 -> External VAT code 87
• VAT code 88 -> External VAT code 88
• VAT code 89 -> External VAT code 89