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 ..... al of the Board. 3. The guidelines for preparation and submission 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 ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... y class for determining the type of asset (short term/long term) and applicable rate. 5. The period of holding (difference between 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 - ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... ay price, if purchase was made before 1st February 2018 , available with the depository. The estimated cost of acquisition is to be taken as NIL for OFF Market purchase, Corporate Action or for any transaction through other than Exchange. IPO credit will be treated as Market credit and cost of the acquisition of the same wilt be arrived using the formula i.e. Number of shares allotted x Per unit price at which share is allotted. The taxpayer will be able to modify the cost of acquisition before filing the return.] 7. In relation to a long-term capital asset, being an equity share in a company or a unit of an equity-oriented fund acquired before the 1st day of February, 2018, adjusted cost of acquisition shall be higher of (i) the cost of acquisition of such asset; and (ii) lower of (A) the fair market value of such asset as on 31st January, 2018; and (B) the full value of consideration received or accruing as a result of the transfer of the capital asset. In a case where the 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 ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... tement Id A.7 Reason for Correction A.8 Statement Date A.9 Reporting Period Start Date A.10 Reporting Period End Date Number of Records B.1 Depository Batch File (DEP_BATCH.TXT) B.2 Depository Account Summary (DEP_ACC_SUMM.TXT) B.3 Depository Transaction Summary (DEP_TRN_SUMM.TXT) B.4 Depository Off-Market Transaction (DEP_OFF_TRN.TXT) Sum of Key Values in Rs. (Refer Depository Account Summary) C.1 Opening Value C.2 Market Credits C.3 Market Debits C.4 Off-Market Credits ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... 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 the reporting period DD-MM-YYYY 10. Reporting Period End Date Y DATE Last day of the reporting period DD-MM-YYYY 11. Principal ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... Client Status Y VARCHAR (1) M Minor O - Other X- Not Classified 11. Guardian Name N VARCHAR(250) Mandatory if Client Status is Minor 12. Guardian PAN N VARCHAR(10) Mandatory if Client Status is Minor . Mention PANNOTAVBL if no PAN is available. 13. Client Aadhaar N VARCHAR (12) First Holder s Aadhaar 14. Client DOB N DATE First Holder s DOB/DOI in DD- MM-YYYY 15. Client Address Y VARCHAR (500) First Holder s Address 16. Client City N VARCHAR (40) First Holder s Address-city 17. Client State code N VARCHAR (2) First ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... 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 Debits Y DECIMAL (18,2) Sum of value debited on account of Corporate Actions during reporting period 36. Dematerialized Credits Y DECIMAL (18,2) Sum of value dematerialized (Credit) during reporting period 37. Rematerialized Debits Y DECIMAL (18,2) Sum of value rematerialized (Debit) during reporting period 38. Pledg ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... y Name Y VARCHAR (200) Name of security 11. Debit Date Y DATE Date of Debit 12. Debit Type Y VARCHAR (1) Refer Guidelines M Market O Off Market 13. Credit Type Y VARCHAR (1) Refer Guidelines M Market O Off Market 14. Asset Type Y VARCHAR (1) Refer Guidelines S Short Term L Long Term 15. Units Y DECIMAL (18,3) Units sold or transferred. Refer Guidelines. 5 [ 16. Unit price Y DECIMAL (18,2) Weighted Average sale price per unit (taking into account the actual value of the transactions) 17. Sale Consideration Y Decimal(18,2) Estimated Sale Consideration at Weighted Average price (taki ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... 6. Transferor Client ID Y VARCHAR (8) 7. Transferor DP Name Y VARCHAR (100) Depository Participant's Name 8. Transferor PAN Y VARCHAR (10) Mention PANNOTAVBL if no PAN is available. 9. Transferor Name Y VARCHAR (250) First Holder s name 10. Transferee DP ID Y VARCHAR (8) 11. Transferee Client ID Y VARCHAR (8) 12. Transferee DP Name Y VARCHAR (100) 13. Transferee PAN Y VARCHAR (10) 14. Transferee Name Y VARCHAR (250) ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... 4. N Not applicable as this is a new statement/test data/ there is no data to report 5. Z Other reason Permissible Values Security Class Code # S ecurity Class Code Description 1. LES Listed Equity Share 2. LPS Listed Preference Share 3. LDB Listed Debenture 4. ZCB Zero Coupon Bond 5. CIB Listed Capital Indexed Bond 6. EMF Unit 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 un ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... unpaid securities 24. PRT Transfer between Partner and Firm, Director and Company 25. RED Redemption of Mutual Fund Units 26. REF Refund of securities by IEPF Authority 27. TPM Transfers to PMS account 28. TRP Transposition - Between joint account of same holders 29. OTH Other 30. ZZZ Not Specified Permissible Values - State code # State/Union Territories Code 1. Andaman and Nicobar AN 2. Andhra Pradesh AP 3. Arunachal Pradesh AR 4. Assam AS 5. Bihar BR ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... Cost Inflation Index (CII) 2001-02 (Base year) 100 2002-03 105 2003-04 109 2004-05 113 2005-06 117 2006-07 122 2007-08 129 2008-09 137 2009-10 148 2010-11 167 2011-12 184 2012-13 200 2013-14 220 2014-15 240 2015-16 254 2016-17 264 2017-18 272 2018-19 280 2019-20 289 2020-21 301 Annexure E Validation Rules The errors have been classified in following categories: Er ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... (e.g. end of day price). The taxpayer will be able to modify the sales consideration before filing the return. 3. Corrected vide Corrigendum to Notification No. 3. of 2021 dated 15-11-2023 before it was read as, Security Class Code Security Class Description Minimum Period of Holding 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 UBT Unit of Business Trust 36 months OTU Other Units 36 months OTH ..... X X X X Extracts X X X X X X X X Extracts X X X X
|