If bank transactions are missing and the account has no bank integration, you can upload a bank file directly in the bank reconciliation. The file can be in CSV, Excel or TXT format. You can use the file from your online bank, or make the file yourself if your bank isn't on the list below.
How to upload the bank file
Export the transactions from your online bank, or make the file yourself (see Making the bank file yourself below).
Go to Bank → Bank reconciliation and choose the bank account and month at the top of the page.
Click Upload bank-file to import transactions in the transaction list.
Catacloud recognises the file from your online bank by the way the bank has laid it out. Upload it exactly as it came from your online bank – don't open it and save it again in Excel first.
You can upload one file per bank account and month. If you uploaded the wrong file, click the arrow next to Approve reconciliation and choose Remove bank-import. You can then upload again.
Which banks are supported?
The file from your online bank can be uploaded directly from these Norwegian banks:
DNB
SpareBank 1
Sbanken
Eika banks
Danske Bank
Nordea (see the note below)
Nordea: Nordea has changed the layout of its transaction history file. Catacloud currently rejects the new file, and we are working on adding support for it. Until then, you can make the file yourself (see below) or use a PDF via the voucher inbox.
If your bank isn't on the list, you can make the file yourself.
Making the bank file yourself
You can make the file in Excel, for example. It must have five columns, one row per transaction and no header row:
Booking date – written DD.MM.YYYY, for example 30.11.2026
Value date – written DD.MM.YYYY (use the booking date if you don't have it)
Text – the text to show on the transaction
Amount – money in as a positive amount, money out with a minus sign
Balance – the account balance after the transaction
Example of a finished file:
30.11.2026;30.11.2026;Rent November;-12500,00;48350,00
15.11.2026;15.11.2026;Payment invoice 1001;25000,00;60850,00
02.11.2026;02.11.2026;Electricity October;-1650,50;35850,00
Important:
Save the file as CSV with a semicolon (;) between the columns.
Choose CSV UTF-8 when you save in Excel. Otherwise æ, ø and å in the text may come out wrong.
Write the amounts without a thousands separator and without «kr», for example -12500,00.
Put the newest transaction at the top. The balance on the first row is used as the outgoing balance for the month.
Every row must have valid dates in the first two columns. A header row or an empty date cell makes the file be rejected.
Posting the transactions as an advanced voucher
Once the transactions are uploaded, you can post them without typing the lines in again:
Tick the bank transactions you want to post. Don't tick anything on the ledger side.
Click Post transactions and choose Advanced voucher under New voucher.
The date, text and amount against the bank account are already filled in. Add the contra account on each line and post the voucher.
If the file is rejected
If the file from your online bank is rejected, it usually means the bank isn't supported or the bank has changed its format. You can then do one of the following:
Make the file yourself: See Making the bank file yourself above.
Post the bank statement as a PDF: Upload the PDF to the voucher inbox and select voucher type Bank statement. Select the correct period (year and month) and the correct account. Fill in the Outgoing balance before you save and post the bank statement.
Connect your bank to Catacloud: With bank integration, transactions are fetched automatically every morning, so you don't need to upload files.
If a file you made yourself is rejected, check that it has no header row, that the dates are written DD.MM.YYYY and that it has exactly five columns.
See Which banks does Catacloud support? and ZTL or Aritma – which bank integration should you choose?
See also
When should you contact us?
Is the file rejected even though your bank is on the list and you uploaded it unchanged? Contact us in the chat and provide:
Client name
Account number
Period (month/year)
Exact error message
The more specific the information, the faster we can help.