Cellwise Start free

Free Excel template · Excel for trucking

Free trucking load tracker template

For owner-operators and dispatchers who want a month of loads in one place. Log each load with the broker, loaded and deadhead miles, pay and tolls, and the template works out the rate per total mile and the profit on every load, month totals, results by broker, your deadhead share, and how many loads fell short of your target profit. It also names the load that paid least per mile.

cellwise-trucking-load-tracker.xlsxExcel workbook · 5.3 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup
Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

RowABCDEFGHI
1Trucking load tracker
2MonthNov 1, 2026
3Cost per mile (all miles)$1.42
4Target profit per mile$0.40
5
6DateLoad #BrokerLoaded miDeadhead miPayTolls, lumperRate / total miProfit
7Nov 2, 2026L-2201Ridgeway61248$1,650.00$0.00$2.50$712.80
8Nov 3, 2026L-2202Blue Lake43895$1,120.00$22.00$2.10$341.14
9Nov 5, 2026L-2203Harbor80530$2,210.00$0.00$2.65$1,024.30
10Nov 6, 2026L-2204Ridgeway290140$780.00$14.00$1.81$155.40
11Nov 9, 2026L-2205Blue Lake1,04060$2,650.00$38.00$2.41$1,050.00
12Nov 11, 2026L-2206Harbor52025$1,480.00$0.00$2.72$706.10
13Nov 12, 2026L-2207Ridgeway375110$900.00$0.00$1.86$211.30
14Nov 16, 2026L-2208Blue Lake69040$1,890.00$26.00$2.59$827.40
15Nov 18, 2026L-2209Harbor455180$1,050.00$0.00$1.65$148.30
16Nov 20, 2026L-2210Ridgeway93055$2,420.00$31.00$2.46$990.30
17Nov 23, 2026L-2211Harbor61070$1,720.00$0.00$2.53$754.40
18Nov 24, 2026L-2212Blue Lake380120$940.00$18.00$1.88$212.00
19Nov 27, 2026L-2213Ridgeway72035$1,980.00$12.00$2.62$895.90
20Nov 30, 2026L-2214Harbor50565$1,310.00$0.00$2.30$500.60
21Month total8,3701,073$22,100.00$161.00$2.34$8,529.94
22
23BrokerLoadsTotal milesPayRate / total miProfit
24Ridgeway53,3157,730$2.33$2,965.70
25Blue Lake42,8636,600$2.31$2,430.54
26Harbor53,2657,770$2.38$3,133.70
27
28Deadhead share of miles11%
29Rate per loaded mile$2.64
30Profit per total mile$0.90
31Loads under target profit2
32Weakest loadL-2209

How the formulas work

Rate per total mile on each load

H7=IF(D7+E7>0,ROUND(F7/(D7+E7),2),0)

Pay divided by loaded plus deadhead miles. It is the rate to compare with your cost per mile, because the truck burns fuel on every mile. The IF keeps empty rows at 0 instead of #DIV/0!.

Profit per load

I7=ROUND(F7-G7-(D7+E7)*$B$3,2)

Pay, minus tolls and lumper fees, minus all the load's miles times your cost per mile in B3. The $ signs keep B3 fixed when you fill the formula down. Work B3 out with the cost per mile calculator and update it when fuel or your fixed costs change.

Results by broker

E24=IF(C24>0,ROUND(D24/C24,2),0)

Total pay from the broker divided by total miles on their loads (two SUMIFs in C24 add loaded and deadhead miles). This weights every load by its miles, so one short load does not skew the broker's average. Add a row for each broker you haul for.

Loads under your target profit

B31=SUMPRODUCT(--(I7:I20<(D7:D20+E7:E20)*B4))

For each load, is the profit less than its miles times your target profit per mile? The -- turns TRUE and FALSE into 1 and 0 and SUMPRODUCT adds them: 2 of the 14 loads (L-2204 and L-2209) miss a $0.40 target, even though the month as a whole makes $0.90 a mile. B32 names the weakest load by rate per mile, L-2209 at $1.65.

Make it yours

FAQ

How do I track loads in Excel?

Give each load one row with the date, load number, broker, loaded miles, deadhead miles, pay and tolls. Then add formulas for rate per mile and profit, like this template, and totals at the bottom with SUM and SUMIF.

How do I calculate profit per load in trucking?

Subtract tolls and lumper fees, then subtract all the load's miles (loaded plus deadhead) times your cost per mile: =pay-tolls-(loaded+deadhead)*cost_per_mile.

How do I calculate deadhead percentage in Excel?

Divide total deadhead miles by total miles, loaded plus deadhead: =SUM(deadhead)/(SUM(loaded)+SUM(deadhead)). Format it as a percentage. Here it is 11.4% for the month.

Functions used

Related guides

More free templates

Updated