Tracking product costs for e-commerce means capturing more than what you paid on the supplier invoice. Landed cost includes every expense required to get inventory to your warehouse: international freight, customs duties, broker fees, insurance, domestic shipping from port to warehouse, and inspection costs. Missing any of these components means your cost of goods sold is understated and your profit margins look better than they actually are.

The calculation itself is straightforward. Total all costs associated with a shipment and divide by the number of units received. If you paid $5,000 for 500 units, spent $800 on ocean freight, $400 on customs duties, and $150 on broker fees, your landed cost is $12.70 per unit. That’s your true cost, not the $10 invoice price. Pricing decisions built on the $10 figure will mislead you.

Mixed shipments require allocation. If one container holds three different SKUs, you need to spread the freight and duty costs across all three. Most sellers allocate based on either value or weight. Value-based allocation means each SKU carries freight proportional to its invoice value. Weight-based means each SKU carries freight proportional to its physical weight. Pick a method and apply it consistently. Switching methods makes your historical cost data meaningless.

Your accounting software needs to support this workflow. QuickBooks Online handles basic inventory but requires manual calculation of landed costs. You enter the full landed cost as your inventory value rather than the raw purchase price. For higher volume sellers, dedicated inventory software like Cin7, DEAR, or Ordoro can automate landed cost calculations and push accurate data to your accounting system. The key is getting inventory accounting set up correctly from the start so you’re not cleaning up months of bad data later.

Timing creates complications for international orders. You might receive goods in January, get the freight invoice in February, and receive the customs brokerage bill in March. Some sellers estimate landed costs at receipt and true up later when all invoices arrive. Others wait until all costs are known before entering inventory. Either approach works as long as you apply it consistently and reconcile the differences.

Keep documentation organized by shipment. A folder for each purchase order should contain the supplier invoice, bill of lading, freight invoice, customs entry documents, and broker fee invoice. When your accountant asks why your landed cost on a particular SKU changed from last quarter, you need to show them the paperwork.

Reconcile inventory costs quarterly at minimum. Pull a report showing your calculated landed costs by SKU and compare to actual purchase records. Variances usually mean missed invoices, allocation errors, or costs that landed in the wrong expense account. Small errors compound over thousands of units.

For sellers with significant international sourcing, proper landed cost tracking directly affects inventory valuation on your balance sheet and cost of goods sold on your income statement. Getting this wrong means your financials don’t reflect reality. Phoenix area bookkeeping services that understand e-commerce can help you build systems that capture these costs automatically and give you margin data you can actually trust.