Every business that sells physical products faces the same fundamental challenge: understanding the true cost of each item. On the surface, it seems straightforward—you pay a supplier, and that’s your cost. But in reality, the purchase price is only the beginning of the story.
Shipping fees, customs duties, insurance, handling charges, and currency conversion costs all add up. When these expenses aren’t properly allocated at the unit level, your cost data is incomplete—and so is every decision you make based on it.
This is where the concept of granular profitability comes in. It’s the ability to understand the actual profit margin on every single product you sell, after accounting for all associated costs. And it starts with one critical step: getting your landed costs right.
In this guide, we’ll break down what landed costs are, how to allocate them accurately, the complexities that make manual tracking unsustainable, and how inventory management software like Qoblex automates the entire process.
Why Granular Profitability Matters for Growing Businesses
Sales revenue is often the first metric businesses track. It’s visible, easy to measure, and feels like a reliable indicator of performance. But revenue alone tells you nothing about how much money you’re actually keeping. Two products can generate identical revenue while delivering vastly different margins—and without accurate cost data, you’d never know the difference.
Granular profitability means understanding the actual profit contribution of each product in your catalog, down to the SKU or variant level. It transforms decision-making by answering critical business questions:
• Which products deliver the highest return relative to their total cost of acquisition?
• Are any products actually losing money once all costs are factored in?
• Which suppliers offer the best value when freight and duties are included?
• How should I adjust my pricing strategy to protect margins across channels?
• Where should I focus marketing spend for maximum profitability?
Without this level of insight, businesses risk over-investing in low-margin products, underpricing high-value items, or making strategic decisions based on incomplete data. For eCommerce brands, wholesalers, and manufacturers operating on tight margins, that’s a risk that compounds over time.
What Are Landed Costs? A Complete Breakdown
Landed cost is the total cost of getting a product from your supplier’s door to your warehouse, ready for sale. It goes well beyond the supplier invoice and captures every expense incurred during the procurement process.
Components of Landed Cost
A comprehensive landed cost calculation typically includes:
• Supplier price (FOB cost) – The base cost of the goods as invoiced by your supplier.
• International shipping and freight – Ocean, air, or ground transportation costs to move goods from origin to destination.
• Customs duties and import tariffs – Government-imposed taxes based on the product’s HS code, origin country, and declared value.
• Insurance – Coverage for loss or damage during transit.
• Port handling and terminal charges – Fees for unloading, storing, and processing goods at the port of entry.
• Domestic transportation – Last-mile delivery from port or customs clearance to your warehouse.
• Warehousing and handling fees – Costs for receiving, inspecting, and storing goods upon arrival.
• Broker and compliance fees – Customs brokerage services, documentation, and regulatory compliance costs.
The challenge is that most of these costs are not expressed on a per-unit basis. They arrive as lump-sum invoices covering an entire shipment—which means you need a systematic method to distribute them across individual products and quantities.
How to Allocate Landed Costs Across Products
The most common and widely accepted method is value-based allocation: distributing additional costs proportionally based on each product’s share of the total shipment value. This approach is intuitive, fair, and aligns with standard accounting practices.
Example: Basic Landed Cost Allocation
Imagine you import two products in a single shipment:
| Units | Unit Price | Total Value | |
| Product A | 100 | $10.00 | $1,000 |
| Product B | 50 | $20.00 | $1,000 |
| Total | 150 | $2,000 |
The additional landed costs for this shipment (freight, duty, insurance, handling) total $500.
Since each product represents 50% of the total invoice value ($1,000 out of $2,000), each receives $250 in allocated landed costs:
• Product A: $250 ÷ 100 units = $2.50 per unit → Final unit cost = $10.00 + $2.50 = $12.50
• Product B: $250 ÷ 50 units = $5.00 per unit → Final unit cost = $20.00 + $5.00 = $25.00
These adjusted costs—$12.50 and $25.00—are the figures your system should use for margin analysis, COGS (Cost of Goods Sold) reporting, and pricing decisions.
Other Allocation Methods
While value-based allocation is the most common, some businesses use alternative approaches depending on the nature of their products:
• Weight-based allocation – Useful when freight costs are primarily driven by weight (e.g., heavy goods).
• Volume-based allocation – Applicable when shipping costs correlate with physical size rather than weight or value.
• Quantity-based allocation – A simplified approach that splits costs evenly per unit, regardless of value.
The right method depends on your product mix. What matters most is consistency—applying the same logic across all shipments ensures comparable data over time.
The Hidden Complexities of Product Costing
A basic landed cost calculation is manageable. But real-world procurement introduces layers of complexity that make manual tracking impractical at scale.
Multi-Currency Transactions
When you source internationally, costs arrive in multiple currencies. Your supplier might invoice in Chinese yuan, freight is billed in US dollars, and customs duties are charged in your local currency. Each amount needs to be converted to your base currency using the exchange rate at the time of the transaction.
Even small exchange rate fluctuations can meaningfully affect your unit cost—especially on high-volume, low-margin products. If your system doesn’t handle multi-currency conversion accurately and automatically, your cost data will drift from reality with every shipment.
Timing Gaps and Provisional Costs
One of the biggest challenges in landed cost management is timing. Goods are often received into inventory before all associated costs are known. Freight invoices may arrive weeks after delivery. Customs duties can be adjusted retroactively. Broker fees trickle in over time.
To keep operations moving, businesses use provisional (estimated) costs when receiving goods, then update them when actual invoices arrive. This is standard practice—but it creates a need for systems that can handle retroactive adjustments cleanly.
Retroactive COGS Adjustments
Here’s where things get particularly challenging. By the time actual costs are confirmed, some of the goods from that shipment may have already been sold, shipped, or transferred between warehouses.
Example: Cost Adjustment After Partial Sale
Using our earlier example, suppose you initially recorded Product A at $12.50 per unit based on an estimated $500 in total landed costs. After receiving the final invoices, the actual total turns out to be $600.
The recalculation:
1. Product A’s revised share: $300 (50% of $600)
2. New per-unit landed cost: $300 ÷ 100 = $3.00
3. Revised unit cost: $10.00 + $3.00 = $13.00 (was $12.50)
If you’ve already sold 60 units at the provisional cost of $12.50, your COGS for those transactions is understated by $0.50 per unit—a total of $30. Your system needs to retroactively adjust:
• The COGS for the 60 units already sold (from $750 to $780)
• The inventory valuation for the 40 remaining units (from $500 to $520)
• The corresponding entries in your accounting system
Handling this manually across hundreds of SKUs, multiple shipments, and various sales channels is not just difficult—it’s a recipe for financial inaccuracies that compound quarter after quarter.
Why Spreadsheets Aren’t Built for Landed Cost Management
Many growing businesses start by tracking costs in spreadsheets. It works—for a while. But as order volume increases, supplier relationships multiply, and international sourcing becomes the norm, the limitations of manual tracking become unavoidable:
• No real-time synchronization. Spreadsheets are static. They don’t update when a purchase order is received, a sale is made, or a cost adjustment arrives.
• Error-prone formulas. A single broken reference or copy-paste mistake can cascade across your entire cost model.
• No retroactive adjustment capability. Once a row is written, going back to recalculate COGS across partially sold inventory is extremely tedious and unreliable.
• Currency conversion headaches. Manually looking up and applying exchange rates for every transaction is time-consuming and inconsistent.
• No integration with your sales channels. Spreadsheets can’t pull order data from Shopify, WooCommerce, or Amazon in real time.
• Audit trail gaps. When multiple team members edit the same spreadsheet, tracking who changed what—and why—becomes almost impossible.
As your product catalog and transaction volume grow, the gap between what spreadsheets can handle and what your business needs widens rapidly. The risk isn’t just inefficiency—it’s making pricing and procurement decisions based on outdated or inaccurate data.
How Inventory Management Software Solves the Cost Accuracy Problem
A purpose-built inventory management platform eliminates the manual work and error risk associated with product costing. It centralizes procurement, cost allocation, inventory valuation, and financial reporting into a single, connected system.
Here’s what a robust solution should handle automatically:
• Landed cost capture and allocation – Add freight, duty, insurance, and other costs to any purchase order, and let the system distribute them across products using the appropriate method.
• Multi-currency support – Record costs in any currency, with automatic conversion to your base currency at the correct exchange rate.
• Cost calculation – Automatically recalculate the cost each time new inventory is received, incorporating all landed costs.
• Provisional cost recording and adjustment – Enter estimated costs at receipt, then update with actual figures when invoices arrive—with the system retroactively correcting COGS and inventory valuation.
• Accounting synchronization – Push accurate cost data directly to Xero, QuickBooks, or your accounting platform, ensuring books stay aligned with actual inventory values.
• Granular profitability reporting – Generate per-product, per-variant, per-customer, and per-channel margin reports based on real cost data, not estimates.
How Qoblex Makes Landed Cost Allocation Simple
Qoblex is designed specifically for growing eCommerce brands, wholesalers, and manufacturers who need accurate product costing without the complexity of enterprise systems.
With Qoblex, you can:
• Add landed costs directly to purchase orders – Attach freight, duties, handling, and any other charges to a PO, and Qoblex allocates them automatically across line items.
• Work in multiple currencies seamlessly – Source from international suppliers, pay freight in USD, and record duties in local currency—Qoblex converts everything to your base currency.
• Use Moving Average Cost for accurate valuation – Every time stock is received, Qoblex recalculates the MAC including all associated costs.
• Adjust costs retroactively – When final invoices differ from estimates, update the costs in Qoblex and the system corrects COGS and inventory values across all affected transactions.
• Sync with Xero and QuickBooks Online – Cost data flows automatically to your accounting system, with configurable sync rules for sales, COGS, adjustments, and payments.
• Run detailed profitability reports – Analyze margins by product, variant, customer, channel, sales rep, brand, or time period—all based on accurate cost data.
• Connect your sales channels – Native integrations with Shopify, WooCommerce, and Amazon ensure that sales data and inventory levels stay synchronized in real time.
Whether you’re managing 50 SKUs or 50,000, Qoblex gives you the cost visibility you need to make confident, data-driven decisions.
The Business Impact of Accurate Product Costing
When your product costs are accurate, the benefits ripple through every part of your operation:
• Smarter pricing. Set prices that protect your margins across all channels, knowing exactly where your cost floor sits.
• Better supplier negotiations. Compare landed costs across suppliers—not just FOB prices—to identify who truly offers the best value.
• Optimized product mix. Double down on high-margin products and phase out items that look profitable on revenue but underperform on margin.
• Accurate financial reporting. Your COGS, gross profit, and inventory valuation reflect reality, giving stakeholders and investors confidence in your numbers.
• Faster, more confident decisions. When you trust your data, you don’t need to second-guess every pricing, sourcing, or marketing decision.
Key Takeaways
Getting product costs right isn’t an accounting exercise—it’s a strategic advantage. Every pricing decision, supplier evaluation, and product strategy depends on having accurate, complete cost data at the unit level.
To achieve granular profitability, your business needs to:
4. Capture all landed costs associated with each purchase—not just the supplier invoice.
5. Allocate those costs accurately across individual products using a consistent methodology.
6. Handle multi-currency transactions with proper conversion at the point of recording.
7. Support provisional costing and retroactive adjustments as actual invoices arrive.
8. Automatically update COGS and inventory valuation when costs change.
9. Generate per-product profitability reports that reflect the true cost of acquisition.
Trying to do this manually with spreadsheets might work for a handful of products, but it doesn’t scale. As your catalog, suppliers, and sales channels grow, automation becomes not just convenient—it becomes essential.
Ready to get your product costs right?
Qoblex helps eCommerce brands, wholesalers, and manufacturers manage landed costs, track accurate margins, and make smarter decisions—all from a single platform. Start your free 14-day trial at qoblex.com—no credit card required.
