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.