PAY ROLL REVISIONARY EXERCISE
COMPANY NAME : PAY ROLL ENTERPRISES
Create Employess Groups as Follows:
1) H.R. Department
2) Accounts Department
3) Sales Department
Create Pay Heads as Follows:
| Pay Heads |
Pay Head Type |
Calculation Type |
Duration |
Computed On |
| Basic Pay |
Earnings for Employees |
On Attendance |
Month |
- |
| D.A |
Earnings for Employees |
As Computed Value |
Month |
Basic Pay |
| H.R.A |
Earnings for Employees |
As Computed Value |
Month |
Basic Pay |
| Conveyance |
Earnings for Employees |
Flat Rate |
Month |
- |
| Canteen Charges |
Deduction from Employess |
Flat Rate |
Month |
- |
| Employees ESI Contribution |
Employees Statutory Deduction |
As Computed Value |
Month |
Basic Pay + D.A |
| Employers ESI Contribution |
Employers Statutory Contribution |
As Computed Value |
Month |
Basic Pay + D.A |
| Professional Tax |
Employers Statutory Contribution |
As Computed Value |
Month |
Basic Pay + D.A |
| TDS |
Deduction From Employees |
Flat Rate |
Month |
- |
| P.F |
Employees Statutory Deduction |
As Computed Value |
Month |
Basic Pay + D.A |
| Gratuity |
Gratuity |
- |
Month |
- |
EMPLOYEE DETAILS:
| Name |
Pandian |
Cathy |
Mahalakshmi |
| Under |
H.R.Department |
Accounts Department |
Accounts Department |
| Date of Joining |
1.5.2011 |
1.3.2012 |
2.6.2012 |
| Employee Number |
123 |
387 |
654 |
| Designation |
Assistant Manager |
Assistant Accountant |
Senior Auditor |
| Gender |
Male |
Female |
Female |
| Date of Birth |
1.04.1960 |
1.03.1997 |
2.06.1998 |
| Blood Group |
O+ve |
AB+ve |
A+ve |
| Father/Mother Name |
Hemanth/Latha |
Raja/Lakshmi |
Ram/Madhu |
| Phone No. |
7356498378 |
9786453456 |
8647563826 |
| Bank Name |
SBI |
IOB |
Canara Bank |
| Bank Account No. |
3456 |
5873 |
5643 |
| Branch |
Nungambakkam |
Mylapore |
Tambaram |
| P.F Account No. |
687 |
596 |
274 |
| ESI Number |
2573 |
4850 |
5739 |
Create Units As Given Below:
1. Symbol: Dys.
Formal Name: Days.
2. Symbol: Mth.
Formal Name: Month.
3. Symbol: Hrs. Formal Name: Hours
Create Attendance As Follows:
| Attendance |
Type |
Units |
| 1. Absent |
Leave Without Pay |
Days |
| 2. Present |
Leave With Pay |
Days |
| 3. Overtime |
Production |
Hours |
PREPARE PAYROLL VOUCHERS AS GIVEN BELOW:
| PAY HEADS |
PANDIAN |
CATHY |
MAHALAKSHMI |
| Basic Pay |
30,000 |
30,000 |
40,000 |
| D.A |
32,000 |
35,000 |
45,000 |
| H.R.A |
12,000 |
15,000 |
14,000 |
| Conveyance |
750 |
650 |
350 |
| Canteen Charges |
160 |
120 |
150 |
| Employees ESI Contribution |
900 |
850 |
800 |
| Employers ESI Contribution |
1,200 |
850 |
800 |
| Professional Tax |
1,520 |
1,500 |
1,200 |
| TDS |
2,500 |
2,500 |
2,400 |
| P.F |
1,400 |
1,200 |
1,300 |
| Gratuity |
1000 |
1,600 |
1,700 |
| Overtime |
20 hrs |
18 hrs |
10 hrs |
| Absent |
2 days |
4 days |
2 days |
