Download & Prepare at a time 100 employees Automated Excel Based Income Tax Master of Form 16 Part B for F.Y.2017-18 [This Excel Utility can prepare at a time 100 employees Form 16 Part B for F.Y. 2017-18]
Showing posts with label Automated Income Tax Form 16 Part B for A.Y. 2018-19. Show all posts
Showing posts with label Automated Income Tax Form 16 Part B for A.Y. 2018-19. Show all posts
Tuesday, 24 July 2018
Sunday, 15 July 2018
Prepare at a time 100 employees Form 16 Part B for F.Y.2017-18 & A.Y.2018-19
Click here to Download the Automated Income Tax Salary Certificate Form 16 Part B which can prepare at a time 100 employees Form 16 Part B for Financial Year 2017-18 & Ass Year 2018-19.
The feature of this Excel Utility:-
1) Automated Tax Calculate as per the New Income Tax Slab for F.Y.2017-18
2) Prepare at a time 100 employees Form 16 Part B for F.Y.2017-18
3) Automatic Convert the Amount into the In-Words ( Without any Excel Formula)
4) You can prepare more than 1000 employees Form 16 Part B by this one Software.
5) All the Income Tax Amended Section and siling of the Tax Section have in this Excel Utility as per the Finance Budget 2017-18.
 |
Main Data Sheet for Employer & Employee |
 |
Tax Deduction sheet Section wise |
 |
Automated Form 16 Part B |
Monday, 25 June 2018
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 |
Sunday, 21 January 2018
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.
- Subscriptions to notified bonds of NABARD
- Unit Linked Insurance Plans
- 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.