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.
This excel utility should be used when PAN has already been allotted to the applicant but applicant wants to make change/correction in PAN data. A new PAN card bearing the same PAN with updated details will be issued to applicant. The form is updated with recent changes made in the same and applicable from 08.04.2012.
1. It calculates Tax Liability of Salaried Employees of Private and Government Sector for A.Y. 2013-14 or Financial Year 2012-13. 2. Calculator have in Built House Rent Allowance (HRA) Calculator which Calculates HRA Exemption which an Employee is Eligible. 3. In Built Arrears Relief Calculator to Calculate tax Relief Receivable by the Employee on Salary Received during the year related to years earlier then Financial year 2012-13.
Download Automated Form-16 for Financial Year 2011-2012 and Assessment Year 2012-2013 – 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. 2012-13 and F.Y. 2011-12.
We have uploaded below ITR one in Excel Format. The form can be used by Individuals who are earning Salary Income to File Income Tax Return For Assessment year 2012-13 or Financial year 2011-2012. the Calculator is in Excel Format and also have a data input sheet in which you can fill all the income and deduction details and it will auto calculate tax and fill ITR with Income Tax Return Acknowledgement.
This File prepare Form 16 for 50 Employees in one go. All we have to do in enter the detail of salary of employees in input sheets and the software automatically prepares form 16 for up to 50 Employees. other benefits of the utility is as follows:-
This Excel utility prepares GPF Ledger of all the Employees and Statement of general Provident Fund Account for all Government Employees of State and Central Government.
This Excel Sheet calculate your portfolio in real time. Benefits of the sheet is that you have a complete scenario of your portfolio (total Gain/loss at the moment, total brokerage actual gain/loss including brokerage etc.) at a glance with out opening any site, where you need to check the prices of your stock one by one. its also show whether your stock is todays gainer or loser by changing its current price column colour (Green of gainer & red for Loser). This Sheet requires Internet connection & takes automatic updates in every 2 minutes.
We have uploaded Calculator to calculate relief Under section 89(1) of the Income Tax Act, 1961 in respect of Arrears of salary received during the financial year 2011-12. The Calculator will calculate relief if any which Assessee can claim U/s. 89(1) in respect of salary received in Financial Year 2011-12 pertaining to years prior to that. Calculator will calculate the Relief for Arrears received pertaining to the period from from 01.04.2005 to 31.03.2010 The Calculator also automatically Fills Form 10E with its annexure and Table A Automatically.
