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.
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™