# Import from a broker

Whisper Money recognises Trade Republic and MyInvestor exports. There are no columns to map: the file identifies itself, the cash is kept apart from the securities portfolio, and each part goes to its own account, created during the import if you don't have it yet.

## Quick start

1. Download the file from your broker, as explained under
   [Trade Republic](#trade-republic) or [MyInvestor](#myinvestor).
2. In **Transactions**, click **Import transactions**.
3. Pick the broker's account. If you don't have it yet, click **Upload the file
   and we'll create it**.
4. Upload the file as it is. The drawer tells you which export it is.
5. Check which account each part goes to, today's balance and, when there is a
   portfolio, its current value.
6. Review the preview and import.

## Trade Republic

### Which file to download

Trade Republic offers a transaction export as a CSV that holds, in one file, the
movements of your cash account and your securities trades. You create it in the
app, among the statements in your profile, choosing a period.

- Choose the longest period, from the day you opened the account. The portfolio
  is worked out from the buys and sells in the file, so a short period leaves out
  what you invested before it.
- Upload the CSV as it comes. There is no need to open it or change anything.
- Older exports, separated by semicolons, are recognised too.
- PDF statements won't work: only the transaction CSV.

![The file step with a recognised Trade Republic export: 22 movements from January to February 2026, no column mapping needed](https://whisper.money/docs/documentation/broker-import-trade-republic-upload.png)

### What gets imported

A Trade Republic file goes to two accounts.

| Part of the file     | Account                                                 | What is kept                                                   |
| -------------------- | ------------------------------------------------------- | -------------------------------------------------------------- |
| Cash                 | “Trade Republic”, a **Checking** account                | One transaction per cash movement, and each day's balance.     |
| Securities portfolio | “Trade Republic · Portfolio”, an **Investment** account | What was invested each day and today's value. No transactions. |

Everything that moves money goes into the cash: card payments, transfers, direct
debits, interest, dividends, Saveback, bonuses, fees, taxes, and also the buys
and sells of securities, which come out of that same account. Each amount is what
the balance changed by, fee and tax included.

The transactions are described like this:

- Card payments, with the merchant's name.
- Buys, sells and dividends, as **Buy · name**, **Sell · name** and
  **Dividend · name**, with the security's name.
- Interest as **Interest**, and Saveback as **Saveback**.
- Everything else, with the counterparty's name or Trade Republic's description.

The portfolio covers stocks, ETFs, savings plans and crypto. Its balance on each
day is what had been invested up to that day: what you paid for buys minus what
you got for sells. A sale at a gain takes off more than it cost, so what was
invested can drop a lot, even below zero. Shares that arrive without moving cash,
such as crypto rewards or a transfer in from another broker, don't count as
invested. If you don't want the portfolio, choose **Don't import the
portfolio**.

## MyInvestor

MyInvestor hands out one file per product: one with the current account's
movements, and another with the operations of the securities and funds
portfolio. Each is imported on its own and goes to its own account.

| File                            | Account                                             | What is kept                                                   |
| ------------------------------- | --------------------------------------------------- | -------------------------------------------------------------- |
| Current-account movements       | “MyInvestor”, a **Savings** account                 | One transaction per movement, and each day's balance.          |
| Securities and funds operations | “MyInvestor · Portfolio”, an **Investment** account | What was invested each day and today's value. No transactions. |

If you have both, import both files: they don't overlap. The securities file
holds no cash, so it duplicates nothing from the current account. The money you
move from the account to the portfolio, and fund subscriptions paid from the
account, come in with the current-account file.

### Current-account movements

In your account's details, tap **Ver más información** and, under
**Documentación**, choose **Resumen de movimientos**. It downloads every cash
movement of the account as an Excel file. The **Extracto de cuenta** is a PDF
and won't work.

Three shapes of this file are recognised:

- The **Resumen de movimientos** Excel, with a few title rows above the header.
- The movements Excel that opens with the **Titular** and **Cuenta** rows, and
  has the **Fecha operación**, **Fecha valor**, **Movimiento**, **Importe** and
  **Saldo** columns.
- The semicolon-separated CSV, with the **Fecha de operación**, **Fecha de
  valor**, **Concepto**, **Importe** and **Divisa** columns.

When the file has a **Saldo** column, each day's balance comes from it, and
today's is the file's last one. When it doesn't, today's balance is worked out by
adding up the movements, and you can correct it.

![The broker step with a MyInvestor current-account Excel: the account to be created and today's balance taken from the file](https://whisper.money/docs/documentation/broker-import-myinvestor-cash.png)

### Securities and funds operations

This is the export of the orders in your securities and funds portfolio, which
MyInvestor downloads as `salida.xls` (or `salida.xlsx`). Upload it as it is, even
if its headers don't line up with the columns when you open it: it is read just
the same.

What is read from each operation:

- **Buys and subscriptions** add to what was invested; **sells and redemptions**
  take off what you got for them.
- **Transfers and switches** between funds don't change what was invested: the
  money leaves one fund and goes into another.
- **Pension-plan contributions** count as invested. They carry no ISIN, so the
  step warns you that they can't be matched to a fund. Pension-plan
  **payouts** (prestaciones) take off, like a sell.
- **Dividends** aren't imported from this file. When they are paid into the
  current account, they come in with its file.

![The broker step with MyInvestor's securities operations: what was invested, the current value still to fill in, and a warning about a pension-plan contribution with no ISIN](https://whisper.money/docs/documentation/broker-import-myinvestor-securities.png)

## The import drawer, step by step

### No account yet

The first step asks which account the file goes to. If you already have the
broker's account, pick it. If not, click **Upload the file and we'll create it**,
next to **Coming from Trade Republic or MyInvestor without an account yet?**, and
you go straight to the file.

![The first step of the import drawer, with the option to upload a Trade Republic or MyInvestor file without picking an account](https://whisper.money/docs/documentation/broker-import-without-account.png)

### The file is recognised

When you upload the file, the drawer says which export it is, how many movements
or operations it holds and which months they cover. A broker export skips the
column mapping step: **Next** takes you to the broker step. A file that isn't
recognised goes the usual way, with its column mapping.

### Choose the accounts

The broker step has a box for each part of the file, with an **Account** picker:

- **Create “Trade Republic” · Checking**, **Create “MyInvestor” · Savings** or
  and, for the portfolio, **Create “Trade Republic · Portfolio” · Investment**
  or **Create “MyInvestor · Portfolio” · Investment** create the account when
  you import.
  When the broker's bank is in your list, the account is created there.
- You can also pick an account you already have. If you already have an account
  at that broker, it comes picked.
- If you pick an account that isn't at Trade Republic for Trade Republic's cash,
  the step warns you in case it's a mistake, but lets you go on.
- On an existing account, the step tells you from which day its daily balances
  are replaced with the file's.

![The Trade Republic broker step: the cash and the securities portfolio, each with its account, today's cash balance and what was invested](https://whisper.money/docs/documentation/broker-import-trade-republic.png)

### Today's balance

Each day's balance is rebuilt backwards from today's. When today's balance is
right, each day's balance adds up even if the file doesn't start when you opened
the account.

- For Trade Republic, the **Cash balance today** is worked out by adding up the
  file's movements, which is only right when the file starts when you opened the
  account. If it doesn't match the one the Trade Republic app shows,
  correct it.
- For MyInvestor, when the file has balances, **Balance today** is the file's
  last one and can't be edited. When it doesn't, it is worked out and you can
  correct it.

### The portfolio's value

The file says how much you invested, but not what your holdings are worth today.
Next to **Invested**, copy the total value the broker's app shows into **Current
value**. Leave it empty and the portfolio is worth what was invested until you
update it.

### Preview and import

Click **Preview**. At the top you see where the accounts will stand: today's
cash, what was invested and, if you entered the current value, that value and
the gain. Below, the cash movements with each day's balance. Those already in
the account come unticked.

![The preview of a Trade Republic import: today's cash, what was invested and the movements with their balance](https://whisper.money/docs/documentation/broker-import-trade-republic-preview.png)

A MyInvestor securities file brings no transactions: the preview lists the
operations for reference, and the button is **Import portfolio history**.

When you import, the transactions go through your
[automation rules](https://whisper.money/documentation/automation-rules), as in any other import.

## What you end up with

- **Accounts.** The ones you picked or the ones created: a cash account and, if
  you imported it, an investment account. They are created in the file's
  currency.
- **Transactions.** Only on the cash account, one per movement, each with its own
  id so the next import recognises it.
- **Balances.** Each day's on the cash account, from the file's first movement up
  to today.
- **Portfolio.** On the investment account, one balance per day with what had
  been invested up to that day, and today's with the current value you entered.
  The holdings of each security (shares, fund units) are not kept.

## Importing again

You can import a newer export whenever you like; usually the same full period,
with the new months included.

- **The accounts are remembered.** The step says **We recognised the file and
  the accounts from last time** and shows **Same accounts as last time**, even
  if you renamed them. Click **Change** to pick others.
- **Transactions aren't duplicated.** Trade Republic gives every movement its own
  id. MyInvestor doesn't, so one is made from the day, the amount and the
  concept; two identical movements on the same day stay two. Whatever is already
  in the account comes unticked in the preview.
- **You see what changed.** Next to what was invested you see how much it moved
  **since last time**, and under the current value, the one you entered last time
  and its date.
- **The balances are redone.** The daily balances from the file's first day on
  are replaced with the new ones. With a Trade Republic file or a MyInvestor
  current-account file, only when some new movement comes in: when nothing is
  new, the balances stay as they were, Trade Republic's portfolio included. A
  MyInvestor securities file always redoes them.

## When the account is connected to your bank

An account connected to your bank gets its movements and its balance from the
[sync](https://whisper.money/documentation/accounts/bank-connections), so the file writes nothing to
it: what it holds would land as duplicates.

- **Trade Republic.** When the cash account is connected, only the portfolio is
  imported, and the preview lists the operations for reference. If you also
  choose **Don't import the portfolio**, there is nothing left to import.
- **MyInvestor, current account.** When the account is connected, the file has
  nothing to import into it and the step won't let you go on.
- **MyInvestor, securities and funds.** Nothing changes: that file only writes to
  the investment account.

## FAQ

### Do I have to create the accounts first?

No. Click **Upload the file and we'll create it** on the first step, and the
accounts are created when you import, with the names you see on the broker step.
You can rename them afterwards: the next import still recognises them.

### Which MyInvestor file should I use?

Both, if you have an account and a portfolio. **Resumen de movimientos** brings
the current account's cash, and the securities operations file brings what you
invested in funds, stocks and pension plans. If you only use the account, the
first one is enough.

### Why is the portfolio worth exactly what I invested?

Because the file has no prices. The past is kept as what was invested, and today
is worth what you enter in **Current value**. If you left it empty, enter it on
the next import, or correct today's balance of the investment account in
[Edit balances](https://whisper.money/documentation/accounts/edit-balances).

### Are my stocks and funds kept one by one?

No. The portfolio is an investment account with what was invested and its value
on each day. The holdings of each security are not kept.

### The cash balance doesn't match Trade Republic's. What do I do?

Correct **Cash balance today** on the broker step with the one Trade Republic
shows. Each day's balance is rebuilt backwards from that figure.

### Can I import a file that overlaps the previous one?

Yes. Whatever was already in the account is recognised by its id and comes
unticked, so only what is new comes in. For the portfolio, always use an export
from the beginning: what was invested is worked out only from the operations in
the file.

### Can I import Trade Republic's cash into an account I already have?

Yes, pick it in the **Account** picker. If it isn't a Trade Republic account, the
step points it out in case you picked the wrong one. Its daily balances from the
file's first day on are replaced with the file's.

### Does the file go through the AI?

No. The file is read in your browser, and a broker export has no column mapping
to suggest.

---

Full documentation index: https://whisper.money/documentation.md?lang=en
