Download & Prepare at a time 100 employees Form 16 Part B in Excel for the Financial Year 2014-15 and Assessment Year 2015-16

Now time is prepare the Income Tax Salary Certificate Form 16 Part B for the Financial Year 2014-15, Just put your Gross Salary Income and Deduction from Salary in Salary Sheet which Salary Sheet prepared for the Both of Govt and Non Govt - employees.This Excel Based Software can Prepare more than 1000 employees form 16 just a moment.

First you can prepare 100 employees Form 16 with the Automatic Calculation of all Income Tax Calculation and Tax Liability as per the Income Tax Slab for the Financial Year 2014-15 and Assessment Year 2015-16.

If you have in your hand this type of Excel Based handy Software, have no problem to prepare more than 1000 employees Form 16 within a short period.

                           Snapshot of Tax Deductor Sheet

Snapshot of Tax Deduction Sheet as per Tax Section (Modified)

           Snapshot of Automated Form 16 Part B in Excel

Feature this Utility :-

• No need to manual Calculation for Tax Liability
• No need to Manual type the Amount to Word, this will convert the amount to in words automatically.
• All the Income Tax Section have in this Utility, which some fit for Govt concerned and some fit for Non- Govt Concerned both.
• This Utility can use the Both of Govt and Non Govt Concerned.
• Easy to understand and easy to Save in your Computer

Download this Utility from the below link: 

Download Master of Form 16 Part B ( Prepare at a time 100 employees Form 16 Part B)

On May 12, 2015 by www.taxexcel.net

Share It

No Comments

Read More

Most of the Govt and Non Govt concerned prepare the Income Tax Salary Certificate Form 16 Part A and Part B by manually to their employees.It is most difficult to make out the Income Tax Calculation as per the Income Tax Law or Norms and it is most hazard to prepare manually the Form 16 for each employee's Form 16. Although now the most of Govt and Non Govt Concerned have the Computer and they prepare the Form 16 through their Computer.  As per the  CBDT Notification  the Format of Form 16 have fully Changed dated 19/2/2013. 

Below given the Automated New Amended Form 16 preparation Excel Based Software which can prepare the Form 16 Part B and Part A&B both just a moment. This Utility can prepare the Form 16 One by one for the Financial Year 2014-15 and Assessment Year 2015-16. In this Excel Utility have all the new amended Income Tax Section and the new Tax Slab for the Financial Year 2014-15 as per the Finance Budget 2014-15

Click here to download the Automatic Form 16 Part B and Part A&B for FY 2014-15 (One by One Preparation of Form 16)

On January 01, 2015 by www.taxexcel.net

Share It

No Comments

Read More

Download and Prepare at a time Tax Compute Sheet +Arrears Relief U/s 89(1) +Form 10E+HRA Calculation U/s 10(13A) +Form 16 Part A&B and Part B for the Financial Year 2014-15 & Assessment Year 2015-16

As you are aware, the Union Budget for FY 2014-15 was tabled in the Parliament by the Finance Minister of India on 10-Jul-2014. There are some changes to the computation of tax on salary which payroll managers need to consider for FY 2014-15.

1. Changes in tax rates

The revised tax rates for salaried employees (aged 60 years and below) for FY 2014-15 are as follows.

Total Income for the Year in Rs.	Tax Rate in %
Up to 2,50,000	Nil
2,50,001 to 5,00,000	10
5,00,001 to 10,00,000	20
Above 10,00,000	30

The revised tax rates for salaried employees (aged above 60 years but below 80 years) for FY 2014-15 are as follows.

Total Income for the Year in Rs.	Tax Rate in %
Up to 3,00,000	Nil
3,00,001 to 5,00,000	10
5,00,001 to 10,00,000	20
Above 10,00,000	30

2. Increase in deduction under Section 80C [Click to view total list of U/s 80C]

The deduction under 80C (Life insurance premium, PPF, investment in National Savings Certificate, interest from notified bank deposits, principal repayment on housing loan, etc.) was restricted to Rs.1 lakh in 2013-14. The same has been increased to Rs. 1.5 lakh for 2014-15.

Consequent to the change in section 80C, section 80CCE has been amended so as to raise the limit of aggregate deduction under sections 80C, 80CCC and 80CCD from Rs. 1 lakh to Rs.1.5 lakh.

3. Increase in deduction under Section 24 – Interest on housing loan[View Section 24B what says as tax Rules)

The tax deduction on housing loan interest payment (for a self occupied property) was restricted to Rs. 1.5 lakh per annum in FY 2013-14. For the year 2014-15, the limit has been increased to Rs. 2 lakh.

There is no reference to Section 80EE in the Finance Bill for FY 2014-15. Hence, the carry forward of unutilized tax deduction for first time owners of residential property, if applicable, is available for FY 2014-15.

Note:
1. The Education Cess stays at 3%.
2. In case the total taxable income goes beyond Rs. 1 crore in the year, a surcharge of 10% (subject to marginal relief) is to be deducted – as it was in FY 2013-14.

What about the tax credit of up to Rs. 2,000?[View Section 87A]

We have received queries from payroll managers regarding the availability of Rs. 2,000 tax credit in FY 2014-15. The Financial Bill tabled in the Parliament does not provide for the removal of tax credit under Section 87A. Hence, the tax credit of Rs. 2,000 is available for FY 2014-15 as long as the total income does not exceed Rs. 5 lakh for the year.

On November 20, 2014 by www.taxexcel.net

Share It

No Comments

Read More

Click to download the Automated All in One TDS on Salary ( This Excel Utility Can prepare at a time Tax Compute Sheet + Automatic HRA Calculation + Automated Form 16 Part A&B and Part B) for the Financial Year 2014-15. This Excel Utility can use both of Govt and Non-Govt Employees. 

The deduction u/s 80DDB is available if the expenses for the medical treatment of specified disease or ailment is incurred by assessee on himself or on dependant. The specified disease for the purpose of section 80DDB is prescribed in Rule 11DD as under:-

11DD. (1) For the purposes of section 80DDB, the following shall be the eligible diseases orailments :

(i) Neurological Diseases where the disability level has been certified to be of 40% and above,—
(a) Dementia ;
(b) Dystonia Musculorum Deformans ;
(c) Motor Neuron Disease ;
(d) Ataxia ;
(e) Chorea ;
(f) Hemiballismus ;
(g) Aphasia ;
(h) Parkinsons Disease ;
(ii) Malignant Cancers;
(iii) Full Blown Acquired Immuno-Deficiency Syndrome (AIDS) ;
(iv) Chronic Renal failure ;
(v) Hematological disorders :
(i) Hemophilia ;
(ii) Thalassaemia.
The amount of deduction allowable under section 80DDB is the expenditure actually incurred or Rs. 40,000/- (Rs. 60,000/- for senior citizen) whichever is lower.

Deduction under section 80U of the I.T. Act, 1961 is available to an individual who is resident and who at any time during the previous year is certified by a medical authority to be a person with disability.
“Person with Disability” means a person suffering from not less than 40% of any of the disability given below:
i) blindness
ii) low vision
iii) leprosy-cured
iv) hearing impairment
v) locomotor disability
vi) mental retardation
vii) mental illness
viii) austim
ix) cerebral palsy
x) multiple disability referred to in clauses (a), (c), & (h) of section 2 of the National Trust for welfare of persons with Austim Cerebral Palsy, Mental Retardation & Multiple Disabilities Act-1999.
The deduction under this Section is a sum of Rs 50,000/- in normal cases and if the person is suffering from a severe disability (80% or more) then with effect from F.Y. 2009-10, a sum of Rs. 1,00,000/- is allowable as deductions.

Click to download automatic Form 16 Part A&B and Part B for Financial Year 2014-15

On November 07, 2014 by www.taxexcel.net

Share It

No Comments

Read More