Trucking Sales Forecast Template

Download the file and open it in Excel or Google Sheets — no macros required. Start on the Revenue Assumptions sheet and fill in your current operating numbers: how many trucks you're running, your average loads per week, typical loaded miles per trip, and your current linehaul rate per mile. If you have a fuel surcharge, enter the rate or dollar amount per mile. The Monthly Forecast sheet will populate immediately from those inputs, so you'll have a rough full-year projection within the first 15 minutes.

Once the base numbers look right, adjust the seasonality row in the Monthly Forecast sheet to match how your freight lanes actually move through the year. If you haul produce, your Q2 and Q3 might be your strongest months. If you run retail freight, Q4 is peak and January is slow. Adjust each month's multiplier up or down from 1.0 to reflect that pattern — the rest of the formulas handle the math. Then fill in the Scenario Planning sheet with your upside assumptions (getting that dedicated lane, adding a truck) and your downside assumptions (rate erosion, market softness).

Use the Actual vs Forecast sheet every month after closing. Pull your invoiced revenue, actual miles driven, and collected fuel surcharge from your TMS or dispatch records and enter them alongside the forecast. The variance columns will show you immediately whether you're outperforming or underperforming your plan — and which revenue line is driving the gap. Most carriers who track this monthly say it takes under 30 minutes and makes their quarterly conversations with lenders and accountants much more straightforward.

Trucking revenue is deceptively simple on the surface — you move freight from A to B and get paid a rate per mile — but the actual P&L depends on a web of variables that move constantly. Spot rates swing with the freight market, fuel surcharge revenue changes weekly, accessorial charges get disputed, and deadhead miles eat into your effective RPM without showing up clearly in your dispatch records. Without a structured forecast, most carriers find out whether a month was profitable only after the fact, when it's too late to adjust.

A driver-based sales forecast grounds your revenue projections in the numbers you can actually control: load count per truck, average loaded miles, and the rate per mile you're negotiating or bidding. Industry benchmarks vary widely by lane type and equipment — dry van carriers typically run RPMs between $1.80 and $2.40 depending on market conditions, while flatbed and refrigerated freight can run higher. Fuel surcharge typically adds 8–15% on top of linehaul depending on diesel prices. Tracking those streams separately in your forecast means you can see clearly when a revenue shift is a rate problem versus a utilization problem.

The most useful thing a trucking sales forecast does is force a comparison between what you planned and what happened. Carriers who do this monthly — even informally — catch underperforming lanes faster, adjust their load acceptance criteria before margins erode, and have the documentation lenders want when they're financing new equipment. This template is built to support that workflow: set your assumptions, project your revenue, enter your actuals, and use the variance data to make better decisions in the following month.