Trucking Business Tracker 2027 – Owner Operator Spreadsheet for Box Truck, Cargo Van, Hotshot & Semi (US)

Busy every day but not sure you're making money? Most owner-operators don't lose it on the big things. They lose it on empty miles, days waiting at the dock, slow-paying brokers and fees that add up. This tracker shows you, in green, amber and red.

What it does

• Load Checker: type a broker's offer and get take it, only if you must or walk away, with the lowest rate to accept and the number to counter with. Compare three loads side by side.
• Real rate per mile on every load, with empty miles included, plus profit and profit per day (insurance and truck payments run while you wait).
• Broker scorecard: average days to pay, who's overdue, who pays below your cost, and chase emails ready to send (up to a bond claim).
• IFTA worksheet by state and province, per diem at the IRS $80 a day (80% deductible), and expenses with their Schedule C heading.
• Compliance & service: 2027 IFTA return dates, quarterly estimated tax (April 15, June 15, September 15, January 18, 2028), Form 2290 (August 31) and UCR, plus your insurance, medical card, plates and inspections. Amber 30 days out, red 7 days out.

A dashboard you can read from the cab

• One phone-width page: traffic-light tiles for profit, profit per day, real rate vs cost per mile, empty miles and money overdue.
• Week-by-week revenue bars against your break-even line.
• Where every dollar goes: fuel, truck payments, insurance, repairs and what's left for you.
• Money owed by age (0–30, 31–60, 61+ days) and your next deadlines.

Works with

For box trucks, cargo vans, Sprinters, hotshots and semis. Microsoft Excel, Google Sheets (free, and works in the Sheets app on your phone) and Apple Numbers, in $. Instant download, one-off purchase, no subscription.

IFTA tax rates change every quarter, so you copy that quarter's rates from iftach.org: we never build in rates that could go out of date. Not tax or legal advice: check your figures with a tax professional.

Try the free load profit calculator and factoring cost calculator first.