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.

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.
- Declared : Tax projection will be generated as per the Declare amount entered in the Perks, Recoveries and Investment Module under the different type of payments.
- Made : Tax projection will be generated as per the Made amount entered in the Perks, Recoveries and Investment Module under the different type of payments.
4.Reimbursement : Reimbursement Exemption will be shown as per below selection in Tax Projection.
- Exemption as per Salary Heads : Exemption will be considered in the Tax projection for those allowances whose exemption limit is entered in the Salary Heads.
- Exemption as per Reimbursement master : Exemption will be considered in the Tax projection for those allowances whose exemption limit is entered in the Salary Heads and it will check with the Daily Voucher Entry Made in the Reimbursement Master of HRMS. It will provide the Exemption as per the voucher entry. It is not made then it will not show the exemption in the 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.
- Last Salary Paid : It will project the amount for those salary components whose column type is At Pay Time in the Salary Heads.
- Salary Structure : It will not project the amount for those salary components whose column type is other than At Pay Time in the Salary Head.
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.

Working with this module :
- Go to Income Tax -> Tax Projector.
- User has to select the Grade / Branch / Department / Division / Unit / Category / Project / All for which he wants to do the Tax Projection.
- Then Select the Employee Name if user wants projection of individual employee or keep the Employee name column blank for Projection of all employees.
- Enter the year From and To, Select the Investment 'Made' or 'Declared' as per 'Perks, Recoveries and Investments' module. (If user selects Investment as 'Made' it will only display the 'Investment Made' entered in Perks and if user selects Investment as 'Declared' then he can display 'Investments Made and Declared' both entered in Perks).
- If user wants to show negative tax of the employee then he has to tick on 'Show Negative Tax' check box.
- Select the Reimbursement Exemption as per 'Salary Heads' or 'Reimbursement Master'.
- Select Project 'With Last Salary Paid' or 'With Salary Structure'. ('With Last Salary Paid' will project the Tax as per last Payslip generated and 'With Salary Structure' will project the Tax as per entries made in the Employee Salary Structure).
- Click on 'View Report' button.

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.
- The window expands displaying the name of the employee and summary of its Tax projection as mentioned in previous screen. (If the name column is blank then it displays the name of all employees). It is a single line Projection.
- In this screen there are two Utilities : 'Transfer TDS to Salary Settings' and 'Transfer TDS in last month'. The first option will divide the balance TDS amount with remaining months and will transfer it to salary settings. The second option will transfer the TDS amount to last month payslip and the Payslip Net salary will be adjusted accordingly.


- To view the details of Tax Projection select the name of employee and click on “Preview Tax Projection” from action the Employee for which user wants to view the projection. The window will further show the details of Tax projection of that particular employee or for all employees. The window shows the Actual and Projected details. i.e. the Process data and the remaining months data. It shows the total Salary, Allowances, Exemptions, Rebate given, the Tax to be deducted and if any TDS.

- In Header user will find Total salary, Taxable Income, Tax Payable Rate and Total TDS Deducted.
- In TDS table user find month wise data of TDS deducted.
- Below table display complete Projection detail.
Actions :
- Download All in One Zip :It will download tax projection file in pdf format for selected employees in single zip.
- Send Email : User can also Email Income Tax Detailed Projection through Send Email option in Action.

Various Colors are applied to verify various Status of Employee.
- WHITE : This Color indicate Ordinary Employee.
- YELLOW : This Color indicate Employee is Women.
- LIGHT GREEN : This Color indicate Sr. Citizen Employee.
- GREEN : This Color indicate Super Sr. Citizen Employee.
- PINK : This Color indicate Foreign Resident Employee.
Note :
Foreign Resident can be made if Employee Master “Nationality” Field having data other than Indian.
- PURPLE: This Color indicate NRI Employee.
Note :
- If Employee is in Tax Bracket of 2.5 to 3.5 Lakhs than rebate of 2500 will be provided in TDS.
- 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.
- For additional information to be added in software for deduction than it need to be done in “Employee Wise Flag” screen.
- 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 :
- Yearly
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 |
- Check Monthly -Calculate Monthly
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)
- Check Monthly -Calculate Yearly
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.