How to Allocate Landed Cost on GRN

FOB-only costing hides margin erosion on imports

Buyers negotiate supplier FOB prices but margin collapses when freight, duty, and handling are expensed separately from inventory value.

Spreadsheet landed-cost calculators applied monthly never match the stock ledger finance uses at month-end.

Without GRN-level allocation, slow-moving import SKUs show healthy unit margin on reports while true landed cost is underwater.

Why this happens

• Freight and duty invoices are booked to expense instead of inventory.
• Landed cost is estimated as a flat percent rather than allocated per shipment.
• Packaging weight is ignored when allocating by weight.
• GRN is posted before carrier and customs invoices arrive.

Biznsbook addresses this through landed cost allocation, GRN freight and duty, weighted average cost when Inventory, Warehouse, and Purchase modules are licensed — receipts, allocations, and match scores post to the same stock ledger sales and accounting consume.

Finance teams lose days each month reconciling versions that should never have diverged. Naming Biznsbook screens as the system of record — and closing periods when agreed — prevents silent edits that auditors flag immediately.

Step-by-step: Allocate Landed Cost on GRN

Built for warehouse managers, buyers, and finance leads running receiving, costing, and accounts payable controls in Biznsbook.

1. Post GRN with line quantities and FOB value. Receive goods on GRN with supplier line costs as the base before adding landed charges.
2. Collect freight, duty, and handling documents. Gather carrier bills, customs entries, and handling fees tied to the shipment reference on the GRN.
3. Open landed cost allocation on the GRN. Use landed cost allocation on GRN lines to spread charges across received quantities or weight per your allocation method.
4. Allocate by quantity or weight. Choose quantity-based spread for uniform SKUs; use weight-based allocation when packaging BOM weights exist on items.
5. Post allocation to update average cost. Approved landed cost posts update weighted average unit cost going forward for affected items.
6. Reconcile with three-way match. Ensure freight and duty vendor invoices align with allocated amounts on the GRN before payment.
7. Review valuation report after import cycles. Compare inventory valuation and margin reports after major shipments to confirm landed cost flowed to COGS correctly.

Review results after the first full weekly cycle. Adjust roles, mappings, or approvals where the same exception repeats.

Screen-level flows live in the Help Center. This guide focuses on the business process; help articles cover click-by-click navigation.

Common mistakes to avoid

• Mistake 1: Freight and duty invoices are booked to expense instead of inventory. Repeating this each month usually shows up first in stock valuation reports or PO match scores.
• Mistake 2: Landed cost is estimated as a flat percent rather than allocated per shipment. Repeating this each month usually shows up first in stock valuation reports or PO match scores.
• Mistake 3: Packaging weight is ignored when allocating by weight. Repeating this each month usually shows up first in stock valuation reports or PO match scores.
• Mistake 4: GRN is posted before carrier and customs invoices arrive. Repeating this each month usually shows up first in stock valuation reports or PO match scores.

Track recurring exceptions in month-end notes; each should map to a control above.

Best practices that hold up as you scale

• Post GRN with line quantities and FOB value — Receive goods on GRN with supplier line costs as the base before adding landed charges.
• Collect freight, duty, and handling documents — Gather carrier bills, customs entries, and handling fees tied to the shipment reference on the GRN.
• Open landed cost allocation on the GRN — Use landed cost allocation on GRN lines to spread charges across received quantities or weight per your allocation method.
• Allocate by quantity or weight — Choose quantity-based spread for uniform SKUs; use weight-based allocation when packaging BOM weights exist on items.
• Post allocation to update average cost — Approved landed cost posts update weighted average unit cost going forward for affected items.

Teams that separate Fast Receive lanes from formal GRN for catch-weight and compliance SKUs keep dock speed without sacrificing cost accuracy or audit defensibility.

How Biznsbook supports this workflow

landed cost allocation is documented in Biznsbook Inventory & Purchase capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.

GRN freight and duty is documented in Biznsbook Inventory & Purchase capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.

weighted average cost is documented in Biznsbook Inventory & Purchase capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.

Receiving permissions, PO approval, GRN posting, and AP payment are separable roles so dock staff scan quickly while finance retains match-score approval.

Suggested implementation timeline

1. Week 1: Document current process gaps and configure landed cost allocation with finance owner sign-off.
2. Weeks 2–3: Pilot on one month or one entity; post all test transactions through Biznsbook; freeze parallel spreadsheet journals.
3. Week 4: Run first trial balance or report tie-out; fix mapping and permission issues.
4. Month 2–3: Roll out to full team; add approvals and period close cadence from this guide.
5. Ongoing: Monthly review using import shipment close checklist and leadership dashboard.

Related guides and help articles

Help Center: creating a GRN, allocate landed cost, purchase orders.

Modules: Purchase, Warehouse, inventory guides hub.

Allocation method selection

Freight by value works for mixed-SKU containers; by quantity suits uniform cartons; by weight fits dense commodity lines. Document the default per supplier lane so receivers do not choose ad hoc methods that swing unit cost month to month.

Allocate customs and duty in the same pass as freight when possible — splitting across two posting events makes valuation reports harder to reconcile.

Timing relative to AP and inventory valuation

Post landed cost before month-end valuation when goods are in stock — delaying allocation understates inventory and overstates freight expense in the wrong period.

When GRN is partially invoiced, confirm landed cost attaches to received quantity only, not the full PO quantity still in transit.

Import and multi-currency freight

Import GRNs with freight in foreign currency should use the FX rate policy your tax adviser approves on the allocation date, not the PO date, when amounts are material.

Split brokerage fees across all lines in the container when the fee is not SKU-specific — arbitrary allocation to the highest-value line distorts margin on hero SKUs.

Metrics to track monthly

• GRN lines with catch-weight variance above tolerance
• PO match scores below threshold awaiting resolution
• Fast Receive sessions posted same day as delivery
• Import GRNs with landed cost allocated within five days
• Valuation report delta after landed cost post

Start with three metrics; trend direction matters more than a single point-in-time snapshot.

Spreadsheet / manual books vs integrated ERP

Compare typical manual finance work with Biznsbook landed cost allocation and related capabilities.

Import shipment close checklist

Within five business days of GRN post, allocate all carrier and customs charges, reconcile to vendor invoices, and re-run valuation on affected SKUs before releasing standard costs to sales quotes. Keep freight invoices matched to GRN references in AP — auditors trace landed cost from supplier bill to allocation screen.

Document this in your finance SOP and revisit each quarter as transaction volume or entity structure changes.

Frequently asked questions

How this differs by industry