Freight Cost Allocation: Put Every Dollar Where It Belongs

Your income statement says freight is 7.2% of sales. That number may be accurate and still be useless.

When every carrier bill lands in one transportation account, finance cannot tell which customer, SKU, order, location or channel consumed the spend. Operations cannot separate a bad lane from a bad product mix. Sales keeps quoting gross margin without the freight that made the order possible. The company knows what it spent, but not what the spend bought.

Freight cost allocation fixes that blind spot. The job is not to invent accounting precision after the fact. It is to connect shipment-level cost to the business decision that created it, preserve the evidence, and route exceptions to people who can resolve them.

Choose the cost object before you choose the formula

A cost object is the thing management wants to measure: an order, shipment, customer, SKU, facility, business unit or channel. Pick one primary object for the operating ledger. Add secondary dimensions only when the source data supports them.

For most shippers, the cleanest primary object is the shipment or load. It already has a carrier, origin, destination, mode, tender, rate, accessorials and delivery event. From there, the cost can be assigned downstream to orders, customers or products using documented rules.

Do not start with the general ledger. The GL is the financial destination, not the operational source of truth. Start with a shipment ID that persists from order creation through quote, tender, delivery, invoice and payment. A managed transportation program should preserve that chain instead of forcing AP to reconstruct it from carrier PDFs.

The hierarchy matters. If one truck serves one customer order, direct assignment is easy. If a consolidated LTL or truckload move serves six orders and 28 SKUs, the rule must specify how cost is divided. Without a hierarchy, teams quietly use different logic and call the output “actual margin.”

Build a shipment cost ledger before mapping the GL

Create one operating record for every shipment. It should carry planned cost, approved changes, accrued cost, invoiced cost, allocation status and the accounting dimensions needed downstream.

At minimum, capture:

• shipment, order and invoice identifiers;
• customer, business unit, origin and destination;
• mode, carrier, service level, weight, cube and handling units;
• base transportation, fuel and each accessorial as separate charge lines;
• quoted, accrued, invoiced and approved amounts;
• allocation method, cost center, GL account and exception owner.

This is more than tidy data. The IRS explains in Publication 538 that transportation or other charges incurred in acquiring merchandise can be part of inventory cost. That does not mean every freight charge receives identical treatment, and it is not tax advice. It means operations cannot casually dump every charge into a single bucket and expect finance to repair the economic meaning later. Your controller or tax adviser should approve the accounting policy.

Timing also matters. The shipment-level freight accrual workflow solves the gap between delivery and invoice. Allocation solves a different problem: where the cost belongs once it is known. Keep those controls connected, but do not confuse them.

Separate direct charges from shared-cost rules

Assign costs directly whenever the evidence supports it. A liftgate charge belongs to the delivery that required a liftgate. A detention charge belongs to the stop and responsible party that created the delay. A redelivery charge should not be smeared across every customer in the month.

Shared costs need a rule. Use the driver that best reflects consumption:

• Weight: useful when dense products consume capacity proportionally.
• Cube or pallet positions: stronger when trailer space is the constraint.
• Units or cartons: acceptable when products are operationally similar.
• Order value: easy, but often economically weak. Expensive jewelry and inexpensive flooring do not consume transportation the same way.
• Stops or miles: useful for multi-stop routes when distance and dwell drive cost.

Document the rule, effective date and owner. Do not let analysts switch drivers until the margin story looks better. The U.S. Government Accountability Office describes managerial cost accounting as combining financial and nonfinancial data to allocate costs to activities and outputs; its reviews repeatedly emphasize documented controls and reliable inputs. That discipline applies even when the ledger belongs to a private shipper, not a federal agency. See the GAO’s managerial cost accounting practices review.

Fuel deserves separate treatment. The U.S. Energy Information Administration notes that diesel pricing reflects crude oil, refining, distribution and taxes, with meaningful regional differences. Use the EIA diesel price framework to understand the moving input; allocate the actual contracted fuel surcharge or invoice line, not a national average pasted over every lane.

Automate the joins; keep humans on exceptions

Manual freight allocation breaks at the joins. The ERP knows the order. The TMS knows the shipment. The carrier invoice knows the charges. The warehouse knows the handling units. Each system uses a different identifier, and a spreadsheet tries to reconcile them after close.

Automate the repeatable work:

1. Generate a persistent shipment ID when transportation is planned.
2. Attach every order and handling unit to that shipment before tender.
3. Store the accepted rate and accessorial assumptions as structured charge lines.
4. Capture delivery, accrual and invoice events against the same ID.
5. Apply the approved allocation rule and push coded entries to the ERP.
6. Reconcile allocated dollars to the invoice total and stop any record that does not balance.

Logistics API and workflow consulting is useful when order, shipment, invoice and accounting data live in separate platforms. The goal is not to automate judgment. It is to stop rekeying stable facts and expose the records that need judgment.

Humans should own unmatched shipment IDs, duplicate invoices, disputed accessorials, mixed tax treatment, customer-specific chargebacks and any allocation that produces a material margin swing. The freight invoice audit workflow should verify what is payable before allocation distributes it. Automating bad charges only makes the error travel faster.

Test the economics before trusting the dashboard

Illustrative example — run your own numbers. One consolidated shipment costs $2,400 and carries three orders. Order A uses 50% of the pallet positions, Order B uses 30% and Order C uses 20%. A cube-based rule assigns $1,200, $720 and $480. A revenue-based rule might assign $600, $1,200 and $600 instead.

Neither rule is automatically correct. The difference is a management decision hiding inside a formula. If the purpose is product profitability, physical capacity may be the stronger driver. If the purpose is a commercial freight-recovery program, the company may use a different customer-facing rule while preserving actual transportation consumption internally.

Reconcile three totals every period: the carrier invoice total, the shipment ledger total and the ERP posting total. They should balance to the cent, with timing differences and disputed amounts explicitly identified. Then compare allocated actuals with the freight budget and variance model instead of explaining an undifferentiated monthly overage.

Do not freeze the rate forever. The Bureau of Labor Statistics’ August 2026 Producer Price Index release identified truck transportation of freight among the service categories moving higher. That is a warning against stale blended rates, not a forecast for any specific lane. Review allocation drivers and standard rates when mode mix, network design or contracted charges change. The current BLS Producer Price Index release provides market context; your shipment ledger provides the evidence.

Know when detailed allocation is not worth it

Here is the damaging admission: not every shipper needs SKU-level freight costing.

If you run a small number of direct shipments, sell products with similar freight profiles and make no decisions from product-level transportation margin, a simple order or customer allocation may be enough. A complex model can cost more to maintain than the insight is worth.

The approach also fails when master data is weak. Missing dimensions, recycled order numbers and invoices without shipment references will produce fake precision. Fix identity and capture first. Add allocation detail only when the data is stable and a real decision depends on it.

Put every freight dollar where the business can act on it. Easy Logistics can map your order-to-shipment-to-invoice flow, define practical cost drivers, connect transportation data to finance and identify which exceptions still need a person. Share a sample shipment file, invoice export and chart of accounts to start a freight cost-allocation workflow review.

•