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 Audit→Tax Audit→New 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 ...

    • Income Tax || TDS Details

      To enter TDS/TCS details in the software, please follow the process outlined below: Steps for Manual Entry of TDS/TCS Details : Navigate to "Transactions → Tax Detail". By default, the TDS Details section is selected. If you're entering details ...

    • 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 ...

    • 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 ...