
Business Insights
Shopify COGS Accuracy: The Cost-Per-Item Gap
Written for Shopify operators who opened a profit report, saw a margin that did not match reality, and went looking for the reason.
8 min read
Partners and services
Help & support
Customers & Tools
By what you sell
Inventory costing software that works out again what each unit cost every time goods are received, freight and duty included. Every sale is costed at that figure, so its margin is real, and the cost of goods sold posts to Xero or QuickBooks.
Moving average cost
Olive oil
| Qty | Unit | Value | |
|---|---|---|---|
| On hand | 100 | $6.00 | $600.00 |
| PO-1057 | 200 | $6.90 | $1,380.00 |
| New average | 300 | $6.60 | $1,980.00 |
Most margin reports are a month behind, because the cost behind them is rebuilt at month end. In Qoblex the cost moves when the goods arrive, every sale reads it, and the same figure reaches your books.
01Average
Moving average cost is the value of the stock you hold divided by its quantity. Each goods receipt adds its units at their landed cost and the average is recalculated on the spot, so nobody maintains a formula. Selling reads the cost without moving it, and every change shows on the product’s stock history beside the movement that caused it.
Stock transactions
Olive oil
| Qty | MAC | Value | |
|---|---|---|---|
| Opening | 100 | $6.00 | $600.00 |
| PO-1057 | + 200 | $6.60 | $1,980.00 |
| SO-2318 | − 48 | $6.60 | $1,663.20 |
02Margin
When a shipment goes out, Qoblex records its cost of goods sold: the quantity shipped times the moving average cost at that moment. Every sales order line shows its COGS and margin, marked as estimated until the goods are dispatched, and the sales reports add them up by product or customer, so a thin margin shows while you can still act on it.
Shipment · SO-2318
Olive oil
Shipped
48
MAC
$6.60
COGS
$316.80
03Books
Every stock movement posts its value to your accounting system, Xero or QuickBooks Online, as a journal: stock on hand, cost of goods sold, and adjustments such as write-offs, each to the account you map. Your accounting system stays the book of record and holds the same cost the warehouse works from, so month end is a review rather than a rebuild.
Inventory journal · SO-2318
Olive oil shipped
| Account | Debit | Credit |
|---|---|---|
| COGS | $316.80 | |
| Stock on hand | $316.80 |
Stock on Hand shows the moving average cost and total cost of every variant.
Historic Inventory exports what a location held on a date, with its cost.
Set a new moving average cost on many variants at once, and the revaluation reaches your books.
Trace the movement that set a cost to 0, and repair the sales it touched.
Components at moving average cost, plus labour and overhead, divided by what the run yielded.
Keep products untracked in Xero so only the cost Qoblex calculates is posted.
Freight and duty on every shipment land in the unit cost of the goods they carried.
Inventory for importersFinished goods take the cost of their components, plus labour and overhead, when production completes.
Inventory for manufacturersStore orders become sales orders in Qoblex and are costed at dispatch like any other sale.
Inventory for ecommerceIf you buy at steady prices, freight is small, and nothing is made in house, a spreadsheet or the average cost in Xero or QuickBooks will do. Qoblex earns its place when the cost on a sale stops matching what the goods really cost.
| Feature | Spreadsheet | Accounting software | Qoblex |
|---|---|---|---|
| Average cost per product | By hand | Yes | Yes |
| Freight and duty in unit cost | By hand | Limited | Yes |
| COGS recorded as each shipment goes out | No | Limited | Yes |
| Made goods costed from their components | By hand | Limited | Yes |
| A record of every cost correction | No | Limited | Yes |
| Stock value on any past date | 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.








Costing methods, COGS, and what syncs to your books.
Inventory costing software works out what each unit in stock cost you, freight and duty included, and keeps that figure current as new stock arrives. Every sale is then costed at that figure, which is what gives you a margin report and an inventory value you can trust without a month-end recalculation.
Average Cost, which is moving average cost, and First In First Out, chosen per variant. Average Cost is the default: every receipt blends into one cost per variant, which suits a business whose purchase prices drift between orders. Under FIFO a sale is costed from the stock it uses up. A variant’s method cannot be changed while any location holds stock of it, so decide with your accountant before the first receipt.
It updates when goods are received, which is the moment the cost actually changes. There is no overnight job and no month-end recalculation. A purchase at a new price moves the average as soon as the receipt is recorded, and every sale after that reads the new figure. To see the arithmetic on your own numbers, try the moving average cost calculator.
They are included, as long as you record them on the purchase order. Extra cost lines are distributed across the line items by value and raise each product’s landed unit cost before it reaches costing. They do not sit in a general expense account disconnected from the goods that caused them. See landed costs.
It syncs to Xero or QuickBooks Online. Each stock movement posts a journal to the accounts you map, for stock on hand, cost of goods sold and inventory adjustments, so nobody writes a month-end journal to make the books agree with the warehouse. Your accounting platform stays the book of record. Accounting integrations are paid add-ons on the Starter and Business plans and included on Scale; see pricing.
Yes. The Stock on Hand report shows the moving average cost and total cost of every variant against the live position, so you can read what your stock is worth right now. For a date in the past, Historic Inventory exports what a location held on that day, with its cost.
If your product count is small and steady, purchase prices are flat and freight is small, a monthly spreadsheet is a reasonable system. The comparison above shows where it stops keeping up: prices that vary between orders, freight and duty large enough to matter, and more sales than a monthly recalculation can follow.
No. Keep the products Qoblex manages untracked in Xero, or as non-inventory items in QuickBooks. If both systems track an item, each keeps its own average cost and books its own cost of goods sold, and the two will not reconcile. Untracked, the only cost posted is the one Qoblex calculated, landed costs included.
Because the product’s moving average cost was zero when it shipped, usually after stock came in without a cost: an adjustment or stocktake import at 0, or a purchase received at a price of 0. Correct the cost on the product and later shipments are costed properly. Sales that already shipped need repairing, as fixing sales with zero COGS explains.

Business Insights
Written for Shopify operators who opened a profit report, saw a margin that did not match reality, and went looking for the reason.
8 min read

Business Insights
Inventory represents one of the largest investments for most businesses, yet many business owners struggle with accurately determining its value. Whether you’re preparing financial statements, calculating taxes, or making strategic business decisions, understanding inventory value is crucial for your company’s financial health and compliance. In this comprehensive guide, we’ll explore everything you need to know […]
29 min read

Business Insights
A plain answer to the question most growing product businesses ask at some point: can one piece of software run both my books and my stock?
12 min read