member badge
Jack
In Finland, apart from the total capital gains, you also need to report a sum of all gains and all losses separately
https://www.vero.fi/en/individuals/property/investments/virtual-currencies/how-to-report-gains-and-losses-from-virtual-currencies-in-mytax/
Workaround
While Koinly doesn't provide a ready calculation for this yet, it's possible to calculate it using Excel and the "Capital Gains" report.
  • Generate a capital gains report
  • Turn it into a table ("Format as table")
  • Add another column, it can be called "Type"
  • In the first cell of the column, enter a formula:
    =IF([@[Gain / loss]]>0,"Gain","Loss")
  • Then Create a pivot table (Insert > Pivot table)
  • In rows:
    Type
  • In Values:
    Gain / Loss
  • If you also want to group by asset, add 'Asset` in the "Columns"
The end result would look somewhat as below.
This can also be done in a Google Sheet, then the formula you need to populate would be
=IF(G4>0,"Gain","Loss")