Which freight numbers should a COO see every month?

AI logistics agent vs. traditional TMS guideNov 17, 202617 min read

Which freight numbers should a COO see every month?

It is the first Monday of the month. The COO of a manufacturer opens the operations review deck. Freight has one slide: a bar chart of total freight spend by month, up 11% from the month before. The logistics manager explains that volume was up. The CFO asks how much was volume and how much was rate. Nobody knows. The COO asks whether customers got their orders on time. Someone says "mostly." The meeting moves on, and freight stays a cost line nobody can steer.

A COO should see a short, fixed set of freight numbers every month: cost per unit shipped, total spend against budget, on-time pickup, on-time delivery, accessorial spend, claims, invoice exceptions and expedited spend, each with the cause of any change and the action it triggers. Eight numbers fit on one page. Each one answers a question an operations leader actually asks: are we paying more, are customers getting their orders, and where is money leaking?

The goal is not a bigger report. The goal is a page the COO can read in five minutes and leave with one or two decisions, such as "rebid the two lanes that went up," "talk to the carrier that missed nine pickups" or "find out why liftgate charges doubled."

Why most freight reporting fails at the COO level

Most freight reports are built for the people who run freight. They show loads by status, carrier lists and open exceptions. That is useful for a coordinator, but a COO cannot act on a list of 600 loads. The opposite failure is a single number, total spend, which moves with sales and hides everything else.

The COO page sits between those two. It summarizes the month, separates causes and points to the few lanes, carriers or customers that need attention. The detailed metrics for the logistics team itself, such as time to quote or follow-ups per load, belong in a different view. The guide on freight coordination KPIs covers that working layer.

How this differs from the monthly logistics report

A logistics manager's monthly report to leadership often covers projects, staffing, carrier changes and the story of the month. The COO's freight numbers are the fixed core of that report: the same eight figures, defined the same way every month, so trends are real. The guide on what to report to leadership about logistics each month covers the full report and its narrative.

Let's build your monthly freight view together. You don't need to prepare anything: Cartage maps the workflow with you on the call.

See it on your own loads. Wilson, by Cartage, is an AI logistics agent that quotes, books, tracks, audits and pays for freight with your approved carriers.

Book a demo →

How do you build the monthly freight numbers, step by step?

Define each number once, pull it from load records, compare it to last month and to budget, and write one line about the cause. The work is mostly in the first month. After that, the same definitions repeat.

Step 1: Write the definitions

Write down exactly what each number means before you calculate anything. For example:

  • Freight cost per unit: total freight cost for outbound loads delivered in the month, divided by units shipped on those loads. Choose the unit the business uses: cases, pallets, pounds or orders.
  • On-time delivery: loads delivered inside the appointment or promised window, divided by loads delivered in the month.
  • Invoice exceptions: carrier invoices that did not match the rate confirmation or the POD and were held for review.

A definition answers three questions: what counts, which date decides the month and which loads are in or out. Without that, two people will produce two different numbers from the same data.

Step 2: Decide which date puts a load in the month

Freight cost has three dates: when the load shipped, when it delivered and when the invoice was paid. Pick one and keep it. Many teams use the ship date for service numbers and the invoice date for spend that ties to the general ledger. Write the choice into the definitions so the numbers tie to finance's close.

Step 3: Pull from the load records

Every number should come from loads, not from a summary someone typed. The inputs are:

  • Orders and units shipped, from the ERP.
  • Booked rates, from rate confirmations.
  • Pickup and delivery times, from tracking events and PODs.
  • Final charges, from audited carrier invoices.
  • Accessorials, claims and disputes, from the invoice and claim records.

If these pieces sit in different inboxes, spreadsheets and portals, the first month will be slow. That is a sign of where the data problem is, not a reason to report less.

Step 4: Compare to last month and to budget

Show each number with last month, the same month last year if available, and budget or target. A number without a comparison is a fact, not a signal.

Step 5: Explain the change in one line

For any number that moved more than an agreed amount, say why. "Cost per pallet up 6%: two lanes rebid after a carrier rate increase, plus four expedites for a late raw material." The COO should not have to ask.

Step 6: Name the action

End the page with two or three actions: what the team will do, who owns it and when it will be checked. If no number calls for action this month, say so. That is useful too.

Step 7: Set a date and a reviewer

Pick a fixed day for the page, for example the fifth business day of the month, after carrier invoices for most loads have arrived. Late invoices will still trickle in, so note how much spend is estimated. Name one person who prepares the page and one person in finance who checks that spend ties to the ledger. A page that is late or does not tie to finance loses trust fast.

A worked example

Consider a hypothetical month at a manufacturer shipping LTL and truckload from one plant.

Number This month Last month Budget Cause in one line
Freight cost per pallet $118 $111 $112 Two lanes rebid after a rate increase; four expedites
Total freight spend $412,000 $371,000 $390,000 Volume up 4%, rate up 6%
On-time pickup 93% 96% 95% One carrier missed 9 pickups on two lanes
On-time delivery 91% 94% 95% Same carrier; two receiver closures
Accessorial spend $21,500 $14,800 $15,000 Liftgate and redelivery charges up
Claims opened 3 2 n/a Two damage claims on one LTL lane
Invoice exceptions 38 25 n/a Accessorials not on the rate confirmation
Expedited spend $9,200 $2,100 $3,000 Late raw material for one product line

The table shows the COO that the problem is not "freight went up." It is a rate increase on two lanes, one weak carrier and an accessorial leak. Each has an owner and a fix.

What does each number tell the COO, and where does it come from?

Each number has a source, a common trap and a decision it supports. Knowing all three keeps the page honest.

Freight cost per unit shipped

This is the most useful single number for a COO because it adjusts for volume. Divide total freight cost by the unit that matters to the business. A distributor may use cost per order or per pound. A manufacturer may use cost per pallet or per case.

Trap: mixing inbound and outbound. Keep them separate, or report both. Also keep customer-paid freight out of the shipper's cost if the customer pays the carrier directly.

Decision it supports: rebid lanes, change mode, review free-freight thresholds or price freight into customer quotes.

Total freight spend against budget

Spend still matters because finance closes on it. Split the change into volume and rate. If volume rose 4% and spend rose 10%, about 6 points came from rate, mode mix or accessorials. The guide on building next year's freight budget shows how the same split helps planning.

Trap: comparing invoice-date spend to ship-date volume. Use matching dates.

On-time pickup

Pickups that happened inside the agreed window, divided by pickups in the month. This number points at carriers and at the shipper's own readiness. A missed pickup because freight was not ready is a different problem from a carrier no-show. Record the cause.

On-time delivery

Deliveries inside the appointment or promised window. This is the number customers feel. Report it by customer for the top accounts if the COO talks to those customers.

Trap: counting the carrier's "delivered" status without a POD. Use the POD time or the receiver's confirmation where possible.

Accessorial spend

Liftgate, residential, inside delivery, detention, redelivery, storage, reweigh and reclass charges. Accessorials often grow quietly because each charge is small. Report them as a total and by type, and as a share of total spend.

Decision it supports: fix booking data, such as liftgate needs and receiver hours, and challenge charges that were never agreed.

Claims

Claims opened, claim value and claims paid. A rise on one lane or with one carrier usually means a handling or packaging problem. For a COO, the count and value are enough; the claim detail belongs to the logistics team.

Invoice exceptions

Carrier invoices held because they did not match the rate confirmation or the POD. This number shows how much money would leak if invoices were paid as billed. Report the count, the amount disputed and the amount recovered. A rising count often means bookings are missing details carriers later charge for. The guide on catching a duplicate freight invoice covers one common exception.

Expedited spend

Premium freight to recover a late order or a production gap. Expedites usually reflect a planning or supply issue, not a logistics one. Showing the cost to the COO puts the conversation with the right owner.

Inbound freight and supplier-paid freight

Many manufacturers pay for inbound raw material freight, and some of it is booked by suppliers and billed back. Inbound cost often hides inside the purchase price, so the COO never sees it. If the company controls inbound loads, report inbound cost per unit received as its own line. If suppliers book and bill the freight, at least show the total so the COO knows how large it is. Inbound delays also explain many expedites on the outbound side, so the two numbers belong on the same page.

Cost per unit by customer for the top accounts

For the five or ten largest customers, cost per unit by customer shows whether freight terms still make sense. A customer that moved from full pallets to small, frequent orders may now cost twice as much to ship to, while the price list has not changed. That is a pricing decision for sales and the COO, not a freight problem.

Numbers that usually do not belong on the COO page

  • Loads by status. Useful daily, noise monthly.
  • Quotes requested per load. A working metric for the logistics team.
  • Carrier count. It says little without performance.
  • Average transit days without a delivery promise to compare against.

These can live in the logistics team's own view.

What mistakes make monthly freight numbers useless?

The common mistakes are changing definitions, reporting without causes, mixing dates and showing numbers nobody acts on. Each one turns the page into wallpaper.

Mistake 1: Changing the definition every month

If on-time delivery uses the POD time in March and the carrier status in April, the trend is fake. Freeze definitions and note any change at the bottom of the page.

Mistake 2: Showing only total spend

Total spend moves with volume. Without cost per unit and a volume and rate split, the COO cannot tell good news from bad.

Mistake 3: No cause, no owner

A number that moved without a stated cause invites a meeting. A number with a cause and an owner invites a decision.

Mistake 4: Numbers that cannot be traced to loads

When the COO asks "which loads were late?", the answer should take minutes. If it takes a week of email searches, the number is not trusted, and an untrusted number does not get acted on.

Mistake 5: Averages that hide the problem

An on-time rate of 94% across all lanes can hide one customer lane at 70%. Show the worst lanes or customers next to the average.

Mistake 6: Reporting what was billed, not what was owed

If invoices are paid as billed, spend includes charges that should have been disputed. Report audited spend and the amount held for review separately.

A short decision guide

Signal Likely cause Who acts Typical action
Cost per unit up, volume flat Rate increase or mode mix Logistics Rebid lanes, review mode choice
Spend up, cost per unit flat Volume growth None needed Note in the report
On-time pickup down on one lane One carrier's service Logistics Talk to the carrier, re-rank the lane
On-time pickup down, freight not ready Plant or warehouse readiness Operations Review cutoffs and staging
Accessorials up Booking details missing or charges not agreed Logistics and finance Fix booking data, dispute unagreed charges
Invoice exceptions up Charges outside the rate confirmation Finance and logistics Hold, ask the carrier, update bookings
Expedited spend up Supply or planning gap Planning or purchasing Find the root cause outside freight

What should the one-page monthly freight view include?

One page, eight numbers, comparisons, causes and actions. The checklist below makes sure nothing is missing.

Item Question to answer Owner
Definitions Is each number defined, with the date rule and what is in or out? Logistics and finance
Cost per unit Which unit does the business use, and is inbound separate? Logistics
Spend split Is the change split into volume, rate and accessorials? Finance
Budget Is each spend number shown against budget? Finance
On-time pickup Are missed pickups split into carrier cause and shipper cause? Logistics
On-time delivery Is the POD or receiver time used, not only carrier status? Logistics
Worst lanes Are the worst lanes or customers shown next to the average? Logistics
Accessorials Are charges shown by type and as a share of spend? Logistics and finance
Claims Are count, value and recovered amount shown? Logistics
Invoice exceptions Are held invoices, disputed amount and recovered amount shown? Finance
Expedites Is the cause and the owner named? Operations
Causes Does every moved number have a one-line cause? Logistics
Actions Are two or three actions named with owners and dates? Logistics
Traceability Can any number be traced to its loads in minutes? Logistics

How to roll it out

Start with the numbers you can already produce: spend, cost per unit and on-time delivery. Add accessorials and invoice exceptions once invoices are audited against rate confirmations. Add the cause line and actions from the first month. After three months, the COO has a trend and the team has a habit. The guide on seeing freight spend by customer, product and lane helps when the COO asks for the next level of detail.

Where the numbers break down

The numbers are only as good as the load records. If rate confirmations, PODs and invoices are scattered, the monthly view becomes a manual project. Fixing the record is often the real first step.

How does Wilson, by Cartage, help a COO see the right freight numbers?

Wilson, by Cartage, is an AI logistics agent that quotes, books, tracks, audits and pays freight for manufacturers and distributors, and because it does the work, the records behind each monthly number are already there. Traditional logistics software gives teams information. Wilson executes the work required to move shipments forward.

Wilson works as the company's logistics department, in four parts: the labor, the data, the network and the payments.

The labor

The labor is the daily work, from the first quote to the final POD. Wilson requests quotes from the company's approved carriers, compares them on total cost, negotiates toward the company's rate targets within approval limits, books with written acceptance and a rate confirmation, schedules pickups, tracks loads and handles exceptions. It requests and files PODs. Each of these steps creates the timestamps and documents that on-time and cost numbers depend on.

The data

The data is the record. Wilson keeps every order, load, quote, rate, document and contact on record as it works, connected to the company's ERP. Every message, confirmation and change is kept in the shipment's change history, so when the COO asks "which loads?", the answer is a search, not a project. Wilson replaces the TMS for freight execution and connects to the company's ERP.

Wilson works with SAP, NetSuite, Microsoft Dynamics 365, Oracle, Infor, Epicor, Sage, Acumatica and other ERP environments, with the exact connection depending on the customer's data flow and scope.

Wilson does not keep a permanent scorecard or run recurring benchmarking by default. It can produce carrier-performance and lane-rate reports on request from the loads it runs. That fits the monthly view: the team asks for the numbers it has defined, and Wilson builds them from the same records it used to move the freight.

The network

The network helps the rate side of the page. A shipper's volume counts with every other Wilson customer's, which helps get better freight rates on every lane. The network includes carriers and brokers, and the company still approves who hauls its freight. When a lane's cost per unit climbs, the team can ask Wilson to quote that lane again with approved carriers.

The payments

The payments feed the invoice-exception and accessorial numbers. Wilson audits every carrier invoice against the rate confirmation and the POD before money moves, then pays carriers from the Wilson Wallet. An invoice over the agreed rate, such as $2,410 against an agreed $2,200, is held and flagged for a person. Payments above the approval limits or outside the rules wait for a person. Because every held invoice has a reason on record, the monthly count of exceptions and the amount disputed come from the same work.

Control starts with assisted execution. The company sets approval limits, and routine actions can run automatically within those rules as the workflow is proven. Teams reach Wilson by email, Slack, Microsoft Teams, WhatsApp, text or phone.

Pricing

Wilson is free on Wilson's network: the shipper pays the freight rate and nothing on top. When a shipper keeps its own carriers, the fee is 2% to 0.5% of what Wilson pays them, falling with volume. There are no seat fees, no setup cost and no contract. Timing depends on scope: most teams start on a few lanes and expand from there.

FAQs

Can Wilson give our COO monthly freight numbers?

Wilson, by Cartage, an AI logistics agent, can produce carrier-performance and lane-rate reports on request from the loads it runs. It does not keep a permanent scorecard by default. Because Wilson quotes, books, tracks, audits and pays the freight, the records behind cost, on-time and invoice numbers are already on file.

How many freight numbers should a COO see?

About eight: cost per unit, total spend against budget, on-time pickup, on-time delivery, accessorial spend, claims, invoice exceptions and expedited spend. More than that and the page stops getting read.

Why is cost per unit better than total freight spend?

Total spend rises and falls with volume. Cost per unit, per pound or per order shows whether freight is getting more expensive for the same work. Show both, with the change split into volume and rate.

Should on-time delivery use the carrier's status or the POD?

Use the POD time or the receiver's confirmation where possible. A carrier's "delivered" status without a POD can be wrong or late. Whichever you choose, keep the same definition every month.

Which date should put a load in a month?

Pick one and keep it. Many teams use the ship date for service numbers and the invoice date for spend that ties to finance's close. Write the rule into the definitions.

What should the COO do when accessorial spend jumps?

Ask for the breakdown by charge type and lane. Rising liftgate, redelivery or detention charges usually point to missing booking details, receiver problems or charges nobody agreed to. The fix is in booking data and invoice review.

Should the COO see carrier rankings?

Usually not as a standing list. It is more useful to show the worst lanes and the carrier behind a drop in on-time pickup. The logistics team can then re-rank carriers on those lanes.

How long does it take to set up a monthly freight view?

The first month takes the longest because definitions are written and data is gathered. After that, the same numbers repeat. If load records are complete, the monthly work is small.

Does Wilson replace our finance reporting?

No. Finance still closes the books. Wilson provides load-level records, audited invoices and reports on request that feed the freight part of the monthly review.

Should inbound freight be on the COO's page?

Yes, if the company pays for it. Show inbound cost per unit received as its own line, separate from outbound. Inbound delays also explain many outbound expedites, so the two belong on the same page.

What if carrier invoices arrive after the month closes?

Pick a fixed day to prepare the page and show how much of the spend is still estimated. Update last month's figure when the invoices arrive, and note the change so the trend stays honest.

Sources

Let's build your monthly freight view together. You don't need to prepare anything: Cartage maps the workflow with you on the call.

Add Cartage as a preferred source on Google