Tradewise Settlements | Domestic Securities - Sandbox Financial Technologies Private Limited

Reference sheet for preparing domestic securities tradewise settlements across asset classes. Each section outlines the expected schema for trades, last traded prices, dividends, and other expenses. Use these tables to validate or map broker exports before uploading to Sandbox Income Tax Annexures.

Stock Sheet

Stock Tradewise Table

Param	Type	Required	Description
isin	`string`	No	International Security Identification Number
symbol	`string`	Yes	Symbol or description of equity share
is_listed	`boolean`	Yes	Indicates if the equity stock is listed on public markets
is_stt_paid	`boolean`	Yes	Whether STT was paid on this trade
quantity	`number`	Yes	Trading quantity
buy_trade_id	`string`	Yes	Buy Trade ID
buy_date	`number`	Yes	Epoch timestamp of purchase
buy_price	`number`	Yes	Buy price
sell_trade_id	`string`	Yes	Sell Trade ID
sell_date	`number`	Yes	Epoch timestamp of sale
sell_price	`number`	Yes	Sell price
fmv	`number`	No	Fair market value as on 31/01/2018
brokerage	`number`	No	Brokerage expense
clearing_charges	`number`	No	Clearing house charges
exchange_transaction_charges	`number`	No	Exchange transaction charges
sebi_turnover_fees	`number`	No	SEBI turnover fee
stt	`number`	No	Securities Transaction Tax
stamp_duty	`number`	No	Stamp duty paid
sgst	`number`	No	State GST
cgst	`number`	No	Central GST
igst	`number`	No	Integrated GST
other_transfer_expenses	`number`	No	Other transfer-related expenses
nature_of_settlement	`string`	No	See Annexure 2: Nature of Settlement
product_type	`string`	Yes	`delivery` or `intraday`

Stock Tradewise Table

Param	Type	Description
isin	`string`	International Security Identification Number
symbol	`string`	Symbol or description of equity stock
quantity	`number`	Trading quantity
transfer_date	`number`	Date the transfer was completed
price	`number`	Per-unit transfer price
transfer_type	`string`	`IN` or `OUT`
nature_of_transfer	`string`	See Annexure 2: Nature of Settlement
transfer_value	`number`	Total transfer value
transfer_expense	`number`	Transfer-related expenses

Stock Tradewise Open Sell Table

Param	Type	Description
isin	`string`	International Security Identification Number
symbol	`string`	Symbol or description of equity stock
quantity	`number`	Trading quantity
sell_date	`number`	Epoch timestamp of sale
sell_price	`number`	Per-unit sale price
transaction_type	`string`	`buy`, `sell`, `send`, `receive`, `trade`
label	`string`	See Annexure 1 Labels
last_traded_price	`number`	Last traded price

Mutual Fund Tradewise Settlement Sheet

Mutual Fund Tradewise Settlement Table

Param	Type	Required	Description
isin	`string`	No	International Security Identification Number
scheme_name	`string`	Yes	Scheme name
asset_class	`string`	Yes	`equity`, `debt`, `other`
is_listed	`boolean`	Yes	Indicates if the MF is listed
is_stt_paid	`boolean`	Yes	STT payment status
quantity	`number`	Yes	Trading quantity
buy_trade_id	`string`	Yes	Buy Trade ID
buy_date	`number`	Yes	Purchase timestamp
buy_price	`number`	Yes	Per-unit buy price
sell_trade_id	`string`	Yes	Sell Trade ID
sell_date	`number`	Yes	Sell timestamp
sell_price	`number`	Yes	Per-unit sell price
fmv	`number`	No	FMV as on 31/01/2018
transfer_expenses	`number`	No	Transfer-related expenses
nature_of_settlement	`string`	No	See Annexure 2

Mutual Fund Tradewise Transfer Table

Param	Type	Description
isin	`string`	International Security Identification Number
scheme_name	`string`	Mutual fund scheme name
asset_class	`string`	Asset class
quantity	`number`	Trading quantity
transfer_date	`number`	Date transfer completed
price	`number`	Per-unit transfer price
transfer_type	`string`	`IN` or `OUT`
nature_of_transfer	`string`	See Annexure 2
transfer_value	`number`	Total value
transfer_expense	`number`	Transfer expenses

Mutual Fund Tradewise Holding Table

Param	Type	Description
isin	`string`	International Security Identification Number
scheme_name	`string`	Name of MF
type	`string`	`equity`, `debt`, `other`
quantity	`number`	Units held
buy_date	`number`	Buy date
buy_price	`number`	Buy price
transaction_type	`string`	`buy`, `sell`, `send`, `receive`, `trade`
label	`string`	See Annexure 1
last_traded_price	`number`	LTP

Mutual Fund Tradewise Open Sell Table

Param	Type	Description
isin	`string`	ISIN
scheme_name	`string`	Scheme name
asset_class	`string`	Asset class
quantity	`number`	Trading quantity
sell_date	`number`	Sell date
sell_price	`number`	Price sold
transaction_type	`string`	Transaction type
label	`string`	See Annexure 1
last_traded_price	`number`	LTP

ETF Tradewise Settlement Sheet

ETF Tradewise Settlement Table

Param	Type	Required	Description
isin	`string`	No	ISIN
scheme_name	`string`	Yes	ETF scheme name
asset_class	`string`	Yes	`equity`, `debt`, `other`
is_listed	`boolean`	Yes	Listed status
is_stt_paid	`boolean`	Yes	STT status
quantity	`number`	Yes	Units traded
buy_trade_id	`string`	Yes	Buy Trade ID
buy_date	`number`	Yes	Buy timestamp
buy_price	`number`	Yes	Buy price
sell_trade_id	`string`	Yes	Sell Trade ID
sell_date	`number`	Yes	Sell timestamp
sell_price	`number`	Yes	Sell price
fmv	`number`	No	FMV
brokerage	`number`	No	Brokerage
clearing_charges	`number`	No	Clearing charges
exchange_transaction_charges	`number`	No	Exchange charges
sebi_turnover_fees	`number`	No	SEBI fees
stt	`number`	No	STT
stamp_duty	`number`	No	Stamp duty
sgst	`number`	No	SGST
cgst	`number`	No	CGST
igst	`number`	No	IGST
other_transfer_expenses	`number`	No	Transfer expenses
nature_of_settlement	`string`	No	See Annexure 2
product_type	`string`	Yes	`delivery`, `intraday`

ETF Tradewise Transfer Table

Param	Type	Description
isin	`string`	ISIN
scheme_name	`string`	ETF scheme name
asset_class	`string`	Asset class
quantity	`number`	Units transferred
transfer_date	`number`	Transfer date
price	`number`	Unit transfer price
transfer_type	`string`	`IN` or `OUT`
nature_of_transfer	`string`	See Annexure 2
transfer_value	`number`	Total value
transfer_expense	`number`	Transfer expense

ETF Tradewise Holding Table

Param	Type	Description
isin	`string`	ISIN
scheme_name	`string`	ETF name
type	`string`	Asset class
quantity	`number`	Units held
buy_date	`number`	Buy date
buy_price	`number`	Buy price
transaction_type	`string`	Transaction type
label	`string`	Label
last_traded_price	`number`	LTP

ETF Tradewise Open Sell Table

Param	Type	Description
isin	`string`	ISIN
scheme_name	`string`	Scheme name
asset_class	`string`	Asset class
quantity	`number`	Quantity
sell_date	`number`	Date sold
sell_price	`number`	Price sold
transaction_type	`string`	Transaction type
label	`string`	Label
last_traded_price	`number`	LTP

Future Tradewise Settlement Sheet

Future Tradewise Settlement Table

Param	Type	Required	Description
isin	`string`	No	ISIN
contract_name	`string`	Yes	Contract name
asset_class	`string`	Yes	`equity`, `currency`, `commodity`
quantity	`number`	Yes	Quantity
buy_trade_id	`string`	Yes	Buy Trade ID
buy_date	`number`	Yes	Buy date
buy_price	`number`	Yes	Buy price
sell_trade_id	`string`	Yes	Sell Trade ID
sell_date	`number`	Yes	Sell date
sell_price	`number`	Yes	Sell price
brokerage	`number`	No	Brokerage
clearing_charges	`number`	No	Clearing charges
exchange_transaction_charges	`number`	No	Exchange charges
sebi_turnover_fees	`number`	No	SEBI fees
stt	`number`	No	STT
stamp_duty	`number`	No	Stamp duty
sgst	`number`	No	SGST
cgst	`number`	No	CGST
igst	`number`	No	IGST
other_transfer_expenses	`number`	No	Other transfer expenses
nature_of_settlement	`string`	No	Nature of settlement

Future Tradewise Open Position Table

Param	Type	Description
isin	`string`	ISIN
contract_name	`string`	Contract name
asset_class	`string`	Asset class
quantity	`number`	Positive or negative quantity (short/long)
trade_date	`number`	Trade date
trade_price	`number`	Trade price
transaction_type	`string`	Transaction type
label	`string`	Label
last_traded_price	`number`	LTP

Option Tradewise Settlement Sheet

Option Tradewise Settlement Table

Param	Type	Required	Description
isin	`string`	No	ISIN
contract_name	`string`	Yes	Contract name
asset_class	`string`	Yes	Asset class
quantity	`number`	Yes	Quantity
buy_trade_id	`string`	Yes	Buy Trade ID
buy_date	`number`	Yes	Buy date
buy_price	`number`	Yes	Price
sell_trade_id	`string`	Yes	Sell Trade ID
sell_date	`number`	Yes	Sell date
sell_price	`number`	Yes	Sell price
brokerage	`number`	No	Brokerage
clearing_charges	`number`	No	Clearing
exchange_transaction_charges	`number`	No	Exchange charges
sebi_turnover_fees	`number`	No	SEBI fees
stt	`number`	No	STT
stamp_duty	`number`	No	Stamp duty
sgst	`number`	No	SGST
cgst	`number`	No	CGST
igst	`number`	No	IGST
other_transfer_expenses	`number`	No	Transfer expenses
nature_of_settlement	`string`	No	Nature of settlement

Option Tradewise Open Position Table

Param	Type	Description
isin	`string`	ISIN
contract_name	`string`	Contract name
asset_class	`string`	Asset class
quantity	`number`	Positive or negative quantity
trade_date	`number`	Trade date
trade_price	`number`	Price
transaction_type	`string`	Transaction type
label	`string`	Label
last_traded_price	`number`	LTP

Bond Tradewise Settlement Sheet

Bond Tradewise Settlement Table

Param	Type	Required	Description
isin	`string`	No	ISIN
security_name	`string`	Yes	Bond name
is_listed	`boolean`	Yes	Listed status
quantity	`number`	Yes	Quantity
buy_trade_id	`string`	Yes	Buy Trade ID
buy_date	`number`	Yes	Buy date
buy_price	`number`	Yes	Price
sell_trade_id	`string`	Yes	Sell Trade ID
sell_date	`number`	Yes	Sell date
sell_price	`number`	Yes	Sell price
fmv	`number`	No	FMV
brokerage	`number`	No	Brokerage
clearing_charges	`number`	No	Clearing charges
exchange_transaction_charges	`number`	No	Charges
sebi_turnover_fees	`number`	No	SEBI fees
stt	`number`	No	STT
stamp_duty	`number`	No	Stamp duty
sgst	`number`	No	SGST
cgst	`number`	No	CGST
igst	`number`	No	IGST
other_transfer_expenses	`number`	No	Transfer expenses
nature_of_settlement	`string`	No	Nature

Bond Tradewise Transfer Table

Param	Type	Description
isin	`string`	ISIN
security_name	`string`	Bond name
quantity	`number`	Quantity
transfer_date	`number`	Date transferred
price	`number`	Price
transfer_type	`string`	`IN` or `OUT`
nature_of_transfer	`string`	Nature
transfer_value	`number`	Value
transfer_expense	`number`	Expenses

Bond Tradewise Open Sell Table

Param	Type	Description
isin	`string`	ISIN
symbol	`string`	Bond
quantity	`number`	Quantity
sell_date	`number`	Date
sell_price	`number`	Price
transaction_type	`string`	Type
label	`string`	Label
last_traded_price	`number`	LTP

Debenture Tradewise Settlement Sheet

Debenture Tradewise Settlement Table

Param	Type	Required	Description
isin	`string`	No	ISIN
security_name	`string`	Yes	Debenture name
is_listed	`boolean`	Yes	Listed
quantity	`number`	Yes	Quantity
buy_trade_id	`string`	Yes	Buy ID
buy_date	`number`	Yes	Buy date
buy_price	`number`	Yes	Price
sell_trade_id	`string`	Yes	Sell ID
sell_date	`number`	Yes	Sell date
sell_price	`number`	Yes	Price
fmv	`number`	No	FMV
brokerage	`number`	No	Brokerage
clearing_charges	`number`	No	Clearing
exchange_transaction_charges	`number`	No	Exchange
sebi_turnover_fees	`number`	No	SEBI fees
stt	`number`	No	STT
stamp_duty	`number`	No	Stamp duty
sgst	`number`	No	SGST
cgst	`number`	No	CGST
igst	`number`	No	IGST
other_transfer_expenses	`number`	No	Transfer
nature_of_settlement	`string`	No	Nature

Debenture Tradewise Transfer Table

Param	Type	Description
isin	`string`	ISIN
security_name	`string`	Debenture name
quantity	`number`	Quantity
transfer_date	`number`	Date
price	`number`	Price
transfer_type	`string`	`IN`/`OUT`
nature_of_transfer	`string`	Nature
transfer_value	`number`	Total value
transfer_expense	`number`	Expenses

Debenture Tradewise Holding Table

Param	Type	Description
isin	`string`	ISIN
symbol	`string`	Debenture
quantity	`number`	Quantity
buy_date	`number`	Buy date
buy_price	`number`	Price
transaction_type	`string`	Type
label	`string`	Label
last_traded_price	`number`	LTP

Debenture Tradewise Open Sell Table

Param	Type	Description
isin	`string`	ISIN
symbol	`string`	Debenture
quantity	`number`	Quantity
sell_date	`number`	Sell date
sell_price	`number`	Price
transaction_type	`string`	Type
label	`string`	Label
last_traded_price	`number`	LTP

Calculator

Reporting

OCR

Tradewise Settlements | Domestic Securities

Stock Sheet

Stock Tradewise Table

Stock Tradewise Table

Stock Tradewise Open Sell Table

Mutual Fund Tradewise Settlement Sheet

Mutual Fund Tradewise Settlement Table

Mutual Fund Tradewise Transfer Table

Mutual Fund Tradewise Holding Table

Mutual Fund Tradewise Open Sell Table

ETF Tradewise Settlement Sheet

ETF Tradewise Settlement Table

ETF Tradewise Transfer Table

ETF Tradewise Holding Table

ETF Tradewise Open Sell Table

Future Tradewise Settlement Sheet

Future Tradewise Settlement Table

Future Tradewise Open Position Table

Option Tradewise Settlement Sheet

Option Tradewise Settlement Table

Option Tradewise Open Position Table

Bond Tradewise Settlement Sheet

Bond Tradewise Settlement Table

Bond Tradewise Transfer Table

Bond Tradewise Open Sell Table

Debenture Tradewise Settlement Sheet

Debenture Tradewise Settlement Table

Debenture Tradewise Transfer Table

Debenture Tradewise Holding Table

Debenture Tradewise Open Sell Table

Calculator

Reporting

OCR

​Stock Sheet

​Stock Tradewise Table

​Stock Tradewise Table

​Stock Tradewise Open Sell Table

​Mutual Fund Tradewise Settlement Sheet

​Mutual Fund Tradewise Settlement Table

​Mutual Fund Tradewise Transfer Table

​Mutual Fund Tradewise Holding Table

​Mutual Fund Tradewise Open Sell Table

​ETF Tradewise Settlement Sheet

​ETF Tradewise Settlement Table

​ETF Tradewise Transfer Table

​ETF Tradewise Holding Table

​ETF Tradewise Open Sell Table

​Future Tradewise Settlement Sheet

​Future Tradewise Settlement Table

​Future Tradewise Open Position Table

​Option Tradewise Settlement Sheet

​Option Tradewise Settlement Table

​Option Tradewise Open Position Table

​Bond Tradewise Settlement Sheet

​Bond Tradewise Settlement Table

​Bond Tradewise Transfer Table

​Bond Tradewise Open Sell Table

​Debenture Tradewise Settlement Sheet

​Debenture Tradewise Settlement Table

​Debenture Tradewise Transfer Table

​Debenture Tradewise Holding Table

​Debenture Tradewise Open Sell Table

Stock Sheet

Stock Tradewise Table

Stock Tradewise Table

Stock Tradewise Open Sell Table

Mutual Fund Tradewise Settlement Sheet

Mutual Fund Tradewise Settlement Table

Mutual Fund Tradewise Transfer Table

Mutual Fund Tradewise Holding Table

Mutual Fund Tradewise Open Sell Table

ETF Tradewise Settlement Sheet

ETF Tradewise Settlement Table

ETF Tradewise Transfer Table

ETF Tradewise Holding Table

ETF Tradewise Open Sell Table

Future Tradewise Settlement Sheet

Future Tradewise Settlement Table

Future Tradewise Open Position Table

Option Tradewise Settlement Sheet

Option Tradewise Settlement Table

Option Tradewise Open Position Table

Bond Tradewise Settlement Sheet

Bond Tradewise Settlement Table

Bond Tradewise Transfer Table

Bond Tradewise Open Sell Table

Debenture Tradewise Settlement Sheet

Debenture Tradewise Settlement Table

Debenture Tradewise Transfer Table

Debenture Tradewise Holding Table

Debenture Tradewise Open Sell Table