Rahul Wagh
Officer Trainee - Personnel
Hr Practices
Hr Executive
HR Recruiter
Hr Executive
+3 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Dear Professionals, Can any body send me about How to prepare Leave, Absenteesm, Manpower Statement . If you’ve any format please send me. Thanks & Regards, Sridharan.K
Hi Sridharan,
You may maintain the attendance in a simple Excel sheet only.. start with E-Code and Name of employee, then put the column for Designation and Date of Joining.. then onwards date and month.. below them mark Present, Absent or Leave or Holiday.. by this way only you may maintain it in a very simple way.. moreover at the end put the formula and calculate all the Absent and leaves taken in that month..
Hope it will help you to do the same..
Amit Seth.

Hi Sridharan,

Manpower Information system is the complete information regarding the available Manpower..

It helps the Management in decision making.. like what are the reasons of resignation.. in which area attrition is high.. and so many things to help in decision making.. with the help of MIS you may prepare a lot of reports.. Like annual attrition.. region wise attrition.. region wise manpower.. graphical representation of regions manpower status.. and so on..

You may prepare the same at your end.As it will help you to prepare other such formats too.

I am describing you the contents with sheet wise..

First Sheet-

Details of employee

a. E.Code b. Name of employee

c. Date of birth d. Designation e. CTC

f. Address for communication

g.Permanent address h. Contact number

i. Blood group j. Maximum qualification

k. Extra qualification l.Total Experience

Second Sheet-

Salary structure

In this sheet write down the complete salary structure.. and make a column what is salary after any revision

Third Sheet -

New Joinees

In this sheet write down the name of New joinees of that month with detail




DOB n etc.

Forth Sheet -

Resigned employees

In this sheet write the name of employees who resigned during

that particular month with details like name, designation, date of joining,

Date of resignation, last working day.

Fifth sheet -

Attrition rate

Based on this MIS report, you may find out the attrition report, Qualification analysis reports, team management reports and so on can prepare a number of reports..


Amit Seth.

Dear please see attached file Rahul

Attached Files
Membership is required for download. Create An Account First
File Type: xls mis_report_1__832.xls (35.0 KB, 1736 views)

Hi Rahul,
Thanks for sharing this MIS format actually i am also looking out for such kind of reports to maintain employee records.There are more columns which i need to add on it once i will make my MIS report i will share that with everyone.

Hi All,
I am a Tech Recruiter, have never been involved into Policy making, doing it for the first time. Can anyone please provide me some material on Absenteeism and Dress code.
You can also write me at

Hi Amit, Thanks for your immediate reply to me. Please send me how to prepare Leave and Absenteeism Statement. If you’ve any format please send it to me. Thanks & Regards, Sridharan.K
Hi Amit, I read the material shared by you. its really very helpful. However, there's one confusion I am having about the sheet with salary structure. how do we have salary structures of different employees on one single sheet? Please reply asap.Thanks
Hi all,
Please tell me how do i change my profile from placement/recruitment to core hr. I have more than 4 years of exp out of which 2 years in placment. Currently i am working as placement co ordination but i want to change as in this org it is not posssible to shift to core hr.

hi this is sharik
i need urgently a format for manpower information system and wat all thingd can be calculated and analysed from it except attrition joining separation retention
and wat are other attributes that can be analyzed..
plz help me out for project

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™