Showing posts with label Tax Rebate Rs 12500/- U/s 87A for F.Y. 2019-20. Show all posts
Showing posts with label Tax Rebate Rs 12500/- U/s 87A for F.Y. 2019-20. Show all posts

Thursday, 19 March 2020

Download Automated All in One TDS on Salary Govt & Non-Govt Employees for the F.Y. 2019-20 with Automated Arrears Relief Calculator U/s 89(1) with Form 10E for F.Y. 2019-20


Download All in One TDS on Salary for Govt & Non-Govt Employees for the F.Y. 2019-20 With H.R.A. Exemption Calculation U/s 10(13A) + Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E for F.Y.2019-20 + Automated Revised Income Tax Form 16 Part A&Band Form 16 Part B for F.Y. 2019-20




 The feature of this Excel Utility is the following:-

1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the Govt and All of the Non-Govt(Private) employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format
8) Automated Arrears Relief Calculator U/s 89(1) with Form 10E from F.Y. 2000-01 to F.Y. 2019-20

Friday, 21 February 2020

Automated Income Tax Software All in One for Govt & Non-Govt Employees for the F.Y. 2019-20

Section 87A provides an income tax rebate to a resident individual having prescribed income. This rebate is also available to senior citizens. However, for a Super Senior Citizens, this deduction becomes irrelevant.
 For AY 2019-20 and AY 2020-21, the maximum income tax rebate is Rs.2,500/- and Rs.12,500/- respectively.
It is provided before the calculation of Cess of 4%.

Rebate under section 87A for AY 2019-20

Conditions to be satisfied

Under the following conditions rebate is allowed:
  1. You must be Resident Individual
  2. Total income* is up to Rs.3,50,000/-
If both the above conditions are satisfied, rebate under section 87A will be available.
*Total income is explained at the bottom of this article

Maximum Rebate

Rebate shall be lower of the following:
  1. Income tax before the rebate
  2. 2,500
Therefore, the maximum rebate for AY 2019-20 is Rs.2,500/-

Rebate under section 87A for AY 2020-21 

In Budget 2019:

The tax rebate has been increased to Rs.12,500/-.
Through this amendment, every resident taxpayer having total income* up to Rs. 5 lakh won’t have to pay income tax.

Conditions to be satisfied

Under the following conditions rebate is allowed:
  1. You must be Resident Individual
  2. Total income* is up to Rs.5,00,000/-
If both the above conditions are satisfied, rebate under section 87A will be available.

Maximum Rebate

Rebate shall be lower of the following:
  1. Income tax before the rebate or
  2. 12,500/-
Therefore, the maximum rebate for AY 2020-21 is Rs.12,500/-

Download All in One TDS on Salary for Government and Non-Government Employees for the F.Y 2019-2020 and A.Y 20120-2021 With Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E for F.Y. 2019-20


 The feature of this Excel Utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the Govt and All Non-Govt(Private) employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format
8) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E for F.Y. 2019-20

Tuesday, 26 November 2019

Download Automated All in One TDS on Salary Govt & Non-Govt Employees for the F.Y. 2019-20 With Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E for F.Y. 2019-20


Download All in One TDS on Salary for Govt & Non-Govt Employees for the F.Y.2019-2020 + H.R.A. Exemption Calculation U/s 10(13A) + Automated Arrears Relief Calculator U/s 89(1) with Form 10E




 The feature of this Excel Utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the All of Non-Govt(Private) employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format
8) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E

Monday, 25 November 2019

Download Automated All in One TDS on Salary Bihar State Govt Employees for the Financial Year 2019-2020 and Assessment Year 20120-2021.


As per the Finance Budget 2019, some Important Income Tax Section and Income Tax Rebate has changed. The Major modification including the Income Tax Slab Rate for the F.Y. 2019-20 is given below.

1) Income Tax Slab for the Financial Year 2019-20 is Same as Previous F.Y.2018-19
2) Raised the Income Tax Rebate U/s 87A up to Rs. 12,500/- who's Taxable Income less than 5 Lakh.
3) Raised the Income Tax Standard Deduction U/s16(ia) from Rs. 40,000/- to  50,000/-

4) Raised the Tax Exemption from the Bank/Post Office Savings Interest from 10,000/- to 50,000/-
5) Introduce New Section 80EEA for New Home Loan Interest Rs.1.5 Lakh.

Download All in One TDS on Salary for BiharState Govt Employees for the Financial Year 2019-2020 and Assessment Year20120-2021 With H.R.A. Exemption Calculation U/s 10(13A)

The feature of this Excel The utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the Bihar State Govt employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format




Saturday, 23 November 2019

Download Automated All in One TDS on Salary for West Bengal Govt Employees for the Financial Year 2019-2020 and Assessment Year 20120-2021

As per the Finance Budget 2019, some Important Income Tax Section and Income Tax Rebate has changed. The Major modification including the Income Tax Slab Rate for the F.Y. 2019-20 is given below.

1) Income Tax Slab for the Financial Year 2019-20 is Same as Previous F.Y.2018-19
2) Raised the Income Tax Rebate U/s 87A up to Rs. 12,500/- who's Taxable Income less than 5 Lakh.
3) Raised the Income Tax Standard Deduction U/s16(ia) from Rs. 40,000/- to  50,000/-
4) Raised the Tax Exemption from the Bank/Post Office Savings Interest from 10,000/- to 40,000/-
5) Introduce New Section 80EEA for New Home Loan Interest Rs.1.5 Lakh.

Download All in One TDS on Salary for WestBengal Govt Employees for the Financial Year 2019-2020 and Assessment Year20120-2021 With H.R.A. Exemption Calculation U/s 10(13A) + Automated Form 16Part A&B and Form 16 Part B ( New Revised Format of Form 16)

The feature of this Excel The utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the West Bengal Govt employee’s Salary Pattern (AS PER ROPA 2019)
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format

Sunday, 17 November 2019

Download Automated All in One TDS on Salary Bihar State Govt Employees for the Financial Year 2019-2020 and Assessment Year 20120-2021.


As per the Finance Budget 2019, some Important Income Tax Section and Income Tax Rebate has changed. The Major modification including the Income Tax Slab Rate for the F.Y. 2019-20 is given below.

1) Income Tax Slab for the Financial Year 2019-20 is Same as Previous F.Y.2018-19
2) Raised the Income Tax Rebate U/s 87A up to Rs. 12,500/- who's Taxable Income less than 5 Lakh.
3) Raised the Income Tax Standard Deduction U/s16(ia) from Rs. 40,000/- to  50,000/-

4) Raised the Tax Exemption from the Bank/Post Office Savings Interest from 10,000/- to 50,000/-
5) Introduce New Section 80EEA for New Home Loan Interest Rs.1.5 Lakh.

Download All in One TDS on Salary for BiharState Govt Employees for the Financial Year 2019-2020 and Assessment Year20120-2021 With H.R.A. Exemption Calculation U/s 10(13A)

The feature of this Excel The utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the Bihar State Govt employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format




Tuesday, 5 November 2019

Download Automated Income Tax Preparation Excel Based Software All in One for the Govt & Non-Govt Employees for F.Y. 2019-20 With Deduction Under Section 87A


Taxes made easy’, was always an ever promoted agenda of the Indian government. With the announcement of the Budget 2019-2020, the government briefed for tax goals of the economy and the essential amendments required in the present direct tax laws. Several changes to the tax rules were proposed for the coming year 2019-2020. One such key amendment was made under Section 87A of the Income Tax Act.
As per the Income-tax Act, 1931 any individual being a resident of India, having a taxable income below the exemption limit is entitled to claim a rebate under Section 87A.
 Section 87A – Basics
Section 87A in the Income-tax Act was proposed by the Finance Bill of 2013 to provide a basic tax rebate to the taxpayers having a low-income background. As per the existing provisions, any individual whose income lies below Rs 3,50,000 is eligible to claim a tax amount rebate under this section. The section states for the tax rebate available to an Individual taxpayer which can be 100% of the total tax amount calculated of his total income of Rs 2500 whichever is lower.
Budget 2019 Update: Adding numerous tax benefits for the taxpayer, the the government further hiked the minimum tax rebate limit to Rs 12,500 from Rs 2500 under Section 87A.

Section 87A – Eligibility

To claim rebate under Section 87A one should:
– Be a resident individual taxpayer of India
– Hold total income after deducting eligible deductions under Section 80, below the total exemption limit.
Note: The rebate shall;
– be available on an amount of tax calculated before adding any Education or related cess.
– be available to only an Individual & not to any Firm/Company/HUF. Senior citizens above 60 years can also claim an exemption under this section.


Thus, as applicable from FY 2019-2020, an individual taxpayer having income below Rs 5,00,000 becomes eligible to claim tax rebate available under Section 87A.


The feature of this Excel The utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the Government and All of Non-Govt(Private) employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format
8) Automated Arrears Relief Calculator U/s 89(1) with form 10e for the F.Y. 2019-20

Monday, 4 November 2019

Download Excel based – Income Tax Preparation All in One for the Bihar State Govt Employees for FY 2019-20 [AY 2020-21]


Highlights of Changes in FY 2019-20 in Income Tax

Standard deduction enhanced for salaried persons from Rs. 40,000 to Rs 50,000 in FY 2019-20.

  1. Income tax slabs remain unchanged as per previous year.
  2. Tax rebate (u/s 87A) enhanced by  Rs 12500 from  Rs 2500, taxable income after all deductions/exemptions up to  Rs 5 lakhs is Tax-free.
  3. TDS deduction on fixed deposits threshold increased from existing  Rs 10,000 to  Rs 40,000.
  4. Additional section 80EEA on home loans on purchase of an affordable home is introduced from FY 2019-20 for Rs 1.5 Lakhs.
  5. Additional section 80EEB on Auto loans on purchase of Electric vehicles are introduced from FY 2019-20 for Rs 1.5 Lakhs.


 The feature of this Excel The utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the Bihar State Employees Salary  Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format

Sunday, 3 November 2019

Download Automated Income Tax Preparation Excel Based Software for Govt. & Non-Govt. Employees for the F.Y. 2019-20 With Section 80EEA Deduction for interest paid on home loan – Housing for All Tax Payers.


Section 80EEA introduced in July Budget 2019 with the objective “Housing for all”. The government has extended the benefit for the FY 2019-20.
The main motive to the introduction of the section is to provide affordably housing finance for every class in common man and to enable the home buyer to have low-cost funds.
In this article, you will get all the features and benefits of this section for the Indian economy
Exemption u/s 80EEA comes with some of the conditions to get full benefits of affordable housing finance.
  • A loan was taken from a financial institute or a housing finance company for buying a residential house property between April 1, 2019, to March 31, 2020.
  • Only first time home buyer or the applicant have never applied for a home loan or not having any residential house on his name can avail the benefit of this section.
  • The actual value (stamp duty value) of the house should be 45 Lakhs or less.
  • The applicant is eligible if the carpet area of metropolitan cities of Bengaluru, Chennai, Delhi National Capital Region (limited to Delhi, Noida, Greater Noida, Ghaziabad, Gurgaon, Faridabad), Hyderabad, Kolkata, and Mumbai (the whole of Mumbai Metropolitan Region) does not exceed 645 Sq Feet.
  • The carpet area of Non-metropolitan cities must not exceed 970 Sq Feet.
If you are able to satisfy the conditions of both Section 24 and Section 80EEA of the Income Tax Act, you can claim the benefits under both the sections.

Download Automated Income Tax Prepare Excel Based Software only for Non-Govt. (Private) Employees for F.Y. 2019-20

Section 80EE for FY 2018-19 or AY 2019-21


For FY 2018-19 or AY 2019-20, the first-time Home Buyers can claim an additional Tax deduction of up to Rs 50,000 on home loan interest payments u/s 80EE. The below criteria has to be met for claiming tax deduction under section 80EE.
  • The home loan should have been sanctioned during/after FY 2016-17.
  • Loan amount should be less than Rs 35 Lakh.
  • The value of the house should not be more than Rs 50 Lakh &
  • The home buyer should not have any other existing residential house in his name.
Deduction under Section 24 and section 80EE/80EEA, the only difference is your possession, section 80EE/80EEA does not require possession of your house.

Income Tax Benefits on Home loan


Earlier income tax benefit on the home loan can be claimed into three parts. Home loan consists of Principal amount and interest amount, and the EMI is calculated under certain home loan calculation formulae, which results in higher interest repayment and lower principal repayment in their initial stage and in the middle of your tenure both (principal and interest) amount are equal and the driven to the bottom bring your principal repayment with higher ratio and interest repayment with lower.

Section 80C – Home Loan principal repayment

How much principal repayment you have made is clearly mentioned in your home loan account statement, all you have to use section 80C, which allow you to get tax exemption up to Rs 1.5 Lakhs (maximum) for your principal repayment.

Section 24 – Home Loan interest repayment

Home Loan Intrest repayment up to Rs 2 Lakhs is exempted u/s 24B of the Income-tax act.

Section 80EE – Additional Home Loan interest repayment
This section 80EE introduced for the first time home buyer opts for a home loan, the first-time Home Buyers can claim an additional Tax deduction of up to Rs 50,000 on home loan interest payments u/s 80EE, This section is already available in ITR form.
There are some criteria to meet the benefit under this section.
  • Section 80EE introduced from FY 2016-17, any loan sectioned beyond 2016-17.
  • Loan amount must be less than 35 Lakhs.
  • The Value of the House against home Loan is processed should not be more than Rs 50 Lakh.
  • The Home Laon applicant never have in possession of any other residential house in his name.

New Section 80EEA for FY 2019-20 [AY 2020-21]

This section overlap section 80EE and the introduction of this section raise interest payment exemption limit by Rs 1.5 Lakhs.
This tax benefit will be available from 1st April 2020 (AY 2020-21) and till the end of the home loan tenure (closure).

 

Section 24 vs Section 80EEA


Although both the section available for the taxpayer for interest payment exemption of Home Loan, beyond this there is some minor difference you must aware of:
  • If the applicant with a family resides in the house property or its vacant or let out for rent – In all scenario, The deduction of up to Rs 2 Lakh applies.
  • In case loan taken from friends or relative and interest paid to them also allow you for exemption u/s 24, In the case of section 80EEA the home loans from banks and approved financial institutions only.
  • To claim u/s 24, you must have possession of your house, on the other hand, Section 80EE and 80EEA do not impose any requirement of possession, as soon as you start your interest repayment you can claim for exemption.
In my personal opinion, only a few loan borrowers can get 100% benefit from this section, because there is a lot of hurdle in between. I recommend read and understand this section completely and calculate Income tax return for FY 2019-2020 [AY 2020-2021].

Download All in One TDS on Salary for Govt.and Non-Govt. Employees for the Financial Year 2019-20 and Assessment Year 2020-2021With H.R.A. Exemption Calculation U/s 10(13A) + Automated Arrears ReliefCalculator U/s 89(1) For f.Y. 2019-20

The feature of this Excel Utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the Govt & Non-Govt (Private) employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format
8) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10e from the F.Y. 2000-01 to F.Y. 2019-20

Monday, 28 October 2019

Free download Automated Income Tax Preparation Excel Based Software All in One for Bihar State Govt Employees With Income Tax Section 80CCD +80CCD(1) + 80CCD(1B) +80CCD(2) For F.Y. 2019-20


The 80CCD deduction for AY 2019-20 can be divided into three different categories:
  • 80CCD (1): You can avail of this deduction irrespective of whether you're in employment or self-employed on the amount deposited under a pension scheme notified by the Central Government (NPS deduction for AY 2018-19). The deduction allowed in this section is lower of the following 3 amounts:
    1. 10% of your Salary (Basic salary+D.A) (in case you're in employment) or 20 % of your Gross Total Income (in case you're self-employed)
    2. Limit left under section 80CCE i.e. Rs 1,50,000 - deduction u\s 80C - deduction u\s 80CCC.
    3. Actual Amount paid under eligible NPS.


·         80CCD(1B): You can claim an additional deduction of up to Rs. 50,000 under this section for investment in  NPS Scheme. This is in addition to 80CCD (1).
·         80CCD (2): Sec 80CCD(2) deduction for AY 2020-21 can be availed by you if you're an employee and your employer makes a contribution towards your Contribution of Pension Fund

Download All in One TDS on Salary for Bihar State Govt Employees for the F.Y.2019-20 & Ass Year 2020-21 With H.R.A. Exemption Calculation U/s 10(13A) 

 The feature of this Excel Utility is the following:-

1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the Bihar State Govt employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format

Sunday, 27 October 2019

Download Automated Income Tax Preparation Excel Based Software All in One for Govt & Non-Govt Employees for F.Y. 2019-20 With Gratuity Calculator Exemption Limit and Calculation [AY 20120-21]

Gratuity refers to the money received by an employee from his employer at the time of:
  1. Retirement
  2. Resignation
  3. Termination
  4. Death
Gratuity is payable only to persons who have been employed for 5 years or more with the employer. In case of death, disease or accident, the time limit of 5 years is not applicable.
Income tax rule is different for government employees and non-government employees. This money is fully exempted in the hands of central or state government employees. [Discussed in detail]
In this article, we will cover the taxation of gratuity in detail, its exemption, and calculation.

Gratuity Received by Government Employee [U/s 10(10)(i)] 

The gratuity received by employees of the following are exempted from income tax:
  1. State government
  2. Central government
  3. Local Authority like Municipality
This the exemption is not available to the employees of a statutory corporation like Airport Authority of India (AAI), NHAI, FCI, etc.
Further, in case of the death of government employees, the gratuity received by the widow or dependent children shall not be fully exempted. [covered under section 10(10)(iii)]

Gratuity Received by Non-Government Employee

Income tax rule further divided non-govt employees into two-part:
  1. Covered under Payment of Gratuity Act, 1972
  2. Not covered under the Payment of Gratuity Act, 1972
From 29th March 2018, gratuity up to Rs.20 lakh is exempted in the hands of private and public sector employees. Previously it was Rs. 10 lakh.

1. Gratuity Exemption Limit for Non-Government Employee Covered under Gratuity Act [u/s 10(10)(ii)]

Employees of a factory, mine, oilfield, plantation, port, and the railway company, shop and other establishments with 10 or more employees at any time during the preceding 12 months are covered under the Payment of Gratuity Act.
Once an establishment is covered, this act will apply even if the number of employees falls below 10.
In this case, gratuity will be partially exempted and the remaining amount will be taxed as Salary Income.
The exemption, in this case, will be lower of the following amounts:
  1. Last drawn Monthly Salary (Basic+DA) x no. of years of employment* x 15**/26
  2. 20,00,000/- [When gratuity received on or after 29-03-2018]
  3. 10,00,000/- [When gratuity received before 29-03-2018]
  4. Gratuity actually received
*Number of the year of employment should be rounded off to the nearest years. Example: For 20 years 7-month service takes employment years like 21 years.
**7 days instead of 15 days in case of employees of a seasonal establishment.
Example:
Mr. Ram a brick factory worker who’s Basic Pay  Rs.30000 + D.A.Rs.15000 He has completed 19 years 2 months of employment. His Date of Retirement is  On 31st December 2018 OR Service of length is 19Years 6 months 1Day i.e. 19 years.
Find the exempted and taxable gratuity value for FY 2019-20.
Solution:
Calculation of exempted and taxable Gratuity amount
Particulars
Amount
Least of the following will be exempted:

Monthly salary+D.A.* x 19 (employment years) x 15/26
5,60250/-

Prescribed limit
3000000

Gratuity actually received
5,60250/-

Gratuity Calculator inExcel for Exemption Limit for Non-Government Employee under Gratuity Act[u/s 10(10)(iii)]

*Mr. Ram is received. Actual Gratuity 5,60,250/-

2.Gratuity Exemption Limit for Non-Government Employee Not-Covered under Gratuity Act [u/s 10(10)(iii)]

Many employers provide gratuity benefits to their employees voluntarily.
In this case, the income tax exemption formula is different. It is lower of the following amount:
  1. Last 10 month’s average Salary*(Basic+DA+ fixed % of commission on sale) x 0.50 x no. of years of employment**
  2. 20,00,000/- [This value is for gratuity received on or after 29-03-2018]
  3. 10,00,000/- [This value is for gratuity received before 29-03-2018]
  4. Gratuity actually received
* The last 10 months doesn’t include the month of retirement, termination or death.
*Number of the year of employment should not be rounded off to the nearest years. Example: For 20 years 7-month service takes employment years like 20 years. 
Note for section 10(10)(iii):
The above formula also applies to the gratuity received by the widow, children or dependents of the dead employee.
For calculating exemption, in this case, the status of the dead employee is irrelevant.
The un-exempted portion of gratuity value will be taxable in the hands of the recipient as Income from other sources.

Download All in One TDS on Salary for Govt& Non-Govt Employees for the F.Y.2019-20 and A.Y. 2020-21 With H.R.A.Exemption Calculation U/s 10(13A) + Automated Form 12 Ba for f.Y. 2019-20 +Gratuity Calculator

 
 

The feature of this Excel The utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the All of Govt & Non-Govt (Private) employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format
8) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10e from F.Y. 2000-01 to 2019-20
9) Automated Gratuity Calculator for Income Tax Exemption [U/s 10(10)(iii)]