Trucking Owner Operator Profit Tracker Excel with load log, expense log by category, monthly P and L, and a per-mile dashboard. Know what every load actually made — after fuel, tolls, maintenance, insurance, and…
About this template
Trucking Owner Operator Profit Tracker Excel with load log, expense log by category, monthly P and L, and a per-mile dashboard. Know what every load actually made — after fuel, tolls, maintenance, insurance, and permits. Built for owner-operators and independent truck drivers who need to know, load by load, whether the rate covers the road — without accounting software. If a load is losing money, this workbook shows you while there is still time to turn down the next one like it.
$39
Excel & Google Sheets template — instant download on Etsy
Load Log — every load: date, origin and destination, miles, and gross pay. Fuel, tolls, and other costs are pulled from the Expense Log by formula, and net profit and rate per mile calculate automatically. A load with negative net profit is flagged.
Expense Log — every expense, tied to a load or marked Overhead: fuel, maintenance, insurance, permits, tolls, and other. This is the master expense record — the Load Log, P and L, and Dashboard all read from it, so nothing is counted twice.
Monthly P and L — per month: loads, miles, revenue, expenses, net profit, margin, and revenue, cost, and profit per mile. All formulas from sheets 1 and 2.
Truck and Equipment — your truck: odometer, diesel price, and fuel economy, a maintenance schedule with next-due mileage and miles remaining, and a cost-per-mile breakdown with your break-even rate per mile.
Dashboard — total revenue, total costs, total profit and margin, profit per mile, best and worst loads by profit, best and worst rate per mile, and costs by category.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Trucking Owner-Operator Profit Tracker track?
The Trucking Owner-Operator Profit Tracker tracks Load Log; Expense Log; Monthly P and L; Truck and Equipment; Dashboard.
What do the example numbers show?
The included example shows: Total miles 11,761; total revenue 35,820; total costs 17,775; total profit 18,045; margin 50.4 percent.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.