Owner Operator Trucking Spreadsheet, Cost Per Mile and Load Tracker
Know what every mile costs your truck, the rate you need to break even, and whether the load in front of you is worth taking. Built for owner-operators and small trucking businesses, with a tax estimate for 2026.
WHAT YOU GET
• Cost Per Mile: fixed costs, fuel, maintenance and tires worked into one cost per mile, your break-even rate per loaded mile, and the rate to ask for your target profit
• Load check: type the loaded miles, empty miles and pay offered, and it says take it, counter (with the pay to ask) or pass
• Loads log: pay per mile, trip cost and profit for every load, or skip it and type monthly totals
• Expenses by category (fuel, repairs, tires, tolls, insurance, lease, permits and more), by month or receipt log
• Meal allowance from full days away from home, using the IRS transportation-industry rate and the 80% limit for hours-of-service workers (editable)
• Quarterly estimated-tax plan, Year-End Summary to hand your preparer, plain-word checks, and an IRS Figures tab with every rate and source
• Sample data to clear. For tax year 2026 only
HOW IT WORKS
- On Setup, type what the truck costs each month and per mile. Cost Per Mile shows your break-even rate and checks any load.
- 2. Type revenue and miles by month or log each load, add expenses, and read the Dashboard.
FORMAT
Excel (.xlsx). Works in Google Sheets (free) and Microsoft Excel. Includes a short READ ME. Opens with sample data so you can see it working; clear it in seconds. Formulas are protected (no password), so nothing breaks while you type. Instant download.
WHO MADE THIS
Built by someone who develops pricing and financial models for multi-million-dollar enterprise contracts for a living. Same discipline, made simple for your own numbers.
GOOD TO KNOW
• Digital download: nothing is shipped.
• For personal use. Please don't resell or share the file.
• Estimates for planning, not tax advice. Tax rules change; every rate, limit and date sits on one tab with its source (irs.gov, read October 29, 2026) so you can update it. Check with the IRS or a tax preparer before you file or pay.
• The meal allowance rate and rules are the IRS's; confirm with a tax preparer that they apply to you. The file does not use a mileage rate: truck costs are actual expenses.
• Questions? Email tidyrate@outlook.com.
Text and layouts were created with AI tools and reviewed and edited by the seller.