This TDS Entry sheet design to file TDS Form 26Q. You have to follow the instruction to enter deduction & challan data faster.
Firstly fill the Master sheet of TDS & Supplier by clicking command button Master Data Form, go to sheet of TDS Report and click on command button of TDS Data Form in which you can manage whole data. During the deduction entry maintain Ref. No. same which payment would be payable in same challan so that payment entry will adjust against same month deduction so no need to reconcile.
Please enable macros to use the excel utility. To enable Excel Macros , please follow the below steps
File -> Options -> Trust Centre -> Trust Center Settings -> Macro Settings -> Select the radio button 'Enable all macros' -> Click on'OK'.
If prompted to enable macros, select 'Yes' and then open the utility. #xls