Sold, Bookkeeping Featured image alt: Inventory valuation in QuickBooks and Xero — TaxKitab Last Updated: 8 October 2026
When a product business says its margins look wrong, the inventory account is where we start. Usually the problem is not pricing. It is that the closing stock figure in the ledger stopped representing anything real some months ago.
Inventory valuation in QuickBooks and Xero drifts because both platforms will let the ledger and the warehouse disagree. The main causes are negative stock quantities, landed costs left out of item cost, stock adjustments posted to the wrong account, and a closing figure that has never been checked against a physical count.
Inventory and COGS not tying to your gross margin? WhatsApp us the period and we will tell you where it broke.
Quick Summary
| Problem | How it happens | Effect on the accounts |
| Negative stock quantity | Sale recorded before the purchase | COGS posted at a guessed cost; margin distorted |
| Landed cost not in item cost | Freight, duty and clearing booked as expense | Inventory understated, COGS overstated early |
| Adjustments to the wrong account | Write-offs posted to purchases or a suspense account | COGS and inventory both wrong, in opposite directions |
| No physical count | Perpetual records trusted indefinitely | Closing stock is an assumption, not a figure |
| Mixed costing methods | Average cost in software, FIFO assumed in reporting | Gross margin not comparable period to period |
💡 TaxKitab Tip Run the inventory valuation report at a period-end date and compare its total to the inventory balance on the balance sheet at the same date. In a clean file these agree to the rupee, dollar or dirham. When they do not, the difference is almost always a stock adjustment or a bill posted straight to an expense account instead of through the item. That one comparison, done monthly, catches most of what follows — and it takes a minute.
Negative Stock Is Not a Warning, It Is a Valuation Decision
Both platforms will let you sell an item you do not have on hand. When that happens the software still has to post a cost of sale, so it uses the last known cost or an average that no longer reflects anything.
When the purchase is later entered, the software may or may not restate the earlier cost of sale. QuickBooks recalculates on a FIFO basis and can shift prior-period COGS; Xero will not let a tracked item’s quantity go negative at all, which pushes the problem into untracked items instead.
Either way the gross margin for the month is wrong. For e-commerce businesses — where sales land in the ledger via an integration before the supplier’s purchase invoice arrives — this is the default state, not the exception. Run a negative-quantity check at each period-end, and enter purchase bills before reconciling the sales they relate to.
Landed Cost Belongs in the Item, Not in the Expense Ledger
Freight inward, customs duty, clearing charges, insurance in transit and inspection costs are part of what the stock cost you. Booked to separate expense accounts, they leave inventory understated and the early months of a shipment’s life looking more profitable than they were.
Neither QuickBooks Online nor Xero has strong native landed-cost allocation. Three practical options:
- Enter freight and duty on the same bill as the goods, allocated across item lines by value or weight.
- Use a landed-cost add-on or inventory app that feeds the ledger with the loaded cost already applied.
- Post the costs to a holding account and allocate by journal at period-end, consistently, with the working kept.
Pick one and stay with it. The common failure is doing it properly on large shipments and skipping it on small ones, which makes item cost incomparable across the catalogue.
Stock Adjustments Posted to the Wrong Account
Damage, shrinkage, obsolescence, samples and own consumption all reduce inventory. Where the offsetting debit goes determines whether the accounts make sense.
Write-offs posted to purchases inflate purchases and leave cost of sales understated. Posted to a suspense account, they sit there until someone clears them at year-end, usually to the wrong place. The adjustment needs its own expense line — inventory write-off or shrinkage — so it is visible and separable from normal cost of sales.
This matters beyond tidiness. A business carrying genuine shrinkage of two or three percent cannot see it if the write-offs are buried in purchases, and will spend its time looking at supplier pricing instead of at the warehouse.
A Closing Figure Nobody Has Counted
Perpetual inventory records are a continuously updated estimate, not a count. Over twelve months they drift — miscounts on receipt, unrecorded breakage, picking errors, returns that never came back into stock.
A full count once a year is the minimum. Cycle counting — a rotating subset of high-value or fast-moving lines each month — catches drift much earlier and is far less disruptive. Whichever you do, the adjustment arising from the count is the point of the exercise, and it has to be posted, not noted and ignored.
Where stock sits in more than one location or with a third-party fulfilment provider, reconcile each location separately. A group total that ties while the locations do not is a coincidence, not a reconciliation.
Costing Method Stated, Not Assumed
QuickBooks Online uses FIFO for inventory items. Xero’s tracked inventory uses weighted average cost. If the management reporting or the statutory accounts assume something else, gross margin and closing stock will not agree with the method actually in use.
Write it down once, in the accounting policy, and check it against what the software is doing. Changing method part-way through a year without disclosing it makes two periods incomparable and will be queried on audit.
The Monthly Routine
- Inventory valuation report total versus balance sheet inventory balance, same date.
- Negative-quantity report — resolve every line.
- Items with a zero or blank cost — these produce 100% gross margin and are always wrong.
- Stock adjustment account reviewed line by line, with a reason against each.
- Landed costs for the month allocated or journalised.
- Gross margin by item category compared to the prior two months, with any movement over a few percentage points explained.
Six checks, and most of a product business’s reporting problems stop recurring. Inventory and indirect tax also interact more than people expect — a stock adjustment with the wrong tax code distorts both, so the VAT and sales tax coding checks belong in the same session. Founders who want the margin story rather than the ledger detail should start with the financial metrics worth tracking, and CPA firms considering an offshore team for this work will find the model in outsourcing bookkeeping to India.
Frequently Asked Questions
Why does my gross margin change when I enter an old purchase bill? Because the earlier sale was costed at a guessed figure while stock was negative, and entering the bill lets the software restate it. The margin did not change; the first version was wrong.
Should freight outward go into inventory cost too? No. Freight inward is a cost of acquiring the stock and belongs in the item cost. Freight outward is a cost of selling and belongs in operating expenses.
Can I run inventory outside QuickBooks or Xero and just post totals? Yes, and beyond a few hundred SKUs it is often better. The requirement is that the external system’s closing valuation reconciles to the ledger balance each period, with the difference explained rather than plugged.
What does a zero-cost inventory item do to the accounts? It records the sale with no cost of sale, so the item shows full gross margin and inventory is never relieved. It is one of the fastest things to find and one of the most distorting.
Does TaxKitab handle inventory for overseas clients? Yes, as part of accounting and bookkeeping — valuation, reconciliation, landed cost allocation and the monthly checks above. Tax filing in overseas jurisdictions is not in our scope.
References
- QuickBooks Online inventory costing documentation, on FIFO valuation for inventory items
- Xero Central inventory costing guidance, on weighted average cost for tracked items
- Inventory measurement requirements under IFRS, UK GAAP and US GAAP
⚠️ Software behaviour on negative stock and cost recalculation changes between releases, and measurement requirements differ by framework. Test on your own file and confirm with whoever prepares the statutory accounts.
Call or WhatsApp: +91 7448200422 | Email: info@taxkitab.com
See our Outsourced Accounting service for product businesses outside India, or the USA and UAE pages for how engagements run. Get in touch.
