e-TDS Return, TDS Non-Salary Software (26Q Data Storage for e-tds Return)

             To protect  PAN Numbers in Salary Data, Access based utility has already been provided.  Now,  TDS Non-Salary utility/Software is ready for use.  In General view, All Section alongwith Section Codes have been included in this utility in the interest of User.  There is many Section which are not in General Use.  User can delete them from Section Table and keep only those Sections whose he want to use.  It makes easy selection during Data Entry.  Refresh Data File Query is automatically run after Each new entry.  In case user Select Yes button on saving each entry there is no need to run later query named "Refresh Data File"

              Installation and procedure is quite same as was in TDS Salary software. (to know click here)

Download Software (Click Here) TDS Non-Salary (Micro Soft Access based)
Download Software (Click Here) TDS Salary (Micro Soft Access based)
(On getting response from user side, utility will be updated time to time)

Mandatory e-filing of Central Excise or Service Tax Return w.e.f. 01.10.2011

Mandatory E-filing of Central Excise Duty and Service Tax Returns w.e.f.  01-10-2011

• Central Excise Duty Return :- Vide Notification No. 21/2011 dated 14.09.2011 and Notification No. 22/2011 dated 14.09.2011, e-filing of ER-1,ER-2,ER-3,ER-4,ER-5,ER-6,ER-7 and ER-8 forms for  all assessees is mandatory w.e.f. 01-Oct-2011.
  1) Complete Notification No 21/2011 dated 14.09.2011 (Click Here)
  2) Complete Notification No.22/2011 dated 14.09.2011 (Click Here)
• Service Tax Return :- Vide Notification No. 43/2011 dated 25.08.2011, e-filing of ST-3 forms for all assessess is mandatory w.e.f. 01-Oct-2011.
  1) Complete Notification No. 43/2011 dated 25.08.2011 (Click Here)

(To download  software of Central Excise Forms ER-1,ER-2,ER-3,ER-4,ER-5,ER-6,ER-7 and ER-8, Click Here)

TDS/TCS SALARY RETURN SOFTWARE/UTILITY

Keeping in view  Pan Number Errors in e-tds/e-tcs  return, some trick is required to aovid PAN errors in Quarterly TDS data.  If a person/deductor enter PAN numbers manually in TDS/TCS return data, there are lot of changes of errors.  Errors do not depend upon a particular person, but it is human.   Manual interaction in Data Entry generate such type of errors.

To avoid PAN Number errors in preparation of Quarterly Salary Data, a simple utility has been prepared in Microsoft Access named  TDS Salary. 

File Size 3.75 m.b. (Download )

Installation :-  Just download and use. 

How to Use : - Two tables    = Data and Employees
                         Two Forms   = Data Entry  and Employees                    
                         Two Queries = Refresh Data  File and Name Search

• Base Data or Master Data of employees can be stored in Employees Table and Quarterly Data will be stored  in Data Table. 
• To store Quarterly data , Data Table can be stored after pressing refresh Data File. 
• Data entry can be done through both forms either from Data Entry Form or from Employees Form.  Vice versa links are available in both forms. 
• Use  query  "Refresh Data File" after  adding new entry.   There will a meesage to ask
   "Are you sure you want to run this type of action query ?
  Form information on how to prevent this message from displaying every time you ran an action query,click help."
  Press Yes to Run and again Press Yes  to update Data file. 

ITR-4 and ITR-4S (SUGAM) RPU

Income Tax Department has released  ITR-4 and ITR4S (SUGAM) excel based forms as free software for submitting online INDIAN INCOME TAX RETURN for the Financial Year 2010-11 or Assessment Year 2011-12.  ITR-4S (SUGAM) is new Income Tax Form for the Assessment Year 2011-12.   Now question arise that who will submit ITR-4 and who will submit ITR-4S (SUGAM).

ITR-4. ITR-4 form will be used for Individuals and HUFs having income from a properietory business or profession for the Assessment Year 2011-12 as per Rule 12 of the Income Tax-Rules,1962)

ITR-4S (SUGAM).  This form will be used for submitting online Indian Income Tax Return for Presumptive Business Income Return. for the Assessment Year 2011-12 as per rule 12 of the Income Tax-Rules 1962. 

To download Indian Income Tax Return forms Manual or Excel Based (Click Here)

Merge or Delete Ledgers in Tally

          Shweta Softwares has issued a free utility for exporting Data from Tally to Excel, Merging two Ledgers, Delete a Ledger and displaying Negative Stock-Reports. Name of this free utility is UDI-Magic Free Edition v1.0 Release 2.5.  I have also tried this utility and got success in running it's features. 

              Initially question arises that what is need of Merge Two Ledgers.  Answer is that sometimes users create duplicate ledgers while passing entries in Tally i.e. M/S Anita Industries or Anita Industries.  Only due difference of  M/S, Two Ledger masters are lying in Tally with entries in both ledgers.  One way is that to simply shift vouchers from one Ledger to another Ledger manually.  But it is difficult when much vouchers are available in both Ledgers. In such position, software requires for Ledger Merging. 

             Secondly due to any reason, you want to delete a Ledger Master having including it's vouchers.  This software plays magical part and Delete Ledger Master in seconds. 

Installation of Software :-

             Simply download the software unzip the zip file and Click on Installer and then follow the instructions.  It's installation is simple. After installation a shortcut will appear on your desktop to run it in future. 

TCP file setting in Tally.ini file

            On successful installation of the software, a folder named UDIMagicFreeEdition has been created in C:\ Drive with showing some files as shown in below picture :-

Three .tcp files are lying in above picture or folder c:\UDIMagicFreeEdiction\.  The tcp file ending with 72.tcp  works for tally 7.2 and tcp file ending with 9.tcp or 9-R3.tcp work for Tally 9 releases.

Now, open your Tally folder and right click on tally.ini file and open with in Notped.  Before alteration some text shows as under  which are required to be changed  :-

Now, change User TDL =yes and type tdl =c:\UDIMagicFreeEdition\udiMaic9.tcp  as shown in below picture:-

In this way setup of  UDIMagicFreeEdition software becomes complete. 

Download Software UDIMagic-free-edition-setup