Generates the data required by the Bulgarian tax office for reporting investment returns.
# Create a virtual environment:
$ python -m venv .venv
# Activate the virtual environment:
$ source .venv/bin/activate
# Install required dependencies:
$ pip install -r requirements.txt
Run the script:
$ python main.py
The following investment brokers are supported:
- Log in to the Interactive Brokers site.
- Go to Performance & Reports > Statements.
- Under "Default Statements", run the "Activity" statement.
- Set period to "Annual" and format to "CSV".
# Example: process 2 yearly exports from Interactive Brokers.
$ python main.py --ib U4151384_2022_2022.csv U4151384_2023_2023.csv
- Open the Saxo Trader Go website (not Saxoinvestor).
- Go to Account > Historical reports.
- Open the "Trades" view. Select a custom period starting with the opening of the account. Export as an Excel sheet.
- Open the "Share dividends" dialog. Choose last year as the period. Export as an Excel sheet.
- Open the "Closed positions" dialog. Select a custom period sarting with the opening of the account. Export as an Excel sheet.
# Example: process the Excel exports from Saxo Bank.
$ python main.py --saxo-trades TradesExecuted_123456.xlsx --saxo-dividends ShareDividends_123456.xlsx --saxo-closed-positions ClosedPositions_123456.xlsx
- Open the Trading212 website.
- Go to History and click the "Export" button in the top right.
- Select a time frame from January 1 to 31 December and click "Export CSV". It is only possible to export 12 months of data, so you need to do this multiple times.
- A few moments later a notification will appear that the export is ready. Click the "Download" button.
# Example: process 2 yearly exports from Trading 212.
$ python main.py --t212 t212-2021.csv t212-2022.csv
It is possible to import the reports that have been generated by the application itself. Often it is easier to start by importing the reports from last year, rather than importing a long list of broker data spanning many years.
# Example: import the report from the previous year.
$ python main.py --pita-investments my_reports/2023/investments.xlsx