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?
- Employee master
- Doctor master
- Hospital master
- Chemist master
- 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
We know how difficult it is to gather actionable data from field. Hence any “Master data” from this excel workbook can be ported to a professional SFA and CRM software like Medismo SFA and Medismo CRM.
Download the FREE Pharma DCR excel format
[lab_subscriber_download_form download_id=1]
i am unable to download the url.can u send the same as an attachment…pls clear me…,
please fill your email address… the excel template for DCR submission will be sent to your email.
I think the format is very apt for report of our Dispensary…
Just going round in circles. For Free download of DCR Excel format. Unable to download, as the link sent to my Email ID clicks open the same page to fill up the name and Email ID.
Hi
For those who couldnt download the Excel Template – we have emailed them personally 🙂
Team Medismo