Allocate outbound shipping costs across multi-item ecommerce orders

Connect orders, parcels and carrier bills

For each outbound parcel keep the seller, order and waybill IDs, warehouse, dispatch date, destination, items and quantities, packed weight or dimensions, carrier agreement, billed amount and adjustments. If an order is split into two parcels, match both waybills. If several orders share one parcel, identify its contents first; do not assign the whole parcel charge to every order.

Separate base freight from fuel or remote-area surcharges, declared-value services, reverse-shipping charges and settlement discounts. Record shipping paid by the customer or platform support separately from the amount payable to the carrier. Decide explicitly how each enters a management view; a net bank payment alone is not necessarily the full delivery cost.

One cohort, two allocation methods

Assume 100,000 parcels have shipped. Each contains one A weighing 8 kg and one B weighing 2 kg. The carrier bill for this cohort is RMB 50 per parcel, RMB 5.00 million in total. For this calculation, the recorded charges match the cohort, with no additional surcharges, refunds or cross-period discounts; amounts use a consistent VAT-inclusive basis.

For the full cohort, the weight basis assigns RMB 4.00 million to A and RMB 1.00 million to B. The unit basis assigns RMB 2.50 million to each.

Both methods allocate RMB 50 per parcel and RMB 5.00 million in total; neither changes the carrier's actual bill. A differs by RMB 1.50 million between the two views, with the opposite difference for B. Label the method when comparing product contribution rather than interpreting the two allocations as an actual increase or decrease in total freight.

Where the carrier agreement is weight-based and product weight, packaging and delivery conditions are reasonably comparable, weight can be a useful starting point for analysis. A per-unit allocation may be simpler for fixed parcel charges and similar products. Where volume, cold chain, destination or special packaging drives cost, isolate those charges or choose a basis closer to their cause. Assign independently identifiable waybills and surcharges directly before allocating shared amounts.

Product weight is not always billable weight

Packaging, first-weight and additional-weight tiers, volumetric weight and route can change the bill. SF Express's mainland China price guidance describes volumetric rules that vary by product and route. The actual agreement and bill govern the shipment; one carrier's formula is not a universal rule.

The sum of product net weights may be available as an allocation basis but may not equal the parcel's billable weight. If costs differ materially by warehouse, destination or packaging, group directly identifiable waybills and routes before allocating shared costs within each group. Keep missing amounts as unallocated rather than presenting estimates as carrier-billed facts.

Check the monthly allocation

1. Completeness: match dispatched waybills, carrier bills, orders and SKU records; flag missing, duplicated, cancelled and unsettled items.
2. Assignment: count each parcel's actual charge once; follow individual waybills for split parcels and assign identifiable charges directly first.
3. Basis: record VAT inclusion, surcharges, customer shipping payments, discounts and period. Allocate to the chosen precision and place rounding residuals on a designated record so totals reconcile.
4. Exceptions: investigate large or remote parcels, warehouse transfers, reshipments and reversals, retaining the original bill and adjustment batch.
5. Comparability: preserve the rule version across periods. Explain a change in basis and, where useful, recalculate the comparison period on the same method.

A management allocation does not automatically determine the financial-statement account. The Ministry of Finance Shandong supervisory office's case discussion illustrates how transport purpose, contract and performance stage can affect accounting under China Accounting Standards for Business Enterprises. Other entities apply their governing framework. Allocating freight to a SKU in a management report does not itself make it inventory cost.

CaiGeek is an AI financial assistant for small and medium-sized businesses. Start with one shipment cohort and let the finance team reconcile waybills, carrier invoices and the allocation basis before comparing product contribution. See the business and profit analysis example or contact CaiGeek.