Case study
TripXY — Transport ERP & Agency Operations Platform
Full-lifecycle transport ERP managing trip dispatch, snapshot-frozen billing, double-entry party ledgers, driver advance deductions, and multi-agency isolation.
Overview
TripXY is AS Infosolution's flagship Transport Management & Financial ERP built specifically for regional transport agencies and fleet owners across Gujarat, India. Live in production at tripxy.cloud, the platform manages the entire logistics journey: from initial trip creation, LR recording, and dispatch to GST-compliant billing, double-entry party khata ledgers, vehicle owner disbursements, and driver advance deductions.
Customer & Context
Regional Indian transport agencies operating dedicated and third-party fleets across high-volume industrial transport corridors, handling thousands of freight trips and complex party accounts every month.
Illustrative concept artwork
The Operational Challenges
Before adopting TripXY, agencies relied on manual paper registers, disconnected Excel sheets, and chaotic WhatsApp groups to manage trips and freight billing:
- Rate Disputes & Historical Rewrites: Whenever master billing rates were updated, old software would retroactively alter past unpaid invoices, causing major accounting conflicts with clients.
- Disconnected Advance & Diesel Logs: Cash advances handed to drivers and diesel filled at en-route petrol pumps were recorded in separate physical diaries, leading to severe leakages during final settlements.
- Unbalanced Party Ledgers: Transport agencies need to track receivables from booking parties and payables to vehicle owners simultaneously, making manual bookkeeping prone to reconciliation errors.
- Complex Trip Status Tracking: Difficulty determining which loads had been delivered, which were ready for invoicing, and which were cleared for vehicle owner disbursement.
The Engineered Solution
AS Infosolution engineered a modern, full-stack enterprise web platform utilizing Next.js 15 App Router, NestJS, Prisma ORM, and PostgreSQL.
Key System Capabilities & Architecture
- Snapshot-Frozen Rate Engine: Commercial amounts and freight rates are snapshot-frozen at trip creation time, guaranteeing that future rate-card adjustments never modify historical billing records.
- Double-Entry Financial Journal: Automated 4-account transaction engine (Receivable, Holding, Khata, Commission) ensuring atomic money moves and zero ledger drift across all party accounts.
- Derived Trip Lifecycle Ladder: Strict status progression (
Loaded → Ready to Bill → Disbursed) enforcing full operational clearance before settlements are triggered. - Integrated Pump & Advance Deductions: Direct logging of pump-wise diesel slips and cash advances with automatic reconciliation during driver salary and vehicle owner settlement.
- Multi-Agency RBAC: Fine-grained permission slug system with complete tenant data isolation, allowing multiple agencies to operate securely on the cloud infrastructure.
Web ERP & Agency Logistics Console
TripXY production screens — dark and light themes (8 verified screenshots)
Driver Companion Mobile App
Flutter mobile application for real-time driver tracking, toll recording, and digital POD (21 verified screens)
Technology Stack
Core Technologies & Frameworks
- Next.js 15
- TypeScript
- NestJS
- Prisma ORM
- PostgreSQL
- Tailwind CSS
- shadcn/ui
- PDFKit Generation
Measurable Results & Impact
TripXY has replaced manual register workflows for active transport agencies, providing full operational transparency and financial precision:
- 100% elimination of retro-billing rate conflicts through snapshot data immutability.
- End-to-end automation of the billing-to-disbursement pipeline, saving hours of manual calculation per trip.
- Accurate real-time outstanding khata visibility for all freight booking clients and third-party truck owners.
- Live in production and continuously serving regional logistics agencies across Gujarat.