How to import finacle file in e-TDS

How to import finacle file in e-TDS


How to import finacle file in e-TDS

Finacle is banking software, which is providing a report in a text format. The report consist of  all financial transaction details,  like payment  date ,tds deducted amount and amount paid detail during the specified period

KDK software provides facility to convert and import  the finacle report to .in TDS software for tds return preparation 


Note : - File will import in selected assessment year  and quarter


Procedure to import finacle file in e-TDS

There are two process to import finacle file. 

First user can directly import detail in software and second is  convert report in excel template .

First process:  Import from finacle report directly  in software

Open the e-TDS software Go to Export / import → Import from finacle report option given in menu bar and select bank name for which finacle report being imported.

Note :- The process is Different  for difference bank and different files.

Below list of bank  which finacle report can be imported in software.

BANK OF BARODA
RAJASHTHAN BANK
BANK OF INDIA
ORIENTAL BANK OF COMMERCE
ORIENTAL BANK OF COMMERCE (NEW)
BANK OF MAHARASHTRA
ANDHRA BANK
PUNJAB NATIONAL BANK (PNB)

Please ensure before importing finacle file, the file being imported and the deductor selected should be the same





Now enter city and state name and browse finacle report and click on proceed button



Now, check the deductee details for the respective Form Type

Go to Deductee Entry → Form Wise Deductee Entry 



Note – Only deductee details would be import through finacle report, Challan details have to be entered in software manually or through mapping process. 

For mapping deductee entry with challan , go to deductee entry > deductee entry mapping (non-salary )



Select deductee entry which you want to adjust with a particular challan and click on deposit







Now, Deductee entry adjusted with challan and we can check the TDS Challan details for the respective Form Type.

Go to Challan Entry → Form Wise Challan Entry.


Second - Convert Finacle Report in excel template for tds return preparation 

Open the e-TDS software Go to Export / import → Convert Finacle to ZEN Excel Template option given in menu bar and select bank name for which finacle report being imported.







All deductee detail will be displayed now click on export button and select the path where the user want to save the excel file. 




Now open excel template, and enter challan and dedcutor details and import excel template in software.

Go to Export/import and click on Import from excel







END






    • Related Articles

    • How to import text/consolidate file in software

      How to import text/consolidate  file in software The purpose of importing a text/conso  file is that all your old filed data gets into the software. You do not have to enter the master and transactions information of the Deductor and the Deductee ...

    • Text file import - Transactions record (challan enetry / dedcute entry) not showing

      Text file import  -  Transactions record (challan enetry / dedcute entry) not showing  Procedure to import text file  Click on Create new return ,the application auto-populates the fields like, Return Type , Financial Year , Quarter and form type ,  ...

    • Express TDS - Deductee/employee master import from excel

      Express TDS - Deductee/employee master import from excel  Step 1 - Go into deductee master and click on import deductee  Step 2- Now click on "downlaod excel template " Enter detail in excel template  you are required to browse the excel file  from ...

    • TDS > CSI File Download process

      What is CSI File? CSI file is Challan status inquiry file which is required to validate data while preparing TDS return. A CSI file can be download from - https://tin.tin.nsdl.com/oltas/ How To Download Your CSI File? To download CSI File Go to ...

    • TDS > Error 13 - Type Mismatch

      Solution: This issue is related to particular Client's database or Conso file issue. To resolve this please follow the steps below: Step 1: Please re-import the consolidate file through Export/Import – Import from Text/FVU/TDS file option and import ...