Breaking News
Loading...
Share It

Enter your email address:

Powered by Feedio

Showing posts with label Automated Form 16 Part B for F.Y.2014-15. Show all posts
Showing posts with label Automated Form 16 Part B for F.Y.2014-15. Show all posts

Thursday 23 April 2015

Download Master of Form 16 Part B for FY 2014-15 [ This Excel Utility can prepare at a time 50 employees Form 16 Part B]

Finance Act 2014 has made following changes relating to determination of Income Tax payable by Salaried Employees, which provide income tax exemption varied from Rs.15,000 to Rs. 30,000 on the basis of taxable income of individual.
1. Taxable Income eligible for full exemption from income tax increased from Rs. 2 lakh to Rs. 2.5 lakh
2. Additional deduction of Rs. 50,000 under Section 80 C, CCC, CCD(1):
Deduction allowed under Section 80C, 80CCC, and Section 80 CCD(1) for savings/investments, premium for annuity / pension fund and employee contribution to NPS respectively has been increased to Rs. 1.5 lakh from Rs. 1 lakh (Section 80CCE Limit)
3. Income Tax exemption on Interest paid on housing loan under Section 24 of the Income Tax Act increased from Rs. 1.5 lakh to Rs. 2 lakh
In addition to above three new changes, Income Tax Rebate of Rs. 2000 for taxable income up to Rs. 5 lakh continues this year also under Section 87A of Income Tax Act

Click here to  Income Tax Calculator 2014-15 

Click here to Tax Form 16 Part A&B for F.Y. 2014-15 [Prepare at a time 100 employees Form 16 Part A&B]

A brief on all eligible income tax exemptions applicable for the year 2014-15 is as follows
Income Tax Structure 2014-15

Allowances exempted under Section 10 of Income Tax Act

House Rent Allowance:

When rent is actually paid by an individual, he / she is entitled to exemption in respect of House Rent Allowance which is limited to least of the following
1. Actual HRA received.
2. Rent paid less 10% of salary.
3. 40% of Salary (50% in case of Mumbai, Chennai, Kolkata, Delhi) Salary is defined as Basic Pay. Dearness allowance will form part of salary if the same enters into computation of retirement benefits

Click here to Income Tax Exemption on HRA Calculator U/s 10(13A)

Leave Travel Allowance or Leave Travel Concession :

LTC or LTA is exempted if the same is actually spent

Transport Allowance:

Transport Allowance granted to an employee to meet expenditure for the purpose of commuting between the place of residence and place of duty. Income Tax Exemption on Transport Allowance is restricted to Rs.800 per month.

Children Education allowance:

Rs. 100/- per month per child up to a maximum of 2 children.

Hostel Subsidy:

Rs. 300/- per month per child upto a maximum of two children.

Other Allowances exempted under Section 10 of IT Act.

Tour TA, Tour Daily Allowance, Academic, research or training allowance, uniform Allowance, Special Compensatory Allowance, High Altitude Allowance, Climate Allowance, allowances applicable to North East, Hilly areas of U.P., H.P. and J & K, border area allowance, Compensatory Field Area Allowance, Counter Insurgency Allowance, High Active Field Area Allowance, island duty allowance, tribal allowance etc.

Income Tax Exemption on Interest paid on Housing Loan / Income or loss from House Property:

Total deduction for interest paid on Housing Loan when the property is self occupied has been increased to Rs. 2 lakh as per amendment made in Section 24 of the Income Tax Act in 2014. Also, in addition to Deduction of of Interest payable on Housing Loan up to Rs. 2 Lakh from the total income (and without any limit for Housing property rented out for an annual value), the new section in the form of Section 80 EE introduced in the last Budget (2013) provides for additional deduction / Income Tax Exemption for Interest paid on housing loan up to Rs. 1 lakh in respect of housing loan sanctioned / disbursed during the year 2013-14 for a first time house buyer with total property cost and amount of loan are not exceeding Rs. 40 lakh and Rs. 25 lakh respectively. This additional deduction of Rs. 1 lakh can either be availed fully in the income tax assessment year 2014-15 (Financial Year 2013-14) or partly in 2014-15 and remaining balance in Assessment year 2015-16 ( Financial Year 2014-15) in case interest payable in A.Year 2014-15 was not exceeding Rs. 1 lakh.

Section 80C:

The total deduction under this section (along with section 80CCC and 80CCD) is limited to Rs. 1.50 lakh. Some investments, savings, expenditure etc covered under Section 80 C are as follows
  • Life Insurance Premium
  • Premium / Subscription for deferred annuity For individual, on life of self, spouse or any child .
  • Sum deducted from salary payable to Govt. Servant for securing deferred annuity for self-spouse or child Payment limited to 20% of salary.
  • Contribution made under Employee’s Provident Fund Scheme.
  • Contribution to PPF For individual, can be in the name of self/spouse, any child & for HUF, it can be in the name of any member of the family.
  • Contribution by employee to a Recognised Provident Fund.
  • Sum deposited in 10 year/15 year account of Post Office Saving Bank
  • Subscription to any notified securities/notified deposits scheme. e.g. NSS
  • Subscription to any notified savings certificate, Unit Linked Savings certificates. e.g. NSC VIII issue.
  • Contribution to Unit Linked Insurance Plan of a Mutual Fund
  • Contribution to fund set up by the National Housing Scheme.
  • Housing Loan Principal amount paid
  • Tuition fees paid at the time of admission or otherwise to any school, college, university or other educational institution situated within India for the purpose of full time education of any two children. Available in respect of any two children

Section 80CCC:

Premium Paid for Annuity Plan of an Insurance Company
Payment of premium for annuity plan of LIC or any other insurer Deduction is available up to a maximum of Rs. 100,000/-. (This limit has been increased from Rs. 10,000/- to Rs. 1,00,000/- w.e.f. 01.04.2007).
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.
Note: The limit for maximum deduction available under Sections 80C, 80CCC and 80CCD(1) (combined together) is Rs. 1,50,000/- (Rs. one lakh and fifty thousand only).

Section 80CCD (1): Deduction in respect of Contribution to Pension Account (by Assessee}

Deduction available for the amount paid or deposited in a pension scheme notified or as may be notified by the Central Government subject to a maximum of :
(a) 10% of salary in the previous year in the case of an employee (b) 10% of gross total income in any other case.

Section 80CCD (2): Deduction in respect of Contribution to Pension Account (by Employer)

Deduction available for the amount paid or deposited by the employer of the assessee in a pension scheme notified or as may be notified by the Central Government subject to a maximum of 10% of salary in the financial year. This exemption is in addition to Rs. 1.5 lakh limit provided under Section 80 CCE for deductions under Section 80 C, CCC, and 80CCD(1)

Deductions under Chapter VIA of Income Tax Act

Section 80CCG: Rajiv Gandhi Equity Saving Scheme (RGESS)

As per the Budget 2012 announcements, a new scheme Rajiv Gandhi Equity Saving Scheme (RGESS) will be launched. Those investors whose annual income is less than Rs. 10 lakh (proposed Rs. 12 lakh from A.Y. 2014-15) can invest in this scheme up to Rs. 50,000 and get a deduction of 50% of the investment. So if you invest Rs. 50,000 (maximum amount eligible for income tax rebate is Rs. 50,000), you can claim a tax deduction of Rs. 25,000 (50% of Rs. 50,000).

Section 80D: Deduction in respect of Medical Insurance

Deduction is available up to Rs. 20,000/- for senior citizens and up to Rs. 15,000/ in other cases for insurance of self, spouse and dependent children. Additionally, a deduction for insurance of parents (father or mother or both) is available to the extent of Rs. 20,000/- if parents are senior Citizen and Rs. 15,000/- in other cases. Therefore, the maximum deduction available under this section is to the extent of Rs. 40,000/-. From AY 2013-14, within the existing limit a deduction of up to Rs. 5,000 for preventive health check-up is available.

Section 80DD: Deduction in respect of Rehabilitation of Handicapped Dependent Relative

Deduction of Rs. 50,000/- w.e.f. 01.04.2004 in respect of
  1. Expenditure incurred on medical treatment, (including nursing), training and rehabilitation of handicapped dependent relative.
  2. Payment or deposit to specified scheme for maintenance of dependent handicapped relative.
Further, if the defendant is a person with severe disability a deduction of Rs. 100,000/- shall be available under this section. The handicapped dependent should be a dependent relative suffering from a permanent disability (including blindness) or mentally retarded, as certified by a specified physician or psychiatrist. Note: A person with ‘severe disability’ means a person with 80% or more of one or more disabilities as outlined in section 56(4) of the ‘Persons with disabilities (Equal opportunities, protection of rights and full participation)’ Act.

Section 80DDB: Deduction in respect of Medical Expenditure on Self or Dependent Relative

A deduction to the extent of Rs. 40,000/- or the amount actually paid, whichever is less is available for expenditure actually incurred by resident assessee on himself or dependent relative for medical treatment of specified disease or ailment. The diseases have been specified in Rule 11DD. A certificate in form 10 I is to be furnished by the assessee from any Registered Doctor.

Section 80E: Deduction in respect of Interest on Loan for Higher Studies

Deduction in respect of interest on loan taken for pursuing higher education. The deduction is also available for the purpose of higher education of a relative w.e.f. A.Y. 2008-09.

Section 80G: Deduction in respect of Various Donations

The various donations specified in Sec. 80G are eligible for deduction upto either 100% or 50% with or without restriction as provided in Sec. 80G

Section 80GG: Deduction in respect of House Rent Paid

Deduction available is the least of
  1. Rent paid less 10% of total income
  2. Rs. 2000/- per month i.e. Maximum Deduction available is 24,000/-
  3. 25% of total income, provided
    • Assessee or his spouse or minor child should not own residential accommodation at the place of employment.
    • He should not be in receipt of house rent allowance.
    • He should not have self occupied residential premises in any other place.

Section 80 TTA: Deduction from gross total income in respect of any Income by way of Interest on Savings account

Deduction from gross total income of an individual or HUF, upto a maximum of Rs. 10,000/-, in respect of interest on deposits in savings account ( not time deposits ) with a bank, co-operative society or post office, is allowable w.e.f. 01.04.2012 (Assessment Year 2013-14).

Section 80U: Deduction in respect of Person suffering from Physical Disability

Deduction of Rs. 50,000/- to an individual who suffers from a physical disability(including blindness) or mental retardation. Further, if the individual is a person with severe disability, deduction of Rs. 100,000/- shall be available u/s 80U. Certificate should be obtained from a Govt. Doctor. The relevant rule is Rule 11D.
RELIEF UNDER SECTION 89(1)

Click here to Arrears Relief Calculator U/s 89(1) 2014-15

Relief u/s 89(1) is available to an employee when he receives salary in advance or in arrear or when in one financial year, he receives salary of more than 12 months, or receives ‘profit in lieu of salary’ covered u/s 17(3). Relief u/s 89(1) is also admissible on family pension, as the same has been allowed by Finance Act, 2002 (with retrospective effect from 1/4/96).

Click here to Private Employees  Income Tax Calculator 2014-15 

Monday 30 March 2015

Download Automated Master of Form 16 Part B for FY 2014-15 [ This Excel Utility can prepare at a time 100 employees Form 16 Part B]. No need to prepare manual Form 16 Part B, if you use this handy Excel Utility which is most ease to generate and easy to install in any computer]

Main Feature of this Utility :-

  • Prevent double entry of Pan Number and Name of Employee
  • Automatic Calculate Tax of each employee after filling the Salary Structure
  • This Excel Utility can use both of Govt and Non-Govt Concerned
  • This Utility can reduce your time to prepare Form 16 Part B
  • All of Tax Feature as per the Budget 2014
  • Automatic Convert the Amount in to the In Words.
You have a question that what is the Form 16 Part B and how to prepare this Form 16 Part B and which Item have in this Form 16 Part B. Given below the all answer with CBDT Notification Number.
Income-tax department has issued Circular No 04/2013 dated April 17, 2013 in respect of Form 16.
New Form 16
Revised Form 16 has been notified vide Notification 11/2013 dated 19.02.2013
Form 16 has two distinct parts :-
Part A : contains details of tax deduction and deposit
Part B : contains details of salary and total income
Form 16 has to be issued on or before May 31, 2014 in respect of Financial Year 2014-15
Procedure for Issuance
Now vide Circular 04/2013, a deductor is required to issue
1) Part A of Form 16 by downloading the same from TRACES web site
2) Part B of Form 16 is to be prepare &  issue by deductor manually
Form 16 Part A generated from TRACES PORTAL will contain unique TDS Certificate Number
Form 16 Part A by Govt. deductors, who make TDS payment by book entry , is also to be issued by generating and downloading from TRACES
Authentication of Form 16
   Form 16 must be signed manually or using digital signature
Analysis
Issuing Form 16 will be a challenge for deductors for FY 2014-15, as this involves two distinct parts being issued from two different sources.

Part A will have to be generated and downloaded from TRACES & Part B will have to be prepared manually or using a third party software.

Download Automated Form 16 Part B for FY 2014-15 ( This Excel Utility can prepare One by One Form 16 Part B)

Friday 27 March 2015

Download and prepare at a time 100 employees Form 16 Part B for Financial Year 2014-15 and Assessment Year 2015-16. This Excel Utility Prepare with the all latest amended format of Form 16 which was published by the CBDT in the Financial Year 2013-14. You can easily prepare at a time 100 employees Form 16 Part B. and you can prepare more than 1000 employees Form 16 Part B by this One Excel Utility. 
                                              Main Data Input Sheet

                                                Tax deduction Sheet
                                        Form 16 Part B Amended Format

As per the Finance Budget 2014 the Tax Slab has already hike up to Rs. 2.5 Lakh and the Section 80C also raised 1.5 Lakh. In this Finance Budget Re-lunched the K.V.P in U/s 80C and the House Building Loan Interest U/s 24B also raised up to Rs. 2 Lakh.

The Most popular Section 87A ( Tax Rebate Rs.2,000/-) is also entitled in this Financial Year 2014-15 as per the Circular by the CBDT. The Section 80TTA ( Relief from Tax from the Savings Bank Interest ) also available in this Financial Year. This Master of Form 16 Part B have the all latest Tax Section and New Slab for the Salaried Person.

Feature of this Utility:-
1) This Utility easy to install and easy to generate, just like a Excel File.
2) Prevent the double entry of Name of Employee and Prevent the double entry of PAN Number
3) All the Income Tax Section have in this Utility
4) Automatic Convert the Amount in to the In-Words without any Excel Formula
5) You can prepare more than 1000 employees Form 16 Part B by this One Utility

Download the Master of Form 16 Part B for the Financial Year 2014-15[ Prepare at a time 100 employees Form 16 Part B for FY 2014-15]

Saturday 14 March 2015

Various Web Site published the various Tax Calculator for Salaried Person, but none of them prepare only for Private Employees Tax Preparation Excel Based Software for the Financial Year 2014-15.
Given below the Excel Based unique Software which can prepare only for Private/Non-Govt employees for the Financial Year 2014-15.

Main Feature of this Excel Utility:-
1) This Utility only for Private Employee
2) The Salary Structure for calculate the Gross Salary is prepare as per Private Concerned Salary Structure.
3) Automatic Calculate the House Rent Exemption U/s 10(13A)
4) Automatic Prepare the Form 16 Part A&B 
5) Automatic Prepare the Form 16 Part B
6) Automatic Prepare the Form 12 BA
7) Automatic Convert the Amount in to the In Words

Download the All in One TDS on Salary for Private employee for FY 2014-15 [Prepare at a time Tax Compute Sheet + HRA Calculation + Form 16 Part A&B + Form 16 Part B + Form 12 BA]

Snapshot of Tax Deduction Sheet
Snapshot of Tax Compute Sheet
Snapshot of Form 16
Snapshot of Form 12 BA

Download the All in One TDS on Salary for Private employee for FY 2014-15 [Prepare at a time Tax Compute Sheet + HRA Calculation + Form 16 Part A&B + Form 16 Part B + Form 12 BA]

Wednesday 4 March 2015

Download and prepare at a time 100 employees Form 16 Part B for Financial Year 2014-15 and Assessment Year 2015-16. This Excel Utility Prepare with the all latest amended format of Form 16 which was published by the CBDT in the Financial Year 2013-14. You can easily prepare at a time 100 employees Form 16 Part B. and you can prepare more than 1000 employees Form 16 Part B by this One Excel Utility. 
                                              Main Data Input Sheet

                                                Tax deduction Sheet
                                        Form 16 Part B Amended Format

As per the Finance Budget 2014 the Tax Slab has already hike up to Rs. 2.5 Lakh and the Section 80C also raised 1.5 Lakh. In this Finance Budget Re-lunched the K.V.P in U/s 80C and the House Building Loan Interest U/s 24B also raised up to Rs. 2 Lakh.

The Most popular Section 87A ( Tax Rebate Rs.2,000/-) is also entitled in this Financial Year 2014-15 as per the Circular by the CBDT. The Section 80TTA ( Relief from Tax from the Savings Bank Interest ) also available in this Financial Year. This Master of Form 16 Part B have the all latest Tax Section and New Slab for the Salaried Person.

Feature of this Utility:-
1) This Utility easy to install and easy to generate, just like a Excel File.
2) Prevent the double entry of Name of Employee and Prevent the double entry of PAN Number
3) All the Income Tax Section have in this Utility
4) Automatic Convert the Amount in to the In-Words without any Excel Formula
5) You can prepare more than 1000 employees Form 16 Part B by this One Utility

Download the Master of Form 16 Part B for the Financial Year 2014-15[ Prepare at a time 100 employees Form 16 Part B for FY 2014-15]

Monday 16 February 2015

Calculation of TDS from Salary
Under the scheme of tax deduction at source (TDS), persons responsible for making payment of income & covered by the scheme, are responsible to deduct tax at source & deposit the same to government treasury within the stipulated time.
The recipient of income – though gets only net amount, is liable to tax on the gross amount and the amount deducted at source is adjusted against his final tax liability.
DEDUCTION OF TAX FROM SALARIES
Any person responsible for paying any income chargeable under the head “salaries” is required to deduct at source on the amount payable. Tax is to be calculated at the rates prescribed for the financial year FY 2014-15 in which payment to employees is made.

POINTS TO CONSIDERED FOR COMPUTE THE SALARY & TAX THEREON
1.House rent allowance exemption- exemption pertaining to house rent allowance should be calculated by the employer on the basis of specified limit provided by the section10(13A) of income tax act.Click to Download HRA Calculator U/s 10(13A)

2.Deduction from gross total income- Employer should taken into consideration amount deductible under sections 80C, 80CCD, 80CCG, 80D, 80DDB, 80E, 80EE, 80GG, 80GA, 80TTA, and 80U. The employer should not give any deduction in respect of donation (deduction under section Sec 80G) given by the employee.

3. TAX LIABILITY- Tax is deductible on the taxable income at the rate applicable for the financial year 2014-15, which is reproduced below for your reference:-

3.1 For a resident senior citizen (who is 60 years or more at any time during the previous year but less than 80 years on the last day of previous year i.e., born during April 1,1935 and march 31,1955):-
Net income range
Income-tax rates
Surcharge
Education cess
Secondary & 
higher education
Up to Rs 2,50,000
Nil
Nil
Nil
Nil
Rs.2,50,000-Rs.5,00,000
10% of (total income minus Rs.3,00,000)
Nil
2% of income-tax
1% of income-tax
Rs.5,00,000-Rs.10,00,000
Rs.20,000+20% of(total income minus Rs.5,00,000)
Nil
2% of income tax
1% of income- tax
Rs.10,00,000-Rs 1,00,00,000
Rs1,20,000+30% of (total income minus Rs.10,00,000)
Nil
2% of income- tax
1% of income- tax
Above Rs 1,00,00,000
Rs.28,20,000+30% of (total income minus Rs.1,00,00,000
10% of income tax
2% of income- tax &surcharge
1%of income –tax & surcharge-
3.2 .For a resident super senior citizen (who is 80 years or more at any time during the previous year, i.e., born before April 1, 1935)-
Net income range
Income-tax rates
surcharge
Education cess
Secondary &higher   education cess
Up to Rs 5,00,000
Nil
Nil
Nil
Nil
Rs.5,00,000 – Rs. 10,00,000
20% of (total income minus Rs.5,00,000)
Nil
2% of income -tax
1% of income-tax
Rs 10,00,000 – Rs 1,00,00,000
Rs.1,00,000+ 30% of (total income minus Rs.10,00,000)
Nil
2% of income -tax
1% of income-tax
Above Rs1,00,00,000
Rs.28,00,000+30% of (total income minusRs.1,00,00,000)
10% of income-tax
2% of income –tax & surcharge
1% of income-tax & surcharge
3.3 Any other case of individual, every HUF / AOP / BOI / AJP :-
Net income range
Income-tax rates
Surcharge
Education cess
Secondary & higher education
Up to Rs 2,50,000
Nil
Nil
Nil
Nil
Rs.2,50,000-Rs.5,00,000
10% of (total income minus Rs.2,50,000)
Nil
2% of income-tax
1% of income-tax
Rs.5,00,00-Rs.10,00,000
Rs.25,000+20% of(total income minus Rs.5,00,000)
Nil
2% of income tax
1% of income- tax
Rs.10,00,000-Rs 1,00,00,000
Rs1,25,000+30% of (total income minus Rs.10,00,000)
Nil
2% of income- tax
1% of income- tax
Above Rs 1,00,00,000
Rs.28,25,000+30% of (total income minus Rs.1,00,00,000)
10% of income tax
2% of income- tax & surcharge
1%of income –tax & surcharge

Download Automated Form 16 Part A&B for FY 2014-15 [ This Excel Based Software can prepare at a time 100 employees Form 16 Part A&B]

TDS RATES IN CASE PAN NO IS NOT FURNISHED
If the recipient does not furnish his PAN to the deductor, tax will be deducted by virtue of section 206AA at the normal rate or the rate of 20% whichever is higher.

4. WHEN A PERSON IS EMPLOYED BY TWO OR MORE EMPLOYERS DURING THE FINANCIAL YEAR – In such a case tax will be deducted by each employer separately. However, the employee is under obligation to declare salary receive & tax deducted thereon from other employers to one of the employers by submitting information in Form no. 12B.

5. TDS CERTIFICATE – TDS certificate will be given to the employee in form no. 16 annually on or before if few condition are satisfied. Form no. 16 can be given in digital signature. The employer should also give a statement of perquisites / profit in lieu salary.

6. SALARY WITHOUT TDS OR WITH LOWER TDS – To get salary without TDS or with lower TDS, the employee will have to approach the assessing officer by submitting an application in Form no.13 under the section 197.

Download Automatic Form 16 Part B for the Financial Year 2014-15 [ This Excel Based Software can prepare at a time 50 employees Form 16 Part B]

7. Other points:-
7.1 TAX ON PREQUISITE PAID BY EMPLOYER – Section 192(IA) provides that the employer responsible for paying an income in nature of perquisite referred to in section 17 (2) may pay at his option, tax on the whole without making any deduction therefrom. In case employer opts to make payment of tax on perquisites, such tax payments will added back to income of employee. However, such tax payments shall not be allowed as tax deduction in the hands of employer.Click to download the Master of Form 16 Part B with Form 12 BA for FY 2014-15

7.2 MORE THAN ONE EMPLOYER – When an employee has more than one employer, he is required to furnish in form no.12B to one of the employer the detail of salary due /receive by him other employer.
Only after submission of information in FORM no 12B, it becomes obligation of the employer (to whom Form No 12B is submitted) to deduct tax at the source after considering the information submitted by the employee.
7.3 Relief under section 89: Section 192(2A) provides that in respect of salary payment of employees deduction of tax at source is to be made after allowing relief under section 89. To avail this benefit the concerned employees should furnish information in Form no. 10E to the employer.Click to Download Arrears Relief Calculator U/s 89(1) with Form 10E ( Up dated)

7.4 Supporting documents: No need to collect supporting evidence for giving exemption in respect of LTC/ Conveyance allowance. For other deduction and allowances employees must have proper supporting documents and must satisfy himself for correctness of claim by employee.

7.5 Tax deduction in respect of other incomes of employee: Following points are notable before including other income of employees for tax deduction:-
The employee may (or may not) declare his other income to employer.
If the employee wants to declare his other incomes to the employer, then such information should
be given plain paper to the employer.

·The employer may declare details of his other incomes (including loss under the head” Income from house property” but not any other loss) & tax deducted thereon by others.

If the aforesaid information is not submitted by the employee to the employer, then employer cannot take into consideration other incomes of the employee.

Download Automated Master of Form 16 Part B with 24Q & 26Q for FY 2014-15 [ This Excel Utility can prepare at a time 50 employees Form 16 Part B with 24Q & 26Q ]