
Business Insights
Shopify Landed Cost Tracking: Freight and Duty
Written from the point of view of an operator who imports stock, sells it on Shopify, and finds that the margin on screen is not the margin in the bank.
11 min read
Partners and services
Help & support
Customers & Tools
By what you sell
Landed cost tracking software for businesses that buy in stock. Freight, duty and other charges go on the purchase order, are spread across the goods by value, and become part of each product’s unit cost when the goods are received, whether you cost by moving average or FIFO.
Purchase order · PO-1057
Landed unit cost
| Item | Price | Landed |
|---|---|---|
| Olive oil | $6.00 | $6.90 |
| Sea salt | $2.50 | $2.88 |
| Glass jars | $9.00 | $10.35 |
Goods
$2,040
Extra costs
$306
Landed
$2,346
The supplier’s price is only part of what stock costs. The freight, the duty and the broker’s fee arrive on other bills, often weeks later. Each one goes on the purchase order it belongs to, and from there into unit cost, margins and the cost of goods sold in your books.
01Capture
Each charge is its own line under the products: sea freight, import duty, insurance, a broker’s fee. Type it Landed Costs and it is spread over the goods. Type it Expenses, as you would an import tax, and it stays on the order without touching unit cost. A forwarder who bills on its own, in its own currency, gets a freight order of its own.
Other Costs · PO-1057
Northwind Supply
| Charge | Type | Amount |
|---|---|---|
| Sea freight | Landed | $210 |
| Import duty | Landed | $96 |
| Import tax | Expense | $234.60 |
02Allocate
Each landed cost is split over the product lines in proportion to their net value, price times quantity, against the order’s total. The split is recalculated every time the order is saved, so a duty bill that arrives late is one more line, not a spreadsheet.
Extra costs · PO-1057
Freight + import duty: $306
| Item | Value | Share | Landed |
|---|---|---|---|
| Olive oil | $1,200 | $180 | $6.90 |
| Sea salt | $300 | $45 | $2.88 |
| Glass jars | $540 | $81 | $10.35 |
03Value
When the goods are received, each line’s landed unit cost becomes the cost of that stock: averaged in under moving average cost, or kept with the delivery under FIFO. That is the cost every sale is charged at, in your margin reports and in the stock value and cost of goods sold journals sent to Xero or QuickBooks Online.
Moving average cost
Olive oil
| Stock | Qty | Cost | Value |
|---|---|---|---|
| On hand | 100 | $6.00 | $600 |
| PO-1057 | 200 | $6.90 | $1,380 |
| New MAC | 300 | $6.60 | $1,980 |
A forwarder’s charges go on a freight order with no product lines, to be allocated across the purchase orders it carried.
Orders and their extra costs in the supplier’s currency, with automatic or set exchange rates.
Landed-cost lines come onto the bill, where their quantity, price and discount can be adjusted.
The Purchases reports show the landed cost on every purchase line and every receipt.
Distributed costs post to your Purchases account, and expense-type costs to the Expenses account you choose.
Products stay non-inventory in QuickBooks, so cost of goods sold comes from Qoblex’s landed cost.
Freight, duty and brokerage from every container, carried by the stock that came in it.
Inventory for importersMargins on thin-priced lines measured against what the goods cost to land, not the supplier’s price.
Inventory for distributorsImported ingredients and packaging costed with their freight and duty, so every line’s margin is real.
Inventory for food and beverageIf you buy from one domestic supplier, in one currency, with no duty, a spreadsheet or the bills in Xero or QuickBooks will do. Qoblex earns its place when one freight bill has to be split across many products, shipment after shipment.
| Feature | Spreadsheet | Accounting software | Qoblex |
|---|---|---|---|
| Record freight and duty against a purchase | By hand | Yes | Yes |
| Split one freight bill across many products | By hand | Limited | Yes, by value |
| Landed cost in each product’s unit cost | By hand | Limited | Yes |
| Unit cost updated at receipt | No | Limited | Yes |
| A forwarder’s bill in another currency | By hand | Yes | Yes, as a freight order |
| COGS at landed cost on every sale | By hand | Limited | Yes |

This app is one of the best investments ever! Our inventory problems have been solved. 90% of our products are bundles/composites and Qoblex works perfectly with these types of products. Support is awesome!
Integration ecosystem
Native integrations and open APIs let you easily connect data across your existing digital toolkit. Enhance your operations without changing the workflows you’ve spent years perfecting.








Freight, duty, allocation, currencies and accounting.
Landed cost tracking software records the charges that come with a purchase, such as freight, duty, insurance and brokerage, against the purchase order they belong to, spreads them over the goods, and makes the result part of each product’s unit cost. Stock value, margins and cost of goods sold then use what the stock cost to land, not only the supplier’s price.
Landed cost is the total cost of getting one unit of inventory into your warehouse and ready to sell. It is the supplier’s invoice price plus freight, customs duty, insurance, and any handling or brokerage fees. It is almost always higher than the invoice price, and it is the number your margins depend on.
Add the product cost, freight, customs duty, insurance, and any handling or brokerage fees for the shipment, then divide by the number of units to get a per-unit figure. It gets awkward when one shipment holds several products and the cost has to be split between them. The free landed cost calculator does that split for you and returns per-unit cost, blended cost, and a landed cost factor.
By value. Each line item receives a share of the extra costs in proportion to its own net value (price times quantity) against the total net value of the order, and the split is recalculated automatically when you save. This is the only allocation method available: Qoblex does not offer allocation by quantity, weight, or a manual split.
Yes. Once an extra cost is allocated to a line item it raises that product’s landed unit cost, and that cost becomes part of the cost of the stock when the goods are received, under moving average cost or FIFO. From then on it is the cost used in COGS and margin reporting, rather than the raw invoice price.
Both are extra cost lines on the order. A line typed Landed Costs is spread over the products and raises their unit cost. A line typed Expenses, such as import VAT, stays on the order and is billed like any other charge, but does not change unit cost. In Xero, expense-type lines post to the Expenses account you choose.
Yes. Duty goes on its own cost line with its own description, so you can see what was freight and what was duty on the same order. Charges that should not sit in inventory value, such as VAT, can be flagged as an order-level expense instead. Duty amounts are entered manually. There is no automated tariff code lookup or customs classification.
Yes. Raise a freight order for the forwarder’s charges, in the currency they bill in. A freight order has no product lines, only cost lines, and its costs can be allocated across the regular purchase orders the shipment carried. See create a purchase order.
Yes. Supplier bills, with their landed-cost lines, post to Xero or QuickBooks Online once they are authorized, along with bill payments, and your accounting platform stays the book of record. The stock value and cost of goods sold journals Qoblex sends are worked out at landed cost, so COGS in your books includes the freight and duty. Accounting integrations are paid add-ons on the Starter and Business plans and included on Scale; see pricing.
If you buy from one domestic supplier, in one currency, with no import duty and only a handful of purchase orders a month, a spreadsheet is genuinely fine. The effort is small and the chance of a materially wrong number is low. Dedicated tracking starts to pay off when you import regularly, when one freight or duty bill has to be split across many SKUs per shipment, or when you need true cost to appear in margin reports on its own rather than as an expense line disconnected from the product it belongs to.
Yes. The landed cost calculator takes product cost, freight, duties and taxes, insurance, and other fees across multiple product lines and returns per-unit landed cost, blended landed cost, and a landed cost factor, using the same by-value allocation described above. Run one real shipment through it. If the answer surprises you, you have your answer about automating it.

Business Insights
Written from the point of view of an operator who imports stock, sells it on Shopify, and finds that the margin on screen is not the margin in the bank.
11 min read

Business Insights
Food producers undercost products when freight, duties, and yield loss never reach COGS. How accurate food costing and landed cost work, and what inventory software must support.
13 min read