Simplify Employee Records: How This Excel Tracker Can Help Manage Leave and Salary

Hi all,

Please find the attached file that will help you in maintaining various records in one Excel file:
1. Yearly leave record
2. Monthly leave record
3. Salary calculations
4. Absenteeism recording
5. For each employee.

For reference, you can view the comments inserted (pink cells) or see the formulas applied, which are visible in the formula bar.
I hope it will help you in maintaining the records more easily and effectively.

Thanks & Regards,
Anshu Goyal

Dear Anush,

Good work. Keep it up. Do you organize like this, for example, in an Excel format which contains salary particulars, PF Form-3 & 6, and ESI Half Yearly Return particulars in one sheet?

Regards,
PBS KUMAR
pbskumar2000@yahoo.com

Hi PBS,

Currently, I don't have such a format, but surely I can arrange it for you very soon. I will email or update the format on citehr by this Friday.

Thanks & Regards,
Anshu Goyal

Hi friends,

Please send me small notes about the abbreviations. I am not able to understand the short forms.

Regards,
Raji