Prepare Automatic One by One Income Tax Form 16 Part B and Parts A Excel for the F.Y.2023-24

As tax season approaches, individuals and businesses alike are gearing up to fulfil their annual tax obligations. One crucial document in this process is Form 16, which provides details of salary income and tax deducted at source (TDS) by the employer. For the financial year 2023-24, ensuring accuracy and efficiency in preparing Form 16 is paramount. With the advent of technology, automating this process can significantly streamline the task, saving time and minimizing errors. In this article, we will delve into the steps to prepare automatic one-by-one income tax Form 16 Part B and Parts A and B in Excel for the FY 2023-24.

First and foremost, it’s essential to gather all the necessary information required for Form 16 preparation. This includes salary details, allowances, deductions, and TDS information for each employee. Organizing this data in a structured format will facilitate the automation process.

In Excel, creating a template for Form 16 Part B is the initial step. Utilize active verbs to label each section and ensure clarity. For instance, label the columns as “Employee Name,” “Employee PAN,” “Employer Name,” “Employer PAN,” “Financial Year,” “Assessment Year,” “Salary Income,” “Allowances,” “Deductions under Chapter VI-A,” “Total Income,” “TDS,” and “Net Income.”

Table of Contents

• You may also like – Automatic Income Tax One by One Preparation Excel-based Utility Form 16 Part B for the F.Y.2023-24
• Download Automatic Excel Based Income Tax Form 16 Part A and B One by One Preparation Software for the F.Y.2023-24
  • Related posts:

You may also like – Automatic Income Tax One by One Preparation Excel-based Utility Form 16 Part B for the F.Y.2023-24

Next, input the respective data for each employee into the designated columns. Ensure accuracy and consistency throughout this step to avoid discrepancies later on. Active verbs like “enter,” “input,” and “populate” can guide this process efficiently.

Once the data is populated, it’s time to calculate the total income and tax liability for each employee. Utilize Excel formulas to sum up the salary income, allowances, and deductions under Chapter VI-A. Active verbs such as “calculate,” “summarize,” and “compute” can guide this computational stage effectively.

Incorporate formulas to determine the taxable income after deductions and apply the appropriate tax rates to calculate the TDS amount. Active verbs like “apply,” “determine,” and “compute” will aid in this crucial calculation process.

Verify the computed TDS amount against the actual TDS deducted by the employer. Active verbs such as “cross-check,” “compare,” and “validate” can ensure accuracy in this verification process.

Generate Form 16 Part B for each employee using the populated data and calculated figures. Utilize Excel’s formatting options to present the information in a clear and professional manner. Active verbs like “generate,” “format,” and “present” can guide this step effectively.

In addition to Form 16 Part B, prepare Parts A and B as per the Income Tax Department’s guidelines. Active verbs such as “prepare,” “compile,” and “organize” can facilitate this documentation process efficiently.

Ensure compliance with the latest tax regulations and updates while preparing Form 16. Active verbs like “comply,” “adhere,” and “update” can guide this compliance aspect effectively.

Double-check the prepared Form 16 documents for any errors or discrepancies. Active verbs such as “review,” “audit,” and “verify” can aid in this final quality assurance stage.

Once verified, distribute the Form 16 documents to the respective employees in a timely manner. Active verbs like “distribute,” “disseminate,” and “share” can guide this dissemination process efficiently.

Provide assistance and guidance to employees regarding any queries or clarifications related to their Form 16 documents. Active verbs such as “assist,” “guide,” and “resolve” can facilitate this support process effectively.

Maintain proper records of the prepared Form 16 documents for future reference and audit purposes. Active verbs like “maintain,” “archive,” and “record” can aid in this documentation aspect efficiently.

In conclusion, automating the preparation of Form 16 Part B and Parts A and B in Excel for the FY 2023-24 can streamline the process, save time, and minimize errors. By utilizing active verbs to guide each step, individuals and businesses can ensure accuracy and efficiency in fulfilling their tax obligations. Embracing technology in tax compliance not only enhances productivity but also contributes to overall financial transparency and accountability.

Download Automatic Excel Based Income Tax Form 16 Part A and B One by One Preparation Software for the F.Y.2023-24

Read More

Section 80 Income Tax Deductions|With All in One Tax Calculator for the F.Y.2022-23

 Worried about paying huge taxesevery year? Know these deductions that can reduce your tax payable.

 

Section 80C - Investment deductions from taxable income

 

Some of your investments offer more than just expected returns. You can also save on taxes. Section 80C investments are important examples of such investments. This deduction is eligible for the individual and Hindu undivided family (HUF). Deductions are available for some large investments such as:

 

Investments in the state pension fund (NPF)

 

Unit Linked Investment Plans (ULIP)

 

Equity Savings Schemes (ELSS)

 

Participation of employees in contributions to the Pension Fund

 

National Savings Certificates (NSCs)

 

Life insurance premium payment

 

Child education

 

Home loan repayment

 

Senior Savings Scheme (SCSS)

 

Maximum deduction: `1,50,000*

 

*The maximum deduction shown here only applies to the specific section. Also note that, in the aggregate, the maximum deduction that can be claimed under Section 80C, Section 80CC and 80CCD(1) is $1,50,000. In addition, an additional 50,000 may be claimed as a tax credit for investments in the National Pension Scheme (NPS) account pursuant to section 80CCD (1B).

 

Section 80 CCD - Withholding a contribution to a pension fund

 

It is designed to reduce the tax liability of pension plans offered by various public and private sector insurance companies. It provides a deduction to an individual who has paid or contributed an amount to any insurer's annuity plan to receive a pension (income) from a fund created by the insurer. The deduction of premium paid during the year may be claimed as a deduction from taxable income.

Maximum deduction: `1,50,000*

*The maximum deduction shown here only applies to the specific section. In addition, please note that the cumulative maximum deduction that can be claimed under Section 80C, Section 80CC and 80CCD(1) is $1,50,000.

 

In addition, an additional Rs.50,000 may be claimed as a tax credit for investing in an NPS account pursuant to section 80CCD (1B).

 

Section 80CCD. Deduction of contribution to the central government pension system.

A Section 80CCD deduction is permitted for individuals who make deposits into their retirement accounts.

 

The maximum deduction allowed is 10% of wages (in the case of employees) and 20% of gross income (in the case of self-employed persons) or £150,000, whichever is less. Under subsection 1B, there is an additional deduction of up to $50,000 for individual contributions to the NPS.

Maximum deduction: Rs.2,00,000*

 

* The maximum deduction shown here only applies to the specific section. Also note that, in the aggregate, the maximum deduction that can be claimed under Section 80C, Section 80CC and 80CCD(1) is Rs.1,50,000.

 

In addition, an additional Rs.50,000 may be claimed as a tax credit for investing in an NPS account pursuant to section 80CCD (1B).

 

Both of the sections mentioned above are related to pension plans and annuity plans. But there is a difference between them.

 

While Section 80CCD covers a deduction from the amount paid into an annuity plan by any insurer, Section 80CCD provides for a deduction from the amount paid into pension plans: NPS and Atal Pension Yojana.

Download Automated Income Tax Preparation Software All in One for the West Bengal Govt Employees for the F.Y.2022-23

Main 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 as per the West Bengal Govt Employee’s Salary Structure.

 

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

 

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

 

7) Individual Salary Sheet

 

Section 80D - Deduction of premium paid for health insurance

Section 80D allows a taxpayer to deduct up to $25,000 for insurance for self, spouse, and dependent children. If the insured is aged 60 or over, the deduction is available for up to EUR 30,000. An additional insurance deduction for parents (parent or both) is allowed in the amount of 25,000 (30,000 if the parents are 60 years of age or older). You can also claim a preventive health check-up to Rs.5,000 up to the limit above.

Maximum deduction: Rs.60,000

 

Section 80E - Deduction of Interest on an Educational Loan Taken for Higher Education

If you took out a student loan for higher education, you can claim a tax credit under Section 80E. It applies even if the loan may be to a spouse, children, or student for whom the taxpayer is legally responsible. A deduction is permitted from the amount of interest on the loan and is available for a maximum period of 8 years or until interest is paid, whichever comes first.

Download Automated Income Tax Preparation Software All in One for the Non-GovtEmployees for the F.Y.2022-23

Main 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 as per the West Non-Govt Employee’s Salary Structure.

 

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

 

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

 

7) Automated Income Tax Form 12 BA

 

You can even claim a deduction if the loan is made to fund study abroad.

Maximum deduction: no limits. The deduction is granted for 8 years.

Section 80GG - Tax deductions for paid rent for housing.

 

Under Section 80GG, you may claim a deduction for housing rent you paid if you did not receive Home Rent Assistance (HRA) from your wages. The taxpayer, spouse, or minor child must not have accommodation at the place of work. The taxpayer must live on rent and pay rent. In addition, the taxpayer must not have their own housing anywhere else.

 

The deduction under this section is available at least:

Rent paid minus 10% of the total rent

5000 per month

25% of total income

Maximum deduction: `60,000

 

Savings Account Interest Deduction - Section 80TTA

A deduction may be claimed under section 80TTA on interest income received from a bank savings account. Savings bank account interest must first be included in the Miscellaneous Income section when it is calculated, and the deduction may be deducted from the total interest earned or "10,000" whichever is less. Interest income on time deposits, regular deposits or interest income on corporate bonds cannot be reported under this section.

Maximum deduction: Rs.10,000

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

 

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

Read More

Disability Tax Exemption U/s 80U | With Automatic Income Tax Arrears Relief Calculator U/s 89(1) with Form 10 E for the F.Y.2022-23(Up-to-date Version)

 Disability Tax Exemption U/s 80U| There are certain sections in the income tax laws of India which

 provide tax benefits to people if they or any of their family members suffer from a certain disability.

 

Section 80U offers tax credits if an individual has a disability and Section 80DD offers tax credits if the taxpayer's dependent family member has a disability. This article is about a discussion of the tax credits available in section 80U.

 

Who Can Apply for a Section 80U Deduction

A resident who has been certified as disabled by a medical authority is eligible for a tax credit under section 80U. For the purposes of this section, a person with a disability of at least 40% as established by the health authorities is considered disabled.

Download and prepare at a time 50 Employees Form16 Part B for the Financial Year 2021-22

For the purposes of this section, disability is defined as one of the following:

• Blindness

• Poor eyesight

• Healing from leprosy

• Hearing problem

• Motor disability

• Mental delay

• Mental disease

 

The section also defines a major disability, which refers to a condition where the disability is 80% or more. Severe disability also includes multiple disabilities, autism and cerebral palsy.

 

Quantum deduction up to 80U

Deduct Rs. 75,000 is allowed for people with disabilities, Rs. 1.25.000 deductions for people with severe disabilities.

 

Section 80U Requirements for Requesting Deduction

No documentation other than a certificate of disability issued by a recognized medical institution on Form10-IA is required. There is no need to submit invoices for expenses incurred in connection with treatment or other similar expenses.

 

To apply under this section, you must submit a medical certificate certifying your disability along with your Section 139 tax return for the applicable. In the event that the certificate of invalidity has expired, you can still request these deductions in the year the certificate expires.

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

However, a new certificate will be required next year to receive the benefits. Certifications can be obtained from medical authorities, which can be a neurologist with a doctorate of medicine (MD) in neurology (in the case of children, a pediatric neurologist with an equivalent degree) or a civil surgeon or medical director of a hospital public.

Note. If the invalidity is temporary and requires re-evaluation after a certain period, the certificate will start in the assessment year corresponding to the fiscal year in which it was issued and will end in the assessment year corresponding to the fiscal year in which the certificate expires.

 

Difference between 80U partition and 80DD partition

Section 80DD provides tax credits to family members and relatives of a taxpayer with a disability, while Section 80U provides tax credits to the taxpayer with a disability.

Section 80DD applies if a taxpayer pays a certain amount as an insurance premium for the care of a dependent person with a disability. Under section 80DD, the deduction limits are the same as in section 80U. Here dependent refers to siblings, parents, spouse, children, or a member of the same Hindu family as the taxpayer.

Download Automated Income Tax Arrears ReliefCalculator U/s 89(1) with Form 10 E from the F.Y.2000-01 to F.Y.2022-23(Up-to-date Version)

Read More

Tax benefits of health insurance premium U/s 80D| With Automatic Income Tax Revised Form 16 Part A&B and Part B for the F.Y.2021-22

 Tax benefits of health insurance premium U/s 80D| 

1. The conditions required to claim a deduction relating to health insurance or health insurance under this section:

The deduction is only allowed in this section to one individual or HUF.

The deduction is allowed for the following purposes:

In the case of an individual: allowed- 

The amount paid to provide or maintain the health insurance of the evaluator or members of his family, or his parents, or parents, or 

Any contribution to the central government health system or another program that the central government may notify on that behalf.

Download and Prepare at a time 50 Employees Form 16 Part B for the F.Y.2021-22

Any payment made as a preventive health check on the Assessor or members of their family, or to assess the health status of the Assessor's parents or guardians.

In my family, we mean the spouse and dependent children of the assessor.

In the case of HUF:

 

The amount paid to provide or maintain health insurance for any member of this indivisible Hindu family is eligible.

 

In the case of a very senior citizen:

A deduction for medical expenses incurred (instead of the amount paid for the implementation of any medical insurance).

 

Health insurance must comply with the structure established for this purpose (a) approved by the GIC and the central government, or (b) approved by any other insurance company and the Insurance Regulatory and Development Authority.

Download and Prepare at a time 50 Employees Form 16 Part A&B for the F.Y.2021-22

 

Payment must be made by any method other than cash. However, this can also be done in cash for preventive medical checkups.

The amount is paid out of your taxable income.

 

2. Section 80D. Deductible below

If the appraiser is an individual:

The allowable deduction is the sum of the following, i.e.:-

(a) (i) The full amount paid to secure or maintain the Appraiser's or spouse's health insurance and dependent children, or

 

(ii) The total amount of any contributions paid to the Central Public Health System (CGHS) shall not exceed Rs. 25,000; As well as

 

(b) The total amount paid to provide or maintain the health insurance of the parents or parents (dependants or not) of the evaluator, which does not exceed a total of Rs. 25,000.

 

However, for the preventive health check of the family or the parent or parents of the assessor, the maximum allowable amount will be capped at Rs. 5000 and this amount is subject to the maximum limit of Rs. 5000 will be within the total limit of Rs. 25,000 referred to in paragraphs (a) or (b) above.

 

If the appraiser is an undivided Hindu family (HUF):

The allowable deduction will be the total amount paid for the implementation or maintenance of the health insurance of any member of this indivisible Hindu family, not exceeding Rs. 25,000.

Download and Prepare at a time 100 Employees Form 16 Part B for the F.Y.2021-22 

Additional deduction in the amount of Rs. 5000:

If the amount referred to in paragraphs (1) (a) and (b) and (section (2)) is paid for the establishment or maintenance of a health insurance policy by any person named therein who is an elderly person, an additional deduction will, in any case, be allowed in the amount of 5000 rupees.

 

A deduction for medical expenses incurred (instead of the amount paid for any health insurance) will be allowed in the case of a very senior citizen.

 

The following deductions may also be requested:

The total amount paid for medical expenses incurred for your health or for any of your family members, cumulatively in Rs. 30,000; As well as

The total amount paid for medical expenses incurred for the health of any evaluator parent, cumulatively up to Rs. no more. 30,000

However, in order to request a deduction of the amount referred to in paragraph (i) or (ii) above, the following two conditions must be met:

 

The amount payable to a very elderly citizen

No amount was to be paid for the operation or operation of that person's health insurance.

Download and Prepare at a time 100 Employees Form 16 Part A&B for the F.Y.2021-22

 

It is further understood that the sum of the amounts referred to in paragraphs (1) (a) and (3) (i) above, or the amounts referred to in paragraphs (1) (b) and (3) (ii), of which the higher should be Rs 30000/-. No more than 30,000 [Cash deduction limit increased from Rs. from 30,000 to rupees. For 50,000 years. 2019-20] 

Notes -

A family includes a person, his spouse and dependent children.

 

Parents include father and mother (dependent or not). Father-in-law and mother-in-law are not counted.

 

The total amount of preventive medical examination fees for self, spouse, dependent children, father and mother cannot exceed Rs. 5000

 

The above payments [referred to in paragraphs (a) and (b)] must be made by any method other than cash. However, you can pay for a preventive medical examination with whom

Download and Prepare One by One  Form 16 Part B for the F.Y.2021-22

Read More