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

    • TDS || Import Text or Consolidate(TDS) file

      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 again. To import the Text/TDS file into TDS software, ...

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

    • TDS || Correction → Excel export and Import Procedure

      The procedure below outlines the data import and export through Excel in the TDS software, along with the correction process: To initiate a correction, first download and import the consolidated file into the software. To do so, click on "Click Here ...

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

    • TDS || Invalid file format or BCP Utility error while importing consolidate file

      SOLUTION: To resolve the "Invalid file format or BCP Utility error" error which generally occurs while importing txt\tds\fvu file please go to Tools > Option Settings, Here set default path in all Export Utility Path and then OK. Export Utility path ...