Excel workbook
Owner-Operator Trucking Tracker: Loads, Cost Per Mile, Fuel and Miles by State
Know your cost per mile, which loads pay, who owes you and the miles and gallons by state for your quarterly return.
$39 one time · example and blank copies · download link by email
Who it is for
Owner-operators and small fleets of one to five trucks.
Why it is different
- It starts from cost per mile, so you can see which loads actually pay.
- The fuel-tax worksheet uses a rate table you fill in from the official source, so the numbers are yours to confirm.
- A filled example with three invented trucks and a blank copy with all formulas working.
What is inside
- Start Here. How to use it and the limits.
- Setup. Trucks, fixed monthly costs, target profit per mile and a fuel-tax rate table that you fill in from the official source.
- Loads. Up to 400 loads with miles, revenue, deadhead percentage and profit per mile, flagged against your target.
- Fuel. Fill-ups by truck and state.
- Mileage by State. Miles by state and a quarterly worksheet of net taxable gallons and net tax by state, using your rates.
- Expenses. Maintenance, tires, tolls, scales, insurance, permits and more.
- Cost Per Mile. Monthly cost per mile by truck, with a chart.
- Receivables. Unpaid loads grouped by age.
- Quarter Summary. Revenue, miles, fuel and costs by quarter.
- Checks. Flags mismatched miles, missing states, unknown trucks and similar problems.
A look inside
Example data, real formulas
Get it
Owner-Operator Trucking Income, Expense and Fuel-Tax Log
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. A worksheet to help you prepare. It contains no real fuel-tax rates in the blank file; the example file uses invented placeholder rates. Confirm every figure and rate against the official forms and instructions. Not tax, legal or accounting advice. Tested by recalculation and by checking sample figures; not opened in every version of Excel. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Free starter
Try a free one-tab version first
A small working Excel file with the same kind of math, filled with made-up example numbers you can type over. We send one confirmation email, and no series follows.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others