JSON Payload
This API gives response in following two formats:
Tradewise Tax PnL
Click here to learn more about this JSON Payload
{
"code": 200,
"timestamp": 1744803928061,
"data": {
"metadata": {},
"@entity": "workbook",
"sheets": [
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Meta",
1,
1463356800000,
55,
4020.0738,
"USD",
3,
219.2768
]
],
"name": "dividend_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"country",
"symbol",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"buy_price_inr",
"cost_of_acquisition",
"cost_of_acquisition_inr",
"sell_trade_id",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transfer_expenses",
"transfer_expenses_inr",
"nature_of_settlement",
"realized_pnl",
"realized_pnl_inr",
"net_realized_pnl",
"net_realized_pnl_inr",
"taxable_pnl",
"taxable_pnl_inr",
"turnover",
"turnover_inr",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"US0378331005",
null,
"Apple",
645,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136,
9940.546,
136,
9940.546,
"CYX9TQSTWUYK8C9Z7BCE",
1650412800000,
0,
0,
null,
25,
1906.9114,
null,
-87720,
-6411652.17,
-87745,
-6413559.0814,
-87745,
-6413559.0814,
0,
6411652.17,
"business_and_profession",
"speculative",
"slab_rate"
]
],
"name": "stock_tradewise_intraday_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"country",
"symbol",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"buy_price_inr",
"cost_of_acquisition",
"cost_of_acquisition_inr",
"sell_trade_id",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transfer_expenses",
"transfer_expenses_inr",
"nature_of_settlement",
"realized_pnl",
"realized_pnl_inr",
"net_realized_pnl",
"net_realized_pnl_inr",
"holding_period",
"taxable_pnl",
"taxable_pnl_inr",
"turnover",
"turnover_inr",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"US0378331008",
null,
"NVIDIA",
254,
"VQLDME6IOJZR95BDEKQ9",
1692316800000,
1290.98,
116903.1399,
1290.98,
116903.1399,
"VXFUFI5Q9HH7FEJPLV3B",
1692403200000,
0.78,
70.632,
"EUR",
21,
1901.6297,
"trade",
-327710.8,
-29677358.6572,
-327731.8,
-29677358.6572,
"short_term",
-327731.8,
-29677358.6572,
198.12,
17940.5181,
"capital_gains",
"securities",
"slab_rate"
]
],
"name": "stock_tradewise_delivery_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"fifty_two_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
],
"name": "reference_data_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"buy_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price",
"last_traded_price_inr",
"unrealized_pnl",
"unrealized_pnl_inr"
],
"rows": [
[
"US0378331022",
"AMAZON",
20,
1463356800000,
56,
56,
null,
"POUND",
"buy",
null,
null,
100,
100
],
[
"US0378331023",
"INTEL",
35,
1692316800000,
88,
88,
null,
"USD",
"buy",
null,
null,
45,
45
]
],
"name": "stock_tradewise_holding_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price",
"last_traded_price_inr",
"unrealized_pnl",
"unrealized_pnl_inr"
],
"rows": [
[
"US0378331012",
"MONSTER",
1,
1650412800000,
800,
800,
null,
"DIRHAM",
"sell",
null
],
[
"US0378331013",
"TSLA",
56,
1692403200000,
95,
95,
null,
"CAD",
"sell",
null
]
],
"name": "stock_tradewise_open_sell_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"transfer_date",
"price",
"price_inr",
"currency",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_value_inr",
"transfer_expense",
"transfer_expense_inr"
],
"rows": [],
"name": "stock_tradewise_transfer_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"total_transaction_value_inr",
"realized_pnl",
"realized_pnl_inr",
"transfer_expense",
"transfer_expense_inr",
"net_realized_pnl",
"net_realized_pnl_inr"
],
"rows": [
[
"trade",
-415430.8,
-36089010.8272,
-415430.8,
-36089010.8272,
46,
3808.5411,
-415476.8,
-36092819.3683
],
[
"lost",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"gift_send",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"gift_receive",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"transfer_in",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"transfer_out",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"buy_back",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "stock_transaction_summary_table"
}
],
"name": "stock_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Alphabet",
1,
1463356800000,
55,
4020.0738,
"USD",
3,
219.2768
]
],
"name": "dividend_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"country",
"symbol",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"buy_price_inr",
"cost_of_acquisition",
"cost_of_acquisition_inr",
"sell_trade_id",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transfer_expenses",
"transfer_expenses_inr",
"nature_of_settlement",
"realized_pnl",
"realized_pnl_inr",
"net_realized_pnl",
"net_realized_pnl_inr",
"taxable_pnl",
"taxable_pnl_inr",
"turnover",
"turnover_inr",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"US0378331005",
null,
"Apple",
645,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136,
9940.546,
136,
9940.546,
"CYX9TQSTWUYK8C9Z7BCE",
1650412800000,
0,
0,
null,
25,
1906.9114,
null,
-87720,
-6411652.17,
-87745,
-6413559.0814,
-87745,
-6413559.0814,
0,
6411652.17,
"business_and_profession",
"speculative",
"slab_rate"
]
],
"name": "dr_tradewise_intraday_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"country",
"symbol",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"buy_price_inr",
"cost_of_acquisition",
"cost_of_acquisition_inr",
"sell_trade_id",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transfer_expenses",
"transfer_expenses_inr",
"nature_of_settlement",
"realized_pnl",
"realized_pnl_inr",
"net_realized_pnl",
"net_realized_pnl_inr",
"taxable_pnl",
"taxable_pnl_inr",
"holding_period",
"turnover",
"turnover_inr",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"US0378331008",
null,
"NVIDIA",
254,
"VQLDME6IOJZR95BDEKQ9",
1692316800000,
1290.98,
116903.1399,
1290.98,
116903.1399,
"VXFUFI5Q9HH7FEJPLV3B",
1692403200000,
0.78,
70.632,
"EUR",
21,
1901.6297,
"trade",
-327710.8,
-29677358.6572,
-327731.8,
-29677358.6572,
-327731.8,
-29677358.6572,
"short_term",
198.12,
17940.5181,
"capital_gains",
"securities",
"slab_rate"
]
],
"name": "dr_tradewise_delivery_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"fifty_two_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
],
"name": "reference_data_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"buy_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price",
"last_traded_price_inr",
"unrealized_pnl",
"unrealized_pnl_inr"
],
"rows": [
[
"US0378331022",
"MSFT",
20,
1463356800000,
56,
56,
null,
"POUND",
"buy",
null,
null,
100
]
],
"name": "dr_tradewise_holding_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price",
"last_traded_price_inr",
"unrealized_pnl",
"unrealized_pnl_inr"
],
"rows": [
[
"US0378331012",
"MONSTER",
1,
1650412800000,
800,
800,
null,
"DIRHAM",
"sell",
null
]
],
"name": "dr_tradewise_open_sell_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"transfer_date",
"price",
"price_inr",
"currency",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_value_inr",
"transfer_expense",
"transfer_expense_inr"
],
"rows": [],
"name": "dr_tradewise_transfer_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"total_transaction_value_inr",
"realized_pnl",
"realized_pnl_inr",
"transfer_expense",
"transfer_expense_inr",
"net_realized_pnl",
"net_realized_pnl_inr"
],
"rows": [
[
"trade",
-415430.8,
-36089010.8272,
-415430.8,
-36089010.8272,
46,
3808.5411,
-415476.8,
-36092819.3683
],
[
"lost",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"gift_send",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"gift_receive",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"transfer_in",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"transfer_out",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"buy_back",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "dr_transaction_summary_table"
}
],
"name": "dr_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Alphabet",
2,
1463356800000,
55,
4020.0738,
"USD",
3,
219.2768
]
],
"name": "dividend_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_date",
"buy_trade_id",
"buy_price",
"buy_price_inr",
"cost_of_acquisition",
"cost_of_acquisition_inr",
"sell_trade_id",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transfer_expenses",
"transfer_expenses_inr",
"realized_pnl",
"realized_pnl_inr",
"net_realized_pnl",
"net_realized_pnl_inr",
"taxable_pnl",
"taxable_pnl_inr",
"turnover",
"turnover_inr",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"US0378331005",
"INV",
"equity",
645,
1463356800000,
"CJ1CLC4YCBFEZ4CVDNMH",
136,
9940.546,
136,
9940.546,
"CYX9TQSTWUYK8C9Z7BCE",
1650412800000,
0,
0,
null,
25,
1906.9114,
-87720,
-6411652.17,
-87745,
-6413559.0814,
-87745,
-6413559.0814,
0,
6411652.17,
"business_and_profession",
"speculative",
"slab_rate"
]
],
"name": "etf_tradewise_intraday_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"country",
"scheme_name",
"scheme_type",
"quantity",
"buy_date",
"buy_trade_id",
"buy_price",
"buy_price_inr",
"cost_of_acquisition",
"cost_of_acquisition_inr",
"sell_trade_id",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transfer_expenses",
"transfer_expenses_inr",
"nature_of_settlement",
"realized_pnl",
"realized_pnl_inr",
"net_realized_pnl",
"net_realized_pnl_inr",
"taxable_pnl",
"taxable_pnl_inr",
"holding_period",
"turnover",
"turnover_inr",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"US0378331008",
null,
"FRO",
"debt",
254,
1692316800000,
"VQLDME6IOJZR95BDEKQ9",
1290.98,
116903.1399,
1290.98,
116903.1399,
"VXFUFI5Q9HH7FEJPLV3B",
1692403200000,
0,
0,
"EUR",
21,
1901.6297,
"trade",
-327908.92,
-29693397.5456,
-327929.92,
-29695299.1753,
-327929.92,
-29695299.1753,
"short_term",
0,
0,
"capital_gains",
"securities",
"slab_rate"
]
],
"name": "etf_tradewise_delivery_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"fifty_two_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
],
"name": "reference_data_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"transfer_date",
"price",
"price_inr",
"currency",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_value_inr",
"transfer_expense",
"transfer_expense_inr"
],
"rows": [],
"name": "etf_tradewise_transfer_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_date",
"buy_price",
"buy_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price",
"last_traded_price_inr",
"unrealized_pnl",
"unrealized_pnl_inr"
],
"rows": [
[
"US0378331022",
"MSFT",
"equity",
20,
1463356800000,
56,
56,
null,
"POUND",
"buy",
null
],
[
"US0378331322",
"Fidelity",
"debt",
1,
1463356800000,
5,
5,
null,
"USD",
"buy",
null
]
],
"name": "etf_tradewise_holding_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price",
"last_traded_price_inr",
"unrealized_pnl",
"unrealized_pnl_inr"
],
"rows": [
[
"US0378331022",
"MSFT",
"equity",
20,
1463356800000,
56,
null,
"POUND",
"sell",
null,
100
],
[
"US0378331322",
"Fidelity",
"debt",
1,
1463356800000,
5,
null,
"USD",
"sell",
null,
12
]
],
"name": "etf_tradewise_open_sell_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"total_transaction_value_inr",
"realized_pnl",
"realized_pnl_inr",
"transfer_expense",
"transfer_expense_inr",
"net_realized_pnl",
"net_realized_pnl_inr"
],
"rows": [
[
"trade",
-415628.92,
-36105049.7156,
-415628.92,
-36105049.7156,
46,
3808.5411,
-415674.92,
-36108858.2567
],
[
"lost",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"gift_send",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"gift_receive",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"transfer_in",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"transfer_out",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"buy_back",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "etf_transaction_summary_table"
}
],
"name": "etf_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Alphabet",
2,
1463356800000,
55,
4020.0738,
"USD",
3,
219.2768
]
],
"name": "dividend_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"country",
"scheme_name",
"scheme_type",
"quantity",
"buy_date",
"buy_trade_id",
"buy_price",
"buy_price_inr",
"cost_of_acquisition",
"cost_of_acquisition_inr",
"sell_trade_id",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transfer_expenses",
"transfer_expenses_inr",
"nature_of_settlement",
"realized_pnl",
"realized_pnl_inr",
"net_realized_pnl",
"net_realized_pnl_inr",
"taxable_pnl",
"taxable_pnl_inr",
"holding_period",
"turnover",
"turnover_inr",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"US0378331005",
null,
"INV",
"equity",
645,
1463356800000,
"CJ1CLC4YCBFEZ4CVDNMH",
136,
9940.546,
170.52,
12463.6905,
"CYX9TQSTWUYK8C9Z7BCE",
1650412800000,
0,
0,
"USD",
25,
1906.9114,
"trade",
-87720,
-6411652.17,
-87745,
-6413559.0814,
-195.52,
-12488.6905,
"long_term",
0,
0,
"capital_gains",
"securities",
"12.5"
],
[
"US0378331008",
null,
"FRO",
"debt",
254,
1692316800000,
"VQLDME6IOJZR95BDEKQ9",
1290.98,
116903.1399,
1290.98,
116903.1399,
"VXFUFI5Q9HH7FEJPLV3B",
1692403200000,
0.78,
70.632,
"EUR",
21,
1901.6297,
"trade",
-327710.8,
-29675457.0275,
-327731.8,
-29677358.6572,
-327731.8,
-29677358.6572,
"short_term",
198.12,
17940.5181,
"capital_gains",
"securities",
"slab_rate"
]
],
"name": "mutual_fund_tradewise_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"fifty_two_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
],
"name": "reference_data_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"transfer_date",
"price",
"price_inr",
"currency",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_value_inr",
"transfer_expense",
"transfer_expense_inr"
],
"rows": [],
"name": "mutual_fund_tradewise_transfer_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_date",
"buy_price",
"buy_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price",
"last_traded_price_inr",
"unrealized_pnl",
"unrealized_pnl_inr"
],
"rows": [
[
"US0378331022",
"MSFT",
"equity",
20,
1463356800000,
56,
56,
null,
"POUND",
"buy",
null
],
[
"US0378331322",
"Fidelity",
"debt",
1,
1463356800000,
5,
5,
null,
"USD",
"buy",
null
]
],
"name": "mutual_fund_tradewise_holding_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price",
"last_traded_price_inr",
"unrealized_pnl",
"unrealized_pnl_inr"
],
"rows": [
[
"US0378331022",
"MSFT",
"equity",
20,
1463356800000,
56,
56,
null,
"POUND",
"sell",
null
],
[
"US0378331322",
"Fidelity",
"debt",
1,
1463356800000,
5,
5,
null,
"USD",
"sell",
null
]
],
"name": "mutual_fund_tradewise_open_sell_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"total_transaction_value_inr",
"realized_pnl",
"realized_pnl_inr",
"transfer_expense",
"transfer_expense_inr",
"net_realized_pnl",
"net_realized_pnl_inr"
],
"rows": [
[
"trade",
0,
-36087109.1975,
-415430.8,
-36087109.1975,
46,
3808.5411,
-415476.8,
-36090917.7386
],
[
"lost",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"gift_send",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"gift_receive",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"transfer_in",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"transfer_out",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"buy_back",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "mutual_fund_transaction_summary_table"
}
],
"name": "mutual_fund_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "list",
"items": [],
"name": "client_details_list"
}
],
"name": "client_details_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"description",
"date",
"amount",
"amount_inr",
"currency",
"tax_witheld",
"tax_withheld_inr"
],
"rows": [
[
"GG",
1463356800000,
8,
584.738,
"USD",
0.12,
8.7711
],
[
"WP",
1692316800000,
54,
4889.905,
"EUR",
2,
181.1076
]
],
"name": "interest_income_table"
}
],
"name": "interest_income_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"quarter",
"asset_class",
"asset_type",
"income_head",
"income_sub_head",
"tax_rate",
"section",
"holding_period",
"turnover_inr",
"buy_value_inr",
"cost_of_acquisition_inr",
"sell_value_inr",
"realized_pnl_inr",
"transfer_expenses_inr",
"net_realized_pnl_inr",
"taxable_pnl_inr"
],
"rows": [
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
17940.5181,
29693397.5346,
29693397.5346,
17940.528,
-29677358.6572,
1901.6297,
-29677358.6572,
-29677358.6572
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
6411652.17,
87720,
6411652.17,
0,
-6411652.17,
1906.9114,
-6413559.0814,
-6413559.0814
],
[
2,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
17940.5181,
29693397.5456,
29693397.5346,
17940.5181,
-29677358.6572,
1901.6297,
-29677358.6572,
-29677358.6572
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
6411652.17,
87720,
6411652.17,
0,
-6411652.17,
1906.9114,
-6413559.0814,
-6413559.0814
],
[
2,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
29693397.5456,
29693397.5346,
0,
-29693397.5456,
1901.6297,
-29695299.1753,
-29695299.1753
],
[
3,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"etf",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"etf",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"etf",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"etf",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
6411652.17,
87720,
6411652.17,
0,
-6411652.17,
1906.9114,
-6413559.0814,
-6413559.0814
],
[
2,
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
17940.5181,
29693397.5456,
29693397.5346,
17940.5181,
-29675457.0275,
1901.6297,
-29677358.6572,
-29677358.6572
],
[
3,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
6411652.17,
8039080.3725,
0,
-6411652.17,
1906.9114,
-6413559.0814,
-12488.6905
],
[
2,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"mutual_fund",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"mutual_fund",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"mutual_fund",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"mutual_fund",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "asset_wise_quarter_wise_tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"quarter",
"income_head",
"income_sub_head",
"holding_period",
"tax_rate",
"section",
"turnover_inr",
"buy_value_inr",
"cost_of_acquisition_inr",
"sell_value_inr",
"realized_pnl_inr",
"transfer_expenses_inr",
"net_realized_pnl_inr",
"taxable_pnl_inr"
],
"rows": [
[
2,
"capital_gains",
"securities",
"short_term",
"slab_rate",
null,
53821.5543,
467612.5596,
467612.5596,
211.896,
-118723571.8875,
7606.5188,
-118727375.1469,
-118727375.1469
],
[
1,
"capital_gains",
"securities",
"long_term",
"12.5",
null,
0,
9940.546,
12463.6905,
0,
-6411652.17,
1906.9114,
-6413559.0814,
-12488.6905
],
[
1,
"business_and_profession",
"speculative",
"intraday",
"slab_rate",
null,
19234956.51,
29821.638,
29821.638,
0,
-19234956.51,
5720.7342,
-19240677.2442,
-19240677.2442
]
],
"name": "quarter_wise_tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"asset_class",
"asset_type",
"income_head",
"income_sub_head",
"tax_rate",
"section",
"holding_period",
"turnover_inr",
"buy_value_inr",
"cost_of_acquisition_inr",
"sell_value_inr",
"realized_pnl_inr",
"transfer_expenses_inr",
"net_realized_pnl_inr",
"taxable_pnl_inr"
],
"rows": [
[
"other",
"etf",
"capital_gains",
"securities",
"12.5",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
6411652.17,
8039080.3725,
0,
-6411652.17,
1906.9114,
-6413559.0814,
-12488.6905
],
[
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
12823304.34,
175440,
12823304.34,
0,
-12823304.34,
3813.8228,
-12827118.1628,
-12827118.1628
],
[
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"mutual_fund",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
6411652.17,
87720,
6411652.17,
0,
-6411652.17,
1906.9114,
-6413559.0814,
-6413559.0814
],
[
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
17940.5181,
29693397.5456,
29693397.5346,
17940.5181,
-29675457.0275,
1901.6297,
-29677358.6572,
-29677358.6572
],
[
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
29693397.5456,
29693397.5346,
0,
-29693397.5456,
1901.6297,
-29695299.1753,
-29695299.1753
],
[
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
35881.0362,
59386795.0802,
59386795.0692,
35881.0461,
-59354717.3144,
3803.2594,
-59354717.3144,
-59354717.3144
],
[
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "asset_wise_tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"tax_rate",
"section",
"holding_period",
"turnover_inr",
"buy_value_inr",
"cost_of_acquisition_inr",
"sell_value_inr",
"realized_pnl_inr",
"transfer_expenses_inr",
"net_realized_pnl_inr",
"taxable_pnl_inr"
],
"rows": [
[
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
53821.5543,
467612.5596,
467612.5596,
211.896,
-118723571.8875,
7606.5188,
-118727375.1469,
-118727375.1469
],
[
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
19234956.51,
29821.638,
29821.638,
0,
-19234956.51,
5720.7342,
-19240677.2442,
-19240677.2442
],
[
"capital_gains",
"securities",
"12.5",
null,
"long_term",
0,
9940.546,
12463.6905,
0,
-6411652.17,
1906.9114,
-6413559.0814,
-12488.6905
]
],
"name": "tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"tax_rate",
"holding_period",
"section",
"taxable_income",
"income_setoff_against_non_speculative_business_loss",
"income_setoff_against_loss_from_other_sources",
"income_setoff_against_stcl_15_percent",
"income_setoff_against_stcl_20_percent",
"income_setoff_against_stcl_30_percent",
"income_setoff_against_stcl_slab_rate",
"income_setoff_against_ltcl_10_percent",
"income_setoff_against_ltcl_10_percent_112a",
"income_setoff_against_ltcl_12_5_percent",
"income_setoff_against_ltcl_12_5_percent_112a",
"income_setoff_against_ltcl_20_percent",
"net_taxable_income"
],
"rows": [
[
"business_and_profession",
"speculative",
null,
null,
null,
0,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0
],
[
"other",
"other_interest",
"slab_rate",
null,
null,
0,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0
],
[
"capital_gains",
"securities",
"slab_rate",
"short_term",
null,
53821.5642,
0,
0,
0,
0,
0,
null,
null,
null,
null,
null,
null,
53821.5642
],
[
"capital_gains",
"securities",
"12.5",
"long_term",
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
0,
0,
0
],
[
"capital_gains",
"securities",
"20",
"long_term",
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
0
]
],
"name": "current_year_income_adjustment_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"quarter",
"net_taxable_stcg",
"net_taxable_ltcg",
"net_taxable_stcg_15",
"net_taxable_stcg_20",
"net_taxable_stcg_30",
"net_taxable_stcg_slab_rate",
"net_taxable_ltcg_10",
"net_taxable_ltcg_10_112a",
"net_taxable_ltcg_12_5",
"net_taxable_ltcg_12_5_112a",
"net_taxable_ltcg_20"
],
"rows": [
[
1,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "accrued_capital_gains_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"tax_rate",
"holding_period",
"section",
"taxable_loss",
"loss_setoff_against_non_speculative_business_income",
"loss_setoff_against_speculative_business_income",
"loss_setoff_against_stcg_15_percent",
"loss_setoff_against_stcg_20_percent",
"loss_setoff_against_stcg_30_percent",
"loss_setoff_against_stcg_slab_rate",
"loss_setoff_against_ltcg_10_percent",
"loss_setoff_against_ltcg_10_percent_112a",
"loss_setoff_against_ltcg_12_5_percent",
"loss_setoff_against_ltcg_12_5_percent_112a",
"loss_setoff_against_ltcg_20_percent",
"loss_setoff_against_other_income",
"total_losses_setoff",
"losses_remaining"
],
"rows": [
[
"business_and_profession",
"speculative",
null,
null,
null,
263160,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0
],
[
"capital_gains",
"securities",
"slab_rate",
"short_term",
null,
0,
null,
null,
0,
0,
0,
null,
0,
0,
0,
null,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"12.5",
"long_term",
null,
0,
null,
null,
null,
null,
null,
null,
0,
0,
null,
0,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"20",
"long_term",
null,
0,
null,
null,
null,
null,
null,
null,
0,
0,
0,
0,
null,
null,
0,
0
]
],
"name": "current_year_loss_adjustment_table"
}
],
"name": "tax_pnl_summary_sheet"
}
],
"name": "foreign_securities_tradewise_tax_pnl_workbook"
},
"transaction_id": "5d6b57fa-2013-4d79-a620-ba3b0ef7027a"
}
Scripwise Tax PnL
Click here to learn more about this JSON Payload
{
"code": 200,
"timestamp": 1745489297427,
"data": {
"metadata": {},
"@entity": "workbook",
"sheets": [
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"symbol",
"quantity",
"buy_average",
"cost_of_acquisition",
"sell_average",
"transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
null,
"US0378331008",
"NVIDIA",
254,
116903.1399,
116903.1399,
70.632,
1901.6297,
"trade",
-327710.8,
-327731.8,
-327731.8,
"short_term",
17940.528,
"capital_gains",
"securities",
"slab_rate"
]
],
"name": "stock_scripwise_delivery_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"symbol",
"quantity",
"buy_average",
"cost_of_acquisition",
"sell_average",
"transfer_expenses",
"realized_pnl",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
null,
"US0378331005",
"Apple",
645,
9940.546,
null,
0.0,
1906.9114,
-87720.0,
-87745.0,
-87745.0,
0.0,
"business_and_profession",
"speculative",
"slab_rate"
]
],
"name": "stock_scripwise_intraday_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"symbol",
"quantity",
"buy_average",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"US0378331022",
"AMAZON",
20,
56.0,
"buy",
null
],
[
null,
"US0378331023",
"INTEL",
35,
88.0,
"buy",
null
]
],
"name": "stock_scripwise_holding_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"symbol",
"quantity",
"sell_average",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"US0378331013",
"TSLA",
56,
95.0,
"sell",
null
],
[
null,
"US0378331012",
"MONSTER",
1,
800.0,
"sell",
null
]
],
"name": "stock_scripwise_open_sell_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"fifty_two_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
],
"name": "reference_data_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Meta",
1,
1463356800000,
55,
4020.0738,
"USD",
3,
219.2768
]
],
"name": "dividend_table"
}
],
"name": "stock_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"symbol",
"quantity",
"buy_average",
"sell_average",
"transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
null,
"US0378331008",
"NVIDIA",
254,
116903.1399,
70.632,
1901.6297,
"trade",
-327710.8,
-327731.8,
-327731.8,
"short_term",
17940.528,
"capital_gains",
"securities",
"slab_rate"
]
],
"name": "dr_scripwise_delivery_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"symbol",
"quantity",
"buy_average",
"cost_of_acquisition",
"sell_average",
"transfer_expenses",
"realized_pnl",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
null,
"US0378331005",
"Apple",
645,
9940.546,
null,
0.0,
1906.9114,
-87720.0,
-87745.0,
-87745.0,
0.0,
"business_and_profession",
"speculative",
"slab_rate"
]
],
"name": "dr_scripwise_intraday_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"symbol",
"quantity",
"buy_average",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"US0378331022",
"MSFT",
20,
56.0,
"buy",
null
]
],
"name": "dr_scripwise_holding_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"symbol",
"quantity",
"sell_average",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"US0378331012",
"MONSTER",
1,
800.0,
null,
"sell",
null
]
],
"name": "dr_scripwise_open_sell_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"fifty_two_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
],
"name": "reference_data_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Alphabet",
1,
1463356800000,
55,
4020.0738,
"USD",
3,
219.2768
]
],
"name": "dividend_table"
}
],
"name": "dr_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_average",
"cost_of_acquisition",
"sell_average",
"transfer_expense",
"nature_of_settlement",
"realized_pnl",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
null,
"US0378331008",
"FRO",
"debt",
254,
116903.1399,
116903.1399,
0.0,
1901.6297,
"trade",
-327908.92,
-327929.92,
-327929.92,
"short_term",
0.0,
"capital_gains",
"securities",
"slab_rate"
]
],
"name": "etf_scripwise_delivery_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_average",
"cost_of_acquisition",
"sell_average",
"transfer_expense",
"realized_pnl",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
null,
"US0378331005",
"INV",
"equity",
645,
9940.546,
9940.546,
0.0,
1906.9114,
-87720.0,
-87745.0,
-87745.0,
0.0,
"business_and_profession",
"speculative",
"slab_rate"
]
],
"name": "etf_scripwise_intraday_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_average",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"US0378331022",
"MSFT",
"equity",
20,
56.0,
"buy",
null
],
[
null,
"US0378331322",
"Fidelity",
"debt",
1,
5.0,
"buy",
null
]
],
"name": "etf_scripwise_holding_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"scheme_name",
"scheme_type",
"quantity",
"sell_average",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"US0378331322",
"Fidelity",
"debt",
1,
null,
null,
null
],
[
null,
"US0378331022",
"MSFT",
"equity",
20,
null,
null,
null
]
],
"name": "etf_scripwise_open_sell_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"fifty_two_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
],
"name": "reference_data_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Alphabet",
2,
1463356800000,
55,
4020.0738,
"USD",
3,
219.2768
]
],
"name": "dividend_table"
}
],
"name": "etf_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_average",
"cost_of_acquisition",
"sell_average",
"transfer_expense",
"nature_of_settlement",
"realized_pnl",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
null,
"US0378331005",
"INV",
"equity",
645,
9940.546,
9940.546,
0.0,
1906.9114,
"trade",
-87720.0,
-87745.0,
-195.52,
"long_term",
0.0,
"capital_gains",
"securities",
"12.5"
],
[
null,
"US0378331008",
"FRO",
"debt",
254,
116903.1399,
116903.1399,
70.632,
1901.6297,
"trade",
-327710.8,
-327731.8,
-327731.8,
"short_term",
17940.528,
"capital_gains",
"securities",
"slab_rate"
]
],
"name": "mutual_fund_scripwise_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_average",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"US0378331022",
"MSFT",
"equity",
20,
56.0,
"buy",
null
],
[
null,
"US0378331322",
"Fidelity",
"debt",
1,
5.0,
"buy",
null
]
],
"name": "mutual_fund_scripwise_holding_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"id",
"isin",
"scheme_name",
"scheme_type",
"quantity",
"sell_average",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"US0378331022",
"MSFT",
"equity",
20,
56.0,
"sell",
null
],
[
null,
"US0378331322",
"Fidelity",
"debt",
1,
5.0,
"sell",
null
]
],
"name": "mutual_fund_scripwise_open_sell_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"fifty_two_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
],
"name": "reference_data_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Alphabet",
2,
1463356800000,
55,
4020.0738,
"USD",
3,
219.2768
]
],
"name": "dividend_table"
}
],
"name": "mutual_fund_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "list",
"items": [],
"name": "client_details_list"
}
],
"name": "client_details_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"description",
"date",
"amount",
"amount_inr",
"currency",
"tax_witheld",
"tax_withheld_inr"
],
"rows": [
[
"GG",
1463356800000,
8,
584.738,
"USD",
0.12,
8.7711
],
[
"WP",
1692316800000,
54,
4889.905,
"EUR",
2,
181.1076
]
],
"name": "interest_income_table"
}
],
"name": "interest_income_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"asset_class",
"asset_type",
"income_head",
"income_sub_head",
"tax_rate",
"section",
"holding_period",
"turnover",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
17940.528,
2.96933975346E7,
0,
17940.528,
-327710.8,
1901.6297,
-327731.8,
-327731.8
],
[
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0.0,
6411652.17,
0,
0.0,
-87720.0,
1906.9114,
-87745.0,
-87745.0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
17940.528,
2.96933975346E7,
0,
17940.528,
-327710.8,
1901.6297,
-327731.8,
-327731.8
],
[
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"other",
"other_exempt_income",
"0",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0.0,
6411652.17,
0,
0.0,
-87720.0,
1906.9114,
-87745.0,
-87745.0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0.0,
2.96933975346E7,
0,
0.0,
-327908.92,
1901.6297,
-327929.92,
-327929.92
],
[
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0.0,
6411652.17,
0,
0.0,
-87720.0,
1906.9114,
-87745.0,
-87745.0
],
[
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
17940.528,
2.96933975346E7,
0,
17940.528,
-327710.8,
1901.6297,
-327731.8,
-327731.8
],
[
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0.0,
6411652.17,
0,
0.0,
-87720.0,
1906.9114,
-87745.0,
-195.52
],
[
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"capital_gains",
"securities",
"20",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "asset_wise_tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"quarter",
"income_head",
"income_sub_head",
"holding_period",
"tax_rate",
"turnover",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
1,
"capital_gains",
"securities",
"short_term",
"slab_rate",
53821.584,
467612.5596,
350709.4197,
211.896,
-1311041.32,
7606.5188,
-1311125.32,
-1311125.32
],
[
1,
"capital_gains",
"securities",
"long_term",
"12.5",
0.0,
9940.546,
9940.546,
0.0,
-87720.0,
1906.9114,
-87745.0,
-195.52
],
[
1,
"business_and_profession",
"speculative",
"intraday",
"slab_rate",
0.0,
9940.546,
9940.546,
0.0,
-87720.0,
1906.9114,
-87745.0,
-87745.0
]
],
"name": "quarter_wise_tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"holding_period",
"tax_rate",
"turnover",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
"capital_gains",
"securities",
"short_term",
"slab_rate",
53821.584,
467612.5596,
350709.4197,
211.896,
-1311041.32,
7606.5188,
-1311125.32,
-1311125.32
],
[
"capital_gains",
"securities",
"long_term",
"12.5",
0.0,
9940.546,
9940.546,
0.0,
-87720.0,
1906.9114,
-87745.0,
-195.52
],
[
"business_and_profession",
"speculative",
"intraday",
"slab_rate",
0.0,
9940.546,
9940.546,
0.0,
-87720.0,
1906.9114,
-87745.0,
-87745.0
]
],
"name": "tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"tax_rate",
"holding_period",
"section",
"taxable_income",
"income_setoff_against_non_speculative_business_loss",
"income_setoff_against_loss_from_other_sources",
"income_setoff_against_stcl_15_percent",
"income_setoff_against_stcl_20_percent",
"income_setoff_against_stcl_30_percent",
"income_setoff_against_stcl_slab_rate",
"income_setoff_against_ltcl_10_percent",
"income_setoff_against_ltcl_10_percent_112a",
"income_setoff_against_ltcl_12_5_percent",
"income_setoff_against_ltcl_12_5_percent_112a",
"income_setoff_against_ltcl_20_percent",
"net_taxable_income"
],
"rows": [
[
"business_and_profession",
"speculative",
null,
null,
null,
0,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0
],
[
"other",
"other_interest",
"slab_rate",
null,
null,
0,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0
],
[
"capital_gains",
"securities",
"slab_rate",
"short_term",
null,
0,
0,
0,
0,
0,
0,
null,
null,
null,
null,
null,
null,
0
],
[
"capital_gains",
"securities",
"12.5",
"long_term",
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
0,
0,
0
],
[
"capital_gains",
"securities",
"20",
"long_term",
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
0
]
],
"name": "current_year_income_adjustment_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"quarter",
"net_taxable_stcg",
"net_taxable_ltcg",
"net_taxable_stcg_15",
"net_taxable_stcg_20",
"net_taxable_stcg_30",
"net_taxable_stcg_slab_rate",
"net_taxable_ltcg_10",
"net_taxable_ltcg_10_112a",
"net_taxable_ltcg_12_5",
"net_taxable_ltcg_12_5_112a",
"net_taxable_ltcg_20"
],
"rows": [
[
1,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[],
[],
[]
],
"name": "accrued_capital_gains_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"tax_rate",
"holding_period",
"section",
"taxable_loss",
"loss_setoff_against_non_speculative_business_income",
"loss_setoff_against_speculative_business_income",
"loss_setoff_against_stcg_15_percent",
"loss_setoff_against_stcg_20_percent",
"loss_setoff_against_stcg_30_percent",
"loss_setoff_against_stcg_slab_rate",
"loss_setoff_against_ltcg_10_percent",
"loss_setoff_against_ltcg_10_percent_112a",
"loss_setoff_against_ltcg_12_5_percent",
"loss_setoff_against_ltcg_12_5_percent_112a",
"loss_setoff_against_ltcg_20_percent",
"loss_setoff_against_other_income",
"total_losses_setoff",
"losses_remaining"
],
"rows": [
[
"business_and_profession",
"speculative",
null,
null,
null,
19240677,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0,
19240677
],
[
"capital_gains",
"securities",
"slab_rate",
"short_term",
null,
1311125.32,
null,
null,
0,
0,
0,
null,
0,
0,
0,
null,
0,
null,
0,
1311125.32
],
[
"capital_gains",
"securities",
"12.5",
"long_term",
null,
0,
null,
null,
null,
null,
null,
null,
0,
0,
null,
0,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"20",
"long_term",
null,
0,
null,
null,
null,
null,
null,
null,
0,
0,
0,
0,
null,
null,
0,
0
]
],
"name": "current_year_loss_adjustment_table"
}
],
"name": "tax_pnl_summary_sheet"
}
],
"name": "foreign_securities_scripwise_tax_pnl_workbook"
},
"transaction_id": "75d6bcbe-79a9-4cd8-9129-f9ef5e6d5e11"
}