Hi Jaya,
MIS report is known as Management Information System regarding the Manpower status of a particular month, place, and overall. It helps the Management in decision-making, like what are the reasons for resignation, in which area attrition is high, and many other factors to aid in decision-making. With the help of MIS, you can prepare various reports such as annual attrition, region-wise attrition, region-wise manpower, graphical representation of region's manpower status, and more.
You can prepare the same at your end. It will help you in preparing other formats as well.
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 include a column for the salary after any revision.
Third Sheet -
New Joinees
In this sheet, write down the names of New joiners of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet -
Resigned employees
In this sheet, write the names 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 can find out the attrition rate, Qualification analysis reports, team management reports, and prepare various other reports.
Regards,
Amit Seth.
From India, Ahmadabad
MIS report is known as Management Information System regarding the Manpower status of a particular month, place, and overall. It helps the Management in decision-making, like what are the reasons for resignation, in which area attrition is high, and many other factors to aid in decision-making. With the help of MIS, you can prepare various reports such as annual attrition, region-wise attrition, region-wise manpower, graphical representation of region's manpower status, and more.
You can prepare the same at your end. It will help you in preparing other formats as well.
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 include a column for the salary after any revision.
Third Sheet -
New Joinees
In this sheet, write down the names of New joiners of that month with details like CTC, Designation, DOB, etc.
Fourth Sheet -
Resigned employees
In this sheet, write the names 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 can find out the attrition rate, Qualification analysis reports, team management reports, and prepare various other reports.
Regards,
Amit Seth.
From India, Ahmadabad
Hi Friends You need enable the Macros in your system, then only the buttons will work. Regards Rajasekar
From India, Madras
From India, Madras
Dear sir, Informative & comprehensive excel sheet. Is it use for SAP-HR? still it has got some technical problem are you facing the same. Awaiting of your earliest reply Pundalikhr
From India, Pune
From India, Pune
Dear Friends,
I want to know about the new TDS rates of salaries and other than salaries, as well as sales tax rates, rules, VAT rates, rules, and procedures for bill passing, CST rates and rules, and service tax for various services and rates for the same. This is for your kind information.
Regards,
S. Chandramouli 🤔
From India, Madras
I want to know about the new TDS rates of salaries and other than salaries, as well as sales tax rates, rules, VAT rates, rules, and procedures for bill passing, CST rates and rules, and service tax for various services and rates for the same. This is for your kind information.
Regards,
S. Chandramouli 🤔
From India, Madras
Can anybody email me the complete MIS-Report format (Excel) with running functions to my email id: rana.vedpal@rediffmail.com? It's very urgent for me.
1. MIS TELECOM
2. MIS HR
3. MIS SALES
4. MIS PURCHASE
5. OTHER TYPE
PLEASE PROVIDE ME VERY FAST.
From India, New Delhi
1. MIS TELECOM
2. MIS HR
3. MIS SALES
4. MIS PURCHASE
5. OTHER TYPE
PLEASE PROVIDE ME VERY FAST.
From India, New Delhi
Sir,
Your MIS report is excellent, but I am not able to use the Excel because it is not working. Please tell me how to use Excel macros as they are not running. Hoping for the best.
Thank you,
Sarfaraz
From India, Ahmadabad
Your MIS report is excellent, but I am not able to use the Excel because it is not working. Please tell me how to use Excel macros as they are not running. Hoping for the best.
Thank you,
Sarfaraz
From India, Ahmadabad
Hi friends,
You need to enable the macros in Excel; then only the buttons will work. To enable the macros, follow these steps for Windows 2007:
- Go to "Excel Options" (this will be in the same tab where the print option is).
- Then "Trust Center".
- Then "Trust Center Settings".
- In that, go to "Macros Setting".
- In "Macros Setting", you need to enable the option called "Enable All Macros".
I hope this will help you.
Regards,
Rajasekar
From India, Madras
You need to enable the macros in Excel; then only the buttons will work. To enable the macros, follow these steps for Windows 2007:
- Go to "Excel Options" (this will be in the same tab where the print option is).
- Then "Trust Center".
- Then "Trust Center Settings".
- In that, go to "Macros Setting".
- In "Macros Setting", you need to enable the option called "Enable All Macros".
I hope this will help you.
Regards,
Rajasekar
From India, Madras
Dear Rajasekar, Can u please email me the the password for the sheet to unprotect shared work book. Regards, aShvini
From India, Mumbai
From India, Mumbai
Hi Srinivasan You need to enable the Macros in your system. Already i have posted in this thread how to enable the macros. You just go through my previous posts. You are welcome sureshkumar.
From India, Madras
From India, Madras
Hi Seniors,
Please help me with the query below:
Any group of persons who are undergoing training for 2 years (as per the appointment order) and have already completed 1 year, can they register with a trade union?
From India, Visakhapatnam
Please help me with the query below:
Any group of persons who are undergoing training for 2 years (as per the appointment order) and have already completed 1 year, can they register with a trade union?
From India, Visakhapatnam
Dear Rajasekar ji,
I found your MIS report very informative. Being a fresher in the HR field, it was like an eye-opener to me. Based on the report, I started collecting more information and found it worth it. Could you please update me with the various activities and the reports to be prepared by HR? Revert to me as soon as possible.
With lots of cheers,
Adhi
From India, Madras
I found your MIS report very informative. Being a fresher in the HR field, it was like an eye-opener to me. Based on the report, I started collecting more information and found it worth it. Could you please update me with the various activities and the reports to be prepared by HR? Revert to me as soon as possible.
With lots of cheers,
Adhi
From India, Madras
Hi Rajasekar Thank you so much for the attched document. It is of great help to us. Regards & Bunches of smiles Chandni Pandey Human Resources Walchand Talent First Ltd Mumbai
From India, Mumbai
From India, Mumbai
Dear Mr. Rajasekar,
Your MIS attachment is great, but unfortunately, I am unable to access it. Could you please assist me? I am not proficient in Excel; could you provide guidance on the functions you used to create this MIS report? Your help would be greatly appreciated.
Regards,
Priya
From India, Pune
Your MIS attachment is great, but unfortunately, I am unable to access it. Could you please assist me? I am not proficient in Excel; could you provide guidance on the functions you used to create this MIS report? Your help would be greatly appreciated.
Regards,
Priya
From India, Pune
Hi friends,
You need to enable the macros in Excel; then only the buttons will work. To enable the macros, follow these steps for Windows 2007:
- Go to "Excel Options" (this will be in the same tab where the print option is).
- Then "Trust Center."
- Then "Trust Center Settings."
- In that, go to "Macros Setting."
- In "Macros Setting," you need to enable the option called "Enable All Macros."
I hope this will help you.
From India, Madras
You need to enable the macros in Excel; then only the buttons will work. To enable the macros, follow these steps for Windows 2007:
- Go to "Excel Options" (this will be in the same tab where the print option is).
- Then "Trust Center."
- Then "Trust Center Settings."
- In that, go to "Macros Setting."
- In "Macros Setting," you need to enable the option called "Enable All Macros."
I hope this will help you.
From India, Madras
Thanks for the format. Is there a possibility that you can share the break up salary in the xl format? I am looking for the %s alongwhich we need to allot the amounts. Please help
From India, Calcutta
From India, Calcutta
rajasekar16 I m not able to work on the file. Macros disabled error is displayed. What shall I do rgds
From India, Mumbai
From India, Mumbai
Hi, I am new to this site and would like to request your help. I am looking for guidelines on how to format a joining kit for new employees. If you could provide me with some valuable suggestions, I would greatly appreciate it.
Additionally, I would like to understand if there are specific formats for offer letters or appointment letters for employees who are joining on a contract basis.
Regards, Sunandita Mukherjee
From India, Calcutta
Additionally, I would like to understand if there are specific formats for offer letters or appointment letters for employees who are joining on a contract basis.
Regards, Sunandita Mukherjee
From India, Calcutta
Hi Rajasekhar,
Very good format. I really appreciate the effort. However, I would like to incorporate some additional features and edit wherever I can to add some of my own observations that would be required in the MIS. I would need the password to unprotect the sheet for the same. Please let me know.
Thanks in advance, Anamika C.
From India, Pune
Very good format. I really appreciate the effort. However, I would like to incorporate some additional features and edit wherever I can to add some of my own observations that would be required in the MIS. I would need the password to unprotect the sheet for the same. Please let me know.
Thanks in advance, Anamika C.
From India, Pune
Hi Rajasekar, Good one, but not able view as access to each functions is disabled. Regards, Sreekumar.N
From India, Madras
From India, Madras
Request for MIS report format.
Hi, I am new to this site and would request your help. I am looking for the format of an MIS Report (preferably in Excel format). Please, if you can help me with some valuable suggestions, it would be appreciated.
Thanks in advance,
Ajay
From India, Bangalore
Hi, I am new to this site and would request your help. I am looking for the format of an MIS Report (preferably in Excel format). Please, if you can help me with some valuable suggestions, it would be appreciated.
Thanks in advance,
Ajay
From India, Bangalore
Subject: Request for MIS Report Formats in Excel
Hello,
I am in need of the complete MIS Report format (Excel) with running functions. Could someone please email it to me at alaudeen786@gmail.com? Your prompt assistance is greatly appreciated as this is urgent for me.
The specific MIS reports I require are as follows:
1. MIS TELECOM
2. MIS HR
3. MIS SALES
4. MIS PURCHASE
5. MIS ACCOUNTS
Please provide the information as soon as possible.
Thank you.
From India, Madras
Hello,
I am in need of the complete MIS Report format (Excel) with running functions. Could someone please email it to me at alaudeen786@gmail.com? Your prompt assistance is greatly appreciated as this is urgent for me.
The specific MIS reports I require are as follows:
1. MIS TELECOM
2. MIS HR
3. MIS SALES
4. MIS PURCHASE
5. MIS ACCOUNTS
Please provide the information as soon as possible.
Thank you.
From India, Madras
hi amit, quite informative. thanks... can u help me in preparing the flow chart ??? for different departments viz.. customer care, finance, production, hr, logistics etc.
From India, Bangalore
From India, Bangalore
hey hi jaya, r u working on MIS reports ?? u have any formats for any sales related data pls share ?? Regards, Chandraknat 09158138999
From India, Bhubaneswar
From India, Bhubaneswar
Hi team,
There are lots of formats for MIS reports, which depend upon the type of information, the people with whom it will be shared, and the frequency, etc. These formats vary for projects, departments, internal/external circulation, etc.
VLOOKUP:
=VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)
Explanation:
=VLOOKUP(the value or array you want to look up, the array where you want to find the corresponding value, column number (starting from the source column), optional)
Hope this helps.
Regards,
Bharat
From India, Pune
There are lots of formats for MIS reports, which depend upon the type of information, the people with whom it will be shared, and the frequency, etc. These formats vary for projects, departments, internal/external circulation, etc.
VLOOKUP:
=VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)
Explanation:
=VLOOKUP(the value or array you want to look up, the array where you want to find the corresponding value, column number (starting from the source column), optional)
Hope this helps.
Regards,
Bharat
From India, Pune
Hi friends,
Now I'm working at a denim factory in the Production MIS department. I am also working in the Process Control department, but I want to work in another knit dyeing unit of ours. Please, can anybody help me by providing suggestions about the knit dyeing procedure, recipes, process control, or monitoring data sheets?
Thank you,
Faruque
From Bangladesh, Dhaka
Now I'm working at a denim factory in the Production MIS department. I am also working in the Process Control department, but I want to work in another knit dyeing unit of ours. Please, can anybody help me by providing suggestions about the knit dyeing procedure, recipes, process control, or monitoring data sheets?
Thank you,
Faruque
From Bangladesh, Dhaka
Hello everyone,
I'm a new member of your team. Can anybody please help me out by attaching MIS reports for both HR and Finance to my email address - palit.sandip81@gmail.com?
Please, it's very urgent.
From India, Calcutta
I'm a new member of your team. Can anybody please help me out by attaching MIS reports for both HR and Finance to my email address - palit.sandip81@gmail.com?
Please, it's very urgent.
From India, Calcutta
Dear Amit,
The report you have attached is really good and easily understandable. However, there are a few issues that need your attention:
1. Three macros are not working in the Statutory Sheet (which you have attached).
2. The Accident Sheet is blank with no information provided.
Could you please clarify the issues mentioned above?
Also, could you explain the significance of the attrition rate?
Regards,
R.S. Sugasini
From India, Hyderabad
The report you have attached is really good and easily understandable. However, there are a few issues that need your attention:
1. Three macros are not working in the Statutory Sheet (which you have attached).
2. The Accident Sheet is blank with no information provided.
Could you please clarify the issues mentioned above?
Also, could you explain the significance of the attrition rate?
Regards,
R.S. Sugasini
From India, Hyderabad
not related to this not related to this not related to this not related to this
From United States, Cincinnati
From United States, Cincinnati
may this help you may this help you may this help you may this help you
From United States, Cincinnati
From United States, Cincinnati
Hi Everyone...!!
I am new to this forum and came to know about this from one of my friend. Few months back I was working with one of the biggest MNC at Delhi NCR location but due to some personal reasons, I left the company after spending more 5.5 yrs. From the last 5 months I am trying to get a a suitable jobs but all vent in vain and now I think I'll not able to celebrate this Diwali with great enthusiasm..Let see which way wind blows............
A brief introduction about me....I am B.com(H) graduate aged 35 yrs and having an experience close to 08 yrs. My last drawn CTC was INR 5,10,000/-. and key skills are as under :-
•Liaison with third party vendors
•Customer Relationship Management (CRM)
•Virtual Transitioning of work from Onshore US/UK locations
•Compliance – In terms of Data Security
•Quality Checks of Processing – Internal Audit
•Commitment to Quality – Adopted Lean best practice, Continuous process Improvements
•Systems knowledge – MS Office, Citrix, Lotus Notes, COGNOZ, IBM Mainframe, Siebel, Maestro
Can anyone please help in getting a suitable job in Delhi NCR ?
Recently I had been interviewed by some companies at Delhi NCR but not succeeded..Now, I had given interview in one of the Outsourcing companies based at Delhi NCR for Mid-level profile. Now, they are asking to submit ORIGINAL educational documents for at least 3-6 months and also need to sign a bond.
I know that this kind of practice is very much prevalent in UAE but not sure about in country like India..As far as my knowledge is concerned, companies Act of India does not allow such kind of unethical practice...Can any one throw some light on this ?
Thanks
GSA
From India, Mumbai
I am new to this forum and came to know about this from one of my friend. Few months back I was working with one of the biggest MNC at Delhi NCR location but due to some personal reasons, I left the company after spending more 5.5 yrs. From the last 5 months I am trying to get a a suitable jobs but all vent in vain and now I think I'll not able to celebrate this Diwali with great enthusiasm..Let see which way wind blows............
A brief introduction about me....I am B.com(H) graduate aged 35 yrs and having an experience close to 08 yrs. My last drawn CTC was INR 5,10,000/-. and key skills are as under :-
•Liaison with third party vendors
•Customer Relationship Management (CRM)
•Virtual Transitioning of work from Onshore US/UK locations
•Compliance – In terms of Data Security
•Quality Checks of Processing – Internal Audit
•Commitment to Quality – Adopted Lean best practice, Continuous process Improvements
•Systems knowledge – MS Office, Citrix, Lotus Notes, COGNOZ, IBM Mainframe, Siebel, Maestro
Can anyone please help in getting a suitable job in Delhi NCR ?
Recently I had been interviewed by some companies at Delhi NCR but not succeeded..Now, I had given interview in one of the Outsourcing companies based at Delhi NCR for Mid-level profile. Now, they are asking to submit ORIGINAL educational documents for at least 3-6 months and also need to sign a bond.
I know that this kind of practice is very much prevalent in UAE but not sure about in country like India..As far as my knowledge is concerned, companies Act of India does not allow such kind of unethical practice...Can any one throw some light on this ?
Thanks
GSA
From India, Mumbai
Can anybody e-mail me the complete MIS-Report formate (Excel) with running function to my email id - pgsaimanohar@gmail.com. MIS PURCHASE MIS SALES MIS ACCOUNTS Thank You in advance
From India, Bengaluru
From India, Bengaluru
Please give me the certain requirement and I will prepare the Mis report for you please send you are requirement to mail
From India, Bengaluru
From India, Bengaluru
Hi Friends,
This is Murali. I have 5 years of experience in accounts. I don't have knowledge in the HR department. Please help me with HR payroll calculations, PF, ESI, and other deductions. What are the PF deduction rules? What are the ESI deduction rules, etc.?
Email: mkrishna99@yahoo.com
From India, Banjara Hills
This is Murali. I have 5 years of experience in accounts. I don't have knowledge in the HR department. Please help me with HR payroll calculations, PF, ESI, and other deductions. What are the PF deduction rules? What are the ESI deduction rules, etc.?
Email: mkrishna99@yahoo.com
From India, Banjara Hills
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.