Your transaction history is a file in CSV format (Comma-Separated Values) that unfiltered contains all your purchases, sales, deposits and withdrawals ever made with BISON. It is the most important document when you want to import your data into portfolio trackers or tax tools (such as Blockpit, Cointracking, Parqet or Getquin).
Download: Where can I find the CSV file?
You can easily request your complete history in the BISON app or web version under “Account” and the menu item “Reports” and “Transaction History”. Simply select the desired period and we will send the file directly to your BISON mailbox.
The golden rule: Why you should NOT just save the file!
If you need the CSV file for external tax tools or portfolio trackers, it is best to upload it there completely untouched.
Warning: If you open the CSV file with Microsoft Excel and then simply save it again, Excel automatically changes the formatting in the background (e.g. by changing commas and points). This makes the file unusable for tools like Blockpit or Parqet and causes errors during upload.
How to open and read the CSV file correctly
If you just want to view the raw data without changing the format, you have the following safe options:
The text editor (the safest choice): Do not open the file by double-clicking on your PC, but right-click on it instead. On Windows, select "Open with > Notepad" (or Editor). On Mac, select "Open with > TextEdit". Here you will see the pure raw data in its original state.
Mac "Numbers": If you use a Mac and open the file with the standard program "Numbers", the values are usually displayed perfectly as a table.
Google Sheets: Upload the file to Google Sheets. Highlight the first column and click on "Data" > "Split text to columns" in the menu above. This will give you a clean table.
The Excel workaround
If you absolutely want to use Excel, the incorrect display is a known settings issue with Excel regarding English/German number formats. To display the columns correctly, you need to change the following settings in Excel:
Go to: File > Options > Advanced
Uncheck “Use system separators”
Change the decimal separator to a point (.)
Change the thousands separator to a comma (,)
Then close the CSV file once (without saving!) and open it again. Excel should now display the correct values in a clean table format.
The most important entries in your BISON CSV file
Once you have successfully opened the CSV file, you will see various columns such as Transaction ID, Transaction type, Asset, Eur (amount) and Fee. To correctly interpret the data for your tax return or portfolio tracker, the column Transaction type is especially important.
Here is the translation of the most important BISON data entries:
Buy & Sell: These are your regular purchases and sales.
Note on savings plans: Automatically executed savings plans are also listed here normally as Buy.
Note on fees: For stock transactions, you will find the order fee in the Fee column. For crypto trades, this is 0 because we earn our money through the spread, which is already fully included in your purchase/sale price.
Staking Reward: This shows your received crypto earnings from the staking programme.
Deposit & Withdrawal: This marks your regular deposits and withdrawals (both Euros and cryptocurrencies).
Important exception (rewards): Currently, cashbacks from the BISON Select programme as well as bonuses from the refer-a-friend programme are also shown as Deposit in the CSV. Warning: Since these rewards are usually taxable (other income), you must manually change these specific entries in your tax tool (such as Blockpit) from "Deposit" to "Reward"!
Note on crypto transfers: We do not show external sender or recipient wallet addresses in the CSV file. If you want to reconcile these, please use the detailed view of your transaction overview directly in the BISON app.
Special cases for securities (stocks & ETFs)
For corporate actions, our system uses special designations which you can read as follows:
CorporateActionIncrease (with asset name): You have been credited with a cash dividend or distribution. Taxes are not separately shown here; you only see your final agreed net amount (the pure Euro inflow) in the CSV.
CorporateActionIncrease (without asset name): If this entry appears without a specific security in the column, a subsequent tax correction was made after a trade.
Stock splits / spin-offs: When a security is split, you will see a combination of two entries: first CorporateActionDecrease (the write-off of your old shares) followed immediately by a CorporateActionIncrease (the posting of the new, split shares).