Guide

DeGiro CSV transaction types, decoded

The DeGiro account.csv uses Dutch descriptions for every row. This is the full list of what each one means and how FolioInsights classifies it.

Last updated: · by FolioInsights

DeGiro exports its account statement with a Dutch-language description column regardless of your UI language. Rows look like Koop 10 @ 435,44 USD or DEGIRO transactiekosten en/of kosten van derden. This is the reference for every string that appears there, grouped by category, with a note on how FolioInsights classifies each one.

Buy and sell

Koop — "Buy". The format is Koop {quantity} @ {unit price} {optional currency}, for example Koop 10 @ 435,445 USD. FolioInsights parses this as a Buy transaction and adds it to the weighted-average cost basis for that ISIN.

Verkoop — "Sell". Same format as Koop. FolioInsights computes the realized P/L as quantity × (sell price − avg cost) − fees and keeps the remaining position's cost basis unchanged.

Dividends

Dividend — Cash dividend payment. The mutation value is the gross amount credited before withholding tax. FolioInsights sums these per ISIN and per currency.

Dividendbelasting — Withholding tax on a dividend. Always a negative amount booked against the same ISIN as the dividend it offsets. FolioInsights subtracts this from the gross dividend in the Dividends KPI.

Fees and taxes

DEGIRO transactiekosten en/of kosten van derden — Per-trade commission. If the fee carries an Order Id that matches a Sell, FolioInsights folds it into that sell's realized P/L. Otherwise it counts toward total fees.

Transactiebelasting … — Financial transaction tax (e.g. Belgian or French stamp duty). Any row whose description starts with Transactiebelasting is classified as a transaction tax.

ADR/GDR externe kosten — Pass-through custody fee on American/Global Depositary Receipts. Treated as a non-trade fee.

DEGIRO aansluitingskosten … — Annual exchange-connectivity fee (€2.50 per exchange per year). Any row starting with DEGIRO aansluitingskosten is classified as a connectivity fee.

Corporate actions

WIJZIGING ISIN — ISIN change, usually from a rebrand, restructuring, or SPAC merger. The export contains two paired rows: WIJZIGING ISIN: Verkoop … on the old ISIN and WIJZIGING ISIN: Koop … on the new one. FolioInsights classifies both as ordinary Buy/Sell, which closes out the old position and opens the new one at the same economic cost basis.

FUSIE — Merger. Behaves identically to WIJZIGING ISIN: paired FUSIE: Verkoop … / FUSIE: Koop … rows close the acquired position and open a position in the surviving entity.

SPIN-OFF — Corporate spin-off: the original position stays and a position in the spun-off entity is created. Silently skipped by FolioInsights rather than misclassified, because there is no consistent price to compute a cost basis for the new shares from the CSV alone.

Conversie geldmarktfonds — Automatic conversion between money-market fund share classes by DeGiro. Not a portfolio event; silently skipped.

Verrekening van aandelen — Share settlement, typically after a corporate action finalises. Silently skipped because it does not represent a trade by the account holder.

Cash movements (ignored)

flatex storting / iDEAL storting — Cash deposit. Not a portfolio event, so FolioInsights skips it. Your net worth chart is based on securities, not cash balance.

flatex terugstorting — Cash withdrawal. Same handling as deposits — skipped on import.

If you see something else

DeGiro occasionally introduces new row types for new corporate actions or product conversions. If FolioInsights cannot classify a row it silently skips it rather than guess — open your CSV and check for any row that does not match the patterns above. The tool is deliberately conservative here because a wrong classification propagates into every downstream KPI.

Ready to try it?

Drop your DeGiro account.csv into the browser. One-time €19, lifetime access, your data never leaves your device.

See FolioInsights