Auto Prep Income Tax Software in Excel for Non-Govt Employees FY 2023-24



In the world of income tax filing, simplicity and efficiency are of utmost importance. Non-government employees often find themselves struggling with the intricate process of preparing and filing their income tax returns. Therefore, The good news is that there’s a solution that can make this process a breeze. This article will guide you through the steps to use Excel to prepare your income tax for the fiscal year 2023-24, focusing on simplicity and accuracy.

Understanding the Basics

In other words, What is Income Tax?

Before we dive into the nitty-gritty of using Excel for income tax preparation, let’s understand the basics. Income tax is a financial charge imposed on an individual’s income by the government. However, It’s a mandatory contribution that funds various public services and government expenditures.

FY 2023-24: What You Need to Know

The fiscal year 2023-24 begins on April 1, 2023, and ends on March 31, 2024. Above all, This is the period for which you will be preparing your income tax return. It’s essential to keep this timeframe in mind when collecting your financial data.

In addition, Preparing Your Data

Organizing Your Documents

After that, The initial step involves collecting all the required documents. Ensure you have your Form 16, bank statements, investment proofs, and other income-related documents ready.

Similarly, Creating an Excel Workbook

Therefore, To begin, open Microsoft Excel and create a new workbook. Label it with the fiscal year, i.e., “FY 2023-24 Income Tax.”

 In other words, Inputting Income Details

Salary Income

However, The first type is “Salary Income.” This is your primary source of income as a non-government employee. Input your salary details in the cells below, including basic salary, allowances, and any deductions.

Other Sources of Income

List any other sources of income, such as rental income, interest, or freelance earnings, under this heading.

For instance, Deductions and Exemptions

Section 80C Deductions

Above all, Deductions under Section 80C are crucial. Enter your investments like PPF, EPF, life insurance premiums, and more in this section.

Other Deductions

Include deductions under various sections, like HRA, standard deduction, and deductions for disabilities.

Calculating Taxes

Income Tax Calculation

In addition, Excel makes calculating your income tax simple. Use formulas to determine your tax liability. Don’t forget to include any applicable rebates or deductions.

Filing the Return

Filing Your Tax Return Online

Now that your income tax is ready, it’s time to file it online. Visit the official income tax e-filing portal and follow the steps.


In summary, preparing your income tax using Excel for FY 2023-24 as a non-government employee is achievable with the right approach. This method allows for a systematic and organized way to ensure accurate tax calculations. By following these steps, you can simplify the process and be confident in filing your returns.


Q1: Can I use any version of Excel for this method?

Yes, you can use most versions of Microsoft Excel. The features required for income tax preparation are available in both older and newer versions.

Q2: What if I have complex financial transactions or multiple sources of income?

For complex financial situations, consider consulting a tax professional or chartered accountant to ensure accuracy in your tax calculations.

Q3: Do I need to maintain printed copies of my documents?

While it’s a good practice to keep physical copies of your documents, maintaining digital copies in a secure location is also acceptable.

Q4: What is the deadline for filing income tax for FY 2023-24?

The deadline for filing your income tax returns for FY 2023-24 is typically July 31, 2024. However, it’s essential to check for any updates or extensions by the income tax department.

Q5: Can I claim tax refunds through this method?

Yes, if you are eligible for a tax refund, you can claim it through this method while filing your income tax return.

Click to Get the All-in-One Automated Excel-Based Income Tax Preparation Software designed for Non-Government (Private) Employees for the Financial Year 2023-24 and Assessment Year 2024-25

Salary Structure
Tax Computed Sheet
Income Tax Form 16
Form 12BA

Features of this Excel Utility

  1. The Tax Calculation will be as per the Budget 2023 with New and Old Tax Regime U/s 115 BAC
  • This Excel Utility has its own Salary Structure as per the Non-Government (Private) Employees’ Salary Structure
  • For instance, This Excel Utility can prepare automatically your Income tax Computed  Sheet  Just fill in the Data
  • For instance, This Excel Utility can Calculate your House Rent Exemption U/s 10(13A)
  • This Excel Utility has a separate Salary Sheet
  • For instance, This Excel Utility have the Value of Perquisite Form 12 BA
  • For instance, This Excel Utility can prepare at a time your Form 16 Part B automatically for FY 2023-24
  • For instance, This Excel Utility can prepare at a time Form 16 Part A and B automatically for FY 2023-24