Estimated vs final landed cost: truing up when the invoices arrive

The sofas arrived on the 3rd with freight estimated at $6,000. The invoice arrives on the 24th for $7,514. By then, 12 of the 30 sofas have been delivered and their margins reviewed. Where does the extra $1,514 go?

In this illustrative example, the extra freight follows the sofas: $605.60 relates to the 12 sold units and $908.40 to the 18 still in stock. A landed-cost true-up replaces an estimate with the supported final amount and keeps that change connected to the original receipts.

General information, not tax or accounting advice.

Receive with a supported estimate and a named follow-up

An estimate lets the store recognize inbound costs before every invoice arrives. Use the forwarder's quote, the broker's calculation, and agreed vendor charges. Record the supporting reference and what is still missing.

Keep a separate charge for a separate obligation. Freight, brokerage, and a vendor surcharge might arrive on different invoices and cover different goods. Combining them into a single unexplained allowance makes the final review harder.

The landed-cost guide covers the cost components. For the accounting foundation, the IRS cost-of-goods guidance includes inbound transport on merchandise purchased for sale. The point of the estimate is to avoid showing those goods at a bare vendor cost while everyone waits for the carrier's paperwork.

Give the expected invoice an owner and follow-up date. “Waiting for freight” is a status; it becomes a useful task when someone knows which forwarder to contact. By this stage, the sofa should be easier to find than its paperwork.

Separate the cost estimate from the accounting entry

Under a simple accrual approach, the $6,000 estimated freight increases inventory cost and creates a $6,000 landed-cost accrual liability. This describes the economics of the example, not a universal journal entry or a claim that OrderPilot automatically creates that exact accrual account.

Ask your CPA to confirm the accounts, recognition dates, and treatment of sold stock and closed periods. Put the resulting policy into the receiving procedure so staff do not improvise it for every shipment.

The invoice eventually establishes the payable. Reconcile it against the amount already accrued or billed; do not add another full freight cost merely because the final document has arrived. That would turn a true-up into a duplicate expense.

Keep merchandise bills and the forwarder's bill identifiable. If a purchasing integration already sends charge lines into accounting, the accountant needs that mapping before entering a separate carrier invoice. Cost allocation and who must be paid are related records, not permission to record the same cost twice.

Split the difference using the actual units

The freight difference is $7,514 − $6,000 = $1,514. Spread across 30 identical sofas, that is $50.4666… per unit before rounding.

Use the group proportions to preserve the exact total:

Do not multiply a displayed $50.47 by every sofa and post $1,514.10. Rounded unit labels are useful for reading; the document total still has to reconcile to the invoice.

In the simple accrual model, clear the original $6,000 accrual, add the $605.60 and $908.40 adjustments, and recognize the actual $7,514 payable. The earlier merchandise cost is unchanged in this example. A vendor-price correction would be a separate identified change.

Reverse the direction when the final bill is lower

A lower final invoice reduces the affected costs. Suppose the same $6,000 estimate finishes at $5,500. The reduction is $500. With the same 12 sold and 18 held, the simple split reduces cost of goods by $200 and inventory by $300.

Keep the reason and final invoice with the correction. A favorable difference deserves the same review as an unfavorable one: check that the invoice is complete and that a separate accessorial charge is not still on its way.

If some goods were rejected, returned, or allocated differently, rebuild the affected population before using the simple sold-versus-held ratio. The arithmetic above assumes identical pieces and a uniform allocation. Real receipt records decide which units carry the charge.

Read the estimated cost in OrderPilot

Add the purchasing charge as Estimated on the PO. Its cost status remains visible, and the PO list's Needs cost review view helps staff find unfinished costs. That is a work list for the buyer or accountant who owns the missing invoices. The customer order also shows the effect. A hatched cost bar indicates an estimated line cost, while the count of final units shows how much of the order is settled. An owner can read the margin without assuming that every received unit already has a final freight bill.

Review the receipt effect before confirming the invoice

When the final bill arrives, update the existing charge's amount and confirm its status after reconciling the evidence. Review which lines and receipts the charge covers. Whole-PO charges share their cost across kept units, with received units carrying their part on the receipts where they arrived.

The charge preview identifies the receipt effects of the change. Check that the invoice belongs to the shipment shown and that it has not already been included in another charge. A cost correction can update the cost associated with units already sold. You do not reopen the customer's commercial order, request another signature, or change the agreed selling price simply because the carrier charged more. The store's gross profit changes; the customer's agreement does not.

Use margin by order to examine that result, and retain the reason so a later reviewer can understand why the cost moved.

Keep final cost separate from finalizing the PO

Final cost means the necessary cost information has been reviewed. Finalizing a PO is a lock on further edits. Treat the two as separate decisions.

A PO can be finalized after receiving without that action proving all estimated charges are complete. Once finalized, further charge work requires an authorized reopening with a reason. Finish the cost review before using finalization as the purchasing closeout.

If a late bill arrives after closeout, use the supported reopening and correction process. Keep the correction on the original receipt so the record continues to describe the delivery that occurred.

Understand what reaches QuickBooks

With QuickBooks Online connected and mapped, OrderPilot creates a bill for each receipt. While the PO is open, the bill remains unpaid, no correction document has already been created, and its accounting period is open, a supported correction can update that bill.

When those conditions no longer permit a direct update, the difference is represented through the supported correction flow, such as a supplemental bill for additional cost or a vendor credit for a reduction. Reconcile the resulting documents to the original receipt and invoice.

Cost of goods can be posted using current costs or held for final costs, according to the configured setting. Later supported changes are sent as differences from what has already been posted. The QuickBooks setup guide explains the mapping decisions. The posting date follows the transaction and correction rules, including the connected company's closing-date controls. Keep the invoice date, original receipt date, and correction date as distinct facts. A closed period needs an approved accounting treatment, not a backdated edit made to improve an old margin report.

Make cost review a routine with an end

Review estimated charges weekly as a suggested operating habit. Ask whether the invoice has arrived, whether the estimate still reflects the expected service, and what prevents closure. Use your own freight-budgeting history to improve the next estimate.

Before month-end, resolve the invoices available and identify those still outstanding. Before quarter-end, escalate anything unresolved for the close process rather than marking an unconfirmed amount final. Keep the supporting estimate and next action visible.

The shipment is finished when its costs can be explained from the record. Follow one receipt through the PO-to-QuickBooks cost walkthrough to check that the final amount reached every place it needed to go.

Sources

1. Publication 334: cost of goods sold — Internal Revenue Service, 2023 tax-year edition.