🎯 Daily MIS War Room Dashboard
This is not a normal report — this is your command centre. View it every morning & evening.
₹2.4 Cr
Today's Revenue
₹1.82 Cr
Cash Balance
42%
Gross Margin
₹18L
Net Profit (Today)
2.1%
Wastage %
24 days
Receivables Age
🧭
Structure: Your dashboard has 7 blocks — Cash Control, Sales, Profitability, Production, Delivery, Inventory, Team. Use the tabs above to navigate each block.
🏆 Must-Create Reports
Daily Cash Flow Report
Daily P&L (Auto)
Sales Funnel Report
Inventory Aging Report
Production Efficiency Report
🎯 KPI Snapshot
Gross Margin
> 40%
42%
✓ OK
Net Margin
> 10%
12%
✓ OK
Wastage
< 3%
2.1%
✓ OK
Receivables
< 30 days
24 days
✓ OK
Stock Turnover
< 45 days
51 days
⚠ Fix
📣 Final Truth
🔄
Earlier: You were running business by feeling
✅
Now: You run business by numbers
Daily review of this dashboard will increase your profit by ₹20–30L/month
💰 1. Cash Control Dashboard
TOP PRIORITY — Are we surviving or sinking?
Opening Bank Balance
₹1.65 Cr
↑ From yesterday
Cash In Today
₹48.2 L
↑ +12% vs last week
Cash Out Today
₹31.5 L
↑ +5% vs last week
Closing Balance
₹1.82 Cr
✓ Above ₹50L threshold
➕ Additional Metrics
Total Receivables
₹8.4 Cr
Safe
Overdue Receivables (>30 days)
₹2.1 Cr
⚠ Alert
Total Payables
₹3.8 Cr
Watch
Net Cash Position
₹4.6 Cr
✓ Good
🚨 Alerts
✅ Cash balance ₹1.82 Cr — well above ₹50L threshold
🔴 Overdue Receivables ₹2.1 Cr exceeds ₹10 Cr safe zone — chase immediately
⚠️ Daily collection ₹48L — target is ₹50L+. Close the gap.
Collection vs Target96%
Cash vs Minimum Required364%
📈 2. Sales & Collection Dashboard
Are we growing revenue fast enough?
Orders Booked Today
₹2.4 Cr
↑ 8 new orders
Collection Today
₹48.2 L
↓ ₹1.8L short of target
MTD Sales
₹6.8 Cr
↑ +14% vs last month
Target vs Achieved
87%
On track for target
📋 Sales Funnel Today
| Stage | Count | Value | Status |
|---|---|---|---|
| Leads Generated | 24 | — | Active |
| Meetings Done | 11 | — | Active |
| Quotes Sent | 8 | ₹3.2 Cr | Pending |
| Orders Closed | 5 | ₹2.4 Cr | ✓ Closed |
| Collection Done | 4 | ₹48.2 L | ✓ Done |
👥 Team-wise Performance
| Executive | Orders | Collection | Avg Order |
|---|---|---|---|
| Rajan | ₹85L | ₹18L | ₹17L |
| Priya | ₹72L | ₹15L | ₹14.4L |
| Arjun | ₹63L | ₹12L | ₹12.6L |
| Meena | ₹41L | ₹8L | ₹8.2L |
| Total | ₹2.61 Cr | ₹53L | — |
Monthly Target Achievement87%
⚠️
Alert: Daily collection < ₹15–20 Lakhs target. Push collection calls this afternoon.
🔥 3. Profitability Dashboard
HEART OF YOUR BUSINESS — Are we actually making money today?
📌
This is where most businesses fail. Track these numbers every single day.
Revenue Today
₹2.4 Cr
Material Cost
₹1.39 Cr
58% of revenue
Labour Cost
₹18 L
7.5% of revenue
Transport Cost
₹4.8 L
2% of revenue
Installation Cost
₹6 L
2.5% of revenue
⚙️ Auto Calculations
Gross Margin %
42%
✓ >40%
Contribution Margin
34%
✓ Good
Net Margin (after fixed cost)
12%
✓ >10%
📊 Margin Trend (This Week)
Gross Margin % — Mon to Sun
Gross Margin42% / 40% target
Net Margin12% / 10% target
🚨 Alerts
✅ Margin 42% — above 35% threshold. All good!
⚠️ Order #INV-2204 — labour cost spike. Review immediately.
✅ No sudden cost spikes detected today.
🏭 4. Production & Wastage Dashboard
This is where silent profit leakage happens
Production Value (Today)
₹1.9 Cr
Orders in Production
23
5 completing today
Delayed Jobs
4
⚠ Action required
Wastage %
2.1%
✓ Below 3% target
🔍 Critical Tracking
| Item | Issued | Actual Used | Wastage | Status |
|---|---|---|---|---|
| Steel Sheet | 450 kg | 438 kg | 2.7% | ✓ OK |
| Powder Coat | 80 kg | 76 kg | 5% | ⚠ High |
| Wiring Cable | 200 m | 198 m | 1% | ✓ OK |
| Fasteners | 500 pcs | 494 pcs | 1.2% | ✓ OK |
🚨 Alerts
🔴 Wastage exceeded 3% in Powder Coat — immediate review needed
⚠️ Machine idle time > 20% on Line 2 — check scheduling
✅ Rework cases: 2 only — within acceptable range
Overall Wastage2.1% / <3% target
Machine Utilisation78%
🚚 5. Delivery & Installation Dashboard
Delay = Cost = Customer Dissatisfaction
Orders Dispatched Today
12
↑ On schedule
Pending Dispatch
7
2 overdue
Installations Completed
8
Installation Pending
5
⚠ 2 beyond 3 days
🔍 Tracking Details
| Order | Dispatched | Delay Days | Install Status | Alert |
|---|---|---|---|---|
| ORD-5521 | Apr 03 | 3 | Installed | — |
| ORD-5522 | Apr 04 | 2 | In Progress | — |
| ORD-5518 | Mar 31 | 6 | Pending | 🔴 >3 days |
| ORD-5515 | Mar 29 | 8 | Pending | 🔴 >3 days |
| ORD-5524 | Apr 05 | 1 | Scheduled | — |
🚨 Alerts
🔴 ORD-5518 — 6 day delay. Call customer immediately. Risk of complaint.
🔴 ORD-5515 — 8 day delay. Escalate to management.
⚠️ 1 failed installation attempt on ORD-5522 — reschedule today
✅ Customer complaints this week: 1 — within acceptable limit
On-Time Delivery Rate74%
📦 6. Purchase & Inventory Control
Are we converting orders to cash efficiently?
⚠️ You have ₹5 Cr inventory — this must be tightly controlled
Total Stock Value
₹5.0 Cr
Raw Material Stock
₹2.8 Cr
High — review purchases
Finished Goods Stock
₹2.2 Cr
Dead Stock (>60 days)
₹68 L
⚠ Increasing
📋 Inventory Detail
| Item | Stock | Age | Movement | Status |
|---|---|---|---|---|
| Steel Frames | 120 pcs | 18 days | Fast | ✓ Good |
| Panel Boards | 45 pcs | 35 days | Slow | Watch |
| Control Cabinets | 18 pcs | 72 days | Dead | 🔴 Dead |
| Wire Harness | 300 m | 12 days | Fast | ✓ Good |
| Mounting Brackets | 600 pcs | 55 days | Slow | Review |
🚨 Alerts
🔴 Dead stock increasing — Control Cabinets 72 days old. Liquidate immediately.
⚠️ Over-purchase detected on Panel Boards. Pause new POs.
⚠️ Purchase rate increase >3% on Steel — negotiate with supplier.
Stock Turnover51 days / <45 day target
Fast-Moving Stock %62%
👥 7. Team Performance Dashboard
What gets measured gets improved
🤝 Sales Team
| Member | Calls | Meetings | Orders | Revenue |
|---|---|---|---|---|
| Rajan | 22 | 6 | 3 | ₹85L |
| Priya | 18 | 4 | 2 | ₹72L |
| Arjun | 15 | 3 | 2 | ₹63L |
| Meena | 12 | 2 | 1 | ₹41L |
| Total | 67 | 15 | 8 | ₹2.61Cr |
🏭 Production Team
| Worker | Output/day | Delays | Wastage | Rating |
|---|---|---|---|---|
| Kumar | 12 units | 0 | 1.2% | ⭐ Top |
| Venkat | 10 units | 1 | 2.1% | ✓ Good |
| Selvam | 8 units | 2 | 4.2% | ⚠ Low |
| Mani | 11 units | 0 | 1.8% | ✓ Good |
📊 Sales Conversions
Rajan85%
Priya72%
Arjun63%
Meena41%
🚨 Team Alerts
⚠️ Selvam — wastage 4.2%, above 3% limit. Coach immediately.
⚠️ Meena — lowest sales conversion 41%. Needs training support.
✅ Rajan — top performer. Revenue ₹85L. Reward & retain.
✅ Kumar — 0 delays, best output. Star worker this week.
🎯 11. Most Important KPI Targets
Fix these numbers — non-negotiable targets
📊 KPI Performance Today
Gross Margin %
Target: > 40%
42%
✓ Met
Net Margin %
Target: > 10%
12%
✓ Met
Wastage %
Target: < 3%
2.1%
✓ Met
Receivables Age
Target: < 30 days
24 days
✓ Met
Stock Turnover
Target: < 45 days
51 days
⚠ Miss
🚨 Action Items
✅ Gross Margin 42% — excellent! Maintain material cost discipline.
✅ Net Margin 12% — above 10% target. Keep fixed costs controlled.
✅ Wastage 2.1% — below 3%. Monitor Powder Coat line.
✅ Receivables 24 days — good. Keep chasing overdue accounts.
🔴 Stock Turnover 51 days — above 45 day limit. Stop excess purchasing. Move dead stock.
📋 Must-Create Reports
Daily Cash Flow Report
Daily P&L (Auto)
Sales Funnel Report
Inventory Aging Report
Production Efficiency Report
🚀 12. Final Impact — What This Will Do
If you follow this dashboard daily, here's what changes
You will
Detect Profit Leakage Immediately
You will
Improve Cash Flow Daily
You will
Control Costs Precisely
Expected gain
₹20–30L Extra Profit/Month
💬 Final Truth
🔄
Earlier: You were running business by feeling
✅
Now: You run business by numbers
This dashboard gives you total financial control with zero blind spots. Every morning and evening, 10 minutes of review = ₹20–30L extra profit per month.
✅ What We Can Build Next
Create exact ERPNext field names & report formats
Build Excel version before ERP implementation
Design automated WhatsApp daily MIS report
👆 Just tell me — I'll build it!