π°
β
Revenue (Today)
β
π
β
Gross Margin
π¦
β
Cash Position (ARβAP)
β
β¬οΈ
β
AR Outstanding
Receivable
β¬οΈ
β
AP Pending
Payable
π§Ύ
β
Invoices Finalized
Today
π¦
β
Live SKUs
In System
ποΈ
β
Units On Hand
Warehouse
π
β
Units Sold (Today)
π’
β
Containers Scanned
Today
β οΈ
β
Match Exceptions
π¨
β
Fraud Alerts (High)
π
β
Open Tasks
π΄
β
Overdue
β‘
β
Critical Priority
Urgent
β
β
Done
π
β
Backlog
Queued
Cash Position (AR β AP)
AP obligation building since Sep 10
Tasks by Department
Open count
| Department | Open Tasks | Load | Type |
|---|---|---|---|
| Loading⦠| |||
PHASE 1
Master Tracker
β
Complete β 148 KPIs mapped
PHASE 2
VGP / UMS Split
β
Complete β Separated by company
PHASE 3
Data Dictionary
β
Complete β 124 KPIs defined
PHASE 4
Data Source Map
β
Complete β 70/15/39 coverage
PHASE 5
Data Foundation
π΅ In Progress β ERP data pulls
PHASE 6
Live KPI Tracking
β¬ Pending
PHASE 7
Dept Scorecards
β¬ Pending
PHASE 8
Dashboards
β¬ Pending
PHASE 9+
Automation & Approval
β¬ Pending β $5K target
70
β
Connected & Ready
Pulling live from ERP today
15
π‘ Manual / Partial
Data exists, process needed
39
π΄ Not Connected
eBay Β· Amazon Β· Shopify Β· Logistics
KPI Connection Progress β 124 Total KPIs
56% Ready
Connected (70)
Manual/Partial (15)
Not Connected (39)
| Blocked Area | KPIs Blocked | What's Needed | Owner |
|---|---|---|---|
| eBay API | 12 | eBay OAuth credentials β Seller Hub API access | E-Commerce Team |
| Amazon SP-API | 12 | Amazon SP-API credentials β IAM role + Seller Central | E-Commerce Team |
| Shopify Admin API | 12 | Shopify API key/secret β Admin API 2024-01 | E-Commerce Team |
| Fuel & Mileage Log | 3 | Build driver daily log β Sheet column or ERP entry per driver | Logistics / Ops |
| Driver Labor Cost | 2 | HR payroll export β wage per driver per period | HR Team |
| Market Resale Price | 2 | Buyers enter expected resale price per SKU in ERP | Purchasing Team |