Daily Reports For Recruiters In A Consultancy !! - XLS Download

Hi friends,

Can anyone provide me with a form or format for the daily report of the work done by recruiters in a consultancy? A similar kind of report made by marketing people is called DSR (Daily Sales Report).

In fact, I also want to know if anyone has a rule for giving reports in consultancies, or anybody who takes these reports. Anything that helps to check the daily work.

Thanks,
Dips

Deepali,

I can't pass judgment on all recruiting consultancies in India. I think there are 2 American subsidiaries who use such reports:

1. Daily Submissions Report, which goes to the recruitment manager.
2. Quarterly KRA Report, which is sent by the recruitment manager to the Head Office.

I will provide you with the contents, and you can tailor them to your needs.

Daily Submission Report:
Column 1 (Vertical)
Name of the Party Visited
===========================
Now, all horizontal headings:

1. Current Customer
2. New Prospects
3. Requirement, if any (e.g., programmer, with qualifications defined)
4. Priority (high/medium/low)
5. Target (e.g., how many, e.g., two)
6. Duration (time taken—say 4 hours)
7. Submissions (yes or no)
8. Comments
====================================
The Recruitment Manager can consolidate these reports into one weekly format.

Daily Submission Report:
Column 1 (Vertical)
Recruiter Name
===========================
Now, all horizontal headings:
1. Name of the Party (current or new prospect)
2. Requirement, if any (e.g., programmer, with qualifications defined)
3. Priority (high/medium/low)
4. Target (e.g., how many, e.g., two)
5. Duration (time taken—say 4 hours)
6. Submissions (yes or no)
7. Comments
====================================
I have left out the quarterly reporting at this stage.

Regards,
Leo Lingham

Dear Mr. Leo,

Sir, I can't believe the first reply from you. But as usual, you have the keys to my questions. I searched a lot to contact you, even on LinkedIn and AllExperts, but everywhere they asked for your email id, which I don't have. Anyways, this was my first post after a long gap here, and to my pleasant surprise, I got a reply from you. See, it's true where there is a will, there's a way.

So thank you so much for this, sir.

Lots of regards,
Deepali

Dear Mr. Leo,

I have sent an email to your email address. I am preparing a business proposal which I will be sending to corporates regarding the sale of corporate gifts. If you could kindly provide some samples or a format, it would be greatly appreciated.

Regards,
Deepali

Dear Mr. Leo,

Have you sent the format? Sir, are you also providing consultancy for sales and marketing as well.

Regards,
Deepali

Dear Mr. Leo & Neetu,

I have not received any mail from your side. Still waiting for it. Please do the needful.

Deepali

Deepali,

Excel formats/Proposal Material already sent to your email ID.

Regards,

Leo Lingham

Dear Mr. Leo,

Thank you for your attachments, and a special thank you to Navin for adding to it. I will update my current format and post it here. I kindly request Mr. Leo to have a look at it and suggest any changes.

I would appreciate if senior consultants here could give their opinions and insights on this matter.

Thanks & Regards,
Deepali

Hi Deepali,

I have been reading your posts regularly. Thanks for sharing your knowledge. I am also from Noida. Can I know where your office is located and what verticals you deal with?

Regards,
Saks

Hi Saks,

Well, I'll definitely let you know, but why haven't you written anything about yourself in your public profile? What do you do?

Thanks,
Deepali

Deepali, I'm new here. I will definitely write my details. At present, I'm working with a construction company. I have worked with a consultancy before.

Regards,
Saks

Hi Sakshi,

I am in Noida, running a consultancy, and we cater to all sectors except Insurance, IT, and BPO. Since when have you been working here?

Deepali,

I just joined this office after a break of 7 months. I was working in Delhi with a consultancy firm, then moved back to my hometown (CHD) for 8 months and worked with a leading consultancy there. Now, I am settled in Noida.

Regards,
Saks

Hi Friends,

I have developed this format for daily reports for my recruiters and to acknowledge here, it's with the inputs given by Mr. Leo and Navin. I hope HR consultants find this relevant.

Thanks,
Deepali

Hello, guys.

If you want to share information like files, resumes, etc., don't email personally. Please post here. CiteHR has an option for uploading files in threads. If you do this, people like me will benefit.

Thank you.

Hi Deepali,

I checked your format, and it looks good. However, I feel there is a need for a summarized weekly and monthly report. As we know, recruitment is a numbers game, so more emphasis needs to be put on the number of resumes hunted and processed. The summary can be added in footnotes.

How about having your report created in such a way that each Excel sheet should have tabs day-wise? For example, 1st Aug, 2nd Aug, 3rd Aug... 7th Aug... Weekly Summary... Monthly Summary, and so on.

What do you say, members?

Hi Deepali,

I am sending you the format of DSR to your email right now, so please check your mail.

Thank you & Regards,
Indu Prasad
RC
IMS Empresaria Pvt Ltd

Hi Navin,

Navin says,

[HTML][/HTML] Checked your format looks good; however, I feel there is a need for a summarized weekly and monthly report. As we know, recruitment is a numbers game, hence more emphasis needs to be put on the number of resumes hunted and processed. The summary can be added in footnotes. How about having your report created in such a way that each Excel sheet should have tabs day-wise, e.g., 1st Aug, 2nd Aug, 3 Aug... 7th Aug... Weekly Summary... monthly summary, and so on. [HTML][/HTML]

Thanks for your suggestion, but if you check this is only a daily report. And I am working on Weekly and a monthly format also.

It's true that recruitment is a game, and you can see in my format that candidates' names and numbers are given for each position. In my opinion, it helps in many ways:

1. For follow-up in recruiters' absence
2. For future reference
3. Single-window contact for all resumes sent
4. The total number of resumes sent with their contact numbers available for urgent communication
5. Seniors can easily check the status in the absence or presence of the concerned recruiter.

But definitely, I am going to add the number of resumes sent, the number of shortlisted, and the number of rejected resumes in the weekly report.

You see, it gives you the complete status of each resume for each position daily, the total number of resumes sent/shortlisted/rejected for each position weekly, and the status of each position monthly.

Hope I am understood.

What say???

Thanks, Deepali

Dear all,

Please find the recruitment tracker attached.

Hi Deepali,

Hope this will help you. If detailed information is required, please reply to me.

Ajay Padnekar

09322932211

Hi, Rena, Ashish, and CareerHorizon,

As requested, I have sent the format I received from Mr. Leo to all of your emails. Please check.

Thanks,
Deepali

Hi Deepali,

I have 3.5 years of experience in HR generalist profile. I am looking for a job in Delhi NCR. It would be appreciated if you could provide me with your email id.

Kind Regards,
Rekha

Good luck with this.

---
Good luck with this.

Hi everyone, I am working as a Marketing Manager with a recruitment company. I need guidance in developing daily worksheets in Excel and how to combine worksheets to make charts in a recruitment company.

Thanks for your valuable time.

Dear All,

I am working in a consultancy and need a format for the daily report for my recruiter.

Regards,
Amit