WilliamW Resources

Fleet management system: Custom-built for a Malaysian rental & corporate fleet company

A fleet system covering the entire vehicle lifecycle: registry, maintenance, repairs, insurance, rentals and hire-purchase loans with auto-computed amortization. Expiring road tax, policies and instalments trigger tiered reminders pushed daily to WhatsApp, Lark or Teams, and uploaded documents are read by offline OCR and filed to the right vehicle in one click. Across a 280-vehicle fleet, missed renewals have gone from under a hundred a year to zero since go-live.

Ask me on WhatsAppFree Renewal Check

Client delivery · 2026

Fleet dashboard with live KPIs, overdue alerts and 12-month cost trends (sample data)

Cost per vehicleWXA 1234

RM 2,560.00

Maintenance
RM 2,080.00
Repair
RM 480.00

Sample data

Fleet dashboard with live KPIs, overdue alerts and 12-month cost trends (sample data)

The starting point

Vehicles, road tax dates, insurance renewals, workshop bills and loan instalments lived in separate spreadsheets. Renewals slipped through, nobody could say what a vehicle truly cost per year, and filing paperwork meant retyping every invoice and policy by hand.

What was built

  • Vehicle registry with plate, chassis, mileage, road tax and inspection dates, plus a full per-vehicle history timeline
  • Four-level expiry reminders across insurance, road tax, servicing and payments, with daily digests to WhatsApp / Lark / Teams
  • Finance module: rentals with payment schedules; hire-purchase loans with flat or reducing amortization computed automatically
  • Offline OCR (PaddleOCR, Chinese + English) reads uploaded policies and invoices, extracts fields, matches the plate and files to the vehicle after review
  • Insurance policies and claims tracking with per-vehicle cost rollups
  • Custom roles built from checkbox permissions, and 11 Excel/print report types

Tech stack

  • Node.js
  • Express
  • SQLite
  • PaddleOCR
  • Vanilla JS
  • ExcelJS

Inside the system

  • 360° vehicle profile: insurance, maintenance, finance and mileage in one view (sample data)
    360° vehicle profile: insurance, maintenance, finance and mileage in one view (sample data)
  • Hire-purchase finance with an auto-computed 84-instalment repayment schedule (sample data)
    Hire-purchase finance with an auto-computed 84-instalment repayment schedule (sample data)
  • Automatic reminders for insurance, road tax, servicing and payments, graded by urgency (sample data)
    Automatic reminders for insurance, road tax, servicing and payments, graded by urgency (sample data)
  • One-click Excel exports and printable reports with per-vehicle cost breakdowns (sample data)
    One-click Excel exports and printable reports with per-vehicle cost breakdowns (sample data)
  • Role-based access control with custom roles built from checkbox permissions (sample data)
    Role-based access control with custom roles built from checkbox permissions (sample data)

What it changed

“The system paid for itself within the first few months. Renewals used to slip through the cracks, and now they don’t. It’s one of the few tools we’ve invested in that our team actually uses every day.”

Supervisor · a rental and corporate fleet company
  • Across 280 vehicles, missed renewals went from under a hundred in the year before go-live to zero since; the system escalates before deadlines, in the chat apps people already read
  • True per-vehicle cost (maintenance + repairs + premiums + financing) became a report instead of a guess
  • Document filing dropped from a few hours a week to minutes: photo-upload, OCR does the typing, staff only verify
  • Finance staff see loan balances and upcoming instalments per vehicle without touching a calculator

Have a project in mind?

Tell me what you need. I usually reply within one business day.

Common questions

Does the OCR need an internet connection or per-page fees?

No. The primary OCR engine runs offline on your own server (PaddleOCR, Chinese and English), so documents never leave your system and there are no per-page API fees. Cloud engines can be added as optional fallbacks.

Our fleet is small. Is a custom system overkill?

The build is phased: a small fleet usually starts with "Registry + Reminders, Phase 1" only, which already removes the missed-renewal problem, and adds finance or OCR later only if the pain justifies it.

Can it manage vehicles we rent out to others?

Yes. Rentals are first-class: each rental has a tenant, a payment schedule and overdue tracking, and rent income appears in the per-vehicle cost rollup.

Ready to scope it?

Send what you manage today and what hurts. I reply within one business day; once we have talked it through, you get a written scope with a fixed price per milestone within one business day.