Pharma Tips

How to Prepare Daily Call Report (DCR) for Medical Representative

By: Pharma Tips | Views: 15534 | Date: 06-Jun-2014

Daily Report format in Excel(.xlsx) FREE download Pharma DCRWe have come up with a DCR format for Micro and Small Pharmaceutical companies and startups who still think Excel based Daily reporting is better than Professional SFA or a Pharma CRM. Though we would never recommend a XLS based Daily reporting format for MR reporting activities; but we do understand that it’s not going to change overnight.



How to Prepare Daily Call Report (DCR) for Medical Representative

Daily Report format in Excel(.xlsx) FREE download Pharma DCR

Pharma-DCR-format-excel

We have come up with a DCR format for Micro and Small Pharmaceutical companies and startups who still think Excel based Daily reporting is better than Professional SFA or a Pharma CRM. Though we would never recommend a XLS based Daily reporting format for MR reporting activities; but we do understand that it’s not going to change overnight.

Hence our in-house Pharma SFE Experts have tried to automate this Excel DCR format with macros for better data integrity & ease of use. We have done our best to make your life easy by giving you option of adding your own master data.

But before you download the DCR format; we would highly recommend that you spend 5 minutes of your time to read: How Excel based DCR Reporting can hamper your Pharma SFE goals this quarter?

What’s included in the Daily reporting format?

What Masters can be added?

  1. Employee master
  2. Doctor master
  3. Hospital master
  4. Chemist master
  5. Blood bank master

What does the DCR report cover?

  • Details of doctor met
  • Gifts dispensed
  • Samples dispensed
  • Personal Order Book(P.O.B.)
  • Expenses made

Daily Call Reporting in Excel sheet


Excel is a powerful & ubiquitous analytical tool for small business analysis, but it lacks strong audit and error-checking capabilities. Pharma marketing companies especially in South East Asian countries, use Excel to store(create Master Data) and act(send daily reports) on customer information. It’s affordable and user-friendly. But just as businesses can outgrow office or retail space, they can outgrow excel based customer information management tools too. Excel was not made to act as an Daily Reporting System, It prevents good analysis and reporting.

Traditional Daily Call Reporting workflow in India:

DCR Formats in excel sheets, are sent to all Medical Reps and instructed to fill out every day and sent via email to an “Admin” at the Head Office or Administrative office. The Admin’s work is to collate all these excel sheets and make reports out of them manually and present to the National Sales Manager / Management on a weekly or monthly basis. The report has to correctly highlight Doctor Coverage, Order Bookings at Stockist & Chemist locations and expenses made for claims at the end of the month among other important SFE metrics.

Traditional Daily Reporting Workflow

Here are some of the comments from Industry Leading experts about this workflow

The current system of field force reporting is archaic and provide only lagging indicators. Lagging indicators do not enable BU Heads to take proactive steps to enable field force to correct course or change tactics. With the current technology capability, it is possible to get leading indicators, which enable BU Heads to get a better picture of sales activities and guide the field force to implement strategic goals on time. – By Anup Soans, Editor @ MedicinMan

What are the drawbacks of this workflow?

  1. A company with just 50 reps can generate thousands of excel files over a month. This wealth of information can be hardly utilized by managers when it is needed most.
  2. Rogue excel spreadsheets with data from dubious sources is propagated throughout the organization.
  3. Executives find themselves making decisions based on untraceable, questionable data.
  4. Actionable data is trapped inside silo corporate systems, Excel spreadsheets, and various standalone reports are scattered across file servers within organizations.
  5. In today’s world where real-time communication is the key, excel sheets hardly help you succeed and collaborate.
  6. Important tasks and followups often gets mixed up or lost
  7. Keeping track of Historical data becomes difficult day by day with excel. This hampers re-targeting and MCL creation.
  8. Managers don’t have real-time data in hand which affects decision making at high level.
  9. One of the key drivers for Sales force effectiveness is Consistency, Excel based reporting can hardly be considered consistent.

Excel has no built-in mechanism for separating the calculation, presentation, analysis,
and storage layers found on a professional daily reporting application. As information is trapped in small Excel Silos – during internal or external Audits, Pharma companies struggle to produce transaction history or any other key piece of information to the regulatory agencies.

The Pharmaceutical Sales Model itself has changed

  • There is an ever increasing number of stakeholders influencing the prescribing choice which necessitates a review of the “age old” sales force strategy. The term “customer” now refers to a variety of stakeholders other than direct prescribers.
  • Agile Pharmaceutical companies are replacing their large sales teams with KAM(key account managers) and specialist advisers(Medical Science Liason) capable of managing the complex network.
  • Since different physicians/practices have different needs for information, pharma companies need to develop sales force strategies which align sales resources to reflect these real world variations.
  • Through careful territory planning, physicians are able to receive sufficient attention and can establish relationships with specific representatives, which increases their satisfaction.
  • The product-service offerings the industry develops for specialist medicines must be both clinically and economically compelling, to ensure that it can reach the physicians who typically prescribe such treatments.
  • Pharma companies, who develop new capabilities and adapt their marketing and sales approaches to target the customer network as a whole, will create an advantage compared with competitors who continue to drive the ‘share of voice’ model with physicians.

To cope with today’s over saturated sales environment, pharmaceutical companies must maintain a single, centralized view — spanning data feeds, segments, and territories — of each physician, and then apply this information to design more relevant communications.

Cloud Computing-based SFA Tools specially designed for Pharmaceutical industry offers customized dashboards for tracking metrics and generating real-time reports on the go. Division Heads and Management are in better control of their territory and goals. Companies who only want to focus on sales force automation, can for for a professional SFA tool and reap their investment in less than 1 year.

What are the Next Steps?

  1. Take time to review your current state
  2. Analyze requirements, goals and objectives
  3. Select a Professional Pharma SFA or CRM for Pharma before the start of next Financial Year
  4. Create ROI and/or business case
  5. Secure budget and implement sooner rather than worry later!
Previous Page Next Page

People Searching On This Page:
  • Format for medical representative
  • reports of medical representive
  • example of m.r. daily doctor call report in php
  • daily sales report format for medical representative
  • Doctors call report
  • pharmacutical companies in expenses format
  • daily report format medical representative
  • Medical representative dcr format
  • medical representative expenses format
  • medical representative daily call report format
  • how to write a report(med rep)

Related Pages


MEDICAL REPRESENTATIVE / M.R. Reputed Pharma clients of NEXTUS SOLUTIONS

MEDICAL REPRESENTATIVE / M.R. Reputed Pharma clients of NEXTUS SOLUTIONS

Jobs | Medical Representative | Ahmedabad
Date:
01-May-2011  Views: 5144

-Implement Company strategy to generate prescriptions-Maintain and develop relations with existing and new customers through appropriate propositions ...
Medical Representative - Ahmedabad, Baroda, Surat Client of A1 Consultants

Medical Representative - Ahmedabad, Baroda, Surat Client of A1 Consultants

Jobs | Medical Representative | Ahmedabad
Date:
01-May-2011  Views: 2525

We are leading placement consultant. We are specialized in pharmaceuticals placement and have been retained by pharmaceutical companies. We require MR ...
Medical Representative - MR - BE –Sundyota Numandis Pharmaceuticals Pvt. Ltd

Medical Representative - MR - BE –Sundyota Numandis Pharmaceuticals Pvt. Ltd

Jobs | Medical Representative | Ahmedabad
Date:
01-May-2011  Views: 4657

Will implement mktg strategies&campaigns for product promotion to doctors,effective in-clinic presentation to doctors,identifying&promoting right prod ...
Medical Representative - Cardio / diabetic DIv 1 Client Of Sublog

Medical Representative - Cardio / diabetic DIv 1 Client Of Sublog

Jobs | Medical Representative | Mumbai
Date:
01-May-2011  Views: 2317

Promoting Company products to Doctors. Responsible for achieving monthly sales.Meeting with the doctor and communicate targeted products.providing the ...
Medical representative - Respiratory Division Client of Sublog

Medical representative - Respiratory Division Client of Sublog

Jobs | Medical Representative | Mumbai
Date:
01-May-2011  Views: 3482

Promoting Company products to Doctors. Responsible for achieving monthly sales.Meeting with the doctor and communicate targeted products.providing the ...
Post Your Comments (No Login Require)
Name : (required)
Email : (required)
Website :

Comment : (required)

99  + 7 =     
Comments
amit  |  12-Sep-2014 16:34:53 IST
Please send me xls sheet let me see first
jayesh  |  15-Sep-2014 17:35:13 IST
kidly send me the execel sheet
Viksit  |  08-Oct-2015 21:56:43 IST
Please mail DCR file
PRAVEEN YADAV  |  18-May-2016 14:01:37 IST
pls mail me DCR in excell format
Sentire Pharma  |  27-Jun-2016 13:13:08 IST
Please send me excel copy
Amit  |  04-Nov-2016 01:14:22 IST
Could you please send me a DCR Xls sheet as mentioned in your ads for me to see and whether same is applicable to me.
Ramender Guleria  |  30-Dec-2016 21:51:29 IST
09310406677, call me for reporting format and software along with MR location tracking
MOUNEIM  |  24-Jul-2017 22:58:26 IST
Please send me the excel sheet
People Searched About:
Format For Medical Representative   |   Reports Of Medical Representive   |   Example Of M.R. Daily Doctor Call Report In Php   |   Daily Sales Report Format For Medical Representative   |   Doctors Call Report   |   Pharmacutical Companies In Expenses Format   |   Daily Report Format Medical Representative   |  
Google : 1311 times | Yahoo : 60 times | Bing : 130 times |