TaxTMI 
TaxTMI 
Format, Procedure and Guidelines for submission of Statement of Financial Transactions (SFT) for Mutual Fund Transactions by Registrar and Share Transfer Agent
X X X X Extracts X X X X
X X X X Extracts X X X X
.... 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 the Financial Year ending on 31st March shall be furnished on or before 31st o....
X X X X Extracts X X X X
X X X X Extracts X X X X
....xpayer 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 - 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 share....
X X X X Extracts X X X X
X X X X Extracts X X X X
....oes 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 Statement Type A.5 Statement Number A.6 Original Statement 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 Mutual Fund Batch File (MF_BATCH.TXT) B.2 Mutual Fund Account Summary (MF_ACC_SUMM.TXT) B.3 Mutual Fund Transaction Summary (MF_TRN_SUMM.TXT) B.4 Mutual Fund Off-Market Transaction (MF_OFF_TRN.TXT) Sum of Key Values in Rs. (Refer Mutual Fund Account Summary) C.1 Opening Value C.2 Purchase Value C.3 Sale Value C.4 Closing Value I, declare that to the best of my knowledge and belief, the information given in the data files ....
X X X X Extracts X X X X
X X X X Extracts X X X X
....used during validation checks. 2. Financial Year Y VARCHAR (4) FY in which transaction was recorded-YYYY 3. Reporting Period Y DATE Last day of the reporting period DD-MM-YYYY 4. AMC Name Y VARCHAR (100) AMC's Name 5. AMC Code Y 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 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 (400) First Holder's Address 16. Client City N VARCHAR (40) First Holder's Address-city 17. Client Stat....
X X X X Extracts X X X X
X X X X Extracts X X X X
....ng period DD/MM/YYYY 4. AMC Code Y VARCHAR (5) 5. Client ID Y VARCHAR (20) Client ID maintained by the reporting entity 6. Client PAN Y VARCHAR (10) PAN of the Client. Mention PANNOTAVBL if no PAN is available. 7. Client Name Y VARCHAR (250) First Holder's name 8. Security Class Code Y VARCHAR (3) See permissible values 9. Security Code Y VARCHAR (12) Unique security code (e.g. ISIN). Mention ISINNOTAVBLE if no ISIN is available. 10. Security Name Y VARCHAR (200) Name of security (scheme, plan and option) 11. Debit Date Y DATE 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 C....
X X X X Extracts X X X X
X X X X Extracts X X X X
.... # Code Description 1. NB New Batch (Statement) containing new information 2. DB Deletion Batch (Statement) 3. CB Correction Batch (Statement) containing corrections for previously submitted information Permissible Values - Reason for Correction # Code Description 1. A Acknowledgement of original Statement had many errors which are being resolved 2. B Errors in original Statement are being corrected suo-motu 3. C The correction report is on account of additional information being submitted 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 # Security Class Code Description 1. EMF Unit of Equity Oriented Mutual Fund 2. 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. Biha....