Skip to content
TurbobullsDocs
DocsPortfolio

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.

A guide4 minutes
Before you start. You have a broker's file to import, and part of what it holds is already in your workspace: the deposits, recorded in the Wallet as Deposit to broker, or the trades, typed by hand or brought in by another file.

Open the import and pick your broker

On the Portfolio, press Import, then pick your broker from the list, as for any import.

PortfolioImport

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).

More optionsLeave out the cash lines

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 fileLeave out the cash linesBring only the cash lines
Buys and sellsCome inLeft out
Dividends, from the file or from market dataCome inLeft out
SplitsCome inLeft out
Deposits and withdrawalsLeft outCome in
Interest on cash, and the broker's feesLeft outCome in
Currency conversionsLeft outCome 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 fileAmount
Deposit, 2 Oct€500.00
Deposit, 20 Oct€300.00
Buys of VWRL and ASML€760.00
Interest on cash€1.20
€1,600Put in without a switch: neither deposit matches the Wallet's €800 to the cent, so the Wallet's 800 and the file's 500 + 300 all count
€40.00Cash after import with Leave out the cash lines: 800 - 760
€1.20Left to add by hand as broker income, to reach the €41.20 the broker shows

Good to know

Each import starts with both off

The switches are not kept. Turn on the one you need each time you import that broker's file.

All lines of a kind

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.

Both on

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.

Interest and fees you left out

Add them on the Broker tab of Add transaction, as Broker income or Broker expense.

Full tracking

Cash after import, and the cash at your brokers, need Investments set to Full tracking: see Turn the Wallet or the Portfolio off.

No switch next time

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.

Something missing, or not what you see in the app?Tell us in the community