Importing a Freedom24 broker report

Export the widest period, not the last month

This is the one decision that changes what you get. A full-period broker report is the fastest way to start: a single export covering the account's history produces both current holdings and the dated purchases behind them, so the portfolio arrives with months of contribution record instead of starting from today.

That matters more here than with most trackers, because the whole point is separating what you contributed from what the market did. A tracker that begins at today's balance can never answer that question about the past — and a valuation nobody recorded cannot be reconstructed later.

Long reports are the expected case

A Freedom Finance annual report is not a small document — a few years of monthly buying easily produces a file past 200 pages, roughly half of which is account summaries and cash-movement ledgers rather than holdings or trades. The extractor is built for exactly that shape: the sections are recognised by their headings, the summary and ledger pages are handled as what they are instead of misread as positions, and the trades section is read in full rather than sampled.

Excel exports get the same treatment, including the detail that the holdings date lives in the sheet name — it is read, not ignored.

What gets extracted

• Positions — ticker, quantity and average price, including fractional quantities. Positions closed during the report period are not resurrected as holdings.
• Trades — each buy becomes a contribution, dated, with quantity, price per share and the commission charged on that trade; sells reduce the position from their date.
• Dividends — payments received during the period, per instrument.
• Statement metadata — broker, period covered and file name, kept so a later upload can be compared against what was already applied.

Anything the extractor reads incorrectly can be edited in review, and holdings can always be added by hand instead — including without uploading a report at all, if you'd rather keep the document to yourself.

Uploading the same period twice is safe

Overlapping periods are the normal case — most people re-export the whole year rather than trimming to what is new. Two rules keep that safe:

• Transactions already imported are matched and listed as skipped duplicates in the review, with counts shown before you confirm. Re-uploading the same file adds nothing.
• A report whose period ends earlier than the last one applied does not silently replace newer position quantities — an older document cannot rewind the portfolio.

The same matching applies when a statement upload meets an API-synced portfolio: trades the connection already pulled are recognised, not doubled.

Statement or API connection — which to pick

Both paths end in the same portfolio; they trade convenience against what you share.

• The report needs no keys and works for any Freedom Finance entity, but you re-upload when you want the record extended.
• The API connection keeps a Freedom24 account current by itself — first sync in under a minute, then nightly — using a read-only key pair you generate and can revoke in the cabinet at any time.

Starting with a full-period report and connecting the API afterwards is a perfectly good order: the report backfills the deep history, the connection keeps it moving.

What the import does not do

• It does not touch your account. Only the file you upload is read.
• It does not invent missing history. A period no report covers is a hole, and the honest response to a hole is to show it rather than interpolate over it.
• It does not import individual bonds or notes. They are priced per 100 of face value and pay coupons rather than dividends; they are named as not imported instead of misread as shares. Bond funds with a ticker import normally.
• It is not a tax document. The cross-border estimates are informational and are explained in the withholding methodology.