e-TDS :- Download consolidated file.

Friends

                  Consolidated file request functionality is not available for deductors on TRACES from 25th June, 2013 to 7th July, 2013. The functionality will be resumed from 8th July, 2013 onwards as new TDS forms are being implemented

e-Tutorial 

What are the functionalities that deductor can access after logging into their account on TRACES?

The following functionalities are available to a deductor after logging in to TRACES:

1. Landing page
2. Dashboard
3. View Challan Status
4. View TDS / TCS Credit
5. PAN Verification
6. View Statement Status
7. Download Consolidated TAN PAN File
8. Request for NSDL Conso file
9. Request for Justification Report
10. Download Form 16 / 16A
11. Manage Profile
12. Add / Edit sub-users for a TAN

e-TDS :- Procedure & New Password to download Form 16/16A and NSDL Consolidated Fvu File

As everyone knows that a new website has been launched to download form 16/16A or consolidated fvu from tdscpc.gov.in.    Not only website but also style of their passwords to open zip files have been changed. at tdscpc.gov.in.   Details procedure and New Password style have been given below :-

• Enter Request Number or Request Date to filter records
• Both From & To Date are mandatory
• Click on ‘View All’ to view all download requests
• Download buttons will be enabled only if Status is ‘Available’
• Select a row by clicking on it
• Select a row and click on download button to download the requested file

e-TDS :- Password to open NSDL Consolidated File

Friends,

               Today, I have downloaded e-tds NSDL consolidated file from www.tdscpc.gov.in.   No doubt that it is new website.  Earlier this type of working was being done through www.tin-nsdl.com.   It was my first experience with the downloaded consolidated file.   This file was password protected.  Initially, I had placed password  containing 15 digits of token number of the original receipt for the respective return as was done earlier.   But fail to extract the zip file.   I thought that zip or rar version of my computer is not correct.   Therefore  I had downloaded latest versions of winzip or winrar and try to download. But again fail to extract the zip file.   Then I thought that  there may be chance that the said zip file will be extracted through TAN registration number. But no.  This decision was also wrong. 

e-TDS Return, Download Consolidated FVU file in Seconds

As all corrections in TDS returns depend upon consolidated fvu file.  Consolidated fvu files can be arranged only after successful TAN Registration at www.tin-nsdl.com.  Tan Registration process is also available here (Click here).  On login for Tan registration,  request for consolidated fvu file can be made through TDS/TCS link as shown in below picture.  Some time we found that consolidated fvu file takes time in email.   But through status of "Request Link", it can be immediately downloaded as shown in given picture. 

In the above image, it is clear that NSDL has not sent email for requested consolidated fvu, I mean to say file is under process but download link named "Click here to download" is available. 

eTutorial -Complete Online Tan Registration and Request for Consolidated TDS/TCS file from TIN

Friends,  In case you have any problem in Online Tan Registration and Request for Consolidated TDS/TCS file from TIN, 28 slides are given below for your connivance.  Slides show step by step actions required for completing Online Tan Registration and Request for Consolidated TDS/TCS file from TIN.  Needless to explain importance of Consolidated TDS/TCS file.   In future there will be single source to update/correct etds/tcs return which is Consolidated File.  Keeping in view all these things, everyone should devote some time in viewing below slides. 

e-TDS Return, "Tan Registration" Complete Procedure

Friends 

                      Now, Tan Registration procedure is working well.  I have completed complete procedure and achieved fvu file through this procedure.  No doubt it is lengthy procedure but works.  In my view there may be short procedure to download the FVU file.  In case you have not your complete data in soft or hard copy, you can not collect fvu file through this procedure.  It is well known that correction statement can not be filed without having fvu files.  Therefore it is second source to collect file.  First easy source is to collect fvu file is through Nodal

Center appointed by Income Tax Department.   However complete procedure to collect fvue file through "Tan Registration" is given as under:-

Deductors / collectors are required to furnish a quarterly TDS / TCS statement as per guidelines of the Income Tax Department (ITD). For any update in the quarterly TDS / TCS statement, a correction statement is furnished by the deductor / collector. Correction statement is prepared on the latest statement details (accepted) at TIN central system. To facilitate the deductor to ensure that the deductor uses the latest statement, request for TDS/TCS statement can be made online at TIN website. TDS/TCS statement (consolidated) provided by TIN will include all the updates done vide correction statements (accepted at TIN central system) filed by deductor/collector. Consolidated TDS/TCS statement will be available for:

• TDS/TCS statements pertaining to F.Y. 2007-08 and onwards.
• TDS/TCS statements accepted and existing at TIN central system.

1. Features of consolidated TDS/TCS statement are as below:
• Details as per latest statement: Updated details of deductor/challan/deductee/salary records will be provided.
• Challan matching flag: No updates should be done if the status of the Challan/Transfer Voucher is "Matched". Considering the same the status (matching flag) of the challan / transfer voucher as below is provided:
  
  
  
  
  
  • "M" = Matched (No update should be done for such challans/transfer voucher)
  • "U" = Unmatched (Challan can be updated)
  • "P" = Provisionally booked (No update should be done for such transfer voucher)
• Expected challan/ deductee/ salary detail record number: In correction statement for addition of records, sequence number for record (challan/deductee/salary detail) should be continued from the record number (challan/deductee/salary detail) of earlier regular/ correction statement. Example,
  
  
  
  
  
  1. There are 5 challans in regular statement.
  2. 1 challan is added by furnishing correction statement
  If one more challan is to be added vide another correction statement, sequence of the challan record no. will be 7.
  To facilitate the deductor/collector in quoting record number in sequence for added records, expected record number for challan, deductee and salary detail (wherever applicable) is incorporated in the consolidated TDS/TCS statement.
• Provisional receipt number (PRN): In correction statement, deductor/collector is required to quote PRN as under to identify the statement in TIN central system for update:
• Corresponding regular statement and
• Latest accepted/Partially accepted correction statement
To facilitate the deductor/collector in quoting correct PRN of Regular and Correction statement, same is provided in the consolidated TDS/TCS statement.
2. Data structure for consolidated TDS / TCS statement.
• Salary TDS statements.
• Non-Salary TDS/TCS statements.
3. Pre-requisite for requesting TDS/TCS statement online.
• Online request for TDS/TCS statement can be made only on successful registration of TAN (creating TAN registration account) at TIN website.
• Register TAN online at TIN website. For registering TAN click here
4. Steps to be followed for placing the request of consolidated TDS/TCS statement
1. Login to TAN Registration Account with user id, password and TAN.
2. On successful login, under option TDS/TCS, select option "Request- Consolidated TDS/TCS statement".
3. Request for consolidated TDS / TCS statement can be made for your TAN only.
4. On clicking the aforementioned option, provide details of statement as below for which consolidated file is required:
• Provisional Receipt Number of regular statement
• Form no.
• Quarter
• Financial Year
5. On successful validation of the above details, two questions related to the TDS/TCS statement requested will be asked as a part of verification.
6. On successful verification of answers to the aforementioned two questions, request number will be generated and the consolidated TDS/TCS statement will be e-mailed to the user on the e-mail ID provided on TAN registration within 24 hours.
7. Consolidated TDS/TCS statement will be available only if correct answers are provided to the questions for verification.
8. Two attempts within a day will be provided to correctly answer the verification questions.
9. In case of two unsuccessful attempts within a day for the same statement, request for such statement can be placed on next day.
10. In case of large number of records in the TDS/TCS statement requested, the statement will be split in multiple files owing to restriction of mail size.
11. In case TDS/TCS statement is split in multiple files then each file will be sent by separate e-mail.
5. Merging the split TDS/TCS statement
1. In case of multiple files, Merge the files using "File Merge Utility" (FMU) and then extract the contents.
2. "File Merge Utility" can be downloaded from TIN website under the option "TAN Registration" in download section.
3. Click the below link for detailed procedure for merging the split files"
6. Procedure for download and merging of split TDS/TCS statement.
   
7. Using Consolidated TDS/TCS statement for preparing correction statement.
1. Consolidated TDS/TCS statement provided will be in compressed form.
2. Extension of the consolidated TDS/TCS statement will be .tds
3. In case of single file, extract the content of the file by providing password to the file.
4. In case of multiple files, merge the files using FMU and then extract the contents of the merged file by providing password.
5. After extracting the consolidated TDS/TCS statement, import the same in the return preparation utility for making any correction.

Download Consolidated FVU file Problem

Friends,  It has been found that it is a major problem to make a successful request for consolidated fvu file after login at TAN registration. Keeping in mind this problem, NSDL has also made some changes in procedure for making request for consolidated file.  Earlier  four or five  PAN numbers and their TDS amounts specified by NSDL  were required  for making consolidated request. I mean to say there was no limit of numbers of PAN numbers while making request.   But now maximum any three PAN Numbers and their TDS amounts are required which can be seen in second below picture. 

In our view the followings are important  points for making consolidated fvu request.

• Everyone should keep hard copy of  uploaded data of original/corrected  e-tds return.  
• Write User id and Password after successful TAN Registration for it's further use.
• One  Challan detail related to concerned consolidated fvu is required like as BSR code, Challan Sr.No, Date of Deposit of TDS and amount of Challan Amount.
• Challan Serial Number can be entered as 1 instead of  00005 (specified format). But  date of deposit of challan is required in specified format like as (DD/MM/YYYY)*
• Any three PAN numbers and their TDS amounts related to consolidated FVU file  are required. 

Consolidated TDS/TCS Statement

Friends, 

                 Yesterday, I have come to know more knowledge  regarding submission of correction statement more than one time.  Earlier I was in view that the FVU (File Validity Utility) of correction statement can not be downloaded after successfully Tan Registration.  Only fvu of original statement can be downloaded with original Provisional Receipt Number .  But I was wrong,   NSDL provides consolidated TDS/TCS statement through TAN Login.  No doubt ,  for making request for consolidated statement it requires only Original Provisional Receipt Number, but data of FVU of consolidated statement includes all corrections which were made till the date and time of the request.

               In brief  I want to share that meaning of Consolidated TDS/TCS statement is statement of Original including all corrections made upto date. 

Question No.(1) :- Is there any difference between the fvu created by us either from NSDL statement or any other software and the fvu received through TAN Registration process ?

Ans: - Yes, there is lot of difference.   Self created fvu do not contain Provisional Receipt Number and date of uploading of fvu whereas this information is available in fvu which has been received by you after TAN Registration. 

Question No.(2) :-  Fvu received through TAN registration process contains data of corrected statement or not. 

Ans:-  Yes,  this fvu includes all corrections there is no matter that the correction has been made one time or more than one time.  It shows updated data as Original Fvu.  

    

Question No.(3) :-  What is differences between the fvu created by us or fvu downloaded from NSDL.

Ans: -Due to following reasons downloaded fvu is different from fvu created by us.

• Availability of Original Provisional Receipt Number
• Availability of Last Corrected Provisional Receipt Number
• Availability of  Uploading Date of fvu.

Tan Registration Procedure

Friends,

Online TAN Registration The Income Tax Department requires all deductors to register their TANs (Tax Deduction Account Numbers) online. Authenticated access (through user ID and password) will be provided to registered deductors. On login, the following will be available to the deductors- view of the status of all statements filed; download of consolidated quarterly e-TDS / TCS statement for preparation of correction statement; and other functionalities related to quarterly TDS /TCS statement.

After the above registration, it will be very useful that we can easily download consolidated statement to submit correction statement and to view all status of all our returns.

Click here to Register Your Tan

Guidelines for TAN Registration
Other important information Click Here