▶
▶Trucking Bookkeeping
Owner-operator money, mile by mile.
5.0shop rating · 6 Etsy reviewsOwner-operator bookkeeping that actually knows trucking: every load's rate per mile over loaded and deadhead miles, checked against your cost per mile, plus broker invoices, profit and loss, and every expense tagged to a Schedule C tax line — across 10 connected tabs.
- Every load checked against your cost per mile
- Load / trip profit tracker
- Broker invoices: paid, unpaid and overdue
- Tagged to Schedule C tax lines
- Comes in Colorful, Light & Dark — all three included
Overview
Know which loads really pay
Most bookkeeping templates weren't built for a truck. This one is: type your all-in cost per mile once, and every load you log shows its rate per mile over loaded and deadhead miles, its net after fuel, and whether it beats your number.
Every expense is tagged to the Schedule C line it belongs on, and the Tax Summary estimates your self-employment tax and an income-tax set-aside — so year-end is a copy-and-paste, not a scramble. Type in the highlighted cells and the dashboard does the rest.
It also comes in three looks — Colorful, Light and Dark. Use the color switch on this page to preview each one; every purchase includes all three, so you can pick the style that fits you.
What's Included
10 connected tabs built for the road
- The Excel workbook (.xlsx) in all three colors — Colorful, Light & Dark — each also opens in Google Sheets
- A step-by-step Quick-Start guide (PDF)
- A link to an in-depth video walkthrough on YouTube
- Free lifetime updates & friendly support — message anytime
Key Benefits
Why this one, not a free template
Set your all-in cost per mile once; each load shows whether its rate per mile beats it.
The load tracker divides the pay by loaded and deadhead miles and shows the net after fuel, not just the rate.
The Tax Summary estimates self-employment tax and an income-tax set-aside from your net profit.
Expenses are tagged to tax lines, so filing is a copy-and-paste.
Log from the cab in Sheets on your phone, or reconcile at home in Excel.
Colorful, Light or Dark — pick your look. All three included.
Who It's For
Built for owner-operators
- Owner-operators who want to know which loads pay
- Drivers tired of guessing which loads pay
- Anyone who dreads Schedule C season
- Small fleets keeping their own books
How It Works
Up and running in three steps
Open the .xlsx in Excel, or upload it to Google Drive and open with Google Sheets.
Type your all-in cost per mile, tax set-aside and broker list once on the Settings tab.
Enter settlements, expenses and each load's miles — rate per mile, load profit, P&L and the tax estimate calculate themselves.
Why It's Different
Bookkeeping that speaks trucking
Generic bookkeeping sheets don't know what a deadhead mile is, so you end up doing the trucking math by hand. This one is built around rate per mile, load profit and the Schedule C owner-operators actually file. Filing IFTA? That's a separate return: the IFTA Quarterly Fuel Tax Tracker does it by state.
Because it's a spreadsheet you own, you can adjust it to your lanes and costs — and it never expires or asks for a subscription.
Delivery & Compatibility
Instant, and works with what you use
As soon as your order is complete you get instant access to download the spreadsheet, plus a copy by email. Prefer Google Sheets for real-time updates and dropdowns? It's fully optimized. More comfortable in Excel? It works just as well.
Built and tested in the latest Excel (Office 365). On Mac we recommend the Google Sheets version — the template is not compatible with Apple Numbers. Available in English. The workbook arrives with sample data filled in so you can see how it works; type over it with your own.
FAQ
Questions, answered
What formats does it come in?
Both Excel (.xlsx) and Google Sheets. If you're on a Mac, note that Apple Numbers isn't supported — use Excel for Mac or the Google Sheets version.
Does it come in different colors?
Yes — every purchase includes three color versions: Colorful, Light and Dark. Preview them with the color switch near the top of the page, and you'll receive all three in your download (for both Excel and Google Sheets).
Do I need a subscription or special software?
No. It's a one-time purchase with no subscription. It works in Excel or in free Google Sheets — nothing else to install.
How do I receive it after purchase?
Instantly. After secure Stripe checkout you're taken to a download page, and you also receive an email with your download link.
Are there instructions or a tutorial?
Yes — a Quick-Start PDF is included, plus a full video walkthrough on our YouTube channel. You can message us anytime with questions.
Do I have to build any formulas?
Never. Type only in the highlighted cells; every dashboard, tab, total and chart calculates itself.
Can I resell or use it commercially?
It's licensed for personal use only. Reselling, sharing or redistributing the file isn't permitted. See our Terms for details.
What's your refund policy?
Because it's an instant digital download, please review the details above before buying. Full details are on our Refunds page.
For personal use only. This template is for informational purposes and is not financial, tax or legal advice. © 2026 NicheToolkitHub — no resale or redistribution.
