TMI BlogFormat, Procedure and Guidelines for submission of Statement of Financial Transactions (SFT) for Mutual Fund Transactions by Registrar and Share Transfer AgentX X X X Extracts X X X X X X X X Extracts X X X X ..... Director General of Income Tax (Systems), with the approval 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 Registrar and Share Transfer Agents 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 t ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... e/transfer is not available, Redemption Offer Price (Exit Load adjusted NAV) on the date of sale/transfer may be taken. The taxpayer will be able to modify the sales consideration before filing the return. 6. The securities should be classified into specified security class for determining the type of asset (short term/long term) and applicable rate. 7. The period of holding (difference between date of sale and date of acquisition of any security) 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 purchases 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: 2 [Security Class Code Security Class Description Minimum Period of Holding Remarks EMF Unit of Equity Oriented Mutual Fund 12 months ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... Submission of Statement of Financial Transactions (SFT) 1. Reporting entities 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). A separate control statement (refer Annexure C) is required to be signed, verified and furnished by the Designated Director. 2. Any file which does not meet the validation requirements will be rejected. 3. In case Reporting Entity needs to modify uploaded data, Correction Statement is required to be filed. In the Correction Statement, only those records should be uploaded in which correction is required. In case Reporting Entity needs to delete uploaded data, Deletion request is required to be filed. Annexure C Control Statement for Mutual Fund Transactions (RTA) Number of Records Values A.1 Reporting Entity Name A.2 ITDREIN A.3 Registration Number A.4 ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... 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) ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... VARCHAR (5) 6. Client ID Y VARCHAR (20) Unique Client ID maintained by the reporting entity 7. Client PAN Y VARCHAR (10) PAN of the Client. Mention PANNOTAVBL if no PAN is available. 8. Client Name Y VARCHAR (250) First Holder s name 9. Client Type Y VARCHAR (1) R - Resident N- Non-resident F - FII Z Not Classified 10. 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 i ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... -YYYY 28. Opening Value Y DECIMAL (18,2) Value of Holding as on first day of reporting period 29. Purchase Value Y DECIMAL (18,2) Sum of purchase cost (net of transaction charges and stamp duty) during reporting period 30. Transaction Charges Y DECIMAL (18,2) Sum of transaction charges during reporting period 31. Stamp Duty Y DECIMAL (18,2) Sum of stamp duty during reporting period 32. Sale Value Y DECIMAL (18,2) Sum of Value of Units Sold (including TDS and excluding STT and Exit Load) during reporting period 33. STT Y DECIMAL (18,2) Sum of STT during reporting period 34. Dividend Paid Y DECIMAL (18,2) ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... Date of Debit in DD/MM/YYYY 12. Debit Type Y VARCHAR (1) Refer Guidelines A AMC (redemption) T Transfer 13. Credit Type Y VARCHAR (1) Refer Guidelines A AMC (purchase) T Transfer 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. 16. Unit price Y DECIMAL (18,2) Estimated Sale price per unit. 17. Sale Consideration Y DECIMAL (18,2) Estimated Sale Consideration. 18. COA Y DECIMAL (18,2) Estimated Cost of acquisition without indexation. ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... feror Name Y VARCHAR (250) First Holder s name 9. Transferee AMC Code Y VARCHAR (5) 10. Transferee Client ID Y VARCHAR (20) 11. Transferee PAN Y VARCHAR (10) Mention PANNOTAVBL if no PAN is available. 12. Transferee Name Y VARCHAR (250) 13. Security Class Code VARCHAR (3) Refer Permissible values 14. Security Code Y VARCHAR (12) Unique Security Code (e.g. ISIN) 15. Security Name Y VARCHAR (200) Name of Security 16. Quantity transferred Y DECIMAL (18,3) ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... UTI Unit of UTI 3. OTU Other Units Permissible Values Transaction Reason # Reason Code Reason Description 1. TRD Transmission (change in holding in event of death of a holder) 2. OTH Other 3. 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 6. Chandigarh CH 7. Dadra and Nagar Haveli DN ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... 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: Errors Record or report level errors which need to be resolved by user as per the specific error code. Defects The reporting entity needs to correct ..... X X X X Extracts X X X X X X X X Extracts X X X X
|