Skip to content

Guide

Allocating import costs by SKU

Short answer

Allocating means splitting each shipment charge across the products by the basis that best explains why it was paid: freight and handling by weight or volume, insurance and broker fees by value, and IGI by each product's tariff fraction. Allocating everything by value is a shortcut that under-costs heavy products.

Why the allocation basis matters

A shipment almost never carries a single product. Freight invoices, the broker account and the pedimento charge for the whole shipment, and to know the cost of each SKU you have to split those charges. The basis you choose moves the unit cost and, with it, your prices and margins.

The most common spreadsheet method is to split everything in proportion to the invoice value. It is easy, but it ignores that freight is charged by weight or volume and that each tariff fraction pays a different rate.

Which basis to use for each charge

Recommended basis by type of charge
ChargeBasisWhy
International freight and surchargesGross weight or volumeThe carrier charges per kilo, cubic meter or container.
Origin and destination logisticsGross weight or volumeHandling and storage depend on the space and handling of the cargo.
InsuranceMerchandise valueThe premium is calculated on the insured value.
Customs broker feesMerchandise valueUsually charged on the shipment value or per pedimento.
IGICustoms value × tariff rateEach line pays its fraction's rate; averaging it distorts the cost.
DTA and PRVCustoms valueDTA is proportional to customs value; PRV is fixed per pedimento.
Trucking to the warehouseGross weight or volumeThe trucker charges by space or weight.

For bulky, light goods such as furniture or inflatables, volume explains freight better than weight. If you do not have each SKU's weight or volume, value is the reasonable fallback.

How to allocate, step by step

  1. 1Take each SKU's gross weight and volume from the packing list, and its value from the commercial invoice.
  2. 2Give each charge its basis, following the table above.
  3. 3Work out each SKU's share: its weight over the total weight, its value over the total value, and so on for each basis.
  4. 4Multiply each charge by each SKU's share.
  5. 5Adjust the rounding so the per-SKU sum is exactly the charge total: leftover cents go to the SKUs with the largest fraction (largest remainder method).
  6. 6Add up all the layers of each SKU and divide by its units to get the unit cost.

Example: two SKUs, two results

In the sample shipment, SKU A is light and high-value: it is 60% of the invoice value but only 30% of the weight. SKU B is the opposite. This is how each charge splits:

How each charge is allocated
ChargeBasisSKU ASKU B
Ocean freight to ManzanilloGross weightMX$8,100.00MX$18,900.00
Cargo insuranceMerchandise valueMX$1,080.00MX$720.00
Port handling and storageGross weightMX$2,700.00MX$6,300.00
Customs broker feesMerchandise valueMX$5,100.00MX$3,400.00
Trucking to the warehouseGross weightMX$1,800.00MX$4,200.00
IGICustoms value × its tariff rateMX$22,518.00MX$8,181.00
DTA and PRVCustoms valueMX$2,004.15MX$1,456.25

Now compare the unit cost against the shortcut of allocating everything by value:

Unit cost by allocation method
MethodSKU ASKU B
Invoice priceMX$216.00MX$360.00
Everything by value (shortcut)MX$267.88MX$446.46
Each charge by its own basisMX$259.30MX$467.89
Shortcut error+3.3%-4.6%

With the shortcut, SKU B's unit cost comes out 4.6% below the real one and SKU A's 3.3% above it. Price with those numbers and you sell SKU B with less margin than you think, and overprice SKU A for no reason.

Rounding matters too

Splitting a charge across several products creates fractions of a cent. If you round each line separately, the per-SKU sum no longer matches the invoice total and your books do not balance. The largest remainder method fixes it: round down, then hand the remaining cents to the lines with the largest fraction, so the sum is always exact.

SmartLanded allocates each charge by its basis, lets you change it per layer and uses this method in every allocation: your SKUs add up to the shipment total to the cent. Try it free.

Keep reading

Back to top