Receiving

Late costs: the freight bill that arrives after the goods

The duty bill lands three weeks after the pans — and you have already sold 150 of them. Split its share between units sold (a period expense) and units on hand (a cost adjustment).

The rule in one paragraph

A late cost is allocated across the receipt’s lines by value or quantity, exactly like any other bill. Then each line’s share is split by units: the part belonging to units already sold is a cost of the period (it goes to COGS now), the part belonging to units still on hand is added to their unit cost. The receipt’s landed total grows by the whole bill; the on-hand units’ cost grows only by their part.

Why the obvious shortcut is wrong

Dividing the whole late bill by the stock left today loads the duty for 150 sold pans onto the 250 that remain. Their cost per item jumps, this month’s margin looks better than it was, and next month’s looks worse. Ignoring the bill is the other shortcut — then the pans never cost what they cost.

A worked example

PO-2270: 549.00 of duty arrives after 150 of the 400 24-cm pans were sold

Shown first: the receipt as it was costed on arrival (goods only). Below the ledger: the late duty split — 330.90 of it belongs to the 24-cm line (by value), 124.09 is expensed for the 150 sold, 206.81 raises the cost of the 250 on hand.

2 lines · 1 cost line(s) · landed cost factor ×1.0752Σbalanced1/1
SKUProduct / variantRecvRejUnit USDLine valueDutyAllocatedLanded totalLanded unitUpliftNew cost
KC-PAN-24Carbon steel pan 24 cm400011.004400.00330.90330.904730.9011.837.5%11.83
KC-PAN-28Carbon steel pan 28 cm200014.502900.00218.10218.103118.1015.597.5%15.59
Total · 2 lines60007300.00549.00549.007849.00×1.07527.5%

The late duty bill, 549.00, split by value three weeks later

SKUReceivedSold sinceOn handShareExpensedTo inventoryUnit cost
KC-PAN-24400150250330.90124.09206.8111.00 → 11.8272
KC-PAN-282000200218.100.00218.1014.50 → 15.5905
Σ600150450549.00124.09424.91

Goods 4,400 + 2,900 = 7,300. The 24-cm line is 60.27% of value → 330.90 of 549.00 (largest remainder). 150 of its 400 units are sold → 124.09 expensed in this period; 206.81 ÷ 250 on hand = +0.8272 per unit. On the web plan this is the “Add late cost” button on a saved receipt.

What we record

  • The late bill, its date and its basis.
  • Per line: share, sold since receipt, on hand now, expensed part, adjustment part, unit cost before → after.
  • A “late cost” event in each SKU’s history; a receipt with late costs is closed to edits (corrections are new events).

If you only remember one thing

Late money follows the units: sold units expense their share, on-hand units carry theirs.

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 · 1 cost lines · factor ×1.0752Σbalanced1/1
SKUProduct / variantRecvRejUnit USDLine valueDutyAllocatedLanded totalLanded unitUpliftNew cost
KC-PAN-24Carbon steel pan 24 cm400011.004400.00330.90330.904730.9011.837.5%11.83
KC-PAN-28Carbon steel pan 28 cm200014.502900.00218.10218.103118.1015.597.5%15.59
Total · 2 lines60007300.00549.00549.007849.00×1.07527.5%
Add your Shopify product export to get an import-ready CSV
Cost lineMethodBillIn USDAllocatedCloses
Entry 7501 — duty · Duty (from customs entry)By value549.00 USD549.00549.00Σ to the cent
Landed total
7849.00 USD
Have a real shipment? Attach your Shopify export and allocate it in full.Allocate my shipment