Tradebook P&L

Tradebook provides you with all the trades that have been executed by an investor or trader. Brokers/Exchanges can use Tradebook to calculate Tax P&L using APIs.

API Pricing

Overview

This API calculates Tax P&L for crypto by taking in the trade book data.

Problem

  • Brokers/Exchanges have to provide accurate Realized & Unrealized P&L.
  • Brokers/Exchanges must apply Virtual Digital Asset tax rules to calculate Pre-Tax & Post-Tax returns accurately.
  • The tax landscape is ever-changing with announcements from regulators, tax departments & finance ministry, especially in the case of crypto.
  • Investors & Traders have to furnish accurate P&L & Holdings in their tax returns as per the tax law.
  • Brokers/Exchanges are unable to provide accurate tax computations.

Solution

  • API to calculate Tax P&L in real-time.
  • API covers tax calculation for different transactions like Trade, Mining, Staking, Gift, NFTs, DeFi, etc.
  • Allows Brokers to visualize Tax P&L for their users.
  • Tax P&L reports can be generated using the trade-wise method as prescribed by the Income tax department.

Endpoint

HTTP MethodEndpoint
POST/it-calculator/crypto/tax-pnl/tradebook

API Endpoint  Contact Us  Free Trial

HTTP MethodEndpoint
POST/it-calculator/crypto/tax-pnl/tradebook/spreadsheet

API Endpoint  

📘

The response of this API is a signed URL of a spreadsheet file with the same data as the above API's response and is valid for 7 days.

Request Body

VDA Transaction

ParamTypeRequiredDescription
idNumberOptionalTransaction ID of the particular trade
dateNumberYesTrade Timestamp in epoch milliseconds
transaction_typeStringYesIndicates whether the order is :
buy, sell, trade, send, receive
labelStringOptionalIndicates 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)

Note - Whenever a field is blank pass null

🚧

All the Transactions should be passed in the request since inception of the account.

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

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

Sample Tradebook

idDateTransaction TypeLabelReceived CurrencyReceived QuantityPricePrice CurrencyPrice in INRSent CurrencySent QuantityFees CurrencyFees AmountFee in INR
11101-04-2021
12:23:30:11
buyBUSD49.469875INR
22202-04-2021 12:23:30:11buyETH0.251000INR
33310-05-2021
12:23:30:11
sell90INRBUSD24.7349
44411-06-2021
12:23:30:11
tradeLUNA0.3179.79BUSD6562.7275BUSD24.7349
55520-06-2021
12:23:30:11
tradeBUSD15.009100.06BUSD8229.935LUNA0.15
66621-06-2021
12:23:30:11
tradeBUSD15.5856100.06BUSD8229.935LUNA0.16
77701-07-2021
12:23:30:11
receiveairdropBUSD185
88810-07-2021
12:23:30:11
receiveinterestLUNA0.319000
99905-08-2021
12:23:30:11
receivestaking_rewardMATIC10240
10101010-08-2021
12:23:30:11
sendlost2000ETH0.15
11111111-11-2021
12:23:30:11
receivemining_rewardETH0.251800
12121220-11-2021
12:23:30:11
sell1200INRETH0.3

Market Value of Crypto Currency in INR

DateCurrencyPrice in INR
11/06/2021BUSD82.25
20/06/2021LUNA7000

Tradewise Capital Gains & Losses

SymbolQuantityBuy Trade IdBuy DateBuy PriceSell Trade IdSell DateSell PriceHolding periodRealized P/LTransfer ExpensesNet Realized P/LTagTaxable P&LIncome HeadIncome Sub HeadTax RateTaxNet P&L (G-L)
ETH0.122202 -04 -2021
10:33:12:45
100012121220-11-2021
10:33:12:45
1200short_term20020trading20Capital GainsVirtual Digital Asset30614
ETH0.211111111-11-2021
10:33:12:45
180012121220-11-2021
10:33:12:45
1200short_term-1200-120trading0Capital GainsVirtual Digital Asset300-120
BUSD24.734911101-04-2021
10:33:12:45
7533310-5-2021
10:33:12:45
90short_term371.02350371.0235trading371.0235Capital GainsVirtual Digital Asset30111.30705259.71645
BUSD24.734911101-04-2021
10:33:12:45
7544411-06-2021
10:33:12:45
82.25short_term179.3280250179.328025trading179.328025Capital GainsVirtual Digital Asset3053.7984075125.5296175
LUNA0.1544411-06-2021
10:33:12:45
6562.727555520-06-2021
10:33:12:45
8229.935short_term250.0811250250.081125trading250.081125Capital GainsVirtual Digital Asset3075.0243375175.0567875
LUNA0.1644411-06-2021
10:33:12:45
6562.727566621-06-2021
10:33:12:45
8229.935short_term266.75320266.7532trading266.7532Capital GainsVirtual Digital Asset3080.02596186.72724

Tradewise Other Tax P&L

SymbolQuantityBuy Trade IdDate of AcquisitionCost of Acquisitionsell_trade_idDate of_ TransferConsideration ReceivedRealized P&LExpensesNet Realized P&LNature of TransactionTaxable P&LIncome HeadIncome Sub HeadTax RateTaxNet P&L (G-L)Turnover
ETH0.1522202-04-2021
10:33:12:45
15010101010-08-2021
10:33:12:45
0-1500-150lost0NANANANA-150NA
MATIC1099905-08-2021
11:35:12:45
02400240002400staking_reward2400Business and ProfessionVirtual Digital Asset3072016802400.0000
ETH0.25111,11111-11-2021
21:12:12:45
04504500450mining_reward450Business and ProfessionVirtual Digital Asset30135315450.0000
BUSD177701-07-2021
10:33:12:45
08585085airdrop85Business and ProfessionVirtual Digital Asset3025.559.585.0000
LUNA0.3188810-07-2021
10:33:12:45
02790279002790interest2790Business and ProfessionVirtual Digital Asset3083719532790.0000

Transaction Summary

NatureTotal Transaction ValueRealised P/LTransfer ExpenseNet Realized P/L
Mining9090090
Trading7171.8663967.18580967.1858
Staking Reward2400240002400
Airdrop8585085
Interest2790279002790
lost150-1500-150
payment_send0000
payment_receive0000
gift_receive0000
gift_send0000
fork0000
donation0000
other_income0000

Tax P/L summary

Income HeadIncome Sub HeadHolding periodRealized P&LTransfer ExpensesNet Realized P/LTaxable P/LTax RateTaxNet P/L
Capital GainsVirtual Digital Assetshort_term967.18580967.18581087.1858530326.155755641.030045
Capital GainsVirtual Digital Assetlong_term00003000
Business & ProfessionVirtual Digital AssetNA5575055755725301717.53857.5
OtherGiftNA0000slab_rateNANA