Discussion on brokers

[Alwar]

@terva_xyz

I’m looking for the first time at how to declare trades made through DEGIRO in the tax return. More detailed information as an attachment that can be downloaded directly. In addition, I should declare 1. total disposal prices, 2. total capital gains, 3. total capital losses.

Degiro’s report does not directly provide answers if I have understood correctly. For example, the report itemizes gains, losses and fees paid, but the problem is that the gain or loss reported in the report is not real because fees have not been deducted from them. Do I really have to do the calculations the hard way and go through the whole year’s trading line by line? The same applies to disposal prices. They are not directly visible in the report if you don’t calculate them yourself.

I had the same task ahead of me, so I decided to code an Excel VBA macro to handle the calculation. The benefit of this is that you can also look at the current year’s situation for year-end tax optimization.
Tested to work with Excel version:

If anyone is interested, I’ll share it:
DegiroTo9A.xlsm (72.7 KB)

P.S. I made an observation that the exchange rates in Degiro’s transaction report are slightly different from those in the final annual report. So there are small differences in these sums.
P.S.2. Please give feedback if you notice anything strange.
P.S.3. The VBA macro codes are visible if anyone is suspicious of running such code downloaded from the internet.

Bug fixes:

• 14.4.2020 - report page row counter and row writing were not in sync
• 15.4.2020 - corrected sum calculation formulas