Receiving
Partial receiving: only the units that arrived share the costs
Half the order lands this week, the rest next month. Each receipt allocates only its own bills across only the units that came off the truck — never across the whole PO.
The rule in one paragraph
A receipt is a set of lines with a received quantity. Costs attached to that receipt are split across those received units only. Lines with 0 received take nothing, and rejected units take nothing. When the balance of the order arrives, it is a second receipt with its own freight and clearance; both receipts roll into the SKU’s moving average on the web plan.
Why the obvious shortcut is wrong
Allocating the first shipment’s courier bill across the whole PO (including 300 tees still at sea) understates the cost of the 580 tees you can sell today and parks part of a real, paid bill on goods you do not have. When the second shipment arrives with its own bill, those tees get charged twice.
A worked example
PO-2255: 900 tees ordered, 600 shipped, 580 accepted, 20 rejected
The L line (300 ordered) is still on the water and takes nothing. The M line received 300 but 20 were rejected: only 280 units carry freight and clearance.
| SKU | Product / variant | Recv | Rej | Unit USD | Line value | Freight | Brokerage | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AP-TEE-S | Organic tee — S | 300 | 0 | 4.20 | 1260.00 | 344.41 | 30.00 | 374.41 | 1634.41 | 5.45 | 29.7% | 5.45 |
| AP-TEE-M | Organic tee — M | 280 | 20 | 4.20 | 1176.00 | 351.59 | 28.00 | 379.59 | 1555.59 | 5.56 | 32.3% | 5.56 |
| Total · 2 lines | 580 | 20 | 2436.00 | 696.00 | 58.00 | 754.00 | 3190.00 | ×1.3095 | 31.0% | |||
What we record
- Received and rejected per line, per receipt; lines with nothing received are listed as skipped.
- Which bills belong to which receipt.
- On the web plan: both receipts under one PO, with the running average per SKU.
If you only remember one thing
Costs follow the units that physically arrived with them.
Try it
Change any number — the stamp stays balanced
The same engine as the home page allocator, preloaded with the example.
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 | Freight | Brokerage | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AP-TEE-S | Organic tee — S | 300 | 0 | 4.20 | 1260.00 | 344.41 | 30.00 | 374.41 | 1634.41 | 5.45 | 29.7% | 5.45 |
| AP-TEE-M | Organic tee — M | 280 | 20 | 4.20 | 1176.00 | 351.59 | 28.00 | 379.59 | 1555.59 | 5.56 | 32.3% | 5.56 |
| Total · 2 lines | 580 | 20 | 2436.00 | 696.00 | 58.00 | 754.00 | 3190.00 | ×1.3095 | 31.0% | |||
Skipped: AP-TEE-L — Nothing received on this line: it takes no share of this shipment’s costs.
| Cost line | Method | Bill | In USD | Allocated | Closes |
|---|---|---|---|---|---|
| Courier — first shipment · International freight | By weight | 696.00 USD | 696.00 | 696.00 | Σ to the cent |
| Clearance — first shipment · Brokerage / clearance | By quantity | 58.00 USD | 58.00 | 58.00 | Σ to the cent |