Realized and Unrealized Gains Report

Arman Azardar

Modified on: Thu, 25 Jan, 2024 at 3:42 PM

The Realized and Unrealized Gains page shows you the gains and losses you have already made in the past, as well as the potential gains/losses at the current moment.

How to get there:

To find the "Realized & Unrealized Gains Report" on CoinTracking, go to Reporting- "Realized & Unrealized Gains"

This article is separated into five sections:

1) Filter Settings

2) The Instant Gain Calculator

3) Total unrealized and realized Gain / Loss for each Currency

4) Realized Gain / Loss for all Sales

5) Unrealized Gain / Loss for all Purchases

1) Filter Settings:

You have the option to select different filters. Some of those filters are also relevant in the tax report and can be used here as well, such as the Tax Method Setting and the Price Setting.

On the right side, you have further filter options:

Hide all zero and negative amounts: Enable to hide amounts less than or equal to zero.

Group all purchases / sales by day: Enable, to group all purchases and sales by day. This can be helpful if the time zones were not recorded correctly during import and sales are listed a few hours before the purchase (recommended for day traders in different time zones). Another benefit is that the number of transactions will be greatly reduced when creating a tax report.

Disable to calculate all trades to the second according to the selected method (recommended if all trades and times have been set correctly).

If you enable grouping, some profits or losses may be skipped. A sale of 1 BTC with a resulting profit of 1000 USD and a purchase of 2 BTC on the same day would be grouped as a pure purchase of 1 BTC and without any profit. For this reason, grouping is not legal in some countries, such as the US, Canada and the UK. You can ask a tax advisor if you do not know whether it is legal to group transactions in your country.

Use depot separation: This article explains the depot separation in detail.

2) Instant Gain Calculator:

Calculate how much you gain or lose if you decide to sell a specific amount of coins at this very moment by using the Instant Gain Calculator under the filter settings.

In this example you can see that if you were to sell 1 Bitcoin with a (current) price of about 30,000 USD per BTC, you would have a Sell Value of about 30,000 USD and a Realized Gain of about 25,000 USD.

(Note that in this example, we bought the Bitcoin for 5,000 USD).

That means you would have a realized gain of about 25,000 USD (30,000-5,000) if you decided to sell 1 BTC right now.

3) Total unrealized and realized Gain / Loss for each Currency

Here you can see all your realized and unrealized gains, grouped by currency.

Each value explained:

Remaining Amount: The remaining amount of a currency you own right now (all purchases-all sales).

Note:

The remaining amount of a coin can deviate from the values on the dashboard, because deposits and withdrawals are not included!

Cur.: The currency of your remaining amount.

Cost per Unit: The amount you have spent in total for one unit of the selected currency.

Current Price per Unit: The current market price for one unit of the selected currency.

Change: The difference between the market price and your cost in percent.

Cost: The total amount you have spent for the entire remaining amount of the selected currency (Remaining Amount * Cost per Unit).

Current Value: The current market value for your remaining amount (Remaining Amount * Current Price per Unit). It's the market value you will get, if you sell the full remaining amount right now.

Unrealized Gain / Loss: The total gain or loss you will achieve, if you sell your full remaining amount right now (Current Value - Cost).

Realized Gain / Loss: The total gain or loss you have achieved with this currency until now.

4) Realized Gain / Loss for all Sales

This table contains all your sales with the respective realized gain. It is the amount you've already achieved with your sales, calculated from the difference between your purchase price and sale price.

Type: Outgoing transaction types (sales, fees, lost, spend etc.)

Amount: The amount of the currency you have sold.

Cur.: The currency of your sale.

Cumulated Cost per Unit: The calculated average purchase price per unit from all purchases before this transaction (value of all purchases till this date / amount of all purchases till this date). Should the purchase amount be negative, no change and realized gain will be calculated.

Sell Price per Unit: The calculated sell price per unit for this trade at the time of your transaction (sell value / amount).

Change: The difference between your sale and the cumulated cost in percent.

Cumulated Cost:The calculated purchase value (Cumulated Cost per Unit * Amount).

Sell Value: The sell value of this transaction (Sell Price per Unit * Amount).

Realized Gain / Loss: The gain or loss you have achieved with this sale (Sell Value - Cumulated Cost).

Trade Date: The day and time of your transaction.

5) Unrealized Gain / Loss for all Purchases

This table contains all purchases with their unrealized gain. It is the difference between your purchase price and today's price. Coins which have already been sold are not taken into account.

Type: Incoming transactions types (Buy, Reward/Bonus/Income, gift etc.)

Amount: The amount of the currency you have bought.

Cur.: The currency of your purchase.

Cost per Unit: The calculated purchase price per unit for this trade at the time of your transaction (Cost / Amount).

Current Price per Unit: The current market price for the traded currency.

Change: The difference between your price and the current market price in percent.

Cost:The total value of your trade at the time of your transaction.

Current Value: The current market value of your trade (amount * current price per unit). It's the market value you would get, if you sell the full amount right now.

Unrealized Gain / Loss: The gain or loss you would achieve, if you sell your full amount right now (Current Value - Cost).

Trade Date: The day and time of your transaction.