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.
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.
| Row | A | B | C | D | E | F | G | H | I |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Trucking load tracker | ||||||||
| 2 | Month | Nov 1, 2026 | |||||||
| 3 | Cost per mile (all miles) | $1.42 | |||||||
| 4 | Target profit per mile | $0.40 | |||||||
| 5 | |||||||||
| 6 | Date | Load # | Broker | Loaded mi | Deadhead mi | Pay | Tolls, lumper | Rate / total mi | Profit |
| 7 | Nov 2, 2026 | L-2201 | Ridgeway | 612 | 48 | $1,650.00 | $0.00 | $2.50 | $712.80 |
| 8 | Nov 3, 2026 | L-2202 | Blue Lake | 438 | 95 | $1,120.00 | $22.00 | $2.10 | $341.14 |
| 9 | Nov 5, 2026 | L-2203 | Harbor | 805 | 30 | $2,210.00 | $0.00 | $2.65 | $1,024.30 |
| 10 | Nov 6, 2026 | L-2204 | Ridgeway | 290 | 140 | $780.00 | $14.00 | $1.81 | $155.40 |
| 11 | Nov 9, 2026 | L-2205 | Blue Lake | 1,040 | 60 | $2,650.00 | $38.00 | $2.41 | $1,050.00 |
| 12 | Nov 11, 2026 | L-2206 | Harbor | 520 | 25 | $1,480.00 | $0.00 | $2.72 | $706.10 |
| 13 | Nov 12, 2026 | L-2207 | Ridgeway | 375 | 110 | $900.00 | $0.00 | $1.86 | $211.30 |
| 14 | Nov 16, 2026 | L-2208 | Blue Lake | 690 | 40 | $1,890.00 | $26.00 | $2.59 | $827.40 |
| 15 | Nov 18, 2026 | L-2209 | Harbor | 455 | 180 | $1,050.00 | $0.00 | $1.65 | $148.30 |
| 16 | Nov 20, 2026 | L-2210 | Ridgeway | 930 | 55 | $2,420.00 | $31.00 | $2.46 | $990.30 |
| 17 | Nov 23, 2026 | L-2211 | Harbor | 610 | 70 | $1,720.00 | $0.00 | $2.53 | $754.40 |
| 18 | Nov 24, 2026 | L-2212 | Blue Lake | 380 | 120 | $940.00 | $18.00 | $1.88 | $212.00 |
| 19 | Nov 27, 2026 | L-2213 | Ridgeway | 720 | 35 | $1,980.00 | $12.00 | $2.62 | $895.90 |
| 20 | Nov 30, 2026 | L-2214 | Harbor | 505 | 65 | $1,310.00 | $0.00 | $2.30 | $500.60 |
| 21 | Month total | 8,370 | 1,073 | $22,100.00 | $161.00 | $2.34 | $8,529.94 | ||
| 22 | |||||||||
| 23 | Broker | Loads | Total miles | Pay | Rate / total mi | Profit | |||
| 24 | Ridgeway | 5 | 3,315 | 7,730 | $2.33 | $2,965.70 | |||
| 25 | Blue Lake | 4 | 2,863 | 6,600 | $2.31 | $2,430.54 | |||
| 26 | Harbor | 5 | 3,265 | 7,770 | $2.38 | $3,133.70 | |||
| 27 | |||||||||
| 28 | Deadhead share of miles | 11% | |||||||
| 29 | Rate per loaded mile | $2.64 | |||||||
| 30 | Profit per total mile | $0.90 | |||||||
| 31 | Loads under target profit | 2 | |||||||
| 32 | Weakest load | L-2209 |
How the formulas work
Rate per total mile on each load
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
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
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
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
- Add a Lane or Origin-Destination column to spot which runs end where there is no freight. High deadhead after a lane is the warning sign.
- Keep fuel surcharge inside the Pay column if your pay includes it, so the rate per mile compares with a cost per mile that includes fuel.
- Turn the log into a table (Ctrl+T) so new rows pick up the formulas, and filter by broker or month.
- Start a new copy each month and keep the month totals on a summary sheet to see the trend in rate and deadhead.
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
SUMAdds numbersIFPicks a result from a testROUNDRounds to digitsSUMIFAdds cells that matchCOUNTIFCounts cells that matchSUMPRODUCTMultiply then addINDEXValue at a positionMATCHPosition of a valueMINSmallest number
Related guides
- SUMIF vs SUMIFS: what is the difference?
- How to calculate profit margin in Excel
- SUMPRODUCT in Excel: what it does and how to use it
- How to use the INDEX MATCH formula in Excel
More free templates
- Trucking cost per mile calculator templateFor owner-operators and small fleet owners who want to know their real cost per mile and the lowest rate worth taking.Free .xlsx
- Employee expense report template for ExcelFor employees who need to claim back business costs, and for the managers and bookkeepers who check those claims.Free .xlsx
- Purchase order template for Excel (PO form with sample)A simple purchase order form for small businesses, office managers and buyers who send POs to suppliers and want to track what actually arrives.Free .xlsx
- Accounts receivable aging report templateFor owners, bookkeepers and credit controllers who invoice customers on terms and need to see who owes what and for how long.Free .xlsx
Updated