Register New Vehicle
Enter vehicle details for workshop tracking
WORKSHOP DASHBOARD
Live Status MonitorMark Vehicle Ready
Scan the QR code, enter the registration number, and the vehicle will move to ready for delivery.
QC Result Update
Scan the QR code, enter the WIP number, then choose whether the vehicle passed or failed QC.
Fleet Courtesy Car Inventory
Manage and track your courtesy car fleet availability
Currently Assigned Vehicles
| Fleet Car | Assigned To (WIP#) | Customer Vehicle | Reg# | Days Out | Date Given |
|---|
All fleet cars are available
Staff Attendance
Mark daily attendance - On Duty / Absent
🔧 Technicians
0/0👔 Service Advisors
0/0👥 Other Staff
0/0Manage Vehicles
| WIP # | Reg # | Vehicle | Source | Type | Job Status | Daily Inflow | Service Advisor | Technician | Last Contact | Date In | Days | VAS | Courtesy | C.Days | WTY Status | WTY Remark | Status | Early Wash | Actions |
|---|
No vehicles registered yet
Use the Vehicle Entry tab to add new vehicles📅 Daily Appointments
Upload daily appointment sheet • Auto-match with workshop entries
No Appointment Sheet Uploaded
Upload a daily Excel file with customer appointment data.
Required column: Reg # (vehicle registration number)
💡 Each upload replaces the previous sheet — no storage buildup
📊 Reports & Analytics
Visual insights and performance metrics for your workshop
📈 Daily Vehicle Inflow
Vehicles received per day🔄 Job Status Distribution
Current active vehicles👨🔧 Technician Workload
Vehicles assigned per technician👔 Service Advisor Performance
Vehicles handled per advisor🚗 Vehicle Source Split
Retail vs Leasing🛠️ Service Type Split
Service vs Repair⚠️ Critical Cases
By case type📋 Workshop Performance Summary
Key metrics at a glance| Metric | Today | This Week | This Month | All Time |
|---|
⏱️ Turnaround Time Analysis
Average days from vehicle-in to completion👨🔧 Avg Turnaround by Technician
Days to complete (lower is better)📈 Turnaround Trend
Weekly average over last 4 weeks⚠️ Aging Report
Active vehicles by days in workshop🚨 Vehicles Over 15 Days (Requires Attention)
| WIP # | Vehicle | Reg # | Days | Job Status | Technician | Service Advisor | Reason |
|---|
🛡️ Warranty Analysis
Warranty claims performance and processing metrics📊 Warranty Status Distribution
Current warranty pipeline📈 Warranty Claims Trend
Monthly warranty submissions👔 Warranty Claims by Service Advisor
Who submits the most warranty claims📝 Common Rejection Reasons
Top reasons for warranty rejection⚠️ Warranty Claims Pending Over 7 Days
0 claims| WIP # | Vehicle | Status | Days Pending | Service Advisor | Submitted Date |
|---|
🔁 Repeat Repair Tracker
Vehicles returning within 30/60/90 days of previous visit👨🔧 Repeat Rate by Technician
Which technicians have higher repeat rates👔 Repeat Rate by Service Advisor
Repeat visits by advisor🔁 Repeat Vehicles - Within 30 Days
Showing: 30 days| Reg # | Vehicle | Current Visit | Previous Visit | Days Between | Technician | Service Advisor | Service Type |
|---|
📅 Appointment Analysis
Appointment vs Non-Appointment vehicle inflow📊 Daily Breakdown
Appointment vs Walk-in by day🥧 Distribution
Overall split📆 Day of Week Pattern
Which days have more walk-ins?📋 Detailed Inflow Records
Showing: This Week| Date | WIP # | Reg # | Vehicle | Type | Service Type | Service Advisor | Source |
|---|
💰 Revenue Report
Last updated: --Budget vs MTD by Brand
Overall Achievement
Jetour Service
| Service Type | Budget | MTD | Sum to Go | % |
|---|
Hongqi Service
| Service Type | Budget | MTD | Sum to Go | % |
|---|
McLaren Service
| Service Type | Budget | MTD | Sum to Go | % |
|---|
INEOS Service
| Service Type | Budget | MTD | Sum to Go | % |
|---|
Achievement Progress by Brand
⚠️ Critical Complaints Report
View All Complaints →🚗 Courtesy Car History Report
| Date | WIP # | Reg Number | Vehicle | Customer | Courtesy Type | Fleet Car | Courtesy Given | Courtesy Returned | Days | Event Type | Vehicle Status |
|---|
📞 Customer Communication Report
Track customer contact compliance and advisor performance
👤 Advisor Performance
| Advisor | Updates | Reached | Missed | Rate |
|---|
📜 Recent Activity
⚠️ Vehicles Needing Customer Update
| WIP # | Reg # | Vehicle | Advisor | Days In | Last Contact | Status | Action |
|---|
⚠️ Critical Complaints
Track and manage critical customer complaints
📝 Log New Complaint
📋 Complaints Log
| Date | Location | Reg # | Vehicle | Customer | Complaint | Age | Status | Actions |
|---|
🛡️ Warranty Management
Manage warranty-related vehicle records
| WIP # | Reg # | Vehicle | Service Advisor | Date In | Days | Job Status | WTY Status | Warranty Remark | Actions |
|---|
🗄️ Storage Monitor
Monitor Firestore database usage and manage storage
Database Usage
Calculating...Storage Breakdown
🧹 Data Cleanup
Delete old completed records to free up storage space. This action cannot be undone.
💡 Storage Tips
- Firestore free tier allows 1 GB of storage
- Each vehicle record uses approximately 1-2 KB
- You can store roughly 500,000+ vehicle records in the free tier
- Regularly delete old completed records to maintain performance
- Export data to CSV before deleting for backup purposes
📋 Physical Inventory
Monitor vehicles parked for extended periods on premises
Initial Data Import
Upload your Excel file to import existing long parked vehicles data
Supported: .xlsx, .xls, .csv
Admin Panel
Enter admin password to access settings