Importing bank transactions

You download a statement file from your bank and import it into TELMAAR. After that you see every credit and debit, and you can match them to your invoices.

What you need

A bank account in TELMAAR. If you do not have one yet, first click Add bank account and fill in your IBAN, the name of your bank and the currency.
A file from your bank: a CSV file or an MT940 file. Both work. You download it in your bank's online banking, usually under Download or Export.
The role of owner, finance manager or bookkeeper. Other roles can look on, but cannot import.

CSV or MT940, which one do you pick

MT940 is the banking format: the columns are fixed, so there is nothing to set up. If your bank can supply it, choose MT940.

CSV is an ordinary table file. Every bank arranges the columns differently, so after uploading you tell us once which column holds the date, which holds the amount and which holds the description.

How to do it

1Go to Bank and then Transactions.
2Click Import transactions at the top right.
3At the top, choose the bank account this file belongs to.
4Choose the CSV tab or the MT940 tab.
5Click the file field and pick the file you downloaded from your bank.
6For CSV only: point out the columns. Date, amount and description are required; counter account and IBAN may stay empty.
7Click Import. You get a message when it worked and the transactions appear in the list.

What you see afterwards

Above the list there are filters: Open, Reconciled and Ignored. New transactions are Open.

Every open transaction has two buttons: one to match it to an invoice and one to ignore it. You use Ignore for lines that have nothing to do with your bookkeeping, for example a transfer between your own accounts.

Not working?

The Import transactions button is not there.: That button only appears once there is at least one active bank account. Click Add bank account first and fill in your IBAN.
With a CSV file the message keeps saying that the columns are required.: Date, amount and description all three have to be assigned. If the drop-down lists are empty, the file has no header row with column names. Export it again at your bank with column headers, or choose MT940.

Last checked on 28 August 2026