Breaking News
Loading...
Share It

Enter your email address:

Powered by Feedio

Showing posts with label Central Govt employees Income Tax Software for F.Y.2016-17. Show all posts
Showing posts with label Central Govt employees Income Tax Software for F.Y.2016-17. Show all posts

Wednesday, 30 November 2016

Click here to download Automatic All in One Income Tax Preparation Excel Based Software  for Central Govt employees for F.Y.2016-17 [ This Excel Utility can prepare at a time Tax Compute Sheet + Automatic H.R.A.Exemption Calculation + Automated Form 16 part A&B and Form 16 Part B]


After all the problems in the form of thousands of taxes faced by the taxpayers, in the budget of 2016, a minute relief against income tax has been provided for small tax payers. The rebate enhances from Rs.2000/- to Rs.5,000/- for F.Y.2016-17 which is now available to small taxpayers who have income below Rs. 5,00,000. There are some misconceptions among the people regarding this relief being available to them, this article focuses on the technical point of view for the relief under section 87A.
Conditions of claiming Rebate u/s 87A:
1.   The taxpayer must be a resident individual and is not applicable to NRI.
2.   The income of the taxpayer should not exceed Rs. 5,00,000 after claiming deduction u/s 80C to 80U.
Amount to be claimed:
The taxpayer can claim the rebate u/s 87A if the above two conditions are satisfied. The amount of rebate which can be claimed by the resident individual is 100% of the income tax payable on total income after deduction of 80C to 80U or Rs. 5000/- whichever is lower. This rebate is allowed out of the total income tax payable amount without adding surcharge and education cess.

Effective Date of section 87 A:
Taxpayers can take the benefit of this section from the AY 17-18 i.e. FY 16-17. This section is not applicable for NRI, resident or non-resident HUF/AOP/BOI or any taxpayer other than the resident individual.
Wrong understanding of section 87A
Some taxpayer might end up with the conclusion that when tax payable is below Rs. 2000 or Nil then also they can claim the rebate of Rs. 5000 but as discussed earlier that lower of the 100% of income tax or Rs. 2000 is allowed as rebate cum relief to taxpayers.

For Example  Mr. X earns income during the year and after deduction, it comes to Rs. 215000. So tax on Rs. 215000 is Rs. 1500. Rebate allowable will be RS. 1500 or Rs. 5000 whichever is lower. Therefore rebate of Rs. 1500 will be given to the taxpayer and not Rs. 5000.

Monday, 19 September 2016

Click here to Download the Automatic All in One TDS on Salary for Central & State Govt Employees for the FY 2016-17 ( Prepare at a time Tax Compute Sheet + Individual Salary Structure + Automated HRA Exemption + Automated Form 16 Part A&B and Part B)
Section - 10 (5)
Exemption for Leave Travel Concession
The amount actually incurred on the performance of travel on leave to any place in India by the shortest route to that place is exempt. This is subject to a maximum of the air economy fare or AC 1st Class fare (if the journey is performed by the mode other than air) by such route.
Provided that the exemption shall be available only in respect of two journeys performed in a block of 4 calendar years.

Section - 10(10):
Gratuity Exemption
Descriptions :
Least of the following will be exempt
1. Amount received
2. Max  Rs. 10,00,000
3. 15*/26 x LS x (CYS + Fraction 6 months)
LS : Last Month Salary Drawn (Salary means Basic + DA (both))

Section - 10(10A)
Commuted Pension, Actual  Amount

Section - 10(10AA)
Leave Encashment upon Retirement
Other Employee Least of the following will be exempted
1.Amount Received
2.Rs. 3, 00,000
3.10 x AS
(LE or 30 days) Received by Employee During the Employment (Fully TAXABLE)
Note - Govt. Employee {Fully Exempt} Received by Legal Heir (Fully exempt)

Section - 10(13A)
HRA
The least of the following will be exempted
1.Amount received
2.50% or 40% of Salary
3.Rent paid less 10% of Salary
4.Salary means; Basic Salary+D.A

Section - 10(14)
Children Education Allowance.
Rs.100 per month per child up to a maximum 2 children.

Hostel expenditure Allowance on employee’s child
Rs.300 per month per child up to a maximum two children.
Note: Allowance granted to meet Hostel expenditure Allowance on employee’s child.

Deductions under section 80 of Income Tax Act:
Section - 80C:
General deduction for investment in PPF, PF, Life Insurance, ULIP, Stamp duty on the house, Fixed deposits for 5 years , bonds etc. Maximum Rs. 1,50,000 is allowed. Investment need not be from taxable income.
Section - 80CCC
Deduction in case of a contribution to pension fund. However, it should be noted that surrender value or employer contribution is considered income. Maximum is Rs 1,50,000.

Section - 80CCD (2)
Deduction in respect to contribution to a new pension scheme. Employees of central and others are eligible.
The maximum is a sum of employer’s and employee’s contribution to the maximum: 10 % of salary.

Section - 80CCD (1B)
Deduction in respect to contribution to a new pension scheme. Employees of central and others are eligible. This deduction is additional deduction U/s 80C Rs.1.5 Lakh.
Maximum Rs. 50,000/-

Section - 80CCE
It should be noted that employer contribution is allowable as extra u/s 80CCD(2) & 80CCE(1B) of the Income Tax Act from Asst Yr 2016-17 and only employee's contribution is within limit of Rs 1.5 Lakh as stated in 80CCE
It should be noted that as per section 80CCE, the maximum amount of deduction which can be claimed in.

Section - 80CCG
Individual having gross total income up to Rs. 12 Lakh can claim this deduction for investing in IPOs of share or mutual fund units. 50 % 0f the invested amount. The limit is Rs. 25,000 max. Note: The deduction is allowed for three years only.

Section - 80D
Medical insurance on self, spouse, children or parents. The deduction is also allowable for CGHS contribution to Central and State scheme. It is also for conducting health check up to Rs 6000.
Rs 25,000 for self, spouse & children. Extra Rs. 30,000 for insurance on parents. IF parents are above 65 years, Thus maximum is RS 55,000 per annum to a person of age below 60 yrs.


Section - 80DD
For maintenance including treatment or insurance, the lives of physical disable dependent relatives
Rs 50,000. In the case of disability is severe, the amount is Rs 1,50,000. Watch video on 80DD Deduction

Section - 80DDB
For medical treatment of self or relatives suffering from specified disease. The actual amount paid to the extent of Rs 40,000. In the case of a patient being Sr Citizen, the amount is Rs 80,000.

Section - 80E
For interest payment on a loan is taken for higher studies for self or education of spouse or children. The actual amount paid as interest and start from the financial year in which he /she starts paying interest and runs till the interest is paid in full. Watch the video on 80E.

Section - 80EE
Interest on home loan sanctioned during F. Y. 2013-14 & on-wards F.Y. Maximum Rs 1.5 lakh from the F.Y.2016-17.  The value of the property should be below Rs 50 Lakh and max loan sanctioned should be Rs 25 lakh. Further, Assessee should not have any other residential house.

Section - 80G
:

Donations to the charitable institution. 100% or 50% of an amount of donation made to 19 entities (National defense fund,Prime minister relief fund etc). For Asst Yr 2014-15, National Children Fund will also get 100% deduction.

Section - 80GG
For rent paid. This is only for people not getting any House Rent Allowance. The maximum is Rs 2000 per month or Rs.60,000/- P.A.


Section - 80TTA

Individual & HUF having interest in Savings Bank Account  Rs 10000 maximum Limit

Section - 80U
Deduction in respect of permanent physical disability including blindness to taxpayer
RS 75,000 which goes to Rs 1,25,000 in case taxpayer is suffering from severe disability.

Section - 87A

Rebate to individual having low taxable income (Below Taxable Income 5 Lakh), Amount of tax or Rs 5,000.

Wednesday, 14 September 2016

The Salary Structure of all Central Govt employees is different from other State Govt employees.Recently the Central Govt has published the 7th Pay Commission and some of the State Govt also published the Pay Commission in the Year 2016 and implemented from the January 2016.

It appears that the Salary Structure and some benefits are different from the other State Govt employees. Some of the benefits can get the Central Govt employee which is not got by the State Govt employees.

In this regard, the below given Excel Based Income Tax Preparation Software can be used by the both of Central Govt employees and other State Govt employees also. The Salary Structure has made as per the Central & State Govt employees. Like as the Central Govt employees can avail the extra D.A. on the Travelling/Conveyance allowances, but the other State Govt employees could not get the same benefits.

Feature of this Excel Utility :-

  • This Excel Utility can use for Central and State Govt Employees
  • The Salary Structure has prepared as per the Central & State Employees Salary Pattern
  • Automated Calculate your Income Tax with Individual Tax Compute sheet for both of Central and State Employee
  • Inbuilt the Salary Individual Salary Structure for Central & State employees
  • Automatic Calculate the House Rent Exemption Calculation U/s 10(13A)
  • Automated Prepare the Form 16 Part A&B
  • Automated Prepare the Form 16 Part B
  • Automatic Convert the amount into the in Words without any excel formula.

Download the All in One Income Tax Preparation Software for Central & State Govt employees for the Financial Year 2016-17 & Assessment Year 2017-18. [Prepare at a time Tax Compute Sheet + Individual Salary Structure + Individual Salary Sheet + Automatic H.R.A. Exemption Calculation + Automatic Form 16 Part A&B and Form 16 Part B ]


In this Excel, Utility has all the amended Income Tax Section as per the Finance Budget 2016.