Scripwise Tax P&L Workbook
Calculate Tax P&L API
| HTTP Method | Resource |
|---|---|
POST | /it-calculator/securities/domestic/report/tax-pnl/generate |
Scripwise Tax P&L Workbook
You can refer to the sample response in workbook format
The API responds back in a sheet structure. An example response is shown below.
Equity Sheet
Equity Intraday Scripwise Tax P/L Table
This table represents all your intraday settled trades
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| symbol | string | Symbol or description of equity share |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a units were bought |
| sell_average | number | Price at which a units were sold |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| total_transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Equity Delivery Scripwise Tax P/L Table
This table represents all your delivery settled trades
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| symbol | string | Symbol or description of equity share |
| is_listed | boolean | is the equity share listed in public markets |
| is_stt_paid | boolean | was security transaction tax paid on this trade |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a units were bought |
| sell_average | number | Price at which a units were sold |
| fmv | number | Fare market value as on 31.01.2018 |
| cost_of_acquisition | number | cost of acquisition considered for calculating taxable pnl. |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| nature_of_settlement | string | The nature of the transaction of the equity share |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| total_transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| holding_period | string | The holding period of the equity utual fund could be either long_term or short_term |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Equity Scripwise Holding Table
This table represents all your Equity holdings
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| symbol | string | Symbol or description of equity share |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a units were bought |
| last_traded_price | string | Last traded market price of the equity share. |
| unrealized_pnl | string | Unrealized pnl on the holding |
Equity Scripwise Open Sell Table
This table represents all your Equity open sell/short sell positions
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| symbol | string | Total value of the all the transactions |
| quantity | number | The realized profit or loss on the trade without considering transfer expenses |
| sell_average | number | Price at which a units were sold |
| last_traded_price | number | Last traded market price of the equity share. |
| unrealized_pnl | number | The unrealized profit or loss on the trade without considering transfer expenses |
ETF Sheet
ETF Intraday Scripwise Tax P/L Table
This table represents all your intraday settled trades
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| scheme_name | string | Symbol or description of equity share |
| asset_class | string | Asset class of fund, possible valuesequity, debt, other |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a unit was bought |
| sell_average | number | Price at which a unit was sold |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| total_transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
ETF Delivery Scripwise Tax P/L Table
This table represents all your delivery settled trades
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| scheme_name | string | Symbol or description of equity share |
| asset_class | string | Asset class of fund, possible valuesequity, debt, other |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a unit was bought |
| sell_average | number | Price at which a unit was sold |
| cost_of_acquisition | number | cost of acquisition considered for calculating taxable pnl. |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| total_transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| holding_period | string | The holding period of the mutual fund could be either long_term or short_term |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
ETF Scripwise Holding Table
This table represents all your ETF holdings
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| scheme_name | string | Symbol or description of ETF unit |
| asset_class | string | Asset class of fund, possible valuesequity, debt, other |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a unit was bought |
| last_traded_price | string | Last traded market price of the ETF unit. |
| unrealized_pnl | string | Unrealized pnl on the holding |
ETF Scripwise Open Sell Table
This table represents all your ETF open sell/short sell positions
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| scheme_name | string | Symbol or description of ETF unit |
| asset_class | string | Asset class of fund, possible valuesequity, debt, other |
| quantity | number | Trading quantity |
| sell_average | number | Price at which a unit was sold |
| last_traded_price | string | Last traded market price of the ETF unit. |
| unrealized_pnl | string | Unrealized pnl on the holding |
Mutual Fund Sheet
Mutual Fund Scripwise Tax P/L Table
This table represents all your Mutual Fund tradewise settlements
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| scheme_name | string | Symbol or description of equity share |
| asset_class | string | Asset class of fund, possible valuesequity, debt, other |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a units were bought |
| sell_average | number | Price at which a units were sold |
| cost_of_acquisition | number | cost of acquisition considered for calculating taxable pnl. |
| nature_of_settlement | string | The nature of the transaction of the equity share |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| holding_period | string | The holding period of the mutual fund could be either long_term or short_term |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Mutual Fund Scripwise Holding Table
This table represents all your Mutual Funds holdings
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| scheme_name | string | Symbol or description of MF unit |
| asset_class | string | Asset class of fund, possible valuesequity, debt, other |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a units were bought |
| last_traded_price | string | Last traded market price of the MF unit. |
| unrealized_pnl | string | Unrealized pnl on the holding |
Mutual Fund Scripwise Open Sell Table
This table represents all your Mutual Fund open sell/short sell positions
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| scheme_name | string | Symbol or description of MF unit |
| asset_class | string | Asset class of fund, possible valuesequity, debt, other |
| quantity | number | Trading quantity |
| sell_average | number | Price at which a units were sold |
| last_traded_price | string | Last traded market price of the MF unit. |
| unrealized_pnl | string | Unrealized pnl on the holding |
Futures Sheet
Futures Scripwise Tax P/L Table
This table represents all your Futures tradewise settlements
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| contract_name | string | Name of contract |
| asset_class | string | The asset class of the contract. Possible valuesequity, currency & commodity |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a unit was bought |
| sell_average | number | Price at which a unit was sold |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| total_transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Futures Scripwise Open Position Table
This table represents all your Futures open positions
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| contract_name | string | Symbol or description of the contract |
| asset_class | string | Asset class of contract, possible valuesequity, currency & commodity |
| quantity | number | Trading quantity, a negative quantity indicates short sell |
| trade_price_average | number | Price at which contract was traded |
| last_traded_price | string | Last traded market price of the contract. |
| unrealized_pnl | string | Unrealized pnl on the open position. |
Options Sheet
Options Scripwise Tax P/L
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| contract_name | string | Name of contract |
| asset_class | string | The asset class of the contract. Possible valuesequity, currency & commodity |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a unit was bought |
| sell_average | number | Price at which a unit was sold |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| total_transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Options Scripwise Open Position Table
This table represents all your Options open positions
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| contract_name | string | Symbol or description of the contract |
| asset_class | string | Asset class of contract, possible valuesequity, currency & commodity |
| quantity | number | Trading quantity, a negative quantity indicates short sell |
| trade_price_average | number | Price at which contract was traded |
| last_traded_price | string | Last traded market price of the contract. |
| unrealized_pnl | string | Unrealized pnl on the open position. |
Bonds Sheet
Bonds Scripwise Tax P/L
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| security_name | string | Symbol or description of bond |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a unit was bought |
| sell_average | number | Price at which a unit was sold |
| cost_of_acquisition | number | cost of acquisition considered for calculating taxable pnl. |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stamp_duty | number | Stamp duty paid on transfer of bonds |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of bonds |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| total_transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| holding_period | string | The holding period of the equity utual fund could be either long_term or short_term |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Bonds Scripwise Holding Table
This table represents all your Bonds holdings
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| security_name | string | Symbol or description of bond |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a unit was bought |
| last_traded_price | string | Last traded market price of the bond. |
| unrealized_pnl | string | Unrealized pnl on the holding |
Bonds Scripwise Open Sell Table
This table represents all your Bonds open sell/short sell positions
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| security_name | string | Symbol or description of bond |
| quantity | number | Trading quantity |
| sell_average | number | Price at which a unit was sold |
| last_traded_price | string | Last traded market price of the bond. |
| unrealized_pnl | string | Unrealized pnl on the holding |
Debentures Sheet
Debentures Scripwise Tax P/L
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| security_name | string | Symbol or description of debenture |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a unit was bought |
| sell_average | number | Price at which a unit was sold |
| cost_of_acquisition | number | cost of acquisition considered for calculating taxable pnl. |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stamp_duty | number | Stamp duty paid on transfer of debentures |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of debentures |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| total_transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| holding_period | string | The holding period of the equity utual fund could be either long_term or short_term |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Debentures Scripwise Holding Table
This table represents all your Debentures holdings
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| security_name | string | Symbol or description of debenture |
| quantity | number | Trading quantity |
| buy_average | number | Price at which a unit was bought |
| last_traded_price | string | Last traded market price of the debenture. |
| unrealized_pnl | string | Unrealized pnl on the holding |
Debentures Scripwise Open Sell Table
This table represents all your Debentures open sell/short sell positions
Note: Only available for tradebook input
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| security_name | string | Symbol or description of debenture |
| quantity | number | Trading quantity |
| sell_average | number | Price at which a unit was sold |
| last_traded_price | string | Last traded market price of the debenture. |
| unrealized_pnl | string | Unrealized pnl on the holding |
Tax P/L Summary Sheet
Asset Wise Summary Table
| Param | Type | Description |
|---|---|---|
| asset_class | string | Asset class |
| asset_type | string | Asset category |
| income_head | string | The income head of ITR under which the income of a specific income is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific income is to be reported |
| holding_period | string | The holding period of the asset could be either long_term or short_term |
| turnover | number | Turnover of the transactions |
| buy_value | number | Sum of buy value for all trades of the asset |
| cost_of_acquisition | number | Sum of cost of acquisition value for all trades of the asset |
| sell_value | number | Sum of sell value for all trades of the asset |
| realized_pnl | number | The realized profit or loss on trades without considering transfer expenses |
| transfer_expenses | number | Any expense relating to the transfer of assets |
| net_realized_pnl | number | The realized profit or loss on trades after considering transfer expenses |
| taxable_pnl | number | The taxable amount |
Tax P/L Summary Table
This table gives a summary of your trades grouped by income_head, income_sub_head, and holding_period.
| Param | Type | Description |
|---|---|---|
| income_head | string | The income head of ITR under which the income is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income is to be reported |
| holding_period | string | The holding period of the crypto. |
| tax_rate | string | The applicable tax rate for all trades. |
| turnover | number | Turnover of the transactions for the asset |
| buy_value | number | Sum of buy value for all trades of the asset |
| cost_of_acquisition | number | Sum of cost of acquisition value for all trades of the asset |
| sell_value | number | Sum of sell value for all trades of the asset |
| realized_pnl | number | Total realized profit or loss on the trades without considering expenses |
| transfer_expenses | number | Total expenses that occurred during the transafer of crypto, could be network fees, brokerage, or any other transaction fee. |
| net_realized_pnl | number | Total realized profit or loss on the trades after considering expenses |
| taxable_pnl | string | The total taxable amount of all trades |
Sample Response
{
"code": 200,
"data": {
"name": "scripwise_tax_pnl_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "equity_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "equity_delivery_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"is_listed",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INE190B01037",
"BAJFIN",
true,
95,
500.0000,
600.0000,
500.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
9500.0000,
0.0000,
9500.0000,
9500.0000,
"long_term",
57000.0000,
"capital_gains",
"securities",
"10"
],
[
"INE190001019",
"NIP IND ETF GOLD BEES",
true,
75,
314,
0,
314,
148.0000,
0.0000,
108.0000,
0.0000,
12.0000,
6.0000,
0.0000,
0.0000,
0.0000,
0.0000,
-23550,
274.0000,
-23824.0000,
-23812.0000,
"long_term",
0,
"capital_gains",
"securities",
"10"
],
[
"INE190B01027",
"INFY",
true,
4,
300.0000,
390.0000,
300.0000,
12.6667,
1.3333,
3.3333,
6.6667,
5.3333,
0.0000,
0.0733,
0.0800,
0.2500,
2.0000,
360.0000,
31.7366,
328.2634,
333.5967,
"short_term",
1560.0000,
"capital_gains",
"securities",
"15"
],
[
"INE002A01019",
"AJANTA PHARMA LIMITED",
true,
16,
200,
911,
200,
130.5758,
0.0000,
0.0000,
0.0000,
6.0000,
1.9394,
0.0000,
0.0000,
0.0000,
0.0000,
11376,
138.5152,
11237.4848,
11243.4848,
"other",
14576,
"other",
"other_exempt_income",
"exempt"
]
]
},
{
"name": "equity_intraday_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_average",
"sell_average",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INE190B01019",
"HINDUJA GLOBAL SOLS. LTD.",
53.0000,
56.0000,
58.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
6.0000,
0.0000,
0.0000,
0.0000,
0.0000,
106.00000000,
6.0000,
100.00000000,
100.00000000,
106.00000000,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE190B01027",
"INFY",
5.0000,
300.0000,
305.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
25.00000000,
0.0000,
25.00000000,
25.00000000,
25.00000000,
"business_and_profession",
"speculative",
"slab_rate"
]
]
},
{
"name": "equity_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE190B01037",
"BAJFIN",
35.0000,
534.2857,
null,
null
],
[
"INE190B01020",
"RIL",
40.0000,
500.0000,
null,
null
],
[
"INE002A01019",
"AJANTA PHARMA LIMITED",
17.0000,
200.0000,
null,
null
],
[
"INE190A01019",
"ITC LTD",
11.0000,
346.0000,
null,
null
]
]
},
{
"name": "equity_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE190B01033",
"TCS",
10.0000,
1000.0000,
null,
null
],
[
"INE190B01027",
"INFY",
2.0000,
390.0000,
null,
null
]
]
}
]
},
{
"name": "mutual_fund_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "mutual_fund_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisition",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_subhead",
"tax_rate"
],
"rows": [
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
17.823,
10,
5,
10.0000,
-89.115,
20.0000,
-109.1150,
-109.1150000,
"short_term",
89.115,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
11.338,
150,
400,
160.0000,
2834.500,
100.8671,
2733.6329,
2620.2529000,
"long_term",
4535.200,
"capital_gains",
"securities",
"10"
],
[
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
36.023,
30,
60,
30.0000,
1080.690,
167.8919,
912.7981,
912.7981000,
"short_term",
2161.380,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
32.531,
400.784,
200,
400.7840,
-6531.704304,
23.5685,
-6555.272804,
-6555.2728040,
"short_term",
6506.200,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
19.574,
120,
160,
120.0000,
782.960,
95.7233,
687.2367,
687.2367000,
"short_term",
3131.840,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
33.807,
150,
250,
150.0000,
3380.700,
43.8583,
3336.8417,
3336.8417000,
"short_term",
8451.750,
"capital_gains",
"securities",
"15"
],
[
"INF200K01190",
"KOTAK SEC FUND",
"equity",
75,
986.6667,
1300.0000,
986.6667,
23499.9975,
1.0000,
23498.9975,
23498.9975,
"long_term",
97500.0000,
"capital_gains",
"securities",
"10"
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
0.123,
15,
60,
47.55,
5.535,
10.0070,
-4.4720,
-8.47565,
"long_term",
7.380,
"capital_gains",
"other_capital_gains",
"20"
],
[
"INF760K01FR2",
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
45.57,
23.21,
23.21,
23.2100,
0.0000,
2.8306,
-2.8306,
-2.830600,
"long_term",
1057.6797,
"capital_gains",
"securities",
"10"
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
6.651,
2,
500,
220.0000,
3312.198,
50.0013,
3262.1967,
1812.2787000,
"long_term",
3325.500,
"capital_gains",
"securities",
"10"
]
]
},
{
"name": "mutual_fund_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
19.3930,
10.0000,
null,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
10.9150,
150.0000,
null,
null
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
106.7680,
151.7878,
null,
null
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
2.5080,
400.7840,
null,
null
],
[
"INF200K01190",
"KOTAK SEC FUND",
"equity",
55.0000,
1145.4545,
null,
null
],
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
64.9620,
23.5080,
null,
null
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
34.8910,
15.0000,
null,
null
],
[
"INF760K01FR2",
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
64.1520,
23.2100,
null,
null
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
19.0290,
2.0000,
null,
null
]
]
},
{
"name": "mutual_fund_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
0.0390,
60.0000,
null,
null
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
17.1370,
160.0000,
null,
null
],
[
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
0.4040,
250.0000,
null,
null
],
[
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
32.3100,
900.0000,
null,
null
]
]
}
]
},
{
"name": "etf_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "etf_delivery_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisation",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
90,
150,
250,
150.0000,
6.0011,
2.0000,
1.0000,
0.0000,
5.4460,
0.0020,
36.0000,
36.0000,
0.0000,
0.0000,
9000,
86.4491,
8913.5509,
8918.9969,
"short_term",
22500,
"capital_gains",
"securities",
"15"
],
[
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
100,
30,
60,
30.0000,
0.0000,
10.0000,
2.0000,
0.0000,
10.4580,
0.0000,
0.0000,
36.0000,
36.0000,
0.0000,
3000,
94.4580,
2905.5420,
2916.0000,
"long_term",
6000,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
60,
120,
160,
120.0000,
4.2500,
0.0000,
0.0000,
9.0000,
19.2960,
0.0000,
0.0000,
31.5000,
31.5000,
0.0000,
2400,
95.5460,
2304.4540,
2323.7500,
"short_term",
9600,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
30,
150,
50,
150.0000,
0.6765,
0.3158,
0.1579,
0.0000,
3.1579,
0.0003,
5.6842,
5.6842,
0.0000,
0.0000,
-3000,
15.6768,
-3015.6768,
-3012.5189,
"long_term",
1500,
"capital_gains",
"securities",
"10"
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
45.5488,
60,
120.5877,
73.01,
2.5284,
1.9110,
0.9555,
0.0000,
150.9464,
0.0019,
0.0000,
34.3976,
34.3976,
0.0000,
2759.69702976,
225.1384,
2534.55862976,
2092.91514176,
"long_term",
5492.62502976,
"capital_gains",
"other_capital_gains",
"20"
],
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
30.739,
10,
5,
10.0000,
9.9495,
0.0000,
0.0000,
0.0000,
53.6353,
0.0000,
17.5451,
35.5451,
18.0000,
0.0000,
-153.695,
134.6750,
-288.3700,
-234.7347000,
"short_term",
153.695,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
20,
15,
60,
17.48,
0.3230,
2.0000,
1.0000,
0.0000,
37.0000,
0.0020,
0.0000,
36.0000,
36.0000,
0.0000,
900,
112.3250,
787.6750,
775.0750,
"long_term",
1200,
"capital_gains",
"other_capital_gains",
"20"
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
20,
400.784,
200,
400.7840,
7.0939,
2.0000,
1.0000,
0.0000,
13.0700,
0.0020,
0.0000,
36.0000,
36.0000,
0.0000,
-4015.680,
95.1659,
-4110.8459,
-4097.7759,
"short_term",
4000,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
99.78,
2,
500,
220.0000,
4.9734,
1.9826,
0.9913,
0.0000,
8.4134,
0.0020,
0.0000,
35.6865,
35.6865,
0.0000,
49690.44,
87.7357,
49602.7043,
27859.077700,
"long_term",
49890.00,
"capital_gains",
"securities",
"10"
],
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
78,
23,
88,
23.0000,
8.5559,
2.0000,
1.0000,
0.0000,
2.9317,
0.0020,
36.0000,
36.0000,
0.0000,
0.0000,
5070,
86.4896,
4983.5104,
4986.4421,
"long_term",
6864,
"capital_gains",
"securities",
"10"
],
[
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
250,
50,
600,
141.45,
0.0000,
0.0000,
0.0000,
0.0000,
17.0000,
25.0000,
36.0000,
36.0000,
0.0000,
0.0000,
137500,
114.0000,
137386.0000,
114540.5000,
"long_term",
150000,
"capital_gains",
"other_capital_gains",
"20"
]
]
},
{
"name": "etf_intraday_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
40.0000,
400.0000,
11.5000,
3.3330,
3.0000,
1.5000,
0.0000,
45.0000,
0.0010,
18.0000,
18.0000,
0.0000,
0.0000,
-15540.00000000,
88.8340,
-15628.83400000,
-15628.83400000,
15540.00000000,
"business_and_profession",
"speculative",
"slab_rate"
]
]
},
{
"name": "etf_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"last_traded_price",
"unrelaized_pnl"
],
"rows": [
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
20.0000,
120.0000,
null,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
105.0000,
245.2381,
null,
null
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
4.4512,
60.0000,
null,
null
],
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
0.7970,
10.0000,
null,
null
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
1.7687,
2.0000,
null,
null
]
]
},
{
"name": "etf_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INF179KB1QR8",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
75.0000,
100.0000,
null,
null
]
]
}
]
},
{
"name": "futures_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "futures_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"contract_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"NIFTY21JUN15800CE",
"Equity",
75,
168,
168.65,
2,
2,
2,
2,
0,
0,
0,
0,
0,
0,
48.75,
8,
40.75,
40.75,
48.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FINNIFTY21MAYFUT",
"Equity",
40,
15700,
15685.9,
2,
2,
2,
2,
0,
0,
0,
0,
0,
0,
-564.0,
8,
-572.0,
-572.0,
564.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY21Jan15800CE",
"Equity",
150,
175.2750,
177.1250,
3,
3,
3,
3,
0,
0,
0,
0,
0,
0,
277.5000,
12,
265.5000,
265.5000,
277.5000,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"USD21APR14700CE",
"Currency",
75,
363.15,
194.9,
2,
2,
2,
2,
0,
0,
0,
0,
0,
0,
-12618.75,
8,
-12626.75,
-12626.75,
12618.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"CRUDE21APR14700CE",
"Commodity",
75,
363.1,
194.9,
2,
2,
2,
2,
0,
0,
0,
0,
0,
0,
-12615.0,
8,
-12623.0,
-12623.0,
12615.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"ONE-FUT",
"Commodity",
50,
600.0000,
680.0000,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
4000.0000,
0,
4000.0000,
4000.0000,
4000.0000,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY21JUN17500CE",
"Equity",
75,
4.55,
4.7,
2,
2,
2,
2,
0,
0,
0,
0,
0,
0,
11.25,
8,
3.25,
3.25,
11.25,
"business_and_profession",
"non_speculative",
"slab_rate"
]
]
},
{
"name": "futures_scripwise_open_position_table",
"@entity": "table",
"header": [
"symbol",
"asset_class",
"quantity",
"trade_price_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"NIFTY21Jan15800CE",
"Equity",
75.0000,
175.0000,
null,
null
],
[
"ONE-FUT",
"Commodity",
100.0000,
663.0000,
null,
null
],
[
"NIFTY23JUN15800CE",
"Equity",
89.0000,
100.0000,
null,
null
]
]
}
]
},
{
"name": "options_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "options_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"contract_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"NIFTY21JUN15800CE",
"Equity",
150,
171.7750,
0.0000,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
-25766.2500,
0,
-25766.2500,
-25766.2500,
25766.2500,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"ONE-PUT",
"Commodity",
25,
600,
660,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
1500,
0,
1500,
1500,
1500,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FINNIFTY21MAYFUT",
"Equity",
40,
15700,
1500,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
-568000,
0,
-568000,
-568000,
568000,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY21Jan15800CE",
"Equity",
75,
175,
180,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
375,
0,
375,
375,
375,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"USD21APR14700CE",
"Currency",
75,
363.15,
194.9,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
-12618.75,
0,
-12618.75,
-12618.75,
12618.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"CRUDE21APR14700CE",
"Commodity",
75,
363.1,
194.9,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
-12615.0,
0,
-12615.0,
-12615.0,
12615.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY21JUN17500CE",
"Equity",
75,
4.55,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
-341.25,
0,
-341.25,
-341.25,
341.25,
"business_and_profession",
"non_speculative",
"slab_rate"
]
]
},
{
"name": "options_scripwise_open_position_table",
"@entity": "table",
"header": [
"symbol",
"asset_class",
"quantity",
"trade_price_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"ONE-PUT",
"Commodity",
125.0000,
650.4000,
null,
null
],
[
"NIFTY21JULY15800CE",
"Equity",
75.0000,
1000.0000,
null,
null
],
[
"NIFTY21Jan15800CE",
"Equity",
75.0000,
175.0000,
null,
null
],
[
"CRUDE23APR14700CE",
"Commodity",
75.0000,
194.9000,
null,
null
]
]
}
]
},
{
"name": "bonds_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "bonds_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisation",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INE112J07020",
"IFCI",
170,
16.55,
500,
16.5500,
38.5000,
26.6000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
82186.50,
69.7200,
82116.7800,
82116.7800,
"long_term",
85000,
"capital_gains",
"securities",
"10"
],
[
"INE261F07055",
"SGB",
50,
322,
400,
322.0000,
13.2000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
3900,
13.2000,
3886.8000,
3886.8000,
"short_term",
20000,
"capital_gains",
"securities",
"slab_rate"
],
[
"INE272F07011",
"Blue Dart Express",
20,
20,
200,
20.0000,
12.4000,
20.8000,
0.0000,
0.0000,
0.0000,
3.0000,
3.0000,
3.0000,
0.0000,
3600,
42.2000,
3557.8000,
3557.8000,
"long_term",
4000,
"capital_gains",
"securities",
"10"
],
[
"INE130K08000",
"SBOX",
170,
16.55,
500,
16.5500,
38.5000,
26.6000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
82186.50,
69.7200,
82116.7800,
82116.7800,
"short_term",
85000,
"capital_gains",
"securities",
"slab_rate"
],
[
"INE261F07032",
"07.64% NABARD TFB 2031",
1000,
10,
125,
10.0000,
42.0000,
0.0000,
32.0000,
0.0000,
0.0000,
2.0000,
2.0000,
2.0000,
0.0000,
115000,
80.0000,
114920.0000,
114920.0000,
"long_term",
125000,
"capital_gains",
"securities",
"10"
],
[
"INE130K08019",
"APPL",
180,
350,
310,
350.0000,
39.0000,
26.9000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
-7200,
70.5200,
-7270.5200,
-7270.5200,
"short_term",
55800,
"capital_gains",
"securities",
"slab_rate"
]
]
},
{
"name": "bonds_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE272F07011",
"Blue Dart Express",
30.0000,
20.0000,
null,
null
],
[
"INE112J07020",
"IFCI",
30.0000,
16.5500,
null,
null
],
[
"INE130K08000",
"SBOX",
30.0000,
16.5500,
null,
null
],
[
"INE130K08019",
"APPL",
20.0000,
350.0000,
null,
null
],
[
"INE261F07055",
"SGB",
500.0000,
327.6000,
null,
null
]
]
},
{
"name": "bonds_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE130K08001",
"QCK",
200.0000,
500.0000,
null,
null
]
]
}
]
},
{
"name": "debentures_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "debentures_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisation",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INE112J07020",
"IFCI",
170,
16.55,
500,
16.5500,
38.5000,
26.6000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
82186.50,
69.7200,
82116.7800,
82116.7800,
"long_term",
85000,
"capital_gains",
"securities",
"10"
],
[
"INE261F07055",
"SGB",
50,
322,
400,
322.0000,
13.2000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
3900,
13.2000,
3886.8000,
3886.8000,
"short_term",
20000,
"capital_gains",
"securities",
"slab_rate"
],
[
"INE272F07011",
"Blue Dart Express",
20,
20,
200,
20.0000,
12.4000,
20.8000,
0.0000,
0.0000,
0.0000,
3.0000,
3.0000,
3.0000,
0.0000,
3600,
42.2000,
3557.8000,
3557.8000,
"long_term",
4000,
"capital_gains",
"securities",
"10"
],
[
"INE130K08000",
"SBOX",
170,
16.55,
500,
16.5500,
38.5000,
26.6000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
82186.50,
69.7200,
82116.7800,
82116.7800,
"short_term",
85000,
"capital_gains",
"securities",
"slab_rate"
],
[
"INE261F07032",
"07.64% NABARD TFB 2031",
1000,
10,
125,
10.0000,
42.0000,
0.0000,
32.0000,
0.0000,
0.0000,
2.0000,
2.0000,
2.0000,
0.0000,
115000,
80.0000,
114920.0000,
114920.0000,
"long_term",
125000,
"capital_gains",
"securities",
"10"
],
[
"INE130K08019",
"APPL",
180,
350,
310,
350.0000,
39.0000,
26.9000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
-7200,
70.5200,
-7270.5200,
-7270.5200,
"short_term",
55800,
"capital_gains",
"securities",
"slab_rate"
]
]
},
{
"name": "debentures_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE272F07011",
"Blue Dart Express",
30.0000,
20.0000,
null,
null
],
[
"INE112J07020",
"IFCI",
30.0000,
16.5500,
null,
null
],
[
"INE130K08000",
"SBOX",
30.0000,
16.5500,
null,
null
],
[
"INE130K08019",
"APPL",
20.0000,
350.0000,
null,
null
],
[
"INE261F07055",
"SGB",
500.0000,
327.6000,
null,
null
]
]
},
{
"name": "debentures_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE130K08001",
"QCK",
200.0000,
500.0000,
null,
null
]
]
}
]
},
{
"name": "tax_pnl_summary_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "asset_wise_summary_table",
"@entity": "table",
"header": [
"asset_class",
"asset_type",
"income_head",
"income_sub_head",
"holding_period",
"turnover",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
"equity",
"share",
"capital_gains",
"securities",
"short_term",
1560,
1200,
1200,
1560,
360,
31.7366,
328.2634,
333.5967
],
[
"equity",
"share",
"capital_gains",
"securities",
"long_term",
57000,
71050,
71050,
57000,
-14050,
274,
-14324,
-14312
],
[
"equity",
"share",
"business_and_profession",
"speculative",
"intraday",
131.00000000,
4468.00000000,
4468.00000000,
4599.00000000,
131.00000000,
6.0000,
125.00000000,
125.00000000
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"short_term",
8451.750,
5071.050,
5071.0500000,
8451.750,
3380.700,
43.8583,
3336.8417,
3336.8417000
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"long_term",
106418.3797,
76771.6842,
78334.9822000,
106418.3797,
29646.6955,
154.6990,
29491.9965,
27928.6985000
],
[
"debt",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"short_term",
5382.335,
3607.800,
3607.8000000,
5382.335,
1774.535,
283.6152,
1490.9198,
1490.9198000
],
[
"debt",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"short_term",
6506.200,
13037.904304,
13037.9043040,
6506.200,
-6531.704304,
23.5685,
-6555.272804,
-6555.2728040
],
[
"other",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"long_term",
7.380,
1.845,
5.84865,
7.380,
5.535,
10.0070,
-4.4720,
-8.47565
],
[
"equity",
"etf",
"capital_gains",
"securities",
"short_term",
22500,
13500,
13500.0000,
22500,
9000,
86.4491,
8913.5509,
8918.9969
],
[
"equity",
"etf",
"capital_gains",
"securities",
"long_term",
58254.00,
6493.56,
28245.600000,
58254.00,
51760.44,
189.9021,
51570.5379,
29833.000900
],
[
"debt",
"etf",
"capital_gains",
"other_capital_gains",
"short_term",
9753.695,
7507.390,
7507.3900000,
9753.695,
2246.305,
230.2210,
2016.0840,
2089.0153000
],
[
"debt",
"etf",
"capital_gains",
"other_capital_gains",
"long_term",
156000,
15500,
38362.5000,
156000,
140500,
208.4580,
140291.5420,
117456.5000
],
[
"other",
"etf",
"capital_gains",
"other_capital_gains",
"short_term",
4000,
8015.680,
8015.6800,
4000,
-4015.680,
95.1659,
-4110.8459,
-4097.7759
],
[
"other",
"etf",
"capital_gains",
"other_capital_gains",
"long_term",
6692.62502976,
3032.9280,
3675.117888,
6692.62502976,
3659.69702976,
337.4634,
3322.23362976,
2867.99014176
],
[
"equity",
"etf",
"business_and_profession",
"speculative",
"intraday",
15540.00000000,
16000.00000000,
16000.00000000,
460.00000000,
-15540.00000000,
88.8340,
-15628.83400000,
-15628.83400000
],
[
"debt",
"etf",
"business_and_profession",
"speculative",
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"business_and_profession",
"speculative",
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"future",
"business_and_profession",
"non_speculative",
null,
901.5000,
667232.5000,
667232.5000,
667006.0000,
-226.5000,
36,
-262.5000,
-262.5000
],
[
"commodity",
"future",
"business_and_profession",
"non_speculative",
null,
16615.0000,
57232.5000,
57232.5000,
48617.5000,
-8615.0000,
8,
-8623.0000,
-8623.0000
],
[
"currency",
"future",
"business_and_profession",
"non_speculative",
null,
25237.50,
27236.25,
27236.25,
14617.5,
-12618.75,
8,
-12626.75,
-12626.75
],
[
"equity",
"option",
"business_and_profession",
"non_speculative",
null,
594482.5000,
667232.5000,
667232.5000,
73500.0000,
-593732.5000,
0,
-593732.5000,
-593732.5000
],
[
"commodity",
"option",
"business_and_profession",
"non_speculative",
null,
14115.0,
42232.5,
42232.5,
31117.5,
-11115.0,
0,
-11115.0,
-11115.0
],
[
"currency",
"option",
"business_and_profession",
"non_speculative",
null,
25237.50,
27236.25,
27236.25,
14617.5,
-12618.75,
0,
-12618.75,
-12618.75
],
[
"debt",
"bond",
"capital_gains",
"securities",
"short_term",
160800,
81913.50,
81913.5000,
160800,
78886.50,
153.4400,
78733.0600,
78733.0600
],
[
"debt",
"bond",
"capital_gains",
"securities",
"long_term",
214000,
13213.50,
13213.5000,
214000,
200786.50,
191.9200,
200594.5800,
200594.5800
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"short_term",
160800,
81913.50,
81913.5000,
160800,
78886.50,
153.4400,
78733.0600,
78733.0600
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"long_term",
214000,
13213.50,
13213.5000,
214000,
200786.50,
191.9200,
200594.5800,
200594.5800
]
]
},
{
"name": "tax_pnl_summary_table",
"@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",
321600,
163827.00,
163827.0000,
321600,
157773.00,
306.8800,
157466.1200,
157466.1200
],
[
"capital_gains",
"securities",
"short_term",
"15",
32511.750,
19771.050,
1500.0000,
32511.750,
12740.700,
162.0440,
12578.6560,
12589.4353000
],
[
"capital_gains",
"securities",
"long_term",
"10",
649672.3797,
180742.2442,
99259.8767,
649672.3797,
468930.1355,
1002.4411,
467927.6944,
444638.8594000
],
[
"capital_gains",
"securities",
"long_term",
"20",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"business_and_profession",
"speculative",
"intraday",
"slab_rate",
15671.00000000,
20468.00000000,
20468.00000000,
5059.00000000,
-15409.00000000,
94.8340,
-15503.83400000,
-15503.83400000
],
[
"capital_gains",
"other_capital_gains",
"short_term",
"slab_rate",
25642.230,
32168.774304,
1091.5680,
25642.230,
-6526.544304,
632.5706,
-7159.114904,
-7073.1136040
],
[
"capital_gains",
"other_capital_gains",
"long_term",
"20",
156700.00502976,
15534.7730,
279.49,
156700.00502976,
141165.23202976,
461.4704,
140703.76162976,
117400.01449176
],
[
"capital_gains",
"other_capital_gains",
"long_term",
"slab_rate",
6000,
3000,
30.0000,
6000,
3000,
94.4580,
2905.5420,
2916.0000
],
[
"business_and_profession",
"non_speculative",
null,
"slab_rate",
651351.5000,
1488402.5000,
1488402.5000,
849476.0000,
-638926.5000,
52,
-638978.5000,
-638978.5000
],
[
"other",
"other_exempt_income",
null,
"exempt",
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
}
]
}
}
Updated 22 days ago