Allocation method
Allocate landed cost by quantity
Brokerage, ISF filing, inspection visits and other flat fees cost the same for a $1.80 collar as for a $3.40 leash. Spread them per unit received.
The rule in one paragraph
A cost allocated by quantity is split in proportion to received units. Every unit that arrived carries the same share of the bill, whatever it cost or weighed. Rejected units take nothing.
Why the obvious shortcut is wrong
Allocating a flat $165 broker fee by value gives the leash line almost 40% of it although it is 20% of the units — the broker did not work harder on a leash. Allocating it by weight, when weights are not even on the invoice, is guesswork. Per unit is honest for a fee that is per shipment.
A worked example
PO-2230: broker 165.00 and inspection 100.00 over 1,500 units
265.00 ÷ 1,500 = 17.67¢ per unit before rounding. The collar lines (600 units each) take 106.00 of the 265.00 each; the leash line (300 units) takes 53.00.
| SKU | Product / variant | Recv | Rej | Unit USD | Line value | Brokerage | QC | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PS-COLLAR-S | Collar — small | 600 | 0 | 1.80 | 1080.00 | 66.00 | 40.00 | 106.00 | 1186.00 | 1.98 | 9.8% | 1.98 |
| PS-COLLAR-M | Collar — medium | 600 | 0 | 1.95 | 1170.00 | 66.00 | 40.00 | 106.00 | 1276.00 | 2.13 | 9.1% | 2.13 |
| PS-LEASH-01 | Leash 1.5 m | 300 | 0 | 3.40 | 1020.00 | 33.00 | 20.00 | 53.00 | 1073.00 | 3.58 | 5.2% | 3.58 |
| Total · 3 lines | 1500 | 0 | 3270.00 | 165.00 | 100.00 | 265.00 | 3535.00 | ×1.0810 | 8.1% | |||
What we record
- Received and rejected units per line.
- The per-unit amount of each flat fee.
- Which fees were flat (quantity) and which were ad valorem (value) on this receipt.
If you only remember one thing
Fees that do not change with the value or weight of the goods are allocated per unit received.
Try it
Change any number — the stamp stays balanced
Every cost line in this mini allocator is locked to “by quantity”. 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 | Brokerage | QC | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PS-COLLAR-S | Collar — small | 600 | 0 | 1.80 | 1080.00 | 66.00 | 40.00 | 106.00 | 1186.00 | 1.98 | 9.8% | 1.98 |
| PS-COLLAR-M | Collar — medium | 600 | 0 | 1.95 | 1170.00 | 66.00 | 40.00 | 106.00 | 1276.00 | 2.13 | 9.1% | 2.13 |
| PS-LEASH-01 | Leash 1.5 m | 300 | 0 | 3.40 | 1020.00 | 33.00 | 20.00 | 53.00 | 1073.00 | 3.58 | 5.2% | 3.58 |
| Total · 3 lines | 1500 | 0 | 3270.00 | 165.00 | 100.00 | 265.00 | 3535.00 | ×1.0810 | 8.1% | |||
| Cost line | Method | Bill | In USD | Allocated | Closes |
|---|---|---|---|---|---|
| Customs broker — entry + ISF · Brokerage / clearance | By quantity | 165.00 USD | 165.00 | 165.00 | Σ to the cent |
| Pre-shipment inspection · Sample / QC inspection | By quantity | 100.00 USD | 100.00 | 100.00 | Σ to the cent |