Import bank statements

By downloading your bank statement as a CSV, CAMT.053 or MT940 file from your internet bank, you can upload all your bank transactions to Cash and bank in Visma eAccounting Pro. To import a comma-separated CSV file correctly, read more under Saving data in the CSV format below.

  1. Go to Cash and bank.
  2. Click the arrow next to New bank transaction and select Import bank statement.
  3. In the window that opens, choose Select file to upload or drop the file in the designated area.
  4. Select Add.

In certain cases when you upload a CSV file you will be asked to specify which columns in your bank statement that Visma eAccounting Pro should retrieve information from. If this is the case, you simply select the columns from the drop-down menus that correspond to Transaction date, Reference and Amount.

When the import is finished, matching accounting transactions to bank transactions will be automatically suggested for you to post to the ledger. The bank transactions are shown under All unreconciled bank transactions.

For imports to work problem-free, all data must be saved in the correct way in a comma-separated CSV file, where each row corresponds to one bank transaction. In Microsoft, the file is called CSV comma separated or CSV comma delimited, depending on which Office package you have installed. In Mac, the same format is called Windows comma delimited (.CSV).

The format in which your exported information is created can vary slightly depending on the program, but you can format it so the information can be imported into Visma eAccounting Pro. The separator which goes between each element can be either one of the characters ; , . :. A negative value is always preceded by a minus sign.

To import a bank statement in the CSV format, the file must at the very least include a column with dates in one of the standard date formats, for example DD-MM-YYYY, one column with amounts as well as one column including references.


04-06-2019;Invoice123;123,25
02-06-2019;"Payment supplier";-500,00
01-06-2019;Invoice122;100,00
01-06-2019;Invoice 99;123,25

Related topics

Bank transactions