Report this item to Etsy

Trucking Spreadsheet for Excel, Owner Operator Bookkeeping, Cost Per Mile Calculator, Load and Fuel Tracker, Truck Expense Log

Price:$20.99

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by SteadyBooks
  • Digital download
  • Digital file type(s): 1 ZIP

Run your truck like a business. Log every load with loaded and deadhead miles, linehaul, fuel surcharge and accessorials, every fill-up and every expense - and the workbook shows revenue after factoring, total costs, profit and what each mile really earns and costs. See your MPG, deadhead share, unpaid loads and the fixed costs you must cover every month.

WHY YOU WILL LIKE IT
- Know your true cost per mile and profit per mile.
- Quote loads with confidence - you know your break-even rate.
- Spot unpaid loads before they become a cash problem.
- Watch fuel, MPG and deadhead miles month by month.
- Everything your accountant needs at tax time, by category.

FEATURES
- Load log for 500 loads: loaded and deadhead miles, linehaul, fuel surcharge, accessorials, factoring % and paid status
- Gross and net revenue after factoring, revenue per mile and rate per loaded mile for every load
- Fuel log for 600 fill-ups with gallons, cost, DEF and price per gallon
- Expense log for 500 costs in 14 trucking categories, each tagged fixed or variable
- Dashboard: net revenue, total costs, profit, and revenue, cost and profit per mile
- Miles, MPG, deadhead %, unpaid loads, cost per mile by category and fixed costs per month
- 3 automatic charts: revenue vs costs, profit per mile by month, cost per mile by category
- Row checks for missing dates, pay, miles and gallons, and unpaid loads highlighted

EXAMPLE (fictional sample data)
In the fictional sample, an owner-operator earned $156,614.94 of net revenue against $79,495.56 of costs by early November, a profit of $77,119.38. That is $1.29 profit per mile, with 6.60 MPG and $3,754 of fixed costs to cover every month.

WHAT'S INCLUDED
- Trucking-Bookkeeping.xlsx - blank workbook with 14 trucking expense categories
- Trucking-Bookkeeping-SAMPLE.xlsx - the same workbook with a fictional owner-operator year
- User-Guide.pdf - getting started, how per-mile numbers work and Google Sheets steps
- Weekly-Trucking-Routine.csv - a weekly paperwork routine
- README.txt - quick start

HOW TO USE
1. Download the ZIP after purchase and unzip it.
2. Open Trucking-Bookkeeping.xlsx in Excel (or upload it to Google Drive and save as Google Sheets).
3. Set the year and factoring rate, then log loads, fuel and expenses as you go.

COMPATIBILITY
- Microsoft Excel (desktop): tested in Microsoft 365 for Windows. Uses features available since Excel 2013.
- Google Sheets: built only with formulas that Google Sheets also supports; upload the .xlsx to Google Drive and choose File > Save as Google Sheets. Live Google Sheets testing is pending - see the note in the guide.
- Not tested in Apple Numbers, LibreOffice or Excel for Mac.

PLEASE NOTE
This is a digital download - no physical product will be shipped. Please read the description and compatibility notes before purchasing. Sample company, lanes and amounts are fictional. A bookkeeping tool, not tax or legal advice; it does not prepare IFTA or IRP reports.

FAQ
Does it do IFTA?
No. IFTA reports need the miles you drove in each state, which this workbook does not track. Fuel purchases are logged with the state for your records.

Does it handle factoring?
Yes. Set your factoring rate on Settings (or per load) and the fee comes off each load's revenue.

Is it for fleets?
It is built for one truck or a small fleet treated as one business. Use one copy per truck to compare trucks.

What are fixed and variable costs?
Fixed costs (truck payment, insurance, permits) are owed even when you are not running; variable costs grow with miles. You can change which is which.

How many loads?
Up to 500 loads, 600 fill-ups and 500 expenses per year.

Will I receive a physical item?
No. This is an instant digital download.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Nov 15, 2026