Showing posts with label Income Tax Form 16 in Excel. Show all posts
Showing posts with label Income Tax Form 16 in Excel. Show all posts

Friday, 1 July 2022

Tax Savings tips for the F.Y.2022-23| With automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E for the F.Y.2022-23

 Tax Savings tips for the F.Y.2022-23 | How to save tax or rather how to plan your investment is a

 question that bothers each one of us. While tax planning is crucial, taxes saving schemes are also

 essential. You can save tax and earn returns with the best tax-saving schemes in India. The ideal time to

 plan for tax-saving investments is the beginning of the financial year. This will ensure you don’t pay

 more taxes and save taxes in Indiaalong with year-long returns on tax-saving investments.

 

While we all aim to save taxes in Indiawhy do only a few of us succeed? The answer could be a lack of knowledge or struggles in fitting the best-suited choice in your investment planning. In this article, we have listed each of the best tax-saving investment options in Indiato help you compare and make a well-informed investment decision. 

 

While planning on how to save tax in India, you must also ensure that your goal is not just tax saving. The goal must be to invest in the best-suited investment option along with income tax savings. We have listed the best tax-saving scheme options for 2020-21 in this article.

You may also like- Automated Income Tax Form 16 Part B One by One Preparation software in Excel for the F.Y.2021-22

form 16 Part B

1. Unit Linked Insurance Plan (ULIP)

ULIP Life Insurance Plan is one of the most important investment plans in India. It ensures that one’s family is financially balanced in the case of an event of death. By purchasing a life insurance policy, the taxpayer can avail of the benefit under the income tax act.

 

Under section 80C of the income tax act 1961, the premium paid towards the purchase of a life insurance policy qualifies for deduction up to Rs. 1.5 lakh. Furthermore, as per section10(10D) income on the maturity of the policy is tax-free. The income is tax-free if the premium is not more than 10% of the sum assured. In the case wherein the money goes to the nominee of the person insured, the same remains as a tax exemption in the hands of the nominee.

 

In terms of the deduction under section 80C 1961, the taxpayer can claim 20% of a tax deduction on the premium paid. The following conditions also apply:

1. The taxpayer purchases a life insurance policy on or before 31st March 2012

2. The policy is in his own name or in the name of their spouse or child

If the life insurance policy is purchased after 1st April 2012, then the premium paid is eligible for tax deduction up to 10% of the sum assured.

 

2. ELSS Mutual Funds

Equity Linked Savings Schemes are mutual fund investment schemes that invest a large percentage of their portfolio in equity. Furthermore, the fund has a mandatory lock-in period of 3 years which is the shortest among all the investment products.

 

Investment in ELSS funds qualifies for deduction under section 80C of the income tax act up to a maximum of Rs. 1.5 lakh. Both lump sum investment and the amount invested through a systematic investment plan (SIP) qualify for the deduction. Since ELSS funds invest a large amount in equity, there is always some inherent risk.

ELSS funds provide the dual benefit of capital appreciation and tax savings. This makes it one of the most popular tax-saving schemes amongst investors.

You may also like- Automated Income Tax Form 16 Part A&B One by One Preparation software in Excel for the F.Y.2021-22 

Income Tax Form 16

In general, taxpayers who want to claim tax deductions of up to Rs 1.5 lakh under Section 80C provisions and are willing to take some risk should consider investing in ELSS. These mutual funds are equity-oriented, and they invest a minimum of 60% of their portfolio in equity and equity-linked instruments. This makes it crucial to be invested in the funds for a long period of time in order to reap the benefit of the returns.

Learn: How to Save Tax by Investing in Mutual Funds

 

3. Public Provident Fund (PPF)

The Public Provident Fund has always been a popular tax-saving scheme among the taxpayer. One of the major reasons for this popularity is the fact that PPF falls under the category of exempt tax status. You can open your PPF accounts with a bank or post office.

 

Taxpayers can claim a deduction under section 80C of the income tax act for the amount invested by them during the financial year. The maximum amount eligible for deduction is Rs. 1.5 lakhs. Since PPF falls under the exempt category, the interest and maturity amount are exempt from tax.

 

PPF account comes with a lock-in period of 15 years and it allows the investors the below options at the end of the maturity period:

Download Automated Excel Based Income Tax Salary Arrears Relief Calculator U/s 89(1)with Form 10E from the Financial Year 2000-01 to the Financial Year 2022-23 (Updated Version)

Tax Savings tips for the F.Y.2022-23
Tax Savings tips for the F.Y.2022-23

Tax Savings tips for the F.Y.2022-23

Monday, 20 December 2021

Download Automatic Income Tax Form 16 Part A&B and Part B for the F.Y.2021-22 as per Old and New Tax Regime U/s 115 BAC

 

As the Financial Year 2021-22 is going to end, and now time to prepare the Form 16 by the all of Employers/Dedicators for distribution the Salary Certificate Form 16 to their employees.

 

And Employees also filling their Income Tax to the Central Board of Income Tax within 31st July 2022 as per the norms by the Income Tax Act 1961.If you prepare the Form 16 from this time, so you can easily delivered the Form 16 to your employees in the stipulated time. 

Budget 2021

In this regard we prepared the unique Excel Based Software for preparing the Form 16 Part A&B and Part B for the Financial Year 2021-22 and Assessment Year 2022-23. These all of Excel Based Form 16 prepare as per the Budget 2021 and the norms of section 115 BAC as Old and New Tax Regime.

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)

Download Automatic Income Tax Form 16 Part A&B
 2) One by One Preparation, Automatic Form 16 Only Form 16 Part B for the Financial Year2021-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)

 

Download automatic Income tax Form 16 Part A&B

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)

Form 16 data input sheet

 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)

Form 16 Part B
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)

 

Master sheet

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)

Form 16 Part A&B


Thursday, 6 May 2021

What is Salary Certificate Form 16? Download Auto Fill Income Tax Revised Form 16 Part B for the F.Y.2020-21 as per U/s 115 BAC

 

Form 16 is a document or certificate issued to salaried professionals in India by self employers under Section 203 of the Income Tax Act, 1961

 

It has details of the salary paid to the employee by the employer in the F.Y. and the tax deducted from the salary by the deductor as well as the employer.

 

TDS deducted by the employer is credited to the income tax department and instead, Form 16 is the proof. Employers must issue Form 16 to their employees on or before June 15 of the financial year that the income was immediately collected and tax deducted.

 

Eligibility Criteria for Form 16?

 

Every salaried person under the taxable bracket is eligible for Form 16 is. If an employee does not fall within the prescribed tax brackets, he/she does not have to deduct tax at the source (TDS).

 

Form 16 the elements of Form 16 are subdivided into the following two parts which include:

Form 16 Part A and

Form 16 Part B

Form 16 Part A

Download and Prepare One by One Form 16 Part B for the F.Y.2020-21 as per the New and Old Tax Regime U/s 115 BAC 

One by One Form 16

Part A gives the summary of the salary income collected by the employer on behalf of the employee and deposited in the government account. It is a certificate duly signed by the employer which they deducted TDS from the employee's salary and submitted to the income tax department. This Form 16 Part A mandatory to download through the Income Tax TRACES PORTAL. 

Income Tax Form 16 Part A

This Form 16 Part A has the following details:

Employee's as well as employer's information

 

Individual and employer name, address details,

 

PAN details of both, and TAN details of the employer.

 

Evaluation Year (A.Y)

The period for which the individual was employed with the employer in the financial field 

Summary of paid salary

Date of tax deduction from salary

Date of submission of tax to government account

 

Three months Interval the tax deduction and submission to the Income Tax Department

 

Recognition number of TDS payment

 

Form 16 Part B  is a compilation of details of the salary paid, any other income declared by the employee to his organization, the amount of tax payable, and if any tax payable is paid as an addition to Part B of Form 16, it includes Presents information on applicable discounts as well. The names and details of the employees like PAN are also mentioned in the passage 

Income Tax Revised Form 16 Part B

It contains the following information:

 

Total salary received

 

Exempt allowed U/s 10 (5),10 (10), 10 (10A), 10 (10AA), 10 (13A), any other discount amount U/S 10.

 

The standard exemption is allowed under section 103 of the Income Tax Act.

 

Income (or perceived loss) from the home property reported by the employee proposed for TDS,

 

Other sources of income under the head are proposed for TDS.

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

Data input sheet for Form 16


 

Fields are available for the amount of total salary received from other employers. 

Income Tax deduction from the salary:-

Section 80C / 80CC / 80CCD / 80D / 80E / 80G / 80TTA and other applicable sections are supplied.

 

All these discount details must be submitted to the employer by the employee along with the required supporting documents.

 

Net taxable salary

 

Scholarship fees and surcharges if any. If applicable, exempt under section 87 released under Section 89, if any

 

The amount of total tax payable on income. Tax-deductible and balance tax applicable or refundable.

 

Download Form 16

Form 16 Part A Portion downloaded and issued by the employer. No one can download his Form 16 Part A For each employer in a financial year

 

In the case of people who have changed jobs as well as worked with more than one employer in a particular financial year, they will receive a separate Form 16 from all employers.

Download and Prepare at a time 100 Employees Form 16 Part B for the F.Y.2020-21 as per the New and Old Tax Regime U/s 115 BAC

Tax Sheet

Income Form 16 Part B


 

The link between Form 16 and Form26AS?

 

The 26AS form will be submitted with all taxes and deductions from your salary and/or unpaid income to the concerned authorities. Thus, the tax exemption displayed on Form 16 / Form 16A can be cross-checked and verified using Form 26AS. Ideally, the amounts of TDS deducted in Form 26AS and Form 16 A must match. If there is any discrepancy, the Tax Department considers the TDS figures as only 26 forms.

Thursday, 22 April 2021

Deduction U/s 80DD in case of support including treatment of a disabled person with Automated Income Tax Form 16 for the F.Y. 2020-21

 

(I) Qualified Assessor

 

This exemption U/s 80 DDD is for any person who is an inhabitant of Indiaor endorsed for HUF.

 

Deduction rate 

Income Tax Section 80DD

The assessee will be permitted a fixed deduction of 75 thousand (Rs. 5,000) from the complete payment for the earlier year.

 

(I) A Deduction of Rs. 1,25,000/ - will be given to such dependents where there is an extreme handicap.

 

(ii) Terms

 

(A) Deduction are permitted on the off chance that they are spent:

Clinical treatment (counting nursing) preparing and recovery of a dependent, being a disabled person or a payee or any amount stored under the timetable recommended by the Life coverage Organization or some other back up plan or executive for the dependent as a disabled person UTI or explicit office for support.

You may also, like- Automated Income Tax Revised Form 16 Part B for the F.Y.2020-21 [This Excel Utility can prepare at a time 50 Employees Form 16 Part B as per new and old tax regime U/s 115 BAC]

 

(B) In the previously mentioned conspire, in case of death of any person or individual from a Hindu undivided family, the arrangement has been made to pay a yearly or single amount to assist a dependent who is a disabled person whose name has been bought into this plan.

 

(C) The assessor designates a person with an incapacity, a person with an inability or some other person or a trustee as a trust to pay for his sake to assist the dependent.

 

(D) If the dependent is a person with an incapacity, an individual from the Hindu Undivided Family or an amount equivalent to the amount paid or stored as in the past, he will be treated as the payment of the past appraiser in the year in which the amount is gotten by the appraiser. Will be relevant for charges.

You may also, like- Automated Income Tax Revised Form 16 Part A&B for the F.Y.2020-21 [This Excel Utility can prepare at a time 50 Employees Form 16 Part B as per new and old tax regime U/s 115 BAC]

 

(E) A duplicate of the authentication gave by the clinical expert in the endorsed structure and way surveyed by the assessor looking for exemption under this section and in case of a discount of pay under section 139, the appraisal will send the exemption in the year.

 

The state of persons with handicaps is that in case of need to rethink the amount after the time recommended in the aforementioned declaration, any evaluation identifying with any earlier year under this section won't be permitted after the termination of the previously mentioned authentication. No new testament is acquired until it very well may be resolved and a duplicate of it is organized with the arrival of pay.

 

 

Clinical Exemption (Section 80DDB)

 

(I) Qualified Assessor

 

This exemption is permitted to any person or HUF who lives just in India.

 

(ii) Terms

 

(A) The assessor has truth be told paid any amount for the treatment endorsed by the Board or for the treatment of the sickness or treatment recommended by this standard.

 

(B) On account of a distinctive person leading the evaluation, the consumption will be borne without anyone else or the dependent

 

(C) Use for any individual from a surveying Hindu Undivided Family might be Hindu Undivided Family.

 

(d) "Dependent" signifies:

You may also, like- Automated Income Tax Revised Form 16 Part B for the F.Y.2020-21 [This Excel Utility can prepare at a time 100 Employees Form 16 Part B as per new and old tax regime U/s 115 BAC]

 

On account of any person, life partner, kids, guardians, kin or any of them,

 

On account of Hindu undivided families, Hindus are individuals from undivided families.

 

Absolutely dependent or fundamentally for him in this public or Hindu undivided family

 

Backing and support.

 

(iii) Deduction rate

 

(A) For 'Non-Old Patient' (age under 60 years)

 

The amount really spent; Or Rs 40,000 not exactly the earlier year, whichever is less

 

Such an amount was really given.

 

(B) A 'senior citizen' (age 60 years or more)

 

On account of any individual from the Hindu undivided family who is really evaluating the amount paid or his dependent or assessor and who is a senior citizen, a Deduction of Rs. 1,00,000 will be permitted under this section.

 

"Senior Citizen" signifies an individual occupant in India, who is sixty years old or more established whenever during the important earlier year.

 

(iv) Treatment for getting clinical protection claims

 

The exemption under this section will be deducted by the amount paid by a guarantor under protection or by a business for the treatment of the above person.

 

(v) Duplicate of Prescription [Replacement of First Arrangement in Section 80 DDB]

You may also, like- Automated Income Tax Revised Form 16 Part A&B for the F.Y.2020-21 [This Excel Utility can prepare at a time 100 Employees Form 16 Part A&B as per new and old tax regime U/s 115 BAC]

 

The exemption won't be permitted under this section except if the assessing nervous system specialist, an oncologist, urologist, haematologist, immunologist or some other expert has gotten a duplicate of the prescription for such treatment.

 

(vi) Illnesses allowed u/s 80DDB [Rule 11DD]

 

Neurological illnesses:

 

(A) Dementia

 

(B) Dystonia solid deformation

 

(C) Engine neurone illness

 

(d) Ataxia

 

(E) Korea

 

(F) Hemiblimus

 

(G) Asia

 

(H) Parkinson's infection

 

Malignant growth

 

Completely AIDS (Helps)

 

Constant renal disappointment

 

Hemophilia

 

Thalassemia.