Income tax deductions under section 80 CCD (1B)| With Automated Income tax Preparation Excel Based Software All in One for the Govt and Non-Govt Employees for the F.Y.2022-23

Table of Contents

Income tax deductions under section 80 CCD (1B)| Income tax is required for all citizens of India who

 are required to pay income tax in accordance with the rules and regulations of the Income Tax Act

 1961. But this does not mean that you have to pay tax on all income received by you in this financial

 area. year. There are several provisions in the Income Tax Act that allow you to claim deductions from

 certain investments and expenses.

Therefore

Plan your taxes to save your income

In other words, You may carefully be planning your taxes, you can save a maximum amount on your tax liability and create an extra source of income for yourself. With the dual benefit of tax savings and income generation, these deductions provide significant benefits. From time to time, the government introduces new deductions or amendments, which you should keep a close eye on. However, one such deduction available to you is CCD Sec 80 (1B), which applies to contributions made to the NPS.

Download and Prepare at a time 100 Employees Form 16 Part B for the Financial Year 2021-22

Income Tax Form 16 Part B

NPS or the National Pension System is a pension scheme available to both government employees and individuals. NPS is one of the most popular options available for people looking to set up a retirement fund along with a regular monthly income. For instance, Money deposited with NPS is invested in a variety of securities and investment opportunities, including the stock market. It is widely regarded as one of the cheapest equity investment options. Since returns are directly related to market performance, there is no guarantee of any particular value, but over time, NPS returns become one of the highest in the market.

Above all,

Should you know that Two Types of NPS Accounts

In addition, two types of NPS accounts: NPS Level 1 and NPS Level 2.

Level 1 account: has a fixed lockout period until the subscriber reaches the age of 60. Withdrawals are entitled to be subject to certain conditions. Contributions made in Tier 1 are tax-free and deductible in accordance with Section 80CCD(1) and Section 80CCD(1B). You can invest up to Rs. 2 lakh in NPS Level 1 account and claim a deduction from the total amount i.e. rupees. 1.50 lakh under section 80CCD(1) and Rs. 50,000 under section 80CCD (1B).

After that, Level 2 Account: This is a mandatory voluntary savings account that allows subscribers to withdraw money as they wish. But a contribution made to a Tier 2 account is not eligible for a tax deduction. In order to open a Tier 2 account, you must first open a Tier 1 account. Similarly, contributing to NPS is now subject to a tax exemption (EEE) regime where the amount contributed to NPS, income received and redemption value are all tax-deductible. rid. According to the latest recommendations, you can withdraw up to 60% of the amount at maturity and must reinvest the remaining 40% to buy an annuity that will give you a regular monthly income.

Download and Prepare at a time 100 Employees Form 16 Part A&B for the Financial Year 2021-22

Income Tax Form 16 Part A and B

What is section 80CCD (1B)

In conclusion, Section 80CCD of the Income Tax Act deals with deductions offered to individuals who contribute to the NPS. Under section 80CCD, prior to 2015, an individual was eligible to claim a tax deduction of up to Rs. 1 lakh against contributions made to NPS. As per the 2015 budget, the government increased the maximum amount payable to the NPS to Rs. 1.50 lakh per year. In addition, a new subsection 1B was introduced which offered an additional deduction of up to Rs. 50,000/- for contributions made by individual contributors to the NPS.

Therefore, an Extra deduction in the amount of Rupees Fifty Thousand pursuant to section 80CCD (1B) available for valuation in excess of Rupees One Lakh and Fifty Thousand is available as a deduction under section 80CCD(1). Thus, raising the upper limit of the exemption to Rs. 2.00 lakh with Section 80CCD(1) + Section 80CCD(1B).

DID YOU KNOW?

In other words, Section 80C+ Section 80CCC+ Section 80CCD(1) For example, consider yourself an individual who invests Rs. 1 50 000 / – in accordance with Section 80C (PPF, Tax Saver FD, ELSS, etc.). Now you have decided to deposit Rs. 70,000/- per year for NPS. Now you can claim a deduction of 50,000 thousand. Total Rs. 2.00 lakh, i.e. 1.50 lakh under section 80C and Rs. 50,000 / – in accordance with section 80CCD (1B).

What to look for when claiming deductions under section 80CCD(1B)

Here are some important points regarding Section 80CCD(1B) that you should be aware of.

Additional deduction in the amount of Rs. 50,000/- is only available for contributions made to NPS Tier 1 accounts.

Level 2 accounts are not eligible to claim the deduction under section 80CCD(1B).

Section 80CCD(1B) deductions are available to both employees and the self-employed.

You need to provide documentary proof of the transaction associated with the NPS contribution.

Partial withdrawals are permitted by the NPS but subject to certain conditions.

Download and Prepare at a time 50 Employees Form 16 Part B for the Financial Year 2021-22

Income tax deductions under section 80 CCD (1B)

The normal exemption limit under section 80CCD(1B) is Rupees Fifty Thousand and is not subject to exceptions under section 80 C. As such, you may qualify for a maximum deduction of Rs. 2,00,000/-

However,

If the defendant dies and the nominee decides to close the NPS account, the amount received by the nominee is exempt from tax.

With a partial withdrawal of funds from the account, only 25% of the contribution made is exempt from taxation.

For instance, If the assessee is an employee and decides to close the NPS account or decide not to participate in the NPS, only 40% of the total amount is tax-deductible.

The appraiser can withdraw 60% of the total amount upon reaching the age of 60 as non-taxable income. The remaining 40% is also tax-free if used to purchase an annuity plan. Section 80CCD(1B) offers you an excellent opportunity to save a significant amount on your tax liability.

This way, you can not only reduce your current tax liability but also work towards building a substantial body for retirement. Please be aware of the points above before taking any action with respect to your NPS account in connection with section 80CCD(1B).

Download and Prepare at a time 50 Employees Form 16 Part A&B for the Financial Year 2021-22

Income tax deductions under section 80 CCD (1B)

Benefits for existing NPS subscribers

Existing NPS subscribers may also benefit from the deduction under section 80CCD (1B) in addition to the deduction of Rs 1.5 million under section 80C. They may claim an additional deduction of Rs 50,000 from their contribution in accordance with Section 80CCD (IB). They can split their NPS contribution and claim partly at 80C and the rest at 80CCD (1B), making the most of the 2 lakh tax deduction. Check out NPS tax credits:

Note. From April 1, 2019, the central government contribution to the NPS for its employees is increased to 14%. maximize your tax benefits.

Download Automated Income Tax Preparation Excel Based Software All in One for the Government & Non-Government (Private) Employees for the F.Y.2022-23 and A.Y.2023-24

Data input sheet
89(1) Calculator
form 10E

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 Government and Non-Government employees Salary Structure.

4) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E from the F.Y.2000-01 to F.Y.2022-23 (Update Version)

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

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

Related Posts

Form 10E
Arrears Relief Calculator U/s 89(1)
admin

Calculating income tax often feels like solving a complicated puzzle, doesn’t it? You gather salary slips, deductions, exemptions, and slabs, yet confusion remains. However, things do not have to be this stressful anymore. An Automatic Income Tax Calculator in Excel for Govt & Non-Govt Employees (FY 2025-26) works like a smart assistant that does the heavy lifting for you. In fact, it calculates tax automatically, accurately, and instantly. Moreover, it saves time, reduces errors, and gives you peace of mind. So, whether you are a government employee, a private-sector professional, or even a pensioner, this article will guide you step by step. Additionally, it will help you understand why Auto Calculate Income Tax Preparation Software in Excel is becoming the preferred choice for the general public across India. Table of Contents Sr# Headings 1 Introduction to Automatic Income Tax Calculator 2 Why Income Tax Calculation Feels Complicated 3 What Is Auto Calculate Income Tax Preparation Software in Excel 4 Who Can Use This Excel Tax Calculator 5 Key Features of Automatic Income Tax Calculator 6 Benefits for Government Employees 7 Benefits for Non-Government Employees 8 Old Tax Regime vs New Tax Regime Comparison 9 Deductions and Exemptions Covered 10 Step-by-Step: How the Excel Calculator Works 11 Accuracy, Transparency, and Error Reduction 12 Why Excel Is Better Than Online Calculators 13 Data Security and Offline Advantage 14 How This Tool Saves Time and Money 15 Conclusion and Final Thoughts 1. Introduction to Automatic Income Tax Calculator To begin with, an automatic income tax calculator in Excel is designed to simplify tax computation. Instead of manually applying slabs and formulas, you simply enter your income details. Consequently, the calculator does everything else. Moreover, it updates totals instantly, which means no more guesswork. Therefore, for FY 2025-26, this tool becomes extremely useful as tax rules continue to evolve. 2. Why Income Tax Calculation Feels Complicated Frankly speaking, income tax feels complicated because it involves multiple variables. Firstly, there are different tax slabs. Secondly, deductions change from person to person. Thirdly, exemptions vary based on salary structure. However, when you use Auto Calculate Income Tax Preparation Software in Excel, these complexities fade away. In other words, the software acts like a GPS that guides you smoothly through a confusing route. 3. What Is Auto Calculate Income Tax Preparation Software in Excel Simply put, this software is an Excel-based calculator with built-in formulas. Not only does it calculate tax automatically, but it also considers deductions, rebates, cess, and surcharge. Furthermore, it allows you to compare the old and new tax regimes side by side. As a result, you can choose the most beneficial option without stress. 4. Who Can Use This Excel Tax Calculator Interestingly, this tool is not limited to one group. Government employees, private employees, PSU staff, teachers, bank employees, and even consultants can use it. Additionally, pensioners and senior citizens can benefit as well. Therefore, it truly serves the general public. 5. Key Features of Automatic Income Tax Calculator Some standout features include: Automatic tax calculation Built-in tax slabs for FY 2025-26 Old vs New regime comparison Support for deductions under Chapter VI-A Simple, user-friendly interface Moreover, these features work together seamlessly. Hence, even beginners can use the calculator confidently. 6. Benefits for Government Employees For government employees, salary structures include DA, HRA, and other allowances. Therefore, tax calculation becomes tricky. However, this Excel calculator automatically adjusts these components. Additionally, it considers standard deduction and applicable exemptions. As a result, government employees save time and avoid errors. 7. Benefits for Non-Government Employees Similarly, non-government employees often deal with performance bonuses, incentives, and variable pay. Consequently, manual calculation leads to mistakes. With the Auto Calculate Income Tax Preparation Software in Excel, everything is handled logically. Furthermore, you can revise figures anytime, and results update instantly. 8. Old Tax Regime vs New Tax Regime Comparison One of the biggest advantages is regime comparison. On the one hand, the old regime offers deductions. On the other hand, the new regime provides lower slab rates. Therefore, the Excel calculator compares both automatically. Eventually, you clearly see which regime saves more tax. 9. Deductions and Exemptions Covered The calculator supports major deductions such as: Section 80C Section 80D Section 80CCD Standard Deduction HRA Exemption Moreover, it applies limits automatically. Thus, compliance becomes effortless. 10. Step-by-Step: How the Excel Calculator Works Firstly, you enter basic salary details. Secondly, you input allowances and deductions. Thirdly, the software calculates taxable income. Finally, it computes the tax payable. Meanwhile, every step updates in real time. Hence, you always stay informed. 11. Accuracy, Transparency, and Error Reduction Accuracy matters when money is involved. Therefore, this calculator uses predefined formulas to minimize errors. Moreover, transparency improves because you can see every calculation. Consequently, trust increases. 12. Why Excel Is Better Than Online Calculators Unlike online tools, Excel works offline. Additionally, there are no ads or distractions. Furthermore, you maintain full control over your data. Hence, Excel-based calculators are reliable and secure. 13. Data Security and Offline Advantage Since the file stays on your computer, your data remains private. Moreover, there is no need for internet access. As a result, sensitive financial information stays protected. 14. How This Tool Saves Time and Money Time is money, right? Because calculations are automatic, you save hours. Moreover, you avoid professional fees for basic tax estimation. Therefore, this tool pays for itself quickly. 15. Conclusion and Final Thoughts To sum up, Download Automatic Income Tax Calculator in Excel for Govt & Non-Govt Employees (FY 2025-26) is a smart move. It simplifies tax calculation, improves accuracy, and empowers you to make informed decisions. Ultimately, Auto Calculate Income Tax Preparation Software in Excel works like a financial compass, always pointing you in the right direction. Frequently Asked Questions (FAQs) Can government and private employees both use this Excel tax calculator? Yes, absolutely. The calculator is designed for both government and non-government employees. Does this calculator support FY 2025-26 tax slabs? Yes, it includes updated slabs and rules applicable for FY 2025-26. Can I compare old and new tax regimes using this software? Yes, the calculator automatically compares both regimes and shows tax savings. Is Excel-based tax calculation accurate? Yes, because predefined formulas reduce manual errors significantly. Is my data safe when using this Excel income tax calculator? Yes, since it works offline, your financial data remains fully secure. Download Automatic Income Tax Calculator in Excel for Govt & Non-Govt Employees (FY 2025-26) Key Features of this Excel Utility are:- Firstly, automatic tax calculation: The Excel tool instantly calculates income tax as soon as you enter salary details, thereby eliminating manual effort and confusion. Secondly, updated tax slabs for FY 2025-26: It automatically applies the latest income tax slabs, hence ensuring accuracy and compliance with current rules. Moreover, old vs new tax regime comparison: The calculator compares both regimes side by side, so you can easily choose the most tax-saving option. Additionally, support for Govt & Non-Govt employees: Whether you work in the government sector or the private sector, the calculator adjusts calculations accordingly. Furthermore, built-in deductions and exemptions: It covers major sections like 80C, 80D, 80CCD, HRA, and standard deduction, therefore reducing errors. As a result, real-time auto updates: Whenever you change any value, the tax payable updates instantly, thus saving time. Likewise, user-friendly Excel format: Since most people are familiar with Excel, the software feels simple, clear, and easy to operate. In addition, error-free formula-based working: Predefined formulas minimise calculation mistakes, consequently improving reliability. Meanwhile, offline usage advantage: You can use the calculator without internet access, hence keeping your data secure. Finally, time-saving and cost-effective: Because everything is automated, you save hours of work and avoid unnecessary professional fees.

Calculating income tax often feels like solving a complicated puzzle, doesn’t it? You gather salary slips, deductions, exemptions, and slabs, yet confusion remains. However, things

Read More »
error: Content is protected !!