Trucking P&L Template

Download the .xlsx file and open it in Excel or Google Sheets — no macros or add-ins required. Start with the Monthly P&L sheet and review the pre-loaded revenue and expense categories. Most trucking operations can use the template as-is with minor adjustments: rename accessorial charge types to match what you bill, add or remove equipment payment rows if you run more or fewer trucks, and adjust the driver pay structure to match whether you pay per mile, hourly, or by percentage of load. Initial setup typically takes 15–20 minutes.

Each month, pull your freight invoices, fuel receipts, and expense records and enter the totals by category. If you use transportation management software (TMS) or an ERP, most can export a monthly expense summary you can use as your source. Fill in your total miles driven for the month in the Per-Mile Cost Tracker sheet — that unlocks the CPM and RPM calculations that tell you what each loaded and empty mile actually costs. These numbers are the foundation of good rate negotiation and load selection.

Review the template at month close — it takes 20–30 minutes once you're in the habit. The operating ratio is the number to watch: anything under 90% means you're keeping at least 10 cents of profit per dollar of revenue. Trucking operators who monitor their P&L monthly spot fuel cost creep, underperforming lanes, and driver settlement discrepancies weeks earlier than those who only look at financials at tax time. After a few months of data, the Annual P&L sheet gives you a seasonal view that makes load planning and rate negotiation significantly more informed.

Trucking runs on thinner margins than most industries realize — the average net profit margin for carriers sits between 2.5% and 8%, and fuel alone can consume 25–35% of revenue in a given month. At those margins, a 2-cent rise in diesel prices, an unscheduled breakdown, or a month of running too many empty miles can flip a profitable quarter into a break-even one. Without a structured P&L to review each month, those problems stay invisible until they've already done their damage.

A trucking P&L has a specific structure that generic business templates don't reflect. Revenue needs to separate linehaul freight from fuel surcharges, because fuel surcharges are meant to offset fuel costs — if your fuel surcharge revenue and actual fuel costs are misaligned, you're either leaving money on the table or billing incorrectly. Accessorial charges (detention, layover, TONU) are often the most overlooked revenue category, and they matter more as freight markets tighten. On the cost side, expenses need to track per mile — not just as monthly totals — because the measure that drives profitability decisions in trucking is cost per mile, not cost per month.

The operating ratio is the number carriers and owner-operators use to benchmark performance: total operating expenses divided by total revenue, expressed as a percentage. An operating ratio of 85–90% is considered healthy for most asset-based carriers. When that number starts climbing toward 95% or above, the P&L usually shows exactly where it's coming from — fuel efficiency dropping, maintenance costs spiking after aging equipment, or lanes that generate low revenue per mile relative to their costs. This template is built to surface those patterns quickly so you can make load selection, rate negotiation, and equipment decisions based on data rather than instinct.