TMI BlogFormat, Procedure and Guidelines for submission of Statement of Financial Transactions (SFT) for Depository TransactionsX X X X Extracts X X X X X X X X Extracts X X X X ..... bmission of Statement of Financial Transactions (SFT) information are enclosed in Annexure A and Annexure B respectively. The format of control statement to be submitted by the Designated Director is given in Annexure C. The data structure and validation rules are enclosed in Annexure D and Annexure E respectively. Notification No. 3 of 2018 dated 05.04.2018 may be referred for the procedure for registration. 4. All Depositories as defined in clause (e) of sub-section (1) of section 2 of the Depositories Act, 1996 (22 of 1996) are required to prepare the data file in prescribed format from their internal system. Reporting entities are required to submit the data files using SFTP Server using the login credentials (To be communicated separately). 5. A separate control statement (refer annexure C) is required to be signed, verified and furnished by the Designated Director. 6. 1[With effect from 1st April 2023 the statement of financial transactions data will be submitted on half yearly basis instead of existing quarterly basis i.e. data relating to 1st half of the Financial Year ending 30th September and remaining half of the Financial Year ending on 31st March shall be furnishe ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... date of sale and date of acquisition of any share/security in the demat account) should be used to classify the asset as short term or long-term asset. First in First out (FIFO) method should be used for identification of corresponding credit in demat account and computation of period of holding. Any capital asset held by the taxpayer for a period of more than minimum period of holding will be treated as long-term capital asset and remaining assets will be classified as short-term asset. The specified minimum period of holding for different asset class is as under: 3[Security Class Code Security Class Description Minimum Period of Holding Remarks LES Listed Equity Share 12 months - LPS Listed Preference Share 12 months - LDB Listed Debenture 12 months - ZCB Zero Coupon Bond 12 months - CIB Listed Capital Indexed Bond 12 months - EMF Unit of Equity Oriented Mutual Fund 12 months - UTI Unit of UTI 12 months Where more than 35% of its total proceeds are invested in the equity shares of domestic companies, this information should be provided. Note: Where not more than 35% of its total proceeds are invested in the equity shares of domestic companies, (Sp ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... capital asset is listed on any recognized stock exchange as on the 31st day of January, 2018, "fair market value" means the highest price of the capital asset quoted on such exchange on the said date. If there is no trading in such asset on such exchange on the 31st day of January, 2018, the highest price of such asset on such exchange on a date immediately preceding the 31st day of January, 2018 when such asset was traded on such exchange shall be the fair market value. In case the cost of acquisition of asset acquired before the 1st day of February, 2018 is not easily available, the adjusted cost of acquisition may be taken as lower of (A) the fair market value of such asset; and (B) the full value of consideration. 8. The Cost Inflation Index should be used to determine estimated indexed cost of acquisition wherever applicable. 9. The details of demat account holders and summary values for the demat account for the reporting period should be reported in Depository Account Summary (DEP_ACC_SUMM.TXT). 10. The details of off-market transactions recorded by the depository during the year should be reported in Depository Off-Market Transactions (DEP_OFF_TRN.TXT). Annex ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... s file contains details of reporting entity, principal officer and files uploaded by the reporting entity #. Field Name Mandatory Format Remarks 1. Reporting Entity Name Y VARCHAR (150) Reporting Entity Name 2. ITDREIN Y VARCHAR (20) Registration number allotted by ITD 3. Registration Number N VARCHAR (150) SEBI Registration number 4. Statement Type Y VARCHAR (2) NB - New Statement containing new information DB - Deletion Statement CB - Correction Statement containing corrections for previously submitted information 5. Statement Number Y VARCHAR (20) Internal reference number for reporting entity 6. Original Statement Id Y DECIMAL (18,0) Statement ID of the original Statement which is being replaced deleted or referred in the current Statement. In case the Statement is new and unrelated to any previous Statement, mention '0' here. 7. Reason for Correction Y VARCHAR (1) Reason for revision to be stated when the original Statement is corrected. (Refer Permissible values) 8. Statement Date Y DATE Statement Date DD-MM-YYYY 9. Reporting Period Start Date Y DATE First day of ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... BL if no PAN is available 23. Second Holder Name N VARCHAR (250) Mandatory if Joint holding exists 24. Second Holder DOB N DATE Second Holder's DOB/DOI in DD-MM-YYYY 25. Third Holder PAN N VARCHAR (10) Mandatory if Joint holding exists. Mention NOPANAVBL if no PAN is available 26. Third Holder Name N VARCHAR (250) Mandatory if Joint holding exists 27. Third Holder DOB N DATE Third Holder's DOB/DOI in DD-MM-YYYY 28. Opening Value Y DECIMAL (18,2) Value of Holding as on first day of reporting period 29. Market Credits Y DECIMAL (18,2) Sum of Market Purchases during reporting period 30. Market Debits Y DECIMAL (18,2) Sum of Market Sales during reporting period 31. Off-Market Credits Y DECIMAL (18,2) Sum of Off-market purchases during reporting period 32. Off-Market Debits Y DECIMAL (18,2) Sum of Off-market Sales during reporting period 33. IPO Credits Y DECIMAL (18,2) Sum of value credited on account of IPO during reporting period 34. Corporate Action Credits Y DECIMAL (18,2) Sum of value credited on account of Corporate Actions during reporting period 35. Corporate Action De ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... hted Average price (taking into account the actual value of the transactions) 18. COA Y Decimal (18,2) Estimated Cost of acquisition without indexation Refer Guidelines.] 19. Unit FMV Y DECIMAL (18,2) FMV per unit as on 31.01.2018. Refer Guidelines 20. Total FMV Y DECIMAL (18,2) Total FMV as on 31.01.2018. Refer Guidelines 21. Adjusted FMV N DECIMAL (18,2) If the long term capital asset was acquired before 01.02.2018, Lower of Sale Consideration and Total FMV. Refer Guidelines 22. Adjusted COA N DECIMAL (18,2) Cost of acquisition without indexation (higher of COA and Adjusted FMV) 23. Indexed COA N DECIMAL (18,2) Wherever applicable 6[24. Purchase Flag Y *Flag B/A VARCHAR(1) Flag B: Purchase was made before 1st February 2018 Flag A: Purchase was made on or after 1st February 2018] Note: Refer Guidelines for preparation of SFT for more details D.4. Depository Off-Market Transaction (DEP_OFF_TRN.TXT) This file shall contain details of off-market transactions recorded for a person/client by the depository during the year. # Field Name Mandato ry Format Remarks 1. Sequence Number Y DECIMAL (18 ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... nit of Equity Oriented Mutual Fund 7. UTI Unit of UTI 8. UBT Unit of Business Trust 9. OTU Other Units 10. OTH Other Listed Securities (Other than a unit) Permissible Values - Transaction Reason # Reason Code Reason Description 1. ACL Account Closure 2. BEN Trust to Beneficiaries/on HUF dissolution to Karta & Coparceners 3. CDR Certificate of Deposit Redemption 4. DRC Conversion of Depository Receipt (DR) to underlying securities and vice versa 5. CPI Commercial Paper Issuance 6. DRW Dissolution/Restructuring/Winding up of Partnership Firm/Trust 7. DUE Meeting Legitimate Dues of Stock Broker 8. ERR Erroneous Transfer pertaining to Client Securities 9. ESP ESOP/Transfer to employee 10. FAM Transfer between specified family members 11. FPM Transfers from PMS account 12. GFT Gift/Donation 13. MGR Margin returned by stock broker / PCM 14. MGT Margin to stock broker / PCM 15. MIN Transfer between Minor Account and Guardian Account 16. MRG Merger/ Demerger of corporate entity 17. OFS Off-market Sale 18. ONS On-market Sale (Transfer towards Pay-in) 19. OOA Open Offer f ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... o. Error Message Error Type File Rejection 1. Control Statement Values Mismatch Error Y 2. Sequence Number in Submitted file is not running sequence number Error Y 3. Account Summary Data not provided for reported transaction Defect N 4. Mandatory Field is blank Defect N 5. Invalid PAN reported Exception N 6. Excessive Value Reported Exception N 7. Mismatch identified after matching data with other submitted data Exception N *************** NOTES:- 1. Corrected vide Corrigendum to Notification No. 3. of 2021 dated 15-11-2023 before it was read as, "The statement of financial transactions relating to Financial Year 2020-21 shall be furnished on or before the 31st May 2021. Thereafter, the statement of financial transactions relating to the quarter ending 30th June, 31st September, 31st December and 31st March shall be furnished on or before 25th of July, October, January and April respectively." 2. Corrected vide Corrigendum to Notification No. 3. of 2021 dated 15-11-2023 before it was read as, "The Estimated Sale Consideration for the debit transaction should be determined on the best possible ava ..... X X X X Extracts X X X X X X X X Extracts X X X X
|