JSON Payload
This API gives a response in the following format:
Tradewise Tax PnL
Click here to learn more about this JSON Payload
{
"name": "tradewise_tax_pnl_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "crypto_currency_spot_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "crypto_currency_spot_tradewise_tax_pnl_table",
"@entity": "table",
"header": [
"symbol",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"holding_period",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"nature_of_transaction",
"taxable_pnl",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"BTC",
3.56783, "acdcwefew3e1113vcd",
1682985600000, 265, "nrezxcetgf2334jk0333d",
1690416000000, 278.98, "short_term",
49.8782634, 18.894277659134, 30.983985740866, "trade",
49.8782634, "capital_gains",
"virtual_digital_asset",
"30"
],
[
"SOL",
245, "efvdf3vmndvnor349023s",
1711843200000, 0.3117, "wg3rg43wfege1dbdg33f",
1687392000000, 36.06812244898, "short_term",
8760.3235000001, 0, 8760.3235000001, "trade",
8760.3235000001, "capital_gains",
"virtual_digital_asset",
"30"
],
[
"XRP",
6.3544, "nknee38ni9cd3defeve",
1687132800000, 58.68, "fwhjceco2trsc344f322e",
1690934400000, 75.35, "short_term",
105.927848, 181.144041698568, -75.216193698568, "trade",
105.927848, "capital_gains",
"virtual_digital_asset",
"30"
],
[
"XRP",
2.6579, "nknee38ni9cd3defeve",
1687132800000, 58.68, "zxc1rtvmk3456hkkve3w",
1696291200000, 48.49, "short_term",
-27.084001, 14.745958301432, -41.829959301432, "trade",
0, "capital_gains",
"virtual_digital_asset",
"30"
],
[
"ETH",
0.4569, "klop3sdcwf23445dwedc",
1594684800000, 120.455, "klop3sdcwf2347d12wxbk",
1708646400000, 511.698, "long_term",
178.7589267, 0, 178.7589267, "trade",
178.7589267, "capital_gains",
"virtual_digital_asset",
"30"
],
[
"USDT",
50, "acdcwefew3e1113vcd",
1682985600000, 84.311, "nknee38ni9cd3defeve",
1687132800000, 85.23, "short_term",
45.95, 52.857142857143, -6.907142857143, "trade",
45.95, "capital_gains",
"virtual_digital_asset",
"30"
],
[
"USDT",
100, "acdcwefew3e1113vcd",
1682985600000, 84.311, "fwhjceco2trsc344f322e",
1691020800000, 88, "short_term",
368.9, 151.604285714286, 217.295714285714, "trade",
368.9, "capital_gains",
"virtual_digital_asset",
"30"
],
[
"USDT",
40, "acdcwefew3e1113vcd",
1682985600000, 84.311, "klop3sdcwf2347d12wxbk",
1708646400000, 91.09, "short_term",
271.16, 2.285714285714, 268.874285714286, "trade",
271.16, "capital_gains",
"virtual_digital_asset",
"30"
]
]
},
{
"name": "crypto_currency_tradewise_other_tax_pnl_table",
"@entity": "table",
"header": [
"symbol",
"quantity",
"buy_trade_id",
"date_of_aquisation",
"cost_of_aquisation",
"sell_trade_id",
"date_of_transfer",
"consideration_received",
"realized_pnl",
"expenses",
"net_realized_pnl",
"nature_of_transaction",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"MATIC",
12.568, "egrgrbko4542gfvfg4gv332",
1693008000000, 0, null, null, 1770.5320816, 1770.5320816, 0, 1770.5320816, "staking_reward",
1770.5320816, "1770.532081600000",
"other",
"gift",
"slab_rate"
]
]
},
{
"name": "cryptocurrency_spot_tradewise_holding_table",
"@entity": "table",
"header": [
"symbol",
"quantity",
"buy_date",
"buy_price",
"last_traded_price"
],
"rows": [
[
"BTC",
4.88887, 1682985600000, 265, 299.785],
[
"BTC",
10.9873, 1690934400000, 309.8, 299.785],
[
"SOL",
1755, 1711843200000, 0.3117, 0.0145],
[
"MATIC",
50, 1687392000000, 88.3669, 1256.789],
[
"MATIC",
50, 1687392000000, 88.3669, 1256.789],
[
"MATIC",
12.568, 1693008000000, 140.8762, 1256.789],
[
"ETH",
0.5253, 1594684800000, 120.455, 89.566],
[
"USDT",
70, 1682985600000, 84.311, 95.45],
[
"USDT",
30, 1690416000000, 85, 95.45]
]
}
]
},
{
"name": "crypto_currency_future_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "crypto_currency_future_tradewise_tax_pnl_table",
"@entity": "table",
"header": [
"symbol",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"BTC-USDT",
1, "addf3434mkvefv456h",
1687219200000, 5901.77, "fege4343gbgee344tg",
1687305600000, 9350, 3448.23, 1400, 2048.23, 2048.23, "business_and_profession",
"non_speculative",
"slab_rate"
],
[
"ETH-USDT",
3, "fhtyjrg35n788985gff3",
1690934400000, 14640, "fhtyjrg35n788985gff5",
1694131200000, 9790, -14550, 500, -15050, -15050, "business_and_profession",
"non_speculative",
"slab_rate"
]
]
},
{
"name": "crypto_currency_future_tradewise_open_position_table",
"@entity": "table",
"header": [
"contract_name",
"quantity",
"buy_date",
"buy_price",
"last_traded_price"
],
"rows": [
[
"XRP-USDT",
2, 1691020800000, 5742.75, 85]
]
}
]
},
{
"name": "tax_pnl_summary_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "tax_pnl_summary_table",
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"holding_period",
"realized_pnl",
"transfer_expense",
"net_realized_pnl",
"taxable_pnl",
"tax_rate"
],
"rows": [
[
"capital_gains",
"virtual_digital_asset",
"short_term",
9575.0556104001, 421.531420516277, 9153.52418988382, 9602.1396114001, "30"
],
[
"capital_gains",
"virtual_digital_asset",
"long_term",
178.7589267, 0, 178.7589267, 178.7589267, "30"
],
[
"business_and_profession",
"virtual_digital_asset",
"NA",
0, 0, 0, 0, "30"
],
[
"other",
"gift",
"NA",
1770.5320816, 0, 1770.5320816, 1770.5320816, "slab_rate"
],
[
"business_and_profession",
"non_speculative",
"NA",
-11101.77, 1900, -13001.77, -13001.77, "slab_rate"
]
]
},
{
"name": "transaction_summary_table",
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"realised_pnl",
"transfer_expense",
"net_realized_pnl"
],
"rows": [
[
"mining_reward",
0, 0, 0, 0],
[
"trade",
27378.6236406001, 9753.8145371001, 421.531420516277, 9332.28311658382],
[
"staking_reward",
1770.5320816, 1770.5320816, 0, 1770.5320816],
[
"airdrop",
0, 0, 0, 0],
[
"interest",
0, 0, 0, 0],
[
"lost",
0, 0, 0, 0],
[
"payment_send",
0, 0, 0, 0],
[
"payment_receive",
0, 0, 0, 0],
[
"gift_send",
0, 0, 0, 0],
[
"gift_receive",
0, 0, 0, 0],
[
"transfer_in",
0, 0, 0, 0],
[
"transfer_out",
0, 0, 0, 0],
[
"fork",
0, 0, 0, 0],
[
"donation",
0, 0, 0, 0],
[
"buy_back",
0, 0, 0, 0],
[
"short_sell",
0, 0, 0, 0],
[
"other",
0, 0, 0, 0]
]
}
]
},
{
"name": "schedule_vda_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "income_from_transafer_of_vda_table",
"@entity": "table",
"header": [
"sr_no",
"date_of_acquisition",
"date_of_transfer",
"income_head",
"cost_of_aquisation",
"consideration_received",
"realized_pnl"
],
"rows": [
[1, 1682985600000, 1690416000000, "capital_gains",
946, 996, 50],
[2, 1711843200000, 1687392000000, "capital_gains",
77, 8837, 8760],
[3, 1687132800000, 1690934400000, "capital_gains",
373, 479, 106],
[4, 1687132800000, 1696291200000, "capital_gains",
156, 129, 0],
[5, 1594684800000, 1708646400000, "capital_gains",
56, 234, 178],
[6, 1682985600000, 1687132800000, "capital_gains",
4216, 4262, 46],
[7, 1682985600000, 1691020800000, "capital_gains",
8432, 8800, 368],
[8, 1682985600000, 1708646400000, "capital_gains",
3373, 3644, 271]
]
},
{
"name": "income_from_from_vda_summary_list",
"@entity": "list",
"items": [
[
"taxable_capital_gain_income",
9779],
[
"taxable_business_and_profession_income",
0]
]
}
]
}
]
}