Showing posts with label Income Tax Form 12 BA in Excel. Show all posts
Showing posts with label Income Tax Form 12 BA in Excel. Show all posts

Monday, 18 October 2021

Tax benefits for F.Y.2021-22 as per Budget 2021. With Automatic Income Tax Preparation Software All in One in Excel for the Non-Govt (PSU) Employees for F.Y.201-22

Income Tax


Tax benefits for the F.Y2021-22 as per Budget 2021. Income Tax Reduction for A.Y 2022-23: See the list of tax deductions below that you can claim for various payments, income and investments.

The following exemption is available for opting for the Old Tax Regime only.

 

1. Income from home property

Exemption from house building loan Interest U/s 24 B Maximum Rs.2 Lakh for self-acquired property

 

For those who have chosen to file a return under the new tax system, this exemption from income from the home property will not be available from this year.

 

2. Life Insurance Premium paid or  P.F. or PPF, Pension Scheme U/S 80C Maximum Rs.1.5 Lakh. If you opt-in new tax regime, you can not avail of this exemption U/s 80C

 

U/s 80CCC, For the pension scheme in the annual plan.

U/s 80 CCD (1), Central Govt Pension Scheme which contributes by the employee. 

If you choose the old tax regime, then you can claim the following exemptions like as the previous financial year 2020-21 

You may also, like- Automated Income Tax Salary Arrears Relief Calculator U/s 89(1) with Form 10 E from theF.Y.2000-01 to F.Y.2021-22(Updated Version)

Income Tax form 12 BA in Excel

1. Income from home property

According to the income tax Section 24(B), the maximum home loan interest deduction is Rs 2 lakh for self-acquired property.

For those who have chosen to file a return under the new tax system, this exemption from income from the home property will not be available from this year.

 

 

2. Life Insurance Premium paid or paid for  P.F, PPF, Pension Scheme U/s 80C

 

Under section 80CCC, a claim for LIC or any other insurer's annual plan for a pension scheme may be claimed.

 

Under Section 80 CCD (1), a claim for payment of money paid under the Central Government Pension Scheme can be made.

 

 

Note: Under Section 80C, Section 80CCC, Section 80 CCD (1), a total lump sum exemption of only Rs 1.5 lakh can be claimed.

 

3. U/s 80CCD(1B) additional deduction Rs. 50,000/-for the  Pension Scheme

 

Under Section 80 CCD2, for contribution by the employer to the employee's pension fund, However, there are two conditions:

If the employer is PSU, state government or others, the deduction limit is 10 %  and if the person is the central government then the deduction will be 14% of salary.

 

4. Pay for health insurance premiums

Under section DD, waivers may be claimed for health insurance premiums and payments made for preventive health check-ups. However, there are several limitations:

 

For self-spouse or dependent children or patent: Rs. 25,000 discount can be claimed and senior citizens above 60 years of age can get a benefit of Rs.50,000/- U/s 80D. Although premiums are not paid on health insurance coverage, deductions may be claimed for the medical expenses of a senior citizen.

 

5. Pay for maintenance/treatment of disabled dependents U/s 80D

 a rebate of up to Rs.25,000/- for below 80% and above 80% disabled can get benefit Rs.1,25,000/-

 

6. Pay for treatment

Under Section 80 DD (1B), deductions of up to Rs.40,000/- and for the Senior Citizen Rs. 1,00,000/- can be avail.

 

7. Pay interest on education loan U/s 80E

U/s  80E, a higher education loan can be taken on one's own or a relative's waiver of the total amount paid for interest payments.

 

8. Paying rent for those who are not getting HRA from the employer, they can get a benefit on the house rent Maximum Rs.60,000/- P.A.

Download Automated IncomeTax 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

 

Tax benefits in the f.Y.2021-22
Tax benefits at F.Y.2021-22 as per Budget 2021


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-Govt(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 in to the in-words without any Excel Formula

Saturday, 12 September 2020

Tax Section 80C - With Automated Income Tax Excel Based Software All in One for the Private Employees for the F.Y.2020-21 as per New Section 115 BAC


Section 80C explained: Did you realize that Section 80C, under the Income Tax Act 1961, encourages you to lessen the tax trouble by allowing a deduction from the total taxable incomein a financial year? Section 80C is a popular decision in the event that you want an answer to the inquiry: How might I save tax on salary?



Section 80C explained: Did you realize that Section 80C, under the Income Tax Act 1961, encourages you decrease the tax trouble by allowing a deduction from the total taxable income in a financial year? Section 80C is a popular decision on the off chance that you want an answer to the inquiry: How might I save tax on salary? Under Section 80C of the Income Tax Act 1961, taxpayers can claim deduction advantage on payments, commitments, or investments in a way determined by the Income Tax law. These include payment for extra security premium, commitment to any perceived opportune reserve and superannuation support, membership to National Savings Certificate, commitment to ULIP, Open Fortunate Store (PPF), Sukanya Samriddhi Yojana, 5-year tax-saving fixed store plans offered by banks, among others.

What is Section 80C breaking point?

In one financial year, the maximum amount of deduction under Section 80C or the Section 80C breaking point is Rs 1.5 lakh. To make the greater part of the arrangement, you have to restrict your total commitment to determined items qualified for deduction under Section 80C.

Download Automated Income TaxExcel Based Revised Form 16 Part A&B for the F.Y.2020-21 and A.Y.2021-22 [ This Excel Utility Prepare at a time 50 Employees Form 16 Part A&B as per New and Old Tax Regime U/s 115 BAC for F.Y.2020-21]



 What investments are secured under 80C? Does a fixed store go under 80C? Deduction list:

A portion of the popular investments/payments qualified for tax deductions under Section 80C are:

           Investment in five-year bank fixed deposit, with a maximum score cutoff of Rs 1.5 lakh in a financial year

           Investment in five-year mail centre time store, Senior Residents Savings Plan

           Investment in EPF or into voluntary opportune reserve

           Investment in PPF

           Investment in National Savings Certificates

           Contribution to NPS Level II account made by Central Government Workers

           Contribution to Sukanya Samriddhi Account

           Payment for Life coverage Strategy (including ULIP) a premium of an individual and/or his or companion or any youngster

           Contribution to any approved superannuation finance

           Contribution to Unit-linked Insurance Plan (ULIP) 1971 and ULIP of LIC Mutual Reserve; Commitment to an approved annuity plan of LIC

           Payment for subscribing to ELSS of a mutual store; Commitment to informed annuity support set up by mutual reserve or UTI

           Repayment of Housing Loan Principal; the amount paid for stamp obligation, registration expense and so forth.

           Payment of educational expenses – For full-time education of his/her youngsters (maximum of two kids.) in any college, school, school, or other educational institution located in India.

Section 80CCC:

When U/s 80C choices through which taxpayers can claim deductions to lessen their tax trouble, Section 80CCC specifically accommodates deductions against the commitment to certain annuity reserves. These assets could be set up by LIC or any other insurer under a benefit conspire approved by IRDAI. Under Section 80CCC, one can claim deduction up to Rs 1.5 lakh on payments made for continuing an existing plan or buying another approach in a financial year. Notwithstanding, this deduction limit is clubbed with the cutoff gave in Section 80C and Section 80CCD. Conclusion, the amount for which one can claim tax deduction under all three sections (Section 80C, Section 80CCC, Section 80CCD) cannot be more than Rs 1.5 lakh per financial year.
 







Feature of this Excel Utility:-

1) This Excel utility prepares and calculates your income tax as per the New Section 115 BAC (New and Old Tax Regime)

2) This Excel Utility has an option where you can choose your option as New or Old Tax Regime

3) This Excel Utility has a unique Salary Structure for Non-Government Employee’s Salary Structure.

4) Automated Income Tax Form 12 BA

5) Automated Income Tax Revised Form 16 Part A&B for the F.Y.2020-21

6) Automated Income Tax Revised Form 16 Part B for the F.Y.2020-21

7) Individual Salary Sheet

Sunday, 12 January 2020

Download at a time 50 Employees Automated Income Tax Form 16 Part B With Form 12 BA For Financial Year 2019-20 ( Modified Format of Form 16 Part B [ As per the CBDT Notification No.36/2019 Dated 12/04/2019


The CBDT has changed the format of Income Tax Form 16 Part B for the Financial Year 2018-19 since the 12 May  2019. This Format is more explore the employee’s Salary Details.
 

 Download And Prepare At a Time 50 Employees  Automated Income Tax Form 16 Part B With Form 12 BA (Modified Format) [This Excel Utility Prepare At a time 50 Employees Form 16 Part B With Form 12 BA in New Format for A.Y. 2020-21]




  The main feature of this Excel Utility:-

1)   Prepare At time 100 Employees  Excel Based  Form 16 Part B With Form 12 BA ( Modified Format of Form 16 Part B Vide CBDT Notification No.36/2019 Dated 12/04/2019 ]
2)   All the Amended Income Tax Section have in this utility as per Budget 2019
3)   You can print individual Form 16 Part  B with Form 12 BA
4)   Most easy to install just like an Excel File
5)   Easy to Fill the all column
6)   Automatic Convert the Amount to the In-Words

Sunday, 22 September 2019

Applicability of Income Tax Form 12BA With Automated Income Tax Form 16 Part B with 12 BA for F.Y. 2019-20 in new format


This is submitted along with Form 16. Your income tax details are mentioned in Form 16 while Form 12BA has details regarding the perquisites given to you by your company. Form 12BA is only an additional document to be provided specifically for perquisites.
Details on salary paid, bonuses & commission, monetary & non-monetary benefits are included in Form 12BA.
 Details on dearness allowance which does not enter computation of superannuation or retirement benefits of concerned employee, employer’s contribution to provident fund, exempt allowances, value of perquisites, payments which are specifically excluded from being considered as perquisites, lump-sum payments received at the time of termination of service or superannuation or voluntary retirement such as gratuity, severance pay, leave encashment, voluntary retrenchment benefits, commutation of pension and similar payments are excluded in Form 12BA.
The Income Tax Act has defined rules for calculating the correct financial value of these perquisites. The value of these payments is represented in Form 12BA and also the amount that is taxable for the individual employed for availing these perquisites. Thus, Form 12BA is an additional form that employees receive from their employer in addition to Form 16. ‘Value of Perquisites u/s17(2) of the Income Tax Act’ is already included in Part B of Form 16.
Note: Form 12BA is required to be issued even in the absence of any perquisite given to an employee. This is important as an employer can mention in Form 12B that no perquisites have been given to a respective employee.

Download And Prepare At a Time 50 Employees  Automated Income Tax Form 16 Part B with Form 12 BA (Modified Format) [This Excel Utility Prepare At a time 50 Employees Form 16 Part B with Form 12 BA in New Format for A.Y. 2020-21 )

The main feature of this Excel Utility:-

1)   Prepare At time 100 Employees  Excel Based  Form 16 Part B with 12 BA ( Modified Format of Form 16 Part B Vide CBDT Notification No.36/2019 Dated 12/04/2019 ]
2)   All the Amended Income Tax Section have in this utility as per Budget 2019
3)   You can print individual Form 16 Part Part B with 12 BA
4)   Most easy to install just like an Excel File
5)   Easy to Fill all column
6)   Automatic Convert the Amount to the In-Words
7)   Automated Income Tax Form 12 BA