Project introduction
Vehicle history management system | Custom system development case study
Fleet management system designed for car rental and tourism shuttle companies, centralizing management of vehicle records, mileage, maintenance and repairs, attachments, and expiration reminders. Features include a maintenance cost dashboard, per-mile cost reports, AI document recognition, duplicate repair alerts, role-based permissions, and audit logs, with support for Excel export, Google Sheets synchronization, and backup.
Background of the Problem
Scattered maintenance documents make mileage and costs difficult to compare. Vehicle histories connect document recognition, human review, reminders and reporting to the same records.
Core Features
- Vehicle records, mileage, and complete maintenance history
- AI document recognition and manual verification
- Expiration reminders and duplicate repair alerts
- Maintenance costs, per-mile costs, and vehicle condition reports
- Three role-based permissions: Owner/Manager/Staff
- Excel export and Google Sheets synchronization
Implementation Methods
- —Duplicate repair matching with three-level rollback: parts/name/category
- —Mileage tracking window and concurrent cost calculation to avoid numerator/denominator errors
- —Data protection with audit logs, private attachments, and recoverable backups
Data Flow
- 01Create vehicle, mileage and maintenance records.
- 02Upload receipts and review extracted information.
- 03Check deadlines, repeat repairs and cost reports.