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.
| SKU | Product / variant | Recv | Rej | Unit USD | Line value | Duty | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|
| KC-PAN-24 | Carbon steel pan 24 cm | 400 | 0 | 11.00 | 4400.00 | 330.90 | 330.90 | 4730.90 | 11.83 | 7.5% | 11.83 |
| KC-PAN-28 | Carbon steel pan 28 cm | 200 | 0 | 14.50 | 2900.00 | 218.10 | 218.10 | 3118.10 | 15.59 | 7.5% | 15.59 |
| Total · 2 lines | 600 | 0 | 7300.00 | 549.00 | 549.00 | 7849.00 | ×1.0752 | 7.5% | |||
The late duty bill, 549.00, split by value three weeks later
| SKU | Received | Sold since | On hand | Share | Expensed | To inventory | Unit cost |
|---|---|---|---|---|---|---|---|
| KC-PAN-24 | 400 | 150 | 250 | 330.90 | 124.09 | 206.81 | 11.00 → 11.8272 |
| KC-PAN-28 | 200 | 0 | 200 | 218.10 | 0.00 | 218.10 | 14.50 → 15.5905 |
| Σ | 600 | 150 | 450 | 549.00 | 124.09 | 424.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 & 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 | Allocated | Landed total | Landed unit | Uplift | New cost |
|---|---|---|---|---|---|---|---|---|---|---|---|
| KC-PAN-24 | Carbon steel pan 24 cm | 400 | 0 | 11.00 | 4400.00 | 330.90 | 330.90 | 4730.90 | 11.83 | 7.5% | 11.83 |
| KC-PAN-28 | Carbon steel pan 28 cm | 200 | 0 | 14.50 | 2900.00 | 218.10 | 218.10 | 3118.10 | 15.59 | 7.5% | 15.59 |
| Total · 2 lines | 600 | 0 | 7300.00 | 549.00 | 549.00 | 7849.00 | ×1.0752 | 7.5% | |||
| Cost line | Method | Bill | In USD | Allocated | Closes |
|---|---|---|---|---|---|
| Entry 7501 — duty · Duty (from customs entry) | By value | 549.00 USD | 549.00 | 549.00 | Σ to the cent |