Download Automated One by One Preparation Form 16 Part A& B and Part B for F.Y.2017-18

Where are few employees with any concern, they can use this One by One Preparation Excel Based Form 16 Part A&B and Part B both in the single file. Most easy to install just like an Excel File and easy to Generate. Govt & Non-Govt are Both Concerned can use this Excel Utility.

Click here to download the Automated One by One Form 16 Part A&B and Part B for Financial Year 2017-18 & Ass Year 2018-19.

Main Input sheet for Employer & Employee

Automated Form 16 Part A&B

Automated Form 16 Part B

Read More

Download Automated Excel Based Form 16 Part B for F.Y.2017-18 ( One by One Preparation Form 16 Part B)

Click here to Download the Automated Income Tax Form 16 Part B for Financial Year 2017-18 & Ass year 2018-19 with the new Tax Slab for F.Y.2017-18. 

This Excel Utility can prepare more than 100 employees Form 16 Part B ( One by One). Most easy to install just like an Excel File and most easy to generate. All the New Amended Income Tax Section have in this Excel Utility.

Main Input sheet for Employer & Employee's details

Automated Form16 Part B

Read More

Automated 50 employees Master of Form 16 Part B for F.Y.2017-18 with exemption of U/s 80C Deduction ay 2018-19 (Section 80C FY 2017-18)

Section 80C Deduction for AY 2018-19 (FY 2017-18) is Rs.1,50,000: Section 80C lists various options where an Individual can invest and claim exemption from income. Foray 2018-19, the deduction under section 80C is limited at Rs.1,50,000. The deduction under section 80C is allowed from your Gross Total Income. The deduction is allowed for various investments, expenses, and payments.  Section 80C Deduction for ay 2018-19 (FY 2017-18) is allowed to Individuals as well as Hindu Undivided Family business.

Details of 80C Deduction for ay 2018-19 (FY 2017-18)

80C Deduction Max Allowable	Rs.1,50,000
80CCD(1)	Including 1.5 Lakh
80CCD(2)	Employer’s to the employee Pension Fund max @ 10% ( Additional deduction excluding U/s 80C
80CCD(1B)	Pension Fund Additional deduction out of 80C 1.5 Lakh

Life Insurance Premiums: Section 80C Deduction

Life insurance premium on the life of himself, spouse and children or paid by a HUF for any member of his family. The insurance premium is deductible subject to maximum ceiling given below.

Provident Fund, Public Provident Fund and other superannuation funds: Section 80C Deduction

Contributing to recognized superannuation fund like Provident fund, Public provident fund, and Mutual funds are eligible for deductions under section 80C.

Usually, the employer invests in such superannuation funds by deducting the investment amount from salary. ELSS constitute a type of Mutual fund which is sold with a lock-in period of 3 years and returns obtained from the ELSS scheme are tax-free.

Any premium paid towards any annuity plan, whether deferred or immediate will give tax relief in that financial year.

Click here to Download Automated 50 employees, Master of Form 16 Part B for F.Y.2017-18 &Ass Year, 2018-19

Main feature of this Excel Utility:-

1) Automatic Income Tax Calculation as per the new Tax Slab for F.Y.2017-18

2) Automatic Prepare at a time 50 employees Form 16 Part B for F.Y.207-18

3) All Amended Income Tax Section have in this utility as per Budget 2017

4) Automatic Convert the Amount to In-Words

5) You can prepare more than 1000 employees Form 16 Part B by this One Excel Utility.

Main Data input Sheet with Deductor Details

Deduction Sheet with Salary Structure

Form 16 Part B

Investments in Infrastructure public Company: Section 80C Deduction

Amount invested in deposit scheme of the public company engaged in infrastructure facility or approved mutual fund.

Bank Fixed Deposits: Section 80C Deduction

Bank fixed deposits which are deductible under section 80C are regular fixed deposits with interest being compounded quarterly with a lock-in period of 5 years.

National Savings Certificates (NSCs) : Section 80C Deduction

Investments in National Savings Certificate are also deductible under this section and these investments are available from the Indian postal services or post offices.

Deposits in various types of accounts: Section 80C Deduction

Any sum deposited in an account under the senior citizen Saving scheme, sum deposited as 5 years time deposit in an account under the post office time deposit, sum deposited in Sukanya Samriddi Account are all eligible for deduction under this section.

Tuition fee: Section 80C Deduction

An Individual can claim deductions on children’s tuition fees only for two children and that too for the educational institutions situated in India only.

1. Subscriptions to notified bonds of NABARD
2. Unit Linked Insurance Plans
3. Repayment of principal amount of loan taken for purchase/construction of house property

The deduction with respect to Home loan repayment can be claimed only if the loan has been taken from specified financial institutions or entities like your employer a public limited company, central or state government, or board, corporation, the university established by law.

In Computing the total income of an individual or Hindu Undivided family, the above contributions, expenses, and investments shall be made available for deduction u/s 80c of the Income Tax Act 1961 capped up to Rs. 1,50,000/- . The legislator’s intention behind the section 80C is to boost investments and savings among the Tax Payers.

Read More

Income Tax Deduction for Medical Treatment, With Automated TDS on Salary for Central & State Govt employees for F.Y.2017-18

Income Tax Act provides a deduction for expenses incurred by a taxpayer for medical treatment of specified disease or ailment under Section 80DDB. In this article, we look at Section 80DDB deduction in detail.

Click here to Download Automated All in One TDS on Salary for Central & State Govt employees for F.Y.2017-18 & Ass Yr 2018-19 [ This Excel Utility can prepare at a time your Tax Computed Sheet + Individual Salary Sheet + Individual Salary Structure as per Central & State Govt  Employees Salary Pattern + Automatic H.R.A. Calculation U/s 10(13A) + Automated Form 16 Part A&B and Form 16 Part B for F.Y.2017-18 with new income tax slab as per Finance Budget 2017]

Section 80DDB

Section 80DDB deduction is allowed from gross total income of an individual assessee for medical expenses incurred during the previous year for medical treatment of specified diseases. The deduction can be claimed for self or a dependent. Dependent means the spouse, children, parents, brothers and sisters of the individual or any of them dependant wholly or mainly on such individual for his support and maintenance.

Amount of Deduction under Section 80DDB

The maximum deduction provided under Section 80DDB is Rs.80,000 or amount spent, whichever is less for very senior citizens. The maximum deduction for senior citizens is Rs.60,000 or amount spent, whichever is less. The maximum deduction for regular taxpayers under Section 80DDB is Rs.40,000 or amount spent, whichever is less.

Eligible Deduction under Section 80DDB

For a deduction to be eligible under Section 80DDB, the taxpayer must obtain a prescription containing the following details from an authorised medical practitioner:

• Name of Patient
• Age of Patient
• Name of disease or ailment
• Name, address, registration number and qualification of Doctor issuing the prescription

Treatment Received from Government Hospital

If the taxpayer received the treatment in a government hospital, the prescription can be issued by any specialist working full-time in that hospital and having a post-graduate degree in General or Internal Medicine or an equivalent degree, which is recognised by the Medical Council of India. The prescription should also contain the name and address of the government hospital.

In addition to Section 80DDB deduction, taxpayers can also claim income tax deduction under Section 80D for medical and health insurance expense.

Read More

Income Tax Deduction for Medical Treatment, With Automated TDS on Salary for Central & State Govt employees for F.Y.2017-18

Income Tax Act provides a deduction for expenses incurred by a taxpayer for medical treatment of specified disease or ailment under Section 80DDB. In this article, we look at Section 80DDB deduction in detail.

Click here to Download Automated All in One TDS on Salary for Central & State Govt employees for F.Y.2017-18 & Ass Yr 2018-19 [ This Excel Utility can prepare at a time your Tax Computed Sheet + Individual Salary Sheet + Individual Salary Structure as per Central & State Govt  Employees Salary Pattern + Automatic H.R.A. Calculation U/s 10(13A) + Automated Form 16 Part A&B and Form 16 Part B for F.Y.2017-18 with new income tax slab as per Finance Budget 2017]

Section 80DDB

Section 80DDB deduction is allowed from gross total income of an individual assessee for medical expenses incurred during the previous year for medical treatment of specified diseases. The deduction can be claimed for self or a dependent. Dependent means the spouse, children, parents, brothers and sisters of the individual or any of them dependant wholly or mainly on such individual for his support and maintenance.

Amount of Deduction under Section 80DDB

The maximum deduction provided under Section 80DDB is Rs.80,000 or amount spent, whichever is less for very senior citizens. The maximum deduction for senior citizens is Rs.60,000 or amount spent, whichever is less. The maximum deduction for regular taxpayers under Section 80DDB is Rs.40,000 or amount spent, whichever is less.

Eligible Deduction under Section 80DDB

For a deduction to be eligible under Section 80DDB, the taxpayer must obtain a prescription containing the following details from an authorised medical practitioner:

• Name of Patient
• Age of Patient
• Name of disease or ailment
• Name, address, registration number and qualification of Doctor issuing the prescription

Treatment Received from Government Hospital

If the taxpayer received the treatment in a government hospital, the prescription can be issued by any specialist working full-time in that hospital and having a post-graduate degree in General or Internal Medicine or an equivalent degree, which is recognised by the Medical Council of India. The prescription should also contain the name and address of the government hospital.

In addition to Section 80DDB deduction, taxpayers can also claim income tax deduction under Section 80D for medical and health insurance expense.

Read More