Owner-Operator Load Profit and IFTA Tracker Spreadsheet | Trucking Load Calculator Google Sheets Template for Owner Operators

Should you take that load?

Every owner-operator knows the moment: a broker names a number, and you have about a minute to decide if it actually pays — after the deadhead, after the fuel, after YOUR costs. Guess wrong a few times a month and the truck is working for free.

This tracker makes the call for you, with your own numbers. Set your cost per mile once, then check any load in about 60 seconds: type the pay and the miles, and the sheet shows the profit, the profit per mile, and a plain GO or NO-GO against the rate you set. No 20-tab "command center" to learn — six focused tabs that work on your phone, in the cab, at the fuel island.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

**WHAT'S INSIDE** — 6 tabs:

- **Start Here** — quick start and the 60-second load check, in plain English

- **Truck Setup** — your fixed monthly costs (truck payment, insurance, permits, phone) plus planned miles and maintenance per mile become ONE number: your true cost per mile. A fuel estimate (diesel price ÷ your MPG) and your personal GO / NO-GO target rate live here too

- **Load Log** — one row per load: pay, loaded miles, deadhead miles, fuel, other costs. Total miles, revenue per mile, total cost, profit, and profit per mile compute themselves, and every load gets flagged GO or NO-GO against your target rate

- **Fuel & IFTA Log** — jot each fill-up: date, state, miles driven in that state, gallons bought. Per-state totals and your overall MPG build themselves at the bottom — no year-end shoebox of receipts

- **Settlements** — what each carrier or broker owed vs. what they actually paid. If they short you, the row flags itself with the exact difference

- **Dashboard** — your month at a glance: total revenue, total profit, average revenue and profit per mile, total miles, load count, settlement shortfalls, and your IFTA state table

**BUILT FOR 1–3 TRUCKS, BUILT FOR THE CAB**

Big type, simple rows, nothing to install. It runs in Google Sheets on your phone, tablet, or office computer, and the sample loads (fictional, Dallas–Atlanta lanes) show you exactly how the math works before you delete them and type your own.

**PLEASE NOTE**

This tracker is a record-keeping aid only — it is not tax advice, and IFTA figures should be confirmed with your tax professional before filing.

FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.**REQUIREMENTS:** a free Google account. Your tracker lives in Google Sheets — no Excel needed.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.