Which exports does Bolero have?
On the Bolero platform you can export to Excel from most menus.1 For your investments, two of them matter. The positions overview shows each of your positions, with your gain or loss per position, and you can export those positions to an Excel file. The transaction history shows all your transactions and every transfer to or from your Bolero account.2
Which one you pick depends on what you want to do. For a snapshot of your portfolio, say to look at your diversification in Excel, the positions overview is enough. To follow your return, your dividends and your costs over the years, you need the transaction history: that is where the transactions themselves are.
Exporting your positions to Excel
In the Portefeuille (Portfolio) menu, go to Posities (Positions). You land on a page with every security in your portfolio. Click the Excel icon to export your portfolio to Excel. Prefer a PDF? Under Rapport (Report) you can generate a PDF report of your portfolio yourself.3
You partly choose what you see: according to Bolero you can add or remove columns1, and Bolero’s 2021 manual lists adjusting your columns next to the Excel export on your positions.4
Looking for a column with the ISIN? Whether it is among the columns you can switch on is not stated in the Bolero help pages we read. Check the column settings of your positions overview before you export.
Exporting your transaction history to Excel
In the Rekeningen (Accounts) menu, open the Transactiehistoriek (Transaction history) tab. There a search engine finds the cash movements on your account, and the Excel icon lets you save or print an overview of those movements.5 According to the manual you can refine the search with filters.4
Bolero uses the same table for the dividend overview you need for your tax return: there you set the period and filter on the keyword ‘dividend’.6 For a complete overview, do the opposite: leave the keyword empty and pick a period from your very first transaction up to today. Anything outside the period is not in your file.
Then open the Excel file and check that your oldest transaction is in it. If it is missing, check the period and whether every row of the table was loaded, and export again.
Which file StockQuarters reads
StockQuarters reads Bolero’s transaction history, as an Excel file (XLSX). We do not read the positions overview: your return, dividends and costs need every transaction, and those are in the transaction history. You upload the file in your browser, without your Bolero password; uploading the same file again adds no duplicate rows.
From the file we take your buys, sells, dividends, deposits, withdrawals and corporate-action costs. Stock exchange tax and commission are included in the amount you paid per buy or sell; we book the difference from quantity × price as costs on that trade. For a dividend we book the gross amount and everything withheld, Belgian withholding tax and foreign withholding together. Deposits and withdrawals are your own money and never count as profit; why that matters for your return is in Return with deposits.
A few things to know. We find no ISIN in the transaction history, only a security’s name and exchange, and we use those to look up its price. A security we cannot find that way stays at cost; after the import you see which ones they are and can enter a price yourself. A row in a currency other than the euro is skipped and listed after the import. A split or a stock dividend does not show up, because no cash moves. And we cannot read an export in French yet: switch Bolero’s language to Nederlands (Dutch) and export again.
More about the import is on StockQuarters’ Bolero page. StockQuarters is a paid service after a 7-day trial (see pricing) and stores your data encrypted in the EU.
Capital gains tax in your Bolero export
For the Belgian capital gains tax, Bolero by default withholds 10% when you sell an investment at a gain, and pays it to the tax authority. That withholding ignores your yearly exemption; anything withheld in excess you recover through your tax return. You can also ask Bolero to withhold nothing (opt-out), per account.7
If your transaction history shows capital gains tax, StockQuarters books it as a separate cost; the result of the sale itself stays as it is. What the 10% costs you this year, and how much gain you can still realise tax-free, you work out with StockQuarters’ capital gains tax calculator, for free; with an account it works from your own sales.
Sources
- According to Bolero you can export to Excel from most menus on the platform, and you choose the information you want to see by adding or removing columns. Source: bolero.be/nl/platformen/bolero-beleggingsplatform, checked on 22 November 2026
- According to Bolero you can export your detailed positions to an Excel file and see your gain or loss per position; the transaction history shows all your transactions and every transfer to or from your Bolero account. Source: bolero.be/nl/platformen/bolero-beleggingsplatform/portefeuille, checked on 22 November 2026
- According to Bolero’s FAQ you click Posities (Positions) in the Portefeuille (Portfolio) menu, land on a page with every security in your portfolio and export it to Excel with an icon; a PDF report of your portfolio is made under Rapport (Report). Source: bolero.be/nl/support/veelgestelde-vragen/hoe-kan-ik-mijn-portefeuille-exporteren-naar-excel, checked on 22 November 2026
- The manual ‘Aan de slag met Bolero’ (Getting started with Bolero, July 2021) lists adjusting your columns and exporting to Excel on your positions, and describes the transaction history as a search engine over every cash movement on your account, with filters. Source: bolero.be/uploads/media/60fa7622f1947/handleiding-bolero-final-juli2021.pdf, checked on 22 November 2026
- According to Bolero’s FAQ you look up the cash movements on your account in the Rekeningen (Accounts) menu, tab Transactiehistoriek (Transaction history), and the Excel icon saves or prints an overview of those movements. Source: bolero.be/nl/support/veelgestelde-vragen/rekeninguittreksels, checked on 22 November 2026
- According to Bolero’s FAQ on the dividend overview, you set the period in Rekeningen › Transactiehistoriek and filter on the keyword ‘dividend’; the overview shows the Belgian withholding tax and exports to Excel. Source: bolero.be/nl/support/veelgestelde-vragen/waar-vind-ik-mijn-dividendenoverzicht-op-het-bolero-platform, checked on 22 November 2026
- According to Bolero, withholding is the default: Bolero withholds 10% capital gains tax on a sale at a gain and pays it to the tax authority, without taking your yearly exemption into account (excess withholding is recovered through your tax return). With an opt-out, requested per account, Bolero withholds nothing. Source: bolero.be/nl/lp/meerwaardebelasting/bronheffing-en-opt-out, checked on 22 November 2026