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 Standaard. 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. Select New bank transaction - 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 Standaard 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, the program automatically searches for accounting transactions which match the bank transactions and suggests matches 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 Standaard. 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.

Date;Reference;Amount
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

Register bank transactions