Looking for a template to import vouchers into Catacloud? You can import vouchers from a file in the GBAT10 format. Download the example file at the bottom of this article and replace its content with your own vouchers. Here is how the file should look and how to import it.
What is a GBAT10 file?
GBAT10 is a text file where each line is one posting, and the fields are separated by semicolons (;). Many payroll and accounting systems can create this file. You can also make it yourself in Excel and save it as CSV.
Lines with the same voucher number become one voucher in Catacloud.
If you already have a GBAT10 file from Mamut or another system, you can import it as it is. The VAT code is then taken from the account in Catacloud, and project and department (columns X and Y) are not included.
How to build the file
Use one row per posting and no header row. These columns are used (the column letters apply when you make the file in Excel):
A: the text GBAT10
B: voucher number – all lines with the same number become one voucher
C: date as YYYYMMDD, for example 20261031
D–F: can be left empty
G: account number
H: VAT code (0 for accounts without VAT)
I: amount – positive is debit, negative is credit
J–T: can be left empty
U: posting text
V–Z: can be left empty
AA: the letter T
AB: the same amount as in column I
Important: Column AA must contain T and column AB the amount. If they are missing, the line is skipped.
Debit and credit must balance to zero for each voucher. The VAT code is taken from the account in the chart of accounts. If the account has a locked VAT code, the code in the file must be the same.
Example file
The example file gbat10-eksempel.csv is at the bottom of this article, under Download the example file. It contains two finished vouchers: a bank fee and interest income. Open it in Excel, replace the date, accounts, amounts and text with your own, and save it again as described below. The accounts in the example (7770, 1920 and 8050) must exist in your chart of accounts.
This is the first voucher when the file is opened in Notepad:
GBAT10;1;20261031;;;;7770;0;250.00;;;;;;;;;;;;Bankgebyr oktober;;;;;;T;250.00
GBAT10;1;20261031;;;;1920;0;-250.00;;;;;;;;;;;;Bankgebyr oktober;;;;;;T;-250.00
Saving the file from Excel
Choose Save As and the file type CSV (semicolon delimited). Do not upload the Excel file (.xlsx) directly.
Open the file in Notepad and check that the amounts use a full stop as the decimal separator (250.00), not a comma (250,00), and that there are no spaces in the amounts.
Also check that there are no lines with only semicolons (;;;;;) at the bottom of the file. Excel creates such lines when something has been in the rows below the vouchers. Delete them.
Note: If an amount uses a comma, only the part before the comma is read. So 250,50 becomes 250.
How to import the file
Go to Accounting → Voucher inbox.
Click the arrow next to Upload and choose Import.
Leave Type set to GBAT10.
Choose the Encoding format. If you saved the file as a regular CSV from Excel, choose ISO-8859-1. If you saved it as CSV UTF-8, choose UTF-8.
Click Find files and select the file.
If you want the vouchers posted straight away, turn on Auto post voucher. Otherwise they end up in the voucher inbox, where you can review them before posting.
Click Import.
Tip: First import a file with one voucher, without Auto post voucher. Open the voucher and check the accounts, amounts and VAT before you import the rest.
Why does the import fail?
The import stops and no vouchers are created if:
The account does not exist: an account number in the file is not in your chart of accounts. Create the account or correct the number. Also check that the account number is in column G.
Account 0 does not exist: if the error message says that account 0 does not exist, the file has lines with only semicolons at the bottom. Delete them, see Saving the file from Excel.
Locked VAT code: the account has a locked VAT code, and the file has a different code.
Locked period: a date in the file is in a period that is locked.
If you get neither an error message nor any vouchers, the file is usually not semicolon delimited. It may have been uploaded as an Excel file (.xlsx) or saved as CSV with commas. Save it again as CSV (semicolon delimited).
If you see no error message but some lines are missing from the voucher, column AA is usually missing the T.
A KID (Norwegian payment reference) that is not valid does not stop the import. It is just not saved as the KID on the invoice.
Only a few vouchers? Record them manually instead
If it is only a few vouchers, it is often quicker to record them as an Advanced voucher directly in the voucher inbox.
Read more
When should you contact us?
Contact us in the chat if the import does not go through after you have checked the points above. Please include:
client,
the exact error message,
which system the file comes from,
and attach the file if you can.
Download the example file
Click the file name below to download the example file. Open it in Excel or Notepad and replace the content with your own vouchers. The posting texts in the file are in Norwegian – replace them with your own.