Trucking Owner-Operator Tracker — one-truck load ledger, per-diem log, IFTA quarters & cost-per-mile dashboard (Excel + Google Sheets)

Stop running your truck on receipts in a shoebox.

Trucking Owner-Operator Tracker is a single spreadsheet system built for one-truck

owner-operators who want load-level profit, per-diem audit defense, and IFTA quarters

in one file — without paying a subscription or enabling a single macro.

What's inside

- Dashboard — 16 KPIs: gross, deadhead/loaded/total miles, empty %, fuel cost,

cash operating expenses, per-diem deduction, total deductions, net income, tax

set-aside, cost per mile (cash and all-in), revenue per loaded mile, fuel gallons,

fleet MPG — plus a year-to-date expense breakdown and a month-by-month

gross/expenses/net table with a chart. All formulas; you never type here.

- Load Ledger — one row per load: date, load ID, broker, route, jurisdiction

dropdown, gross, deadhead miles, loaded miles. Total miles computes itself.

- Expenses — trucking categories with dropdowns (fuel, maintenance, insurance,

parking, tolls, permits, cell, lumper, scales, professional, supplies, other). Fuel

rows carry gallons + jurisdiction so IFTA MPG works.

- Per-Diem Log — a contemporaneous road-day log; pick "Yes" and the row

auto-applies $64.00/day ($80.00 CONUS special M&IE x 80% DOT limit). The IRS checks

this log — now you have one.

- IFTA Summary — calendar quarters (miles / gallons / MPG) with audit notes, built

on the same data you already typed.

- Schedule C Map — where every lane lands on Schedule C (guidance, not tax advice).

- Settings & ReadMe — WorkYear (one cell drives every period), per-diem constants

(C5/C6/C7 = C5xC6), tax rate, and the three dropdown source lists.

Why you'll like it

- One-time purchase vs $19/mo ProfitGauges — pays for itself in about six weeks.

- Undercuts the $52.55 Etsy anchor by half while adding the two things most trackers

skip: per-diem audit defense and load-level P&L.

- Per-diem audit defense + load-level P&L + IFTA quarters, all in one macro-free file.

- Zero setup: no macros, no add-ins, no accounts. Opens in Excel 2016+ and imports

into Google Sheets in one click.

- Ships with clearly-marked sample data (52 weekly loads, 220 road days) so every

report works before you type a thing — delete the sample rows and it's yours.

- New year? Change one WorkYear cell and keep going. No subscription, ever.

You get

- `Trucking-Owner-Operator-Tracker-v1.xlsx` (the full system)

- `QUICKSTART.md` + `QUICKSTART.pdf` (your first 5 minutes)

- `USER-GUIDE.md` + `USER-GUIDE.pdf` (every sheet, field, formula, FAQ, troubleshooting)

- `LICENSE.txt` (single-user license)

Honest notes

- This is a brand-new product from a small template studio — v1.0. It is built for one

truck; multi-truck is a future version. If you spot a bug or want a category added,

message us through Payhip and we'll fix it in the next update. Buyers get free v1.x

updates.

- Estimates, per-diem deductions, and IFTA summaries in the workbook are plain math and

record-keeping aids — not tax, IFTA, or legal advice.