Trucking Income Statement Template
Track freight revenue, fuel surcharges, driver wages, and operating costs in one income statement built for trucking companies and owner-operators.
What's Inside This Trucking Income Statement Template
This template includes 4 worksheets, each designed for a specific part of your trucking financial workflow:
Monthly Income Statement
The core worksheet where you report each month's revenue and expenses using trucking-specific line items.
Annual Summary
A 12-month rollup that pulls from each monthly sheet automatically, giving you a full-year view of revenue by category, total expenses by line item, and net income across the year.
Per-Mile Analysis
A dedicated worksheet that calculates cost per mile (CPM) and revenue per mile (RPM) for each month and for the full year.
Dashboard
A visual summary with pre-built charts showing revenue trends by month, expense breakdowns by category, operating ratio over time, and fuel cost as a percentage of revenue.
Trucking Income Statement Template Features
- Revenue broken out by linehaul, fuel surcharge, accessorials, and contract lanes
- Driver wages and owner-operator settlements tracked separately
- Per-mile analysis: CPM, RPM, and operating ratio auto-calculated
- Monthly income statement with 12-month annual rollup
- Fuel cost percentage and operating ratio KPIs built in
- Visual dashboard with charts for revenue trends and expense breakdown
How to Use This Trucking Income Statement Spreadsheet
Getting started takes about 15 minutes. Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Start with the Monthly Income Statement sheet: review the pre-loaded revenue and expense categories and adjust any line items that don't match your operation. Owner-operators running a single truck will use fewer categories than a small fleet carrier — the structure works for both.
Once the categories look right, enter your revenue and expenses for the current month. Pull the numbers from your load board reports, fuel receipts, and settlement statements. If you use a factoring company, note the factoring fee as a separate line under administrative expenses. Enter your total miles driven in the Per-Mile Analysis sheet and the CPM and RPM calculations update automatically. Copy the monthly structure forward for future months as you go.
15 minutes from download to your first income statement
Download the template, plug in your freight revenue and costs, and see your trucking operation's full financial picture — monthly statement, annual rollup, and per-mile analysis included.
Why Every Trucking Company Needs an Income Statement Template
Trucking is a margin-sensitive business. Gross margins typically run 12–20%, but once you subtract driver pay, fuel, insurance, and equipment costs, net margins land between 2.5–8%. At those levels, a 5% increase in fuel prices or a diesel surcharge that doesn't keep pace with actual fuel costs can wipe out a month of profit entirely. Most owner-operators and small carriers know their revenue from load confirmations, but they don't see their true cost picture until tax season — which is too late to do anything about it.
A trucking income statement needs to reflect how the business actually generates and spends money. On the revenue side, that means separating linehaul rates from fuel surcharges and accessorials — because fuel surcharge revenue should roughly offset fuel costs, and if it doesn't, that gap is a strategic problem, not an accounting detail. On the cost side, it means tracking fuel, driver settlements, maintenance, insurance, and equipment separately, because each of those lines behaves differently and requires a different operational response when it starts to move.
Trucking Industry at a Glance
Financial templates built for trucking companies and owner-operators — pre-loaded with freight billing, fuel surcharge, and per-mile cost categories.
Revenue Drivers
- Linehaul freight rates
- Fuel surcharge revenue
- Accessorial charges
- Dedicated contract lanes
Key Cost Categories
- Driver wages & settlements
- Fuel
- Maintenance & repairs
- Insurance (liability, cargo, physical damage)
- Equipment payments & depreciation
- Permits & compliance fees
Typical Margins
Gross: 12-20% · Net: 2.5-8%
Seasonality
Peak freight volumes in August–October (back-to-school and holiday restocking) and late November–December. Slowest in January–March post-holiday.
Key Performance Indicators
Trucking Income Statement Template FAQ
More Trucking Templates
Trucking Balance Sheet Template for Excel
$29
Trucking Budget Template for Excel
$29
Trucking Business Plan Template for Excel
$39
Trucking Cash Flow Template for Excel
$29
Trucking Expense Tracker Template for Excel
$29
Trucking Financial Model Template for Excel
$29
Trucking Invoice Template for Excel
$29
Trucking KPI Dashboard Template for Excel
$29
Trucking P&L Template for Excel
$29
Trucking Pro Forma Template for Excel
$29
Trucking Project Budget Template for Excel
$29
Trucking Sales Forecast Template for Excel
$29
Trucking Company Valuation Template for Excel
$29
More Income Statement Templates
Accounting Firm Income Statement Template for Excel
$29
Auto Repair Income Statement Template for Excel
$29
Car Wash Income Statement Template for Excel
$29
Church Income Statement Template for Excel
$29
Cleaning Service Income Statement Template for Excel
$29
Coffee Shop Income Statement Template for Excel
$29
Trucking Income Statement Template
$29