New to Recruitment? Need Help Creating Daily, Weekly, and Monthly Reports in Excel?

I have recently joined a recruitment firm and have no idea about the business and the industry. My manager has asked me to make a daily, weekly, and monthly recruitment report on an Excel sheet to check my ability. I have no idea what it looks like. Could someone please share an example with me? It would be great if I could go through some of these reports. Thank you. Please revert.

Hi,

I think you should try to consider a format based on your job responsibilities. If you work in an Excel sheet, then try to create a list of assigned tasks on a daily basis and record completed work. For example, in an Excel sheet, you can maintain a record with the following columns or customize it according to your job role and duties:

Date -- No. of Interviews -- Shortlisted Candidates -- Assigned Tasks -- Completed Tasks -- Remarks

Hope this suggestion helps. Just put in the effort, and I am confident you will succeed.

Best regards,
Partha.

Date-Candidate Name- Resource (Portal/Headhunt/Network)-Skill Set-Client-Shortlisted-Status (rejected/selected)-Resume received. This format is for weekly basis.

For the monthly report, combine 5 weeks' data into one sheet including candidate details such as skill, client, and offer status.

Customer / Project / Skill Set / Position / Requirement / Offered / Joined Pending Vacancies / Interviewed / Rejected / On Hold / FBA / Selected

---

This input seems to be a list of categories related to customer projects, skills, positions, requirements, and various stages of the recruitment process. I have corrected the formatting and spelling errors to ensure clarity and readability.

Hi Roma,

Here, one can also include the following metrics of target like 30/60/90 days for the junior, middle, and senior positions, respectively, for your clients. Also, include the value addition factor as well on your personal contribution as to how you are making a difference to the organization! This could be done by way of making a comparison of your contribution of networking or headhunting compared to the resumes from the portals, advertisements, etc., where the company spends capital.

As far as your knowledge of the industry is concerned, don't worry, just use your common sense! :)

Best wishes,
Rajat Joshi