Trucking Spreadsheet for Excel, Owner Operator Bookkeeping, Cost Per Mile Calculator, Load and Fuel Tracker, Truck Expense Log
Price:$20.99
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
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
More from this shop
Visit shop-
Digital download
Personal Finance Planner Spreadsheet for Excel, Yearly Budget Plan vs Actual, Savings Goals, Debt Payoff and Net Worth Tracker
$12.99
-
Digital download
Business Expense Tracker Spreadsheet for Excel, Receipt Tracker, Mileage Log, Quarterly Expense Report, Small Business Template
$8.99
-
Digital download
Contractor Job Costing Spreadsheet for Excel, Construction Estimate Template, Job Profit Tracker, Budget vs Actual, Quote Template
$24.99
-
Digital download
Sinking Funds Tracker Spreadsheet for Excel, Monthly Set Aside Calculator, Irregular Expenses Planner, Savings for Bills and Gifts
$8.99
Be the first to leave a review
-
Digital download
Trucking Spreadsheet, Load Booking Calculator, IFTA Fuel Tax Reporting, Profit Loss Report, Mileage Tracker, Financial Analysis
Sale Price $16.27
Original Price $25.03
-
Digital download
Owner Operator Trucking Expenses Spreadsheet | Truck Driver Income Tracker | Trucking Profit & Loss Excel Template
Sale Price $25.49
Original Price $50.98
-
Digital download
Trucking Bookkeeping Excel Template: Income, Expense & Profit Tracker
Sale Price $25.49
Original Price $50.98
-
Digital download
Trucking Business Expenses Spreadsheet | Easy Monthly Excel Bookkeeping Tool for Owner Operators & Fleet Owners
Sale Price $25.49
Original Price $50.98
-
Digital download
The Definitive "All-in-One" Trucking Business Spreadsheet
$24.99
-
Digital download
Trucking Profit and Loss Spreadsheet: Trucker Business Accounting, Trucking Template
$24.99
-
Digital download
Trucking Bookkeeping Spreadsheet | Excel Template for Truckers | Track Income, Expenses, Profit & Loss Easily
Sale Price $25.49
Original Price $50.98
-
Digital download
Trucking Bookkeeping Excel Template: Income & Expense Tracker
Sale Price $25.49
Original Price $50.98
-
Digital download
Trucking Income and Expense Excel Template: Accounting Bookkeeping Spreadsheet
Sale Price $25.49
Original Price $50.98
-
Digital download
Trucking Income and Expense Excel Spreadsheet: Profit & Loss Template
Sale Price $25.49
Original Price $50.98
-
Digital download
Trucking Income & Expense Spreadsheet (Excel)
Sale Price $25.49
Original Price $50.98
-
Digital download
Trucking Income and Expense Excel Spreadsheet: Profit and Loss Template
Sale Price $25.49
Original Price $50.98
Shoppers with similar taste loved these
-
Digital download
Tax Prep Instagram Carousel Templates: Black & Red Canva Flyers (25 Posts)
Sale Price $7.76
Original Price $15.51
-
Digital download
Blue & Gold Tax Prep Canva Templates, Social Media Bundle (Digital Download)
$10.99
-
Digital download
10 Tax Prep Bundle, Tax Prep Instagram, Tax Prep Flyer Bundle, Tax Flyer Template, Prep Flyers Bundle, Tax Prep Templates, Tax Preparation
Sale Price $13.00
Original Price $20.00
-
Digital download
50 Christmas Tax Prep Bundle | Christmas Tax Prep Flyer | Tax Prep Flyer 2025 | Tax Prep Templates | Tax Prep Flyer Bundle | Christmas Flyer
Sale Price $7.22
Original Price $18.05
-
Digital download
Tax Prep Flyer Template Bundle | DIY Canva Branding (Digital Download)
$10.99
-
Digital download
Tax Prep Bundle, Tax Prep Instagram, Tax Prep Flyer Bundle, Tax Flyer Template, Prep Flyers Bundle, Tax Prep Templates, Tax Preparation Post
Sale Price $13.00
Original Price $20.00
-
Digital download
Tax Professional | Tax Flyer | Tax Prep Flyer | Tax Prep Template | Summer Tax Flyer | Tax Specialist | Financial Planning | Tax Season
Sale Price $6.50
Original Price $10.00
-
Digital download
Tax Prep Flyer Bundle: Professional Marketing Templates
$6.00
-
Digital download
160 Tax Prep Instagram Reels With Text | Accountant | Bookkeeper Canva Templates | Tax Prep Posts & Checklist | Taxprep Tiktok Reels
Sale Price $11.01
Original Price $27.52
-
Digital download
20 Tax Social Media Post Templates, Tax Preparer Marketing Bundle, Tax Season Canva Templates, Tax Business Social Media Kit
$19.99
-
Digital download
Purple Tax Prep Marketing Kit Bundle, 70+ Canva Templates for Tax Preparers, Tax Season Flyers, Banners, Website, Brochure, Canva Editable
Sale Price $16.50
Original Price $33.00
-
Digital download
6 Fully Editable Tax Prep Service Flyers, 2026 Tax Season Flyers, Income Tax Preparer Flyers, Accounting Services Flyers, Canva Template
$10.00