This article explains how each transaction type impacts the PNL calculation.
* refers to the "Action" column in the custom file.
No. |
Transaction type ("Action" column in the custom file) |
How it is processed | PNL impact? |
Examples |
1 | BUY | Purchased at the price*1 on the transaction date and time |
× |
・Buy crypto on exchanges ・Peer to peer trading |
2 | SELL | Sold at the price*1 on the transaction date and time | 〇 |
・Sell crypto on exchanges ・Peer to peer trading |
3 | BONUS | Profit recognized at the price*1 on the transaction date and time |
〇 |
・Airdrop ・Campaign reward ・Referral reward |
4 | LOSS | Loss recorded at the book price*2 | 〇 | The exchange shut down, and the tax office confirmed it can be reported as a loss |
5 | REDUCE | Decrease the quantity*3 without affecting the PNL |
× |
The exchange shut down, but the tax office doesn't allow it to be reported as a loss. |
6 | STAKING | Profit recognized at the price*1 on the transaction date and time | 〇 | Received a reward for staking |
7 | LENDING | Profit recognized at the price*1 on the transaction date and time | 〇 | Received a lending interest |
8 | LEND | Locks in the stated quantity | × | Lent coins to a friend |
9 | RECOVER | Releases the stated quantity | × | Received back the coins that were lent |
10 | MINING | Profit recognized at the price*1 on the transaction date and time | 〇 | Received a reward for mining |
11 | Transfer fee (SENDFEE) | Decrease the quantity*4 without affecting the PNL | ×*4 | Paid a transfer fee |
12 | PAY | Sold at the price*1 on the transaction date and time | 〇 | Paid for goods/services in a cryptocurrency |
13 | BORROW | Incorporate the price for the stated date and time into the book price | × | Borrowed coins |
14 | RETURN | PNL is calculated as (price at the time of borrowing - book price) * quantity | 〇 | Returned the borrowed coins |
15 | LEVELUP | Add to the book price *2 of NFTs | × | Level-up in STEPN |
16 | Payment in a Fiat currency (CASH) | Loss for the fiat currency portion | 〇 | Paid for goods/services in a Fiat currency |
17 | TIP | Sold at the price for the stated date and time or decrease the quantity without affecting the PNL | *5 | Sent a tip |
*1 the price -> the market value obtained from cryptact (for supported coins only) / the transaction price provided by the exchange / the price entered by the user.
*2 the book price->the book value. The value of assets and liabilities included in the ledger.
The book price for a cryptocurrency is calculated based on all historical trades.
*3 the quantity -> the quantity of each coin.
*4 × -> the default behavior is to simply reduce the quantity. You can change the setting to include the fee in the PNL.
(Please refer to "Expense transfer fees").
*5 The calculation method varies depending on the date of transaction. For more details, please refer to the following page. Calculation Method for Transaction Type "Tip" on Transactions Page
[Related Article]
Custom File for any other trades
PNL calculation for borrowing/returning for SPOT trades
How is level-up in STEPN treated in the pnl calculation (level-up of NFT)?