DEGIRO Import transactions

English Installation & Start
1

Hello,

I’m a Dutch DEGIRO user and I’ve been trying to import my transactions and account statements using both PDF and CSV files. I’ve run into a lot of trouble and am close to giving up. The software seems to understand most data, except for my current stock holdings. Can anyone help me?

What I tried:

  • Transactions (CSV & PDF)

  • Account statements (CSV & PDF)

What I want: A complete overview of my current holdings and all historical transactions, including all associated costs.

The problem: The transactions.csv contains all stock trades, but it lacks data on dividends, Belgian transaction tax (TOB), and dividend tax. When I try to add the account.csv to include that information, the import fails or gives errors. I tried mapping everything manually, but the results remain incorrect.

Field Mapping for transactions.csv:

  • Datum / Tijd: Date and Time

  • Product / ISIN: Product name and ISIN code

  • Beurs / Uitvoeringsplaats: Stock exchange and venue of execution

  • Aantal: Amount/Quantity

  • Koers: Trade value (the field next to it contains the local currency)

  • Lokale waarde: Local amount (USD or EUR value)

  • Waarde EUR: Value in EUR

  • Wisselkoers: Exchange rate

  • AutoFX Kosten: Costs for automatic currency conversion

  • Transactiekosten: DEGIRO transaction fees

  • Totaal EUR: Total amount in EUR

  • Order ID: Unique order identifier

Note: In the CSV, buying a stock results in a positive amount, while selling is negative.

afbeelding
Note: Empty field Between koers and Localwaarde

Field Mapping for account.csv:

  • Valutadatum: Value date

  • Omschrijving: Description/Type of transaction

  • Mutatie / Saldo: These have two fields: the currency and the value itself.

Note: That mutation and saldo amount have 2 fields, the Valuata its in and the value itself

  • afbeelding

Transaction Types Translation:

  • Koop: Buy

  • Verkoop: Sell

  • Overboeking naar/van uw geldrekening: Cash transfer to/from the flatexDEGIRO account (deposits/payments)

  • Transactiebelasting België: Belgian transaction tax (TOB)

  • Dividend / Dividendbelasting: Dividend and dividend tax

Its seems the perfect app for tracking the portfolio but can’t seem to find out myself how to import it with Degiro. Any tips/help or configuration templates (json)?

2

Did you get it to work? After two or three days worth of work, I still do not get my data imported correctly.

3

If you want the importer to work with your documents. We do need to have a pdf debug.

Ideal state… diverent transactions → different debugs and please don’t forget a small desciption on what each debug should represent.

4

Try the attached.
As stated in the (Dutch) name, go to the transactions screen and filter (on dates) only. Export as CSV.

1_DeGiro_CSV_portfolio_transacties_alleen_filteren.json (868 Bytes)

5

For the Account Statement (rekeningoverzicht) part, mostly dividends and money transfers, I use the generic in-app PDF file import. Account Statement, filter (on dates) and export as PDF.

6

It’s not perfect, I’m open for any suggestions or improvements! :innocent: