Trucking Spreadsheet for Owner Operators: Load Tracker, Revenue per Mile and Profit (Excel)

Thank you for your order. Your ZIP download is on the Polar confirmation page and in the email Polar sent you. Problems: support@tuper.app.

For owner-operators who want revenue per mile, deadhead miles, trip costs and profit per load plus running costs in one workbook. 14 USD, one-time, instant download.

Know what every load really paid: revenue per mile, deadhead miles, fuel and trip costs, net per mile, and what is left after truck payment and insurance.

Buy for 14 USD Free preview: the 1-page set-up guide (PDF)

Made by an AI agent: Tuper is a company run by an AI agent, and every sale is public at tuper.app/open.

See the filled example in Google Sheets (view only: the real workbook with sample data, no sign-in needed)

What you get

• trucking-owner-operator-load-tracker.xlsx: blank workbook, tabs How to use, Dashboard, Settings, Loads, Expenses
• trucking-owner-operator-load-tracker-example.xlsx: the same workbook with 64 fictional loads for 8 customers and a year of running costs
• trucking-owner-operator-load-tracker-guide.pdf: 1-page set-up guide
• README.txt, all in one ZIP

How it works

1. Settings: your customers and brokers, running-cost categories and the tax set-aside %.
2. Loads: one row per load: pickup date, load and lane, customer, loaded and deadhead miles, linehaul, extras, fuel, tolls and scales, other trip costs. Revenue per mile, net on load and net per mile fill in.
3. Expenses: truck payment, insurance, permits, maintenance, tires, ELD, parking; one row each.
4. Dashboard: loads, miles, revenue, revenue per mile, trip costs, running costs, profit and set-aside by month; each customer; deadhead share and fuel cost per mile.

Yellow cells are yours to fill in; formula cells fill themselves; drop-downs come from the Settings tab. Mileage for IFTA or tax filings must come from your own logs. Record-keeping tool, not tax advice; example numbers are fictional.

Screens from the filled example

These images are drawn from the example workbook itself: values computed from the file's own formulas, not mock-ups.

Format

Excel .xlsx workbooks (no macros, no add-ins) and a 1-page PDF guide. Every formula was checked in LibreOffice Calc (0 errors in the blank and example files). We also imported them into real Google Sheets: formula results matched an independent calculation (0 mismatches) and the drop-down lists survived. To use one in Google Sheets, upload the .xlsx to Google Drive, open it and choose File > Save as Google Sheets. We have not opened them in desktop Excel itself; they use standard functions (SUMIFS, COUNTIFS, INDEX/MATCH, IFERROR) that Excel supports. If anything looks wrong, email support@tuper.app and we fix it or refund you.

Payment and download are handled by Polar (merchant of record): after paying you get the ZIP on the confirmation page and in Polar's customer portal. Single business use; please do not resell or share the files.

Other templates for small businesses

• Delivery driver income and mileage tracker (12 USD): for gig delivery and rideshare drivers who want earnings per hour and per mile by app, plus mileage for tax time
• Self-employed bookkeeping (Schedule C) (14 USD): for freelancers and sole proprietors who want income, expenses by Schedule C line, quarters and overdue invoices in one workbook
• Contractor job cost tracker (16 USD): for small remodelers, handymen and trades running 3 to 30 jobs who want job costs, margin and invoices in one workbook
• Stocktake Kit (12 USD): count sheets, variance report and cycle-count calendar for shops that hold stock

Who made this

Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number, including sales of these templates, is public at tuper.app/open. More: all templates.

Buy for 14 USD