Freight arrived after the stock sold: reconcile the landed-cost adjustment

An inbound-freight invoice can arrive after some or all of the goods have been sold. Posting the whole charge to whatever stock remains can overstate ending inventory, while expensing it without checking an existing estimate can duplicate cost. Start with the original shipment and receipt population before deciding how the late amount should flow.

Confirm that the charge qualifies for the proposed inventory-cost treatment under the company's accounting policy. Inbound freight, outbound customer delivery, penalties and other services can require different treatment. The invoice's arrival date does not determine its nature, and a supplier name alone does not identify the relevant shipment.

Obtain the freight invoice, shipment reference, affected receipts, original cost estimate and any earlier accrual or provisional posting. Record whether the charge replaces an estimate, supplements a separate component or corrects an earlier invoice. Those relationships determine what is new in the calculation.

List the estimated cost by type and the records that already carried it into the books. A spreadsheet forecast that was never posted is different from an estimate included in inventory cost and an accrued liability. The reviewer needs to establish which situation actually exists.

Microsoft's landed-cost documentation describes estimated costs followed by actual-cost invoicing through configured clearing processes, with behavior depending on the item's costing method. That is a product-specific workflow to verify. Do not assume every accounting package reverses an estimate or propagates the difference automatically.

Match actual invoices to the estimates they resolve. One shipment can have several carriers or agents, and one supplier bill can cover several shipments. Keep the allocation and settlement relationships explicit so a later invoice does not reverse the same estimate twice.

Preserve unresolved estimated components separately. Receiving the freight bill does not necessarily finalize duty, insurance or another expected cost. Close only the supported portion and retain the remaining estimate with its basis and owner.

Assume a hypothetical receipt contains 1,000 identical units purchased for $10,000. An approved $4,000 inbound-freight estimate was already included in the receipt's recorded cost, producing $14,000 in total and $14 per unit. The later actual freight invoice is $5,000 for the same fully covered cost component.

The incremental cost difference is $1,000, or $1 per received unit under the example's simple allocation. The final total acquisition cost is $15,000, or $15 per unit. Adding the full $5,000 to the previously recorded $14,000 would produce $19,000 and count the original $4,000 estimate twice.

The supplier payable can still be the full $5,000 invoice. That does not mean the new inventory-cost adjustment is $5,000. The prior estimate and associated clearing or accrual treatment explain why the invoice amount and the incremental cost change differ.

Retain the gross invoice, estimate reversal and net cost change in separate columns. A net-only entry of $1,000 may be insufficient to explain the supplier liability and the clearing account, even though it correctly states the additional total cost in this example.

Suppose 750 of the 1,000 units have been sold and 250 remain. Under an explicitly assumed cost treatment that assigns the extra $1 to each unit in this receipt, $750 relates to the sold units and $250 to remaining inventory. The accountant must confirm that this treatment fits the actual cost-flow method and records.

The illustrative sold-unit cost rises from $10,500 to $11,250. Closing stock rises from $3,500 to $3,750. Together, $11,250 plus $3,750 equals the final $15,000 receipt cost. This bridge proves that the extra $1,000 has been allocated once across the same population.

Do not put the full $1,000 into the 250 remaining units merely because they are the only stock still visible. That would add $4 per remaining unit and leave the earlier sales at their old cost. Nor should the reviewer infer the sold population solely from today's total item quantity if other receipt lots have since entered stock.

Trace transfers, production consumption, returns and other dispositions where relevant. Goods may no longer be in the receiving warehouse yet remain in another inventory form. The cost adjustment needs the supported downstream relationship, not a simple assumption that every missing unit was sold.

Microsoft's Business Central item-charge guidance states that adding a charge after an item is sold requires the relevant cost-adjustment process to carry the additional cost to related outbound entries. The document distinguishes the extra value entry from a new physical item movement. Verify both the source charge and its downstream effect in the installed system.

Inspect the relevant adjustment status and resulting entries. An invoice posted successfully to payables does not prove that the inventory and sales-cost updates completed. A separate job, failed record or excluded item can leave the supplier account correct while product margins remain provisional.

Compare the accepted calculation with the ledger and inventory reports after the required processing. Use consistent report dates and valuation settings. A report refreshed before the adjustment and another refreshed afterward can appear inconsistent even when both accurately reflect their extraction time.

Do not solve a failed cost propagation by changing physical quantities or entering a second freight invoice. Have the authorized system owner resolve the specific processing issue, then reconcile its completed output. Keep the original charge reference available so a rerun does not duplicate the adjustment.

A late charge may relate to goods sold in a closed inventory or accounting period. Have the accountant decide the permitted posting date and any required reporting treatment. Backdating a spreadsheet does not reopen the ledger or establish that prior published results should change.

Business Central's cost-adjustment guidance describes how closed inventory periods or allowed posting dates affect adjustment entry dates. Other systems and configurations can differ. Preserve the actual posting date, valuation relationship and management-report period so the review does not imply they must always be identical.

Standard cost and other methods may direct differences to configured variance accounts rather than reproduce the simple per-unit example. Ask the accountant to explain that result using the approved policy. An operational allocation to a shipment remains useful, but it should not be presented as a universal financial-statement entry.

If negative inventory, missing receipt applications or unsupported allocations prevent a reliable downstream bridge, identify the affected population and resolve those records first. A precise freight amount cannot compensate for an uncertain quantity history.

Reconcile the actual invoice, resolved estimate, remaining clearing balance, downstream cost updates and supplier payable. Investigate residuals by cost type and shipment rather than clearing the total because it is old or small. A remaining balance may represent a valid missing invoice or a failed reversal.

When buying landed-cost support, test a shipment with partially sold stock and an existing estimate. Require the provider to explain the full supplier invoice, the smaller incremental cost change and the split between remaining and transferred costs. This is more informative than checking only the unit-cost field on the item master.

Retain the approved allocation, adjustment references and any open components with the shipment record. The final file should explain how the goods reached their complete supported cost and which later reports incorporate it, while preserving the original estimate and the reason it changed.