Gain/Loss

Realized and unrealized gain or loss per commodity, for securities and foreign currencies together.

Reading the report

Two totals sit above the table:

• Realized gain/loss: proceeds minus cost basis for everything you sold or converted within the selected period.
• Unrealized gain/loss: market value minus cost basis for the lots you still hold, valued as of the period end.

The table breaks both down per commodity:

• Commodity: the security or currency. Your reporting currency is omitted, as it has no gain against itself.
• Held: quantity you hold as of the period end.
• Realized: gain or loss booked from sales and conversions in the period.
• Basis: cost of the lots you still hold.
• Market: market value of those lots as of the period end.
• Unrealized: market minus basis.

Select a row to drill in. It lists the open lots you still hold and each past sale matched to the lots it drew from.

What realizes a gain

Selling a security and exchanging one currency for another both realize a gain. Spending a currency you hold does not. Securities use the cost basis method you choose; currencies use average cost.

Controls

• Period: the window for realized gain. Unrealized is always as of the period end.
• Accounts: limit the report to selected accounts.
• Cost basis method: FIFO, LIFO, HIFO, or average, applied to securities. See Tracking Securities.
• Fetch prices: pull current market prices so holdings can be valued.

A commodity with no price is flagged, as DOGE is above, and left unvalued rather than guessed. Fetch prices or add one to include it.

Multiple currencies and securities

Like the other reports, Gain/Loss converts to your reporting currency. See Multi-Currency.