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
| Charge | Basis | Why |
|---|---|---|
| International freight and surcharges | Gross weight or volume | The carrier charges per kilo, cubic meter or container. |
| Origin and destination logistics | Gross weight or volume | Handling and storage depend on the space and handling of the cargo. |
| Insurance | Merchandise value | The premium is calculated on the insured value. |
| Customs broker fees | Merchandise value | Usually charged on the shipment value or per pedimento. |
| IGI | Customs value × tariff rate | Each line pays its fraction's rate; averaging it distorts the cost. |
| DTA and PRV | Customs value | DTA is proportional to customs value; PRV is fixed per pedimento. |
| Trucking to the warehouse | Gross weight or volume | The 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
- 1Take each SKU's gross weight and volume from the packing list, and its value from the commercial invoice.
- 2Give each charge its basis, following the table above.
- 3Work out each SKU's share: its weight over the total weight, its value over the total value, and so on for each basis.
- 4Multiply each charge by each SKU's share.
- 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).
- 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:
| Charge | Basis | SKU A | SKU B |
|---|---|---|---|
| Ocean freight to Manzanillo | Gross weight | MX$8,100.00 | MX$18,900.00 |
| Cargo insurance | Merchandise value | MX$1,080.00 | MX$720.00 |
| Port handling and storage | Gross weight | MX$2,700.00 | MX$6,300.00 |
| Customs broker fees | Merchandise value | MX$5,100.00 | MX$3,400.00 |
| Trucking to the warehouse | Gross weight | MX$1,800.00 | MX$4,200.00 |
| IGI | Customs value × its tariff rate | MX$22,518.00 | MX$8,181.00 |
| DTA and PRV | Customs value | MX$2,004.15 | MX$1,456.25 |
Now compare the unit cost against the shortcut of allocating everything by value:
| Method | SKU A | SKU B |
|---|---|---|
| Invoice price | MX$216.00 | MX$360.00 |
| Everything by value (shortcut) | MX$267.88 | MX$446.46 |
| Each charge by its own basis | MX$259.30 | MX$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
Guide
How to calculate the landed cost of an import
Step by step: calculate the landed cost of an import into Mexico. Cost layers, customs value, import taxes and per-SKU allocation, with a worked example.
Guide
Mexico import taxes: IGI, DTA, PRV and VAT
Which taxes you pay when importing into Mexico and how they cascade: IGI, DTA (8 per thousand), PRV and 16% VAT, with a worked example for 2026.
Guide
Customs value and incrementables: how they are calculated
What customs value is, which costs are incrementables and which are not, how the Incoterm affects it, and a per-SKU example for imports into Mexico.
Glossary
Mexico import and foreign trade glossary
Plain definitions for importing into Mexico: pedimento, tariff fraction, customs value, IGI, DTA, PRV, creditable VAT, Incoterms and more.