Skip to content
TurbobullsDocs
DocsQuestions and fixes

What the notes on your file mean

After you add a broker's file, the Check can list Notes on your file: what the file could not show, like sales of shares it never shows arriving, dates it read one way, or rows it left out. What each means and what to do.

An answer5 minutes

Where the notes are

After you drop a broker's file, Check what we found counts what it holds under In your file. When the import noticed something the file could not show, the tile Notes counts it, with read them below, and the notes are listed at the bottom under Notes on your file. Each one says what it found, and a button such as Show 2 lines opens the lines it is about, as your file wrote them.

A note is not an error: the rest of the file still comes in, except where the file sells shares it never shows arriving, below. Many ask you to do one thing, before or after the import. They come back on the review, under the Left out tab.

Why does it say these sales take shares the file never shows arriving?

The file sells shares it never shows you buying, so the import cannot tell what they cost. The note names each holding with the shares missing, such as These sales take shares the file never shows arriving: ASML 10. Charles Schwab's says This file sells or repays holdings it never shows arriving (ASML 10)., and Directa's and Parqet's speak of units. It happens when:

  • the file starts after you bought them, for example an export of the last year only;
  • the shares came from another broker, which this file does not list;
  • they came from a spin-off the broker leaves out of its file.

To fix it, close the import, add the shares as a Transfer in at the broker the file goes into, at what they cost, dated before the file's first line about them, then import the file again. Or press Skip on that holding under Holdings on the Check, and the rest of the file comes in without it. Until you do one or the other, the review stops at the sale with Holdings below zero.

A note such as This file has payments on holdings it never shows held (ASML) is the same for dividends: they are left out until your workspace holds those shares. Either note goes away by itself once your workspace already holds the shares, for example when you imported the months before from an earlier file.

Why are splits and free shares named?

  • Splits: a note such as Skipped 1 stock split row (AAPL). Splits are applied from market data. Add a Split by hand if a holding looks off after the import. The split comes in from market data on the review, under From market data, so the file's own line is not needed. If the holding's number of shares still looks wrong afterwards, add a Split by hand.
  • Free shares: Shares received for nothing (a spin-off or a stock distribution) need their cost set by hand: add them as a transfer in. The import cannot know what they cost you. Add them as a Transfer in on their day, with the cost your broker or the company gives.

For Trading 212, the last screen of the import lists them again under One thing left for you, such as Add the 4 SOLV shares from 1 Apr 2024. Add them opens a Transfer in with the holding, the day and the broker filled in: you add how many and what they cost.

Why does the cash not add up?

Some brokers' files give the cash balance after each line. When it jumps from one line to the next, lines are missing from the file: BUX's cash balance does not add up from one row to the next, so some bookings are missing from this file. Export again with every transaction type selected, from before your first deposit, so the cash comes out right. Finpension and Swissquote say the same. Export the file again as the note says and import it: lines already here are skipped, so nothing doubles.

A DEGIRO file that starts after the account was opened says what was already there: The account already held 1250.00 EUR when this file starts (2024-01-02). The import brings in only what the file shows, so the broker's cash will be 1250.00 EUR short: export from the day the account was opened, or record that balance by hand. By hand, that is an Outside deposit of €1,250.00 dated before the file's first day. See Cash at your brokers.

Were my dates read the right way?

A date such as 03/04/2025 is 3 April or 4 March, depending on who wrote it. When nothing in the file settles it, the note says how it was read: Trading 212: dates such as 03/04/2025 could be day-first or month-first, and nothing in this file settles it. They were read day-first (3 April 2025). When the lines disagree, it names two of them and says all were read one way. Most sources read such dates day-first; Charles Schwab, Coinbase and Tastytrade month-first.

Check one line you know on the review, such as your last deposit. A broker writes its dates one way, and a spreadsheet app that opened and saved the file can rewrite them. If they came out the wrong way round, export the file again and import it as the broker wrote it, without opening it first.

Why were repeated rows skipped?

A note such as Skipped 2 repeated Trading 212 rows: the same event, under the same ID, appears more than once in the file. means the broker wrote one event twice, with its own number on both. It comes in once, and there is nothing to do. XTB, Trade Republic, Freetrade and Crypto.com say the same of their files.

Why should I export again later?

Some lines were not final when you exported: Skipped 2 rows that have not settled (BTC). Their status is not Completed: export again once Bitvavo has settled them. Freetrade says the same of an order still queued: If the order was still queued when the file was downloaded, download it again once the order has run. Wait a day or two, export again and import the new file. Lines already here are skipped, so only what was missing comes in.

Worked example

Your Revolut statement starts on 1 March 2026, but you bought 10 ASML in 2025 at €600 each. The file sells them on 15 March at €700.

StepWhat you seeWhat you do
CheckThese sales take shares the file never shows arriving: ASML 10.Close the import
Add transactionTransfer in of 10 ASML on 1 March 2026, at €600 each
Import againNo note, and the sale comes inPress Import
€6,000What the 10 ASML cost: 10 × €600
+€1,000Gain on the sale: 10 × (€700 - €600)

Good to know

Other lines left out

A note can also name rows of a kind the import does not read, with the words the file used. Add such a line by hand if it matters to you.

Cash in a second currency

A note that the file also moves money in another currency says those amounts are converted at each day's rate, so the broker's cash can differ a little from what your broker shows.

Fix first, then import

No line of the file is saved until you press Import, so you can close the window, do what a note asks, and import the file again.

Ask without the file

Unsure what a note means for you? Ask in the community with the note's words, never the file or its amounts.

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