Welcome Back

Log in to access Fleet Manager

FleetMgr

Smarter Fleet. Higher Profits.
MySQL Database

Fleet Management

Track performance, control cost, drive growth.

Active Fleet Operations (In-Transit & Holding Trips)

Transport Lifecycle: New Trip → [Holding / Breakdown] → Returning Trip (Closed). Vehicles remain locked until return leg is closed.

No Vehicles Currently In Transit or On Holding

All fleet vehicles are idle and available for new trips.

⚠️

Vehicle Locked — Currently Active in Fleet Operations

This vehicle is already in transit or on holding. A vehicle cannot start a new trip until its open trip completes its return journey.

Trip Starting Details & Vehicle Info

GENERATED TRIP NO. NZ/GATI/26-27/08/0001

Selecting a vehicle automatically pre-fills its assigned driver, division, and associated company

Expense Breakdown

All expenses in INR (₹). Blank fields default to 0.

Fuel & Road Charges
₹
Enter Quantity and Price — Total Cost calculates automatically
₹
₹
Driver & Labor Allowances
₹
₹
₹
Maintenance & En-Route Fees
₹
₹
₹
₹
₹
₹
₹
₹

Freight Bhada & Accounts

Billing, Payment accounts, and Trip Notes

₹

Live Trip Calculations

Real-Time
TOTAL TRIP EXPENSES ₹0.00 0 expense items logged
Bhada Revenue ₹0.00
Net Margin ₹0.00
Expense Distribution
Fuel (Diesel + CNG) ₹0
Toll & En-Route ₹0
Driver Allowances & Labor ₹0
Mechanical & Maintenance ₹0
Other / Holding / Police ₹0
Fleet Availability Today
Total Fleet Size 88 Vehicles
Active in Ops (In Transit + Holding) 0 Active
Available Fleet (Idle) 88 Ready
⛽ Current Fuel Prices Tap to edit

Dashboard Analytics & Financial Telemetry

💡 Interactive Drilldown: Click any KPI card, chart segment, or table row to view the exact source trips.

Total Trips
#
0
—vs previous period
Total Gross Bhada
₹
₹0
—vs previous period
Total Fleet Spend
₹
₹0
—vs previous period
Net Operating Margin
₹
₹0
0% margin
Fuel & Energy Spend
⛽
₹0
0% of spend

Revenue, Expense & Margin Trend

Click any point to drill down into that period's trips

Bhada Expense Margin

Expense Breakdown

Direct cost analysis by category

Revenue by Company

Click a bar to view company-specific trips

Trips by Status

Top Vehicles by Trips

#VehicleTripsSpend
View all vehicles →

Top Drivers by Trips

#DriverTripsRevenue
View all drivers →

Recent Trips

View all trips →
TP No.DateVehicleDriverCompanyRouteBhadaExpenseMarginStatus
No trips found Try adjusting your filters or selecting a different date range.

Trip Reports Hub

Unified reporting module for all trips (Created, Open, Holding, and Closed) with date filters, KPI summaries, and exports

Total Trips Found 0
In Transit / Holding 0
Closed / Completed 0
Filtered Bhada ₹0.00
Filtered Expense ₹0.00
Net Filtered Margin ₹0.00
← Comprehensive report view for all created, holding, and closed trips →
Status Trip No. (TP No.) Created / Start Date Closed Date Vehicle No. Driver Name Route / Holding Hub Outward TCS Return Builty Company Fuel Qty Total Exp. (₹) Bhada Rev. (₹) Net Margin (₹) Actions

No trip records match the selected report criteria.

Master Ledger Table

Full raw dataset with dedicated columns for all 30+ parameters, Auto TP No., and multi-row bulk selection

0 trips selected
← Scroll horizontally to view all 30+ column parameters →
Status Trip No. (TP No.) Start Date Closed Date Vehicle No. Driver Name From (Origin) To (Dest.) TCS / Builty Return Builty Trip Type Company Labour (₹) Food (₹) Adv Salary (₹) Diesel (₹) CNG (₹) Fuel Qty Holding (₹) Babu (₹) Police (₹) Toll (₹) Mechanical (₹) Touching (₹) Grease (₹) Maintenance (₹) Other (₹) Total Exp. (₹) Bhada Rev. (₹) Net Margin (₹) Paid By A/C Receiving A/C Remark / Holding Note Actions

No trip records match the selected filters.

Master Data Management Hub

Manage Vehicles, Drivers, Locations (with Auto Unique Code), Associated Companies, Divisions, FTL, and Fuel

0 items selected
Showing records

Audit & Activity History Log

Comprehensive ledger recording every minor and major action (Create, Edit, Delete, Holding Transition, Trip Closed, Google Sync) with exact timestamp, operator, and field details.

Exact Timestamp Operator / User Action Section Exact Activity & Change Details Details

No activity logs found.

Bulk Trip Upload (CSV / Excel)

Import trip logs in batches with automated validation

Drag & Drop Trip CSV File Here

or click to browse your computer (.csv files supported)

Upload Preview (0 Total Records)

Review parsed records and validation warnings before saving

⚠️
Incomplete or Error Entries Detected

Some records contain missing fields or warnings. You can choose to import only clean records or import all with defaults.

Validation Date Vehicle Driver Route Builty Company Total Exp. (₹) Bhada (₹) Status

Users & Roles

Manage employee accounts and their permissions.

Name Username Role Status Actions

Edit Trip Record

#TRIP OPEN

Primary Trip & Vehicle Details

Modify route, driver, builty numbers, or operational status

Expense Breakdown (₹ INR)

Edit individual expenses; total expenses and net profit update live

Quantity of fuel used on this trip (unit follows the fuel type set when the trip was created).

Revenue, Payment & Live Margin

Bhada revenue minus total expenses equals net profit margin

Log Holding / Detention Status

#TRIP
CURRENT VEHICLE & TRIP DETAILS
Vehicle: -
Driver: -
Outward Route: -

Holding & Stoppage Details

Vehicle standing for loading, unloading, breakdown, or terminal waiting

Incurred Holding & Detention Expenses (₹)
₹
₹
₹

Log Return Journey & Finalize Closed Trip

#TP-NO
OUTWARD & OPERATIONAL PROGRESS
Trip No: -
Vehicle: -
Driver: -
Outward Route: -
Start Date: -
Prior Incurred Exp: -
⏸️ Holding Logged: -

Complete Return Journey Operations

Record full return trip leg with fuel, tolls, allowances, and revenue settlement

Return Fuel & Road Charges (₹)
₹
Enter Quantity and Price — Total Cost calculates automatically
₹
₹
Return Driver & Labor Allowances (₹)
₹
₹
₹
Return Maintenance & En-Route Fees (₹)
₹
₹
₹
₹
₹
₹
₹
₹
₹
Combined Trip Expenses ₹0.00
Combined Bhada Revenue ₹0.00
Final Trip Net Margin ₹0.00

Source Data Drilldown

0 Records

Add New Record

Category

Bulk Upload Master Data

Category
1. Download Template for this Section Template includes all mandatory & optional columns with sample entries.

Drag & Drop Master CSV File Here

Or click to browse from your computer (Comma Separated .CSV)

Previewing 0 Total Records
⚠️
Validation Notice

Some rows contain missing fields or formatting issues. Review below.

Document Preview

PDF / Image
Download Document

Trip Expense Voucher

#TRIP

Audit Activity Record Details

#LOG

Hostinger MySQL Database Synchronization

MySQL Live

The application is powered by PHP + MySQL on Hostinger. All trip records, master catalogue items, user profiles, and audit trail logs are securely stored in your MySQL database via PDO prepared statements.

Hostinger Deployment Configuration:
  1. Import Database: Open Hostinger phpMyAdmin and import database/hostinger_fleet_manager.sql.
  2. Configure Credentials: Enter your DB Name, Username & Password in api/config.php.
  3. Upload Files: Upload all files to your Hostinger public_html/ folder.

Create New User

Access Permissions

Dashboard / Form Can start new trips and view dashboard
Open Trips Can view active trips
Edit Trips Can modify existing trip details
Close Trips Can settle and close trips
Reports & Records Can view financial reports and historical trips
Export Reports Can download CSV and PDF files
Master Data Can view Vehicles, Drivers, etc.
Add New Data Can create new master records
Edit Data Can modify existing master records
Delete Data Can permanently delete master records
Activity Logs Can view the system audit logs