could you please help me how to make attendance sheet and maintain salary sheet with an example. please dont send me any templates . I want it with a valid example.
From India, Kolkata
From India, Kolkata
Hi Sathi,
I've not worked with salary but have worked with attendance sheet and here's what you can do.
Since I work with a smaller firm, we use Excel to keep the data. I have a sheet that gives current month's attendance details.I have employees name on different rows. Every month this data is copied and pasted to an annual attendance sheet.
On the 1st day of the month, I mark all Sundays (weekly offs) and listed holidays of company.
I have used different colors and alphabets for various situations -
A - absent
SL - Sick Leave
CL - Casual Leve
PL - Privilege Leave
LP - Leave w/o Pay
B - gone out for business purpose
L - Late Entry
H - Half day
With that I also keep a count on no. of late marks employee wise and generate a graph department wise which is circulated to all.
Hope it helped you. :-)
From India, Mumbai
737I've not worked with salary but have worked with attendance sheet and here's what you can do.
Since I work with a smaller firm, we use Excel to keep the data. I have a sheet that gives current month's attendance details.I have employees name on different rows. Every month this data is copied and pasted to an annual attendance sheet.
On the 1st day of the month, I mark all Sundays (weekly offs) and listed holidays of company.
I have used different colors and alphabets for various situations -
A - absent
SL - Sick Leave
CL - Casual Leve
PL - Privilege Leave
LP - Leave w/o Pay
B - gone out for business purpose
L - Late Entry
H - Half day
With that I also keep a count on no. of late marks employee wise and generate a graph department wise which is circulated to all.
Hope it helped you. :-)
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Attendance sheet.xls