How to Export Your Transaction History from DeGiro (And What Every Column Means)

Sooner or later every DeGiro user needs their full history out of the platform — to file taxes, to calculate what they've actually earned, or to move into a tracker that shows more than a single green number. And sooner or later they discover the same thing: the file they need is buried in the menus, its columns are in Dutch no matter what language the app is set to, and nowhere in it is the one number they probably wanted — their profit or loss per position.

This guide fixes that. Below is the exact path to export the one file you need, a plain-English breakdown of every column, and the handful of traps that quietly corrupt most people's return calculations. StockDashes is built to parse these exports, so the traps section comes from handling real files.

The only file you need: the Account Statement

Most guides — and most other trackers — tell you to export two separate files: a "Transactions" file for your trades and an "Account Statement" for everything else. You don't need to. The Account Statement is the complete ledger. It already contains your buys and sells, plus your dividends, fees, deposits, withdrawals, currency conversions and corporate actions, all in one file. The separate Transactions export is just a tidier-looking subset of data the Account Statement already holds. One file, full history — that's all it takes.

Here's how to export it:

1. Log into the DeGiro web platform on a desktop (the mobile app is more limited).
2. Hover over or click Inbox in the left-hand menu, then open the Account statement tab (Rekeningoverzicht on the Dutch platform; it sits next to Orders and Transactions).
3. Set the period with the Start date and End date fields (Begindatum and Einddatum on the Dutch platform). The quick buttons only go back three months, so enter the day you opened your account as the start date and today as the end date. The toggle that hides background transactions doesn't matter here: the export contains the same rows (cash sweep transfers included) whether it's on or off.
4. Click the download icon at the top right — it has no label. In the Export dialog that opens, choose XLS (the file downloads as .xlsx) — that's the format StockDashes reads. CSV and PDF are offered too: PDF is only for reading, and CSV is only worth it if you want the raw file in your own spreadsheet (see the quirks below).

That's the whole export. You'll likely see a separate Transactions export sitting in the same menus — you can ignore it for tracking, because everything in it is already in the Account Statement.

Got your export? Import it into a free StockDashes account to see your real, time-weighted return, in euros or US dollars. It prices US-listed holdings and European shares that also trade in the US, like ASML or Shell.

Create a free account and import your statement →

If you exported as XLS, you can open it in Excel and it'll look fine. Only if you chose CSV for your own spreadsheet do these two quirks apply:

• DeGiro's CSV uses semicolons as separators, not commas — so if you double-click it and the columns look mangled in Excel, that's why. Import it as a semicolon-delimited file.
• Numbers and dates in the CSV use Dutch formatting regardless of your app language: dates as dd-MM-yyyy, and a comma as the decimal separator (so 1.234,56 means one thousand two hundred thirty-four and fifty-six cents). This trips up a lot of spreadsheet imports.

What every column means

The Account Statement crams every type of event into one table and leans on a Dutch description column to tell them apart. That description is the key to the whole file — it's what tells you whether a row is a buy, a sale, a dividend, a fee, a deposit or a corporate action. The export has these twelve columns, in this order (the on-screen statement shows a slightly different set). Two of them have no header at all:

A few things that live in that description column:

• Deposits and withdrawals — your own money in and out (often referencing iDEAL or a bank transfer).
• Dividends — and, separately, the dividend tax withheld on them.
• Fees — transaction costs, connection/exchange fees, currency-conversion charges.
• Corporate actions — mergers (you'll literally see FUSIE) and ISIN changes (WIJZIGING ISIN) when an instrument's identifier is reassigned.

The one thing the Account Statement does not give you is your cost basis or your profit. It tells you what you bought and sold and what cash moved — never what you actually made on a position. That you have to compute yourself, which brings us to where it goes wrong.

The four traps that quietly break most return calculations

This is the part the other export guides skip. If you're rebuilding your performance from this file — by hand or in a spreadsheet — these are the things that will silently give you a wrong answer.

1. ISIN is not a ticker. DeGiro identifies every instrument by its ISIN (e.g. US0378331005), not its ticker (AAPL). If you want live prices or to match positions against a benchmark, you have to translate every ISIN to a ticker first. There's no ticker column to lean on.

2. Your deposits are hiding in a text field — and not every match is real. To separate your own contributions from market gains (essential for any honest return figure), you have to fish deposits out of that Dutch description column. The trap: if you just search the text for a keyword like "iDEAL", you'll also catch reservation and pending rows that look like deposits but aren't actual cash in. Those phantom deposits inflate your contributions and deflate your return. You need to match the exact row type, not just a substring.

3. Currency is split across rows, not tidied into columns. A foreign trade and its currency conversion show up as separate lines, each in its own currency, with the FX rate applied separately. If you treat a dollar amount as if it were euros — or apply today's exchange rate to a trade from two years ago — you corrupt both your total return and your ability to see how much of your gain was the stock versus the currency.

4. Same-day round trips and row order. DeGiro's files aren't guaranteed to be in chronological order, and if you process a same-day sell before its matching buy, your accounting briefly goes negative and you end up with a phantom open position that was never really open. Anything using FIFO to separate realized from unrealized gains has to sort correctly first.

None of these is exotic. They're just the difference between a number you can trust and one you can't.

By hand, or the shortcut

You can absolutely do all of this in a spreadsheet. Export the Account Statement, translate the ISINs, strip out the phantom deposits, convert every trade at the right historical FX rate, sort everything chronologically, and run FIFO to get realized versus unrealized. It's a weekend the first time and an hour every month after.

Or you can skip it. StockDashes takes your Account Statement export and does each step above — resolving ISINs, separating deposits from trades, applying historical FX and fees, ordering same-day trades — then calculates your time-weighted return against a benchmark. It's free, and you never hand over your broker password. It prices US-listed holdings and European shares that also trade in the US.

If you want to understand why the numbers matter once you have them, read why DeGiro doesn't show your real return. And if you're a Saxo user too, the same field-by-field treatment for Saxo's report is here.

Frequently asked questions

Which DeGiro file do you need to track your portfolio? Just the Account Statement. It already contains your buys and sells along with dividends, fees and deposits, so you can ignore the separate Transactions export.

Should you export from DeGiro as CSV or XLS? XLS: that's the file StockDashes reads, and it also avoids the semicolon separators and Dutch decimal formatting that can mangle the CSV version in Excel.

Why doesn't DeGiro show my profit per position? DeGiro records what you bought and sold and what cash moved, but it never stores your cost basis. Profit or loss has to be calculated from the Account Statement yourself.

What date range should you export? From the day you opened your account through today, so you capture your complete history in one file.

Which holdings can StockDashes price? US-listed shares and ETFs, and European shares that also trade in the US, like ASML or Shell. Your other holdings, such as UCITS ETFs like IWDA or VWCE, stay in your portfolio by name and are listed separately on the performance page, so you always see exactly what your return is built from.

The short version

DeGiro buries the one file you actually need — the Account Statement — under the Inbox menu. Export it as XLS across your full history and you've got every trade, dividend, fee and deposit in a single file; ignore the separate Transactions export, because everything in it is already here. The columns are in Dutch, the cost basis is missing on purpose, the CSV version comes semicolon-separated, and four small traps decide whether your numbers come out right. Get that one file, watch the traps, and you'll have the raw material for an honest view of your portfolio — instead of the single number the platform decided to show you.

Create a free account and import your statement →