It's time for first working of any works at your office, but the Income Tax Calculation with all exemption like as House Rent Exemption Calculation or Arrears Relief Calculation with Form 10E OR prepare the Form 16, if you can do one by one, there can take much time to prepare and calculation the above all calculation. Also if your Concerned have more than 40 or 100 employees who're the preparation of all of above calculation one by one it will be a hazard and take huge time to prepare the same of all employees calculation. 

      But If you have one unique Excel Based Software like as All in One TDS on Salary, which can prepare at a time your (Income Tax Computed Sheet + Arrears Relief Calculator U/s 89(1) + Form 10E + House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B) for the Govt. & Non-Govt. employees with all amended by the Finance Budget 2017-18. So it will be easy to prepare and preserve the all of the Calculation in future.

      You can treat this Excel Utility as an Advance Tax Calculator and guess the all employees Taxable Income with all deductions at a glance.

Download the All in One TDS on Salary for Govt and Non-Govt Employees for the Financial Year 2017-18 & A.Y. 2018-19. [ This Excel Utility Can Prepare at a time Income Tax Computed Sheet + Arrears Relief Calculator U/s 89(1) + Form 10E up to F.Y.2017-18 + House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B]

Deductor's Details Sheet

Salary Structure for Non-Govt Employees

Income Tax Computed Sheet

Automated Form 16 Part B

Main Sheet for Arrears Relief Calculator up to F.Y.2017-18

Arrears Relief Calculation Sheet 

Arrears Relief Form 10E

On May 07, 2017 by www.taxexcel.net

Share It

No Comments

Read More

1) Download Govt & Non-Govt Employees All in One TDS on Salary  (Both can use) for the Financial Year 2016-17 (Income Tax Computed Sheet + Arrears Relief Calculator U/s 89(1) + Form 10E + House Rent Exemption Calculation U/s 10(13A) + +  Automated Form 16 Part A&B and Form 16 Part B)

2) Download Non-Govt Employees All in One TDS on Salary For Financial Year 2016-17 (Income Tax Computed Sheet + Arrears Relief Calculator U/s 89(1) + Form 10E + House Rent Exemption Calculation U/s 10(13A) + Form 12 BA +Automated Form 16 Part A&B and Form 16 Part B)

3) Download Central Govt Employees All in One TDS on Salary for Financial Year 2016-17 ( Income Tax Computed Sheet + Salary Structure + House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B) 

4) Download All State Employees All in One TDS on Salary for Financial Year 2016-17 ( Income Tax Computed Sheet + Salary Structure +  House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B)

5) Download West Bengal Govt employees All in One for Financial Year 2016-17 ( Income Tax Computed Sheet + Salary Structure +  House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B) 

The New Finance Budget 2016-17 has already Passed and the Income Tax Slab for the financial year 2016-17 is same up to Rs. 2.5 Lakh is NIL and Section 80 C is also same up to Rs. 1.5 Lakh. More one Section have added in the section 80C AS U/S 80CCD(1B) Which deduction Max Rs. 50 thousand as additional of U/s 80C. And the Tax Rebate U/s 87A have raised up to Rs.5 thousand from the F.Y.2016-17

This Financial Year 2016-17 has continuing and middle in the Financial Year. The 2nd Quarter of 24Q is knocking to submit the Tax amount  deposit into the Central Govt through the 24Q or 26Q Tax Challan. So you can prepare your Tax Liability for this financial year 16-17 and deposit the amount of Tax in 2^nd Quarter.

If you have one unique Excel Based Software like as All in One TDS on Salary, which can prepare at a time your (Income Tax Computed Sheet + Arrears Relief Calculator U/s 89(1) + Form 10E + House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B) for the Central Govt Employees, All State Govt Employees, All Non-Govt Employees and Govt & Non Govt employees in different Excel based Software, so it will be easy to prepare and preserve the all of Calculation in future.

The Salary Structure of Central Govt is differ from another any State Employee's Salary Structure, also the differ the Salary Structure of any Non - Govt Employees Salary and Pay Structure. In this Regard, prepared the Salary Structure for each Concerned Employees in these Excel Utility.

On August 28, 2016 by www.taxexcel.net

Share It

No Comments

Read More

Download All in One TDS on Salary for Central Govt Employees for F.Y.2015-16 [Prepare at a time your Tax Compute Sheet + Individual Salary Sheet + Individual Salary Structure +Automatic HRA Exemption Calculation + Automated Form 16 Part A&B and Form 16 Part B for the Financial Year 2015-16 ]

As per the new Finance Budget 2015, has some changes in some Tax Section and hike the limit of some Section under chapter VIA, the main changes is given below :-

Section	Brief Information about the Chapter VIA Section as per Budget 15
80C	Amount paid or deposited towards life insurance, contribution to Provident Fund set up by the Government, recognized Provident Fund, contribution by the assessee to an approved superannuation fund, subscription to National Savings Certificates, tuition fees, payment/ repayment for purposes of purchase or construction of a residential house and many other investments. For full list, please refer to section 80C of the Income-tax Act. ( The aggregate amount of deduction under section 80C, 80CCC and 80CCD(1) shall not exceed Rs. 1,50,000/- ) Include One another Item as Sukanya Samriddhi Account Max Rs.1.5 Lakh
80CCC	Deduction in respect of Payment of premium for annuity plan of LIC or any other insurer. Deduction is available upto a maximum of Rs. 150,000/-. The premium must be deposited to keep in force a contract for an annuity plan of the LIC or any other insurer for receiving pension from the fund.
80CCD(1)	Deduction for contribution in pension scheme notified by the Government to the extent of 10% of salary in case of employees and 10% of total income in case of others.
80CCD(2)	Contribution by employer in pension scheme notified by the Government to the extent of 10% of salary.
80D	Deduction in respect of Medical Insurance Premium for Self and family members.( Maximum Deduction available Rs. 25,000/- for Senior Citizens and Rs. 25,000/- for others. )
	Deduction in respect of Medical Insurance Premium for Parents (Father or mother or both).( Maximum Deduction available Rs. 30,000/- for Senior Citizens parents and Rs. 30,000/- in other cases. )
80DDB	Deduction to the extent of Rs. 80,000/- or the amount actually paid, whichever is less for expenditure actually incurred on self or dependent relative for medical treatment of specified disease or ailment.
80U	Deduction in case of a person with disability. ( Maximum Deduction: General disability - Rs. 75,000/-, Severe disability - Rs. 1,25,000/-. )

Other tax deduction Under Chapter VI A is the same as previous Financial Year, there have no changes. Like U/s 80TTA, 87A

On October 31, 2015 by www.taxexcel.net

Share It

No Comments

Read More

HOUSE RENT ALLOWANCE Sec.10 (13A)

Download HRA Exemption Calculator U/s 10(13A)

Objective: To claim exemption for House Rent Allowance under Sec.10 (13A).

Definition as per Income Tax Act, 1961:

any special allowance specifically granted to an assessee by his employer to meet expenditure actually incurred on payment of rent (by whatever name called) in respect of residential accommodation occupied by the assessee, to such extent as may be prescribed having regard to the area or place in which such accommodation is situate and other relevant considerations.]

[Explanation.—for the removal of doubts, it is hereby declared that nothing contained in this clause shall apply in a case where—

(a) The residential accommodation occupied by the assessee is owned by him; or

(b) The assessee has not actually incurred expenditure on payment of rent (by whatever name called) in respect of the residential accommodation occupied by him]

Rule: Under Sec. 10(13A), an employee who is in receipt of House Rent Allowance (HRA) can claim exemption, if he does not live in his own house, and pays rent in excess of 10% of his salary for his residential accommodation.

The assesse is not entitled to receive HRA in the following cases:

a)     When the assesse stays in his own house, i.e. the property is in Assesse name.

b)     When the assesse does not pay any rent or incur any expenditure towards rent,

c)     When the assesse rent paid is less than 10% of salary.

1.The exemption shall be calculated on the basis of where the accommodation is situated.

2.If place of employment is the same for the whole year, then exemption shall be calculated for the whole year.

3.If there is a change in place during the previous year, then it shall be calculated on monthly basis.

4.Exemption should be calculated in respect of the period during which rental accommodation is occupied by the employee during the previous year.

Computation of taxable HRA:

Step 1: - Salary= Basic Salary + DA considered for Retirement Benefits + Commission forming part of Salary as a Fixed Percentage of Turnover of the Employee.

Step 2: - Taxable HRA:

Amount received during the financial year towards HRA

Less: Exemption u/s 10(13A) is the least of the following 

Actual amount of HRA received

50% (for Chennai, Mumbai, Kolkata and Delhi)/40% (for other places) of the Salary for the relevant period

Rent paid Less 10% of Salary for the relevant period. 

Click here to Download the HRA Calculator in Excel 

On January 11, 2015 by www.taxexcel.net

Share It

No Comments

Read More

As per the CBDT Notification that the Form 16 Part A is mandatory to download from the TRACES PORTAL ( www.tdscpc.gov.in) . Most of Deductor have not yet know know how to download the Form 16 Part A from the TRACES Portal. It is most easy to download the Part A of Form 16 and Form 16 A.

First Log In  the TRACES Portal as a Deductor. If you yet not Register your TAN by this TRACE Portal then you first Register your TAN in this Portal and after Register Log in  as a Deductor. After Log In you should download the Form 16 Part A. Below given the Picture of the TRACES Portal. But the Form 16 Part B is mandatory to prepare by the Deductor. Part A can you Download from the Portal but the Part B must be prepare by the deductor which Part B have in the all details of Salary of an employee. 

If you have need Excel Based Income Tax preparation Software for the Financial Year 2014-15, which can prepare at a time Tax Computed Sheet + Individual Salary Sheet + Automatic Form 16 Part B + Automatic Form 16 Part A&B + Automatic Arrears Relief Calculator + Form 10E + Automatic HRA Exemption Calculation in a single File. 

Click here to Download the utility

On December 20, 2014 by www.taxexcel.net

Share It

No Comments

Read More

      It's time for first working of any works at your office, but the Income Tax Calculation with all exemption like as House Rent Exemption Calculation or Arrears Relief Calculation with Form 10E OR prepare the Form 16, if you can do one by one, there can take much time to prepare and calculation the above all calculation.Also if your Concerned have more than 40 or 100 employees who's preparation of all of above calculation one by one it will be hazard and take huge time to prepare the same of all employees calculation. 

      But If you have one unique Excel Based Software like as All in One TDS on Salary, which can prepare at a time your (Income Tax Computed Sheet + Arrears Relief Calculator U/s 89(1) + Form 10E + House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B) for the Central Govt Employees, All State Govt Employees, All Non Govt Employees and Govt & Non Govt employees in different Excel based Software, so it will be easy to prepare and preserve the all of Calculation in future.

The Salary Structure of Central Govt is differ from another any State Employee's Salary Structure, also the differ the Salary Structure of any Non - Govt Employees Salary and Pay Structure. In this Regard, prepared the Salary Structure for each Concerned Employees in these Excel Utility.

Download the All in One TDS on Salary for the Financial Year 2014-15 of Each Concerned from the below link :-

1) Download Govt & Non Govt Employees All in One TDS on Salary  (Both can use) for the Financial Year 2014-15 (Income Tax Computed Sheet + Arrears Relief Calculator U/s 89(1) + Form 10E + House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B)

2) Download Non-Govt Employees All in One TDS on Salary For Financial Year 2014-15 (Income Tax Computed Sheet + Arrears Relief Calculator U/s 89(1) + Form 10E + House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B)

3) Download Central Govt Employees All in One TDS on Salary for Financial Year 2014-15 ( Income Tax Computed Sheet + Salary Structure + House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B)

4) Download All State Employees All in One TDS on Salary for Financial Year 2014-15 ( Income Tax Computed Sheet + Salary Structure +  House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B)

5) Download West Bengal Govt employees All in One for Financial Year 2013-14 ( Income Tax Computed Sheet + Salary Structure +  House Rent Exemption Calculation U/s 10(13A) + Automated Form 16 Part A&B and Part B)

On December 19, 2014 by www.taxexcel.net

Share It

No Comments

Read More