RideYourWay
Data Updates
What are you updating?
Budget Update
The monthly close. Master file plus a new QuickBooks YTD Profit & Loss — walks you through categorizing the latest month and writes an updated master.
Update Fleet Data
Latest Fleetio exports — vehicle roster and service history. Refreshes odometers, lifecycle pace and cost per mile.
Replace Master File
Load a master .xlsx straight in, no categorization steps. Use this to correct or roll back what the dashboard is reading.
Workbooks are parsed in your browser.
RideYourWay
Budget Data Update
RideYourWay
Edit Financing Schedule
Add, edit or remove loans, leases and subordinated debt. Changes apply to the dashboard and can be exported to the master.
Edit Normalization Methods
Choose how each cost category is smoothed for the Normalized view and daily-rate calculations.
Update Fleet Data
Upload your latest Fleetio exports. Re-uploading replaces the roster (new vehicles appear, retired ones drop) and refreshes odometer + service history.
1 · Vehicle Roster
not loadedUpload Fleetio vehicle export
Vehicle number, make, model, year, status, current odometer
2 · Service History
not loadedUpload Fleetio service history export
Every service, classified Preventative/Repair via labels, with cost
Maintenance Standard — Methodology & Sources
Where the per-vehicle lifecycle maintenance standard comes from, and how it compares to published benchmarks.
Edit Maintenance Bands
The lifecycle cost standard — expected preventative & repair cost per 1,000 miles in each mileage band.
Month — Assumptions
Set this month's revenue and any rate overrides. Blank fields inherit the global defaults.
Projection Assumptions
The drivers behind the budget projection. Category per-leg rates are set in the table.
How this is calculated
—
Vehicle Details
Status drives capacity: only Active vehicles count toward utilization and fleet sizing. Loss payee is prefilled from the financing lender — correct any that differ on your policy.
VehicleStatusFinancingLoss Payee
Status changes effective
Earlier months keep the status they had — history is never rewritten.
Remember to export the master afterwards — edits live in the browser until you do.
Operating Volumes by Month
Completed Kent legs and total vehicle operating hours — the denominators for the $/Leg and $/Hour views.
MonthKent LegsOperating Hours
Monthly Trip Counts
Total completed trips per month — drives the per-trip unit economics.
Vehicle Detail
Full maintenance history and cumulative spend vs. standard.
Rate change
Person
Insurance Amortization Schedule
Declare the annual premium once per policy year; add prorated new-vehicle payments as they occur. Each row spreads evenly across its policy window and persists across sessions.
RYW Budget Command
No data loaded — open Data Updates to load a master file
2026 Budget — P&L Waterfall
Actuals from QuickBooks · Click any month header to deep-dive
YTD Revenue
—
—
Gross Margin (YTD)
—
After all COGS
Net Operating Income (YTD)
—
—
Operating Volume — by Month
denominators for $/Kent Leg & $/Hour views
Cost Waterfall — Normalized
Dollar view
3 items need review
◆ normalized
◇ has rule
Ratio vs standard:
●≤1.0x
●1.0–1.1x
●1.1–1.2x
●>1.2x
Daily Fixed Cost Rates
monthly total ÷ 21.58 working days
Save your work
Export the updated master file after any changes — this becomes your source of truth for next session
Analysis
Most recent complete month · Trends, rolling averages, and standard performance
—
—
Daily Direct Fixed COGS
—
—
Daily Fixed Operational OH
—
—
Daily Fixed Corporate OH
—
—
These three daily rates feed the intelligence dashboard's daily & weekly margin math. Each = that layer's monthly total ÷ 21.58 working days (a flat constant = 259 weekdays ÷ 12, so daily rates aren't distorted by calendar-day count). Fuel & driver wages are handled separately from live operational data.
Publishing always sends the normalized basis, whichever basis the cards above are showing — actuals are lumpy for invoice-timing reasons and can't be fairly matched against a day of trips. The current incomplete month carries the previous closed month's rates until its own numbers land.
Publishing always sends the normalized basis, whichever basis the cards above are showing — actuals are lumpy for invoice-timing reasons and can't be fairly matched against a day of trips. The current incomplete month carries the previous closed month's rates until its own numbers land.
Executive Summary
—
Revenue
—
—
Gross Margin
—
—
Net Operating Income
—
—
Operating Margin
—
—
Total OpEx
—
—
Revenue / Kent Leg
—
—
Latest complete month, with the month-over-month change and the series behind it. Each sparkline is on its own scale so its movement is visible; green marks a favorable move. Profit measures are colored by sign — a dashed baseline marks zero where the series crosses it.
Revenue → Net Income Bridge
how revenue becomes profit
Each bar steps down from revenue through the cost layers to net operating income, and each cost bar is split against its standard: the blue portion is what the standards say this month's volume and revenue should have cost, red is the excess on top. Grey is spend with no standard behind it — Operational and Corporate Overhead have none yet, and Direct Fixed COGS is benchmarked only on insurance, R&M and dispatch pay. Hover a bar for the breakdown.
Unit Economics — Per Kent Leg
Cost per Kent Leg
—
—
Revenue per Kent Leg
—
—
Contribution per Kent Leg
—
—
Kent Legs per Vehicle
—
—
Driven by completed Kent legs — the same volume unit used across the Standards tab and Budget Projection. Cost/Leg = fully-loaded total cost (COGS + operational + corporate overhead) ÷ legs; Contribution = revenue/leg − cost/leg. Legs per Vehicle uses Active capacity vehicles only.
Daily Cost Rate Trend
$ per working day · each panel on its own scale
Each layer is charted separately so its own movement is visible — on a single shared axis these three sit at very different levels and every line reads as flat. Panels are not directly comparable in height; the axis range is printed on each. Hover any panel for the month's figure.
Expense Analysis — —
—
| Expense Category | This Month | % of Rev | vs Prior Mo | 3-Mo Avg | vs 3-Mo Avg % | vs Standard |
|---|
Time Card Audit
iSolved clock punches vs Route Genie & Samsara shift timestamps · run before each bi-weekly payroll
Audit rules
Load iSolved Time Card Report
Drop the Time Card Report PDF here or click to choose
iSolved → Reports → Time Card Report → PDF · one file per pay period · nothing leaves your browser except the parsed hours, which are saved to Ryder for the audit
Route Genie punches — backfill
Drop the Mileage & Road Time export here or click to choose
Route Genie → Reports → Mileage & Road Time, any date range, with the Actual Start / Finish columns. Fills in punches for days the daily Intelligence upload did not have them (and any day the feed no longer reaches). Intelligence itself is not touched — do not re-upload there.
Driver Roster
Hourly rates and raise history · what Intelligence prices each shift at · published to Ryder on every save
Standards & Ratio Engine
Where every managed cost stands against what we said it should be
Standards Score ⓘ
—
—
On target
—
within 5% of standard
Watch
—
5–20% over, or short of a pay target
Over standard
—
more than 20% over
Standards Tracker
—
| Cost Category | Standard | YTD | This Quarter | Current | Status |
|---|
Cost Normalization Methods
Drives the Normalized view & daily rates
Each category can be smoothed differently for the Normalized view. Actual = real cash as booked ·
Annual Spread = known annual amount ÷ 12 · Rolling Avg = trailing N-month average ·
Annualize YTD = year-to-date ÷ months elapsed. Categories not listed use Actual.
| Cost Category | Method | Parameter | Notes |
|---|
Vehicle Financing
Loans, leases & sub-debt · Monthly obligations · Term expiry tracking · From Vehicle Payment Schedules
Total Monthly Obligation
—
Loans + Leases + Sub-debt
Total Outstanding Debt
—
Current balances owed
Total Loan Payments
—
Total Lease Payments
—
Expiring ≤ 12 Months
—
Obligations ending soon
Loans
Per your payment schedule
| Note | Description | Vehicles | APR | Monthly Payment | Term Start | Term End | Payments Left | Interest Remaining | Balance Owed | Status |
|---|
With an APR set on the Financing sheet, the loan amortizes: payments left, interest remaining and the balance all come from the schedule rather than the stated term. Two structures are handled and auto-detected from whether QuickBooks books the same principal every month — constant principal (the Mercantile Commercial Term Variable notes) holds principal fixed and lets the payment decline, so the payoff comes from balance ÷ principal and the stated maturity is an outside date; fixed payment (GM, Mitsubishi, Toyota) holds the payment constant and derives the payoff from the balance. Balances are rolled forward from their Balance As Of date, so a stale figure is corrected rather than trusted. Notes are grouped by lender, and a group billed on one combined statement says so.
Leases
| Lessor | Vehicles Covered | Monthly Payment | Term Start | Term End | Months Remaining | Balance Owed | Status |
|---|
Subordinated Debt
| Lender / Note | Vehicles Covered | Monthly Payment | Term Start | Term End | Months Remaining | Balance Owed | Status |
|---|
Matured / Paid Off
No longer active
| Lender / Note | Vehicles Covered | Type | Term End | Status |
|---|
Owned Vehicles (No Payment)
Fleet Lifecycle
Vehicle maintenance amortization · 250k-mile / 5-year life · 50k bands · actual vs. expected pace
Lifetime Performance
Maintenance Cost per Mile — Actual vs. Industry
Total Cost / Mile
—
vs Fleetio $0.20
—
Preventative / Mile
—
—
Repair / Mile
—
—
Preventative : Repair Mix
—
higher preventative = proactive
Fleet Overview
Active Vehicles
—
Avg Life Used
—
of 250k miles
Expected Maint. / Month
—
budget pace
Fleet Over/Under Expected
—
lifetime actual vs expected
Vehicles Beating Goal
—
20% under standard
Current Quarter
—
—
—
Quarter-to-Date Total
—
—
Expected by Now
—
month-bucket pace
Available This Quarter
—
of full-quarter budget
Available This Month
—
vs. one month of pace
Preventative — This Quarter
—
of expected pace
—
left to spend this quarter
—
Repair — This Quarter
—
of expected pace
—
left to spend this quarter
—
Vehicle Lifecycle Tracker
Expected = sum of band rates across the miles driven during our ownership (from each vehicle's acquisition baseline, not from 0 — so used vehicles aren't charged for miles the prior owner put on them). Over/Under compares lifetime actual spend to that ownership-window expected. Click a column header to sort. B1–B5 = mileage band (year of life). ▸ marks vehicles bought used (hover for the acquisition mileage and ownership window).
Lifecycle Cost Curve — Vehicles vs. Standard
Standard curve
Goal (20% under)
Under goal
Under standard
Over standard
Bought used
Each dot is a vehicle at its current mileage. A dot on the line spent exactly to standard; above = over, below = under. Used vehicles (hollow) start partway up the curve at their acquisition point, so they're judged only on miles we've owned them. Hover any dot for detail.
Budget Projection
Actual vs. projected P&L by month. Set each month's revenue → projected Kent legs → per-leg cost projections.
Projected Revenue (FY)
—
sum of monthly targets
Projected Kent Legs (FY)
—
revenue ÷ rev/leg
Projected Cost (FY)
—
all categories
Projected NOI (FY)
—
revenue − cost
Actual vs. Projected — Monthly P&L
click a month's assumption button to set revenue & rates
drag the table left/right to move month to month
Three columns per month: Act (what happened, from your P&L) · Std (what costs should have been at the revenue you actually earned — revenue ÷ rev-per-leg → standards) · Bud (the original plan you set). Act vs. Std shows cost control at the volume you ran; Std vs. Bud isolates the revenue miss/beat; Act vs. Bud is total plan variance.
Staff Roster
Compensation bands · Payroll reconciliation · Department allocation · Click any person for rate history
Payroll Reconciliation
Estimates pending roster confirmation—
QB Total Wages
—
Identified Staff
—
Dispatch Labor
—
Driver Pay (remainder)
Leadership / C-Suite — vs standard
—Misc Middle Management — vs standard
—Pre-Assign / Scheduling — vs standard
—Dispatch Labor — vs standard
—People Cost — roll-up · excludes driver wages
—Staff Roster
Showing current rates · Click a row for history| Name | Role | Department | Waterfall Layer | Current Monthly | Band | Status |
|---|
Soft Cap Schedule
Pay ceilings by role, stepping on revenue milestones · Click any seat to set its steps
Seats under a soft cap