Benefits of New Tax Regime for F.Y 2023-24 as per Budget 2023 with Automatic 100 Employee’ Income Tax Preparation Form 16 Part B in Excel for F.Y.2023-24

chapter Vi A


Navigating through the complexities of income tax can seem like a challenging endeavour. Therefore, The Union Government, in its budgetary wisdom, introduced a New Tax Regime under Section 115BAC in 2020, revolutionizing tax slabs. In other words, In this article, we explore the advantages of the new regime for the fiscal year 2023-24, focusing on the automated Form 16 Part B in Excel.

Key Changes in the Union Budget 2023

1. Increase in Tax Rebate Limits

Above all, Under the new tax regime, individuals can enjoy a full tax rebate on income up to Rs. 7 lakhs, a notable increase from the previous limit of Rs. 5 lakhs. Additionally, claiming a standard tax deduction of Rs. 50,000 on an income limit of Rs. 7.5 lakhs results in zero tax liability.

2. Standard Tax Deductions

However, Salaried individuals and family pensioners can benefit from standard deductions of Rs. 50,000 and Rs. 15,000, respectively, further reducing taxable income.

3. Default Option: New Tax Regime

 The new tax regime is now the default choice for both employers and the Income Tax Department,  streamlining the tax deduction process.

4. Exemptions and Deductions Not Available

Above all, Certain exemptions and deductions, such as those under Section 80C, 80D, HRA, and more, are not claimable under the new tax regime. This simplifies tax calculations but requires careful consideration.

5. Non-Claimable Tax Deductions & Exemptions

In addition, Reviewing the table, we find a list of key exemptions and deductions not available in the new tax regime. Similarly, These include professional tax, entertainment allowance, HRA, and more.

Download Automatic 100 Employee’ Income Tax Preparation Form 16 Part B in Excel for F.Y.2023-24

Benefits of New Tax Regime for F.Y 2023-24 as per Budget 2023
Benefits of New Tax Regime for F.Y 2023-24 as per Budget 2023

6. After that, Unique Features of the Excel Utility

Therefore, Download the Automatic Income Tax Master of Form 16 Part B in Excel to experience a myriad of features:

7. Preparation for 100 Employees

 Efficiency is paramount –  this Excel utility can prepare Form 16 Part B for up to 100 employees simultaneously.

8. Automatic Tax Liabilities Calculation

Similarly, The utility computes your income tax liabilities based on the new and old tax regimes, providing a comprehensive overview.

9. Updated Salary Structure

For instance, Aligning with the Budget 2023,  the Excel utility incorporates a unique salary structure for individuals.

10. Amendments as per Budget 2023-24

However, Stay compliant effortlessly, as the utility includes all amended Income Tax Sections as per the Budget 2023-24.

11. Prevent Duplicate Entries

Above all, Worried about duplicating PAN numbers? Fear not – the Excel utility prevents double entries, ensuring accurate records.

12. A-4 Paper Size Compatibility

In addition, Print Form 16 Part B conveniently on A-4 size paper with the utility’s user-friendly design.

13. Amount in Words Conversion

After that, Enjoy the convenience of automatic conversion of amounts to words without the need for complex Excel formulas.

14. Government and Non-Government Use

  Versatility is key – this Excel utility caters to both government and non-government entities.

15. Simple and User-Friendly

 No expertise is required – this Excel file is easy to download, and use, and fills data effortlessly for 50 employees at a time.

In conclusion,

In other words, The New Tax Regime for FY 2023-24 brings a breath of fresh air to income tax calculations. Therefore, With increased rebate limits, simplified deductions, and the convenience of an automated Form 16 Part B in Excel, taxpayers can navigate the tax landscape with ease.


Q1: Can I switch between the old and new tax regimes?

Yes, taxpayers have the flexibility to choose between the old and new tax regimes based on their financial preferences.

Q2: Are all exemptions eliminated in the new tax regime?

No, while certain exemptions are not available, the new regime has its set of benefits. It is crucial to evaluate the advantages and disadvantages according to individual circumstances.

Q3: How do I download the Excel utility for Form 16 Part B?

You can download the utility from the provided link and start using it by entering your employees’ data.

Q4: Is the Excel utility compatible with older Microsoft Office versions?

Yes, the utility is compatible with Office 2003, 2007, 2010, and even 2011 for Mac.

Back To Top