Showing posts with label All in One Income Tax preparation Excel utility for F.Y 2021-22. Show all posts
Showing posts with label All in One Income Tax preparation Excel utility for F.Y 2021-22. Show all posts

Monday, 9 August 2021

What is tax exemption under section 87A? With Automated Income Tax Preparation Software All in One in Excel for the F.Y.2021-22

What is tax rebate U/s 87 A as per Income Tax Act 1961? The government of a country imposes income tax on its citizens. The tax system for this purpose varies from country to country. In India, the system is progressive, which means your income tax liability increases according to your annual income. The higher a person's income, the higher his share of income tax, and vice versa.

 

Under this tax system, the government also provides ways to exempt people at the lower end of the income spectrum. Thus, the tax system ensures that these individuals are not overburdened by taxes and can end up with limited financial means.

 

U/s 87 A

 

These processes of tax relief are known as tax exemptions and one of the most common tax exemptions provided by the Income Tax Act is U/s 87A.

You may also, like- Automated Income Tax Preparation Excel Based Software All in One for the Non-Govt Employees for the F.Y.2021-22 [This Excel Utility can prepare at a time your Income Tax Computed Sheet as per new and old tax regime U/s 115 BAC + Individual Salary Structure as per the All Non-Govt Employees Salary Pattern + Automated Income Tax Form 12 BA + Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B]

Tax Exemption U/s 87 A

Tax exemption under section 87A

This proposal under section 87A was first introduced in 2013 and has been in effect for several years, it has recently been updated as 2019. Millions are eligible for income tax exemption of Rs12,500.

 

Who's Taxable Income less than 5 Lakhs they can entitle to these benefits(Rebates U/s 87A)as per the Income TaxAct.

.

Claim exemption under Section 87A of the Income-tax Act, 1961

You may also, like- Automated Income Tax Arrears Relief Calculator U/s 89(1) for the F.Y.2021-22 

Data Input sheet

Income Tax Form 10 E

How is the income tax rebate calculated?

To calculate discounts:

1) Calculate total income - Add income from all sources like salary, capital gain, house rent and income from other sources.

2) Find Net Taxable Income - Apply deductions under section 80 for your total income as applicable.

3) For taxable income equal to or less than Rs 5 lakh, you can claim an exemption under section 87A.

 

Subject to note about Section 87A

However, here are a few points of note that a taxpayer must keep in mind before considering income tax protection in Indiaunder section 87A:

This tax exemption under Section 87A cannot be enjoyed by non-resident Indians, who are NRIs.

You may also, like- Automated Income Tax Preparation Excel Based Software All in One for the Jharkhand State Employees for the F.Y.2021-22 [This Excel Utility can prepare at a time your Income Tax Computed Sheet as per new and old tax regime U/s 115 BAC + Individual Salary Structure as per the All Jharkhand State Employees Salary Pattern + Automated Income +Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B]

 

Salary Statement of Jharkhand state employees

Tax These tax exemptions cannot be availed by corporations, firms or HUFs.

Sen Although seniors (60 to 80 years old) can get this tax exemption, super seniors (80 years or older) cannot.

 

To provide relief and reduce the burden on small taxpayers, the government announced tax exemption plans through the introduction of Section 87A in the Income Tax Act.

Criteria for exemption under section 87A 

Under the existing provisions, any Indian resident whose income is less than Rs. 500,000 is eligible to claim tax exemption under this section Maximum Rs. 12,500/-.

You may also, like- Automated Income TaxPreparation Excel Based Software All in One for the Andhra Pradesh State Employees for the F.Y.2021-22 [This Excel Utility can prepare at a time your Income Tax Computed Sheet as per new and old tax regime U/s 115 BAC + Individual Salary Structure as per the Andhra Pradesh State Employees Salary Pattern + Automated Income + Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B]

 

Salary Structure for Andhra Pradesh Employees

Section 87A - Eligibility

To claim an exemption under section 87A:

- Be a resident personal taxpayer in India

- Under Section 80, hold the total income after deducting the eligible discount below the total discount limit i.e., below Rs.5,00,000.

 

Note:

Discounts will be given

- The calculated amount of tax will be available before adding any education or related cess.

- Available to one person only and not to any firm/company / HUF.

- Stay available for senior citizens above 60 years of age for the old tax system

- Not available for super senior citizens over 80 years of age and opting for the old tax system.

- Available under the old tax regime and the new tax system.

You may also, like- Automated Income TaxPreparation Excel Based Software All in One for the Bihar State Employees for the F.Y.2021-22 [This Excel Utility can prepare at a time your Income Tax Computed Sheet as per new and old tax regime U/s 115 BAC + Individual Salary Structure as per the All Non-Govt Employees Salary Pattern + Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B] 

Salary Structure for the Bihar State Employees

Adjustment of tax liability as opposed to rebate

This exemption can be claimed against tax liability in case of long-term capital gains under section 112 of the Income-tax Act,

 

 levying tax at slab rate. (Section 112 applies to long-term capital gains for the sale of capital assets other than equity-based schemes of mutual funds in addition to listed equity shares.) This exemption is also available against short-term capital gains tax on listed equities. Shares as well as equity-based schemes of mutual funds under Section 111A of the Act, on which tax is payable at an equivalent rate of 15%.

 

 

Automated Income Tax Preparation Excel Based Software All in One for the Govt & Non-Govt Employees for the F.Y.2021-22 

Income Tax Exemption U/s 87 A
Income Tax computed Sheet

Main Feature of this Excel Utility:-

#This Excel Utility can prepare at a time your Income Tax Computed Sheet as per new and old tax regime U/s 115 BAC

 

# Individual Salary Structure as per the All Non-Govt & Govt Employees Salary Pattern

 

# Automated Income Arrears Relief Calculator U/s 89(1) with For 10E For the F.Y.2021-22

 

# Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A)

 

#Automated Income Tax Form 16 Part A&B and Part B]

 

# Automated Income Tax H.R.A. Exemption Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B]

 

Saturday, 15 May 2021

Income Tax Calculator All in One for the Private Employees for F.Y. 2021-22 with a comprehensive list of budgets 2021

 

Income Tax Calculator All in One for the Private Employees for FY2021-22 with a comprehensive list of Budgets 2021 

Tax Slab for the F.Y.2021-22

Union Finance Minister Nirmala Sitharaman presented the Union Budget in Parliament on Monday (2ndFebruary 2021).

 

The Finance Minister gave a big boost to the healthcare and infrastructure sector in the 2021 Union Budget. There has been no change in income tax slab this year.

 

However, some important proposals have been made, which can affect a person's personal finances and tax aspects.

 

In this post, we have tried to put the important budget 2021-22 proposals in one place.

 You may also, like- Download & Prepare at a time 50 Employees Automated Form 16 Part B for the F.Y.2020-21 in Excel

Income Tax Revised Form 16 Part B


A detailed list of the proposed budget 2021-22 for F.Y 2021-22 / A.Y 2022-23

1) The latest income tax slab rate is 2020-22 April

Below is the income tax slab structure as per the new tax discipline. People who are reluctant to pay taxes under the new minimum personal income tax will have to cancel almost all the tax breaks that you are claiming in the old tax structure.

Income tax slab for the financial  year 2022-23 

Income Tax Slab for the A.Y.2022-23

2) Collection of interest tax of EPF

Until now (F.Y 2020-21), interest earned on employee-generated EPF contributions is completely tax-free.

 

However, with effect from 1 April 2021, the tax-free interest of more than Rs.5 Lacks. This also applies to private PF trusts.

 

As of  1st April 2021, Rs. 5 lakh in the Provident Fund recognized by an employee is taxable under the provisions of Bill 2021.

 

Employee If the contribution of the employee is more than Rs.5 lakhs, the interest earned on the extra money from 1st April 2021 is taxable. 

Note that additional interest of this amount (Rs. 2 lakhs) is not taxable in subsequent assessment years.

3) Maturity tax goes beyond ULIPs

Maturity obtained from the ULIP policy (taken after February 1, 2021) will be tax-free only if the total annual premium on them does not exceed Rs. 2.5 lakhs.

You may also, like- Download & Prepare at a time 50 Employees Automated Form 16 Part A&B for the F.Y.2020-21 in Excel 

Income Tax Form 16

Thus, gains in ULIP equity funds (e.g. for exempt ULIPs) will be taxed at 15% (short term) or 10% (long term). If it is a ULIP debt fund (for exempt ULIPs), the profits will be taxed at your applicable slab rate (short term) and the index for long-term profits.

There will still be a tax deduction for UTIP from ULIP regardless of the amount of premium paid. The proposal does not affect the tax treatment of death benefits.

 

4) There is no ITR filing for senior citizens

Senior citizens aged 60 years and above who have only pension/interest income from bank/post office are not required to file income tax returns. Although banks will waive the applicable duty. The criteria for exemption from filing ITR from 1st April 2021, are:

 

Senior Citizen should be a resident and must be 75 years of age or older for the financial year for which tax must be paid.

He/she must get a pension and interest income from the same bank.

Your banker will deduct the taxes applicable to your income.

Only some banks are accepted for this purpose.

Bank In this case the bank has to make an announcement.

 

5) IT Exemption for Paying Interest on Home Interest (Sector 80EEA)

An additional income tax exemption of Rs 2.5 lakh on affordable loans will be extended for one more year, u / s 80EEA. The Interest exemption of Rs 1.5 lack (US 80 EEA) may be increased for the loan is taken up to  March 31, 2022. This Exemption cannot be claimed if you choose a new tax slab.

 

Additional tax exemption of Rs. 1.5 Lacks only for first-time homeowners. In that case, if you have an existing residential property, you cannot claim the tax benefit U / S 80EEA.

 

Note that your property should have a maximum stamp duty value of Rs. 45 lakhs (stamp duty value). Only such property falls under the category of ‘affordable housing. Note that this is the standard of registration and not the "standard of contract". Most property deals will have white and black money ratios (although this is not legally allowed).

Download Automated Income Tax Preparation Excel Based Software All in One for the Non-Government (Private) Employees for the Financial Year 2021-22 and Assessment Year 2022-23U/s 115BAC 

Data Input Sheet
Salary Structure

Tax Computed Sheet
Form 16 Part A&B

Form 16 Part A

Form 12 BA

Feature of this Excel Utility:-

 

1) This Excel Utility Prepare Your Income Tax as per your option U/s 115BAC perfectly.

 

2) This Excel Utility has all amended Income Tax Section as per Budget 2021

 

3) Automated Income Tax Form 12 BA

 

4) Automated Calculation Income Tax House Rent Exemption U/s 10(13A)

 

5) Individual Salary Structure as per the Non-Government (Private) Concern’s Salary Pattern

 

6) Individual Salary Sheet

 

7) Individual Tax Computed Sheet

 

8) Automated Income Tax Revised Form 16 Part A&B for the F.Y.2021-22

 

9) Automated Income Tax Revised Form 16 Part B for the F.Y.2021-22

 

10) Automatic Convert the amount into the in-words without any Excel Formula