This Excel utility is fully automated. Just put the data in Data input sheet and it will prepare the Form-16 automatically. User can also take printout of Form 16 prepared through this utility. Format if form 16 is latest and applicable from A.Y. 2013-14 and F.Y. 2012-13.
Many times we require STD CODE of some place, but we have do not have that and search for the same in Telephone Directories, on Internet etc. We have uploaded an excel utility which will ease your search of STD codes.Download STD Code Finder
Download EMI Calculator EMI in Terms of FD & RD Calculator
Download Automatic Excel Utility for Application for allotment of New PAN (Form 49A) – applicable for Citizens of India. This form should be used when the applicant has never applied for a PAN or does not have PAN allotted to him. An applicant can visit Income Tax Department (ITD) website to find whether a PAN has been allotted to him or not. Indian citizens located outside India should also use this form.
WCT certificate need to be issued as per the requirement of respective state VAT Act. In the state of west Bengal WCT certificate need to be issued on monthly basis as per rule 47 of West Bengal VAT Rules 2005. We have prepared a Marco in excel which makes the task of preparing WCT certificate in form 18 much easier. Generally it takes around 5-8 minutes to prepare one certificate and need a lot of concentration to avoid any error.
TDS on Salary Calculator for Financial Year 2012-13 / Assessment year 2013-14. The Calculator attached is in excel format which can calculate TDS liability of up to 50 employees. Calculator have facility to prepare and print computation of Income for all the Employees.
Automatic Due Date Reminder Calender for Financial Year 2012-13-This Calender contains due dates of all the statutory and other Reports to be presented to Management and Banks.
Download Format of Bills for CA, CS, ICWA and other Professionals. This Format will work only in Excel 2007. In this bill book you have to enter only details of bill book in a table and after that you can print the bill you want to print in just one command.
TDS on Salary Calculator for Employers for A.Y. 2012-13 F.Y. 2011-12. Calculate TDS of more then one employee in single file. 1 Fill the data in sheets Bonus, arrear, Apr to Dec only 2 Estimates will be automatically calculated 3 ESI and PF in Estimate calculation applied only for applicaple employee, formula can be copied or deleted as and when applicable 4 in TDS sheet Green colour cells only should be filled manually apart from that Emp Id, Name, Gender and Designation can be filled.
Download Revised Form 49A Excel Auto utility – This form should be used when the applicant has never applied for a PAN or does not have PAN allotted to him. An applicant can visit Income Tax Department (ITD) website to find whether a PAN has been allotted to him or not.
