Import bank statements

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

If you cannot download a CSV file from your bank, you can instead copy and paste your bank statement into Visma eEkonomi Smart. Read more in Copy and paste bank statements.

Please note that the file must be saved as a comma-separated CSV file for you to be able to import it to Visma eEkonomi Smart. You can read more about how to save a file as a CSV file 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 eEkonomi Smart 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 eEkonomi Smart. 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 ÅÅÅÅ-MM-DD, one column with amounts as well as one column including references.

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

Related topics

Register bank transactions

Work smarter

This is how you can work most effectively

9 tips to take your company from liquidity problems

Take a look at our education website

Find an accounting office

Video tutorials

See all movies about Visma eEkonomi Smart

Support forum

Discover Visma eEkonomi - accounting and invoicing on autopilot!