How to Build a Landed Cost Support Schedule for QuickBooks Online

October 6, 2026

Bottom line: Landed cost should be reconstructed from the purchase and logistics evidence, not estimated from the difference between a supplier bill and a bank payment. Create a receipt-level schedule, define which acquisition costs qualify under approved policy, choose a defensible allocation driver, and tie the result to inventory records, bills, customs documents, and the general ledger.

Define the cost boundary before calculating

“Landed cost” often combines the supplier price with freight, insurance, duty, brokerage, handling, and other charges required to bring goods to their intended location and condition. It should not become a bucket for every cost near an import. Outbound customer delivery, avoidable demurrage, storage after goods are ready for sale, penalties, and administrative overhead may require separate treatment.

Ask the accountant to document included and excluded categories, treatment of purchase discounts, foreign-currency policy, materiality, and when inventory becomes available for sale. Record whether the company uses perpetual inventory in QuickBooks, an external inventory system, or periodic adjustments. The operational schedule must fit that system rather than pretending QuickBooks is the only subledger.

Create one shipment or receipt identifier that follows the purchase orders, supplier invoices, bills of lading, packing lists, customs entries, freight invoices, warehouse receipts, and QuickBooks transactions. If a container carries several purchase orders, preserve both the container ID and the individual lines. If one purchase order arrives in stages, do not allocate the entire shipment cost to the first receipt.

Assemble the shipment population

At line level, record item or SKU, description, quantity ordered, quantity received, unit purchase price, currency, supplier invoice, receipt date, weight, volume, tariff classification when relevant, country of origin, duty, and exception status. Reconcile received quantities to warehouse evidence and investigate shortages, damages, substitutions, and units in transit.

Then list each additional cost document with vendor, invoice date, service, currency, shipment reference, amount, tax, approved cost category, and allocation method. Directly assign costs when evidence identifies one SKU or purchase order. Pool only genuinely shared charges. This avoids spreading a product-specific inspection fee across unrelated goods.

Suppose a shipment has 600 light units costing 12,000 and 100 heavy units costing 8,000. Freight is 2,400 and duty is 1,600. If freight is driven by weight while duty follows customs value, allocating both by unit count distorts the heavy products. The schedule can assign freight by documented weight and duty by dutiable value, then show each product’s purchase cost, allocated additions, total landed cost, and unit landed cost. The example illustrates traceability, not a universal allocation rule.

Make allocation logic testable

Common drivers include quantity, supplier value, weight, volume, and direct assignment. State the chosen driver for each cost pool and why it reflects the underlying charge. Keep the denominator visible. A reviewer should be able to recompute an allocation from source columns without reverse-engineering hidden spreadsheet formulas.

Add checks that allocated amounts equal each source invoice, no receipt line receives a negative or duplicate allocation, and zero-quantity lines are resolved. Round at a defined level and place any small rounding remainder on a transparent line rather than burying it in one SKU. Lock formulas or use a reviewed template, but preserve input evidence separately.

Foreign currency adds two dates: the supplier or service transaction and the payment. Record original currency, source amount, approved exchange rate, functional-currency amount, and later settlement difference. Do not roll payment-date exchange differences into unit cost automatically. Escalate the distinction to the accountant and follow the company’s policy.

Connect the schedule to QuickBooks

Tie purchase invoices to accounts payable and payments without losing gross amounts. Tie inventory receipts to the item records or external subledger. Tie freight, broker, and duty bills to the schedule. Then compare the approved landed-cost adjustment or product-cost update with the schedule total and document the posting reference.

Avoid entering a logistics bill as expense and also including it in an inventory adjustment unless the approved entry relieves the original account. That creates duplicate cost. Conversely, capitalizing a charge in a spreadsheet without a corresponding book entry leaves inventory and the ledger inconsistent. The bridge should show source postings, reclassification or allocation, and ending accounts.

Intuit provides guidance on tracking inventory in QuickBooks Online. Exact features depend on subscription and configuration, so confirm current behavior before designing the entry path. U.S. importers can use Customs and Border Protection entry-summary resources to identify authoritative customs evidence, while classification and accounting judgments remain with qualified specialists.

Reconcile after receipt and after sale

At close, roll forward shipments in transit, received-not-finalized costs, inventory additions, and open logistics bills. Compare the landed-cost schedule with the inventory subledger and general ledger. Review receipts lacking freight documents, bills without shipment IDs, cost pools awaiting allocation, negative quantities, late duty assessments, and inventory sold before final costs arrived.

When a late bill arrives, identify the affected receipt and whether inventory remains on hand. Do not silently overwrite prior numbers. Prepare the incremental allocation and let the accountant decide the treatment of amounts related to sold units, current inventory, or a closed period. Preserve the former schedule, revised schedule, reason, approval, and entry.

The completed packet contains the policy note, shipment index, receipt population, cost documents, allocation calculations, currency support, QuickBooks bridge, exceptions, posting evidence, and reviewer signoff. A virtual assistant can gather and normalize that evidence, maintain the schedule, and prepare tie-outs, while accountants and customs professionals retain classification decisions. QBOAssistant can help through QuickBooks bookkeeping support or a consultation.

Sources

• Intuit: Set up and track inventory in QuickBooks Online
• U.S. Customs and Border Protection: Entry summary