Hi, I need a help in preparing Attendance and Payroll sheet
1. I want "Attendance file FY 19-20" and "Salary sheet FY 19-20" (both separate xls & subject line as specified in " ").
2. here I'm adding keys as i needed in attendance sheet.
PRESENT P
WEEK OFF WO
HALFDAY PRESENT HDP
LATE COMING LC
HOLIDAY H
HOLIDAY WORK HW
ABSENT A
COMPO OFF CO
APPROVED LEAVE AL ( update it as if 1 leave and 2 leaves in a month)
NEW JOIN NJ
ON JOB TRAINING OJT
TRANSFER TRN
LEFT/ABSCOND LEFT
RESIGN RSN
3. I will update in CTC components ( Basic, HRA, Conveyance, other allowances.) as per Company policy, P.Tax slots (Hyderabad, upto 15000=0, 15001 to 20000=150, 20001 above 200) check and update along with all statutory calculations and PF ceiling amt for 15000. So please send me the CTC structure and Payroll sheet month wise and year wise.
1. I want "Attendance file FY 19-20" and "Salary sheet FY 19-20" (both separate xls & subject line as specified in " ").
2. here I'm adding keys as i needed in attendance sheet.
PRESENT P
WEEK OFF WO
HALFDAY PRESENT HDP
LATE COMING LC
HOLIDAY H
HOLIDAY WORK HW
ABSENT A
COMPO OFF CO
APPROVED LEAVE AL ( update it as if 1 leave and 2 leaves in a month)
NEW JOIN NJ
ON JOB TRAINING OJT
TRANSFER TRN
LEFT/ABSCOND LEFT
RESIGN RSN
3. I will update in CTC components ( Basic, HRA, Conveyance, other allowances.) as per Company policy, P.Tax slots (Hyderabad, upto 15000=0, 15001 to 20000=150, 20001 above 200) check and update along with all statutory calculations and PF ceiling amt for 15000. So please send me the CTC structure and Payroll sheet month wise and year wise.