JSON Payload
This API gives a response in 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_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "crypto_currency_tradewise_capital_gains_and_losses_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",
0.00002018,
"50",
1677628800000,
2300000.84,
"34",
1677683460000,
234616,
"short_term",
-41.6795,
0,
-41.6795,
"trade",
0,
"capital_gains",
"virtual_digital_asset",
"30"
],
[
"BTC",
0.00000164,
"51",
1677628800000,
4.0164,
"34",
1677683460000,
234616,
"short_term",
0.3848,
0,
0.3848,
"trade",
0.3848,
"capital_gains",
"virtual_digital_asset",
"30"
],
[
"BTC",
0.00015226,
"52",
1677628800000,
2500000,
"34",
1677683460000,
234616,
"short_term",
-344.9274,
0,
-344.9274,
"trade",
0,
"capital_gains",
"virtual_digital_asset",
"30"
],
[
"BTC",
0.093775433402,
"35",
1677683460000,
232269.84,
"34",
1677683460000,
234616,
"short_term",
220.0122,
0,
220.0122,
"trade",
220.0122,
"capital_gains",
"virtual_digital_asset",
"30"
],
[
"BTC",
0.00017408,
"35",
1677683460000,
232269.84,
"41",
1677689340000,
238669,
"short_term",
1.114,
0,
1.114,
"trade",
1.114,
"capital_gains",
"virtual_digital_asset",
"30"
],
[
"BTC",
0.16732592,
"40",
1677689340000,
236282.31,
"41",
1677689340000,
238669,
"short_term",
399.3551,
0,
399.3551,
"trade",
399.3551,
"capital_gains",
"virtual_digital_asset",
"30"
],
[
"CELR",
119327.1597,
"32",
1677683000000,
227570.92,
"36",
1677683460000,
227827.57,
"short_term",
30625315.537,
0,
30625315.537,
"trade",
30625315.537,
"capital_gains",
"virtual_digital_asset",
"30"
],
[
"USDT",
2840.909090909091,
"37",
1677683460000,
250000,
"38",
1677683460000,
250000,
"short_term",
0,
0,
0,
"trade",
0,
"capital_gains",
"virtual_digital_asset",
"30"
],
[
"USDT",
2051.299170616114,
"45",
1677683460000,
172990.62,
"44",
1677683460000,
174738,
"short_term",
3584399.1448,
0,
3584399.1448,
"trade",
3584399.1448,
"capital_gains",
"virtual_digital_asset",
"30"
],
[
"ZIL",
74553.8975,
"42",
1677689340000,
250000,
"46",
1677683460000,
173129.65,
"short_term",
-5730984194.6891,
0,
-5730984194.6891,
"trade",
0,
"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": [
[
"BTC",
0.00002018,
"50",
1677628800000,
0,
null,
null,
46.414,
46.414,
0,
46.414,
"other",
46.414,
"46.4140",
"business_and_profession",
"virtual_digital_asset",
"30"
],
[
"BTC",
0.00015226,
"52",
1677628800000,
null,
null,
null,
380.65,
380.65,
0,
380.65,
"gift_receive",
380.65,
"380.6500",
"other",
"gift",
"slab_rate"
],
[
"LUNA2",
0.000069648,
"53",
1677628800000,
0,
null,
null,
0.0,
0,
0,
0,
"airdrop",
0,
"0.0000",
"business_and_profession",
"virtual_digital_asset",
"30"
],
[
"ADA",
0.013368138318,
"54",
1677628800000,
0,
null,
null,
0.0,
0,
0,
0,
"staking_reward",
0,
"0.0000",
"business_and_profession",
"virtual_digital_asset",
"30"
]
]
}
]
},
{
"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",
"transafer_expense",
"net_realized_pnl",
"taxable_pnl",
"tax_rate"
],
"rows": [
[
"capital_gains",
"virtual_digital_asset",
"short_term",
-5696774245.7481,
0,
-5696774245.7481,
34210335.5479,
"30"
],
[
"capital_gains",
"virtual_digital_asset",
"long_term",
0,
0,
0,
0,
"30"
],
[
"business_and_profession",
"virtual_digital_asset",
"NA",
46.414,
0,
46.414,
46.414,
"30"
],
["other", "gift", "NA", 380.65, 0, 380.65, 380.65, "slab_rate"]
]
},
{
"name": "transaction_summary_table",
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"realised_pnl",
"transafer_expense",
"net_realized_pnl"
],
"rows": [
["mining_reward", 0, 0, 0, 0],
[
"trade",
41162236216.0828,
-5696774245.7481,
0,
-5696774245.7481
],
["staking_reward", 0.0, 0.0, 0, 0.0],
["airdrop", 0.0, 0.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", 380.65, 380.65, 0, 380.65],
["fork", 0, 0, 0, 0],
["donation", 0, 0, 0, 0],
["buy_back", 0, 0, 0, 0],
["short_sell", 0, 0, 0, 0],
["other", 46.414, 46.414, 0, 46.414]
]
}
]
},
{
"name": "holdings_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "crypto_currency_tradewise_holding_table",
"@entity": "table",
"header": [
"symbol",
"quantity",
"buy_date",
"buy_price",
"last_traded_price"
],
"rows": [
["BTC", 0.00017408, 1677689340000, 236282.31, 1250888],
["LUNA2", 0.00006965, 1677628800000, 0.0, 500],
["LUNA2", 2202.99, 1677683460000, 264808.21, 500],
["CELR", 4067.6353, 1677683000000, 227570.92, 89],
["ICP", 513.867215, 1677683460000, 250000.0, 111],
["LTC", 32.573217, 1677683460000, 250000.0, 11000],
["ZIL", 34884.915, 1677689340000, 250000.0, 98],
["ADA", 0.01336814, 1677628800000, 0.0, null]
]
}
]
},
{
"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",
"income_head"
],
"rows": [
[
1,
1677628800000,
1677683460000,
"capital_gains",
4.7346,
-41.6795
],
[2, 1677628800000, 1677683460000, "capital_gains", 0.3848, 0.3848],
[
3,
1677628800000,
1677683460000,
"capital_gains",
35.7226,
-344.9274
],
[
4,
1677683460000,
1677683460000,
"capital_gains",
22001.2171,
220.0122
],
[5, 1677683460000, 1677689340000, "capital_gains", 41.5475, 1.114],
[
6,
1677689340000,
1677689340000,
"capital_gains",
39935.51,
399.3551
],
[
7,
1677683000000,
1677683460000,
"capital_gains",
27186016829.4529,
30625315.537
],
[
8,
1677683460000,
1677683460000,
"capital_gains",
710227272.7273,
0
],
[
9,
1677683460000,
1677683460000,
"capital_gains",
358439914.4751,
3584399.1448
],
[
10,
1677689340000,
1677683460000,
"capital_gains",
12907490180.3109,
-5730984194.6891
],
[
11,
1677628800000,
null,
"business_and_profession",
46.414,
46.414
],
[12, 1677628800000, null, "business_and_profession", 0, 0],
[13, 1677628800000, null, "business_and_profession", 0, 0]
]
},
{
"name": "income_from_from_vda_summary_list",
"@entity": "list",
"items": [
["taxable_capital_gain_income", 34210335.5479],
["taxable_business_and_profession_income", 46.414]
]
}
]
}
]
}