Beanvest
Login

Import transactions from a csv

How to format your csv file

In order to successfully import your transaction in Beanvest, your csv file needs to have the following columns:

  • Type transaction, "Buy" or "Sell"
  • Symbol and/or ISIN of the stock
  • Price at which you bought or sold
  • Units is the quantity bought or sold
  • Date of the transaction
  • Exchange (optional) can be useful to match the symbol if present on mutiple exchanges
  • Fee (optional) additional fees of the transaction
  • Description (optional) any more info to save

Beanvest will try to match each transaction using the ISIN in priority, or with the symbol and exchange if they are present.

How to import transactions from a csv file

  1. Select your csv file to import it

CSV upload

  1. Beanvest will try to match the columns from your csv. You might need to do some manual matching between your columns on the left, and Beanvest's fields on the right.

CSV matching

Sometime, you might also need to match values for each column, to values in Beanvest.

  1. Click on the "Continue import" button, and verify your imported lines.

Sometimes, Beanvest might not be able to import some of the lines when no corresponding security has been found :

CSV Failed

You can either add these lines manually, or modify your csv to include the ISIN. If an ISIN is not found, don't hesiate to reach out.

  1. Finally, click on the last "Import transactions" button.

How to export transactions in csv

Here are some detailled guide on how to export transactions in csv with different brokers (Degiro, Interactive Brokers, ...) :

Degiro

Note: Premium users have access to a real-time Degiro integration

Here's a guide to export all your transactions in a csv file from Degiro. You can go here directly of follow the steps below :

  1. Go to "Activity" > "Transactions" in the left menu

Degiro transactions tab

  1. Select a date range, and click on the "Export" button on the right:

Degiro transactions Export

  1. Choose "csv" to export the selected transactions:

Degiro export modal

Interactive brokers

  1. In the menu, click on "Exports" > "Flex Queries" (or click here directly)

Interactive Brokers menu

  1. In "Activity Flex Query", click on the + sign icon on the right :

Interactive Brokers menu

  1. In the "Create an Activity Flex Query" section, enter a new name in the "Query Name" field such as "CSV export"

  2. In "Sections", scroll and click on "Trades"

Interactive Brokers trades

  1. In the newly opened window select the following columns :
  • Currency
  • Symbol
  • Description
  • ISIN
  • Listing Exchange
  • Trade Time
  • Quantity
  • TradePrice
  • Buy/Sell

Interactive Brokers menu

Then click save.

  1. Below, in "Delivery Configuration" change the format to "csv"

  2. Also change the "period" to make sure you export all transactions

  3. In "General Configuration", change the "Date Format" to yyyy-mm-dd

  4. Click on the "Continue" at the bottom

  5. Click on the "Create" button at the bottom

  6. Go back to "Flex Queries" and click on "Run" on the right:

Interactive Brokers Run

  1. In the final export, window select a period and CSV format. Then click "Run" to download:

Interactive Brokers Export

Bourse Direct

Unfortunately, Bourse Direct does not have any way to export your transactions in csv at the moment. You will need to create them manually.

The best way to find them is to go to Avis d'opérés and click day by day to see them.

Last update on December 4, 2021

Start tracking your investments today

14-day Premium trial, 100% free after. No credit card required