Home

USER MANUAL

image

Contents

1. Here you have two options Restore from archive Restore from specified location Each of the above is briefly explained below Restore from archive This will show you the chronological history of backup taken along with the reference notes that were submitted along through the Backup module You can select a specified backup and click on Restore Button to restore the data Restore from specified location You can also use this option to restore the data only if you know the file location and filename where the same has been stored Once you browse the file and select Restore button your database file will be restored It is very important to understand that restoration will overwrite the existing data and the current database will be lost Before restoration it is advisable to take the backup of the current data TDSMAN User Manual Page 76 Other Utilities 9 2 Software Update From time to time updates will be released on TDSMAN based on statutory changes user feedbacks and bug corrections if any The software can be updated both online internet connection required and offline For updating the software under Utilities click on Check for Updates This is an internet based automated system for updating the software wherein the latest version is checked for and if any new update is found the software is instantly updated In the absence of the internet connection you will need
2. Select Financial Year 2012 13 v Select Quarter Q1 v Select Company B Save Cancel Edit Search Refresh Delete Exit from 26Q The following important parameters should be selected for a return Financial Year Select the financial year of the return Quarter Select the relevant quarter of the return Company Select the company for which the return will be prepared On selection of all the parameters as discussed above the following screen will be displayed TDSMAN User Manual Page 26 Regular Returns Figure 5 3 Return Specific Details as TDSMAN Form 26Q a Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit amp x Form 26Q Domestic Select Financial Year 201 2 13 wal Select Quarter UR v Select Company PDS INFOTECH PRIVATE LIMITED xvj Company Info TAN CALP08143C PAN AAECP6176D Deductor Type K Company Company Name PDS INFOTECH PRIVATE LIMITED View Details Responsible Person RAMESH GUPTA View Details NIL Return C NIL Return Control Summary Return Filing Status Save Cancel Edit Search Refresh Delete Challan amp Deductee Entry Exit from 26Q Generate Returns This data window displays the details company as explained below Company Info TAN TAN No is displayed PAN PAN No is displayed Deductor Type Company Type is displayed Company Name Name of the company is displayed Responsible Person Name
3. TDS TCS Tax Collected at Source Permanent Account Number Commissioner of Income Tax Income Tax TDSMAN User Manual Page 5 Software Installation amp Registration 2 Software Installation and Registration 2 1 Hardware and Software Requirement PC Pentium 1 GB RAM Minimum 1024 x 768 resolution Windows XP or higher version 150MB Hard disk space 2 2 Software Installation and Registration TDSMAN operates on the NET framework of Microsoft If the system already has the NET framework in place TDSMAN directly installs otherwise the NET framework and its components are installed followed by TDSMAN To install the software insert the TDSMAN CD in your PC Right click on the setup file and click on Run as Administrator to start the setup file After Administrator confirmation of the windows you will get the following screen Figure 2 1 Software Installation Step 1 gi TOSMAN lec A Welcome to the TOSMAN Setup Wizard TDS MAN Filing returns made easy The installer will guide you through the steps required to install on Your computer WARNING This computer program is protected by copyright law and international treaties Unauthorized duplication or distribution of this program or any portion of it may result in severe civil or criminal penalties and wall be prosecuted to the masimum estent possible under the law Cancel Click Next button to get the following int
4. 6 10 Query Reports Challan amp Deductee ccc cceccccccesececeescecceessececeusececeeeceeseuecessuaeceesagaesss 54 oA RR Ye Boo ee en ee eee eee ee ee ee ee 56 612 af 1 pol g2 4 0 Lop sasrssrers rE Aa 59 7 Preparation Of Correction RetUINs ccccccscscscsccscscsccccccscsccccccscsceccccecscececcccscsceccececsceceesess 60 7 1 FMP Ort Gata tOr COLCECHIO ean E AE ces deed oedantesaeeene cadantnaene 60 7 2 Make COCCI NS E E E E E E E E O 61 7 3 Generate Correction Return for Submission ssssssssseerressssserresesssssssrereeessssseerresssserereee 68 8 Importing of External Data sessesessssessssesssoecsssessssesssosossseossosossssossseossseossosossssosesssesssoeoe 69 8 1 impon om Excel WV Ol ON serieren abbosewsendeeasaeasenneewiease 70 8 2 Karon omn TOS FIE AE A E 73 9 Other UGS een E E E 75 9 1 Backup and RE STOTE sonein piena EE 75 9 2 SOWNO UDO E e N A 77 9 3 Healthy Practices of USING TDSMAN sscccccsssecccesseccceseccceceeseceeeusececsuneceesuccetauseeeeeauneses 78 TDSMAN User Manual Page 3 1 Preface TDSMAN is a state of the art software solution enabling the companies deductors to keep in pace with the ever changing TDS filing procedures by the Income Tax authorities TDSMAN helps in generation of TDS TCS return Correction of the returns filed earlier irrespective of the software in which the earlier return was filed and generation of various reports and certificates It
5. TAN CALPO8143C FA Year 2012 13 From 0104 2012 To 3006 2012 Form No 260 Correction Statement Challan Details hode Srl Date Sec BSR Code Challan No Chg No Trt ych No Total TDS Sur Chq Ed Cess No 246 Rept Update 1 05105 2012 194H 0004329 06359 0 00 Interest Others 0 00 Figure 6 16 Report on Changes done in Deductee details PDS INFOTECH PYT LTD TAN CALPO 143C FA Year 2012 13 From 01 04 2012 To 30106 2012 Form No 260 Correction Statement Deductee Details hode Sr No PAN Deductee Name Amount Rate Section 194H Challan No 06359 BSR Code 0004329 Update 1 BIUPM8762B NIVEDITA MAHANTA 3042012 1471 00 1 00 Section 194C Challan No 47633 BSR Code 0004329 Update 1 BIUPMS 762B NIVEDITA MAHANTA 2305 2012 4416 37 1 00 Section 194C Challan No 438183 BSR Code 0004329 Update 2 BIUPMS762B NIVEDITA MAHANTA 2206 2012 10662 96 1 00 TDSMAN User Manual Sr Chg Edu Cess Total Deposit Date 05 05 2012 0 00 0 00 15 00 Deposit Date 06 06 2012 0 00 0 00 45 00 Deposit Date 06 07 2012 0 00 01 00 107 00 Total Amount Print Date 1902 2013 Others Rmk Allocated Interest Allocated 0 00 0 00 Print Date 19 02 2013 Amt Dep Rmk Prov Entry Page 52 Certificate amp Report Printing 6 9 Correction Log Purpose This report provides the log for all changes made in the correction return wherein the old value and the changed new value both are displayed It also displa
6. FEU Door Bock Ma Name of Premises Buikding Road Street Lane Area Locality Town DEGA City Pin Code Sie 51D Mobile eMail c Fathers Name 2 Designation TDSMAN User Manual ABACDEAIS K Company 2 COCHE amp KELVE Y BUILDING OLD COURT HOUSE STREET DIRECTOR Company List Run Date 1302 2013 TAN No MUMDO6393C Deductee List Pan No AAACDS449B Run Date 1802 2013 Pan No ALCPGO 63N AAACBI5376 AAACBAS 766 ARAF CS274C AAJPS9664H AAAC CO4G2F AADCCI36 J AFMPT9162K BQZPS9 47N AAAFI51 95K AAACTSS45N AHUPGS382J PANNOTAVBL PANNOTAVBL AERPJ9363A4 AGTPS2727B PAJP S596656 ADJPN3631N ATINPKOS70H AITPD4304R AAMCS 030F Figure 6 21 List of Companies Company List Deductors Company Name PDS INFOTECH PRIVATE LIMITED Figure 6 22 List of Deductees All Deductors Deductee List Deductee Name ASLAM GADKARI BANK OF AMERICA SAN FRANSISCO BARCLAYS BANK LONDON CHANDABHOY amp JASSOOBHOY CHANDAN SAVLA CITI BANK SINGAPORE COMMERZ BANK LUXEMBURG ISHAN THACKER JINISHA SHAH JIVAN SILK MILLS JPM CHASE SINGAPORE KARISHMA GUPTA LULU INTERNATIONAL EXCHANGE ABU DHABI LULU INTL EXCHANGE ABUDHABI POOJA GUPTA PRAKASH K SHAH RAMNIK SAWLA SANDESH NIKAM SHREERAM KHAPSE SHRENIK M DOSHI STANDARD BANK LONDON Certificate amp Report Printing Type NON COMPANY COMPANY COMPANY COMPANY NON COMPANY COMPANY COMPANY NON COMPANY NON COMPANY CO
7. Mo of Deducter Records i Total TOS TES ki Dele of Fling E Tan Depostied Friisk SMES FAD Ciuk PAD Fep Ho DDD Cuk DOO Regho Sie Windy H TDSMAN User Manual Page 39 Certificate amp Report Printing b Challan This report provides the details of all the challans for the selected return It can be sorted on the basis of the date section or the way it has been entered Figure 6 2 Report on Challan Details PDS INFOTECH PRIVATE LIMITED c Deductee TAN MUMDO6393CFA Year 2012 13 Page 1 of 1 From 01 04 2012 To 3006 2012 Form No 280 Challan Details Print Date 18402 2013 Date Srl No Sec BSR Code Challan No Chg No Total TDS Sur Chg Ed Cess Interest Others Total Amount Rmk 24G Rept Trf vch No 1210112013 1 194J 0290179 92512 4000 00 0 00 0 00 0 00 0 00 4000 00 0406 2012 2 194 0290176 91196 5960 00 0 00 0 00 0 00 0 00 5960 00 0410712012 3 194J 0290179 90126 6365 00 0 00 0 00 0 00 0 00 6365 00 3004 2012 4 1941 0290179 92589 7100 00 0 00 0 00 0 00 0 00 7100 00 0406 2012 5 1941 0290179 91223 7100 00 0 00 0 00 0 00 0 00 7100 00 0410712012 6 1941 0290179 90168 7100 00 0 00 0 00 0 00 0 00 7100 00 30704 2012 7 1941 0290179 92545 14450 00 0 00 0 00 0 00 0 00 14450 00 0406 2012 1941 0290179 91209 14450 00 0 00 0 00 0 00 0 00 14450 00 04072012 9 1941 0290179 90146 269 00 0 00 0 00 12 00 0 00 281 00 04072012 10 1941 0290179 90158 269 00 0 00 0 00 00 0 00 277 00 04407201
8. PRAKASH K SHAH AGTPS27278 lv Select Deselect All Search Select the deductees for which the TDS certificates have to be printed Enter values for Place and Date of Issue if you want this to be printed in the certificate Print Option Place Date of Issue The following certificate will get printed TDSMAN User Manual Page 41 Certificate amp Report Printing Figure 6 4 Certificate Form No 16A FORM NO 16A See rade A T Certhia ender secton 203 of the Incometax Act PS for Tax deducted at source mare am asf te mt PES INFOTECH PR ATE UNTED ASLAM GAD RAR 20 COOME E KELET BUILDING OLD COURT HILSE STREET TORE WOTILAL HAGAR 1 G0RESLON WEST WUWEAL MOLKATA 720 SHH WEST SEHGAL MAHARASHTRA won a THE GOWMESSIORER OF INCOME TAX 70S TIH FLOOR MIDDLETON ROW ROLEATA THOT ep Geen ey Um ay of Pamer L DETAJLE OF TA DEDUCTED AND DEPT EDK THE CENTRAL OCVERNMERT ALETUHT THROU Boe ENTRY Te Deduction to pred payor whee het of tact dette mri depoeited with imped bo De ded iL DETALI OF TAs DEDUCTED AnD GERSEITED i THE GERTAAL GIW ERHWENT AGGOUAT THROUGH CHALLA Them Cette bo prcevicde prai whee chee oof et Sede aed epee eS eget ts he ede RAMAN GONE sondeugiie of waring nthe capecty of RECTOR do hereby ceri Geri a care of Rs 3225090 Rupeses Tiree Those Taree Hundred Tween Fie only has been deducted andi deposited to be creat of fhe Cenk Goverment rhe oeiy het be
9. 422 0 00 Cess 423 0 00 Total 424 Tax Deposited 425 Remarks 428 Normal Higher Rate Below Threshold Limit Lower Deduction No Deduction Transporter Challan Amount 5000 00 Difference 5000 00 Titel Tex Depia Exit from 26Q Back to Home Screen The above screen is divided into three sections The left panel is the area where data has to be entered The right panel displays records as you keep on entering The bottom part has the self labeled action buttons The challan details screen consists of the following fields Deductee Serial No This is an auto generated sequential number Deductee Name Enter the name of the deductee PAN Enter the PAN of the deductee Code Select the deductee code from the dropdown list TDSMAN User Manual Page 30 Regular Returns provided Select the section under which TDS deduction for the record was done Enter the date on which the payment was made Enter the amount paid Section Payment Date Amount of Payment Rate Enter the rate of TDS Income Tax Enter the Income Tax deducted Surcharge Enter Surcharge Cess Enter Cess Total The total deduction will automatically get populated here Remarks Select the relevant non deduction remark Certificate No Enter the certificate number if any non deduction or lower deduction remark is selected Click on the Save button to record entered details The saved entr
10. 91209 14450 00 0 00 0 00 i 0 00 14450 00 260 04 07 12012 0290179 90126 6365 00 0 00 0 00 0 00 6365 00 260 04 07 12012 0290179 90163 7100 00 0 00 0 00 0 00 7100 00 260 04 07 12012 0290179 90146 269 00 0 00 0 00 0 00 231 00 260 O47 2012 0290179 90153 269 00 0 00 0 00 d 0 00 277 00 260 04072012 0290179 90134 14719 00 0 00 0 00 J 0 00 14719 00 1281 2013 0290179 92512 4000 00 0 00 0 00 4000 00 Total 1762 00 0 00 0 00 0 00 1902 00 TDSMAN User Manual Page 47 Certificate amp Report Printing 6 6 Summary Report Deductions Purpose This report provides the summarized information of all the deductions made by a company for the any specific period for a particular form or across different forms for a given financial year As per the requirement the user has to provide the specific criteria on the basis of which the report will be generated Run Time Selection Criteria Company TAN FA Year Challan Type Select Forms Summary Type Select the company for which the report is to be generated Select the Financial year for which the report is to be generated Select the type of the challan to filter out particular type of Challan Select one or multiple forms across which the report is to be generated Select the summary type from the given options Summary Type Monthly Quarterly Annual If Monthly Summary or Quarterly summary is selected then additionally the month range or quarter range has to be selecte
11. Returns TDS TCS form Transaction Return Generated selected s details i e Challan Deductee Employee data TDSMAN User Manual Page 13 The details of the different steps involved in generating the returns are given below Process Diagram Select TDS TCS Form 24Q 26Q 27Q 27EQ from the transaction menu In the Form select the Financial Year Quarter and Company Proceed with providing Challan and corresponding Deductee details After completion of all entries generate the return and complete the validation process The validated file is to be copied on CD Floppy Pen drive for submission or upload Print Form 27 A or 27 7B as applicable that is accompanied along with the CD Floppy Pen Drive TDSMAN User Manual Page 14 3 2 2 Correction of TDS Returns This is the process through which the company deductor prepares the corrections of the TDS TCS details submitted earlier to the Income tax department of India Figure 3 2 Processing of Correction Returns Import the file Make Generate Download Retur TDS TCS file Corrections in HOMI Q IC o a 3 3 Getting familiarized with the Action Buttons of TDSMAN Figure 3 3 Table of Action Buttons Add Enables you to create a new record Save Enables you to save data It could be a new record or a modified record Cancel Enables you to reset the screen The screen is now ready to accept a new entry E
12. Selection Criteria Company TAN Select the company for which the report is to be generated FA Year Select the Financial year for which the report is to be generated Challan Type Select the type of the challan to filter out particular type of Challan Select Forms Select one or multiple forms across which the report is to be generated Select Qtrs Select one or multiple quarters across which the report is to be generated On providing the above details all the challan sections present for the given criteria will get listed Description 192B Payments made to employees other than Govt employees Interest other than interest on securities Contractors Sub Contractors Commission amp Brokerage Rent Professional amp Technical Services Select Deselect All Search Select the sections for which the report has to be generated and press OK button to print the report Figure 6 9 Challan Reports PDS INFOTECH PRIVATE LIMITED TAN MUMDO6393CFA Year 2012 13 FORMS 260 Challan Report QUARTERS Q1 Form Of Date BSR Code Challan Nos TDS Surcharge Edu Cess Others Total Amount Remar No 24G Rept T V No 260 Q1 30042012 0290179 92539 7100 00 0 00 0 00 0 00 7100 00 260 30 04 2012 0290179 92545 14450 00 0 00 0 00 i 0 00 14450 00 260 04 06 2012 02901 76 91196 6960 00 0 00 0 00 j 0 00 5960 00 260 0406 2012 0290179 91223 7100 00 0 00 0 00 j 0 00 7100 00 260 04706 2012 0290179
13. adapts to your business regardless of whether it is corporate banking amp insurance Government bodies or SMEs amp individuals TDSMAN is a versatile and configurable tool that enables return generation of all type of Forms Form 24Q Form 26Q Form 27Q amp Form 27EQ in line with the requirements of Income Tax authorities 1 1 Audience This manual is intended to assist the users both trial and licensed of the TDSMAN software 1 2 Manual Organization This manual starts with the detailed description of installation and registration of the TDSMAN software This is followed by the overview of the complete software including the different forms that are used for filing the TDS TCS returns Then it continues to provide the detailed description of the process for filing of the returns Correction of the returns filed and the generating of various certificates and reports 1 3 Document Convention This guide uses the following formatting conventions Figure 1 1 Document Convention Guide IF YOU SEE IT MEANS boldfaced text Emphasized subjects meres The word or set of words are especially italicized text emphasized Blue written text indicates mandatory Blue text l l information nae The following paragraph provides additional ote information Ti The following paragraph provides suggestive ip USE TDSMAN User Manual Page 4 Preface 1 4 Abbreviation Figure 1 2 Table of Abbreviation Abbreviation
14. ai TDSMAN Receipt No Master ay Masters T Regular Return Corrections Return Reports HSDL Information Utilities Exit X Vie Receipt No Master aral Mod Create Filter f 1 f F 1 f r Financial Year v Form No _ Company Name vi Financial Year Form No Quarter Company Name TAN No Token No 2011 12 260 Q1 PDS INFOTECH PYT LTD CALPO8143C 2011 12 260 Q2 PDS INFOTECH PYT LTD CALPO8143C 2011 12 260 Q3 PDS INFOTECH PYT LTD CALPO8143C gt 260 er 15 INFOTEC i 2012 13 24Q Qi PDS INFOTECH PYT LTD CALPO8143C 050365112356998 2012 13 260 Qi PDS INFOTECH PYT LTD CALPOS8143C 2012 13 240 Q2 PDS INFOTECH PYT LTD CALPO8143C 2012 13 260 Q2 PDS INFOTECH PYT LTD CALPO8143C swe Canoe The salient feature of this interface is as given below A grid is displayed with the records of all returns that has been created through the software TDSMAN User Manual Page 36 Regular Returns The bottom part has self labelled action buttons To add or Edit a Receipt Number you have to use your mouse to select the return given on the grid After selecting a return of a particular Company Financial Year Quarter amp Form just double click on the record or select the Edit button to get the following Interface Figure 5 12 Edit Receipt No mi TDSMAN Receipt No Master a Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit A xX Financial Year 201
15. creating a new employee TDSMAN User Manual Page 23 Masters Figure 4 9 Employee Master Details ge TDSMAN Employee Master oJ Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit Company Name Employee PAN PANNOTAVBL Employee Name Employee Category G General Designation Add Edit Save Cancel Search Delete Refresh Exit The above screen shows the following fields of employee information Employee PAN mandatory Enter the PAN No of the employee Employee Category mandatory Select the category from the dropdown list provided Employee Name mandatory Enter the name of the employee Employee Ref No Enter the company s reference no of the employee Designation Enter the designation of the employee Modify an Employee Refer to Section 3 3 Getting familiarized with the Action Buttons of TDSMAN Remove an Employee Refer to Section 3 3 Getting familiarized with the Action Buttons of TDSMAN A deductee cannot be deleted if it has been used in the any return TDSMAN User Manual Page 24 5 Regular Returns To file the return you will have to select a particular form under which the return will be prepared Basically there are four forms that can be selected These four Forms are explained in section 3 1 There are three broad steps required for the preparation of the file for returns They are as following i Selection
16. generate your TDS TCS return The Generate Return button is present on the Home Page of the For Click on the Generate Return and the following interface appears on the right panel TDSMAN User Manual Page 34 Regular Returns Figure 5 10 Generate Returns TDS filing involves following steps 1 Generation of text file 2 Creation of FVU file using the text file 3 Printing of Form 277A Step 1 TDS TCS Input File Name with Path Step 2 and 3 E CSI file download Optional Internet required TDS TCS Output folder C Program Files TDSMAN TDSMAN FVU Riles Greate Uhe Open Output Folder There are 3 steps involved in the Generation of returns i Generate the text file ii Cross Verification of the challans iii Validation of the file generated using utility provided by IT department We shall discuss in details about all the steps mentioned above over the subsequent sections Generate the text file In the first step you will have to generate the text file This text file is used as an input file for the validation by the utility provided by Income Tax Department Cross Verification of the challans In second step you can check uncheck Automatic CSI file download link for which Internet connection is a prerequisite This will download a file which will have the Challan details as per IT records provided by the Bank from the NSDL s website for cross verification of the challans Va
17. generated Provide the Rate for which the report is to be generated Figure 6 19 Deductee Query PDS INFOTECH PRIVATE LIMITED TAN MUMDOG2Z52CFA Yinw 2012 12 From Oste O1M4 2012 To 18M2f2013 Deductee Wise Query Report Page of1 Date Section Amount Pald Rate TOS Amount TOS Deposited Pay Doc No Pay Doc Date Remarks Dediche Nine ASLAM GADKARI PAN ALCP GOFTESN Type Norn Compary 1009 2012 194J 19600 00 1960 00 91196 04062012 10106 2012 194 13660 00 1266 06 80126 O4 07 012 10 07 2012 194 13300 00 1330 06 0332 OBO S012 Total 46440 00 4644 00 Form No lt 260 Section No selected 194 TDSMAN User Manual Page 55 6 11 Master Lists Purpose This report provides the option of printing the company details list of Companies Deductors Deductees or Employees Company Details 1 Particulars of Deduector a Hame D Adis FEU Door Bock Fao Name of Premises Building Street Lane Area Locality Town DEA City Tae Pin Code Certificate amp Report Printing Figure 6 20 Company Details PDS INFOTECH PRIVATE LIMITED TAN MUMDOG3SC Company Details Prt Date 2022013 a PAO Code CODRE amp KELVEY BUILDING PAD Fieg No OLD COURT HOUSE STREET DOG Code DIDO Reg No KOLKATA Sale WEST BENGAL Minestry TOO eMail noppis c Tax Deduccion Account Number TANM id Permanent Account Number TAN e Deductor Type 2 Particulara of Responsible Person 3 Name 0 Address
18. interest and others fields are copied to allocated fields as well The default values can be changed in this modify mode TDSMAN User Manual Page 29 Regular Returns Delete a Challan In order to delete a challan select the challan you need to delete from the right panel with the help of the mouse After selecting the record click on Delete button then after seeking your confirmation the selected record will be deleted Whenever a challan is deleted then all the deductees present in that challan will also subsequently get deleted Add Deductee Details To add the deductee against any Challan select the particular Challan from the grid and click on Deductee Details Deductee Details button __ This will transfer you to an interface as shown below for providing Deductee details Figure 5 6 Add Deductee TDSMAN Form 260 a Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit amp x Form 26Q Domestic t Fi Yez 0 gt l f Q y NI i l IVATE I tT Et Challan Srl No Section 194C Deductee Details Challan No 00004 Date 0870472012 SINo PAN No Deductee Name Amount Date Total Tax Deposited Deductee Srl No Provision Entry Deductee Name 417 g PAN 416 Code 415 01 Company v Date 418 _ DD MM YYYY Amount of Payment 419 0 00 Rate 427 0 0000 Income Tax 421 0 00 Surcharge
19. need to enter limited data adequate for preparing the TDS return Enter Form 16 Details On selecting this option you will need to enter all information that will help in preparing the TDS returns as well as also print Form 16 for the employees The above screen is divided into three sections The left panel is the area where data has to be entered The right panel displays records as you keep on entering The bottom part has the self labeled action buttons Enter the salary details on the left panel as per the field columns After providing the details of each record click on the Save button The saved entry will be displayed on the right panel As you keep on making more entries keep saving each record and list of all the records will get displayed on the right panel TDSMAN User Manual Page 67 Preparation of Correction Returns Modify Salary record In order to modify a salary record select the record you need to modify from the right panel with the help of the mouse Either double click on this entry or click on the Edit button The selected entry will be displayed on the left panel which can now be modified and saved again Delete Salary record In order to delete a salary record select the record you need to delete from the right panel with the help of the mouse After selecting the record click on Delete button then after seeking your reconfirmation the record will be deleted 7 3 Generate Correct
20. save more entries the records get displayed on the right panel An illustrative screen of two saved challans is displayed as below Figure 5 5 Challan Details ai TDSMAN Form 260 a Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit ate Form 260 Domestic 13 Select Quarter QT lect Lompany PDS INFOTECH PRIVATI IMITED Sri No 401 Challan Details Sl Section Challan No Deposit Dt BSR Code Tax Deductee Total Difference Section 402 15 v 1 194C 00004 08 04 2012 0000144 5000 00 0 00 5000 00 Professional amp Technical Services 2 jaw 08 04 2012 Date of Payment 411 08 04 2012 DD MM S YYY BSR Code 410 00001 44 Challan No 412 Cheque No 409 TDS 403 Surcharge 404 Education Cess 405 Interest 406 Others 407 Total 408 Remarks Deductee Details Exit from 26Q Back to Home Screen Modify a Challan In order to modify a challan select the challan you need to modify from the right panel with the help of the mouse Either double click on this entry or click on the Edit button The left panel will display details of the selected entry which can now be modified and saved again Dror When a challan details is shown in modify mode you will be able to see two additional fields viz Interest Allocated and Others Allocated By default the amount entered in
21. to download the update file from the website www tdsman com and update as per the interface as below Figure 9 3 Software Update TOSMAN Updater i TDS MAN filing returns made easy Choose the application fle to update m your application Here you can specify the downloaded latest update location and then click on L HPdste button to update the software TDSMAN User Manual Page 77 Other Utilities 9 3 Healthy Practices of using TDSMAN Regular Backups Ideally each day when data has been added modified in the software Backup files should be copied in some external storage media such as pen drive external hard drive etc Check and update the software regularly Refer to the User Manual Video Demo if something is not understood in the software Visit www tdsman com for resources and latest on TDS TCS TDSMAN User Manual Page 78 Visit us at www tdsman com TDS MAN filing returns made easy Developed by PDS INFOTECH P LTD 20 Old Court House Street 2 Floor Kolkata 700001 Phone 033 22623535 64596006 Fax 033 22488451 Email info pdsinfotech com
22. will be highlighted using the different colour conventions Make the relevant corrections and save this document Now once again you need to import the corrected excel sheet as described above and validate the same After validation is successful you will get the following interface where every Challan and its deductee detail can be checked and verified by user Figure 8 3 Verify Imported Data TDSMAN Import from Excel file mef aJ Masters Regular Return Corrections Return Reports HSDL Information Utilities Exit a felt Import Summary TAN No CALPO08143C Company PDS INFOTECH PRIVATE LIMITED CALP08143C Financial Year Form No Quarter Total Challan Records 5 Total Deductee Records Amount Paid 3785569 04 Challan Amount 44764 00 TDS Deducted 43906 00 New Deductees Found o Challan Details SI No Section No Challan Transfer o Deposit Date BSR Code 24G No No of Deductees Tax Deductee Total Difference Status gt 1 194C 3325 06 08 2011 6390340 22 18124 00 17266 00 858 00 2 194H 12345 06 08 2011 6390340 1 349 00 349 00 0 00 3 194J 3466 06 08 2011 6390340 1 1158 00 1158 00 0 00 4 194C 2812 06 09 2011 6390340 20 18983 00 18983 00 0 00 5 194J 123 30 08 2011 6390340 1 6150 00 6150 00 0 00 Progress Once it is verified you should click on Import Data ttn to start transferring data into the software database The data gets transferred into the system only after Import Data
23. 00 00 Total 64305 00 6431 00 6431 00 AAJPS9664H CHANDAN SAVLA Q2 194 F 7700 00 7 70 00 7 70 00 Q3 194 16650000 16650 00 16650 00 Total 244200 00 24420 00 24420 00 AFMPT9162K ISHAN THACKER q2 194H 1000 00 100 00 100 00 Q4 194 25000 00 2500 00 2500 00 Total 106000 00 10600 00 10600 00 Grand Total 461055 00 46106 00 46106 00 TDSMAN User Manual Page 45 Annual Summary Certificate amp Report Printing Figure 6 8 Employee Party wise Summary Report Annual Deductee Transactions Annual Summary PAN Party Employee Marie ALCPGOFEEN ASLAM GADKARI ABAPCE2fdG CHANDABHOY amp JASSOOBHOY AAIPSS664H CHANDAN SAMLA AFMPTS162K ISHAN THACKER PDS INFOTECH PRIVATE LIMITED TAM MUMDOBS930F 4 Year 2012 13 Period Sector 202 13 194 202 13 134l z012 13 134 Total 2012 13 134l 2012 13 194H 2012 13 134l Total Grand Total Amount Paid 4656000 ZEDIG 00 29306 00 64305 00 24420000 1000 00 26000 00 106000 00 461055 00 TOS Amount 4656 00 2600 00 2921 00 6431 00 2442000 2100 00 250000 10600 00 46106 00 TOS Deposited 4656 00 2500 00 2921 00 6431 00 2442000 2700 00 2500 00 10600 00 46106 00 TDSMAN User Manual Page 46 Certificate amp Report Printing 6 5 Challan Report Purpose This report provides the list of all the Challan payments made across one or multiple forms and further across one or multiple quarters for a given financial year Run Time
24. 00 1000 00 Non Cormpany ALCPGOT65N ASLAM GADKARI 1006 2012 13650 00 10 0000 1365 00 1365 00 Total 63650 00 6365 00 6365 00 Section 1941 Challan No 92539 BSR Code 0290179 Deposit Date 3004 2012 Non Cormpany AGTPS2727B PRAKASH K SHAH 0504 2012 71000 00 10 0000 7100 00 7100 00 Total 71000 00 7100 00 7100 00 Section 194l Challan No 9122 BSR Code 0290179 Deposit Date 04 06 2012 Non Company AGTPS2727B PRAKASH K SHAH 0505 2012 71000 00 10 0000 7100 00 7100 00 Total 71000 00 7100 00 7100 00 Secton 194l Challan No 90168 BSR Code 0290179 Deposit Date 04 07 2012 TDSMAN User Manual Page 40 Certificate amp Report Printing 6 2 Certificate Printing Purpose This report is used to print TDS amp TCS Certificates Form 16 is printed for Form 24Q Salary Form 16A is for Forms 26Q amp 27Q and Form 27D is for Form 27EQ As per the requirement the user has to provide the criteria for generating printing all or selective certificates Run Time Selection Criteria Deductor Company Select the Deductor Company for which the certificate has to be generated Financial Year Select the Financial Year for which the report has to be generated Quarter No Select the Quarter No for which the report has to be generated On providing the above parameters all the deductees present for the given criteria will get listed Deduolee List FF JINISHA SHAH BUZPSS 4 N FF JIVAN SILK MILLS AAAT ISI fe KARISHMA GUPTA AUPGSX E PANA GUPTA F RPJSASAA
25. 1 ot TOSMAN Registration Online Registration Process filing returns made easy step lol 2 Enter Serial No Serial No 13320H69 TDSMAN User Manual Page 9 Software Installation amp Registration On entering the valid serial number you get the following interface Figure 2 7 Online Registration Process Step 2 d TDSMAN Registration Online Registration Process DS M AN filing returns made easy Step 2of 2 Enter Licensee Details KEJRIWAL PDS INFOTECH PRIVATE LIMITED inio Spdarniotsch co 9970243014 OLD COURT HOUSE STREET KOLKATA PIN 700001 WEST BENGAL 0339 22493451 Provide your details and click Next to proceed and complete the registration process You will get the following confirmation screen where you have to select Finish button to exit the registration process Figure 2 8 Online Registration Process Step 3 Se TOSMAN Registration Registration Complete l DS MAN Tiling returns made easy IDSMAN has been successfully registered Click Finish to Exit TDSMAN User Manual Page 10 Software Installation amp Registration OFFLINE REGISTRATION Select Offline on the first screen of the registration process if you don t have an internet connection and click on Next button The following interface is displayed Figure 2 9 Offline Registrat
26. 12 Cheque No 409 TDS 403 Surcharge 404 Education Cess 405 Interest 406 Others 407 Total 408 Remarks Edit Delete Deductee Details Exit from 260 Back to Home Screen In this section we concentrate on entering and maintaining all the Challans which have been submitted The above screen is divided into three sections i The left panel is the area where data has to be entered li The right panel displays records that has been entered iii The bottom part has the self labeled action buttons The challan details screen consists of the following fields Srl No This is an auto generated sequential number Date of Payment Enter the date on which Challan was submitted BSR Code Enter the BSR code of the Bank Challan No Enter the Challan No TDS Enter the TDS Value Surcharge Enter the surcharge value Education Cess Enter Education Cess Interest Enter the interest value Fee Enter the Fee value paid for late submission of the TDSMAN User Manual Page 28 Regular Returns return Others Enter other value if any Total The total value will get calculated and displayed automatically Minor Head Select the appropriate Minor Head as mentioned in Challan Remarks Enter remarks The above details will get recorded on clicking the Save button The saved entry will be displayed on the right panel As you
27. 194J PDS INFOTECH PRIVATE LIMITED TAN MUMDO6393CFA Year 2012 13 Deductions Quarterly Summary Total Payments TDS Amount 664573 00 65457 00 163250 00 16325 00 113000 00 11200 00 662782 00 66273 00 278300 00 27830 00 45230 00 453 00 556650 00 55665 00 219305 00 21931 00 50000 00 5000 00 50000 00 5000 00 No Of Deductions 9 2 13 13 1 15 10 2 1 No Of Deductees Annual Summary Figure 6 12 Summarized Deductions for a Company Annual Report Period Form No 2012 13 260 2012 13 260 2012 13 260 2012 13 260 Section 194C 194H 194 194J PDS INFOTECH PRIVATE LIMITED TAN MUMDO6393CFA Year 2012 13 Deductions Annual Summary Total Payments TDS Amount 45230 00 453 00 113000 00 11200 00 1924008 00 192400 00 710855 00 71086 00 No Of Deductions 1 2 33 33 No Of Deductees TDSMAN User Manual Page 49 6 7 Summary Report Deductors Purpose Certificate amp Report Printing This report provides the summarized information of all the deduction made by all companies deductors for the specified financial year Run Time Selection Criteria FA Year Click on OK button to print the report based on above selection Tan Ho MUMDO6393C MUMDO6393 C MUMDO6393C MUMDO6393 C MUMDO6393C MUMDO6393 C MUMDO6393C MUMDO6393C MUMDO6393C MUMDO6393 C MUMDO6393C MUMDO6393C MUMDO6393C MUMDO6393 C MUMDO6393 C MUMDO6393C Select the Financial year for which the
28. 2 11 1941 0290179 90134 14719 00 0 00 0 00 0 00 0 00 14719 00 Total 31732 00 0 00 0 00 20 00 0 00 1802 00 This report provides the details of all the deductee within the challans The deductees can be sorted on deductee name date or as entered within the challan Figure 6 3 Report on Deductee Details PDS INFOTECH PRIVATE LIMITED TAN MUMDO6393C FA Year 2012 13 Page 1 of 1 From 01 04 2012 To 30 06 2012 Form No 26G Deductee Details Print Date 18402 2013 Type Srl No PAN Deductee Name Date Amount Rate Total TDS Amt Dep Prov Enty Remarks Section 194J Challan No 92612 BSR Code 0290179 Deposit Date 12 01 2013 Non Company AERPJIGBA POOJA GUPTA 100472012 20000 00 10 0000 2000 00 2000 00 Non Company BOZPS9T47N JINISHA SHAH 100472012 20000 00 10 0000 2000 00 2000 00 Total 40000 00 4000 00 4000 00 Section 194J Challan No 91196 BSR Code 0290176 Deposit Date 04 06 2012 Non Cormpany BoZPSof47iN JINISHA SHAH 1005 2012 20000 00 10 0000 2000 00 2000 00 Non Company AERPJ966BA POOJA GUPTA 1005 2012 20000 00 10 0000 2000 00 2000 00 Non Company ALCPGOT65N ASLAM GADKARI 1005 2012 19600 00 10 0000 1960 00 1960 00 Total 59600 00 5960 00 5960 00 Section 194J Challan No 90126 BSR Code 0290179 Deposit Date 04 07 2012 Non Cornpany AERPJ966BA POOJA GUPTA 1006 2012 20000 00 10 0000 2000 00 2000 00 Non Cornpany BOZPS9i47N JINISHA SHAH 1006 2012 20000 00 10 0000 2000 00 2000 00 Non Cornpany AHUPGS362J KARISHMA GUPTA 1006 2012 10000 00 10 0000 1000
29. 2 13 Quarter Q1 Company Name PDS INFOTECH PRIVATE LIMITED Form No 260 Receipt No EFJHABOS Date of Filing 30 06 2012 DD MM YYYY Token No 050420500623920 Search Refresh Exit Here you can to record the details of the receipt and click on the Save button TDSMAN User Manual Page 37 6 Certificate amp Report Printing TDSMAN has an in built comprehensive system for printing TDS TCS certificates and reports It generates report for on screen viewing and printing hard copies serving multiple purposes such as record keeping auditing filtered queries etc The report interface is simple to use with convenient self explanatory labels for understanding Most of the reports have the facility for setting filters across multiple Form types Quarters Deductees Section etc 6 1 Quarter Wise Reports Purpose This report is used to generate the details of all the records that have been submitted in a particular return The user has to select the specific parameters on the basis of which the report will be generated Selections Deductor Company Select the Deductor Company for which the report has to be generated Financial Year Select the Financial Year for which the report has to be generated Quarter No Select the Quarter No for which the report has to be generated Form No Select the Form No for which the report has to be generated Select Type On the basi
30. D Branch Division PAO Code Deductor Type K Company PAO Reg No Company Details Responsible Person Details DDO Code Fit Dr Bick No 20 O Sane Different DDO Reg No Building COOKE AND KELYEY BUILDING Fit Dr Blick No 20 ae sre elect Ministr Rd Strt Lane OLD COURT HOUSE STREET Building COOKE AND KELVEY BUILDING z aea onany Rd Strt Lane OLD COURT HOUSE STREET aa Town District KOLKATA Area Locality PIN 700001 Town District KOLKATA CIT Details Address THE COMMISSIONER OF INCOME TAX TDS City KOLKATA PIN 700071 Mobile No 9834986232 Click here to know your CIT details Search Delete Refresh Exit In the above screen there are self explanatory fields against which data has to be entered Further we can classify the fields into 2 broad following sections a Details of Company Enter the details of the company such as Company Name TAN No PAN No Deductee Type Address and other govt details if applicable b Details of Responsible Person Enter the details of the responsible person such as Name Father s Name Mobile No Address etc Brief description of each field is mentioned below Company Details Company Name TAN No Mandatory PAN No Mandatory Branch Division Deductor Type mandatory Enter the company s name Enter the TAN No of the company Enter the PAN No of the company Enter the branch name or the division name of the company Select the ty
31. Import from Excel gt Create Blank Excel sheet Import from TDS File Consolidated Statement Import Deductee Master Import Employee Master Add Deductee Import Company Master Transactions Form no 240 a carr The following window will be displayed Figure 8 2 Validate Excel TDSMAN Import from Excel file a Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit amp x Excel Validate Select Select Financial Year 2011 12 si Select Quarter Q2 v Select Form No 260 v Select Company PDS INFOTECH PRIVATE LIMITED CALP081 43C v Select Excel file Excel file path C XLS_BLANK26Q xls Progress l Validate Excel file Select the Financial Year Quarter Form No and Company Name for which the data needs to be imported Browse and select the Excel file and select the relevant Import type from the options provided Cick on the button to validate the selected excel file This file will be validated and only after successful validation this file will be ready for getting imported in the software Please ensure that the Excel workbook is correctly selected TDSMAN User Manual Page 72 Import of External Data If there is any error in the selected Excel file then the same would be displayed in a separate sheet in this file only Additionally you can select the option of colour coding where in the errors
32. It Dr Block No Enter the building name Enter the name of the road street lane Enter the name of the area locality Enter the name of the town district Enter the PIN no Enter the name of the state Enter the STD code Enter the phone no Enter the E mail address of the responsible person Modify a Company Deductor Refer to Section 3 3 Getting familiarized with the Action Buttons of TDSMAN Dror All the modifications made in the company will only get reflected in the returns for which the return filling details are not mentioned Remove a Company Deductor Refer to Section 3 3 Getting familiarized with the Action Buttons of TDSMAN The company deductor cannot be deleted if any return is made against it TDSMAN User Manual Page 18 Masters 4 2 Deductee Master In the Deductee master the deductees can be created Once Deductee is created in the master it will appear in the help window of transaction module User just needs to select the Deductee from the help window to populate the details of the deductee in the required fields Whenever a user saves a record of new deductee in transaction module its master gets automatically created In order to access the deductee details click on the Add Deductee shortcut as shown in the front screen below Figure 4 4 Access Deductee Master TOSMAN e S i Regular Return Gorrections Return Beporte NSDL information TRACES information ytii
33. MPANY COMPANY NON COMPANY NON COMPANY NON COMPANY NON COMPANY NON COMPANY NON COMPANY NON COMPANY NON COMPANY NON COMPANY COMPANY TDSMAN User Manual Page 57 Employee List Figure 6 23 List of Employees PDS INFOTECH PRIVATE LIMITED TAN HUM DOG393C Certificate amp Report Printing Print Date 18022013 Employee List Page 1 of 1 Pan Ho Employee Name Category Designation AJPPPE1 GON ARBPGSBS5 ALTPMOQS22 M AAHP Fade G AAPP 07L AJXFG1246A ARAP F042 D AADPSTSETD ATTPKOO11D AQUP hirESED AJBPGOO4 P BVCPSS466G AR GPMO422H AGFPJEG02D ALOP T3313 AABPGS652 0 AGAPASSSSA ABP SS P05 AJAY PRADHAN AMIT GUFTA ASHIM MATHUR BHAVNA FIFADRA BINAY UPADHYAY KAMLESH GUFTA KIRIT FIFADRA KISHORE SHAH HEETA KARERKAR RADHARAMAN MISHRA RAJESH GODHWANI SADAF SURTI SAMIF MUNDRI SHAMA JADHAW SHIJU JOHN SUMEET GUFTA SYED SHAHAB ALAM USHA SHAH G General G General G General W Female G General W Female 5 General G General Wt Female G General G General W Female G General W Female G General G General 6 General w Female EDITOR DIRECTOR EDITOR DIRECTOR EDITOR EDITOR DIRECTOR DIRECTOR EDITOR EDITOR EDITOR EDITOR EDITOR EDITOR EDITOR CEO EDITOR DIRECTOR TDSMAN User Manual Page 58 Certificate amp Report Printing 6 12 File Generation Log Purpose Every time a return is generated through the TDSMAN software an internal log is u
34. Mesters Regular Rohan Gormections Rehun Reports MSO information Utilities Ean ao amp a import Mose aa eee a Notes As per the new notification released by the TIN NSDL it is mandatory to make corrections using consolidated TDOS TCS statement omiy downloaded trom TIN website Click here to dovnload the tutorial on how to aot the TOS TCS File path a Mrogress TDSMAN User Manual Page 60 Preparation of Correction Returns Use the browse option to select the TDS file that needs to be imported and then click on the Import button 7 2 Make Corrections After data has been imported now you can proceed with making corrections In order to select Make Corrections click on Make Corrections option in Correction Return menu as shown below Figure 7 2 Make Corrections TDSMAN aaa AETR u ete Gi Regular Return Corrections Return Reports NSDL Information TRACES Information Utilities Exit Import Data for Correction Make Corrections Receipt No Master Shortcuts TDS MAN filing returns made easy Name KEJRIWAL Print Form 16A Serial No ab1234ijk Financial Year 2005 06 To 2015 16 Add Employee Version Date 05 Jan 2015 Developed by Helpline 91 33 22623535 64596006 Email info tdsman com PDS Infotech P Ltd 20 Old Court House Street and Floor Kolkata 700001 www tdsman com Make Correction can also be selected by clicking on C Meke corrections shortcut provided with
35. TDS MAN filing returns made easy USER MANUAL Document Version 8 1 Released on 01 February 2015 Disclaimer While PDS Infotech P Ltd makes every effort to deliver high quality products we do not guarantee that our products are free from defects Our software is provided as is and you use the software at your own risk We make no warranties as to performance merchantability fitness for a particular purpose or any other warranties whether expressed or implied No oral or written communication from or information provided by PDS Infotech P Ltd shall create a warranty Under no circumstances shall PDS Infotech P Ltd be liable for direct indirect special incidental or consequential damages resulting from the use misuse or inability to use this software even if PDS Infotech P Ltd has been advised of the possibility of such damages These exclusions and limitations will apply in all jurisdictions Information in this document is subject to change without notice No part of this manual may be reproduced stored in a retrieval system or transmitted in any form or any means electronic or mechanical including photocopying and recording for any purpose other than the licensee s personal use without the written permission of PDS Infotech P Ltd All trademarks used herein are properties of their respective owners Copyright PDS Infotech P Ltd All rights reserved PDS Infotech P Limited 20 Old Co
36. an only interest allocated amount and others allocated amount can be updated TDSMAN User Manual Page 64 Preparation of Correction Returns Delete a Challan In order to delete a challan select the challan you want to delete from the right panel with the help of the mouse After selecting the record click on Delete button then after seeking your reconfirmation the record will be deleted Original Challan that has been imported cannot be deleted You can only delete the new challans that have been entered during correction Correction in Deductee Details Select the Challan against which contains the particular Deductee record in which the correction has Deductee Detail to be done and click on button The following window will be displayed for correction in the deductee details Figure 7 7 Correction in deductee details TDSMAN Make Corrections ad Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit f X Correction Return Financial Year Form No Quarter Company PDS INFOTECH P T LTD Challan Sri No 4 Section 194C Deductee Details Challan No Date 0571272011 SINo Mode PAN No Deductee Name Amount Date Total Tax Deposited Srl No Bamana 1 AAAAT 7798M DEDUCTEE2 5000 00 19 11 2011 100 00 100 00 2 AIUPM5562B DEDUCTEE 1676 10 24 11 2011 17 00 17 00 Deductee Name PAN Code 01 Company is Date i DD MM SY YYY Amo
37. any details Total changes in existing Challan Total changes in Deductees of existing Challans Total No of PAN updates of Deductees Total No of New Challan Added Total No of Deductees added in New Challan Total Corrections Hy LULL Save Cancel Edit Refresh Delete In this Interface you will be able to see the data summary and also the count of the corrections that you have done in this particular batch TDSMAN User Manual Page 62 Preparation of Correction Returns Drove After making the corrections you have to return back to this page for generation of correction return file To make the Corrections click on piece ee ouecon button The following window will be displayed Correction In Company details Figure 7 5 Correction in Company Details TDSMAN Make Corrections oJ Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit tet RS Financial Year Form No Quarter Company PDS INFOTECH P T_ LTD Company Name PDS INFOTECH P T LTD Basic Information For Govt Deductors TAN No CALP081 43C PAN No AAECP6176D Branch Division SAT Ke PAO Code eductor e v yp ompany PAO Reg No Company Details Responsible Person Details DDO Code Fit Dr Bick N
38. ary Report Monthly PDS INFOTECH PRIVATE LIMITED TAN MUMDO6393CFA Year 2012 13 From APRIL To MARCH Deductee Transactions Monthly Summary PAN Party Employee Name Period section Amount Paid TDS Amount TDS Deposited ALCPGO 6 N ASLAM GADKARI May 12 194J 19600 00 1960 00 1960 00 Jun 12 194J 13650 00 1365 00 1365 00 Jul12 194J 13300 00 1330 00 1330 00 Total 46550 00 4655 00 4655 00 AAAFCS274C CHANDABHOY amp JASSOOBHOY Oct 12 194J 39305 00 3931 00 3931 00 Feb 13 194 25000 00 2500 00 2500 00 Total 64305 00 6431 00 6431 00 AAJPS9664H CHANDAN SAVLA Sep l2 194 FP 700 00 FP 70 00 FF 70 00 Oct 12 194 55500 00 5550 00 5550 00 Now 12 194 55500 00 5550 00 5550 00 Dec 12 194 55500 00 5550 00 5550 00 Total 244200 00 24420 00 24420 00 AFMPT9162K ISHAN THACKER Sep 12 194H 1000 00 100 00 100 00 Feb l3 194 25000 00 2500 00 2500 00 Total 106000 00 10600 00 10600 00 Grand Total 461055 00 46106 00 46106 00 Quarterly report Figure 6 7 Employee Party wise Summary Report Quarterly PDS INFOTECH PRIVATE LIMITED TAN MUMDO6393CFA Year 2012 13 From Quarter 1 To Quarter 4 Deductee Transactions Quarterly Summary PAN Party Employee Name Period Section Amount Paid TDS Amount TDS Deposited ALCPGO 63N ASLAM GADKARI Q1 194J 33250 00 3325 00 3325 00 Q2 194J 13300 00 1330 00 1330 00 Total 46550 00 4655 00 4655 00 AAAFCS274C CHANDABHOY amp JASSOOBHOY Q3 194J 39305 00 3931 00 3931 00 Q4 194 25000 00 2500 00 25
39. ated Challan Total Amount Provide the challan amount for which the report is to be generated TDSMAN User Manual Page 54 Form No 260 260 260 260 260 260 260 260 260 260 260 Certificate amp Report Printing Figure 6 18 Challan Query PDS INFOTECH PRIVATE LIMITED TAN MUMDOG3S93CFA Year 2012 132 Challan Query Report Date Sec BSR Code Challan Nos TDS Surcharge Interest Others Total Amount Remark 24G Rept T W No S0M4 2012 13941 0290179 932523 7100 00 0 00 0 00 0 00 7100 00 20 04 2012 1341 0230173 92545 14450 00 0 00 A 0 00 0 00 14450 00 04062012 134 0290176 91196 5960 00 0 00 i 0 00 0 00 5360 00 0446 2012 13941 02390173 91222 7100 00 0 00 A 0 00 0 00 7100 00 0406 2012 1341 0290179 91209 14450 00 0 00 i 0 00 0 00 14450 00 o4forf2012 1394 02901 73 90126 6365 00 0 00 i 0 00 0 00 6365 00 O42012 13941 0290179 30162 7100 00 0 00 A 0 00 0 00 7100 00 04072012 1341 0290179 90146 269 00 0 00 12 00 0 00 281 00 04072012 1341 0290179 90158 269 00 0 00 A 2 00 0 00 2FF 00 O4772012 13941 0290179 90134 14719 00 0 00 k 0 00 0 00 14719 00 12 01 2012 194J 0290179 92512 4000 00 0 00 0 00 0 00 4000 00 Total 1752 00 0 00 20 00 0 00 31302 00 Deductee Query Additional Filters Select Section No Select the Challan Section No for which the report is to be Amount Paid TDS Amount Rate generated Provide the Amount paid which the report is to be generated Provide the TDS Amount for which the report is to be
40. cess the employee details click on the Add Employee tab in Fig 4 7 Figure 4 7 Access Employee Master Scaled aa TOSMAN Return Gorrections Return Beporte NSDL Information TRACES Information Yulties Exit Shortcuts TDS MAN Sa i Add Company Add Deductee filing returns made easy Form No 740 Form No 260 Quarter wise Report Name 8S KEJRIWAL Serial No abil 2a4ijk Financial Year 2005 06 To 2015 16 O5 Jan 2015 Version Date Develoned by Helpline 91 33 22623535 64596006 Email info tdsman com PDS Infotech P Ltd 20 Old Court H use Street W tdsma nm com 2nd Floor Kolkata 700001 WW e gt The following window appears which displays the list of all the employees that have been defined in the TDSMAN database till now Currently the list is blank because we have not added any new employee to our master An Employee is created under one company The company has to be selected from the Company Name selection box to do any activity View Add modify related to that company TDSMAN User Manual Page 22 Masters Figure 4 8 Employee Master TDSMAN Employee Master Company Name PDS INFOTECH PRIVATE LIMITED CALP08143C a Employee PAN Employee Name Caa J E Add a new Employee To add a new employee click on the Add button on the bottom of the screen The following window appears for
41. d Click on OK button to print the report based on above selections Monthly Summary Figure 6 10 Summarized Deductions for a Company Monthly Report PDS INFOTECH PRIVATE LIMITED TAN MUMDO6393CF A Year 2012 13 Deductions Monthly Summary From APRIL 2012 To MARCH 2013 Period Form No Section Total Payments TDS Amount No Of Deductions No Of Deductees Apr 260 194 218191 00 21819 00 3 Apr 260 194J 40000 00 4000 00 2 May 26Q 194 213191 00 21819 00 3 May 260 194J 59600 00 5960 00 3 Jun 260 194 213191 00 21819 00 2 Jun 260 194J 63650 00 6365 00 4 Jul 260 194 213191 00 21819 00 2 Jul 260 194J 3300 00 330 00 6 Aug 260 194 213191 00 21819 00 2 Aug 260 194J 135000 00 13500 00 4 Sep 260 194H 113000 00 11800 00 2 Sep 260 194 22640000 22640 00 9 Sep 260 194J 60000 00 6000 00 3 Oct 260 194 135550 00 1556 00 5 Oct 260 194J 99305 00 9931 00 4 Now 260 194 135550 00 1556 00 5 Nov 260 194J 60000 00 6000 00 3 Dec 260 194C 45230 00 453 00 1 Dec 260 194 135550 00 1556 00 5 Dec 260 194 60000 00 6000 00 3 Jan 260 194J 50000 00 5000 00 1 Feb 260 194 50000 00 5000 00 2 TDSMAN User Manual Page 48 Quarterly Summary Certificate amp Report Printing Figure 6 11 Summarized Deductions for a Company Quarterly Report From Quarter 1 To Quarter 4 Period Form No Q1 260 01 260 Q2 260 Q2 260 Q2 260 Qs 260 Qs 260 Os 260 Q4 260 Q4 260 Section 194l 194J 194H 194 194J 194C 194 194J 194
42. ding and preparing the correction statements conveniently It also helps the users in requesting theTDS certificates Form 16A for Form 26Q 27Q non salary deductee and Salary certificate Form 16 from the TRACES website 3 1 Description of the different TDS TCS Forms The Income Tax Department Govt of India has defined four different types of TDS TCS Forms Depending upon your requirement select a particular form under which the return has to be filed All these four forms are explained below Form 24Q For filing the returns of salaried employees Form 24Q has to be selected In this form the deductions made are under section 192A Payment done to government employees section 192B payment done to non government employees or section 192C payment done to union government employees Form 26Q For filing of returns of the deductees other than employees residing under domestic territory Form 26Q has to be selected This includes payment of contractors professionals rent interests commission etc Form 27Q For filing of returns of deductees other than employees residing outside the domestic territory Form 27Q has to be selected Form 27EQ For filing TCS returns Form 27EQ has to be selected 3 2 Key Functions of TDSMAN Process Overview 3 2 1 Processing of Returns This is the process by which the company deductor provides the details of the TDS TCS to the Income Tax department of India Figure 3 1 Processing of
43. dit Enables you to modify a record This is to be clicked after selecting a record for modification purposes Search Enables you search records using the search parameter s All records will be filtered and only searched records will be displayed Refresh Enables you to restore the full list of records Delete Enables you to delete a record This button is to be clicked after selecting a record for deletion purposes Exit Enables you to shift the control to the main screen of the software TDSMAN User Manual Page 15 4 Masters 4 1 Company Deductor Master In Company master the detail of all the companies deductors for which the return has to be prepared is created In order to access the company details click on the Add Company tab in Fig 4 1 Figure 4 1 Access Company Master a TOSMAN EEA Masters Regular Return Gorrections Return Beporte NSDL information TRACES information yuities Eit Shorncuts Add Company E jisi L a m E Add Deductee L Form No 24Q filing returns made easy Form No 260 Quarter wise Report Name S amp S KEJRIWAL Serial No abl 23a4ijk Financial Year 2005 06 To 2015 16 O5 Jan 2015 Version Date Developed by Helpline 91 33 22623535 64596006 Email infog tdsman com PDS Infotech P Ltd 20 Old Court House Street ice 2nd Floor Kolkata 700001 VATA AYA A sman com The following window which displays the list of all
44. ductions under section 16 ALNPP8316G LAKHAN LAL PUROHIT 12974 00 a Entertainment Allowance 16ii 0 00 APLPS6466M MAHESH CHANDRA SHAH 54357 00 b Tax on Employment 16ii Oc AOMPSO551P PAWAN KUMAR SHAH 43796 00 Aggregate of a amp hi AVMPS1938C RAMESH CHANDRA SHAH 56337 00 447PR6100L RAJESH RATHODD 7091 00 Income chargeable under the head Salaries i L AJOPS7195E RAKESH SHAH 42649 00 Any other Income other than Salary I i BENPR4279M SURAJ KUMAR ROY 73 00 Gross Total Income AUYPB5247D SANJAY RANG RAO BIRAMWAR 12422 00 Deductions under Chapter YLA AGHPS8253R SAGAR SEN 13155 00 ee eee eee AYKPS5146G TUSHAR SHAH 3959 00 Total Deductible Amount S0CCF AWTPS5295E SIDDARTHA SHAH 43795 00 Total Deductible Amount Other Sections p BMKPSFES7J SANJAY SINGH 6245 00 Aggregate of deductible amount under i ALHPM9674R R P MAITRA 3090 00 Chapter I A JP i Total Taxable Income Tax on Total Income Surcharge Add Salary details In this section we concentrate on entering salary details for each employee TDSMAN software provides you the option to select either Enter Mandatory Fields Only or Enter Form 16 Details By default the system selects the option Enter Mandatory Fields Only Enter Mandatory Fields only Enter Form 16 Details Enter Mandatory Fields Only On selecting this option you will
45. e Cancel Search Delete Retrest tat The brief description of the fields is shown below Deductee Code mandatory It has to be either 01 or 02 If deductee type is Company select 01 else if deductee type is non company select 02 TDSMAN User Manual Page 20 Masters PAN mandatory Enter the PAN of the deductee Incase the deductee is not having PAN then PANNOTAVBL has to be entered Deductee Name mandatory Enter the name of the deductee Address Enter the address State Enter the state of the deductee PIN Enter the PIN of the deductee Mobile Enter the mobile no E mail Enter the e mail address vere Address Mobile and Email of the deductee is not submitted in the TDS return This is required only to print the TDS Certificate through the software Modify a Deductee Refer to Section 3 3 Getting familiarized with the Action Buttons of TDSMAN Remove a Deductee Refer to Section 3 3 Getting familiarized with the Action Buttons of TDSMAN Drove A deductee cannot be deleted if it has been used in the any return TDSMAN User Manual Page 21 Masters 4 3 Employee Master In Employee master the details of the employees are created Once the employee is available in the master then the same will be available in the help window of the transaction screen of Form 24Q Deore Whenever a user enters a new deductee in transaction module its master gets automatically created In order to ac
46. e PAN has to be modified it has to be a valid PAN For example while preparing for regular returns the system allows us to modify PAN to PANNOTAVBL PANINVALID and PANAPPLIED however the same in not possible while making corrections Delete Deductee In order to delete a deductee select the deductee you need to delete from the right panel with the help of the mouse After selecting the record click on Delete button then after seeking your reconfirmation the record will be deleted Original deductees that have been imported cannot be deleted You can only delete the new deductees that have been entered during correction In case one wish to clear the record of existing deductee then one has to modify all the amount values to zero TDSMAN User Manual Page 66 Preparation of Correction Returns Correction in Salary Details Corrections in salary detail as entered in Quarter 4 of Form 24Q can be done by clicking on Salary Detail on the company details screen The following window will be displayed for correction in the Salary details Figure 7 8 Correction in Salary Details at Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit M x Form 24Q Salary Details Financial Year Quarter Company PDS INFOTECH P T LTD Sri No Name Srl Total PAN 328 Category 330 General v No Mode PAN Name padua Total Salary 0 00 2 AMLPSOOS6K GHANSHYAM DAS SHAH 63366 00 De
47. elect the TDS file and click on the button impon After checking and verifying relevant details the data will be transferred into TDSMAN TDSMAN User Manual Page 74 9 Other Utilities 9 1 Backup and Restore Through this utility you can backup your data and also restore the same back as and when required In Utilities Menu select on Backup Restore and further click on Backup This will take you to the following interface Figure 9 1 Backup TDSMAN Backup a Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit Date 20 04 2012 DD MM YYYY Time 15 36 46 1875000 hh mm ss Output Folder C Program Files TDSMAN FY 2012 13 File Name TOSMAN 20120420 153646 MDB Notes filing of 260 Quarter done for Pds Infotech Privete Limited of Financial Year 2012 13 Select the Output folder where you want your backup to be created and specify some textual note which will serve as a reference for the backup Click on Backup button to create the backup file in the specified folder For restoration of backed up data click on Restore It will take you to following interface TDSMAN User Manual Page 75 Other Utilities Figure 9 2 Restore Restore Restore from Archive Restore from Specified Location p File Name Date Time Notes 1 E TOSMAN 2012041 7 175125 MDB 20 04 2012 17 51 25 4843750 filing of 260 Quarter done for Pds Infotech Privete Li
48. eports NSDL Information Utilities Exit Form 24Q Meee Cdr Salay Details Z O Z S S S S SSS Details Financial Year Quarter Company PDS INFOTECH PRIVATE LIMITED Srl No 1 Name 329 PAN 328 Salary Details Category 330 General From Date 01 04 2012 To Date 31 03 2013 Enter Mandatory Fields only Enter Form 16 Details Total Salary 3 Balance 1 2 4 Deductions under section 16 a Entertainment Allowance 16ii b Tax on Employment 1 6iii TDSMAN User Manual Page 32 Regular Returns In this section we concentrate on entering salary details for each employee TDSMAN software provides you the option to select either Enter Mandatory Fields Only or Enter Form 16 Details By default the system selects the option Enter Mandatory Fields Only Enter Mandatory Fields only Enter Form 16 Details One can select either of the two options based on the following Enter Mandatory Fields Only On selecting this option you will need to enter only those data required for preparing the TDS return Enter Form 16 Details On selecting this option you will need to enter all information that will help in generating the Form 16 Salary Certificate as well as in preparation of TDS returns The above screen is divided into three sections The left panel is the area where data ha
49. erface where you can view the default folder in which TDSMAN software is to be installed or you select a different destination folder where you want to install the software TDSMAN User Manual Page 6 Software Installation amp Registration Figure 2 2 Software Installation Step 2 qe TOSMAN Select Installation Folder TDS MIAN Filing returns made rasy The installer will install TO SMARN to the Following folder To imstall in this folder click West To install to a different folder enter it below or click Browse Folder C Program Files TOSMALNS TOS MANS Browse Disk Cost Cancel lt Back Use the Browse button in case you desire to change the installation folder Before installing if so desired click on Disk Cost button to get information of the availability of the disk space on your system After you have selected the destination folder click on the next button to get the following interface Figure 2 3 Software Installation Step 3 fa TDSMAN Confirm Installation TDS MAN Filing returns made e Asy The installer ie ready to install TO SMAN on your computer Click Mest to start the installation Cancel lt Back Click on the Next button to confirm and start the installation procedure On completion of this you will get the following interface TDSMAN User Manual Page 7 Software Installation amp Registration Figure 2 4 Software Installatio
50. f all the deductions made for Parties Employees for the any specific period for a particular form or across different forms for a given financial year As per the requirement the user has to provide the specific criteria on the basis of which the report will be generated Run Time Selection Criteria From Date Enter the date from which the summary of the deductees have to be generated To Date Enter the date till which the summary of the deductees have to be generated Deductor Company Select the Deductor Company for which the report has to be generated Party Employee Select either Party or Employee If Party is selected then you have to ret C 27a select either one or multiple forms mos However if employee is selected then Form 24Q will be selected Summary Type Monthly Quarterly annual Summary Type Select the summary type from the given options If Monthly Summary or Quarterly summary is selected then additionally the month range or quarter range has to be selected On providing the above details all the deductees present for the given criteria will get listed Peductee List JINTSHA SHAH JIVAN SILK MILLS KARISHMA GUPTA POOJA GUPTA PRAKASH K SHAH F Select Deselect ALL Search Select the deductees for which the report has to be generated TDSMAN User Manual Page 44 Certificate amp Report Printing Monthly Summary Figure 6 6 Employee Party wise Summ
51. fel Ee Financial Year Form No Quarter Company PDS INFOTECH PYT LTD Changes Section aes v rp Mode Section T iniit Tax sera Difference in D eductee Matched 194H 14428 05 11 2011 214 00 214 00 0 00 Matched 194H 15737 07 11 2011 85 00 86 00 0 00 Matched 194C 15515 07 11 2011 22 00 22 00 0 00 Matched 194C 16535 05 12 2011 117 00 117 00 0 00 Cheque No Matched 194C 16420 05 01 2012 29 00 29 00 0 00 TDS Date of Payment 20 04 2012 BSR Code Challan No Surcharge Education Cess Interest Others Total The above screen is divided into three sections i The left panel is the area where data has been entered li The right panel displays all the records iii The bottom part has the self labeled action buttons Add a Challan To add a challan enter the details in the left panel The brief description of all the fields has been explained in Regular returns section After entering click on the Save button to record the new challan in the return Modify a Challan In order to modify a challan select the challan you need to modify from the right panel with the help of the mouse Either double click on this entry or click on the Edit button The selected entry will be displayed on the left panel which can now be modified and saved again Doce For matched challan provisionally matched challan amp over booked chall
52. has already been submitted can be corrected using the Correction Returns module In Correction Return you can modify add or delete existing information as per rules and limitations as specified by the Income Tax Department There are three broad steps required for the preparing a Correction Return They are as following i Import of data for correction ii Make corrections iii Generate Correction Returns for submission We shall discuss in details about all the steps mentioned above over the subsequent sections 7 1 Import data for Correction For making the Correction Return you have to import the file of the last accepted return for the relevant Deductor Form type Financial Year amp Quarter This TDS file can be downloaded from TRACES website after registering your TAN in their website The URL for the same is www tdscpc gov in It will have all the details of the latest return that has been uploaded by you This TDS file will always show your last accepted statement at the Income Tax Department For the Import of data for the correction Return you will have to go to the Corrections Menu and A Corrections Return Reports NSDI Import Data for Correction Make Corrections Receipt No Master select Import Data for Correction The following screenshot shows the interface for the Import of the file for making correction statement Figure 7 1 Import Data for Correction a IDSMAN import Data ud
53. in the list of short cut buttons Ref to fig 7 2 The following window appears which assists you in preparing the file for making correction Figure 7 3 Batches of Data Import TDSMAN User Manual Page 61 Preparation of Correction Returns TDSMAN Make Corrections a Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit jel is Select Batch for Correction FA Year Form No Otr Company Name Imported date amp Time Total Corrections Q3 PDS INFOTECH PVT LTD CALPos143c 20 04 2012 3 4 PM Here you will be able see the all the TDS files that you have made for preparing correction returns Every import is a separate batch and you will be able to differentiate all by looking at the summary of that batch shown in the grid along with the date and time at which the file was imported Use your mouse to select a batch and either double click on the batch or click on Select button to enter into the Batch for making corrections Once you enter the batch the following window appears Figure 7 4 Data Summary TDSMAN Make Corrections a Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit fel obs Financial Year Form No Quarter Company PDS INFOTECH P T_ LTD Import Summary File Downloaded on File Imported on Total Challan Records I Total No of Deductions Total Challan Amount Total TDS Deducted Correction Summary Changes in Comp
54. ion Process Step 1 Offline Registration Process DS MAN filing returns made easy es TOSMAN Registration es Step l of 2 Enter Activation code For cine regictration visit the following URL or call POS Infotech at 91 33 22623535 64596006 Fiesse mote while Registering you meed the Serial Mo provided along with software are system id as displayed below System ID 29 4 DF4A4 E566 63D4 201 1 Aattivwaliom Code The identification of your computer system is displayed in the System ld field You will need to get the Activation Code either through our website as per the web address mentioned on the interface by filling up a web form with the requisite details or by calling over our Helpdesk While entering the web form for offline registration you will need the Serial No provided along with the software package and the System ID displayed in the above screen while filling the web form After successful verification the Activation Code will be made available which needs to be entered in the form above Click on Next button to proceed If the Activation Code is correctly keyed in following interface will be displayed Figure 2 10 Offline Registration Process Step 2 TDSMAN User Manual Page 11 Software Installation amp Registration f TOSMAN Registration m Offline Registration Process i DS M AN filing returns made easy Step 2 of 2 Eoter Licensee details Pro
55. ion Return for Submission After all corrections have been done you are all set to generate your Correction Return Click on the Generate Return and the following interface appears on the right panel Figure 7 9 Generate Correction Returns TDS filing involwes following steps 1 Generation of text file 2 Creation of FW file using the text file 3 Ponting of Fomm 27 7AL Step 1 TDS TCS Input Ale Name with Path Step 2 and 3 E CSI file download Optional Intemet required TDS TCS Output folder C Program Files TDSMAN TDSMAN FVU Files There are 3 steps involved in the Generation of the correction returns i Generate the text file ii Cross Verification of the challans lil Validation of the file generated using utility provided by IT department Generate the text file In the first step you will have to generate the text file This text file is used as an input file for the validation by the utility provided by Income Tax Department Cross Verification of the challans TDSMAN User Manual Page 68 Preparation of Correction Returns In second step you can check uncheck Automatic CSI file download link for which Internet connection is prerequisite This will download a file from the NSDL s website which will have the Challan details as per IT records provided by the Bank PAO for cross verification Validation of the file generated using utility provided by IT department Third step involves
56. is clicked upon and confirmed subsequently After the import is completed you can go to the respective Form where the data was imported and you are ready to generate the file for return submission 8 2 Import from TDS File When you import the data from the TDS file all the challan and deductee data from this file is transferred into the database of the software including automatic creation of the Deductee amp Employee master data TDSMAN User Manual Page 73 Import of External Data For Importing of data from TDS file go to the Regular Return Menu and select Import from TDS File Regular Return Corrections Return Reports NSDL Infi Form 240 Form 260 Form 270 Form 27EQ a Import from Excel gt a eee which will transfer you to the following consolidated statement interface Figure 8 4 Selection for Importing Data mi TDSMAN Import from Consolidated Statement Beles g Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit ee X Consolidated Statement Import Select Select Financial Year 2011 12 v Select Quarter Q3 v Select Form No 260 v Select Company PDS INFOTECH PRIVATE LIMITED CALP08143C v Select TDS file TDS file path C CALP08143C_201112_26Q_Q3 tds P Progress Coo Select the Financial Year Quarter Form No and Company Name for which the data needs to be imported Browse and s
57. lidation of the file generated using utility provided by IT department Third step involves validating the text file generated in Step 1 and generating the FVU file for submission While validating the Challan details entered in the returns and Challan Detail as uploaded by Bank will be cross verified In case automatic CSI file is unchecked then the path of this file should be manually provided TDSMAN User Manual Page 35 Regular Returns On validation the status in terms of successful unsuccessful validation will be displayed and one can also view the report for subsequent action After the return has been generated and validated the return has to be submitted to TIN FC or it can also be uploaded as per the rules in NSDL s website Steps for preparation for submission of the return are explained as under Click on open output folder and copy the file having extension fvu Print Form 27A by clicking on button Print Form 27A which will also be required for submission of return along with the fvu file in Floppy CD Pen drive 5 4 Entering the Receipt Number of the Return After the return is submitted to TIN FC or uploaded online you will receive an acknowledgement document The details of this acknowledgement receipt can be entered into the software using Receipt No option present in the Master Once you click on the Receipt Number you will get the following interface Figure 5 11 Enter Receipt Number
58. m the help screen to populate the details in the required fields Moreover when a new deductee record is entered its master will automatically get created when the record is saved TDSMAN User Manual Page 31 Regular Returns Modify a Deductee In order to modify a deductee select the deductee you need to modify from the right panel with the help of the mouse Either double click on this entry or click on the Edit button The selected entry will be displayed on the left panel which can now be modified and saved again When a deductee details is shown in modify mode you will be able to see an additional fields viz Deducted Date By default the date entered in payment date field is copied to deducted date field as well The default values can be changed in this modify mode Delete a Deductee In order to delete a deductee select the deductee you need to delete from the right panel with the help of the mouse After selecting the record click on Delete button then after seeking your reconfirmation the record will be deleted In case Form 24Q salary return is selected then salary details have to be entered also Add Salary details Drove Salary detail has to be entered in the 4 Quarter To enter the salary detail click on the Salary detail button on the Home Screen You will be transferred to an interface displayed as below Figure 5 8 Add Salary a Masters Regular Return Corrections Return R
59. mieia pres abae bs bas Comet end ores end is based on fe books of ecoount documest TOS saene Tid depasiied and TDSMAN User Manual Page 42 Certificate amp Report Printing 6 3 Party Employee wise Detailed Purpose This report provides the details of all the deductions made for Parties Employees for the any specific period for a particular Form or across different Forms for a given financial year As per the requirement the user has to provide the specific criteria on the basis of which the report will be generated Run Time Selection Criteria From Date Enter the date from which the details of the deductees have to be generated To Date Enter the date till which the details of the deductees have to be generated Deductor Company Select the Deductor Company for which the report has to be generated Party Employee Select either Party or Employee If Party is selected then you have to C 27a C 27EQ select either one or multiple forms However if Employee is selected then Form 24Q will be selected On providing the above details all the deductees present for the given criteria will get listed Peductee List F JINISHA SHAH BOePSS747N F JIVAN SILK MILLS AAAFJSI SK F KARISHMA GUPTA AHUPGSRJJ F Poda GUPTA AERPJSSESA E PRAKASH K SHAH AGIPS2727R F Select Deselect ALL Search Select the deductees for which the report has to be generated Figure 6 5 Detailed Report on Deduc
60. n Step 4 fe TOSMAN Installation Complete Filing returns made easy TOSMARNM has been successfully installed Chek Close to exit Please use Windows Update to check for any critical updates to the MET Framework Click on Close button to exit the installation Click on the software icon created on the Desktop to launch the software The software needs to be registered with PDS Infotech P Ltd before one can start using the same For TDSMAN registration you will get the following interface Registration of the software can be done on the following ways Online internet connection required Offline The procedure of each is explained below TDSMAN User Manual Page 8 Software Installation amp Registration ONLINE REGISTRATION Select Online on the above interface and click on Next button The following interface is displayed Figure 2 5 Registration Process TOSMAN Registration Welcome to TOSMAN Registration The software needs to be registered before it can be weed filing returns made easy Select the process for regizhration from the following options then click Next gt Ofline NOTE Online is an auwlomatic Registration process Offline process can be done either over phone or through internet aos Enter the Serial Number provided to you along with the software package and then click Next to proceed Figure 2 6 Online Registration Process Step
61. name the software will provide a help screen having list of deductees matching with the value entered in the field One can select the deductee from the help screen to populate the details in the required fields Moreover when a new deductee record is entered its master will automatically get created when the record is saved Tax Calculation Help The software will provide the value of tax that should have been deducted based on Taxable Income value provided One can also click on View Calculation to check the exact details of the calculation Total TDS deducted Help The software will provide the value of total deduction done for that deductee in the relevant financial year by taking data from all the 4 quarters Modify a Salary record In order to modify a salary record select the record you need to modify from the right panel with the help of the mouse Either double click on this entry or click on the Edit button The selected entry will be displayed on the left panel which can now be modified and saved again Delete a Salary record In order to delete a salary record select the record you need to delete from the right panel with the help of the mouse After selecting the record click on Delete button then after seeking your reconfirmation the record will be deleted 5 3 Generation of Return After the Challan amp Deductee details and also Salary Details in Form 24Q Q4 have been entered you are all set to
62. ncwoaseeuscuesuesueyes vensuecnysaceuseseuseteseetesosespensyers 25 5 1 Selection of Parameters for filing the Returns ccscccccsseccecessecceeecceeeeeeeceeseecesseneeeeeees 26 5 2 Chalan and Deductee ENUY peer eee een enn red nena nen eo eee oe eee 28 5 3 Generation OF RETU eneit En EE puatinsncegrniaeautinedennsieaenueiaaiensinns 34 5 4 Entering the Receipt Number of the Return cccccssccccssececeeecceeeesseceeseeceeeeeceeseuseceeeneces 36 Certificate amp Report Printing sesessesessecessscoessscessscesssoecosoesssoesssoesssoesssoessssesssososssesssoesssseo 38 6 1 Quarter Wise Reports c ccccseccseccseeceeeceeeceseceseecseccecseeesescesccesecessceuscesssesseeseceseeesesaesseeses 38 6 2 CENERE PANU a E E E E E A 41 6 3 Party Employee wise Detailed oo cccccccssssseceeceeececcesseceseeeeeeueeeesseeeeeeeeeeeseeeeeeeeeaugees 43 6 4 Party Employee wise SUMMAry sxccscsexsdsxavvatadacntesanwanessdsvacaeuadevaceaarncesaagunsasesagauvanesranenbueebenses 44 6 5 CAN REDON araa E E eee 47 6 6 Summary Report DEGUCIIONS seesirreieen a 48 6 7 Summary Repon BI 0 0c 0 rennet ee nearer eee E AEE ee eee 50 6 8 Correction Statement sssssesssssssseesseesesrosrcessseosssresscosseosesrosecesseressroesseosserssseosseoseresseessees 51 TDSMAN User Manual Page 2 6 9 COSC OU LOD va evrestonane ean pesarseoneasnspnceectaatesdesianesncbaaineucus unio ued tukevedavinrssohasnacancsiibersedenetrmvensociat 53
63. o 20 Fit Dr Bick No 20 Al DDO Reg No Building OLD COURT HOUSE STREET Building OLD COURT HOUSE STREET ane ate Rd Sttt Lane KOLKATA Rd Strtt Lane KOLKATA Select Ministry Area Locality COOKE amp KELVE Y BUILDING Area Locality COOKE amp KELYEY BUILDING Town District Town District Other Ministry State WEST BENGAL PIN 700001 State WEST BENGAL PIN 700001 STD 33 Phone 22623535 STD 33 Phone 22623535 Provisional Receipt Number E mail info pdsinfotech com E mail Original PRN No Responsible Person Address Change since last return 050420300237871 Name RAMESH GUPTA C Company Ulett il bie Designation DIRECTOR C Responsible Person 050420300237871 Mobile No 9820086326 LC Prepare Cancelation Statement Cancel Edit Search Refresh Delete Challan amp Deductee Details Back to Basic Screen If required you can modify the company details over here and click on the button to save the same CD wore TAN of the company Financial Year Form No amp Quarter cannot be modified for the return To make any correction in the Challan or Deductee Details click on Challan amp Deductee Details button The following window will be displayed for correction in challan data TDSMAN User Manual Page 63 Preparation of Correction Returns Correction in Challans Figure 7 6 Correction in Challans TDSMAN Make Corrections aJ Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit
64. of Parameters for filing the Returns li Challan and Deductee Entry lil Generation of Returns We shall discuss in details about all the steps mentioned above over the subsequent sections As Form 26Q is most popularly used the same is being used to explain the operational procedure In order to select Form 26Q click on Form 26Q option in Regular Return menu as shown below Fig 5 1 Figure 5 1 Access Form 26Q on beers 4 y TDSMAN i Reports SDL Information TRACES Information Utilities Exit Form 270 Form 27EQ Import from Excel Import from TDS File Consolidated Statement TDS MAN filing returns made easy Name KEJRIWAL Serial No gt abl234ijk Financial Year 2005 06 To 2015 16 Version Date 05 Jan 2015 Developed by Helpline 91 33 22623535 64596006 Email info tdsman com PDS Infotech P Ltd 20 Old Court House Street VV AVVAYY td S m a n CO m 2nd Floor Kolkata 700001 TDSMAN User Manual Page 25 Regular Returns Form 26Q can also be selected by clicking on shortcut button provided in the list of shortcuts Ref to fig 5 1 5 1 Selection of Parameters for filing the Returns The following screen appears after the selection of Form 24Q Figure 5 2 Parameter for Filing Returns TDSMAN Form 26Q ad Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit al es Form 26Q Domestic
65. of the responsible person is displayed Last Token Number It is mandatory to enter the token number of last regular return submitted for this form Control Summary It shows the summary of the records saved in this return It shows information such as no of challans saved No of Deductee records saved total amount shown in deductee details total tax deduction shown in deductee details Return Filing Status It displays the receipt no and other details mentioned in the acknowledgement copy provided the user has entered the information in the Receipt Master of the return filed TDSMAN User Manual Page 27 Regular Returns 5 2 Challan and Deductee Entry For all the TDS Deductions of the deductees made by the company deductor challans are submitted These challan and deductee details form the building blocks for the preparation of the return and are entered over here Adding a Challan Click on the Challan and Deductee Entry button provided at in above screen refer to fig 5 3 On clicking this button the following screen will be displayed Figure 5 4 Challan Screen TDSMAN Form 26Q ad Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit amp x Form 26Q Domestic Challan Details Sl Section Challan No Deposit Dt BSR Code Tax Deductee Total Difference Srl No 401 Section 402 B v Date of Payment 411 20 04 2012 DDIM YYYY BSR Code 410 Challan No 4
66. pdated This report provides the option to print the internal log of all the file generations done through this software for the selected company Run Time Selection Criteria FA Year Select the Financial year for which the report is to be generated Select Forms Select one or multiple forms across which the report is to be generated Select Qtr Select one or multiple quarters across which the report is to be generated On providing the above details all the companies present for the given criteria will get listed Company PAN Company Name Company TAN AAACDS4498 PDS INFOTECH PRIVATE LIMITED MUMDO6393C Select Deselect All Search Select the company for which the report has to be generated and press OK button to print the report Figure 6 24 File Generation Log File Generation Log Pun Date 1802013 FA Year 2012 13 Company Mame Form amp GTR Mo Ot No of Date amp Time chalan Deductees POS INFOTECH PRIVATE LIMITED 260 01 11 17 16a 01 81223 AM POS INFOTECH PRIVATE LIMITED 240 01 1 2 Teer ole 240041 PM POS INFOTECH PRIVATE LIMITED 240 08 3 Ar JAGT 2AA PM POS INFOTECH PRIVATE LIMITED 240 01 1 2 120172013 2 30 58 PM POS INFOTECH PRIVATE LIMITED 240 2 6 12012013 2 24 01 PM POS INFOTECH PRIVATE LIMITED 240 2 6 Tear egl 2 14 49 PM POS INFOTECH PRIVATE LIMITED 240 1 1 2 120012012 1 56 35 PM TDSMAN User Manual Page 59 7 Preparation of Correction Returns The regular return for any Form type that
67. pe of the company from the dropdown list provided Fit Dr Blck No mandatory Enter the Fit Dr Block No Building Enter the building name Rd Strt Lane Enter the name of the road street lane Area Locality Enter the name of the area locality Town District Enter the name of the town district PIN mandatory Enter the Address PIN Enter the name of the state Enter the STD code of the company State mandatory STD mandatory TDSMAN User Manual Page 17 Phone mandatory E mail mandatory Govt Deductors PAO Code mandatory PAO Reg No DDO Code mandatory DDO Reg No State Ministry mandatory Responsible Person details Name mandatory Designation mandatory Father s Name Mobile No mandatory Fit Dr BIck No mandatory Building Rd Strt Lane Area Locality Town District PIN mandatory State mandatory STD mandatory Phone mandatory E mail mandatory Masters Enter the phone no of the company Enter the E mail address of the company Enter the PAO code Enter the PAO Registration No Enter DDO Code Enter the DDO Registration No Enter the ministry state Applicable for State Government Deductors In the ministry options if Other is selected then enter other ministry Enter the name of the responsible person Enter the designation of the responsible person Enter the father s name of the person concerned Enter the mobile no of the person concerned Enter the F
68. query provides advanced filtering functions to extract specific information as per requirement from TDS TCS returns throughout the financial year for a particular deductor For example throughout the year one can extract all payments under section 194J greater than Rs 1 00 000 Run Time Selection Criteria Company TAN Select the company for which the report is to be generated FA Year Select the Financial year for which the report is to be generated Challan Type Select the type of the challan to filter out particular type of Challan Select Forms Select one or multiple forms across which the report is to be generated Select Qtrs Select one or multiple quarters across which the report is to be generated On providing the above details all the challan sections present for the given criteria will get listed Description Section No Section Description Ba O Parmeria made to anglaras aiher han Gont omnes 194A Interest other than interest on securities 194C Contractors Sub Contractors 194H Commission amp Brokerage 1941 Rent 194J Professional amp Technical Services Select Deselect All Search Select the sections for which the report has to be generated As mentioned above this query provides additional filtration criteria depending on whether it is Challan query or Deductee query Both are explained below Challan Query Additional Filters BSR Code Select the BSR Code for which the report is to be gener
69. report is to be generated Figure 6 13 Summarized Report on Deductors Company Name PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED PDS INFOTECH PRIVATE LIMITED All Deductors Summary FA Year 2012 13 Form No 240 240 240 240 260 260 260 260 27EQ 27 EQ 27EQ 27EQ 27Q 27Q 270 27O Qtr Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q Q4 q1 q2 Q Q4 Total Challan Total Total Deductees Deductions 2 2 9 5 6 1 3 1 1 1 1 5 6 2 TDSMAN User Manual Page 50 6 8 Correction Statement Purpose Certificate amp Report Printing The report provides the complete set of instructions that is required to correct the return which was submitted earlier Run Time Selection Criteria Select Correction Batch Select the correction batch for which the report needs to be generated The correction batches can be differentiated by looking at the information against each batch Click on OK button to print the report based on above selection From 04 04 2012 To 3006 2012 1 Particulars of Deduc
70. s of the criteria provided Select Type gives the user the option of generating three different sections of this return The different section are a Company Info b Challan c Deductee Employee Print all the sections of the report to view the complete details of the return submitted Each section is explained below TDSMAN User Manual Page 38 a Company info Certificate amp Report Printing This report provides the details of the company entered in the return It also provides the summarized information of the challans and deductees submitted Figure 6 1 Report on Company Information From CDS 12 To SOS 2 4 Partoulars of Deductor ei HETE bh hiies Fei Door Elod Ha Hame of Premises Eesiiding Rinad Sieti Lane Ames Leii Hie Pin Code SIE zii c Tex Dein Account Number TAR if Pemer Accoued Humbe FAH Ei Deducir Type ff Has Adies dged 7 2 Partculars of Responsable Person fa Harme fh Address Fei Doo Bock Kio Hame of Premises Bulking Taani i Disc ay Preto cage Mobile eal fc Fabers Hame iW eimir fep Has Addeess changed 7 2 Bummary PHa of aen 11 ib Total Amat ETEL 4 Filing Detaits ia Remi Ho HFOTECH PRIVATE LIMITED TAN MUMEOEGGSC FA Yem 242 POS NAOTECH PAMWATE UMITED COOKE KELVEY BUILDING OLD COURT HOLGE STREET HOLKATA WEET BENGAL 032 Phone 255 K Company Phone 232515 ic
71. s to be entered The right panel displays records as you keep on entering The bottom part has the self labeled action buttons Enter the details on the left panel as per the field description After providing the details of each record click on the Save button The saved entry will be displayed on the right panel As you make more entries the records get displayed on the right panel An illustrative screen is displayed as below Figure 5 9 Salary Details aJ Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit amp x Form 24Q Salary Details Financial Year Quarter Company PDS INFOTECH PRIVATE LIMITED Srl No 2 Name 329 PAN 328 S Salary Details Category 330 General v From Date 01 04 2012 To Date 31 03 2013 a Name Total Deducted a JOHN DUKE Enter Mandatory Fields only Enter Form 16 Details Total Salary 1 Gross Salary a Sec 17 1 0 00 b Sec 17 2 0 00 c Sec 17 3 0 00 d Total 2 Less Allowance under section 10 Description 3 Balance 1 2 4 Deductions under section 16 a Entertainment Allowance 16ii b Tax on Employment 1 6iii CD wore The sequencing of the fields is as per the Form 16 format provided by IT dept TDSMAN User Manual Page 33 Regular Returns Employee Master Help While entering the deductee
72. the companies that have been defined in the TDSMAN database till now appears Currently the grid is blank because we have not added any company Figure 4 2 Company Master a TDSMAN ompany Master a e gt lt oad Masters RegularReturn Corrections Return Reports NSDL information Utilities Exit 7 x Company Master Deductor f Collector Deduecbor Employer Collector Name Deductor Type Save Ganoal TDSMAN User Manual Page 16 Masters Add a new Company Deductor To define a new company click on the Add tab at the bottom of the screen The following window appears which assists you in defining a new company Figure 4 3 Company Master Details as TDSMAN Company Master aJ Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit P X Company Master Deductor Collector Basic Information State STD E mail Name Designation Father s Name Company Name PDS INFOTECH PRIVATE LIMITED WEST BENGAL v 033 Phone 22623535 info pdsinfotech com Responsible Person RAMESH GUPTA DIRECTOR PIYUSH GUPTA PIN State STD E mail 700001 WEST BENGAL 033 Phone 22623535 info pdsinfotech com For Govt Deductors TAN No CALPO8143C PAN No AAECP6176
73. ties Exit meor tee e Shortcuts Add Company m oo Lo fa m m E a Add Deductee Ea Form No 24Q filing returns made easy m 5 Form No 260 Quarter wise Report Name 8S KEJRIWAL Serial No abl 2a4ijk Financial Year 2005 06 To 2015 16 05 Jan 2015 Version Date Developed by Helpline 91 33 22623535 64596006 Email infogtdsman com PDS Infotech P Ltd 20 Old Court House Street VVAVAVAV VA tdsma n com 2nd Floor Kolkata 700001 m m The following window appears which displays the list of all the deductees that have been defined in the TDSMAN software till now Currently the grid is blank because we have not entered any details yet Figure 4 5 Deductee Master TDSMAN User Manual Page 19 Masters ge TOSMAN Deductee Master uJ Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit Ada _ Save Cancel Search Dolte Refresh Em Add a new Deductee To add a new deductee click on the Add button on the bottom of the screen The following window appears which assists you in adding a new deductee Figure 4 6 Deductee Master Details x oe Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit Pacis Mode Deductee Master f Ceneri Mode Deductee Code 0 Deductee Type Company PAN PANNOTAVBL Deductee Name Address State PIN Mobile E mail Add Echt Sw
74. tions PDS INFOTECH PRIVATE LIMITED AN MUMDOB3I93C FA Your 2012 13 From Date O1M4 2012 To 1802 2013 Deductee Transactions Page 1 of1 Date Section Amount Paid Rate TOS Amount TOS Deposited Pay Doc No Pay Doc Date Remarks Deductee Name ASLAM GADKARI PAN ALCP GO 6EN lype Non Company 10 6 2012 194 18600 00 16 0000 1960 00 1960 00 91156 0470672012 10706 2012 134I 13660 00 16 0000 1366 00 1366 00 90126 0470772012 1007 2012 194J 13300 00 10 0000 1330 00 1330 00 90332 O32012 Total 46950 00 4655 00 4655 00 Didia Mar CHANDABHOY amp 2JASSOOBHOY PAN AAAF CETA C Type Company DIAO 1543 39205 00 3931 OO 3931 00 90955 260 2012 Total 39305 00 3931 00 3931 00 Deductee Name CHANDAN SAVLA PAN AAJIP SIG64H Type Non Compary 0199 2012 13941 19600 00 1050 00 1060 00 92963 29 09 2012 0109 2012 1941 46000 00 10 0000 4600 00 4500 00 92963 29 09 2012 0199 2012 1941 4200 00 190 0000 420 00 420 00 92963 29 09 2012 0199 2012 1941 13000 00 1300 00 1300 00 92963 290972012 DA OOI 194 10500 00 1050 00 1080 00 90330 26M 0 2012 DA OOI 194 4600 00 26N OROI DAI 1341 1050000 1060 00 1060 00 90712 3012012 I 1 2012 1341 46600 00 4600 00 4600 00 90712 30r 12012 i 2 2012 1941 10600 00 10660 00 1060 06 20978 3171272012 DA 2202 1941 4600 00 4500 00 9097 31A 2 2012 Total 241200 00 24420 00 24420 00 TDSMAN User Manual Page 43 Certificate amp Report Printing 6 4 Party Employee wise Summary Purpose This report provides the summarized information o
75. tor Figure 6 14 Company Details as recorded in the Statement a Name PDS INFOTECH PVT LTD b Address Fiat Door Block No 20 Name of Premises Building DALHOUSEE Road Street Lane COOKE amp KELVEY BUILDING Area Locality KOLKATA Town District City OLD COURT HOUSE STREET State WEST BENGAL Pin Code 700001 STD 33 Phone 22623535 eMail info pdsinfotech com c TAN CALP08143C d PAN AAECPS176D e Deductor Type K Company Has Address changed No PAO Code DDO Reg No PAO Reg No State DDO Code Ministry 3 Previous Filing Details a Previous PRN No 050420100404973 4 Filing Details a Receipt No PDS INFOTECH PVT LTD TAN CALPOB143C FA Year 2012 13 Form No 260 Correction Statement Company Details 2602 2013 Print Date 2 Particulars of Responsible Person a Name b Address Flat Door Biock No Name of Premises Building Road Street Lane Area Locality Town District City Pin Code State STD Mobile ea c Father s Name d Designation e Has Address changed b Original PRN No 050420100404973 b Date of Filing RANJAN GOENKA 20 DALHOUSEE COOKE amp KELVEY BUILDING KOLKATA OLD COURT HOUSE STREET 700001 WEST BENGAL 33 Phone 22623535 9830086326 info pdsinfotech com DIRECTOR No TDSMAN User Manual Page 51 Certificate amp Report Printing Figure 6 15 Report on Changes done in Challan details PDS INFOTECH PYT LTD
76. ts NSDLInformation TRACES Information Utili E ara ar A Form 240 Form 260 Form 270 Form 27E0 Import from Excel b Create Blank Excel sheet Import from TDS File Consolidated Statement Import Deductee Master Import Employee Master Add Deductee Import Company Master Import Transactions from Excel and select Create blank Excel workbook Fermno 240 The following window will be displayed Figure 8 1 Selection of relevant TDS TCS Form rm TDSMAN Create Blank Excel sheet ad Masters Regular Return Corrections Return Reports NSDL Information Utilities Exit AddMode f Get Blank Excel File Format GeneralMode Select the relevant to a TDS TCS Form and the relevant file type i e xls or xlsx files Save the same in the selected destination folder TDSMAN User Manual Page 70 TDSMAN User Manual Page 71 Import of External Data Enter data in the created Excel sheet Provide the Challan and Deductee details in the Excel workbook as per displayed columns headers Guidelines for placement of data are provided within the Excel workbook and should be strictly followed Validate and Import data from the excel sheet In order to import the excel sheet click on the option Import from Excel and select Import t Regular Return Corrections Return Reports NSDL information TRACES Information Utili Form240 Form 260 Form 270 Form 27EQ
77. unt of Payment 0 00 Rate 0 0000 Income Tax 0 00 Surcharge Cess Total Tax Deposited Remarks Normal Transporter Below Threshold Limit Lower Deduction No Deduction Higher Rate Challan Amount 117 00 Difference Total Tax Deposited 117 00 The above screen is divided into three sections The left panel is the area where data has to be entered The right panel displays records as you keep on entering The bottom part has the self labeled action buttons TDSMAN User Manual Page 65 Preparation of Correction Returns Add Deductee To add a challan enter the details in the left panel The brief description of all the fields has been explained in Regular returns section After entering click on the Save button to record the new challan in the return The deductees can also be added from a pre defined excel sheet This can be done by clicking on the Add Deductees using Excel button Modify Deductee In order to modify a deductee select the deductee you need to modify from the right panel with the help of the mouse Either double click on this entry or click on the Edit button The selected entry will be displayed on the left panel which can now be modified and saved again If Deductee record is marked with Higher Rate flag then changes are only allowed in Payment Amount Payment Date and PAN of the Deductee In case th
78. urt House Street 2nd Floor Kolkata 700001 Phone 91 33 22623535 64596006 Email info pdsinfotech com Website www pdsinfotech com TDSMAN User Manual Page 1 Table of Contents 1 2 3 PC TAC Ecs ceacnccestunncessnacsecss E E E E 4 Le AU C a E A E AE A E AE 4 L2 Muar O ZA O eea ES 4 Lo Document Convenio sssi a 4 LA lt P DIDI V1 ON ase sina ices E E E T O T E 5 Software Installation and Registration ccsccscscccsccscsceccccscsceccccecscsccccecscsceccecscscesececscesees 6 2 1 Hardware and Software RequireMent cccccssssssssssesssessscccceceeeeesessssssssscceanseessccceeeeess 6 2 2 Software Installation and Registration seeseesssesssssserrrrsrrsssssresrrssssrrrrersrsssrrerrreerssserrrene 6 OVEFVIEW sirais E EEE E E E EEE 13 3 1 Description of the different TDS TCS FOr ccccecccceecccccecsesceeeeeceeeeeseeceeeeeeeesseseeeeuaeees 13 3 2 Key Functions of TDSMAN Process OvervieW ssssssssssseessrreresrrrrerereserrrrsrrererrrressrereserrsene 13 3 2 1 Processing ORROT NG scere 13 3 2 2 COM ECUON OF LDS RETU esn OE E 15 3 3 Getting familiarized with the Action Buttons Of TDSMAN cccccccssseceeeeseceeesseceeeeeeeeeees 15 MA ter aaas E E A 16 4 1 Company Ded ctor Mate eseo eanaudeavanciaieecnauanedneneaaseensarsaaesenares 16 4 2 Bodu e MA TET a a E E E E S 19 4 3 Employee Master sorserien err EE 22 ROO RETU DS occ sree ccc ccecen epee ncsteancaeseecenoas cacauecnse
79. validating the text file generated in Step 1 and generating the FVU file for submission While validating the Challan details entered in the returns and Challan Detail as uploaded by Bank will be cross verified In case automatic CSI file is unchecked then the path of this file should be manually provided On validation the status in terms of successful unsuccessful validation will be displayed and one can also view the report for subsequent action After the return has been generated and validated the return has to be submitted to TIN FC or it can also be uploaded as per the rules in NSDL s website Steps for preparation for submission of the return are explained as under Click on open output folder and copy the file having extension fvu Print Form 27A by clicking on button Print Form 27A which will also be required for submission of return along with the fvu file in Floppy CD Pen drive TDSMAN User Manual Page 69 8 Importing of External Data TDSMAN has a convenient option for importing transferring data from Excel workbook and TDS file 8 1 Import from Excel Workbook To import data from an Excel workbook the follow the steps given below gt Create Blank Excel sheet gt Enter data in the above sheet gt Validate and import data from the excel sheet Create Blank Excel sheet A pre defined format has been provided in the Regular Return Menu Click on the option Import Corrections Return Repor
80. wide the following information then click Next 1332069 S KEJRIWAL info Gtdsman coml In the above interface you will need to enter the Serial No as provided along with the software package Name of the person using the software and Email Click on Next button to complete the offline installation process After successful installation and registration the following start up screen will be displayed Figure 2 11 Successfully Registered Reports NSDL Information TRACES Information Utilities Exit Shortcuts Add Company TDS MAN filing returns made easy Add Deductee Form No 24Q Form No 26Q Make Corrections Quarter wise Report Name KEJRIWAL Serial No ab1234ijk Financial Year 2005 06 To 2015 16 05 Jan 2015 Print Form 164 Add Employee Version Date Developed by Helpline 91 33 22623535 64596006 Email info tdsman com PDS Infotech P Ltd toma www tdsman com 2nd Floor Kolkata 700001 TDSMAN User Manual Page 12 3 Overview TDSMAN generates eTDS eTCS Returns as per the stipulated requirements of the Income Tax Department Govt of India It is a simple to use software which will assist in processing your returns pertaining to Forms 24Q 26Q 27Q amp 27EQ and help one to generate the electronic files for submission with minimum effort Further it also has an in built utility to help its users in understan
81. y will be displayed on the right panel As you keep on making more entries keep saving each record and list of all the records will get displayed on the right panel An illustrative screen is displayed as below Figure 5 7 Deductee Details TDSMAN Form 26Q a Masters Regular Return Corrections Return Reports NSDL Information amp x Form 26Q Domestic Utilities Exit Deductee Details Amount Date 17000 00 01 04 2012 10000 00 01 7047 2012 Challan Srl No fi Section 194C Challan No 00004 Date 08 04 2012 Deductee Srl No Provision Entry Deductee Name 417 Total 340 00 Tax Deposited 340 00 SINo PAN No 1 AMAPB7S94E S4KFS6295B Deductee Name S M ENTERPRISH LM STEELS COMPA PAN 416 Date 418 Amount of Payment 419 Rate 427 Income Tax 421 Surcharge 422 Code 415 01 Company 01 04 2012 DD MM YYYY 0 00 2 0000 0 00 0 00 Cess 423 Total 424 Tax Deposited 425 Remarks 428 Nomal Higher Rate Below Threshold Limit Lower Deduction No Deduction Transporter Total Tax Deposited 540 00 Challan Amount 5000 00 Difference 4460 00 Exit from 26Q Back to Home Screen Deductee Master Help While entering the deductee name the software will provide a help screen having list of deductees matching with the value entered in the field One can select the deductee fro
82. ys the details of all the records that have been additionally added or deleted Run Time Selection Criteria Select Correction Batch Select the correction batch for which the report needs to be generated The correction batches can be differentiated by looking at the information against each batch Click on OK button to print the report based on above selection Figure 6 17 Correction Log PDS INFOTECH PVT LTD TAN CALPORW430 FA Year 2012 13 Page 1of1 Fom OVA To S0aN Form No 260 Cormection Log Print Date 28002A Comection Summary Changes in Company Details Yes Total changes in existing challan 1 Total Changes in Deductees of existing challans 0 Total No of PAN Upsiaies of deductees 3 Total No of new challan added 0 Total Ho of deductees added in naw chalan 0 Company Details 3l No Field New Value Old Value 1 Company Address Town District DALHOUSEE 2 Resposible Person Address Town Distnc DALHOUSEE 3 Resposible Person Address Email ina ipetsinfotech comi Values Changed in Challan Details Challan Record No Field New Value Old Value 1 Section 14H isc Values Changed in Deductee Details Challan SI Ho ductes Sl No Field New Value Old Value 4 1 Deguciee PAN BIUPMaT 628 AIUIPMa 7628 2 1 Deduciee PAN BIWPMaT 628 AIUIPMaTa28 3 2 PAN BIUPMaT 628 AIUIPMa 7628 TDSMAN User Manual Page 53 Certificate amp Report Printing 6 10 Query Reports Challan amp Deductee Purpose This

Download Pdf Manuals

image

Related Search

Related Contents

Stack Command Line Interface User's Guide  Nazdar Ink Conversion Guide for Wide Format Solvent Digital Printers  König SEC-DUMMYCAM90  GP-S044 - ELTRON  64-bit PCI 10/100/1000Mbps Gigabit Ethernet Card User's Guide  Rockford Fosgate Prime R500-1 User's Manual  第4回定期安全管理審査結果    Negro para cuero VM liquido  Hampton Bay AL634-NI Use and Care Manual  

Copyright © All rights reserved.
Failed to retrieve file