How to export your portfolio from Saxo

The export is not hidden. It is one of twelve, and picking the wrong one costs you either the trades or the cash.

· 4 min read

Saxo does not hide its export. It offers twelve of them, and the names do not tell you which one holds your transactions.

The report you want is the Account Statement. Saxo describes it as all the transactions and movements that happened on a selected account for a given period, which is the whole of what a portfolio tracker needs: the trades, and the cash that funded them.

Where it is

In SaxoTraderGO: My Profile, then Account reports, then Download report. Pick the report, choose the period, and download it as PDF or Excel. Take the Excel one — the PDF is for filing, not for importing.

The same reports are reachable in SaxoInvestor and in SaxoMonitor, where they sit under historical or transactional reports rather than under a profile menu. If your platform looks different from the path above, it is the report name to search for, not the menu.

Which of the twelve

ReportTake it?
Account StatementYes. Trades and cash movements over the period, which is what reconstructs positions and cost basis.
Portfolio ReportNo. A point-in-time picture of performance, profit/loss and fees — useful reading, but it is a snapshot rather than a history.
DividendsOptional. Dividends already appear in the account statement; this one is a narrower view of the same payments.
Aggregated AmountsNo. Totals rather than rows, so there is nothing to import from it.
Set the start date to before you opened the account. A period that begins partway through your history produces sales with no matching purchases, and cost basis cannot be computed from that — the file is perfectly valid and the arithmetic is impossible. There is no penalty for asking for a wider range than exists.

Two things worth checking afterwards

Currency

A Saxo account can hold several currencies at once, and a statement covering them reports each movement in the currency it happened in. Nothing is wrong with that, but a total is only meaningful once everything in it has been converted at the rate that applied on the day — not at today’s rate, and not at one rate for the whole file.

The sign on a sale

Exports differ on whether a sale is a negative quantity, a negative amount, both, or neither with a word in a type column instead. If a position reads larger than you ever held, or a sale looks like a purchase, that is the convention to check first — against one trade you remember, on the platform.

HaboFi does not auto-detect this one yet

Every broker we recognise automatically, we recognise by matching the exact column headings its export writes. We have not seen a real Saxo account statement, and the published guidance describes the reports without quoting their header row — so a detector built from it would either never fire, or fire on somebody else’s file and mis-read it silently. The second outcome is much worse than the first, and guessing risks both.

So a Saxo export goes to the mapping screen instead, which asks you which column is which and what each transaction type means. It takes about a minute, it is the same screen that handles every broker we have not met, and the import preview runs before anything is saved. Excel files are converted in your browser, so the workbook itself is never uploaded.

If you hold a Saxo account and are willing to send an anonymised statement, that is the one thing standing between here and automatic detection. See also exporting from any broker.

HaboFi imports a file you downloaded yourself — CSV or Excel, no broker login and no API key, and nothing that keeps reading your account afterwards. Anything it does not recognise goes to a mapping screen that asks you two questions rather than refusing the file.

Try HaboFi free

Common questions

Which Saxo report should I export to import my portfolio?

The Account Statement. Saxo describes it as all the transactions and movements on a selected account for a given period, which covers both the trades and the cash that funded them. The Portfolio Report is a point-in-time snapshot of performance rather than a history, so it cannot reconstruct positions or cost basis.

Where do I find account reports in SaxoTraderGO?

Open My Profile, then Account reports, then Download report. Select the report you want, choose the period, and download it as PDF or Excel. Choose Excel for importing into a tracker; the PDF version is intended for filing. The same reports appear in SaxoInvestor and SaxoMonitor under historical or transactional reports.

Should I export a Saxo statement as PDF or Excel?

Excel. A PDF is laid out for reading rather than for machines, and recovering rows from one means scraping a layout that can change between statements. The Excel version of the same report contains the same movements as data.

What date range should a Saxo export cover?

Start before you opened the account. A period beginning partway through your history produces sales with no matching purchases, and cost basis cannot be calculated from that. The file is valid and the arithmetic is impossible. Asking for a wider range than exists costs nothing.

Does HaboFi detect a Saxo export automatically?

Not yet. Automatic detection works by matching the exact column headings an export writes, and the published guidance for Saxo describes the reports without quoting their header row. A detector built on that would either never match or match another broker's file and misread it silently. Saxo exports go to the mapping screen instead, where you confirm which column is which before anything is saved.

This article is general information about how these calculations work. It is not financial, investment or tax advice, and nothing in it is a recommendation to buy or sell any security. See our terms.

Read next

How to export your portfolio from any brokerEvery broker exports a transaction history and none agree on the columns. What to download, what goes wrong, and a guide for each broker.How to export your portfolio from DEGIRODEGIRO has two exports, not one. Take only the Transactions file and your dividend history is empty — and every sale arrives as a negative number.Portfolio tracker without connecting your brokerOpen banking connections, read-only API keys and CSV files are three different levels of access. What each one actually hands over.