Calculate and review landed cost

Create a landed cost batch

Start by creating a batch to hold the shipment, item, and cost details you want to review.

1. Open the Landed Cost workspace.
2. Select New Batch.New Batch
3. Enter Batch ID and Batch Name in the form. Create stays unavailable until both fields are filled.Name
4. Select Create.Create

Add shipment, product, transaction, and cost details

Use the batch detail panel to build the batch. Products are the items that receive the landed cost allocation. Transactions are linked expense lines, and cost components are the additional costs you want to spread across the products.

• Products use Item Code, Qty, and Amount. You can also enter Weight, Volume, and Units Sold for allocation and valuation review.
• Transactions use a transaction name, amount, and currency.
• Cost components use a label, amount, currency, and an allocation basis.
• Files and Section Files let you link file metadata by file name to the batch or to a named section.
• Section files are tied to the section you choose; batch files are tied to the batch itself.

1. Open a batch from the list to see its detail panel.
2. Add one or more products with Item Code, Qty, and Amount. Add Weight, Volume, and Units Sold when you want those values included in allocation and valuation review.AmountItem CodeQtyUnits Sold
3. Link related transactions in the Transactions area by entering a name, amount, and currency.
4. Add a cost component in Cost Components and choose the allocation basis that matches the cost: value, quantity, weight, volume, or manual.
5. If needed, add file metadata in Files or Section Files by entering the file name for the batch or the selected section.Section

How allocation basis values are used

The preview allocates each positive cost component across the products using the basis you choose. The app treats the values you enter as the allocation base for that component, then calculates each item’s share from the relative size of its base value.

• Value basis uses product Amount.
• Quantity basis uses Qty.
• Weight basis uses Weight.
• Volume basis uses Volume.
• Manual basis uses saved per-item manual weights when present.
• If a chosen basis has no positive values, the preview falls back to another available basis and shows a warning.

For each cost component, the allocation is calculated from the component amount and the selected basis. The resulting share is rounded to the currency cent, and any rounding difference is placed on one item so the total stays exact.

Review the landed cost preview

The preview shows the estimated allocation result for the batch. It is a calculation view, not a posted warehouse valuation.

1. With the batch open, select Refresh Preview.Refresh Preview
2. Review the preview totals for Products Total, Additional Cost, Inventory Impact, COGS Impact, and Grand Total.
3. Review the warnings area for any fallback allocation notes or other preview messages.
4. Review the allocation table to see each item’s allocated cost, unit cost delta, units on hand, units sold, inventory impact, and COGS impact.

Understand the preview math and units

The preview uses the product quantity and amount you enter, plus any weight, volume, and units sold values. Each positive cost component is allocated across the products by the selected basis. The batch’s additional cost total is the sum of the cost components that are actually included in the preview; zero-amount components do not add to that total.

• Allocated cost is the item’s share of the additional cost total.
• Unit cost delta is the allocated cost divided by quantity, when quantity is greater than zero.
• Units on hand means quantity minus units sold, with negative results treated as zero.
• Inventory impact is the unit cost delta multiplied by units on hand.
• COGS impact is the unit cost delta multiplied by units sold.
• If quantity is zero, unit cost delta is zero and the preview does not divide by zero.

The preview’s inventory impact and COGS impact are estimated valuation effects. They are not a payment, and they are not a bank balance. They show how the added cost is split between inventory still on hand and cost of goods sold already recognized.

Mark the batch ready and request export

When the batch is complete, mark it ready. After that, you can create the export request. Export does not finish the ledger posting immediately; it queues the landed cost posting for processing in the connected ledger.

1. Open the batch and select Mark Ready.Mark Ready
2. Confirm the batch shows Ready for LCV in the list or Ready in the detail panel.
3. Select Create LCV or Export from the batch actions.CreateExport
4. Review the export check shown after submission, including allocation count, cost component count, and additional cost total.

What to expect after export

After a successful export submission, the batch status changes to queued and the app shows the export reference details. This means the request has been accepted for processing, not that the ledger posting is already complete.

Common problems and recovery

• If you do not see the workspace, your account may not be entitled to the landed cost feature.
• If the batch is missing, confirm you are in the correct workspace and that the batch was created there.
• If export is unavailable, check that the batch has products, a linked purchase receipt, a positive additional cost total, and exactly one active ERPNext integration with a Company binding.
• If the app shows 401 or 403, you are not signed in correctly or you do not have access to the current workspace.
• If the app shows feature_not_entitled, your workspace or plan does not currently include this feature.
• If the app shows not_found for preview or export, the batch ID is not available in the current workspace; reopen the correct batch rather than creating a duplicate.