Download State employee’s Tax Computed Sheet +Individual Salary Sheet+Salary Structure +HRA Calculation +Arrears Relief Calculation +Form 16 Part B + Form 16 Part A&B for Financial Year 2014-15

Click here to Download the latest IncomeTax Preparation Excel Based software which can prepare any State Govt employee’s ( Tax Computed Sheet + Individual Salary Sheet + Salary Structure for any State Govt concerned Salary Pattern for calculating the Gross Salary Income + Automatic Arrears Relief Calculation with Form 10E + Automatic House Rent Exemption Calculation + Automatic Form 16 Part B and Form 16 Part A&B for the Financial Year 2013-14 and Assessment Year 2014-15.)


It seems that the various State Govt have different Salary Structure and various Salary Benefits other than Central Govt employees. Most of the State Govt employees have known that which Income Tax Section can be get the Tax Benefits. In this Excel Based Software can use any State Employee and also can use the All Central Govt employee also. 

The Salary Structure of each and every State Govt Pattern have built in this utility and which can fit for any State Employees Salary Structure. Also can use this Salary Structure to the Central Govt employees also.
This Excel Based Software most easy to generate and easy to handle. You can prepare more than 100 employees TDS on Salary by this One software ( One by One).

Feature this utility

1.     In build the Salary Structure for Calculating the Gross Salary with the all Benefits of each State Govt Salary Pattern.
2.     All the Income Tax Section have in this Utility and you can view the section at a glance
3.     Automatic Calculate your Income Tax Liability
4.     Automatic Calculate the Arrears Relief Calculation from the FY 2000-01 to 2013-14 with Form 10E
5.     Automatic Calculate the House Rent Exemption Calculation U/s 10(13A)
6.     Automatic Prepare the Form 16 Part B and Form 16 Part A&B as you like to print
7.     Print Facility of all the sheets
8.     Automatic Convert the Amount in to the In Words 

9. An Instruction have in this First Page for guide "How to use this Utility"

Click here to Download the latest IncomeTax Preparation Excel Based software which can prepare any State Govt employee’s ( Tax Computed Sheet + Individual Salary Sheet + Salary Structure for any State Govt concerned Salary Pattern for calculating the Gross Salary Income + Automatic Arrears Relief Calculation with Form 10E + Automatic House Rent Exemption Calculation + Automatic Form 16 Part B and Form 16 Part A&B for the Financial Year 2013-14 and Assessment Year 2014-15.)

How to check Income Tax Refund Status Online


  • Enter your Permanent Account Number (PAN) in the available box.
  • Choose the assessment year for which you desire to know the status and then click on submit. The NSDL website is a secure website, so one need not worry while entering sensitive information.
  • If your refund has already been sent to the refund banker i.e. to State Bank of India, the display would be something “Refund is already credited to your bank, please contact your bank”
  •  State Bank of India transfers refunds to tax payers either through ECS, or by way of a cheque.
  • Remember: The status of the refund would be available for tax payers, only 10 days after the refund has been sent by the Assessing Officer to the refund banker.



All about the Income Tax deduction Under Chapter VI A with All in One TDS on Salary for Non-Govt Employees for Financial Year 2014-15

Click here to Download Private employees All in One TDS on Salary for FY 2013-14(Prepare at a time Tax Compute Sheet + Individual Salary Structure + Automated HRA Calculator + Form 16 Part A&B and Part B for the Financial Year 2014-15)


As per the Income Tax Rules the all deduction Under Chapter VI A with the all current amended Section of Income Tax which was passed by the Central Finance Budget 2014-15 have also in this Chapter and showing the same is given below, so you can guess the which Section you can get the Income Tax benefits.

Deduction Under chapter VI A is given bwlow:-

Section 80D: Deduction in respect of Medical Insurance

Deduction is available up to Rs. 20,000/- for senior citizens and upto Rs. 15,000/ in other cases for insurance of self, spouse and dependent children. Additionally, a deduction for insurance of parents (father or mother or both) is available to the extent of Rs. 20,000/- if parents are senior Citizen and Rs. 15,000/- in other cases. Therefore, the maximum deduction available under this section is to the extent of Rs. 40,000/-. From AY 2013-14, within the existing limit a deduction of upto Rs. 5,000 for preventive health check-up is available.

Clickhere to Download the Automatic Master of Form 16 Part A&B for FY 2014-15 (Prepare at a time 50 employees Form 16 Part A&B for the Financial Year 2014-15)

Section 80DD: Deduction in respect of Rehabilitation of Handicapped Dependent Relative

Deduction of Rs. 50,000/- is available on:
1.     expenditure incurred on medical treatment, (including nursing), training and rehabilitation of handicapped dependent relative.
2.     Payment or deposit to specified scheme for maintenance of dependent handicapped relative.
Further, if the dependent is a person with severe disability, a deduction of Rs. 100,000/- is also available under this section. The handicapped dependent should be a dependent relative suffering from a permanent disability (including blindness) or mentally retarded, as certified by a specified physician or psychiatrist.
Note: A person with 'severe disability' means a person with 80% or more of one or more disabilities as outlined in section 56(4) of the 'Persons with disabilities (Equal opportunities, protection of rights and full participation)' Act.

Click here to Download Govt & Non Govt  employeesAll in One TDS on Salary for FY 2014-15 (Prepare at a time Tax Compute Sheet + Arrears Relief Calculation+Form 16+HRA Calculation+Form 16 Part A&B and Form 16 Part B)

Section 80DDB: Deduction in respect of Medical Expenditure on Self or Dependent Relative

A deduction to the extent of Rs. 40,000/- or the amount actually paid, whichever is less is available for expenditure actually incurred by resident assessee on himself or dependent relative for medical treatment of specified disease or ailment. The diseases have been specified in Rule 11DD. A certificate in form 10 I is to be furnished by the assessee from any Registered Doctor.

Section 80G: Deduction for donations towards Social Causes

The various donations specified in Sec. 80G are eligible for deduction upto either 100% or 50% with or without restriction as provided in Sec. 80G. 80G deduction not applicable in case donation is done in form of cash for amount over Rs 10,000.

Donations with 100% deduction without any qualifying limit:

  • Prime Minister’s National Relief Fund
  • National Defence Fund
  • Prime Minister’s Armenia Earthquake Relief Fund
  • The Africa (Public Contribution - India) Fund
  • The National Foundation for Communal Harmony
  • Approved university or educational institution of national eminence
  • The Chief Minister’s Earthquake Relief Fund, Maharashtra
  • Donations made to Zila Saksharta Samitis.
  • The National Blood Transfusion Council or a State Blood Transfusion Council.
  • The Army Central Welfare Fund or the Indian Naval Benevolent Fund or The Air Force Central Welfare Fund.

Donations with 50% deduction without any qualifying limit.

  • Jawaharlal Nehru Memorial Fund
  • Prime Minister’s Drought Relief Fund
  • National Children’s Fund
  • Indira Gandhi Memorial Trust
  • The Rajiv Gandhi Foundation

Donations to the following are eligible for 100% deduction subject to 10% of adjusted gross total income

Donations to the Government or a local authority for the purpose of promoting family planning.

Donations to the following are eligible for 50% deduction subject to 10% of adjusted gross total income

Donation to the Government or any local authority to be utilized by them for any charitable purposes other than the purpose of promoting family planning.

Section 80U: Deduction in respect of Person suffering from Physical Disability


Deduction of Rs. 50,000/- to an individual who suffers from a physical disability (including blindness) or mental retardation. Further, if the individual is a person with severe disability, deduction of Rs. 100,000/- shall be available u/s 80U. Certificate should be obtained from a Govt. Doctor. The relevant rule is Rule 11D.

Download New Amended Form 16 Part B with 24Q & 26Q for the Financial Year 2014-15 & Assess Year 2015-16

Click here to Download the Master of Form 16 Part B with 24Q & 26Q for the Financial Year 2014-15 & Assessment Year 2015-16 ( This Excel Based Software can prepare at a time 50 employees Form 16 Part B with 24Q & 26Q[All Quarters] )

As per the Income Tax Rules it is mandatory to submit the each quarter ended Income Tax Return to the Central Govt by the Govt and Non-Govt Concerned of their employees with the Challan 24 Q for Govt and 26Q for Non-Govt Concerned. In the One Financial Year have 4 (four) quarter 1st,2nd,3rd and 4th and final quarter.The CBDT has modified the Challan of 24Q and 26Q and published the new Amended Format of 24Q and 26Q.
Most of the concerned have not prepare and submit the Challan in each quarter and it appears that they have submit only the 27A Challan where not found of each employees salary details as well as TDS deduction of each employees. Now it is Mandatory to submit the 24Q or 26Q by the CBDT in each quarter. The Final and 4th Quarter will be Total Income of the hole financial year of an employees with the details of TDS deduction with Annex A.
It may help if you have already prepare the both of Form 16 Part B and 24Q or 26Q of each quarter for the Financial Year 2014-15 & Assessment Year 2015-16. If it is possible, then your time will be reduce and it will be advance to prepare the Form 16 Part B which can distribute to the employees after 31st Marc 2015. The itaxsoftware.net have prepared an Excel Based Software which can prepare at a time 50 employees Form 16 Part B with 24Q & 26Q ( for all quarters) for the financial year 2014-15 and Assessment Year 2015-16.
Feature of this Utility :-
1) This Excel Based Utility can prepare at a time 50 employees Form 16 Part B
2) Prepare at a time 50 employees All Quarters 24Q & 26Q ( Amended Version) 
3) Prevent the double entry of the Name of Employee and Pan Number
4) Automatic Calculate the Income Tax
5) Automatic Prepare the Form 16 Part B ( Amended Version)
6) Automatic Convert the Amount in to the In Words ( Without any Excel Formula)
7) Easy to install in any Computer 
8) Easy to Generate as this file is simple Excel File
9) Both of Govt and Non-Govt Concerned can be used this utility
10) The Salary Structure have in built, so it will be easy to calculate Tax Liability

Click here to Download the Master of Form 16 Part B with 24Q & 26Q for the Financial Year 2014-15 & Assessment Year 2015-16 ( This Excel Based Software can prepare at a time 50 employees Form 16 Part B with 24Q & 26Q[All Quarters] )

Section 80TTA of income tax act Plus Master of Form 16 Part B for Govt & Non Govt employees for the Financial Year 2014-15

Click here to download All in One Master of Form 16 Part B For the Financial Year 2014-15 (This Excel Based Software can prepare at a time 50 employees Form 16 Part B with Individual Salary Structure)

Section 80TTA deals with the tax rebate available on interest earned in your savings bank account upto a limit of Rs 10,000 in a financial year. This new section was introduced in the finance act 2012 and is applicable from the financial year 2013-14. Only individuals and HUF can claim rebate under this section. The aim of this act is to increase savings and motivate tax payers to park their short term funds in savings accounts and benefit from interest gained.
Section 80TTA tax rebate is for interest earned in normal savings accounts only. The savings account can be with any commercial bank , public or private, cooperative banks or post offices. If the savings account is in the name of a firm or a group of people or a society then this tax rebate will not be applicable.Please note that tax rebate under this section is not applicable for fixed deposits of any term or recurring deposits.

Section 80TTA deductions can be claimed in chapter VI A deductions in addition to existing sections and has a separate limit of Rs 10, 000. This section is not clubbed with any other section under Chapter VI A

Click here to download All in One Master of Form 16 Part B For the Financial Year 2014-15 (This Excel Based Software can prepare at a time 50 employees Form 16 Part B with Individual Salary Structure)

Income Tax Under Section 80C is now Max Rs.1.5 Lakh, Plus All in One TDS on Salary for Non-Govt employees for the Financial Year 2014-15

Click here to Download All in One TDS on Salary for Non-Govt Employees for the Financial Year 2014-15 & Ass Year 2015-16 ( This Excel utility can prepare at a time Tax Compute Sheet + Individual Salary Structure + Individual Salary Sheet + Automatic HRA Calculation + Form 16 Part A&B and Part B)

Each year most of the people eagerly wait for the budget proposals to be announced for various reasons.
One of the significant reasons is to know what all instruments of investments and deductions / exemptions have been included in the Section 80C of Indian Income Tax for employees, so that they can plan their tax savings according to the same, and maximize the benefits.
As income tax is major component of the salary, the changes / additions in 80C Section has major impact on the savings and expenses of salaried employees as they have a fixed source of income. The 80C Section deductions are introduced to boost savings of employees on one side and save tax on the other side.
Actually, Section 80C replaced the earlier Section 88 which was available till 1st April 2006. The Deductions permitted in the 80 C Section of Indian Income Tax is more or less the same investment mixes that were available in Section 88. Even the section 80CCC on pension scheme contributions was merged with the above 80C. However, this new section has allowed a major change in the method of providing the tax benefit. Section 80C of the Income Tax Act allows certain investments and expenditure to be tax-exempt. One must plan investments well and spread it out across the various instruments specified under this section to avail maximum tax benefit. Unlike Section 88, there are no sub-limits and is irrespective of how much you earn and under which tax bracket you fall.
The most important aspect that needs to be kept in mind is that the total exemption limit under section 80c is revised from Rs 1,00,000 to Rs 1,50,000 in the budget presented by Finance Minister Arun Jaitley on July 10th 2014. 
Now see in details those deductions that are permissible under section 80C in this section. The following is section 80c deductions / exemption list mainly.
Provident Fund (PF) deduction under section 80C
Any contributions to Provident Fund, Voluntary provident Fund (VPF) or savings made in Public Provident Fund (PPF Account) are eligible for income tax deduction under section 80C of Indian Income Tax Act. The PF limit has been increased to 1.5 Lakhs from 1.0 Lakh earlier
Life Insurance Premiums
Any Life Insurance premiums (for one or more insurance policies) paid by you for yourself, your spouse or your children is eligible under income tax deduction under section 80C of Indian Income Tax Act.

ELSS Equity Linked Saving Schemes

Any investment made in certain Mutual Funds called equity linked saving schemes qualifies for section 80C deduction. Please note that not all mutual fund investments are eligible for this deduction. Some examples of ELSS funds are – SBI Magnum Tax Gain, HDFC Tax Saver, HDFC Long term advantage, etc.

ULIP – Unit Linked Insurance Plan

Investments made in certain ULIPs of Unit Trust of India and LIC of India are eligible for 80C deduction.
Bank Fixed deposits or Term deposits of term greater than 5 years
According to a relatively new provision amount saved in fixed deposits of term at least five years is eligible for income tax deduction under section 80C of Indian Income Tax Act.
Principal part of EMI on Housing Loan deduction under section 80C
If you are paying EMI on a housing loan, you would be aware that the EMI (equated monthly installments) consists of two parts – principal part and interest part. The principal part of the EMI on your housing loan is eligible for income tax deduction under section 80C. The interest part is also eligible for tax deduction, however not under section 80C but section 24.
Tuition Fees deduction under section 80C
Amount paid as tuition fee for the education of two children of the employee / Tax Payer is eligible for deduction under section 80C of Indian Income Tax Act.
Public Provident Fund (P.P.F.)under section 80C
The maximum limit of P.P.F. is now available up to Rs. 1.5 Lakh
 Other 80C deductions
Amount saved in National Saving Certificate (NSC),  amount paid as stamp duty and registration charges while buying a new home are eligible for income tax deductions under section 80C of Indian Income Tax Act.

Click here to Download All in One TDS on Salary for Non-Govt Employees for the Financial Year 2014-15 & Ass Year 2015-16 ( This Excel utility can prepare at a time Tax Compute Sheet + Individual Salary Structure + Individual Salary Sheet + Automatic HRA Calculation + Form 16 Part A&B and Part B)

Get Extra Relief from House Building Loan Interest up to Rs. 1 Lakh U/s 80 EE with Automatic TDS on Salary All in One for only Central Govt employees for FY 2014-15

Click here to Download the TDS on Salary All in One for the Central Govt employees For Financial Year 2014-15 & Ass Year 2015-16 ( This Excel utility can prepare at a time the Tax Compute Sheet + Individual Salary Structure + Arrears Relief Calculator + Form 10E + HRA Exemption Calculation + Form 16 Part A&B and Part B)


The New Income Tax Section 80 EE ( HBL Interest relief up to Rs.1 Lakh ) have already introduce From the Financial Year 2013-14 and this Section shall be continue in this Financial Year 2014-15 also. What & How this benefits can get by the tax payers, in addition to the Section 24 B is also applicable separately.

“80EE. (1) In computing the total income of an assessee, being an individual, there shall be deducted, in accordance with and subject to the provisions of this section, interest payable on loan taken by him from any financial institution for the purpose of acquisition of a residential house property.

(2) The deduction under sub-section (1) shall not exceed one lakh rupees and shall be allowed in computing the total income of the individual for the assessment year beginning on the 1st day of April, 2014 and in a case where the interest payable for the previous year relevant to the said assessment year is less than one lakh rupees, the balance amount shall be allowed in the assessment  year beginning on the 1st day of April, 2015.

(3) The deduction under sub-section (1) shall be subject to the following conditions, namely:—
(i) the loan has been sanctioned by the financial institution during the period beginning on the 1st day of April, 2013 and ending on the 31st day of March, 2014;
(ii) the amount of loan sanctioned for acquisition of the residential house property does not exceed twenty-five lakh rupees;
(iii) the value of the residential house property does not exceed forty lakh rupees;
(iv) the assessee does not own any residential house property on the date of sanction of the loan.

(4) Where a deduction under this section is allowed for any interest referred to in sub-section (1),deduction shall not be allowed in respect of such interest under any other provisions of the Act for the same or any other assessment year.

(5) For the purposes of this section,—
(a) “financial institution” means a banking company to which the Banking Regulation Act, 1949 applies including any bank or banking institution referred to in section 51 of that Act or a housing finance company;
(b) “housing finance company” means a public company formed or registered in India with the main object of carrying on the business of providing long-term finance for construction or purchase of houses in India for residential purposes.”



Click here to Download the TDS on Salary All in One for the Central Govt employees For Financial Year 2014-15 & Ass Year 2015-16 ( This Excel utility can prepare at a time the Tax Compute Sheet + Individual Salary Structure + Arrears Relief Calculator + Form 10E + HRA Exemption Calculation + Form 16 Part A&B and Part B)


Automatic Arrears Relief Calculator with Auto Form 10E from the FY 2000-01 to FY 2014-15 in Excel

Click here to download the Automatic Arrears Calculator U/s 89(1) with Form 10E From the Financial Year 2000-01 to Financial Year 2014-15 (Up to date).

As per the Income Tax Section 89(1) the any employee can get the Income Tax Relief from the Arrears Salary which Salary Income comes from his previous Financial Years. Some of employee have got the amount as arrears salary for the financial year 2006-07 in the financial year 2014-15. Hence when he calculate the Income Tax with this arrears Income, the Taxable Income will be raised for this Arrears Salary of FY 2006-07. But this Amount is only for the Financial Year 2016-07. Now it is burden for this Financial Year 2014-15 and most of the employee have to pay the tax including this previous year's earning salary.
The Income Tax Section 89(1) can get relief from tax of those financial year arrears salary by submit the Form 10E . This Form 10 E can bifurcate the amount of each Financial year and calculate the actual taxable income of each financial year. 

Most of the employee have not make out " How to Bifurcate this arrears salary to the previous salary income" and what is the Process about this. Now the itaxsoftware.net have prepared a Arrears Relief Calculator with Automatic Form 10E which can calculate and prepare the Arrears Salary Income and Bifurcate the amount of each Financial Year and reduce the taxable income U/s 89(1) with Form 10 E.

Click here to download the Automatic Arrears Calculator U/s 89(1) with Form 10E From the Financial Year 2000-01 to Financial Year 2014-15 (Up to date).