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

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 km, 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 km on every load, with empty km 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 in km and litres, the long-haul meal claim (CRA simplified method, 80% deductible), and expenses with their T2125 heading.
• Compliance & service: 2027 IFTA return dates, CRA instalments and the June 15 self-employed filing deadline, 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 km, empty km 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 CA$. 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.