Register New Vehicle
Enter vehicle details for workshop tracking
WORKSHOP DASHBOARD
Live Status Monitor
Our Courtesy
0
Leasing Courtesy
0
Monthly Target
--
•
Achieved
--%
LIVE
0
APPTS TODAY
--°
Loading...
Washing Department
Mark Vehicle Ready
Scan the QR code, enter the registration number, and the vehicle will move to ready for delivery.
QC Department
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
0
Available
0
In Use
0
Total Fleet
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
0
On Duty
0
Absent
0
Total Staff
🔧 Technicians
0/0👔 Service Advisors
0/0👥 Other Staff
0/0Manage Vehicles
Date Filter
to
| 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
0
Total Appointments
0
Arrived
0
No-Show
0
Pending
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
Showing:
This Week
0
Total Vehicles
+0 this period
0
Completed
+0 this period
0
Avg Days in Workshop
—
0%
Courtesy Car Rate
—
📈 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
0
Overall Avg Days
0
Service Avg Days
0
Repair Avg Days
-
Fastest Technician
👨🔧 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
0-5 Days
0
vehicles
6-10 Days
0
vehicles
11-15 Days
0
vehicles
16-30 Days
0
vehicles
30+ Days
0
vehicles
🚨 Vehicles Over 15 Days (Requires Attention)
| WIP # | Vehicle | Reg # | Days | Job Status | Technician | Service Advisor | Reason |
|---|
🛡️ Warranty Analysis
Warranty claims performance and processing metrics
0
Total Claims
all time
0%
Approval Rate
0 approved
0%
Rejection Rate
0 rejected
0
Avg Processing Days
0 pending
📊 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
0
Total Repeat Visits
all time
0%
Repeat Rate
of total vehicles
0
Within 30 Days
critical repeats
0
Avg Days Between
visits
Within 30 Days
0
Within 60 Days
0
Within 90 Days
0
All Repeats
0
👨🔧 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
0
Total Vehicles
this week
0
With Appointment
0%
0
Walk-in / Non-Appointment
0%
0%
Appointment Compliance
target: 80%
📊 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: --
0
Total Budget
0
Total MTD
0
Sum to Go
0%
Achievement
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
0
Delivered & Returned
0
Returned (Not Delivered)
0
Courtesy Taken Back
0
Source Changed
0
Total Records
| 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
Total Updates
0
Customers Reached
0
No Answer/Busy
0
Pending Updates
0
👤 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
0
Open
0
Solved
0
Escalated
📝 Log New Complaint
📋 Complaints Log
| Date | Location | Reg # | Vehicle | Customer | Complaint | Age | Status | Actions |
|---|
🛡️ Warranty Management
Manage warranty-related vehicle records
0
WIP Submitted
0
WIP Received
0
Invoicing Pending
0
Invoiced
0
Rejected/Returned
| 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...
0 KB
1 GB Free Tier
Storage Breakdown
Vehicles Collection
0 records
~0 KB
Attendance Collection
0 records
~0 KB
Active Vehicles
0 records
~0 KB
Completed Vehicles
0 records
~0 KB
🧹 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
Daily Refresh Tip
Press Ctrl + Shift + R once daily to get the latest updates