Yl International Group Inc

Sign in with Supabase to save trips, mileage, fuel, and documents online.

Yl International Group Inc Truck Operations

Record each load or completed trip in one place: dispatch details, IFTA mileage, fuel, cost control, invoice status, and profitability. The dashboard turns saved records into operating KPIs, exception checks, and trend analysis.

1) Trip / Load Record

Core trip details used by dispatch, accounting, IFTA, and management reporting.
Images will be compressed before saving. PDF files are recorded by name until cloud upload is connected.

2) IFTA Mileage by State

Enter each jurisdiction once. This supports IFTA review and odometer reconciliation.
#StateMilesAction

3) Fuel Purchases

One row per fuel stop. Amount is the receipt total; leave it blank to calculate gallons x price/gal.
#DateStateGallonsPrice/GalAmount $Action

Operating Scorecard

Instant profitability, fuel, utilization, and exception checks before saving to dashboard.
Income
$0.00
Gross - Commission
Net Profit
$0.00
Income - Salary - Fuel - Other
Revenue / Mile
$0.00
Gross revenue / total miles
All-in Cost / Mile
$0.00
Fuel + pay + accessorial costs
Mileage Total
0
From mileage rows
Fuel Cost
$0.00
From fuel rows
Fuel Gallons
0.000
From fuel rows
MPG
0.00
Mileage / Fuel gallons
Fuel Cost / Mile
$0.00
Fuel cost / Mileage
Profit / Mile
$0.00
Net profit / Mileage
Deadhead %
0.0%
Empty miles / total miles
Maintenance Reserve
$0.00
Miles x reserve rate
Miles Check
CHECK
Odometer Difference
0
Trip Margin
0.0%
Formula used: Commission = Gross × Commission Rate, Income = Gross + Detention - Commission, Net Profit = Income - Driver Pay - Fuel - Accessorial Costs - Maintenance Reserve.

Historical Baseline

Existing checked records loaded into the dashboard database. Use them as a baseline while adding more Yl International Group Inc trips.
TripTruckMilesFuelIncomeProfit

Dashboard Summary

All completed trips saved in this browser will appear here automatically.
Filters
0 trips loaded

Analysis Logic

The dashboard now judges each trip with four checks: company history, market benchmark, route economics, and fuel buying quality.

1) Was the load worth taking?

Compare profit per mile, gross revenue per mile, margin, and break-even cost. A trip is strong when it beats your own average and stays above the market cost benchmark.

2) Compare with Yl history

Each trip is compared against the saved company average. If revenue per mile or profit per mile is below your own baseline, the dashboard marks it for rate review.

3) Compare with market

Use public references as guardrails: DAT spot rate by equipment type for revenue, ATRI operating cost per mile for cost pressure, and EIA diesel prices for fuel sanity checks.

4) Route and fuel review

Route quality checks mileage mismatch, unusual detours, low MPG, expensive fuel states, and fuel stops above the trip's own average price per gallon.

Trip Analysis

Per-trip decision support based on the Excel data and saved records.
All Saved Trips
Completed trips cannot be deleted. Corrections must be made from the detail page and will be recorded in the audit log.
Deletion only affects this browser's saved dashboard data.

Completed Trip Detail

Read-only completed trip record.
This completed record is read-only. Any correction must be recorded in the audit log.

Correction / Audit

Use this only when a completed record must be corrected. Every change records who changed it, when, which field changed, and the before/after values.