HO Admin Integrated Prototype v1
PG
Admin
ProGNS Team

Dashboard enhanced with Targets

Your existing analytics — now with Target vs Achievement layered onto the sales blocks.

Revenue Overview
Monthly Sales
month-by-month revenue arc
Total Sales
₹3,04,63,897
Peak Month
Mar
₹34,89,736
Monthly Average
₹23,43,376
↺ Reuses your live /dashboard/monthly-sales endpoint — unchanged.
Regional Snapshot
ProGNS Sales
Total Revenue
₹10,74,768
across ProGNS regions
Leading Region
Deepanshu
5 active
Region (rep)TargetSales% Achievement newShare
Deepanshu₹3,20,000₹3,65,644114%34%
Shivanshu₹2,90,000₹2,69,23393%25%
Rishant₹2,50,000₹2,09,99784%20%
SaiGanesh₹2,20,000₹1,79,29982%17%
OTHERS₹50,5954%
Company₹10,80,000₹10,74,76899%100%
↺ Reuses /dashboard regional data + your leaderboard. + NEW: Target & % Achievement columns (targets from our new targets table; region target = sum of its customers).
Doctor Snapshot
Doctor-wise Sales
Dr. NameRegionTarget newTotal Sales% Ach new
Dr. Prashant SalviShivanshu₹90,000₹1,01,924113%
Dr Bala MurganSaiGanesh₹80,000₹77,29697%
Dr. Mahendra NarwariaDeepanshu₹70,000₹61,92788%
Dr Naveeswar ReddySaiGanesh₹60,000₹54,88591%
Dr. Ajay GaurRishant₹40,000₹38,07495%
UnassignedOTHERS₹50,595

47 rows · invoices not linked to a doctor grouped under "Unassigned".

↺ Reuses /dashboard/doctor-sales?date&region. + NEW: per-doctor Target & % Achievement (customer-wise targets reps plan).
Product Mix
Product Sales
TOTAL
₹10.7L
Bariforte Multivitamin kit28%
Gold Pro Vanilla26%
Gold Pro Chocolate24%
Gold Pro Mango12%
Protein Bar-Chocolate11%
↺ Reuses /dashboard/product-sales?date&region — this feeds our Sales Analysis → Brand-wise tab too (same source, no rebuild).
Head Office · Wednesday, 8 July 2026

Command Centre

Everything the team submits, at a glance — what needs your action, and how the month is tracking.

Pending approvals
6
across 4 types
Company target
₹28.25L
Aug · assigned to 4 reps
Achieved MTD
₹5.68L
20% · Jul
DCRs filed today
3 / 4
SaiGanesh pending
Avg deviation
16.6%
team, July MTD
Needs your action now
Approvals queue
Shivanshu — Aug week 12 min ago
Rishant — August1 hr ago
SaiGanesh — August3 hr ago
Dt Kavita Mehra (Rishant)Yesterday
Dr Hemi Soneja (Rishant)Yesterday
Deepanshu — Aug week 1Yesterday
Team pulse · today
RepDCRPlan
Rishant
ShivanshuFiled
DeepanshuFiled
SaiGaneshNot filedNot started
SaiGanesh: no DCR today, Aug plan not started, deviation 31.6%. Needs a call.
Revenue Overview
Company % Target Achievement — month on month

Achieved sales as a % of assigned target, whole company.

63%
Mar
78%
Apr
101%
May
85%
Jun
20%
Jul
MTD
Area 1 · The core control loop

Approvals Hub

Every rep submission lands here. Approve to lock, or return with a note. Try the buttons — they work in this wireframe.

Tour plans
2
Target plans
2
New doctors
1
Profile updates
1
Pending queue
Shivanshu — 13–19 Jul (weekly)Submitted 2 min ago · 6 days · Mumbai 5 / Surat 1 · 24 planned calls
Objectives filled on all 24 doctors ✓ · 3 doctors flagged "not visited 60+ days" included ✓
Rishant — August 2026Planned ₹7,90,000 · 7 doctors · assigned grand-total ₹8,50,000
Bariatric ₹5.8L (73%) · Obesity Care ₹1.1L · biggest bet: Hexa Healthcare ₹1.0L (was 9% in Jul)
Dt Kavita Mehra — requested by RishantDietitian · BLK Hospital · Delhi · attached to Dr Randeep Wadhawan
Duplicate check: no match in MCL ✓ · Next code in sequence: P2214 · Birthday: 12 Sep
Dr Hemi Soneja — hospital changeSoneja Clinic → Max Smart, Saket · requested by Rishant
Reason: Doctor shifted practice from July · Code P2088 unchanged
SaiGanesh — August 2026Planned ₹4,10,000 · 12 doctors · assigned ₹4,00,000
Deepanshu — 13–19 Jul (weekly)Submitted yesterday · 6 days · Ahmedabad-heavy, 2 outstation legs · 26 calls
Recently decided · audit trail
ItemDecisionByWhen
Deepanshu — August targetsApproved & lockedSamirYesterday 6:12 PM
Dr Amit Garg — new doctorApproved · P2213SamirYesterday 6:10 PM
Shivanshu — July targetsReturnedSamir28 Jun
Area 2 · Select a Region / MR and see the detailed Tour Plan

Team Tour Plans

Choose what each cycle should cover, push it to the team, then review what comes back.

Rishant — Plan · 13–19 July 2026
DRAFT · 3 OF 6 DAYS SAVED
Mon, 13 JulField WorkDelhi
Dr Vivek Bindal🎯 Push Bariforte kit for post-op batch; discuss hospital tender
Dr Sanjay Jain🎯 Re-introduce GLP Companion; leave clinical literature
Dr Saket Kant🎯 First call — profile the practice, gauge bariatric volume
Dr Dinesh Thakur🎯 Follow up on Gold Pro trial feedback
Tue, 14 JulField WorkDelhi
Dr Pankaj Agarwal🎯 Convert to Bariforte from competitor multivitamin
Dr PK Diwan🎯 Quarterly relationship call; check sampling needs
Dr Abhimanyu Diwan🎯 Present Protein Bar range for OPD counter
Wed, 15 JulField WorkLudhiana
Dr KS Kular🎯 Reactivate — no order since May; birthday visit (27 Jul)
Dr GS Jammu🎯 Institutional rate discussion for Ursogreat
Edit control: the rep can request an edit to this plan from their side, but any change stays pending and only goes live once HO re-approves it here.
Tour Plan Summary · Table 1 · Rishant
Dr. NameNo. of Calls PlannedLast 15 days · No. of times Visited
Dr Vivek Bindal13
Dr Sanjay Jain11
Dr Saket Kant10
Dr Dinesh Thakur12
Dr Pankaj Agarwal11
Dr PK Diwan11
Dr Abhimanyu Diwan10
Dr KS Kular10
Dr GS Jammu11
Tour Plan Summary · Table 2 — coverage
Total Doctors in MCLUnique doctors planned% Planned
25936%

Auto-updates as the plan changes — unique doctors planned ÷ total MCL for this MR.

Approved Tour Plans — full history since data entry began
Rishant · date-wise

Every approved plan, listed one row per planned date (not by cycle). Approving a plan adds its dates here automatically.

DateDay typeCityDoctors plannedReportedApproved on
Sat, 12 Jul 2026Field WorkDelhi545 Jul
Fri, 11 Jul 2026Field WorkDelhi445 Jul
Thu, 10 Jul 2026Field WorkJalandhar435 Jul
Wed, 9 Jul 2026Field WorkDelhi555 Jul
Mon, 7 Jul 2026Field WorkDelhi4328 Jun
Sat, 5 Jul 2026Field WorkDelhi5528 Jun
Fri, 4 Jul 2026Field WorkDelhi2128 Jun
Thu, 3 Jul 2026Field WorkJalandhar4328 Jun
Tue, 1 Jul 2026Field WorkDelhi4428 Jun
Mon, 30 Jun 2026Field WorkDelhi4422 Jun
Sat, 28 Jun 2026Field WorkLudhiana3222 Jun
Fri, 27 Jun 2026MeetingDelhi22 Jun

Data entry began 1 May 2026 — history goes back to the first approved plan. Click any date to open that day's full doctor list with objectives.

Area 4 · Merged — field feed, filing discipline & roll-ups

DCR Feed · Compliance · Visit Analysis Roll-up

The live pulse of the field team, the discipline scorecard, and the aggregated visit roll-ups — in one place.

HO Dashboard
Daily Call Reporting

Showing: whole country. Select an MR to see their full date-wise call history — scroll for all dates.

DatePlanned DoctorsCalls done
Showing: whole country. Pick an MR and the roll-ups below filter to that MR — the same Call Analysis layout as the rep's own page.
DCRs filed today
3 / 4
SaiGanesh pending
Filing rate · MTD
88%
team average
Avg deviation
16.6%
completely-missed doctors
Not visited 30d+
17
of 426 in MCL
Customer-wise · No. of calls done · whole country
DoctorSegmentCalls MTDDates visited
Dr Vivek BindalBAR3Today
Dr Ajay GaurBAR25 Jul
Dr Pankaj AnejaOBE24 Jul
Dr Hemi SonejaOBE12 Jul
Dt SamareenDIET13 Jul
Missed customers · planned but not visited
DoctorPlanned onStatus
Dr Dinesh Thakur7 JulNot visited
Dr Sanjay Jain6 JulNot visited
Dr Saket Kant6 JulNot visited
Dr HS Jolly3 JulNot visited
Plan discipline
% Deviation from Planned calls
14.8%

4 of 27 planned doctors completely missed this month.

Planned doctors (MTD)27
Met on planned day21
Met on another day not a deviation2
Completely missed deviation4

Deviation rule: a planned doctor met on a different day is not counted as deviation. Only a doctor completely missed for the month counts as a deviation.

Working days reported · by HQ (team roll-up)
HQDays reported (team)
MTD Total Working Days72
Delhi18
Mumbai16
Ahmedabad19
Hyderabad9
Outstation (all)10
Segment coverage · company · July MTD
SegmentIn MCLPlanned (a)Visited (b)% (b/a)
Bariatric19814210473%
Obesity Care96704463%
Dietitians132882933%
Doctors not visited 30 / 60 / 90 days · push into next plan
DoctorRepSegmentLast visit
Dr KS KularRishantBAR41 days ago
Dr Sanjeev DahiyaRishantOBE36 days ago
Dr Bala MurganSaiGaneshBAR63 days ago
Area 3 · You set the number, they own the breakup

Targets Control

Reps plan targets per customer; a region's target is the sum of its customers. Achievement is auto-computed from doctor-tagged invoices.

Showing: whole country · pick an MR to see their detailed customer-wise plan. Change the month to view historical targets.
New module · achievement analysis

Sales Analysis

Target vs actual sales, sliced by customer, region and brand — each exportable to Excel.

Revenue Overview · % Target Achievement — month on month
58%
Mar
72%
Apr
104%
May
81%
Jun
12%
Jul
MTD
Section 1
Customer-wise Sales Analysis
MonthTargetSales% Achievement
April₹1,00,000₹85,00085%
May₹1,00,000₹80,00080%
June₹1,00,000₹1,10,000110%
July₹1,00,000₹35,00035%
Section 2
Region-wise Sales Analysis
MonthTargetSales% Achievement
April₹25,00,000₹21,25,00085%
May₹26,00,000₹20,80,00080%
June₹26,32,000₹28,95,000110%
July₹28,25,000₹9,88,00035%

A region's target = sum of its customers' targets. Sales pulled from doctor-tagged invoices in that region.

Section 3
Brand-wise Sales Analysis
BrandFebMarAprMayJunJulTOTAL
ProGNS Bariforte Multivitamin kit4204605105404951202,545
ProGNS Gold Pro Vanilla380410445470430982,233
ProGNS Gold Pro Chocolate350375400425390882,028
ProGNS Gold Pro Mango290310330345318721,665
ProGNS Protein Bar-Chocolate210230255270245551,265
ProGNS GLP Companion180205240265238601,188
ProGNS Protein Bar-Cranberry15016518019517640906
ProGNS Gold Pro Strawberry16017519020518844962
ProGNS Gold Pro Multi-flavour Pack12013515016515035755
ProGNS Ursogreat Tablets9510812213512428612
ProGNS BariGreat809210511810824527
ProGNS Baribiotics Tablets7080921039521461
TOTAL2,5052,7453,0193,2362,95770515,167

Toggle Units / Values to switch the figures. Brand list pulled from the products master; monthly columns from invoice line-items.

Area 5 · Master Customer List control

Doctors / MCL Management

The master stays clean because every addition and edit is approved here. Dr. Codes auto-sequence; birthdays live in the master.

Total in MCL
426
across 4 regions
Pending additions
1
Dt Kavita Mehra
Pending edits
1
Dr Hemi Soneja
Next Dr. Code
P2214
auto-sequenced
Pending in Approvals Hub
Dt Kavita MehraDietitian · BLK Hospital · Delhiby Rishant
Dr Hemi SonejaHospital → Max Smart, Saketby Rishant
Master Customer List
Dr. CodeDoctorSegmentHospital / CityRepBirthdayStatus
P1101Dr Vivek BindalBARMax · DelhiRishant14 MarActive
P1102Dr Ajay GaurBARFortis · DelhiRishant02 NovActive
P2088Dr Hemi SonejaOBESoneja Clinic · DelhiRishantedit pendingActive
P1533Dr Prashant SalviBARApollo · MumbaiShivanshu09 JanActive
P2214*Dt Kavita MehraDIETBLK · DelhiRishant12 Sep

*Code reserved in sequence; becomes active on approval. Birthdays drive the reminder shown on each rep's home page.

Upcoming birthdays · this week (drives rep reminders)
Dr KS KularP1119 · Rishant27 Jul 🎂
Dr Chintan PatelP1534 · Shivanshu29 Jul 🎂

Inventory existing

Your current live Inventory module — unchanged.

Existing tab. Lives as-is in the current admin app; shown here so the full navigation is visible in one shell.

Team existing

Your current Team module — reps/users. Our Doctors/MCL and field modules link to these same users (region = rep).

Existing tab. The rep records here are the same identities our field-force modules scope by.

Invoices existing

Your current Invoices module — the source of all sales & achievement figures.

Existing tab. These invoices are exactly what powers every % Achievement across the new modules.
Area 6 · Two-way match

Sample Reconciliation

Dispatched via Sample Vouchers vs given via DCRs, per rep. In-hand should always reconcile; mismatches flag for follow-up.

Reconciliation · July MTD
RepDispatched (vouchers)Given (DCRs)In handReconciled?
Rishant78 units38 units40 units✓ Matches
Shivanshu60 units41 units19 units✓ Matches
Deepanshu90 units52 units36 units✓ Matches
SaiGanesh40 units21 units15 units4 unaccounted

Dispatched pulls from HO Sample Vouchers; Given sums from DCR sample entries. Difference = in-hand; a mismatch flags automatically.

Recent dispatches · Sample Vouchers
SV-2026-118 · 1 JulRishantGold Pro × 30
SV-2026-117 · 1 JulShivanshuBariforte kit × 20
SV-2026-112 · 24 JunRishantGLP Companion × 10
SaiGanesh · mismatch detail
Dispatched40
Given (per DCRs)21
Expected in-hand19
Reported in-hand15
Unaccounted4
Flag raised — follow up with SaiGanesh on 4 unaccounted units.

Incentives existing

Your current Incentives module — unchanged.

Existing tab, shown for complete navigation.