Business Overview — 2024
Loading…Monthly Expense Trend
Fuel
Toll
Others
Expense Breakdown
Fuel · Toll · Parking Monthly Comparison
Fuel
Toll
Parking
Expense Register
All Expenses
| # | Date | Category | Vehicle | Description | Mode | Amount (₹) | Status |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
–
Cab-wise Purchase Sheet — 2024
Vehicle-wise Expense Summary
| Vehicle No. | Type | Make / Model | Fuel (₹) | Toll (₹) | Parking (₹) | Penalty (₹) | Petty Cash (₹) | Maint. (₹) | Total (₹) | Trips | Km | Cost/Trip |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||||
Cab-wise Total Expense
Trip Summary Report
All Trips
| # | Date | Vehicle | Driver | Route | Dist (km) | Fuel (₹) | Toll (₹) | Status |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
–
Upload Excel / CSV Files
0 of 10 files selected
ℹ️ Upload up to 10 files (.xlsx · .xls · .csv). Every file is previewed before upload — you'll see its real headers and sample rows so you can confirm it's the right one. Files can be a trip log (driver, cab, pickup/drop) or an expense sheet (fuel, toll, parking, petty cash) — tag each one so the system knows what it's looking at.
Files stored in database
| # | File Name | Type | Sheet | Rows | Cols | Status | Uploaded | |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Compare & Match Files — Report Builder
ℹ️ Pick the trip log as File A and the expense sheet as File B once uploaded. Choose a match column for each — usually Cab No, Driver Name, or Trip ID. The report panel on the right is a live pivot table: drag any column into Rows / Columns / Values and it recalculates instantly. Adding new columns to your source file (after re-upload) automatically makes them available here too.
Select File A to start — File B is optional and only needed to bring in cost data.
📊 Status Breakdown
❌ Cancellation Report
⏱ Time & Distance
🧩 Available Fields
Drag a field into a drop zone on the right →
Rows
Columns
Values
Quick layouts:
Pivot Report
Build a report above, then drag fields into Rows / Columns / Values to pivot.