Import Portfolio CSV
Import a trade history, the positions you hold today, or your manual assets from a CSV, XLS or XLSX file.
Importing a file is the fastest way to load broker data into WonderMoney. The import window asks what the file holds first:
- Trade history: every buy and sale, with its date.
- Current positions: what you hold today, one row per holding, without the trades that led there.
- Manual assets: homes, vehicles and valuables, each with a value on a day.
Open it from a portfolio: choose Add transaction, then Import transactions, and pick the mode.

Import a trade history
- Export your trades from your broker.
- Choose Trade history, the portfolio and, if you like, the broker. The list has Degiro, Interactive Broker, Trading212 and Coinbase. A file from any other broker imports the same way, by matching its columns.
- Upload the file and choose Analyze file.
- Match the file's columns to the trade fields: date, type (buy, sell or dividend), quantity, unit price or total amount, currency and the asset (ISIN, ticker or name). A fee and the broker's own transaction ID are optional.
- Resolve any asset WonderMoney could not match (see Review before anything is saved).
- Check the summary and choose Confirm import.
Import current positions
Use this when you start from what you hold today rather than years of history. Each row is one holding:
| Column | Required | Notes |
|---|---|---|
| Symbol or ISIN | Yes | The asset name also works, but an ISIN matches most reliably. |
| Quantity | Yes | Greater than zero. |
| Average unit cost, or total cost | Yes | With both, the average unit cost is used. A total cost is divided by the quantity. |
| Currency | Yes | A column, or one currency for the whole file. |
| Acquisition date | No | Rows without one use the as-of date. |
- Choose Current positions, the portfolio and, if you like, the broker. Download the positions template gives you a file with these columns, which maps itself.
- Upload the file and choose Analyze file.
- Match the columns, and pick the as-of date: the day a row without an acquisition date is bought on. It defaults to today.
- Resolve any unmatched asset, then review the rows for assets the portfolio already trades (below).
- Choose Confirm import.
What a position becomes
Each row becomes one opening buy: a normal buy of that quantity at the average unit cost, on its acquisition date or the as-of date, marked "Opening position" in its notes. Because it is an ordinary buy, the portfolio treats it exactly like one you recorded by hand:
- Under FIFO it is one lot; under average cost it adds to the average. A later sale relieves its cost and reports the realized gain, under either cost basis method.
- It counts as money put into the portfolio on its date for the time-weighted and money-weighted returns. Returns are measured from that day: what happened before it is not part of them.
- The cost basis is what the file says you paid, so check it: unrealized gain is measured against it.
Assets that already have trades
If the portfolio already has buys or sales of an asset in the file, an opening buy on top of them would count the holding twice. Those rows are listed with a warning and skipped by default. Switch a row on to import it anyway, for example when the existing trades are of a holding you sold before buying again. Rows for assets without trades import as usual.
Importing the same positions file into the same portfolio twice, with the same broker choice, is caught as a duplicate as long as each row lands on the same date. A row without an acquisition date takes the as-of date, so under a different as-of date it is not a duplicate; it is then listed with the warning above and skipped by default.
Import manual assets
Manual assets are not part of a portfolio: they count in your net worth at a value you set. See Homes, vehicles and other assets.
- Choose Manual assets in the import window, or Import CSV on the Assets page.
- Download the template and fill in one row per asset:
| Column | Required | Notes |
|---|---|---|
| Name | Yes | |
| Kind | Yes | property, vehicle, valuable or other. |
| Value | Yes | In the asset's currency. |
| Valuation date | No | YYYY-MM-DD. Empty means today. |
| Currency | Yes | A three-letter code, such as EUR. |
| Private | No | yes keeps the asset to yourself; empty or no shares it with your household. |
- Upload the file. WonderMoney checks every row and lists the ones that need fixing, by line.
- Choose Import. Each asset is created with that value as its first valuation, and it is yours, exactly as if you had added it by hand. If any row cannot be imported, none is.
The manual-assets template reads a CSV file of up to 500 assets.
Review before anything is saved
Nothing is added to a portfolio until you choose Confirm import. Before that:
- Column mapping. WonderMoney suggests a mapping from the file's headers; check it and fill in what is missing.
- Asset review. A row whose asset could not be matched with confidence goes to asset review. Pick the right security from the suggestions, search for another symbol, or skip the group.
- Summary. Rows that are invalid (a missing quantity, a date that cannot be read) or duplicates of rows already imported are counted and left out.
Best results
- Use a fresh export from the broker.
- Keep one portfolio per broker account when possible.
- Prefer ISINs: they match one security, where a ticker can exist on several exchanges.
- Review quantities, dates, costs and currencies in the file before uploading.
Common mistakes
- Importing a positions file into a portfolio that already holds the same trades: the warning catches it, but only for the assets in the file.
- Importing a trade history as current positions, or the other way round.
- Leaving the currency column empty when the file includes several currencies.
- Assuming every broker uses the same column names.