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.

2 lines · 2 cost line(s) · landed cost factor ×1.3095Σbalanced2/2
SKUProduct / variantRecvRejUnit USDLine valueFreightBrokerageAllocatedLanded totalLanded unitUpliftNew cost
AP-TEE-SOrganic tee — S30004.201260.00344.4130.00374.411634.415.4529.7%5.45
AP-TEE-MOrganic tee — M280204.201176.00351.5928.00379.591555.595.5632.3%5.56
Total · 2 lines580202436.00696.0058.00754.003190.00×1.309531.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 & FX
03Costs
04Allocate & export

01Receipt lines

SKU
Product / variant
Received
Rejected
Unit cost (USD)
Weight / unit (g)
Volume / unit (cm³)
Costs are shared only between lines with a received quantity. Rejected units take no share.

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

2 lines · 2 cost lines · factor ×1.3095Σbalanced2/2
SKUProduct / variantRecvRejUnit USDLine valueFreightBrokerageAllocatedLanded totalLanded unitUpliftNew cost
AP-TEE-SOrganic tee — S30004.201260.00344.4130.00374.411634.415.4529.7%5.45
AP-TEE-MOrganic tee — M280204.201176.00351.5928.00379.591555.595.5632.3%5.56
Total · 2 lines580202436.00696.0058.00754.003190.00×1.309531.0%

Skipped: AP-TEE-L — Nothing received on this line: it takes no share of this shipment’s costs.

Add your Shopify product export to get an import-ready CSV
Cost lineMethodBillIn USDAllocatedCloses
Courier — first shipment · International freightBy weight696.00 USD696.00696.00Σ to the cent
Clearance — first shipment · Brokerage / clearanceBy quantity58.00 USD58.0058.00Σ to the cent
Landed total
3190.00 USD
Have a real shipment? Attach your Shopify export and allocate it in full.Allocate my shipment