product
Rate cards per vehicle
Different rates per car, per package, per date — without spreadsheets.
Every car has a price per package (hourly / daily / weekly / monthly) with an effective_at date. Rent agreement creation pulls the current rate automatically from the right card.
- car_rent_policies + car_rent_policy_details tables
- Historical rates preserved (effective_at index)
- Rates stored as NUMERIC(12,2) — no rounding surprise
- UI lives in the car detail "Rate card" tab
How it works
On rent create: SELECT rate FROM car_rent_policy_details JOIN car_rent_policies WHERE car_id = ? AND package_id = ? AND effective_at ≤ rent.start ORDER BY effective_at DESC LIMIT 1.
Edit rates on any car detail page.
More product features
- Bookings & reservationsHold a car for a customer before they pay a rupee.
- Rent agreements with live totalsEvery formula from the legacy desktop — plus the rules it only implied.
- Offline payment provisionCash, cheque, bank transfer — first-class, not bolt-on.
- Owner payouts ledgerPer-car, per-owner, per-rent. Nothing to reconcile by hand.