Total fleet profit equals average profit per truck multiplied by the number of trucks included in that average—provided both figures use the same reporting period, truck roster, and cost definition. If shared expenses sit outside the truck-level entries, subtract those expenses before comparing the average with the fleet’s bottom line.
The key is consistency: an average based on revenue-producing trucks cannot directly reconcile with a total that also includes idle-truck costs. Likewise, truck-level results before office overhead cannot reconcile with fleet profit after that overhead without an adjustment.
Establish What “Profit” Includes
For this reconciliation, start with a clearly defined truck-level result:
[
P_i = R_i – C_i
]
Here, (P_i) is the result for truck (i), (R_i) is its revenue, and (C_i) is its included costs. All amounts must cover the same reporting period and use the same currency.
The subtraction alone does not establish whether the result is contribution margin, operating profit, or net income. That depends on which expenses you include. The SEC’s financial-statement guide distinguishes operating profit from net income and explains why profit also differs from cash flow.
Before adding the truck rows, document these boundaries:
- Revenue: Include linehaul, fuel surcharge, and accessorial revenue attributable to the period under your chosen reporting basis. Apply credits and adjustments consistently.
- Truck-specific costs: Include the applicable fuel, driver compensation, maintenance, insurance, equipment, toll, dispatch, and other expenses within your chosen cost definition.
- Shared expenses: Identify office payroll, software, accounting, yard rent, and other expenses not already assigned to individual trucks.
- Owner labor: State whether compensation for an owner who drives or manages the business is included. Results before and after an owner-labor allowance are different measures.
Use settlements carefully. If a settlement shows revenue after dispatch or other deductions, do not enter that net amount as revenue and subtract the same deductions again. Either reconstruct gross revenue and list the associated expenses separately, or retain the net presentation and clearly identify what has already been deducted.
For an accounting-profit comparison, do not substitute the full loan payment for depreciation and interest. Principal repayment belongs to financing cash flow; depreciation and interest affect profit in different ways. Counting the full payment alongside depreciation and interest would overstate the expenses used in that comparison.
Calculate the Total and Average from the Same Truck Rows
For a roster containing (N) trucks:
[
T = \sum_{i=1}^{N} P_i
]
[
A = \frac{T}{N}
]
Where:
- (T) is the combined profit or loss from the truck rows.
- (A) is average profit per listed truck.
- (N) is the number of trucks represented in those rows.
The reconciliation check is:
[
T – (A \times N) = 0
]
Use unrounded values for this check. A small difference can arise if you multiply a displayed average rounded to cents by the truck count.
If shared expenses have not been allocated to the rows, introduce a separate adjustment:
[
F = T – H
]
[
A_F = \frac{F}{N}
]
Here, (H) is shared expense not already included in truck costs, (F) is the fleet result after that expense, and (A_F) is the corresponding average per truck.
Do not subtract (H) again if it is already included in the truck rows.
Worked Example: Four Trucks for One Month
The following hypothetical example uses US dollars and one calendar month. The truck costs include the truck-specific expenses selected for this analysis but exclude $2,000 of shared office expenses.
| Truck | Revenue | Included truck costs | Profit or loss before shared office expenses |
|---|---|---|---|
| A | $24,000 | $19,000 | $5,000 |
| B | $22,000 | $18,500 | $3,500 |
| C | $18,000 | $19,000 | −$1,000 |
| D — idle all month | $0 | $2,500 | −$2,500 |
| Total | $64,000 | $59,000 | $5,000 |
Truck D generated no revenue but still incurred $2,500 in included costs. Keeping that truck in the roster preserves both its costs and its effect on the fleet average.
Before shared office expenses:
[
A = $5{,}000 \div 4 = $1{,}250
]
The check is:
[
$1{,}250 \times 4 = $5{,}000
]
After subtracting the $2,000 of shared office expenses:
[
F = $5{,}000 – $2{,}000 = $3{,}000
]
[
A_F = $3{,}000 \div 4 = $750
]
Both averages are mathematically correct, but they describe different cost boundaries. The $1,250 average is before shared office expenses; the $750 average is after them. Neither should be labeled net income unless the underlying costs and adjustments support that label.
How Allocating Shared Costs Changes the Truck Results
If the $2,000 is allocated equally, each truck receives $500 of additional expense. The adjusted truck results become:
- Truck A: $4,500.
- Truck B: $3,000.
- Truck C: −$1,500.
- Truck D: −$3,000.
They still total $3,000 and average $750.
An equal allocation is a reporting choice, not proof that each truck caused the same overhead. Another allocation basis may be more useful for a particular expense. Whatever basis you choose, the allocated amounts must add up to the expense being assigned. Changing the allocation can change individual truck results without changing total fleet profit.
Choose the Truck Count Before Interpreting the Average
“Average profit per truck” is incomplete unless the denominator is clear.
For a whole-fleet monthly view, define the roster explicitly—for example, all trucks held in the operating fleet during the month, including idle units. For a production comparison, you may also calculate a separate result for trucks that hauled freight. Keep the two measures labeled separately.
In the example, the three revenue-producing trucks earned a combined $7,500 before shared office expenses:
[
$7{,}500 \div 3 = $2{,}500
]
That $2,500 active-truck average does not reconcile directly with the four-truck total. The bridge is:
[
($2{,}500 \times 3) – $2{,}500
= $5{,}000
]
The second $2,500 is idle Truck D’s loss. Subtracting the $2,000 of shared office expenses then produces the $3,000 fleet result.
Dividing the entire $5,000 by three would produce a different metric: the whole-fleet result per revenue-producing truck. It would not be the arithmetic average of the three active trucks’ individual results.
Partial-Period Trucks Need Separate Treatment
A truck added halfway through the month has less time to generate revenue and incur costs than a truck present all month. Include its actual results in the fleet total, but flag its shorter participation before comparing it with full-month trucks.
If you need an exposure-adjusted comparison, calculate truck-equivalent months separately:
[
E =
\frac{\text{Total included truck-days}}{\text{Calendar days in the month}}
]
Then divide the corresponding fleet result by (E). Label the output “profit per truck-equivalent month,” not average profit per listed truck.
Define truck-days consistently. Days assigned to the fleet, days available for dispatch, and days actually hauling freight measure different things. Do not replace a listed-truck count with an exposure measure without changing the metric’s label.
Trace a Mismatch in a Fixed Order
When the total and average do not reconcile, check the inputs before interpreting the difference as an operating problem.
1. Match the Reporting Period and Recognition Basis
Confirm that every row covers the same start and end dates. A calendar-month revenue report will not align with expenses pulled from a four-week settlement cycle.
Also check when revenue and costs enter the report. Under an accrual approach, revenue and associated expenses are recognized for the relevant period rather than solely when cash moves. Bank deposits alone therefore do not establish the revenue or profit for that period.
Use freight invoices, settlements, fuel records, payroll reports, maintenance invoices, and accounting records to trace discrepancies. Keep the same recognition basis throughout the comparison.
2. Match the Roster to the Denominator
Count unique trucks, not spreadsheet rows. Look for:
- Duplicate unit numbers.
- Idle trucks omitted from one report.
- Sold, added, or temporarily out-of-service trucks treated differently.
- Blank entries counted as trucks.
- Trucks with missing financial data treated as zero-profit units.
A blank revenue or cost field means the result is incomplete unless you have confirmed that zero is the correct amount. Reconcile a complete subset separately if necessary, but do not present it as the whole fleet.
3. Bridge Shared and Company-Level Items
Compare the sum of truck results with the company report using an explicit bridge:
[
\text{Company result}
=
\text{Truck-row total}
–
\text{Unallocated expenses}
+
\text{Other included income or adjustments}
]
Use the same profit definition on both sides. If the company report includes interest, income taxes, equipment-sale gains or losses, or other items absent from the truck rows, those differences need their own lines rather than being hidden in the average.
4. Check Duplicates, Signs, and Rounding
Confirm that:
- A cost is not included in both a settlement deduction and an expense entry.
- Allocated overhead is not deducted again at fleet level.
- Credits and refunds reduce the appropriate expense rather than increase it.
- Loss-making trucks remain negative in the total.
- Formulas include every intended row and exclude subtotal rows.
- Rounding occurs after aggregation, not repeatedly at each calculation step.
If the truck count is zero, average profit per truck is undefined. Report it as unavailable rather than $0. A zero-revenue truck, by contrast, can still have a valid negative result when its costs are known.
Use the Reconciled Average Without Hiding Truck-Level Differences
In the example, an average of $750 after shared office expenses coexists with two profitable trucks and two loss-making trucks. The average reconciles correctly, but it does not describe the performance of a typical individual unit.
Keep the truck-level results beside the fleet total. For an unusually low result, identify whether the difference comes from fewer available days, lower revenue, higher recurring costs, or a specific expense such as a major repair. Do not remove the expense from the reported total simply because it is unusual; show any adjusted comparison separately.
For period-to-period decisions, compare total profit, the defined truck count, and average profit together. A higher average across a smaller fleet can accompany lower total profit. A larger fleet can increase total profit while reducing profit per truck. The reconciliation establishes that the numbers agree; the truck-level records explain why they changed.