📘
🚗 Vehicle Cost-Per-Mile Workbook — Instruction Manual
Instruction Manual · How to use this template
This premium Google Sheets workbook gives fleet owners, small-business operators, and multi-vehicle households a single place to log every vehicle expense and instantly see cost-per-mile, efficiency rankings, and annual spending projections. Simply enter each fuel fill-up, service visit, or repair into the Expense Log; every other number—per-mile costs, running totals, budget flags, and forecasts—calculates itself automatically. The workflow is: log expenses on the Expense Log, review per-vehicle rankings on Cost Rankings, then monitor fleet-wide trends and forecasts on the Dashboard.
⚡ Quick start
1Step 1 — Open the workbook and read the 'Read Me' sheet for a quick orientation and color-key explanation.
2Step 2 — Go to the 🚗 Expense Log sheet. In the Vehicle side-table (right section), type each vehicle's name, current odometer reading, condition, and last service date so the formulas have baseline data.
3Step 3 — Start logging expenses: fill in Date, Vehicle (must match a name in the side-table exactly), Category (e.g. Fuel, Maintenance, Insurance), Amount, Miles driven since last entry for that vehicle, Paid method, and an optional Note. All ƒ columns will populate instantly.
4Step 4 — Check the 🏆 Cost Rankings sheet to see which vehicles cost the most per mile, their cost mix, and efficiency scores — no input needed, it pulls from the Expense Log automatically.
5Step 5 — Open the 📊 Dashboard to review monthly trends, year-to-date spend curves, forecasts, and budget flags. Everything here is auto-computed from your Expense Log data.
6Step 6 — Use the ✨ AI side-panel (see the assistant section) to ask questions like 'which vehicle should I replace first?' or 'explain this cell' for instant insight.
This is the primary data-entry sheet and the engine of the entire workbook. Every fuel purchase, maintenance bill, insurance payment, registration fee, and miscellaneous vehicle cost gets logged here row by row. Three side-tables let you track each vehicle's status, schedule upcoming services, and the six KPI cards plus six charts give you an instant visual snapshot. Every other sheet in the workbook pulls its data from this one.
✍️ Step by step
11. Start with the Vehicle side-table (right section): type each vehicle's name in the Vehicle column, its current Odometer reading, Condition (e.g. Excellent, Good, Fair, Poor), and the date of its Last Svc (last service). These baseline entries power the per-vehicle formulas across the workbook.
22. In the main expense table (left section), enter a new row for every expense: type the Date (MM/DD/YYYY), select or type the Vehicle name (must exactly match a name in the Vehicle side-table), choose a Category (Fuel, Maintenance, Insurance, Registration, Tires, Tolls, etc.), enter the dollar Amount, and enter Miles driven since the previous entry for that vehicle.
33. Fill in the Paid column with the payment method (e.g. Credit Card, Cash, Fleet Card) and optionally add a Note (e.g. 'synthetic oil change at 60k').
44. All seven ƒ columns to the right auto-calculate: $/Mile for that single transaction, Veh $/Mi (vehicle lifetime per-mile cost), Running $ (cumulative spend), % of Veh (what percentage of that vehicle's total this transaction represents), Run $/Mi (running per-mile rate), and vs Cat Avg (how this transaction compares to the category average).
55. In the Vehicle side-table, review the auto-computed columns: Days Ago (since last service), Alert (flags overdue service), Log Mi (total logged miles), # Txns (transaction count), Annual Est (projected annual cost), Energy/Mi (fuel or energy cost per mile), Maint % (maintenance as a share of total cost), Priority (overall attention ranking), and $/Mile (overall per-mile cost for that vehicle).
66. Use the Service Schedule side-table to enter upcoming Service descriptions, Due Dates, Status (Scheduled, Complete, Overdue), Est Cost, and Shop name. The ƒ columns Due In (days until due), Urgency (color-coded priority), $/Mile (service cost per mile), and Visits/Yr (annualized visit frequency) calculate automatically.
77. Review the six KPI cards at the top — Amount, Miles, $/Mile, Veh $/Mi, Running $, % of Veh — for a quick numeric summary.
88. Study the six charts: Vehicle Priority (which vehicles need attention first), Upcoming Service Costs (budget for near-term services), Spend by Vehicle (total dollars per vehicle), Spend by Category (fuel vs. maintenance vs. insurance breakdown), Running Spend & $/Mi (cumulative trend lines), and Energy Cost/Mile (fuel or charging efficiency over time).
99. Keep entering expenses chronologically; the formulas and charts update in real time with every new row.
📋 Column-by-column
| Date | INPUT — Type the date of the expense in MM/DD/YYYY format (or your locale's date format). Example: 06/15/2026. This anchors the transaction in the timeline used by the Dashboard's monthly roll-ups. |
| Vehicle | INPUT — Type or select the vehicle's name exactly as it appears in the Vehicle side-table (e.g. '2022 F-150' or 'Van #3'). Spelling must match precisely or the per-vehicle formulas will not pick up this row. |
| Category | INPUT — The type of expense. Use consistent categories such as Fuel, Maintenance, Insurance, Registration, Tires, Tolls, Parking, or Repairs. Consistent naming ensures the Spend by Category chart and the vs Cat Avg formula group costs correctly. |
| Amount | INPUT — The dollar amount of the expense. Type the number without a dollar sign (e.g. 87.50). This is the raw cost that feeds every downstream calculation including $/Mile, Running $, and the Dashboard totals. |
| Miles | INPUT — The number of miles driven since the previous entry for this same vehicle. For a fuel fill-up this is typically the trip-odometer reading; for other expenses, estimate miles since the last log. Example: 342. This value is the denominator in the $/Mile calculation. |
| Paid | INPUT — Payment method used: Credit Card, Debit, Cash, Fleet Card, Reimbursed, etc. Useful for reconciling statements and filtering by payment type. |
| Note | INPUT — Optional free-text field for context. Examples: 'Premium unleaded', 'Replaced front brake pads', '60k-mile scheduled service'. Helps when reviewing old transactions. |
| ƒ$/Mile | AUTO-COMPUTED — Cost Per Mile for this single transaction. Formula in words: Amount ÷ Miles. Tells you how expensive this particular expense was on a per-mile basis. A fuel fill-up might show $0.12–$0.20/mile; a large repair could spike to $1.00+ per mile. Lower is better. Compare across rows to spot unusually expensive transactions. |
| ƒVeh $/Mi | AUTO-COMPUTED — Vehicle Cost Per Mile (cumulative). This is the overall cost per mile for this vehicle across all logged transactions to date. Formula: sum of all Amounts for this vehicle ÷ sum of all Miles for this vehicle. A typical passenger car runs $0.30–$0.60/mile all-in; commercial trucks may be higher. A rising trend means the vehicle is getting more expensive to operate. |
| ƒRunning $ | AUTO-COMPUTED — Running Total in dollars. This is the cumulative sum of all expenses up to and including this row, across the entire fleet. Formula: sum of Amount from the first row through the current row. Use it to see how quickly your total fleet spend is climbing. |
| ƒ% of Veh | AUTO-COMPUTED — Percentage of Vehicle Total. Shows what share of that vehicle's total lifetime spend this single transaction represents. Formula: this row's Amount ÷ sum of all Amounts for this vehicle, displayed as a percentage. A single transaction above 20–30% of the vehicle total suggests a major repair event worth investigating. |
| ƒRun $/Mi | AUTO-COMPUTED — Running Cost Per Mile. The fleet-wide cumulative cost per mile up to this row. Formula: Running $ ÷ cumulative Miles. Track this over time; a steady or declining trend is healthy, while a rising trend signals growing inefficiency. |
| ƒvs Cat Avg | AUTO-COMPUTED — Versus Category Average. Compares this transaction's $/Mile to the average $/Mile for all transactions in the same Category. A positive value (or above 100%) means this transaction was more expensive per mile than the category norm; negative (or below 100%) means cheaper. Use it to flag outlier expenses — e.g., a fuel fill-up that cost far more per mile than your average fuel cost. |
| Vehicle (side-table) | INPUT — The name or identifier for each vehicle in your fleet. Examples: '2022 F-150', 'Sprinter Van', 'Tesla Model 3'. Must match the Vehicle column in the main expense table exactly. |
| Odometer | INPUT — Current odometer reading in miles. Update this periodically (e.g. monthly) so the formulas can estimate total miles accurately. Example: 47520. |
| Condition | INPUT — A qualitative assessment of the vehicle's current state. Use Excellent, Good, Fair, or Poor. This feeds into the Priority ranking formula. |
| Last Svc | INPUT — Date of the most recent service or maintenance visit, in MM/DD/YYYY format. Example: 03/10/2026. The Days Ago and Alert columns use this date. |
| ƒDays Ago | AUTO-COMPUTED — Days Since Last Service. Formula: today's date minus Last Svc date. Shows how many calendar days have elapsed since the vehicle was last serviced. Under 90 days is typically fine; 90–180 days may warrant attention; over 180 days triggers a visual alert. |
| ƒAlert | AUTO-COMPUTED — Service Alert flag. Displays a warning (e.g. '⚠️ Overdue') when Days Ago exceeds a threshold (commonly 90 or 180 days). If blank or shows a green indicator, the vehicle's service is current. Act on any alert promptly to avoid costly breakdowns. |
| ƒLog Mi | AUTO-COMPUTED — Logged Miles. The total miles recorded in the expense log for this vehicle. Formula: sum of all Miles entries where Vehicle matches this row. Compare to the Odometer reading to see if you are capturing most of the vehicle's driving. |
| ƒ# Txns | AUTO-COMPUTED — Number of Transactions. A count of all expense rows logged for this vehicle. Formula: COUNTIFS on the Vehicle column. More transactions generally mean more complete data and more reliable per-mile averages. |
| ƒAnnual Est | AUTO-COMPUTED — Annual Cost Estimate. Projects the vehicle's yearly spending based on its current run rate. Formula: (total Amount for this vehicle ÷ number of days since first transaction for this vehicle) × 365. Use this to budget; compare it against your annual vehicle budget to catch overruns early. |
| ƒEnergy/Mi | AUTO-COMPUTED — Energy Cost Per Mile. Isolates fuel or electricity costs per mile by summing only Fuel/Energy category amounts and dividing by total miles. Formula: sum of Fuel-category Amounts for this vehicle ÷ total Miles for this vehicle. A typical gasoline vehicle runs $0.10–$0.18/mile for fuel; EVs may be $0.03–$0.06/mile. Rising values suggest worsening fuel economy or higher fuel prices. |
| ƒMaint % | AUTO-COMPUTED — Maintenance Percentage. The share of this vehicle's total spending that goes to maintenance and repairs. Formula: sum of Maintenance/Repair-category Amounts ÷ total Amount for this vehicle, as a percentage. Under 30% is typical for newer vehicles; above 50% on an older vehicle may signal it is time to consider replacement. |
| ƒPriority | AUTO-COMPUTED — Vehicle Priority Score. A composite ranking that factors in $/Mile, Maint %, Days Ago since service, and Condition to flag which vehicle in your fleet needs attention most urgently. Higher priority (or rank #1) means this vehicle has the worst combination of high cost, overdue service, and poor condition. Review the top-priority vehicle first when planning maintenance or replacement. |
| ƒ$/Mile (side-table) | AUTO-COMPUTED — Overall Cost Per Mile for this vehicle, identical in meaning to Veh $/Mi in the main table but displayed in the vehicle summary for quick scanning. Formula: total Amount for this vehicle ÷ total Miles for this vehicle. |
| Vehicle (service table) | INPUT — The vehicle name this upcoming service applies to. Must match the vehicle side-table and main log exactly. |
| Service | INPUT — Description of the upcoming or scheduled service. Examples: 'Oil Change', 'Tire Rotation', 'Brake Inspection', '100k-Mile Service'. |
| Due Date | INPUT — The date by which this service should be completed, in MM/DD/YYYY format. Example: 08/01/2026. |
| ƒDue In | AUTO-COMPUTED — Due In (days). The number of calendar days remaining until the Due Date. Formula: Due Date minus today's date. Negative values mean the service is overdue. Zero or negative values should be acted on immediately. |
| ƒUrgency | AUTO-COMPUTED — Urgency Level. A color-coded or text label (e.g. Overdue, Due Soon, Upcoming, On Track) based on how many days remain. Overdue and Due Soon items appear prominently in the Upcoming Service Costs chart. |
| Status | INPUT — Current status of this service item. Type Scheduled, In Progress, Complete, or Overdue. Marking a service Complete removes it from urgency alerts. |
| Est Cost | INPUT — Estimated dollar cost of the service. Example: 150. This feeds the Upcoming Service Costs chart so you can forecast near-term maintenance spending. |
| Shop | INPUT — The name or location of the service provider. Examples: 'Jiffy Lube #412', 'Dealer Service Dept', 'Mobile Mechanic'. Useful for tracking vendor history. |
| ƒ$/Mile (service table) | AUTO-COMPUTED — Service Cost Per Mile. The estimated cost of this service divided by the vehicle's total logged miles. Formula: Est Cost ÷ Log Mi for the matching vehicle. Helps you understand how much each service event adds to the vehicle's overall per-mile cost. |
| ƒVisits/Yr | AUTO-COMPUTED — Visits Per Year. The annualized frequency of service visits for this vehicle. Formula: count of service entries for this vehicle ÷ time span in years since the earliest service entry. A passenger car typically averages 3–6 visits per year; significantly higher may indicate reliability problems. |
📊 Reading the numbers
• KPI card 'Amount' shows total dollars spent across all vehicles and all categories — compare it to your fleet budget to gauge overall spend health.
• KPI card 'Miles' shows total miles logged fleet-wide; if this seems low relative to your odometers, you may be missing entries.
• KPI card '$/Mile' is the fleet-wide cost per mile — the single most important number. Typical fleets range $0.30–$0.70/mile all-in; anything above $1.00/mile warrants investigation.
• The 'Vehicle Priority' chart ranks vehicles from most to least urgent based on the composite Priority score — act on the top bar first.
• The 'Running Spend & $/Mi' chart overlays cumulative dollars (left axis) with running $/mile (right axis); a flattening $/mile line means your fleet is stabilizing, while an upward curve signals growing costs.
⚠️ Avoid these mistakes
• Misspelling a vehicle name so it does not match the side-table — the row's per-vehicle formulas will return errors or zeros.
• Leaving the Miles column blank — this makes $/Mile divide by zero and corrupts downstream averages.
• Overwriting a ƒ (formula) column with a typed value — this breaks the auto-calculations; use Ctrl+Z immediately if you accidentally do this.
• Using inconsistent Category names (e.g. 'Gas' sometimes and 'Fuel' other times) — this splits what should be one category into two and skews the Spend by Category chart.
💡 Tips• Sort or filter by Vehicle to quickly review one vehicle's history without affecting formulas.
• Use the vs Cat Avg column to find outlier transactions — if a fuel fill-up is 50% above the category average, investigate (wrong fuel grade? price spike? data-entry error?).
• Update the Odometer in the vehicle side-table at least monthly so Annual Est and Energy/Mi stay accurate.
• Enter services in the service schedule table before they happen so you can see upcoming costs in the chart and plan cash flow.
This sheet is a read-only leaderboard that automatically ranks every vehicle in your fleet by cost efficiency. Use it to compare vehicles side by side, identify your most and least expensive assets, and decide where to cut spending or which vehicle to replace. All data is pulled from the Expense Log via SUMIFS, FILTER, and COUNTIFS — you never need to type anything here.
✍️ Step by step
11. Navigate to this sheet after you have logged at least a few expenses on the Expense Log — the rankings need data to populate.
22. Review the six KPI cards at the top for fleet-wide benchmarks: Best $/Mi (your most efficient vehicle), P75 $/Mi (the 75th-percentile cost — three-quarters of your fleet is at or below this), Avg TCO/Mo (average Total Cost of Ownership per month across the fleet), Total (total dollars spent), Miles (total miles logged), and $/Mile (fleet-wide average).
33. Study the 'Cost Per Mile Ranking' chart — vehicles are sorted from lowest (best) to highest (worst) cost per mile. The leftmost bar is your most efficient vehicle.
44. Check the 'Cost Mix by Vehicle' chart to see how each vehicle's spending breaks down by category (fuel vs. maintenance vs. insurance, etc.). A vehicle dominated by maintenance costs may be aging out.
55. Use the 'Fleet Spend by Category' chart for a fleet-wide view of where money goes — if fuel dominates, route optimization or fuel cards may help; if maintenance dominates, review vehicle ages and service intervals.
66. Review the 'Efficiency Score' chart which provides a composite score factoring in $/Mile, maintenance share, and usage — higher scores mean more cost-effective vehicles.
77. The 'Per-Mile by Category' chart breaks down the per-mile cost into category layers for each vehicle, letting you pinpoint exactly which cost type is dragging a vehicle's efficiency down.
88. The 'Volatility by Vehicle' chart shows how much each vehicle's per-mile cost fluctuates month to month — high volatility means unpredictable costs (often a sign of sporadic major repairs).
📊 Reading the numbers
• KPI 'Best $/Mi' shows your fleet champion — the vehicle costing the least per mile. Compare other vehicles to this benchmark to see how much room for improvement exists.
• KPI 'P75 $/Mi' (75th Percentile Cost Per Mile) means 75% of your vehicles cost this amount or less per mile. If the gap between Best $/Mi and P75 is large, one or two vehicles are dragging the fleet average up.
• KPI 'Avg TCO/Mo' (Average Total Cost of Ownership Per Month) is the fleet's average monthly all-in spend per vehicle. Multiply by 12 for an annual per-vehicle budget estimate. Under $500/month per passenger car is reasonable; commercial vehicles vary widely.
• The 'Volatility by Vehicle' chart flags unpredictable vehicles — tall bars mean wild cost swings. Consider setting aside a larger reserve for high-volatility vehicles or scheduling preventive maintenance to smooth costs.
• If a vehicle's 'Efficiency Score' is significantly below the fleet average, it may be more cost-effective to replace it than to continue maintaining it.
⚠️ Avoid these mistakes
• Trying to type data into this sheet — it is entirely formula-driven. Any manual entry will overwrite formulas and break the rankings.
• Ignoring this sheet and only looking at the Expense Log — the Rankings reveal fleet-wide patterns (like one vehicle costing 3× more per mile) that are hard to spot row by row.
• Comparing vehicles with vastly different numbers of logged transactions — a vehicle with only 2 entries will have a less reliable $/Mile than one with 50 entries. Check # Txns in the Expense Log side-table.
💡 Tips• Screenshot this sheet quarterly and share it with stakeholders — the charts make a compelling case for vehicle replacement or budget reallocation.
• Use the Per-Mile by Category chart to build a targeted cost-reduction plan: if fuel is the biggest per-mile component, investigate fuel efficiency improvements; if maintenance dominates, consider newer or more reliable vehicles.
• Compare P75 $/Mi against your fleet budget threshold — if P75 exceeds your target, more than a quarter of your fleet is over budget.
• Pair the Volatility chart with the Priority ranking on the Expense Log to prioritize which vehicles to address first.
The Dashboard is a month-by-month command center that auto-generates fleet-wide trends, forecasts, and budget alerts. It pulls from the Expense Log (via SUMIF, SUMIFS, and COUNTIF) and from Cost Rankings (via INDEX/MATCH) to give you a time-series view of your fleet's financial health. Use it for monthly reviews, annual budgeting, and spotting cost trends before they become problems. No data entry is needed here.
✍️ Step by step
11. Navigate to this sheet once you have at least one to two months of expense data logged — with only a few entries the trend lines and forecasts won't be meaningful yet.
22. Each row represents one calendar month. The Month column lists months chronologically; all other columns auto-calculate from your Expense Log data.
33. Review ƒSpend (total dollars spent that month) and ƒMiles (total miles logged that month) for the raw volume figures.
44. Check ƒ$/Mile (that month's cost per mile) and compare it to the ƒ3M Avg (three-month moving average) to see if costs are trending up or down. A single-month spike might be a one-time repair, but if $/Mile exceeds the 3M Avg for two or more consecutive months, costs are genuinely rising.
55. Read the ƒMoM % (Month-over-Month percentage change) to quantify how much spending changed versus the prior month. A value like +25% warrants investigation.
66. Look at ƒForecast for the AI-generated or formula-based projection of next month's spend based on recent trends. Compare it to your budget to anticipate overruns.
77. The ƒFlag column highlights months with anomalies — overspend warnings, unusual spikes, or missing data. Address any flagged month promptly.
88. Review YTD columns: ƒYTD $ (year-to-date cumulative spend) and ƒYTD $/Mi (year-to-date cost per mile) for the big-picture annual view.
99. Study the six charts to visualize trends: Fleet Cost Split (category breakdown over time), Actual vs Forecast (how well projections match reality), Energy vs Service (fuel costs vs. maintenance costs month by month), Monthly vs YTD $/Mi (short-term vs. long-term per-mile trends), YTD Spend Curve (cumulative spend trajectory), and $/Day Trend (daily cost rate by month).
📋 Column-by-column
| Month | AUTO-POPULATED — The calendar month label (e.g. Jan 2026, Feb 2026). Each row corresponds to one month. This column anchors the time series for all other columns and charts. |
| ƒSpend | AUTO-COMPUTED — Monthly Spend. The total dollar amount of all expenses logged in the Expense Log for this calendar month. Formula: SUMIFS on Amount where Date falls within this month. Compare month to month to spot seasonal patterns (e.g. higher fuel costs in summer, higher maintenance in winter). |
| ƒMiles | AUTO-COMPUTED — Monthly Miles. Total miles logged across all vehicles for this month. Formula: SUMIFS on Miles where Date falls within this month. If miles drop suddenly but spend stays flat, your per-mile cost is rising. |
| ƒ$/Mile | AUTO-COMPUTED — Monthly Cost Per Mile. This month's total spend divided by this month's total miles. Formula: ƒSpend ÷ ƒMiles. The most important monthly metric. A healthy fleet typically stays between $0.30 and $0.70/mile; spikes above $1.00/mile almost always trace back to a major repair or anomaly. |
| ƒMoM % | AUTO-COMPUTED — Month-over-Month Percentage Change in spend. Formula: (this month's Spend − prior month's Spend) ÷ prior month's Spend × 100. A positive value means spending increased; negative means it decreased. Swings beyond ±20% are worth investigating. |
| ƒ3M Avg | AUTO-COMPUTED — Three-Month Moving Average of $/Mile. Formula: average of $/Mile for the current month and the two preceding months. This smooths out one-time spikes and reveals the true cost trend. If the 3M Avg is steadily climbing, your fleet costs are structurally increasing and you should investigate root causes. |
| ƒForecast | AUTO-COMPUTED — Forecasted Spend for the upcoming month. Formula: typically based on the 3M Avg trend extrapolated forward (or a weighted moving average). Compare this number to your monthly budget — if the forecast exceeds budget, plan to defer non-critical services or find savings. |
| ƒFlag | AUTO-COMPUTED — Anomaly Flag. Displays a warning icon or text (e.g. '🔴 Over Budget', '⚠️ Spike') when the month's spend or $/Mile exceeds a threshold relative to the 3M Avg or a budget target. A blank or green flag means the month is within normal bounds. Always investigate flagged months. |
| ƒYTD $ | AUTO-COMPUTED — Year-to-Date Spend. The cumulative total of all fleet expenses from January through this month. Formula: running sum of ƒSpend from the first month of the year through the current row. Use it to track your annual budget consumption — if you have spent 60% of your annual budget by June, you are on pace. |
| ƒYTD $/Mi | AUTO-COMPUTED — Year-to-Date Cost Per Mile. The cumulative $/Mile from January through this month. Formula: YTD $ ÷ cumulative YTD Miles. This is a more stable metric than the monthly $/Mile because it smooths out month-to-month volatility. It should gradually converge toward your true annual per-mile cost. |
| ƒ# Txns | AUTO-COMPUTED — Monthly Transaction Count. The number of individual expense entries logged this month. Formula: COUNTIF on Date within this month. A sudden drop in transaction count may mean you forgot to log expenses, which would make other metrics unreliable for that month. |
| ƒ$/Day | AUTO-COMPUTED — Cost Per Day. This month's total spend divided by the number of days in the month. Formula: ƒSpend ÷ days in month. Useful for normalizing months of different lengths (28 vs. 31 days). A typical small fleet might run $15–$50/day; commercial fleets vary widely. The $/Day Trend chart plots this over time. |
📊 Reading the numbers
• KPI 'Total Spent' shows the grand total of all fleet expenses across all time — your lifetime fleet investment. Compare against asset values to assess total cost of ownership.
• KPI 'Fleet $/Mi' is the all-time fleet-wide cost per mile — the single number that answers 'how much does it cost to drive one mile across my whole fleet?'
• KPI 'Annual Est' (Annual Estimate) projects total fleet spending for the full year based on the current run rate. If this exceeds your annual budget, the Forecast and Flag columns will help you identify which months to cut.
• KPI 'Runway' estimates how many months of operation your current budget can sustain at the current spending rate. If Runway is shrinking month over month, costs are accelerating.
• The 'Actual vs Forecast' chart is your early-warning system: when actual spend bars consistently exceed the forecast line, your costs are outpacing expectations and corrective action is needed. When actuals fall below the forecast, you are trending better than expected.
⚠️ Avoid these mistakes
• Entering data on this sheet — every cell is a formula. Even typing into the Month column can break the time series.
• Drawing conclusions from only one or two months of data — the 3M Avg, Forecast, and YTD metrics need at least three months to stabilize.
• Ignoring the Flag column — it is specifically designed to catch the anomalies you might otherwise overlook in a wall of numbers.
• Not logging small expenses (parking, tolls) on the Expense Log — these omissions make Dashboard totals understate true costs and skew $/Mile downward.
💡 Tips• Review this sheet on the first business day of each month as part of a 'fleet health check' — a 5-minute habit that prevents surprises.
• If $/Mile is rising but Miles are flat, the problem is cost inflation (higher fuel prices or more repairs); if $/Mile is rising because Miles dropped, the issue may be underutilization — you are paying fixed costs (insurance, registration) over fewer miles.
• Use the YTD Spend Curve chart to visually compare this year's spend trajectory against a straight-line budget — if the curve bows upward, you are front-loading costs.
• Export or screenshot the Dashboard charts for monthly fleet reports to management or partners — they convey the story faster than raw numbers.
📖Glossary — what every value means
| $/Mile (Cost Per Mile) | Total dollars spent divided by total miles driven. This is the core metric of the workbook. It answers 'how much does each mile cost?' across a single transaction, a single vehicle, or the entire fleet. Lower is better. Typical ranges: $0.10–$0.20/mile for fuel alone; $0.30–$0.70/mile all-in for passenger vehicles; $0.80–$1.50+/mile for heavy commercial trucks. |
| Veh $/Mi (Vehicle Cost Per Mile) | The cumulative cost per mile for one specific vehicle across all of its logged transactions. Calculated as the sum of all Amounts for that vehicle divided by the sum of all Miles for that vehicle. Use it to compare vehicles against each other and against the fleet average. |
| Run $/Mi (Running Cost Per Mile) | The fleet-wide cumulative cost per mile calculated progressively as each new expense is logged. It is a running total of all dollars divided by all miles up to that row. A declining or flat trend is healthy; a rising trend indicates growing fleet costs. |
| TCO (Total Cost of Ownership) | The complete cost of owning and operating a vehicle, including fuel, maintenance, insurance, registration, depreciation, and all other expenses. In this workbook, Avg TCO/Mo on the Cost Rankings sheet divides the total spend per vehicle by the number of months of data to give an average monthly ownership cost. |
| MoM % (Month-over-Month Percentage Change) | The percentage increase or decrease in spending from one month to the next. Calculated as (current month Spend − prior month Spend) ÷ prior month Spend × 100. Positive means costs rose; negative means they fell. Changes beyond ±20% deserve investigation. |
| 3M Avg (Three-Month Moving Average) | The average of the cost-per-mile values for the current month and the two prior months. It smooths out one-time spikes or dips to reveal the underlying trend. If the 3M Avg is rising steadily, fleet costs are structurally increasing regardless of any single month's anomaly. |
| YTD (Year-to-Date) | A cumulative total from January 1 through the current month. YTD $ is the total dollars spent so far this year; YTD $/Mi is the cumulative cost per mile for the year. These metrics give a big-picture view and are less volatile than single-month figures. |
| P75 $/Mi (75th Percentile Cost Per Mile) | The per-mile cost at which 75% of your vehicles fall at or below. If P75 is much higher than the fleet average, it means a few expensive vehicles are pulling the average up. Vehicles above the P75 threshold are your least efficient and are prime candidates for cost reduction or replacement. |
| Annual Est (Annual Estimate) | A projected yearly cost for a vehicle or the fleet, extrapolated from the current spending rate. Formula: (total spend ÷ days of data) × 365. Compare this to your annual budget to determine if you are on track, under, or over budget. |
| Energy/Mi (Energy Cost Per Mile) | The per-mile cost of fuel or electricity only, excluding maintenance, insurance, and other categories. Calculated by summing only fuel or energy-category expenses and dividing by total miles. Useful for isolating fuel economy from other cost drivers. |
| Maint % (Maintenance Percentage) | The percentage of a vehicle's total spending that goes to maintenance and repair categories. Calculated as maintenance and repair dollars ÷ total dollars × 100. A Maint % above 40–50% on an older vehicle often signals it is approaching the point where replacement is more economical than continued repair. |
| vs Cat Avg (Versus Category Average) | A comparison of a single transaction's cost per mile against the average cost per mile for all transactions in that same category. A positive deviation means this transaction was more expensive than the norm for its category; negative means it was cheaper. Use this to quickly spot outlier expenses. |
| Runway | An estimate of how many months your fleet can continue operating at the current spend rate before exhausting a defined budget. Calculated as remaining budget ÷ average monthly spend. A shrinking Runway means costs are accelerating relative to budget. |
| $/Day (Cost Per Day) | The average daily fleet cost for a given month. Calculated as that month's total spend ÷ number of days in the month. Normalizes for months of different lengths (28 vs. 31 days) and provides an intuitive daily cost figure. Plotted in the $/Day Trend chart on the Dashboard. |
| Volatility | A measure of how much a vehicle's cost per mile fluctuates from month to month. High volatility means unpredictable costs (often caused by sporadic large repairs), while low volatility means stable, predictable expenses. Shown in the Volatility by Vehicle chart on Cost Rankings. |
| Efficiency Score | A composite metric on the Cost Rankings sheet that factors in a vehicle's cost per mile, maintenance percentage, and overall usage to produce a single efficiency rating. Higher scores indicate more cost-effective vehicles. Use this to quickly identify your best and worst performers. |
| Priority | A composite ranking on the Expense Log's vehicle side-table that combines cost per mile, maintenance share, days since last service, and condition to determine which vehicle needs attention most urgently. Rank #1 (or the highest score) is the vehicle you should address first. |
| Forecast | A forward-looking estimate of next month's fleet spend, auto-calculated on the Dashboard using recent trends (typically a weighted or three-month moving average projection). Compare the Forecast to your monthly budget to anticipate and prevent overruns. |
Every template ships with an AI side-panel. Type in plain language — it fills rows, explains any cell, and analyses your data for you.
How to use it
1To open the built-in ✨ AI assistant, click the sparkle icon in the side panel on the right side of your Google Sheets window. It is a chat-based assistant that understands your spreadsheet and responds in plain language.
2You can ask the assistant to explain any cell — for example, type 'explain B7' or 'what does the $/Mile column calculate?' and it will describe the formula and what the value means in context. You can also give it action commands like 'sum column C', 'fill the next row with sample data', or 'color row 1 gold' — it reads your sheet and executes changes without breaking existing formulas.
3The assistant includes one-click presets tailored specifically to this vehicle cost-per-mile template — these preset prompts are designed to surface the most useful insights for fleet expense tracking. Simply click a preset to run it instantly without typing.
4You can attach a screenshot or image (such as a fuel receipt or repair invoice) and the assistant will read and interpret it, helping you extract amounts or details to log into your Expense Log.
5Under the Tools tab, you will find 'Analyze All My Data,' which generates a comprehensive report on a new sheet covering your fleet's spending patterns, efficiency trends, and recommendations. The same tab offers Auto-Fit to resize columns for readability, Translate to convert every label into another language, and the ability to build a visual Infographic of your fleet data. You can also select a Tone (Friendly, Professional, or Concise) and apply Smart Styling to polish the workbook's appearance. Pro subscribers unlock native chart creation, advanced forecasting tools, and a full multi-page report feature.
6The AI assistant comes with free trial requests so you can explore its features immediately. After the trial, a subscription plan provides a larger monthly allowance of requests for continued use.