Tradebook | Crypto | Reporting

Cryptocurrency Spot Tradebook Sheet

Cryptocurrency Spot Tradebook Table

ParamTypeRequiredDescription
idStringNoTransaction ID of the particular trade
dateNumberYesTrade Timestamp in epoch milliseconds
transaction_typeStringYesIndicates whether the order is :
buy, sell, trade, send, receive
labelStringNoIndicates the category of transaction type.
Possible values:- interest, staking, staking_reward, lost, mining_reward, airdrop, donation, fork, gift, payment, other_income
received_currencyStringYesSymbol of the cryptocurrency received
(If transaction_type = send/sellpass null)
received_quantityNumberYesQuantity received by executing the transaction.
(Required when received_currencynull)
priceNumberYesPrice at which unit is traded.
(If transaction_type = send/receivepass null)
price_currencyNumberYesCurrency in which price is considered.
Possible values: INR, USD, BTC etc.
(Required when pricenull)
price_in_inrNumberYesPer unit value of the crypto in INR
(Required when price_currencyINR or = null)
sent_currencyStringYesSymbol/Name of the crypto sent
(If transaction_type =recieve/buy pass null).
sent_quantityNumberYesQuantity sent by executing the transaction
(Required if sent_currencynull).
fee_currencyStringNoCurrency in which transaction fees or any other expense was made while executing the transaction
fee_amountNumberNoAmount/quantity spent as fees or other expenses while executing transactions
fee_in_inrNumberNoINR value of the fee paid for the transaction.
(Required if fee_currencyINR)

Cryptocurrency Spot Last Traded Price List

ParamTypeDescription
cryptocurrency_namestringName of the cryptocurrency
last_traded_pricenumberLast traded price of the cryptocurrency

Cryptocurrency Future Tradebook Sheet

Cryptocurrency Future Tradebook Table

ParamTypeRequiredDescription
idStringNoTransaction ID of the particular trade
dateNumberYesTrade Timestamp in epoch milliseconds
contract_nameStringYesName of the cryptocurrency futures contract being purchased or sold
transaction_typeStringYesIndicates whether the order is :
buy, sell
quantityNumberYesQuantity of the contract
priceNumberYesPrice at which unit is traded.
price_currencyNumberYesCurrency in which price is considered.
Possible values: INR, USD, BTC etc.
price_in_inrNumberYesPer unit value of the crypto in INR
(Required when price_currencyINR or = null)
fee_amountNumberNoAmount/quantity spent as fees or other expenses while executing transactions
fee_currencyStringNoCurrency in which transaction fees or any other expense was made while executing the transaction
fee_in_inrNumberNoINR value of the fee paid for the transaction.
(Required if fee_currencyINR)

Cryptocurrency Futures Last Traded Price List

ParamTypeDescription
contract_namestringName of the contract
last_traded_pricenumberLast traded price of the contract

Annexures

Annexure 1: Definition of Transaction Type

Transaction TypeDefinition
buyOTC buy transaction on an exchange
sellOTC sell transaction on an exchange
tradeCrypto to Crypto transaction on the Exchange
sendCrypto sent out of the wallet
receiveCrypto received in the wallet

Annexure 2: Label

LabelDefinition
airdropAn unsolicited distribution of a cryptocurrency token or coin, usually for free
interestCryptocurrency received in the form of Interest on the coins kept as a deposit
stakingLock crypto assets for a set period of time to help support the operation of a blockchain
staking_rewardThe reward received for locked crypto assets for a set period of time
forkCrypto received due to hard fork
giftCrypto received as a gift in the wallet
lostIrrecoverable cryptocurrency from wallets
mining_rewardThe crypto reward received on mining the coin
donationDefines a transaction that was donated to a charity
paymentA transaction that was received as a payment for a good or service
other incomeDefines any other type of reward received
transferTransaction between wallets owned by same user.
marginAmount blocked from wallet for trading crypto futures
margin_gainAny gains realized while trading in Crypto Futures
margin_lossAny losses realized while trading in Crypto Futures

Annexure 3: Nature of Transaction wise Tax Treatment

Nature of TransactionIncome HeadTax RateNotes
mining_rewardbusiness_and_professionslab_rateTax is applicable on the fair market value of such asset. (as per the price in the open market on the valuation date).
interestotherslab_rateThe complete value of interest is taxable and all kinds of expenses are disallowed.
tradingcapital_gains30%Tax is applicable on the "Full value of consideration", less "Cost of acquisition".
staking_rewardotherslab_rateThe total amount received as reward is taxable and all expenses are disallowed.
forkotherslab_rateThe total amount received as reward is taxable and all expenses are disallowed.
gift_recievedotherslab_rateThe total amount received as gift is taxable at a slab rate
gift_sendNANAAny cryptocurrency that was sent as a gift, would not be considered for taxation
lostNANAAny irrecoverable cryptocurrency from wallets, would not be considered for taxation.
airdropotherslab_rateThe complete value of airdrop is taxable and all kinds of expenses are disallowed.
donationNANAAny cryptocurrency that was donated to charity, would not be considered for taxation
payment_receivedotherslab_rateAny crypto received as a payment is completely taxable and all expenses are disallowed.
payment_sendcapital_gains30%Tax is applicable on the "Full value of consideration" (as per the price in the open market on the payment date), less "Cost of acquisition".
other_incomebusiness_and_profession30%Any other income generated from crypto is completely taxable and all expenses are disallowed.
transfer_inNANATransfers between wallets owned by the same taxpayer are not taxable.
transfer_outNANATransfers between wallets owned by the same taxpayer are not taxable.