Smart Bookkeeping for Smart Sellers
Learn how to set up and reconcile inventory valuation in QuickBooks and Xero so your inventory asset, cost of goods sold, landed costs, purchase bills, stock adjustments, ecommerce payouts, and tax-ready financial reports stay clean and reliable.
```Inventory valuation in QuickBooks and Xero is the process of recording inventory at the correct cost, keeping inventory on the balance sheet while it is unsold, moving cost into COGS when items sell, and reconciling inventory reports to accounting records.
Inventory is one of the most important accounts for ecommerce sellers, Amazon sellers, Shopify stores, wholesalers, distributors, and product-based businesses. If inventory is recorded incorrectly, your gross profit, net income, balance sheet, tax-ready reports, and product-level profitability can all be wrong.
Many sellers make a common mistake: they expense inventory purchases immediately when products are bought. That may make reports look simple, but it can distort profit timing. In a cleaner inventory accounting workflow, inventory purchases are recorded as an asset first. When inventory is sold, the related cost is moved to cost of goods sold. This creates a better match between revenue and the cost of the products sold.
This guide explains how to think about inventory valuation in QuickBooks and Xero, how to set up inventory items, how to choose accounts, how to record purchase bills, how to handle landed costs, how to reconcile inventory, and how ecommerce sellers can avoid common inventory accounting mistakes.
Main keyword used naturally: Inventory Valuation in QuickBooks and Xero. Related keywords include QuickBooks inventory valuation, Xero inventory valuation, inventory asset reconciliation, COGS reconciliation, landed cost, stock adjustment, tracked inventory, ecommerce inventory accounting, and Amazon seller inventory bookkeeping.
Inventory accounting affects financial statements and tax reporting. QuickBooks and Xero can help track inventory, but software setup should match your accounting method, business model, tax jurisdiction, and CPA guidance. Always confirm your final inventory policy with a qualified accountant or tax professional.
Inventory valuation means assigning a monetary value to inventory on hand. For a product seller, inventory value is not only the number of units sitting in a warehouse. It is the cost value of those units, including the cost method used by the accounting system and the business policy for what costs should be included.
In clean bookkeeping, inventory valuation connects four areas: product purchases, inventory asset, cost of goods sold, and ending inventory. If one part is wrong, the reports can become misleading. For example, if inventory purchases are all expensed immediately, COGS may be too high in the purchase month and too low in the sales month.
Beginning Inventory + Purchases + Direct Inventory Costs - Cost of Goods Sold - Adjustments = Ending Inventory
QuickBooks inventory setup should begin with your chart of accounts and item list. Product sellers need a clear separation between inventory asset, sales income, and cost of goods sold. If the item setup is wrong, sales and purchase transactions can post to the wrong accounts.
Confirm that your QuickBooks plan and settings support inventory tracking. Enable inventory tracking before creating inventory items.
Review the chart of accounts for inventory asset, sales income, cost of goods sold, purchase clearing, and inventory adjustment accounts.
Add inventory items with SKU, name, description, sales price, cost, quantity on hand, and correct accounts.
Enter accurate opening quantity and value only after reviewing your conversion date and historical records.
Use supplier bills or purchase transactions so inventory quantity and value increase correctly.
Run inventory valuation and product reports to confirm quantities, values, COGS, and balance sheet totals.
QuickBooks inventory features and reports can vary by product version, subscription level, and region. Verify the current feature availability inside your own QuickBooks account before final setup.
Xero inventory setup is also built around items, accounts, purchases, sales, and adjustments. Product businesses should decide which items need tracked inventory and which items should remain untracked. Tracked inventory is useful when you need quantities and inventory value to flow through the accounting system.
Confirm whether your Xero plan and organization settings support tracked inventory for the workflow you need.
Create consistent item codes or SKUs so marketplace exports, supplier bills, and accounting reports match.
Assign the correct income, inventory asset, and cost of goods sold accounts to tracked items.
Enter opening quantities and values carefully at the conversion date to avoid duplicated inventory value.
Supplier bills increase inventory, while customer invoices or synced sales reduce inventory and move cost to COGS.
Compare inventory item reports, balance sheet values, stock adjustments, and sales data every month.
Xero inventory features, item limits, and workflows may vary by plan and region. Review current Xero help documentation and your account settings before implementing tracked inventory.
QuickBooks and Xero can both support inventory accounting, but the best choice depends on business size, sales channels, integrations, reporting expectations, and how much detail is needed for inventory reconciliation.
| Area | QuickBooks Inventory | Xero Inventory | Bookkeeping Tip |
|---|---|---|---|
| Best Fit | Small to mid-sized product sellers needing built-in item tracking and reports. | Small businesses needing tracked items, clean invoices, bills, and inventory reports. | Match software to SKU count, channel complexity, and CPA needs. |
| Setup Focus | Products/services list, quantity on hand, inventory asset, income, COGS accounts. | Tracked items, item codes, inventory asset account, sales and purchase accounts. | Avoid creating duplicate SKUs or mixed item naming. |
| Reconciliation | Compare inventory valuation reports to balance sheet inventory asset. | Compare inventory item reports to balance sheet inventory account. | Reconcile monthly, not only at year-end. |
| Ecommerce Sellers | Works best when integrations and item mapping are controlled carefully. | Works best when sales channel data is mapped cleanly to tracked or summary items. | Amazon, Shopify, and marketplace data need careful mapping. |
| Limitations | May need add-ons for advanced warehouse, landed cost, lot, serial, or manufacturing workflows. | May need add-ons for advanced stock control, multi-warehouse, or manufacturing needs. | Use inventory apps when native accounting inventory is not enough. |
Inventory reconciliation means proving that the inventory value in your accounting software is reasonable, supported, and tied to real inventory activity. A clean reconciliation compares accounting records to physical stock, inventory software, marketplace reports, supplier bills, and warehouse records.
Check the inventory asset account balance at month-end. This is the number that must be supported by detail.
Export the inventory valuation, item summary, or stock-on-hand report from QuickBooks, Xero, or inventory software.
Tie the total inventory value from item detail to the balance sheet inventory asset account.
Match supplier bills, purchase orders, landed costs, freight, duties, prep costs, and inventory receipts.
Confirm that sold units reduced inventory and moved cost to COGS in the correct month.
Record shrinkage, damage, lost inventory, write-offs, count corrections, and obsolete stock with support.
Use this checklist at month-end before closing the books. It is especially important for Amazon sellers, Shopify sellers, multi-channel ecommerce sellers, wholesalers, and product businesses with frequent purchase orders.
Landed cost is the full cost of getting inventory ready for sale. For ecommerce and Amazon sellers, landed cost may include supplier product cost, freight, import duties, customs, inspection, prep, packaging, labels, and other costs needed before products are available for sale.
QuickBooks and Xero users often struggle with landed costs because supplier bills, freight invoices, customs charges, and prep costs may arrive separately. If these costs are expensed immediately instead of allocated to inventory, gross margin may be overstated later. If they are duplicated, inventory may be overstated.
The base product cost from the manufacturer, distributor, wholesaler, or supplier invoice.
Inbound shipping, import duties, customs brokerage, and freight costs directly related to inventory acquisition.
Inspection, labeling, bundling, packaging, and prep center costs that prepare inventory for sale.
Landed cost policies should be consistent. Decide which costs are capitalized into inventory and which are expensed, then apply the same method each month unless your accountant recommends a change.
Amazon sellers face additional inventory accounting complexity because inventory may move between suppliers, prep centers, warehouses, Amazon FBA, AWD, removals, returns, replacements, and lost/damaged reimbursement activity. The accounting system may not always match Seller Central quantities without reconciliation.
For Amazon sellers, inventory valuation should connect with Amazon settlement reconciliation, SKU profitability, fee tracking, and monthly bookkeeping. Recording Amazon deposits alone is not enough to understand product-level profit.
Inventory mistakes often build slowly. A few incorrect item mappings, duplicate bills, manual journal entries, or unreviewed adjustments can create large differences between inventory reports and the balance sheet.
Recording purchases directly to COGS can distort profit if products are not sold in the same period.
Opening balances, supplier bills, imports, and manual journals can accidentally record the same inventory twice.
Mismatched SKUs between Amazon, Shopify, warehouse software, QuickBooks, or Xero can break reconciliation.
Freight, duties, prep, and inspection costs may be missed or expensed inconsistently.
Inventory adjustments without documentation make CPA review and audit support harder.
Software quantities should be compared to warehouse, FBA, and physical stock records periodically.
The report names may vary depending on your software version, plan, region, and connected apps, but the goal is the same: compare detailed inventory value to the balance sheet and investigate differences.
| Report / Record | Why It Matters | What to Check |
|---|---|---|
| Balance Sheet | Shows total inventory asset value at month-end. | Tie inventory asset to detailed inventory report. |
| Inventory Valuation / Item Report | Shows quantity and value by item or SKU. | Review negative quantities, zero-cost items, and unusual values. |
| COGS Detail | Shows cost moved from inventory to expense. | Compare COGS to sales volume and product margins. |
| Purchase Bills | Supports inventory additions and landed costs. | Match supplier bills to received inventory and purchase orders. |
| Stock Adjustments | Explains shrinkage, damage, corrections, and write-offs. | Confirm adjustments are approved and documented. |
QuickBooks and Xero can be useful for basic inventory accounting, but product businesses may need dedicated inventory software when operations become more complex. Accounting software is not always the best place to manage every warehouse, lot number, serial number, bundle, manufacturing process, or fulfillment workflow.
Ecommerce sellers should reconcile inventory from several sources, not just accounting software. A clean month-end process may include marketplace reports, inventory app reports, warehouse stock reports, purchase bills, bank payments, and accounting reports.
Amazon, Shopify, Walmart, eBay, Etsy, or WooCommerce sales and stock reports.
3PL, prep center, FBA, AWD, or internal warehouse quantity and movement reports.
Purchase orders, supplier invoices, freight bills, duties, and receiving records.
Balance sheet, inventory detail, COGS, bills, adjustments, and cash payments.
Inventory valuation works best when it connects to monthly bookkeeping, Amazon seller accounting, SKU profitability, fee tracking, cash flow, and tax-ready reports. These internal resources can help you build a stronger inventory accounting system.
Get help with Amazon FBA, FBM, settlement reconciliation, fees, refunds, reimbursements, inventory, COGS, and SKU profitability. View Amazon Seller Accounting.
Estimate product cost, landed cost, freight, duties, prep, storage, and other inventory costs before reordering stock. Use Inventory Cost Calculator.
Review product-level margin after revenue, COGS, Amazon fees, refunds, ads, and fulfillment costs. Use SKU Profitability Calculator.
Clean monthly books help reconcile inventory, COGS, fees, cash flow, and tax-ready reports. View Bookkeeping Services.
Seller Bookkeeping can help ecommerce sellers and Amazon sellers review inventory setup, COGS, landed costs, purchase bills, stock adjustments, SKU profitability, and monthly reconciliation so your books are cleaner and more tax-ready.
Schedule Free ConsultationInventory valuation is the process of recording inventory at cost, keeping unsold inventory as an asset, moving cost to COGS when items sell, and reconciling inventory reports to the balance sheet.
Inventory valuation affects the balance sheet, cost of goods sold, gross profit, net income, tax-ready reports, product margin, and business decisions. Wrong inventory value can make profit look too high or too low.
For many product businesses, inventory purchases should be recorded as an inventory asset first and moved to COGS when the related products are sold. Ask your CPA to confirm the right treatment for your business.
Inventory should usually be reconciled monthly for ecommerce sellers, Amazon sellers, wholesalers, and product businesses with frequent purchases and sales. At minimum, inventory should be reviewed before tax reporting.
Inventory reports should reconcile to the balance sheet inventory asset account, physical stock counts, warehouse reports, supplier bills, purchase orders, marketplace reports, and stock adjustments.
QuickBooks can support inventory tracking and inventory valuation workflows when the correct plan, settings, items, and accounts are used. More complex sellers may still need inventory apps or custom reconciliation.
Xero can support tracked inventory workflows when items, accounts, bills, invoices, and adjustments are set up correctly. Larger or more complex product businesses may need additional inventory software.
Landed costs are costs needed to bring inventory to its sale-ready location and condition. They may include freight, duties, customs, inspection, prep, packaging, labels, and other directly related costs.
Differences may come from duplicate bills, missing landed costs, incorrect item mapping, manual journal entries, unrecorded stock adjustments, returns, lost inventory, FBA delays, or timing differences between systems.
Yes. Amazon sellers often need extra review because inventory can move through suppliers, prep centers, FBA, AWD, removals, refunds, replacements, damaged inventory, reimbursements, and multiple sales channels.