12 · Hotshot & Box-Truck Tracker
Hotshot and Box Truck Tracker
A 56-page owner-operator tracker plus a 15-sheet calculator workbook (7,615 formulas) for hotshot, box-truck, and cargo-van businesses. It is built around what the truck costs per mile and whether a load beats that number: a break-even calculator, a two-load compare, a load log, a broker scorecard, fuel and state miles with quarterly IFTA summaries, maintenance by mileage, and a tax set-aside. It has 4,610 fillable fields and 699 links, and comes in Letter and A4.
$8
Spreadsheet · Fillable PDF · Printable PDF · Letter and A4
Secure checkout through Payhip. Instant download after purchase.
Refunds: if a file won't open, is missing something, or isn't as described, email [email protected] within 14 days of purchase and we'll fix it or give you a full refund. TABWORK is a brand of IQ Learning LLC.

Who it is for
Hotshot, box-truck, and cargo-van owner-operators who need to know what the truck costs per mile and whether a load beats it.
The hero tool
A break-even cost-per-mile calculator sets the floor. A load calculator and two-load compare show all-in rate, estimated profit, and the rate to counter at. The load log and broker scorecard keep every load and broker in one place, and fuel, state-miles, and quarterly IFTA summaries support your fuel-tax filing.
What is included
- A 15-sheet workbook that opens in any spreadsheet app (7,615 formulas, no macros)
- Fillable, hyperlinked PDFs in US Letter and A4, plus printable PDFs in both sizes (56 pages, 4,610 fillable fields, 699 links)
- Break-even cost-per-mile calculator, load calculator, and two-load compare
- Load log, invoices, and a broker scorecard that fills itself
- Fuel log with MPG, a state-miles record, and quarterly IFTA summaries
- Maintenance by mileage, compliance dates you set, a quarterly tax set-aside, and printable trip sheets
- A start-here note and a personal-use license
Fuel-tax, tax, and compliance pages are record-keeping aids. Rules and rates change, so check current rules with the agency or a tax professional. No carrier, broker, or app marks. Example January–March data is filled in so you can see every formula work; delete it when you start.
Inside the file
These are real page renders from the planner, not mock layouts.



Questions about the Hotshot and Box Truck Tracker
How do I work out my cost per mile?
Add a month's fixed costs (truck and trailer payments, insurance, permits) to its variable costs (fuel, maintenance, tires, tolls), then divide by every mile you ran that month, loaded and empty. The break-even calculator does this and shows the rate to counter at. See our free guide at www.tabwork.org/guides/hotshot-cost-per-mile/.
Does it handle IFTA?
It records fuel and state miles and builds quarterly IFTA summaries to support your filing. It does not file for you, and rules change, so check current rules with your state.
What opens the spreadsheet?
It opens in any spreadsheet app. There are no macros. Cells you type in are tinted; leave the formula cells alone.
How much is it, and where do I buy it?
It is $8 on Payhip, with secure checkout and an instant download.
Related
Planning tool only. Not legal, financial, tax, or medical advice.
