DumperTrack is a fleet and finance management platform for dumper truck businesses. It tracks trips, client payments, driver salaries, vehicle EMIs and partner finances in one real-time, multi-user system.

Who built DumperTrack?

Karnveer Singh built it end-to-end — operations discovery, data modelling, UI/UX and the full React + Supabase implementation.

How are client payments settled?

Recording a client payment automatically distributes it FIFO across that client's oldest unpaid trips, so pending balances stay accurate without manual allocation.

How is data separated between firms?

Each firm gets a unique UUID link token and its own login URL. Every table is indexed by firm_id, so partners only ever see their own firm's operational data.

Heavy transport · Fleet & finance SaaS

DumperTrack

Every trip. Every rupee. A full-stack operations platform that replaced paper ledgers and WhatsApp updates for a multi-firm dumper truck business in India.

Live — multi-firm deployment

bumpermanager.vercel.app ↗

Overview

The client runs multiple dumper truck firms with several business partners, a rotating pool of drivers and dozens of active clients. Trips were logged by hand, driver salaries were calculated mentally at month-end, and nobody could say in real time what had been collected, what was outstanding, or whether a month was profitable.

DumperTrack is the operational nervous system of that business: partners log in from any device, add a trip entry in under a minute, see live financial summaries, and settle client and driver accounts without touching a spreadsheet.

Every architectural choice minimises operational complexity for a business with no technical team — a React single-page app on Supabase, no backend server, no deployment pipeline beyond a static host.

Scope

Operations discovery & data modelling
Product UI/UX for mobile-first field use
React + Supabase full-stack build
Credit/debit ledger and FIFO payment settlement
Driver salary and vehicle EMI systems
Multi-firm access control and handover

Tech stack

Frontend

React 18
Vite
JSX
Inline CSS design system

Database

Supabase
PostgreSQL
9 tables indexed by firm_id
Versioned migrations

Auth

4-digit partner PIN
UUID firm link tokens
Synthetic admin role

State & delivery

useState / useEffect store hook
Optimistic local state
Static hosting on Vercel

Deliverables

Trip management with immutable, locked-on-save entries
Credit & debit ledger with automatic FIFO client payment distribution
Per-client running balances — billed, received and pending at a glance
Driver salary system supporting per-trip and fixed monthly modes
Vehicle registry with EMI amount, tenure and outstanding loan calculations
Real-time balance sheet: gross income, pending collections, net profit, partner contribution
Admin panel for firms, partners, PINs and firm access links
Nine-table Supabase schema with migrations and firm-level isolation

Outcomes

Manual ledger books needed: 0
Data types tracked: 9 tables
Firm types supported: 2
Transactions per firm: ~2,000

Frequently asked questions

What is DumperTrack?: DumperTrack is a fleet and finance management platform for dumper truck businesses. It tracks trips, client payments, driver salaries, vehicle EMIs and partner finances in one real-time, multi-user system.
Who built DumperTrack?: Karnveer Singh built it end-to-end — operations discovery, data modelling, UI/UX and the full React + Supabase implementation.
How are client payments settled?: Recording a client payment automatically distributes it FIFO across that client's oldest unpaid trips, so pending balances stay accurate without manual allocation.
How is data separated between firms?: Each firm gets a unique UUID link token and its own login URL. Every table is indexed by firm_id, so partners only ever see their own firm's operational data.