Allocation method
Allocate landed cost by value
Duty, insurance and agent commission are charged on what the goods are worth. Share them in proportion to each line’s value, so a $6 tray carries more duty than a 95¢ spoon.
The rule in one paragraph
A cost allocated by value is split in proportion to each received line’s value in your store currency (received quantity × unit cost × exchange rate). Lines with nothing received take no share. Each bill is rounded to the cent with the largest remainder method, so the column adds up to the bill.
Why the obvious shortcut is wrong
Dividing duty by the number of units gives every spoon the same duty as every tray. But duty was assessed on the entered value: the tray line is 63% of the invoice, so it owes 63% of the duty. Per-unit duty misprices both — the cheap item looks expensive and the expensive item looks like a bargain.
A worked example
PO-2201: duty 313.50 and insurance 42.00 across three acacia lines
Goods 4,585.00: trays 2,500.00 (54.5%), bowls 1,230.00 (26.8%), spoons 855.00 (18.6%). Each bill follows those shares — the spoons are 56% of the units but carry 18.6% of the duty.
| SKU | Product / variant | Recv | Rej | Unit USD | Line value | Duty | Insurance | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EH-TRAY-01 | Acacia serving tray 40 cm | 400 | 0 | 6.25 | 2500.00 | 170.94 | 22.90 | 193.84 | 2693.84 | 6.73 | 7.8% | 6.73 |
| EH-BOWL-02 | Acacia salad bowl 25 cm | 300 | 0 | 4.10 | 1230.00 | 84.10 | 11.27 | 95.37 | 1325.37 | 4.42 | 7.8% | 4.42 |
| EH-SPOON-03 | Serving spoon pair | 900 | 0 | 0.95 | 855.00 | 58.46 | 7.83 | 66.29 | 921.29 | 1.02 | 7.8% | 1.02 |
| Total · 3 lines | 1600 | 0 | 4585.00 | 313.50 | 42.00 | 355.50 | 4940.50 | ×1.0775 | 7.7% | |||
What we record
- The exact share and its rounding for every line (hover a cell).
- The bill’s currency, the converted amount and the Σ check per bill.
- The basis total (Σ value) so the report can be rebuilt by hand.
If you only remember one thing
Anything the customs broker computed from the invoice value — duty, MPF, insurance premium, an agent’s percentage — is allocated by value.
Try it
Change any number — the stamp stays balanced
Every cost line in this mini allocator is locked to “by value”. The full allocator on the home page lets each bill pick its own method.
01Receipt lines
02Payments & exchange rate
03Costs to allocate
Each bill picks its own method. Defaults follow what moves the cost: freight by weight, duty by value, brokerage per unit.Duty: use the amount on your customs entry (CBP 7501 line totals); this tool does not classify HS codes. MPF: use the amount printed on the entry — the prefill is the 0.3464% ad valorem part before the yearly minimum and maximum.
04Landed cost by SKU
| SKU | Product / variant | Recv | Rej | Unit USD | Line value | Duty | Insurance | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EH-TRAY-01 | Acacia serving tray 40 cm | 400 | 0 | 6.25 | 2500.00 | 170.94 | 22.90 | 193.84 | 2693.84 | 6.73 | 7.8% | 6.73 |
| EH-BOWL-02 | Acacia salad bowl 25 cm | 300 | 0 | 4.10 | 1230.00 | 84.10 | 11.27 | 95.37 | 1325.37 | 4.42 | 7.8% | 4.42 |
| EH-SPOON-03 | Serving spoon pair | 900 | 0 | 0.95 | 855.00 | 58.46 | 7.83 | 66.29 | 921.29 | 1.02 | 7.8% | 1.02 |
| Total · 3 lines | 1600 | 0 | 4585.00 | 313.50 | 42.00 | 355.50 | 4940.50 | ×1.0775 | 7.7% | |||
| Cost line | Method | Bill | In USD | Allocated | Closes |
|---|---|---|---|---|---|
| Entry 7501 — duty · Duty (from customs entry) | By value | 313.50 USD | 313.50 | 313.50 | Σ to the cent |
| Cargo insurance · Insurance | By value | 42.00 USD | 42.00 | 42.00 | Σ to the cent |