Trucking Income Statement Template

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.

Come back each month to enter actuals. The real value shows up when you start comparing months: is your fuel CPM creeping up while your RPM holds flat? Is your operating ratio trending above 95% — the threshold where margins get dangerously thin? These are the signals that get missed when you're running off bank statements alone. Most carriers who use this template say the monthly review takes 20 minutes and surfaces cost problems before they compound.

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.

The per-mile lens is what makes trucking financials actionable. A $15,000 monthly fuel bill means nothing without knowing how many miles you drove. A $0.52 fuel CPM against a $1.85 RPM tells you exactly where you stand. This template is built around that framework: report your income statement the standard way for accounting and tax purposes, but also view every major cost as a per-mile figure so you can benchmark against industry averages — typically $0.45–0.65 fuel CPM, $0.65–0.85 driver CPM, and a target operating ratio below 92–95% for a healthy carrier.