📘
🚗 Vehicle Cost-Per-Mile Workbook — Complete User Manual
Instruction Manual · How to use this template
The Vehicle Cost-Per-Mile Workbook is a professional Google Sheets template that lets you track every fleet expense — fuel, maintenance, insurance, registration, and more — in one centralized log and instantly see which vehicles cost the most to operate. It is designed for fleet managers, owner-operators, small-business owners, and anyone who manages one or more vehicles and wants hard data on cost-per-mile, efficiency rankings, and annual spend forecasts. Your workflow is simple: log each expense on the Expense Log sheet, and the Cost Rankings, Dashboard, and all KPI cards and charts update automatically — no formulas to write, no pivot tables to build.
⚡ Quick start
1Step 1: Open the workbook and read the 'Read Me' sheet for a quick orientation, color-key, and any version notes.
2Step 2: Go to the 🚗 Expense Log sheet. In the first empty row, enter a Date, Vehicle name, Category (e.g. Fuel, Maintenance, Insurance), the Amount spent, the Miles driven since last fill-up or service, how it was Paid, and an optional Note. Repeat for every expense you want to track.
3Step 3: In the vehicle-status section on the same sheet, enter each Vehicle's current Odometer reading, Condition, and Last Service date so the sheet can compute days-since-service alerts and annual estimates.
4Step 4: In the upcoming-service section, enter any scheduled services with Vehicle, Service description, Due Date, estimated cost, and shop name — the sheet will flag urgency automatically.
5Step 5: Switch to the 🏆 Cost Rankings sheet to see which vehicles cost the most per mile and where your fleet spend is concentrated. No data entry is needed here — everything pulls from the Expense Log.
6Step 6: Open the 📊 Dashboard sheet to review monthly trends, year-to-date totals, forecasts, and budget status. Again, no data entry — it updates itself as you add expenses.
The Expense Log is the heart of the workbook — every dollar you spend on any vehicle gets recorded here. It contains three functional sections: a transaction log for individual expenses, a vehicle-status panel that tracks odometer readings and service history, and an upcoming-service scheduler. All other sheets pull their data from this one, so accuracy here drives everything else.
✍️ Step by step
11. Start in the transaction-log section. In the Date column, enter the date of the expense in your locale's date format (e.g. 2026-06-15). Use one row per expense.
22. In the Vehicle column, type the vehicle's name or identifier exactly the same way every time (e.g. '2022 Ford F-150' or 'Truck A'). Consistency is critical because summaries group by this text.
33. Choose a Category from a consistent set you define — common choices are Fuel, Maintenance, Insurance, Registration, Tires, Tolls, Parking, or Detailing. Consistent spelling lets the formulas aggregate correctly.
44. Enter the dollar Amount of the expense (numbers only, no dollar sign needed). In Miles, enter the miles driven since the last entry for that vehicle — this is how cost-per-mile is calculated.
55. In Paid, note the payment method (e.g. Credit Card, Cash, Fleet Card). In Note, add any useful detail (e.g. 'oil change at 45 000 mi' or 'premium fuel').
66. After entering a row, glance at the auto-computed columns to the right: ƒ$/Mile, ƒAvg $/Mi, ƒRunning $, ƒ% of Total, ƒRunning $/Mi, and ƒvs Cat will populate instantly.
77. Scroll to the vehicle-status panel. For each vehicle in your fleet, enter the current Odometer reading, a Condition note (e.g. Good, Fair, Needs Brakes), and the Last Svc date. The sheet will compute ƒDays Since, ƒAlert, ƒLogged Mi, ƒ# Txns, ƒAnnual Est, ƒEnergy/Mi, ƒMaint %, ƒPriority, and ƒ$/Mile.
88. Scroll to the upcoming-service scheduler. Enter each Vehicle, the Service needed (e.g. Oil Change, Tire Rotation), the Due Date, the Status (e.g. Scheduled, Pending, Done), the Est Cost, and the Shop name. The sheet auto-fills ƒDue In, ƒUrgency, ƒ$/Mile, and ƒSvc/Yr.
99. Review the KPI cards at the top or side of the sheet for a real-time snapshot: total Amount spent, total Miles logged, fleet-wide $/Mile, Avg $/Mi, Running $, and % of Total. These update with every new row you add.
📋 Column-by-column
| Date | INPUT — Enter the calendar date of the expense. Use a consistent date format such as MM/DD/YYYY or YYYY-MM-DD. Example: 06/15/2026. This anchors every calculation that involves time trends and monthly roll-ups on the Dashboard. |
| Vehicle | INPUT — Type the name or identifier for the vehicle this expense belongs to. Always spell it exactly the same way (e.g. '2022 Ford F-150'). Inconsistent names will cause the vehicle to appear as two separate entries in rankings and charts. |
| Category | INPUT — The type of expense. Use a consistent set of labels such as Fuel, Maintenance, Insurance, Registration, Tires, Tolls, Parking, or Detailing. This drives the Spend by Category chart and the per-category breakdowns. |
| Amount | INPUT — The dollar amount of the expense, entered as a plain number (e.g. 85.40). Do not include a dollar sign — the column is formatted as currency automatically. This is the core cost figure that feeds every KPI and chart. |
| Miles | INPUT — The number of miles driven since the previous log entry for this same vehicle (trip miles or interval miles, not the odometer reading). Example: 320. This is used to compute cost-per-mile. If the expense has no mileage component (e.g. an insurance payment), you may leave it blank or enter 0, but note that a zero value will make $/Mile show as blank or N/A for that row. |
| Paid | INPUT — The payment method used, e.g. Credit Card, Debit, Cash, Fleet Card, or Company Account. Useful for reconciling with bank statements. |
| Note | INPUT — An optional free-text field for details like invoice numbers, part descriptions, or service notes. Example: 'Replaced front brake pads and rotors at 52 000 mi.' |
| ƒ$/Mile | AUTO-COMPUTED — Cost Per Mile for this single transaction. Formula in words: Amount ÷ Miles. It tells you how expensive this particular expense was relative to the distance driven. A fuel fill-up might show $0.15–$0.25/mile; a major repair on few miles could spike to $1.00+. Lower is better. If Miles is zero or blank, this cell will show blank or an error indicator. |
| ƒAvg $/Mi | AUTO-COMPUTED — Average Cost Per Mile. This is a running or cumulative average of all $/Mile values for the same vehicle up to this row. It smooths out spikes from one-off repairs and gives you the vehicle's trend line. A healthy fleet vehicle typically runs $0.20–$0.60/mile all-in; above $0.75 signals high operating cost. |
| ƒRunning $ | AUTO-COMPUTED — Running Total Spend. This is the cumulative sum of the Amount column from the first row down to the current row. It shows how total fleet spending is growing over time. Use it to see if you are on pace to hit your annual budget. |
| ƒ% of Total | AUTO-COMPUTED — Percentage of Total Spend. Formula in words: this row's Amount ÷ the grand total of all Amounts, expressed as a percentage. It tells you how significant this single expense is relative to all spending. Most routine entries will be under 1–2%; a value above 5% flags a big-ticket item worth reviewing. |
| ƒRunning $/Mi | AUTO-COMPUTED — Running Cost Per Mile. This is the cumulative total spend divided by cumulative total miles up to this row. It is the most reliable efficiency metric because it absorbs volatility. Watch for a steady or declining trend; a rising trend means your fleet is getting more expensive to operate per mile driven. |
| ƒvs Cat | AUTO-COMPUTED — Versus Category Average. This compares the current row's $/Mile to the average $/Mile for the same Category across all vehicles. A positive value or percentage means this entry is more expensive than the category average; a negative value means it is cheaper. Use it to spot outlier expenses — for example, a fuel fill-up that is 30% above the fleet fuel average may indicate a vehicle with poor fuel economy. |
| Odometer | INPUT (vehicle-status section) — The current or most recent odometer reading for each vehicle, in miles. Example: 47520. This is used alongside Logged Miles to estimate annual mileage and energy cost per mile. |
| Condition | INPUT (vehicle-status section) — A brief assessment of the vehicle's current condition. Use terms like Excellent, Good, Fair, or Poor, or add a short note such as 'Needs tires soon.' This is for your reference and helps prioritize service scheduling. |
| Last Svc | INPUT (vehicle-status section) — The date of the vehicle's most recent service or maintenance visit. Example: 04/10/2026. The sheet uses this to calculate days since last service and generate alerts. |
| ƒDays Since | AUTO-COMPUTED — Days Since Last Service. Formula in words: today's date minus the Last Svc date. It tells you how many calendar days have passed since the vehicle was last serviced. A value above 90–180 days (depending on your service interval) should prompt a check-up. |
| ƒAlert | AUTO-COMPUTED — Service Alert flag. This column displays a warning label (e.g. 'Overdue' or '⚠ Due Soon') when Days Since Last Service exceeds a defined threshold. If the cell is blank or shows 'OK,' the vehicle is within its normal service window. Pay attention to any non-OK value and schedule service promptly. |
| ƒLogged Mi | AUTO-COMPUTED — Logged Miles. This sums all the Miles entries from the transaction log for this vehicle. It tells you the total distance recorded in the workbook, which is useful for verifying against odometer readings and for annual mileage estimates. |
| ƒ# Txns | AUTO-COMPUTED — Number of Transactions. A count of how many expense rows exist for this vehicle. A low count relative to the vehicle's age may indicate under-reporting; a high count is normal for a high-use fleet vehicle. |
| ƒAnnual Est | AUTO-COMPUTED — Annual Spend Estimate. Formula in words: total spend for this vehicle ÷ the fraction of the year elapsed (or the vehicle's active period), projected to 12 months. It forecasts what this vehicle will likely cost for the full year at the current spending rate. Compare it to your budget to see if you are on track. |
| ƒEnergy/Mi | AUTO-COMPUTED — Energy Cost Per Mile. This isolates fuel or charging costs (the Fuel or Energy category) and divides by total miles for the vehicle. It strips out maintenance and other costs so you can see pure propulsion cost. For gasoline vehicles, typical values are $0.10–$0.20/mile; electric vehicles may be $0.03–$0.08/mile. |
| ƒMaint % | AUTO-COMPUTED — Maintenance Percentage. Formula in words: total Maintenance-category spend for this vehicle ÷ total spend for this vehicle, as a percentage. It shows what share of the vehicle's total cost goes to upkeep. A Maint % above 40–50% on a newer vehicle suggests reliability problems; on an older vehicle, 30–40% may be normal. |
| ƒPriority | AUTO-COMPUTED — Vehicle Priority score or rank. This is a composite indicator that factors in $/Mile, Maint %, Days Since service, and alert status to rank vehicles from highest priority (needs attention) to lowest. The vehicle at the top of the priority list is the one you should review or service first. It drives the Vehicle Priority chart. |
| ƒ$/Mile (vehicle-status) | AUTO-COMPUTED — Overall Cost Per Mile for this vehicle across all categories. Formula in words: total Amount for this vehicle ÷ total Miles for this vehicle. This is the single most important efficiency number for each vehicle. Compare vehicles side by side — the one with the highest $/Mile is your costliest to operate. |
| Vehicle (service section) | INPUT (upcoming-service section) — The vehicle that needs the scheduled service. Must match the exact vehicle name used in the transaction log and vehicle-status sections. |
| Service | INPUT (upcoming-service section) — A description of the service needed, e.g. 'Oil Change,' 'Brake Inspection,' '60K Mile Service,' or 'Annual Inspection.' |
| Due Date | INPUT (upcoming-service section) — The date by which this service should be completed. Example: 07/01/2026. The sheet uses this to calculate how many days remain. |
| ƒDue In | AUTO-COMPUTED — Due In (days). Formula in words: Due Date minus today's date. It shows how many calendar days remain until the service is due. A negative number means the service is overdue. |
| ƒUrgency | AUTO-COMPUTED — Urgency label. Based on the Due In value, this displays a flag such as 'Overdue,' 'Due This Week,' 'Due Soon,' or 'OK.' Use it as a quick visual scan for what needs attention right now. |
| Status | INPUT (upcoming-service section) — The current status of this service item. Use labels like Scheduled, Pending, In Progress, or Done. Marking an item Done will typically clear it from urgency alerts. |
| Est Cost | INPUT (upcoming-service section) — The estimated dollar cost of the service. Example: 150. This feeds into the Upcoming Service Costs chart so you can see what near-term spending looks like. |
| Shop | INPUT (upcoming-service section) — The name of the repair shop or service center where the work will be done. Example: 'Jim's Auto' or 'Dealer Service Dept.' Useful for tracking vendor history. |
| ƒ$/Mile (service section) | AUTO-COMPUTED — Estimated cost per mile impact of this service. Formula in words: Est Cost ÷ the vehicle's total logged miles. It puts the service cost in perspective — a $500 repair on a vehicle with 10 000 logged miles adds $0.05/mile to its lifetime cost. |
| ƒSvc/Yr | AUTO-COMPUTED — Services Per Year. This counts how many service entries exist for this vehicle and annualizes the rate. It helps you gauge maintenance frequency — a vehicle averaging 8–10 services per year may be higher-maintenance than one averaging 4–5. |
📊 Reading the numbers
• KPI: Amount — the grand total of all expenses logged. Compare this to your fleet budget to check overall spending health.
• KPI: Miles — total miles logged across all vehicles. This is your denominator for fleet-wide cost-per-mile.
• KPI: $/Mile — fleet-wide cost per mile (total Amount ÷ total Miles). A value under $0.50 is solid for most light-duty fleets; above $0.70 warrants investigation.
• KPI: Avg $/Mi — the average of individual transaction $/Mile values, which can differ from the fleet-wide $/Mile because it weights each transaction equally rather than by miles. Compare it to $/Mile: if Avg $/Mi is much higher, you have some very expensive low-mileage transactions pulling it up.
• Chart — Vehicle Priority: shows vehicles ranked by their composite priority score. Vehicles at the top need the most attention. Chart — Upcoming Service Costs: a bar or timeline showing estimated costs for scheduled services, so you can plan cash flow. Chart — Spend by Vehicle: a pie or bar chart breaking total spend by vehicle — quickly reveals which vehicle eats the most budget. Chart — Spend by Category: shows how spending distributes across Fuel, Maintenance, Insurance, etc. Chart — Cumulative Spend: a line chart of Running $ over time; a steep upward curve means spending is accelerating. Chart — Running $/Mi Trend: a line chart of Running $/Mi over time; a flat or declining line is ideal, a rising line means deteriorating efficiency.
⚠️ Avoid these mistakes
• Inconsistent vehicle names (e.g. 'F-150' vs 'Ford F150') will split one vehicle into two in every chart and ranking — always copy-paste or use a drop-down if available.
• Entering the odometer reading in the Miles column instead of trip/interval miles will massively inflate $/Mile calculations. Miles should be the distance driven since the last log entry for that vehicle.
• Leaving the Miles column at 0 for fuel entries makes $/Mile undefined and hides fuel efficiency data — always enter the miles driven for that fill-up.
• Forgetting to update the Last Svc date after completing a service will keep the alert in a perpetual 'Overdue' state.
💡 Tips• Sort or filter the log by Vehicle to quickly audit one vehicle's cost history.
• Use Google Sheets' built-in data validation (Data → Data validation) on the Vehicle and Category columns to create drop-down lists, ensuring perfect consistency.
• Enter expenses weekly or at each fill-up to keep forecasts accurate — stale data leads to misleading projections.
• Review the ƒvs Cat column regularly to catch outlier transactions that may indicate mechanical problems (e.g. fuel costs 40% above category average could signal poor engine efficiency).
The Cost Rankings sheet automatically ranks every vehicle in your fleet by cost-per-mile and total cost of ownership. Use it to quickly identify your most and least efficient vehicles, see how spend breaks down by category for each vehicle, and compare annual cost projections. No data entry is needed here — it pulls everything from the Expense Log via SUMIFS, FILTER, and COUNTIFS formulas.
✍️ Step by step
11. Navigate to the 🏆 Cost Rankings sheet. All data is auto-populated from the Expense Log — do not type in any cells.
22. Review the KPI cards at the top: Best $/Mi (your most efficient vehicle), P75 $/Mi (the 75th-percentile cost-per-mile, meaning 75% of vehicles are at or below this), Avg TCO/Mo (Average Total Cost of Ownership per month across the fleet), Total spend, total Miles, and fleet-wide $/Mile.
33. Look at the Cost Per Mile Ranking chart to see vehicles ordered from lowest (best) to highest (worst) cost per mile.
44. Check the Cost Breakdown by Vehicle chart to see how each vehicle's spend splits across categories (fuel, maintenance, insurance, etc.).
55. Review the Fleet Spend by Category chart to understand where the fleet's money goes overall — if Maintenance dominates, your fleet may be aging.
66. Examine the Efficiency Score chart, which visualizes a composite score for each vehicle combining cost-per-mile and maintenance burden.
77. Use the Per-Mile by Category chart to compare how much each expense category contributes to the per-mile cost for each vehicle.
88. Check the Annual Projection chart to see forecasted yearly costs per vehicle based on current spending trends — use this for budgeting and replacement decisions.
📊 Reading the numbers
• KPI: Best $/Mi — the lowest cost-per-mile among all your vehicles. This is your efficiency benchmark; try to understand what makes this vehicle cheaper (newer, better fuel economy, fewer repairs) and apply those lessons fleet-wide.
• KPI: P75 $/Mi — the 75th-percentile cost per mile. 75% of your vehicles operate at or below this cost. If the gap between Best $/Mi and P75 is large, you have significant efficiency variation. A tight spread means your fleet is uniformly efficient (or uniformly expensive).
• KPI: Avg TCO/Mo — Average Total Cost of Ownership per month. Formula: total fleet spend ÷ number of vehicles ÷ months of data. This is your per-vehicle monthly budget benchmark. For light-duty trucks, $400–$800/month is a common range; anything above $1 000/month per vehicle deserves scrutiny.
• KPI: Total, Miles, $/Mile — fleet-wide totals mirroring the Expense Log KPIs, included here for quick reference without switching sheets.
• Chart — Cost Per Mile Ranking: a horizontal bar chart ordering vehicles from best to worst $/Mile. Vehicles on the right (or bottom) are your costliest — consider whether they are worth keeping. Chart — Cost Breakdown by Vehicle: stacked bars showing each vehicle's total spend split by category; dominated by one color means one category is driving costs. Chart — Fleet Spend by Category: a pie or donut chart for the entire fleet; if Maintenance is more than 35–40%, consider fleet age or reliability issues. Chart — Efficiency Score: a composite metric visualized per vehicle; higher scores mean better efficiency. Chart — Per-Mile by Category: shows $/Mile broken into its category components per vehicle. Chart — Annual Projection: forecasted 12-month spend per vehicle — compare to replacement cost to decide if it is cheaper to replace than maintain.
⚠️ Avoid these mistakes
• Do not type data into this sheet — it is entirely formula-driven. Any manual entry may overwrite formulas and break the rankings.
• If a vehicle appears to be missing from the rankings, check that its name in the Expense Log matches exactly — even an extra space will cause it to be treated as a separate vehicle.
• Do not delete rows on this sheet; if you remove a vehicle from your fleet, simply stop logging expenses for it on the Expense Log and it will eventually drop in relevance.
💡 Tips• Use this sheet during quarterly fleet reviews to decide which vehicles to keep, sell, or replace based on their ranking and annual projection.
• Compare the Efficiency Score chart to each vehicle's age and mileage — a low score on a newer vehicle is a red flag for reliability.
• Screenshot the Cost Per Mile Ranking chart and share it with stakeholders as a quick fleet health summary.
• If one vehicle's annual projection far exceeds the others, investigate whether a single large repair is skewing it or if it has a systemic cost problem.
The Dashboard is your fleet's command center. It provides a month-by-month summary of spending, mileage, cost-per-mile, and forecasts, all auto-calculated from the Expense Log and Cost Rankings sheets. Use it to spot trends, compare actual spending to forecasts, monitor year-to-date performance, and ensure you stay within budget. No data entry is required here.
✍️ Step by step
11. Open the 📊 Dashboard sheet. The Month column lists each calendar month automatically.
22. Review the auto-populated columns: ƒSpend (total spent that month), ƒMiles (total miles that month), ƒ$/Mile (monthly cost per mile), ƒMoM Δ (month-over-month change), ƒ3M Avg (three-month rolling average), ƒForecast (projected spend for the next month), ƒStatus (whether you are on/under/over budget), ƒYTD $ (year-to-date total spend), ƒYTD $/Mi (year-to-date cost per mile), ƒ# Txns (transaction count for the month), and ƒ$/Day (average daily spend for the month).
33. Check the KPI cards: Total Spent, Fleet $/Mi, Annual Est, Runway, Total, and Energy for a snapshot of fleet financial health.
44. Study the Fleet Cost Split chart to see how the current period's spending distributes across categories.
55. Review the Actual vs Forecast chart to see if real spending tracks the projection — persistent over-forecast indicates a trend you need to address.
66. Use Energy vs Service chart to compare fuel/energy costs against maintenance/service costs over time — a crossover where service exceeds energy may signal an aging fleet.
77. Examine Monthly vs YTD $/Mi to see if individual months are volatile but the year-to-date trend is stable (normal) or if both are rising (a problem).
88. Check the YTD Spend Curve (cumulative spend through the year) against your annual budget line to see if you will finish under or over budget.
99. Review the Budget Variance chart to see exactly how much you are above or below your planned spend each month.
📋 Column-by-column
| Month | AUTO-POPULATED — The calendar month label (e.g. Jan 2026, Feb 2026). Each row represents one month of fleet activity. You do not need to enter anything here. |
| ƒSpend | AUTO-COMPUTED — Monthly Spend. Formula in words: SUM of all Amount values from the Expense Log where the Date falls within this month. It tells you how much you spent on the entire fleet in a given month. Compare month to month to spot seasonal patterns (e.g. higher fuel in summer, more maintenance in spring). |
| ƒMiles | AUTO-COMPUTED — Monthly Miles. The total miles logged across all vehicles for this month, pulled via SUMIF from the Expense Log. A drop in miles with steady spend means rising cost-per-mile. |
| ƒ$/Mile | AUTO-COMPUTED — Monthly Cost Per Mile. Formula: monthly Spend ÷ monthly Miles. This is the fleet's efficiency for a single month. Compare it to the YTD $/Mi and the 3M Avg to see if the month was typical or an outlier. |
| ƒMoM Δ | AUTO-COMPUTED — Month-over-Month Delta (change). Formula: this month's $/Mile minus last month's $/Mile (or expressed as a percentage change). A positive value means cost-per-mile increased; negative means it decreased. Occasional spikes are normal (a big repair month), but consecutive positive deltas signal a worsening trend that needs action. |
| ƒ3M Avg | AUTO-COMPUTED — Three-Month Rolling Average of $/Mile. Formula: average of the current month's $/Mile and the two preceding months. This smooths out monthly volatility and reveals the underlying trend. If the 3M Avg is steadily climbing, your fleet efficiency is deteriorating regardless of any single good or bad month. |
| ƒForecast | AUTO-COMPUTED — Forecasted Spend. This projects next month's expected spend based on historical patterns (typically a weighted moving average or linear trend from prior months). Compare your actual spend to this forecast to see if you are spending more or less than expected. Consistent actual > forecast means your costs are accelerating. |
| ƒStatus | AUTO-COMPUTED — Budget Status indicator. Displays a label such as 'On Track,' 'Over Budget,' or 'Under Budget' based on whether YTD spend is within an acceptable range of the projected pace. Green/On Track means you are within budget; Yellow/Caution means you are approaching the limit; Red/Over Budget means you have exceeded it. |
| ƒYTD $ | AUTO-COMPUTED — Year-to-Date Total Spend. Formula: cumulative sum of monthly Spend from January through the current month. This is the running total for the calendar year, used in the YTD Spend Curve chart and for comparing against your annual budget. |
| ƒYTD $/Mi | AUTO-COMPUTED — Year-to-Date Cost Per Mile. Formula: YTD $ ÷ YTD total miles. This is the most stable efficiency metric on the Dashboard because it includes all data for the year. It is less volatile than any single month's $/Mile and is the number to quote when someone asks 'what does our fleet cost per mile?' |
| ƒ# Txns | AUTO-COMPUTED — Number of Transactions for the month. A COUNTIF of Expense Log rows with dates in this month. Useful for gauging data completeness — if you typically log 20–30 transactions per month and suddenly see 5, you may be behind on data entry. |
| ƒ$/Day | AUTO-COMPUTED — Cost Per Day. Formula: monthly Spend ÷ number of days in the month. It normalizes spending to a daily rate, which is useful for comparing months of different lengths (e.g. February vs. March). Typical fleet daily costs vary widely by fleet size; track your own baseline and watch for deviations. |
📊 Reading the numbers
• KPI: Total Spent — the grand total of all fleet expenses for the year to date. This is your headline budget number.
• KPI: Fleet $/Mi — the fleet-wide cost per mile for the year to date, identical to YTD $/Mi. Under $0.50 is strong for most light-duty fleets; $0.50–$0.70 is average; above $0.70 needs attention.
• KPI: Annual Est — the projected total fleet spend for the full 12-month year, extrapolated from current pace. Compare this to your annual fleet budget to see if you will finish under or over.
• KPI: Runway — how many months (or dollars) of budget remain at the current spending rate before you exhaust your annual allocation. A shrinking runway mid-year is a warning to cut costs.
• KPI: Total and Energy — Total reiterates the cumulative figure; Energy isolates fuel/charging costs. If Energy is a large share of Total, fuel prices or vehicle efficiency are the main lever for savings.
• Chart — Fleet Cost Split: a pie or donut showing the share of spend by category for the current view. Chart — Actual vs Forecast: a dual-line chart comparing what you actually spent each month to what the model predicted; persistent gaps indicate a need to revise the budget. Chart — Energy vs Service: two trend lines letting you compare propulsion costs to maintenance costs; when maintenance overtakes energy, fleet age may be the driver. Chart — Monthly vs YTD $/Mi: two lines showing the volatile monthly metric against the smooth yearly metric; divergence highlights outlier months. Chart — YTD Spend Curve: a cumulative area chart with an optional budget line overlay; staying below the budget line is the goal. Chart — Budget Variance: bars showing the dollar difference between actual and budgeted spend each month; negative bars mean you are under budget (good), positive bars mean over.
⚠️ Avoid these mistakes
• Do not manually enter data on this sheet — all columns are formula-driven from the Expense Log. Manual entries will overwrite formulas.
• If a month shows $0 for Spend or Miles, it likely means no expenses were logged for that month on the Expense Log — go back and enter any missing data.
• Do not re-sort or rearrange rows on this sheet; the month sequence is essential for rolling averages and forecasts to calculate correctly.
💡 Tips• Use the Forecast column to set realistic monthly budgets for the coming quarter — it is based on your actual data, not guesswork.
• If the 3M Avg is rising, drill into the Expense Log to find which vehicle or category is driving the increase before it becomes a bigger problem.
• Export or screenshot the Actual vs Forecast chart for monthly fleet reports to management.
• Compare the Runway KPI to the number of months left in the year — if Runway is less than months remaining, you will overshoot your budget without changes.
📖Glossary — what every value means
| $/Mile (Cost Per Mile) | Total cost divided by total miles driven. It is the primary efficiency metric in the template, calculated at the transaction level, vehicle level, and fleet level. For light-duty vehicles, $0.30–$0.60/mile is typical; lower is better. |
| Avg $/Mi (Average Cost Per Mile) | The arithmetic average of individual transaction-level $/Mile values. Unlike the fleet-wide $/Mile (which is total$ ÷ totalMiles), Avg $/Mi weights every transaction equally. If some transactions have very few miles, Avg $/Mi can be higher than fleet $/Mile. |
| Running $ (Running Total Spend) | A cumulative sum of all expenses from the first entry to the current row. It shows how total fleet spending grows over time. |
| % of Total | The percentage that a single expense represents of all expenses combined. Formula: individual Amount ÷ sum of all Amounts × 100. Most entries are under 2%; large values flag significant one-time costs. |
| Running $/Mi (Running Cost Per Mile) | Cumulative total spend divided by cumulative total miles at each point in time. It is the most stable per-mile metric and shows the long-term efficiency trend. |
| vs Cat (Versus Category Average) | A comparison of a single transaction's $/Mile to the average $/Mile across all transactions in the same Category. A positive value means the transaction was more expensive than average for its category. |
| Days Since (Last Service) | The number of calendar days between the Last Service date and today. High values (90+ days depending on the vehicle's service interval) indicate the vehicle may be overdue for maintenance. |
| Logged Mi (Logged Miles) | The sum of all Miles entries from the transaction log for a specific vehicle. Represents total distance tracked in the workbook, not necessarily the odometer reading. |
| # Txns (Number of Transactions) | A count of expense entries for a given vehicle or time period. Useful for assessing data completeness. |
| Annual Est (Annual Estimate) | A projected 12-month spend based on the current rate of spending. Formula: total spend to date ÷ fraction of year elapsed, annualized. Compare to your budget to see if you are on track. |
| Energy/Mi (Energy Cost Per Mile) | Fuel or electricity cost divided by miles driven, isolating propulsion cost from all other expenses. Typical gasoline vehicles: $0.10–$0.20/mile; EVs: $0.03–$0.08/mile. |
| Maint % (Maintenance Percentage) | The share of a vehicle's total cost that goes to maintenance. Formula: Maintenance spend ÷ total spend × 100. Above 40–50% on a vehicle under 5 years old is a red flag for reliability. |
| Priority | A composite ranking score for each vehicle that factors in $/Mile, Maint %, Days Since service, and alert status. The highest-priority vehicle is the one most in need of attention. |
| Due In | The number of calendar days until a scheduled service is due. Negative values mean the service is overdue. |
| Urgency | A label (Overdue, Due This Week, Due Soon, OK) based on the Due In value for upcoming services. Designed for at-a-glance service scheduling. |
| Svc/Yr (Services Per Year) | The annualized count of service events for a vehicle. A higher number indicates more frequent maintenance needs. |
| Best $/Mi | The lowest (best) cost-per-mile among all vehicles in the fleet. This is your efficiency benchmark. |
| P75 $/Mi (75th Percentile Cost Per Mile) | The cost-per-mile value at the 75th percentile of all vehicles. 75% of vehicles are at or below this cost. A large gap between Best $/Mi and P75 $/Mi means significant efficiency variation in the fleet. |
| Avg TCO/Mo (Average Total Cost of Ownership Per Month) | Total fleet spend divided by the number of vehicles divided by months of data. It is the average monthly operating cost per vehicle. For light-duty fleets, $400–$800/month per vehicle is common. |
| TCO (Total Cost of Ownership) | The complete cost of operating a vehicle over its life or a given period, including fuel, maintenance, insurance, registration, and depreciation. In this template, TCO is represented by the sum of all logged expenses for a vehicle. |
| MoM Δ (Month-over-Month Delta) | The change in $/Mile from one month to the next. A positive delta means cost-per-mile increased; negative means it improved. Consecutive positive deltas signal a worsening trend. |
| 3M Avg (Three-Month Rolling Average) | The average of $/Mile for the current month and the two prior months. It smooths short-term volatility to reveal the underlying efficiency trend. |
| Forecast | A projected future spend value based on historical spending patterns, typically using a weighted moving average or linear trend. Used on the Dashboard to anticipate next month's costs. |
| YTD $ (Year-to-Date Spend) | The cumulative total of all expenses from January 1 through the current month of the calendar year. |
| YTD $/Mi (Year-to-Date Cost Per Mile) | Year-to-date total spend divided by year-to-date total miles. This is the most stable fleet efficiency metric and the best number to quote in reports. |
| $/Day (Cost Per Day) | Monthly spend divided by the number of days in that month. Normalizes spending across months of different lengths for fairer comparison. |
| Runway | How much budget remains at the current spending rate, expressed in months or dollars. If Runway is less than the months left in the year, you are projected to exceed your budget. |
| Budget Variance | The difference between actual spend and budgeted spend for a given period. Negative variance means under-budget (good); positive means over-budget. |
| Fleet | The collection of all vehicles tracked in this workbook. Fleet-level metrics aggregate data across every vehicle. |
| Efficiency Score | A composite metric on the Cost Rankings sheet that combines cost-per-mile, maintenance burden, and other factors into a single score for ranking vehicle efficiency. Higher scores indicate better efficiency. |
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 AI assistant, click the ✨ sparkle icon in the right-hand side panel of Google Sheets. A chat window will appear where you can type questions or commands in plain English. You start with a set of free AI requests; after those are used, a subscription gives you a bigger monthly allowance of requests.
2Ask the assistant to EXPLAIN any cell — for example, type 'explain B7' or 'what does the $/Mile formula do?' and it will break down the formula in that cell in plain language, including what inputs it uses and what the result means. You can also attach a screenshot or image (such as a photo of a receipt or a chart from another tool) and the assistant will read and interpret it.
3Give the assistant COMMANDS that read and act on your data without breaking any formulas — for example, 'sum column C,' 'fill the next row with today's date and vehicle Truck A,' or 'color row 1 gold.' These are typed as natural-language instructions in the chat, not standalone buttons. The assistant can also SCAN the entire workbook to check for errors, missing data, or anomalies.
4The assistant includes one-click PRESETS tailored to this template — these are pre-built prompts relevant to vehicle cost tracking that you can run with a single click, saving you time on common analyses. You can also use the Tools tab to run ANALYZE ALL MY DATA, which generates a comprehensive report on a new sheet, and AUTO-FIT columns to resize them for readability.
5Use the TRANSLATE feature to convert every label in the workbook into another language, making the template accessible for non-English-speaking team members. The assistant can also build an INFOGRAPHIC from your data for presentations or reports. Adjust the response style using the Tone selector (Friendly, Professional, or Concise) and apply Smart Styling to format your sheets visually.
6Pro subscribers unlock additional capabilities including native CHARTS generated by the assistant, FORECASTS based on your historical data, and a full multi-page REPORT — all created directly within Google Sheets from your fleet data.