Income Tax Preparation Software in Excel All in One for the Non-Govt Employees for the F.Y.2022-23

 Income Tax Preparation Software in Excel All in One for the Non-Govt Employees for the F.Y.2022-23

 

Income tax tables and rates remain unchanged in the fiscal year 2022-2023. No changes to the Budget for Individual Taxpayers for 2022 have been announced. Taxpayers will be able to pay taxes under the old or new tax regime. Under the new Tax Regime, tax is levied on taxpayers at preferential rates, but significant tax deductions and exemptions are not allowed. However, income tax deductions and exemptions are available under the old tax system, but the tax rate is high. Individuals need to evaluate their tax liability under both tax systems in order to determine the ideal tax system for them. The old tax system can be beneficial for those interested in using most of the deductions and exemptions. Whereas, the new tax system could be ideal for middle-income groups with small, non-tax-oriented investments.

 

Budget 2022: key takeaways

The tax credit of up to Rs 12,500 under Section 87A is still available for individuals with taxable income up to Rs 5 lakh per annum. This means that individuals with an income of up to Rs 5 lacs will not incur any tax liability in the 2022-23 fiscal year and 2023-2024 valuation. A standard deduction of Rs 50,000 is also available under the old tax regime. Income tax deductions under sections 80C-80U are available under the old system for employees.

 

Employees can significantly reduce their tax liability by taking advantage of tax deductions under the old tax system for the fiscal year 2022-23. In fact, individuals with an income of up to Rs 13 lakh can qualify for full tax exemption by taking advantage of all eligible deductions for the 2022-23 financial year.

 

Income tax deduction and exemption up to Rs 1,50,000 is available for individuals under Section 80C. Section 80CCC and 80CCD (1) are included in Section 80C with an aggregate deductible ceiling of INR 1,50,000/-. Investments that qualify for deduction and exemption under Section 80C include investments in the Public Reserve Fund (PPF), the National Savings Certificate (NSC), the Equity Savings Scheme (mutual funds), Life Insurance and etc.

 

State Reserve Fund: One of the most popular small savings schemes among individuals. PPF offers guaranteed returns along with tax incentives. Interest is reported quarterly and interest accrues annually. Investments are provided with a fixed period of 15 years.

ELSS Funds: The equity savings scheme has the shortest lock-up period of 3 years. The investment is deductible under section 80C. Investments in mutual funds can bring higher returns than debt instruments. However, investments in the capital market are subject to volatility. Therefore, investors need to make an informed decision.

 

Best Equity Savings Scheme for Investment: EF 2022-23

National Savings Certificate (NSC): NSC has a 5-year blocking period. Investments are eligible for tax deductions. However, interest earned is taxable. Investment interest is announced quarterly.

 

Life insurance plans. Premiums paid on life insurance policies are also deductible under section 80C. The premium paid by self, spouse, dependent children and any member of an undivided Hindu family is eligible for a deduction. The post-maturity benefit is tax-free in most cases.

 

Senior Savings Scheme (SCSS): This scheme is designed specifically for seniors and offers the highest returns among small savings schemes. The duration of the program is 5 years with the possibility of extension up to 8 years. Under this scheme, persons over 60 years of age can make deposits.

 

Sukanya Samriddhi Yojana (SSY): The scheme aims at the welfare of the girl. A parent or guardian of a girl under the age of 10 is eligible to join the program. The regime applies to a maximum of 2 girls (3 in the case of twins). The maximum deduction under this scheme is Rs 1,50,000.

 

Income Tax Tariffs and Rates for Fiscal Year 2022-23

The mortgage principal repayment is also deductible along with the registration fee and stamp duty paid on the property. However, the allowance is capped at a maximum deduction limit of INR 150,000/-. Provided that the Individual does not transfer the property before the expiration of 5 years from the Fiscal year in which it was acquired. A registration fee and stamp duty deduction are also available for individuals who have not applied for a mortgage.

 

Income tax deductions U/S 80 CCD (1b)

Deposit up to Rs 50,000 - eligible for deduction under section. The deduction is greater than the available U.S. Section 80C deduction for deposits made in the National Pension Scheme (NPS) and Atal Pension Yojana (APY).

Individuals can invest in these pension schemes to qualify for tax deductions up to a maximum of Rs 50,000/-.

Download Automated Income Tax Preparation Excel-Based Software All in One for the Non-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 Form 12 BA

 

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

 

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

Read More

Tax Saving Tips| With automated income tax software All in One for the West Bengal Govt Employees for the 2022-23 tax years.

 Tax Saving Tips|

 

1. Tuition fees:

The Income Tax Act of 1961 provides for a deduction under section 80C of the Income Tax Act for the payment of children's schooling. This tax savings option is available in Section 80C as well as other investments such as PPF, NSC, ELSS, etc. Tuition fees paid to any registered university, college, school or educational institution are deductible up to Rs. 1.5 thousand.

 

In addition, only tuition fees are deductible under the Income Tax Act. Any other fee such as a donation, development fee, etc., even if paid to such an institution, is non-deductible.

The income tax law allows both parents to claim a deduction up to the amount they paid. Thus, if the total amount paid by the parents is 1 Lakh rupees, of which the father paid 40,000 rupees and the mother paid 60,000 rupees, then both of them can claim this amount individually as they pay.

You may also like- Prepare at a time 50 Employees Form 16 Part B for the F.Y.2021-22

2. National Pension Scheme (NPS)

The NPS or National Pension Scheme has become a popular investment product for income tax savings. This is a tax-saving option that is available to both public and private employees. This allows the contributor to building retirement housing along with a regular monthly income. The amount invested by the depositor is invested in various schemes, including stock markets.

 

There are two types of NPS accounts: level 1 and level 2. A level 1 account has a lockout period until the subscriber reaches the age of 60. Contributions made by a Tier 1 subscriber are deductible in accordance with sections 80CCD(1) and 80CCD(1B). Level 2 accounts are voluntary, allowing the subscriber to withdraw money at any time. However, contributions to Tier 2 accounts are not tax-deductible.

 

Under the provision of Section 80CCD, an individual may claim a deduction of up to Rs. 1.5 Lakh investment in NPS. In addition, a new section 80CCD(1B) was introduced which offered an additional deduction of up to Rs. 50,000/- for contributions made by individual contributors to the NPS.

 

3. Section 80D health insurance premiums:

You can claim a tax deduction of up to 10,000,000 rubles. 25,000 in respect of the following contributions:

The premium is paid to maintain health insurance covering yourself, your spouse, or dependent children.

You may also like- Prepare at a time 50 Employees Form 16 Part A&B for the F.Y.2021-22

 

Any contribution to central government health programs.

Any other scheme may be notified by the central government as eligible for the deduction.

To take care of emergency medical care, health insurance is considered the safest investment option. This allows the taxpayer to enjoy benefits on two fronts. First, have an insurance policy in case of a medical emergency. Secondly, the tax relief is in accordance with the income tax law for investing in an investment product.

 

In addition to the above, an additional deduction for parents' insurance of Rs. 25,000 if under 60 or Rs. 50,000 if they are over 60. If an individual and their parents are over 60 years of age, the maximum deduction available under this section will be Rs. 100000.

 

4. Student loan repayment

The Income Tax Act provides a tax credit for repaying a loan as a tax deduction under section 80E of the Act. You must remember that this tax savings option is available to the payer of the loan. After using the student loan, the interest paid on the student loan is tax-deductible for a maximum period of 8 years or the interest is refunded, whichever comes first.

 

Depending on who pays the EMI for student loans, the parent or child may qualify for the deduction. The Section 80C deduction is only available if you take out a loan from a financial institution and not from family members. You can claim a tax deduction from the year the return began.

 

The tax authorities grant the borrower a moratorium for up to one year from the date of completion to start repaying the loan. This gives the taxpayer enough time to manage their finances and claim the deduction once they start paying off the loan.

 

For example, if a taxpayer repays their student loan within 5 years of the due date, the tax credit will only be available during that 5-year period. Under section 80E, this relief must be claimed for 8 years before taxpayers can take advantage of it. Borrowers should note that their repayment may exceed 8 years, but in such cases, they will not receive a Section 80E tax credit after the 8th year.

Download Automated Income Tax Preparation Excel-Based Software All in One for the West Bengal Government Employees for the F.Y.2022-23As per New Section 115 BAC (New and Old Tax Regime)

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 W.B.Govt Employee’s Salary Structure.

 

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

 

7) Individual Salary Sheet

Read More

Section 80U Deduction | With Form 10 E 2022-23

 Section 80U Deduction | Section 80U of income tax is a deduction for a person with a disability. This

 the section provides a flat deduction for a person with a disability based on the severity of the disability,

 regardless of the amount of expenses.

Conditions for receiving this deduction:

1. Taxpayers must be resident individuals.

2. He must have at least 40% disability.

3. The disability must also be certified by recognized medical institutions.

Tax deduction under section 80U?

*"a person with a severe disability" means -

(i) a person with 80% or more of one or more disabilities as specified in subsection (4) of section 56 of the Persons with Disabilities  or

(ii) a severely disabled person as defined in section 2(o) of the National Autism, Cerebral Palsy, Intellectual Retardation and Multiple Disability Welfare Fund Act of 1999 (44 of 1999).

 

**"person with a disability" means a person identified in paragraph (t) of section 2 of the Persons with Disabilities (Equal Opportunity, Protection of Rights and Full Participation) Act 1995 (1 of 1996) or paragraph (j ) Section 2 of the National Autism, Cerebral Palsy, Mental Retardation, and Multiple Disability Welfare Fund Act of 1999 (44 of 1999);

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

 

What is the u/s 80U deduction available?

As above, the amount of the deduction depends on the severity of the disability. Thus, taxpayers with a disability of less than 80% receive a deduction of Rs 75,000, and taxpayers with a severe disability of 80% or more receive a deduction of Rs. 1,25,000 lakhs. The deduction is a fixed amount that is allowed as a deduction from taxable income.

What disadvantages are covered by section 80U?

The Following types are entitled Under Section 80U

• Musculoskeletal insufficiency: Refers to insufficiency of the muscles or bones of the joints, resulting in severe limitation of limb movement.

• Poor vision: people with visual impairment that cannot be completely corrected with surgery or standard refraction correction. People with this disability can still use their vision with other devices.

• Blindness: - Blindness means no vision at all or when the field of vision is limited to an angle of 20 degrees or worse, or visual acuity less than 6160 on the Snellen scale after corrective lenses.

• Cured leprosy: - People who have been cured of leprosy but still suffer from a disability where they have lost sensation in their legs or arms and have palsy of the eyelids and eyes. It also includes the elderly or people with extreme deformities that prevent them from engaging in any useful activity.

• Mental retardation: people with incomplete or interrupted development of mental abilities, resulting in a subnormal level of intelligence.

• Autism: Autism spectrum disorder is associated with brain development that affects how a person perceives and communicates with others, causing problems in social interaction and communication.

• Cerebral palsy: A cerebral palsy is a group of movement disorders that appear in early childhood. Signs and symptoms vary from person to person and over time but include poor coordination, tense muscles, weak muscles, and tremors. There may be problems with sensitivity, vision, hearing and speech.

• Mental illness: This includes other mental disorders.

A taxpayer is not considered to have a major disability if he or she suffers from a disability equal to or greater than 40% but less than 80%. However, if the taxpayer suffers from a disability of 80% or more, this will be considered a severe disability.

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

 

How do I get a Section 80U deduction?

The person applying for the deduction must provide a copy of the certificate issued by the medical institution in the prescribed form, along with the engineer. There is practically no need to attach any documents to the ITR, it is advisable to keep the document at hand.

Please note that a medical certificate confirming the disability received is required. The certificate must be prepared by a recognized medical institution in the prescribed format, which is contained in Form 10-IA. The form can be found on the Indian income tax website.

 

 

So it simply means that if you make a deduction under this section, keep a certificate with you that you can get from an authorized physician.

It is also a good idea to keep your prescription and medical card in case the IRS requests them in the future.

 

The medical certificate must contain information about the disability of the taxpayer.

The certificate of disability has a certain period of validity. If the certificate expires in any fiscal year, a deduction for that fiscal year can be claimed using the expired certificate. However, beginning in the next fiscal year, you will need to use a new certificate to receive your Section 80U deduction in the following year.

Section 80U and section 80DD and 80DDB

 

Section 80U and section 80DD is often confused because both sections allow deductions for persons with disabilities. However, the main difference between these sections is that while Section 80U provides for deductions for a taxpayer with a disability, Section 80DD allows deductions if the taxpayer has a dependent with a disability.

 

In the case of an individual, the dependent may be a spouse, children, parents or siblings, and in the case of a HUF, a member of the HUF. In addition, a Section 80DD deduction is permitted if the taxpayer has incurred medical, drug, tuition, or rehabilitation costs for a disabled dependent. Therefore, both sections have different meanings and tax implications and should not be confused with one.

 

Whereas pursuant to Section 80DDB, if an Individual or HUF incurs any cost of treating Certain Diseases for themselves or a relative, they may receive a tax credit.

Download Automated Income Tax Arrears Relief Calculator U/s89 (1) with Form 10 E from the Financial Year 2000-01 to F.Y.2022-2023

Read More

5 new rules are being introduced in the income tax in April 2021 with Automated Income Tax Form 16 for the F.Y.2020-21

 

5 new rules are being introduced in the income tax in April 2021. Changes have been made in the field of income tax in line with the new labour and wage policy. 

Union Finance Minister Nirmala Sitharaman announced several new policies on income tax in the Union Budget. The new policy is going to be effective from  1st April 2021.

 

A number of new policies are being introduced to ensure that more citizens file their income taxes on time. That is why the new tax policy is being introduced in the case of PF. Besides, the Union Finance Minister has also announced an increase in TDS and TCS. Not only that, changes have been made in the field of income tax in line with the new labour and wage policy. The Union Finance Ministry has also tried to facilitate the process of paying income tax. Pre-field income tax return application is being introduced.

 

Take a look at what changes are coming from April 1:

1

1) Benefits for Senior Citizens:

Those aged 65 and above who are dependent on full pension and bank interest money for income does not have to file income tax returns. The money will be deducted from the bank where they get their pension.

2

2) Pre-filled Income Tax Return Form:

Every taxpayer will get a pre-field income tax return form. This means that all the information of the taxpayer will be filled in the form beforehand. All the information like income, interest income from savings, payment of tax etc. will be mentioned there in advance. So the tax payment process will be easier.

Download Automated Income Tax Revised Form 16 Part A &B and Part B which can prepare One by One Form 16 for the F.Y.2020-21

3YouY

3) New tax policy for PF:

If more than Rs 5 lakh is deposited on behalf of the employee for PF, the tax will be applicable from now on. Tax will be levied on the interest accrued on deposits above Rs 5 lakh. However, in this case, the money that the employer is depositing will not be caught.

In the words of the Union Finance Minister, 'The new EPF policy should be done keeping in mind the interests of the workers. This policy will not have any effect on a person earning less than Rs 2 lakh per month.

4

4) TDS:

In this case, the main purpose of the new policy is to encourage more citizens to file income tax. In this year's budget, the finance minister has announced an increase in TDS and TCS.

The Union Finance Minister also announced the addition of two new sections, 206AB and 206CCA, to the Income Tax Act in the budget. According to this policy, those who do not file income tax will be deducted TDS and TCS at an extra rate.

5

5) LTC:
In the Union Budget 2021, the Finance Minister announced tax exemption on Leave Travel Concession (LTC). The centre announced the policy during the Corona Lockdown last year. This year the workers will get the whole money. Basically, government employees will benefit from this.

 

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

Read More

Most common Investments and how they are Taxed in F.Y. 2019-2020 With Automated Income Tax Preparation Excel Based Software All in One TDS on Salary for Non-Govt Employees for F.Y. 2019-20

Tax collection assumes a significant job in the profits created by your venture thus you should know how the speculation is saddled before you pick one. We list down the most widely recognized speculations and how they are saddled?

• Interest earned in Saving financial balance up to Rs 40,000 is absolved from charge u/s 80TTA. Any intrigue more than Rs 40,000 is added to your salary and exhausted at personal assessment chunk rates.

• Senior resident can guarantee charge exception up to Rs 50,000 on premium pay from bank/post office fixed store, investment account up to Rs 50,000 u/s 80TTA

• This is additionally appropriate for Post Office Savings Account

Download Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E from F.Y. 2000-01 to F.Y. 2019-20

1.Bank Fixed Deposits:

•           The whole premium earned on Bank FD is added to the salary and saddled by the personal assessment chunk rates.

•           However from FY 2018-19 premium salary got from Bank/post office FD/RD is charge absolved up to Rs 50,000 under new Section 80TTB.

•           TDS of 10% is deducted if the yearly intrigue surpasses Rs 40,000 (changed in Budget 2019) and Rs 50,000 if there should arise an occurrence of senior residents. Enthusiasm over all Fixed Deposit/Recurring Deposit accounts over all parts of a bank is contemplated to land at the all out yearly premium figure for TDA.

•           If NO PAN is connected to the FD account the TDS rate is 20%.

Likewise Read: Highest Interest Rate on Bank Fixed Deposits

Download Automated Income Tax Automated Revised Form 16 Part B for F.Y. 2019-20 [This Excel Utility can prepare One by One Form 16 Part B]

2. PPF (Public Provident Fund)

•           The intrigue got is tax exempt

3. Senior Citizen Saving Scheme:

•           The intrigue got is added to salary and burdened at peripheral annual duty rates.

4. NSC/KVP

•           The intrigue got is added to salary and burdened at peripheral annual duty rates.

•           There is NO TDS.

5. NPS:

•           40% of corpus ought to be utilized to purchase annuity. The regularly scheduled compensation out got is completely assessable.

•           Remaining 60% of the development corpus is tax exempt (successful April 1, 2019)

Download Automated Income Tax Revised Form 16 Part A&B and Part B for F.Y. 2019-20 [ This Excel Utility can prepare One by One Form 16 Part A&B and Part B ]

6. EPF (Employee Provident Fund)

•           Maturity sum got structure EPF is completely tax exempt on the off chance that you have consistent help of over 5 years.

•           In case the administration time frame is under 5 years, the sum is assessable according to annual expense section rates.

•           TDS at 10% is deducted for untimely and assessable withdrawal of assets from EPS, if the installment is more than Rs 50,000.

•           In case the PAN data isn't outfitted the TDS would be deducted as 20%

Download Automated Income Tax All in One TDS on Salary for only Non-Govt Employees (Private Employees ) [ This Excel Utility can prepare at a time your Tax Computed Sheet + Automatic H.R.A. Calculation U/s 10(13A) + Automated Form 16 Part A&B in New Revised Format and Revised Income Tax Form 16 Part B + Automated income tax form 12 BA]

7. ULIPs:

•           The development sum is tax exempt if the premium paid for every one of the years are under 10% of the development sum.

•           Surrender sum, early fractional withdrawals absolved from charge following 5 years

•           TDS at 2% if the all out receipts surpass Rs 1 Lakh.

Read More

Chapter VIA List of All Deductions at a Glance, With Automatic Master of Form 16 Part B for 100 and 50 employees for F.Y.2016-17

Download Automatic Master of Form 16 Part B for 100 & 50 Employees for F.Y. 2016-17.

1) Download Master of Form 16 Part B for 100 employees for F.Y.2016-17

2) Download Master of Form 16 Part B for 50 employees for F.Y.2016-17

The feature of this Excel Utility:-

1) Automatic Income Tax Calculate as per Tax Slab 2016-17

2) Prepare at a time 100 employees and 100 Employees form 16 Part B for F.Y.2016-17

3) Automatic Amount into the In-Words 

4) You can prepare more than 1000 employees Form 16 Part B

5) All the Income Tax Amended Section have in this Excel Utility

Chapter VIA List of All Deductions at a Glance, List of all Income Tax deductions from u/s 80C to 80U. Hi, Friends Here we are providing a list of all deductions covered under  Chapter VIA of Income tax act. In this article, we provide the complete list of deductions with Name of Section, Brief details for Section, List of Assessee’s who can avail that exemption, Amount of Deduction etc. Find Short details for Every Deduction like – Deduction under Section 80C, Maximum Deduction allowed u/s 80C, Deduction u/s 80CCC, Deduction u/s 80G, Deduction u/s 80U, Deduction u/s 80E, Deduction u/s 80D, Deduction u/s 80IA etc. Recently we provide a special article on “Paying Tax is better than Saving Tax!“. Now you can scroll down below and check more details for Chapter VIA List of All Deductions at a Glance

Chapter VIA List of All Deductions at a Glance

In this article, we provide a list of all Deductions are available under Chapter VIA of Income tax. In this article, we provide a list of all deductions by section wise covered under Chapter VIA. Now check below table for Chapter VIA List of All Deductions at a Glance.

Sections	Particulars	Allowed to	Quantum of deduction
80C	Deduction in respect of Life Insurance Premium, Contribution to Provident Fund, etc. Deduction in respect of contribution to certain pension funds	Individual and HUF	Max. Rs.1,50,000
80CCC	Deduction in respect of contribution to certain pension funds	Only individuals	Max. Rs.1,50,000
80CCD (1)	Deduction in respect of contribution to notified pension scheme of Central Government	Salaried employee or self-employed individual	Employer and employee contribution not exceeding 10% of salary in each case. Maximum deduction to an employee or self-employed person for his contribution limited to Rs.1,00,000
80CCD(2)	Deduction in respect of contribution to the Employee’s Pension Fund by the Emplyer	Salaried employee or self-employed individual	Contribution to the Employee’s Pension Fund by the Employer.This Additional Deduction out of the limit of U/s 80C Max. Rs.1.5 Lakh
80CCD(1B)	Additional deduction U.s 80C out of 1.5 Lakh to the employees Pension Scheme	Salaried employee or self	Max Rs. 50,000/ as additional deduction out of 1.5 Lakh.
80CCE	Limit on deductions under sections 80C, 80CCC and 80CCD (1)	N.A.	Rs.1,50,000
80CCG	Deduction in respect of investment made in an equity saving scheme	Individual who is resident in India	50%  of the amount invested or Rs.25,000 whichever is less
80D	Deduction in respect of medical insurance premium	Individual or HUF whether resident or non – resident	In case of individual – Maximum Rs.25,000 & Rs. 30,000/- for Sr.Citizen
80DD	Deduction in respect of maintenance including medical treatment of dependent who is a person with disability	For senior citizen Individual or HUF resident in India	Addl. Rs.5,000 Rs.75,000 or Rs.1,25,000 in case of a person with severe disability
80DDB	Deduction in respect of medical treatment, etc.	Individual or HUF resident in India	Max.Rs.60,000
80E	Deduction for interest paid on loan	For senior citizen Individual whether resident or not	Addl. Rs.20,000 Actual amount paid
80EE	Deduction in respect of interest on loan sanctioned during the financial year 2013 – 14 for acquiring residential house property	Individual only	Maximum Rs. 50,000
80G	Deduction in respect of donations to certain funds, charitable institutions, etc.	All assesses	(a)   100% or 50% of eligible donations, without applying qualifying limit in certain cases

Read More