Download All in One Automated Income Tax Calculator for Government and Non-Government Employees (Individual) for Financial Year 2022-23 under New and Old Tax Regime U/s 115BAC

 Download All in One Automated Income Tax Calculator for Government and Non-Government

 Employees | Include a new section 115 BAC in the 2020 budget for the fiscal year 2022-23. This

 section 115BAC contains an option that allows you to continue the old tax regime with any income tax

 exemption as of the financial year 2021-22 and opt for the new tax regime apart from any income tax

 exemption as of the last fiscal year. Current. 2019-20 as clearly indicated in Budget 2020 U/s 115BAC.

According to the budget, a new U/s tax label has been specified under 115BAC which was introduced in the 2020 Budget.

 At the same time, it is also clear that according to Article 115BAC (New Tax Regime) there is no exemption for the elderly in the new tax plan.

Download Automated IncomeTax Preparation Excel-Based Software All in One for the Government andNon-Government (Private) Employees for the Financial Year 2021-22 and Assessment Year 2022-23 U/s 115BAC

 

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 the all amended Income Tax Section as per Budget 2021

 

3) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E from the F.Y.2000-01 to F.Y.2021-22 (Updated Version)

 

4) Automated Calculation Income Tax House Rent Exemption U/s 10(13A)

 

5) Individual Salary Structure as per the Govt and 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 into the in-words without any Excel Formula

Read More

New and old tax regime U/s 115BAC|With Automated Income Tax Calculator All in One for the Govt & Non-Govt Employees for the F.Y.2022-23

 New and old tax regime U/s 115BAC|In this New Tax System, A lot of doubt about the new tax regime.

 People can't decide what to choose. Let's discuss the new tax regime.

 

The new tax regime has available for individuals, both for HUF, if you are a resident or a non-resident, and is optional. The new tax regime has preferential rates up to a taxable income of Rs. 15 lakh with tax slabs of 5%, 10%, 15%, 20% and 25% on income, upfront of 2.50 lakh of Rs base exemption. 2.50 Lakh If you wish to take advantage of the reduced tax slab rates under the new tax regime in lieu of the existing tax slabs, you must waive the tax deductions & exemptions available under the old tax regime.

 

As for employees, they are not eligible for important benefits such as standard deductions, housing allowance, vacation assistance, etc. if they choose the new tax regime. The senior citizen will not be able to claim the standard ex-employer's pension deduction, nor the section 80TB postal and bank interest deduction if they choose the new tax regime.

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

In addition, various deductions under Chapter VIA such as Section 80 C (consisting of various items such as EPF, LIP, tuition, PPF, NSC, ELSS, home loan repayment, etc.), 80 CCD (1) and 80 CCD (1B) (for NPS) 80D (for health insurance premiums) 80D for health insurance, 80G for donations, 80 TTA for bank savings interest, etc. but not available in the new tax regime.

 

If you have borrowed money to buy a home or renovate a home claiming autonomy, you are not eligible for the interest deduction, which is available up to Rs. 2 million a year. You will also not be able to offset the current loss, as well as the expected loss of ownership of the main home against current income if you choose the new scheme. Not only that, you are not allowed to carry any homeownership losses onto the rental property.

 

The total benefit from the transition to the new tax regime is about Rs. 75,000/- plus 4% deductible if your total income is Rs. 15 thousand. Since many exemptions and deductions can be claimed, and the composition of these tax credits varies from person to person, there is no ready answer to the question of which scheme works for you. However, looking at the tax credits that most taxpayers have to forgo, the benefits available under the existing scheme outweigh the lower rate benefits available under the new scheme, especially for employees and homeowners.

 

How to activate consent to the new scheme and switch between the old and new scheme

 

Those with no business or income must use this option each year by filing Form 10IE with the ITR, no later than the ITR filing deadline. those. July 31st and an option once exercised for a given year cannot be changed if you wish to file a revised report. Therefore, take into account all income, benefits and deductions when choosing a scheme for a given year.

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

 

Please note that under income tax law, using the new tax regime with your employer does not count as exercising the option. The use of the employer option has a limited purpose and you may choose an alternative scheme when filing an ITR. Be sure to file your ITR before the expiration date if you wish to opt for a new tax regime as this option is not available after the expiration date. However, you can stay on the old scheme for one year and on the new scheme the following year.

 

Those with business and income must exercise the option once and for all first by completing Form 10IE before the ITR filing deadline through the ITR, which can be filed later. This person can opt-out of the new tax regime only once, and then cannot return to the new tax regime if there is no business income that year. Therefore, you need to be very careful when choosing a new tax regime when you have business income, and you must take into account the composition of income not only of the relevant years but in all future years.

 

How does the scheme work?

Let's see how the circuit works with examples. Almost all employees receive HRA benefits for paying rent or buying a home with a mortgage. Assuming you bought a house with a mortgage, you will not be able to claim the benefits of a home loan with interest and principal repayment of Rs. 3.50 thousand together.

 

Bearing in mind the fact that you will also have to waive the standard deduction requirement. 50,000/- if you choose the new mode, losing all the benefits of Rs. 4,00,000/- leading to tax implications of Rs. 80,000 if you are on the 20% tax rate with an income between 5 and 10 lakhs.

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

 

The forgone net tax benefit is greater than the benefit of Rs. 62 500/- is accumulated for you under the new scheme. For those on the 30% tax slab, the tax effect of waiving the 30 % exemption will be 1.20 lakh compared to the Rs benefit. 75,000/- accumulated under the new regime.

 

We can also include exclusive benefits available for NPS Rs. $50,000 pursuant to Article 80 CCD (1B). So, apparently, the new scheme does not look attractive to the employee. Employees must determine their final tax liability when completing the ITR and select a regimen that will help them optimize their tax revenue.

 

From the example above, it becomes obvious that if someone is on a 20% or 30% tax rate, the current scheme is better for those who enjoy all the major deductions that people usually enjoy.

 

Let's move on to an example where a person has an income of up to Rs. 7 lakh and who will have to pay a tax of Rs. 32 500 / - if you choose the new model. However, if he can claim a deduction under section 80 C for Rs. 1.50 lakh and deduction of Rs. 50,000/- under Section 80 CCD (1B) for NPS and reduce his total income below 5 lakhs, he will not have to pay any taxes, taking advantage of the u/s 87A discount to Rs. 12,500/- Thus, by investing two lakh rupees, it will be possible to save rupees in taxes. 32 500 / - remained in the old regime. However, this scheme will work for self-employed people who don't want to save money to make investments that qualify for multiple deductions.

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

Download and Prepare at a time 50 or 100 or One by One Income Tax Form 16 Part A&B and Part B for the F.Y.2021-22 as per Old and New Tax Regime

 

What is Form 16 of Certificate? Automated Income Tax Form 16 along with Part A and B for the financial year 2021-22 as per section 115 BAC

Form 16 is an income tax certificate issued by an employer giving details of how much tax was deducted and when it was submitted to the IT (Income Tax) department. It is issued as proof of tax deduction and filing. Form 16 can also be considered as salary TDS certificate. It is also considered the source of proof of employee's tax return. Form 16 consists of two parts, Part A and Part B.

16. Part A of Form 16

Part A of Form 16 contains the details of withholding tax on salary. This includes the name and address of the employer, PAN (Permanent Account Number) and TAN (Tax Collection and Deduction Account Number), amount deposited and summary of taxes deducted.

16. Part B of

It must be issued by the employer. Contains details of pay break. It also includes deductions allowed under the Income Tax Act (Chapter VI A).

Eligibility for Form 16

As per the rules issued by the Ministry of Finance, Government of India, any person earning salary and filing tax return is eligible for Form 16. Employers use this certificate to track their earnings.

Download all types of Form 16 for the financial year 2021-22 from the link given below.

Automated Form 16 Part B and Part A&B for FY 2021-22 & Ass Yr 2022-23

 

  1)One by One Preparation Automatic Form 16 Part A & B and Part-B for the Financial Year 2021-22 and Ass Year 2022-23 (Click here to Download the Utility]( This Excel Utility can use New and Old Tax Regime U/s 115BAC as per Budget 2021)

 2) One by One Preparation, Automatic Form 16 Only Form 16 Part B for the Financial Year 2021-22 and Ass Year 2022-23, [Click here to download the Utility] ( This Excel Utility can use New and Old Tax Regime U/s 115BAC as per Budget 2021)

 

3) Master of Form 16 only Part-B  for the Financial Year 2021-22 and Ass Year 2022-23, ( which can prepare  at a time 50 employees Form 16 Part B) which  Click here to download Utility] ( This Excel Utility can use New and Old Tax Regime U/s 115BAC as per Budget 2021)

 4) Master of Form 16 Part B for FY 2021-22 and Ass Year 2022-23 ( This Utility can prepare at a time 100 employees Form 16 Part B [ Click here to Download the  Utility ] ( This Excel Utility can use New and Old Tax Regime U/s 115BAC as per Budget 2021)

5) Master of Form 16 Part A&B FY 2021-22 and Ass Year 2022-23,[ This utility prepare  At a time 50 employees Form 16 Part A&B ]  Click here to Download  the Utility] ( This Excel Utility can use New and Old Tax Regime U/s 115BAC as per Budget 2021)

 

6) Master of Form 16 Part A&B (This utility can prepare at a time 100 employees Part A&B) for 2021-22 and Ass year 2022-23 [Click here to download the Utility] ( This Excel Utility can use New and Old Tax Regime U/s 115BAC as per Budget 2021)

Read More

Tax Planning for F.Y.2021-22| With Automated Income Tax Preparation Software In Excel All in One Govt & Non-Govt Employees for the F.Y.2021-22

 Tax Planning for F.Y.2021-22| According to the Finance Act,2020, when a person favours a 

the new tax, no specific exemption (such as Section 80C, Section 80D, Section 80G, etc.) 

can be claimed under Chapter VI-A of the Act. It may be claimed that only deductions can be made 

under sub-section (2) of section 80CCD (notice the pension scheme employer contributes to 

the employee's account.

You may also, like- Automated Income Tax Preparation Excel Based Software All in One for the Assam State Employees for the F.Y.2021-22 [This Excel Utility can prepare at a time Tax computed sheet as per new and old tax regime + Individual Salary Structure as per the Assam State Employees Salary Pattern + Auto Calculate H.R.A. Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B for the F.Y.2021-22]

 

Persons with disabilities are exempt from maintenance including medical treatment of a dependent person (Section 80DD of the Act)

 

A resident who spends on the treatment and maintenance of a disabled person gets a retirement of Rs 75,000 and if a dependent is a disabled person and if that dependent is a severely disabled person then INR 125,000

 

Exemption on interest earned on higher education (Section 80E of the Act)

According to the Domestic Tax Act of India, when calculating a person's total income, certain financial institutions (including banks) pay interest separately on loans (tax payable out of their income) / charities for the higher education of themselves / their relatives. Appropriate discount is

You may also, like- Automated Income Tax Preparation Excel Based Software All in One for the Bihar State Employees for the F.Y.2021-22 [This Excel Utility can prepare at a time Tax computed sheet as per new and old tax regime + Individual Salary Structure as per the Bihar State Employees Salary Pattern + Auto Calculate H.R.A. Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B for the F.Y.2021-22]

 

The reduction for interest paid on the loan will be available before the following period:

 

tax year to year for a year where the taxpayer starts paying interest; Or

up to the interest on such loan is paid in full.

 

Discount for rent payment (Section 80GG of the Act)

Individuals who are paying rent for more than 10% of taxable income for a dwelling (furnished/unfinished) but have not received a house rent allowance from the employer can claim a discount of the following:

 

Rent - 10 % of taxable income; Or INR 5,000 per month (or INR 60,000 annually); Or 25 per cent of taxable income

You may also, like- Automated Income Tax Preparation Excel Based Software All in One for the West Bengal State Employees for theF.Y.2021-22 [This Excel Utility can prepare at a time Tax computed sheet as per new and old tax regime + Individual Salary Structure as per the West Bengal State Employees Salary Pattern + Auto Calculate H.R.A. Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B for the F.Y.2021-22]

 

Savings Account Deposit Interest Exemption (80 TTA by Act)

Additional discount up to INR10,000 per annum on interest on deposits (excluding time deposits) in savings accounts at designated banks, co-operative societies and post offices for individuals / HUFs from 2012/13 to tax F.Y. 2012-13.

 

Deposit interest on deposits for senior citizens (Section 80TTBof the Act)

Interest on deposits with specific banks, co-operative societies and post offices (including annual deposits) up to INR 50,000 per annum for senior citizens from tax year / 1999 onwards. However, no waiver will be allowed under section 80TTA in this case

You may also, like- Automated Income Tax Preparation Excel Based Software All in One for the Non-Government (Private) Employees for the F.Y.2021-22 [This Excel Utility can prepare at a time Tax computed sheet as per new and old tax regime + Individual Salary Structure as per the Non-Govt Employees Salary Pattern + Auto Calculate H.R.A. Calculation U/s 10(13A) + Automated Form 12  BA + Automated Income Tax Form 16 Part A&B and Part B for the F.Y.2021-22]

 

Exemption for persons with disabilities (Section 80U of the Act)

INR75,000 is available for a disabled resident and a US ছাড় 125,000 discount for a severely disabled resident certified by the medical authorities.

Discount for interest on the home property (a) 24 (b)

Deduction of interest payable on, construction, repair etc. for self-occupied house Rs. 2 lacks.

 

* Where the property has been acquired or constructed with borrowed capital, the interest payable on the borrowed capital for the period at which the property was acquired or constructed prior to the previous year, if any has been deducted by any part thereof. Under any other provision of this Act, under this section deductions, will be made in equal instalments for the previous year and immediately for the following 4 years.

You may also, like- Automated Income Tax Preparation Excel Based Software All in One for the Jharkhand State Employees for the F.Y.2021-22[This Excel Utility can prepare at a time Tax computed sheet as per new and old tax regime + Individual Salary Structure as per the Jharkhand State Employees Salary Pattern + Auto Calculate H.R.A. Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B for the F.Y.2021-22]

 

* If a person owns more than one home during F.Y. the maximum home property loss compared to other fixed income is INR Rs. 200,000 in the same financial year alone. Balance House Assets Decreased Assets Decreased Assets can be advanced for a maximum of 8 F.Y to match the income.

 

* As provided by the Finance Act 2019, the taxpayer may consider the property of two houses owned by them as self-acquired property. Accordingly, there is no need to pay tax on fictitious rent from such second self-occupied / vacant property. In addition, the total tax deduction for interest payable on housing loans for both the mentioned self-occupied / vacant properties will be limited to INR 200,000 / - per tax year.

You may also, like- Automated Income Tax Preparation Excel Based Software All in One for the Andhra Pradesh State Employees for the F.Y.2021-22 [This Excel Utility can prepare at a time Tax computed sheet as per new and old tax regime + Individual Salary Structure as per the Andhra Pradesh  State Employees Salary Pattern + Auto Calculate H.R.A. Calculation U/s 10(13A) + Automated Income Tax Form 16 Part A&B and Part B for the F.Y.2021-22]

 

* The Finance Act of 2020 proposes that where taxpayers opt for a new tax discipline, no exemption will be available for interest payments and principal payments. Moreover, any foreclosure loss will not be available for set-off against income from home property. * Under the Finance Act, 2020, it is proposed to offer a rebate of R 150,000 on interest on affordable housing, i.e. housing loans below INR 4.5 Lakh (for approved loans from 1 April 2019 to 31 March 2020) and extended loans approved for 1 March 2021.

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

 

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 Employee’s 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.2021-22 (Update Version)

 

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

 

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

Read More

Income Tax Allowance and Exemptions F.Y.2020-21 along with Automatic Income Tax Form 16 for the F.Y.2020-21

 Income Tax Allowance and Deduction F.Y.2021-22.

Salary employees make up the largest share of the country’s overall taxpayers and the contribution they make to tax collection is significant enough. As a result of income tax exemption, there is an opportunity to save tax for the salaried class. With the help of these discounts and rebates and, one can significantly reduce his taxes.

 

In this article, we try to list some of the big discounts and allowances available to salaried individuals, using which can reduce their income tax liability.

 

Allowance exemption

House rent allowance 

A tenant-based on rent can get the benefit of HRA (house rent allowance). 

You can claim the lowest of the following as an HRA discount.

A. Total HRA received from your employer

B. Rent paid less than 10% (Basic Salary + DA)

C. 40% of non-metro salary (basic salary + DA) and 50% of metro salary (basic salary + DA)

 Download Automated Income Tax House Rent Exemption Calculator in Excel U/s 10 (13A) as per Income Tax Act

Standard deduction-

The Finance Minister of India, at the time of presenting the Union Budget 2018, the limit was Rs. 40,000 has been increased. The interim budget for 2019 is Rs 50,000.

You may also, like- One by One Preparation Form 16 Part A&B and Part B in Excel for the F.Y.2020-21 as per new and old tax regime U/s 115 BAC

Deduction travel allowance (LTA)

The Income-tax Act also provides for LTA exemptions for salaried employees, which restricts travel expenses to their pages. The following are the restrictions applicable to LTAs: 

The LTA covers only domestic travel, not the cost of International travel 

This type of travel mode must be by rail, air travel or public transport 

Approved discount

Sections 80C, 80CCC and 80CCD (1)

Section 80C is the most widely used option for income tax protection. Here, any person or HUF (Hindu Undivided Family) who invests or spends on prescribed tax protection opportunities can claim a rebate of up to Rs 2,000. One and a half lakh rupees for tax exemption. To save taxes. For some such investments up to a maximum of Rs 1.5 lakh is provided under Section 80C, 80CCC, and 80CCD (1). 

Life insurance premium

Equity Linked Savings Scheme (ELSS)

Employees Provident Fund (EPF)

Anniversary / Pension Schemes

Home loans are the main payment

Tuition fees for children

Contribute to PPF account

 Sukanya Samridhi Account 

NSC (National Conservation Certificate)

Fixed Deposit (Tax Savings) 

Post office deposit 

National Pension Scheme

You may also, like- One byOne Preparation Form 16 Part B in Excel for the F.Y.2020-21 as per new and old tax regime U/s 115 BAC

Medical Expenses and Insurance Premiums (Section 80D)

Section 80D is a discount that you can claim for medical expenses. Treatment paid for the health of the self, family, and dependent parents can save tax on insurance premiums. 

The limit for Section 80D exemption is:

25,000 for premium for self/family.

. Rs 50,000 for a premium paid for senior citizen parents. 

In addition, health checkups up to Rs. 5000 are also allowed and included in the overall limit.

 

Deduction up to Rs 50,000 on medical expenses incurred by senior citizens (years above 60 years or older) or senior citizen parents, if they are not covered by any medical policy. 

The taxpayer can claim a maximum rebate of Rs 50,000 including premium amount and medical expenses if he is a senior citizen 

(60 years or more) In addition, if he pays the medical bills of his senior citizen parents, he can claim a rebate of up to an additional five thousand rupees. 5000 

Your employer can pay a premium on your behalf and deduct it from your salary. Such premium paid is also eligible for discount under section 80D.

You may also, like- Prepare At a time 50 Employees Form 16 Part A&B in Excel for the F.Y.2020-21 as per new and old tax regime U/s 115 BAC

 

Home Interest (Sections 80C and 24B)

Another key tool for tax savings is the interest on the home. Homeowners have the option to claim up to  Rs 2 lakh as an exemption for a house building loan interest

 

In addition to the above, the principal component of a housing loan repayment can also be claimed as a rebate under Section 80C up to a maximum of Rs 1.5 lakh.

 

Deduction for higher studies (Section 80E)

The income tax law provides exemptions for interest in education. Notable conditions involved in claiming this amount of discount are that it should have been taken from a bank or financial institution for higher studies (in Indiaor abroad) by the person or his spouse.Or children.

 

Exemption U/s  80G

Section 80G of the Income-tax Act, 1961 offers an income-tax exemption to an appraiser who contributes to a charitable fund. 50% or 100% deduction of donated amount with or without restriction.

You may also, like- Prepare At a time 100 Employees Form 16 Part A&B in Excel for the F.Y.2020-21 as per new and old tax regime U/s 115 BAC

 

Savings Account Interest Discount (Section 80 TTA)

Section 80 TTA of the Income Tax Act, 1911 offers Rs.10,000 rebate on income earned from savings account interest.

 

Home Interest (Section 80EE)

Section 80EE allows homeowners to claim an additional rebate of Rs.50,000/-

 

Children's allowance

Employers can provide education allowances for your children as part of your salary. Such allowance received by the employer for the education of children is exempt from tax.

However, the employee can claim a maximum of Rs 1200 children per year per chile for a Maximum 2 Child & Hostel Allowances Rs.300 P.M. or 3600/- Per Year.

Prepare At a time 100 Employees Form 16 Part B in Excel for the F.Y.2020-21 as per new and old tax regime U/s 115 BAC

Read More

Automated income tax form 16 Part B details for the F.Y.2020-21

 

Automated income tax form 16 Part B details for the F.Y.2020-21

 

To provide 16 forms to all employees from June of each financial year as per the Income Tax Act and to file income tax returns for the assessment year 2021-22. Form 16 divided into 2 parts, Part A which is generated from the TRACES PORTAL after uploading the TDS Annual Return 24Q or 26Q. And Form 16 Part B is prepared and issued by the employer.

 

As per Budget 2020, a new Income Tax Department has introduced 115 BAC where you can choose an alternative to new and old tax slabs. These are called new and old tax rules. So you should know about the new and old tariff system: -

 

1) If you opt for the new tax system as well, you will not be able to avail of any income tax exemption or exemption under the Income Tax Act except for the NPS facility.

 

But

 

2) If you choose or opt for the Old Tax Regime you can get all the benefits as per the Income Tax Act and you can get the Old Tax Slab as per the tax slab rate for the financial year 2019-20.

 

As per notification No. 39-2019, the Income Tax Department has effectively amended Form 16 Part B from 12th May 2019. That notification clearly states that the Income Tax Site TRACES PORTALand Part 2 of the Compulsory Form 16 Part Form 16 to be downloaded from the 2nd The employer must be prepared by the cutter.

 

Form 16 Part A only shows employee tax deduction and deposited to Central Government. And another Form 16 Part B will show all the coverage of the employee’s Gross total income of the employee

Download and Prepared at a time 50 Employees Automated IncomeExcel Based Software Revised Form 16 Part B for the F.Y.2020-21 as per new and old tax regime U/s 115 BAC

Features of this utility:

# Automatically calculate taxes

# Bulk Generate Form 16 Part B

# Prevent double-entry of employees' PAN card number automatically

# You can create 16 forms with more than 1000 employees with this One Excel utility.

 

How to use the Form 16 Part B utility?

 

Download the utility from the link provided below. This Excel utility has basically 2 sheets for filing employee data. And all other Forms 16 Part B.

 

Update the initial information details and signer details in the master sheet.

After updating the next master sheet you fill out the employee payroll than all of the bulk forms 16 will be automatically filled in including income tax calculation as per new and old tax slab for F.Y.2020-21.

 

Print Form 16 Part B

 

It will be ready for printing when the data-sheet is updated. Now you can open the Form 16 Part B sheet and click the serial number to print the desired employee’s Form 16 Part B/

Download and Prepared at a time 100 Employees Automated Income Excel Based Software Revised Form 16 Part B for the F.Y.2020-21 as per new and old tax regime U/s 115 BAC

 

Read More