3CD annexure export / import process from TDS to Income Tax

3CD annexure export / import process from TDS to Income Tax


Process to export / import 3CD Annexure from TDS to Income Tax

 This process helps the user to export/ import the 3CD details entered for a particular PAN in TDS Software to the Income Tax Software using an excel template format easily.

Process to export the data from ZEN TDS software

  1. Run TDS Software → Go into → Reports→ MIS Reports→  3CD Annexure Report
            

  1. Search the PAN number of the client of whom the data has to be exported. All clients from same PAN will appear on the screen. Click on Next to proceed..

  1. Click on TDS Summary (Deductee Details) and then Click on "Download Blank 3CD Template".
            

  1. Click on Download Blank 3CD Template, the software would prompt with a message to save the template. Save the same on a desired location and proceed.


                 

  1. Now to export the data available for the selection, select the template saved at the desired location using Browse button and the click on Export. Once the data is exported successfully, "Data exported Successfully" message would appear.



  1. The data for 3CD annexure would get exported in sheet named as TDS _Summary and TDS_Return_Info.
            

Process to import the 3CD Annexure data in Income Tax software

  1. Select the assessee in which the data of 3CD is to be imported with correct assessment year. 

      Go into AuditTax AuditNew 3CD W.E.F 20/08/2018

            


  1. Point no. 34(a) and 34(b) are the two annexures where the data exported from TDS can be imported, the annexures being- TDS_Summary and TDS_retrun_info respectively. Go to question number 34(a) and select the flag as "yes" from the available drop down. Select the Annexure option.

            Click on Excel Import , Select the Excel template and import. Data will get imported in that particular Annexure. "Save" the data and similarly follow the process for point 34(b).
            
    • Related Articles

    • Income Tax || How to import salary details from TDS software

      Solution: To import salary details in Income Tax module from TDS software you please go to Transactions > Salary Income option given in menu bar. Here, click on TDS Salary Import button and you will get the list of Deductors. Message appears - Just ...
    • 3CD annexure export Process - "Interest details paid u/s 201 (1A)/206C(7)"

      3CD annexure export Process - "Interest details paid u/s 201 (1A)/206C(7)"  This process helps the user to export/ import the 3CD details entered for a particular PAN in TDS Software to the Income Tax Software using an excel template format easily. ...
    • Billing || Client master Import from Income Tax / TDS

      To initiate the import process for the Client Master, ensure that you first select the Consultant Master. Go to the Import form for Master Data, specifically designed for importing data from Income Tax or TDS Software. To access it, follow the menu ...
    • Income Tax || How to Import Trial Balance from BUSY Software

      Please export the Excel sheet using BUSY Software. Follow the steps below to export the BUSY Excel file: Export all the data successfully. Import the exported data into the Trial Balance. To import the data, navigate to Transactions → Balance sheet → ...
    • TDS || Excel export and Import Procedure

      To reduce complications of data entry in TDS software, a facility has been provided where the user can import data through excel and can export data in excel. The process below explains Data import and export through excel in TDS software. Excel ...