Bring only the trades, or only the cash
Two switches on an import's review bring in part of a broker's file. Leave out the cash lines when the deposits are already in your Wallet, and bring only the cash lines when the trades are already in your workspace.
Open the import and pick your broker
On the Portfolio, press Import, then pick your broker from the list, as for any import.
Add the file, and check where it goes
Drop the file on the window. On Check what we found, make sure Goes into names the broker that already holds the deposits or the trades you have. If it says Pick one, open Pick a broker and choose yours. If it says New broker, open Use another broker and choose yours: a new broker would hold none of them. Then press Review with the number of lines.
See what is left out already
Open the Left out tab before you change anything. A deposit your Wallet already records is there by itself, saying Your wallet already records this deposit, with the account and the day. The import finds it when it went to this broker, for the same amount to the cent, within 5 days of the file's date. Trades your workspace already has are there too, as Already in your portfolio.
If everything you have is already there, you need no switch: go to the last step.
Turn on one switch
Under the list of transactions, open More options and turn on the switch you need:
- Leave out the cash lines when your deposits are in the Wallet but do not match the file one by one, such as one monthly total for two transfers. It leaves out deposits, withdrawals, interest, fees and currency conversions, and keeps the trades and dividends.
- Bring only the cash lines when your trades are already in, typed by hand with prices a little different from the file's, or brought by another file. It leaves out the trades, dividends and splits, and the holdings they add, and keeps the deposits, interest and fees.
The lines move from From your file to Left out, saying Left out: you chose to leave out the cash lines (More options). or Left out: you chose to bring only the cash lines (More options).
Compare the cash, then import
Cash after import shows the broker's cash once the file is in, with the deposits your Wallet records counted in. It should match the cash your broker shows today. A gap the size of the interest or fees you left out is expected: add those by hand afterwards. Then press Import with the number of transactions.
What each switch leaves out
| A line of the broker's file | Leave out the cash lines | Bring only the cash lines |
|---|---|---|
| Buys and sells | Come in | Left out |
| Dividends, from the file or from market data | Come in | Left out |
| Splits | Come in | Left out |
| Deposits and withdrawals | Left out | Come in |
| Interest on cash, and the broker's fees | Left out | Come in |
| Currency conversions | Left out | Come in |
Each switch shows only when the file has lines it would leave out.
Worked example
You moved €800 to Trading 212 in October and recorded it in the Wallet as one Deposit to broker of €800 on 1 October. The broker's file lists that money as two deposits, with your buys and the interest it paid on your cash.
| In the broker's file | Amount |
|---|---|
| Deposit, 2 Oct | €500.00 |
| Deposit, 20 Oct | €300.00 |
| Buys of VWRL and ASML | €760.00 |
| Interest on cash | €1.20 |
Good to know
The switches are not kept. Turn on the one you need each time you import that broker's file.
A switch leaves out every line of its kind, even ones not in your workspace yet. To keep some, leave the switches off and press Leave it out on each line you already have.
Nothing is left to bring in. The button still reads Import 0 transactions, and pressing it closes the window with Nothing to import - no transactions were selected.
Add them on the Broker tab of Add transaction, as Broker income or Broker expense.
Cash after import, and the cash at your brokers, need Investments set to Full tracking: see Turn the Wallet or the Portfolio off.
Record each transfer in the Wallet with the amount your broker shows, and within a few days of its date: the import then finds it by itself.