Tax Projector Detail

This module is used for projection of Income Tax. User can check with this module the Tax payable, the deductions or the rebates given to the employee in a particular Financial Year.

taxproj1

Filter Criteria :

1.Tax Projection : User can Run Projection in two ways, if user want to generate fresh Tax Projection with current setting than select “Regenerate Tax Projection with Latest Data” or if user want to generate last generated data with no effect of current setting than select option “Tax Projection as per Last Process”.

2.Period From and To : User can only select From Year system will auto pick To year Field value.

3.Investment : Tax projection will be generated as per the Declare or made amount entered in the Perks Entry on selection of below option.

4.Reimbursement : Reimbursement Exemption will be shown as per below selection in Tax Projection.

5.Master Selection : Then user can select the Grade / Branch / Department / Division / Project / Category for which he wants to Perform Tax Projection.

6.Employee : Tax projection will be generated for those employees who have been selected or for all if kept blank.

7.Project With : At Pay time Amount Valuation in Tax Projection.

8.Show Negative Tax : It will show the extra tax deducted under the heading Balance Tax to be deductible in the tax projection.

9.Report : View data in grid format for all employees as per last generated Tax projection. It displays "Emp Code,Emp Name,Year,PAN,Type Tax Rate,Total Earnings & Allowances,Total exemption,Gross Salary,Standard Deductions,PT Deducted,Loss from Housing Property,All Perquisites excluding HRA,HRA,Other Income Reported,All the secs,Taxable Total Income,Tax on Income,Surcharge,Education Cess,Total Tax on Income,Total TDS deducted, Balance Tax Deductible,Monthly Tax to be deducted" Fields in Tax Projection Report.

taxproj5

Working with this module :

taxproj2

Note :

If user wants Projection for only those employees who left in a particular Financial Year, then he has to tick on 'Show Only Employee-Left in F.Y.' from Configuration. In Tax Projection page master filter will not be display as it will showing all left employee for particular Financial Year.

taxproj3

taxproj4

  1. In Header user will find Total salary, Taxable Income, Tax Payable Rate and Total TDS Deducted.
  2. In TDS table user find month wise data of TDS deducted.
  3. Below table display complete Projection detail.

Actions :

taxproj7

Various Colors are applied to verify various Status of Employee.

Note :

Foreign Resident can be made if Employee Master “Nationality” Field having data other than Indian.

Note :

  1. If Employee is in Tax Bracket of 2.5 to 3.5 Lakhs than rebate of 2500 will be provided in TDS.
  2. If User want CED exemption than Education allowance Salary head to be added with attach as CED and No. of children need to be mention in Employee Master.
  3. For additional information to be added in software for deduction than it need to be done in “Employee Wise Flag” screen.
  4. NRI can be made from Employee Wise Flag.

Calculation of Following Field/Option are as:

1. Accommodation calculation to be done as per below case :

It indicate place give in which someone may live or stay, and its calculation mainly depend on type of city as rate got change accordingly as mentioned:

City Type as Metro : 15%

City Type as Semi Metro : 10%

City Type as Non Metro : 7.50%

These Percentage used to calculate Accommodation in Salary which can be calculated as below:

Accommodation Salary = (Total Basic + Total Allowance) - Total DA

In Below table calculation is done on the basis of two component i.e. Fair Rent paid and Accommodation Salary.

If we take an example of Metro city, System will Pick minimum of (15% of accommodation Salary) or (Fair Rent Paid).

Calculation as per Acc. salary

Calculation as per Fair Rent Paid

Month Provided in Perks

12

Month Provided in Perks

12

Cost Of Furniture

5000

Cost Of Furniture

5000

Rent P.A. (Rent Recovered)

2000

Rent P.A.

2000

HRA

7500

HRA

7500

Total Allowance

70,296.00

(-) DA

5000

(-) Total Exemption

7500

Accommodation Salary(12 month)

57796

15 % of Accommodation salary

8669.4

Fair Rent Paid

100000

(+) 10% Cost Of Furniture

500

10% Cost Of Furniture

500

(-) Rent Recovered

2000

Rent Recovered

2000

Accommodation Exemption (For 12 Month)

7169.4

Accommodation Exemption

98500

2. Hotel Accommodation can be calculated and System will Pick minimum of (24% of Accommodation Salary) or (Hotel Accommodation provided in Perk Entry).

As per above e.g. = 24% of Accommodation Salary to be calculated

I.e. 57796*24% = 13871

3. HRA Exemption :

The House Rent Allowance (HRA) is an essential component of an individual's salary that defines the total amount allotted by the employer towards the employee's accommodation as rent. The HRA amount can be beneficial for an employee as it is calculated for tax deductions for a particular financial year and its calculation depend on type of city as rate got change accordingly as mentioned:

City Type as Metro : 50%

City Type as Non Metro : 40%

User have to compare three steps and minimum of three will be HRA Exemption and above Percentage is used in Step 2 calculation.

For HRA Exemption their is three method for calculation :

Its calculation shown as below :

Non- Metro

Metro

Total Basic + Total DA (HRA Salary)

55000

55000

HRA

2500

2500

RENT

7500

7500

Step 1

RENT-(10% OF HRA SALARY)

RENT-(10% OF HRA SALARY)

2000

2000

Step 2

40% OF HRA SALARY

50% OF HRA SALARY

22000

27500

Step 3

HRA

HRA

2500

2500

HRA EXEMPTION

2000

2000

Its calculation shown as below :

April

May

June

July

Aug

Sept

Oct

Nov

Dec

Jan

Feb

March

Total Basic + Total DA

0

16000

16000

15243

16000

16000

16000

16000

16000

16000

16000

16000

HRA

0

7656

7656

7294

7656

7656

7656

7656

7656

7656

7656

7656

RENT

0

6000

6000

6000

6000

6000

6000

6000

6000

6000

6000

6000

HRA SALARY

0

16000

16000

15243

16000

16000

16000

16000

16000

16000

16000

16000

Step 1

RENT-(10% OF HRA SALARY)

0

4400

4400

4475.7

4400

4400

4400

4400

4400

4400

4400

4400

Step 2

METRO 50% / NON METRO 40%

50%

0

8000

8000

7621.5

8000

8000

8000

8000

8000

8000

8000

8000

Step 3

RENT PAID

0

6000

6000

6000

6000

6000

6000

6000

6000

6000

6000

6000

HRA EXEMPTION

0

4400

4400

4475.7

4400

4400

4400

4400

4400

4400

4400

4400


HRA Exemption = 48476 (sum of all month HRA Exemption, Ignore Negative value if any)

Its calculation shown as below :

April

May

June

July

Aug

Sept

Oct

Nov

Dec

Jan

Feb

Mar

Total Basic + Total DA

55000

55000

55000

55000

55000

55000

55000

55000

55000

55000

55000

55000

HRA

2500

2500

2500

2500

2500

2500

2500

2500

2500

2500

2500

2500

RENT

7500

6000

5000

8000

9000

8700

5786

8760

7890.9

7000

7800

8100

HRA SALARY

55000

55000

55000

55000

55000

55000

55000

55000

55000

55000

55000

55000

Step 1

RENT-(10% OF HRA SALARY)

2000

500

-500

2500

3500

3200

286

3260

2390.9

1500

2300

2600

Step 2

METRO 50% / NON METRO 40%

50%

27500

27500

27500

27500

27500

27500

27500

27500

27500

27500

27500

27500

Step 3

RENT PAID

7500

6000

5000

8000

9000

8700

5786

8760

7890.9

7000

7800

8100

HRA EXEMPTION

2000

500

-500

2500

3500

3200

286

3260

2390.9

1500

2300

2600


HRA Exemption = 23537 (sum of all month HRA Exemption)

4. Vehicle Provided (First)

Below Combination is used to calculate vehicle Perquisite.

Expense Done By

Provided for

With Driver

HP

Perk Value (Auto update)

Employer

Office use

Yes

Big/Small Car

10800

Employer

Private use

Yes

Big/Small Car

null

Employer

Both

Yes

Big Car

39600

Employer

Both

No

Big Car

28800

Employer

Both

Yes

Small Car

32400

Employer

Both

No

Small Car

21600

null

Employee

Office use

Yes

Big/Small Car

10800

Employee

Private use

Yes

Big/Small Car

null

Employee

Both

Yes

Big Car

21600

Employee

Both

No

Big Car

10800

Employee

Both

Yes

Small Car

18000

Employee

Both

No

Small Car

7200

5. Vehicle Provided (Second/Third)

For Second and Third car 10% of "value of vehicle" is picked in tax projection.