Loading…
Monthly Spend
Procurement by month
Vendor Concentration
Spend share
Recent GRNs
| GRN | Date | Vendor | Total | Status |
|---|---|---|---|---|
Monthly Spend vs Budget
Actual spend (bars) vs budget target (line)
Seasonal Pattern
Average monthly spend across all years — reveals seasonal cycles
Spend by Therapeutic Category
Where your procurement budget is going
Top 10 Items by Spend
Highest procurement cost items — click a row to investigate
Price Movement Alerts
Items where latest purchase price differs >10% from historical average
| Item ↕ | Vendor | Hist Avg | Latest | Drift ↕ | Interpretation |
|---|
All Items — Full Detail
| Item Name | Category | Orders | Avg Unit Price | Total Spend | Trend |
|---|
How to use this tracker:
Each item below is deduplicated per batch number. When Wai Teng physically verifies a batch, she can mark it checked —
this records the verification. Items that are expired and confirmed written off in SGiMed can be dismissed.
This does not write off stock in SGiMed — that must be done separately.
Expiry Watchlist — Deduplicated by Batch
| Status | Item | Batch | Expiry Date | Days Left | Vendor | Value | Wai Teng Action |
|---|
Spend by Vendor
Vendor Performance
| Vendor | GRNs | Total Spend | Share | Avg GRN | Discounts | Zero-Value |
|---|
Batch Recall Lookup
Search by item name, code, or batch number — returns all matching stock
What is VCDSS?
The Vaccine Centre Data Submission System is MOH Singapore's programme that subsidises specific childhood and adult vaccines for GP clinics.
You procure approved vaccines, submit claims to MOH, and receive reimbursement. This tab shows your VCDSS vaccine procurement history —
useful for verifying doses purchased vs doses submitted and tracking upcoming expiry of vaccine batches.
VCDSS Spend by Vaccine Type
Total procurement cost per vaccine programme
VCDSS Spend Over Time
Monthly vaccine procurement — useful for seasonal pattern
VCDSS Procurement Records
| Vaccine | GRN | Date | Batch | Expiry | Days Left | Amount |
|---|
GRN Closure Cycle Times
| GRN | Received | Closed | Created By | Closed By | Days | Status |
|---|
Monthly Avg Spend
—
Based on filtered period
Annual Projection
—
At current run rate
Spend Over Time
Actual (solid) · Projected (faded) · Budget line $30k
Monthly Breakdown
| Month | GRNs | Subtotal | GST | Discount | Total |
|---|
🇸🇬 Singapore Disease Surveillance — Live
Weekly case data from MOH via data.gov.sg · Refreshed each visit · Cross-referenced with your dispensing patterns
💬 Ask your data a question
Loading operational data…
Loading financial analysis…
Loading clinical data…
Categories Running Low
Items with <30 days stock by therapeutic category
Cash Tied Up in Overstock
Items with >90 days stock — potential to reduce orders
Order List
Stock snapshot:
FILTER:
Loading stock data…
🚨 Expired Stock — Verify & Write Off in SGiMed
| Item Code | Item Name | Stock Qty | Unit | Action Required |
|---|
| Month | Patients | Avg/Day | Private | Government | Revenue | Rev/Patient | Drug Cost/Patient |
|---|
GLP-1 Dispensing Revenue
Monthly revenue from GLP-1 agent dispensing
Dispensing vs Procurement Cost
Revenue earned vs cost of GLP-1 drugs purchased
GLP-1 Programme Monthly Detail
| Month | Dispensing Revenue | Procurement Cost | Gross Profit | Margin | Dispense Count |
|---|
Revenue vs Procurement
Monthly — revenue (teal) vs drug spend (orange)
Drug Cost Ratio
Procurement as % of revenue — lower is better
Revenue Mix — Patient vs Government
Patient-pay includes GLP-1, vaccines, private consultations · Government includes CHAS, HSG, MediFund
Monthly Revenue & Margin
| Month | Total Revenue | Patient | Government | Procurement | Drug Cost % | Gross Margin | Margin % |
|---|
Monthly Dispensing Volume
Total dispense events per month
Dispensing by Category
What your patients are actually receiving
Procurement vs Dispensing — Are You Buying What You Use?
Compare monthly procurement spend with dispensing volume. Gaps indicate overstocking or understocking.
Drug Dispensing Analysis
Items dispensed 10+ times/month on average — these are your critical stock items. Never let them run out.
| Medicine | Category | Total Dispenses | Monthly Rate | Days of Stock* | Status |
|---|
Open Irregularities
| Severity ↕ | Type ↕ | GRN | Vendor ↕ | Amount ↕ | Date ↕ | Description | Action |
|---|