1. Ajay started business with cash rs.650000 and by SBI bank Rs.
500000
2. He paid salary to all his department using payroll (DATE OF JOINING 1/05/2024)
ACCOUNTS SALES RESEARCH AND HR DEPRTMENT
DEPARTMENT DEPARTMENT DEVELOPMENT
BINOY SAM SHYAM SUNDAR
KAVIN CATHERINE SANDRA GOPAL
ANJALI APARNA JOSY PRASAD
PRADEEP DILEEP ANJU MANOJ
3. PAYHEADS
NAME PAYHEAD TYPE CALCULATION TYPE
BASIC SALARY EARNINGS FOR EMPLOYEES ON ATTENDENCE
PROVIDENT EMPLOYEES STATUTORY ON SPECIFIED
FUND DEDUCTIONS FORMULA
EFFECTIVE AMOUNT GREATER THAN AMOUNT UP TO SLAB TYPE VALUE
FROM 15000 PERCENTAGE 9%
1/05/24 15000 20000 PERCENTAGE 12%
20000 35000 PERCENTAGE 14%
35000 PERCENTAGE 15%
TRAVELLING EARNINGS FOR EMPLOYEES ON FLAT RATE
ALLOWANCE
ESI EMPLOYEES STATUTORY ON SPECIFIED
DEDUCTIONS FORMULA
EFFECTIVE AMOUNT GREATER THAN AMOUNT UP TO SLAB TYPE VALUE
FROM 20000 PERCENTAGE 1.45%
1/05/24 20000 35000 PERCENTAGE 2.45%
35000 VALUE 560
4. SALARY DETAILS OF EMPLOYEES GROUP
EFFECTIVE PAYHEAD ACCOUNTS SALES RESEARCH AND HR DEPRTMENT
FROM DEPARTMENT DEPARTMENT DEVELOPMENT
1/05/24 BASIC 40000 25000 38000 45000
SALARY
PF 15% 14% - -
ESI - - 560 560
TRAVELLING 2000 - 2400 2500
ALLOWANCE
5. ATTENDENCE (F10- ATTENDENCE VOUCHER ) (F2-1/5/24)
EMPLOYEE PRESENT DAYS
BINOY 28 DAYS
KAVIN 25 DAYS
ANJALI 31 DAYS
PRADEEP 29 DAYS
SAM 30 DAYS
CATHERINE 26 DAYS
APARNA 28 DAYS
DILEEP 27 DAYS
SHYAM 23 DAYS
SANDRA 26 DAYS
JOSY 27 DAYS
ANJU 30 DAYS
SUNDAR 31 DAYS
GOPAL 28 DAYS
PRASAD 28 DAYS
MANOJ 25 DAYS
6. AUTOFILL SALARY FOR THE MONTH OF MAY
