Description
Full Walkthrough
Log box truck loads, fuel and expenses. See rate per mile, cost per mile, deadhead %, MPG, unpaid invoices and monthly P&L, with an optional IFTA tab.
Who it’s for
Box truck owners and small fleets (1 to 6 trucks) who want rate per mile and cost per mile without paying for trucking software.
What’s inside
- Dashboard: Revenue, net profit, rate per mile, cost per mile, deadhead %, unpaid invoices, charts and a broker scorecard
- Loads: Load log with revenue, total miles, deadhead %, rate per mile, est. fuel, factoring fee and net per mile
- Fuel: Fuel log with cost, miles since last fill and MPG per truck, and the gallons by state that IFTA needs
- Expenses: Every operating expense by truck, category and load
- Monthly P&L: 12-month profit and loss with fixed costs, revenue / cost / profit per mile
- IFTA: Quarterly miles by state against gallons bought, net taxable gallons and estimated tax due or credit
- Settings: Currency, MPG, fuel price, factoring %, fixed costs, brokers, trucks and categories
What you get
- The .xlsx workbook with sample data that’s easy to clear
- Setup Guide PDF, with every tab explained
- A video walkthrough
FAQ
Does it work in Google Sheets?
Yes. Upload it to Google Drive, open it with Google Sheets, then choose File > Save as Google Sheets.
Which Excel version do I need?
Excel 2019 or newer, Microsoft 365 or Excel for Mac.
Is this a subscription?
No. You pay once and keep the file. No macros, no add-ons.
The IFTA tab is optional and an estimate. Trucks under 26,001 lb usually don't file IFTA, so check your own rules. Not tax advice.
This is a digital product. No physical item will be shipped.
Also on Gumroad: Box Truck Business Load, Profit & Expense Tracker on Gumroad
Build your own store: Hostinger WordPress hosting (affiliate link: I may earn a commission at no extra cost to you)
