Inventory Accounting in QuickBooks Online: Costing Methods, Tracking, and Adjustments

Managing Inventory in QuickBooks Online

Inventory accounting concepts like FIFO and weighted average are important—but what matters most is how you apply them inside QuickBooks Online. Here’s a step-by-step tutorial to help beginners connect the theory with day-to-day bookkeeping:

1. Turn On Inventory Tracking

  1. Click the Gear Icon in QuickBooks Online.
  2. Go to Account and Settings → Sales.
  3. Enable Track quantity and price/rate and Track inventory quantity on hand.
  4. Save your changes.

2. Add Inventory Items

  1. Go to Sales → Products and Services.
  2. Select New → Inventory.
  3. Enter product name, SKU, and category.
  4. Set the Initial Quantity on Hand, As of Date, and Cost.
  5. QuickBooks automatically calculates the asset value and posts it to the Inventory Asset account.

3. Record Inventory Purchases

When you buy stock to resell:

  • Create a Bill or Expense and select the inventory item.
  • QuickBooks increases the quantity on hand and updates your Inventory Asset account.

4. Track Sales and COGS

When you sell inventory:

  • Create an Invoice or Sales Receipt with the inventory item.
  • QuickBooks automatically reduces inventory, records revenue, and posts the cost to COGS using your chosen costing method.

5. Adjust Inventory for Accuracy

To fix shrinkage, damage, or errors:

  1. Go to + New → Inventory Qty Adjustment.
  2. Select the product, enter the new quantity, and choose the Inventory Shrinkage account.
  3. QuickBooks records the adjustment, updating both your balance sheet and income statement.

6. Run Inventory Reports

For analysis and reconciliation:

  • Inventory Valuation Summary: Shows total value of stock on hand.
  • Inventory Valuation Detail: Tracks item-level purchases, sales, and adjustments.
  • Sales by Product/Service: Helps spot bestsellers and slow-moving items.
 

For detailed tutorials, visit our QuickBooks Online guides at excelinaccounting.com/category/quickbooks-tutorial.

 

Inventory Accounting for Beginners: Costing Methods and Adjustments

Inventory is often one of the largest assets on a small business balance sheet. Whether you run a retail store, wholesale distribution, or manufacturing operation, tracking inventory correctly ensures accurate profit measurement and compliance. This guide introduces inventory accounting fundamentals, explains costing methods like FIFO, LIFO, and weighted average, and shows how to handle adjustments for accuracy.

What Is Inventory Accounting?

Inventory accounting is the process of valuing and recording goods held for sale. It affects both the Balance Sheet (as an asset) and the Income Statement (through Cost of Goods Sold, or COGS). Proper inventory accounting ensures that revenue is matched with the costs of producing or purchasing goods, leading to accurate profit reporting.

Why Inventory Accounting Matters

  • Profit measurement: Incorrect inventory values distort gross margin.
  • Tax compliance: Many tax authorities require approved costing methods.
  • Cash flow management: Excess inventory ties up funds that could be used elsewhere.
  • Decision-making: Managers rely on accurate data to reorder, price, and forecast demand.

Key Inventory Terms

  • Beginning Inventory: Value of stock on hand at the start of a period.
  • Purchases: Goods bought during the period.
  • Ending Inventory: Value of unsold stock at the end of a period.
  • Cost of Goods Sold (COGS): Beginning Inventory + Purchases – Ending Inventory.

Inventory Costing Methods

1) FIFO (First In, First Out)

Assumes the oldest inventory is sold first. Ending inventory reflects the most recent purchases.

Impact: In times of rising prices, COGS is lower, profit is higher, and ending inventory is valued closer to market prices.

2) LIFO (Last In, First Out)

Assumes the newest inventory is sold first. Ending inventory reflects older costs.

Impact: In rising prices, COGS is higher, profit is lower, and taxes may be reduced. Note: not permitted under IFRS, but accepted under U.S. GAAP.

3) Weighted Average

Calculates an average cost per unit: Total Cost of Goods Available ÷ Units Available. Each sale reduces inventory using this average cost.

Impact: Smooths out price fluctuations, producing moderate COGS and inventory values.

Perpetual vs. Periodic Inventory Systems

Perpetual System

Updates inventory records continuously as purchases and sales occur. Provides real-time data but requires reliable software or systems.

Periodic System

Updates inventory at the end of an accounting period. Simpler but less accurate for decision-making during the month.

Recording Inventory Transactions

Purchasing Inventory

Debit Inventory (asset); Credit Accounts Payable or Cash.

Recording Sales

Two entries: (1) Debit Accounts Receivable or Cash; Credit Sales Revenue. (2) Debit COGS; Credit Inventory.

Adjustments

Record adjustments for shrinkage, obsolescence, or damaged goods: Debit COGS; Credit Inventory.

Inventory Adjustments Explained

Adjustments align book records with physical counts. Common reasons include:

  • Shrinkage: Loss from theft or errors.
  • Obsolescence: Outdated or unsellable goods.
  • Damage: Unsellable goods due to handling or storage issues.

Accurate adjustments prevent overstated assets and understated expenses.

Example Inventory Calculation

Beginning Inventory: $20,000; Purchases: $50,000; Ending Inventory: $15,000.

COGS = $20,000 + $50,000 – $15,000 = $55,000.

Inventory Ratios for Analysis

  • Inventory Turnover: COGS ÷ Average Inventory. Higher turnover indicates faster movement.
  • Days Sales of Inventory (DSI): 365 ÷ Inventory Turnover. Shows how long stock is held before sale.
  • Gross Margin: (Revenue – COGS) ÷ Revenue. Measures profitability after direct costs.

Best Practices for Small Businesses

  • Conduct physical counts at least annually, preferably quarterly.
  • Standardize costing method and apply consistently.
  • Use software to track real-time balances if inventory volume is high.
  • Regularly review for obsolete or slow-moving items.

Frequently Asked Questions

Can I switch inventory methods? Yes, but it may require approval from tax authorities and consistent future application.

Which method is best? FIFO is common for most businesses; weighted average works well for large volumes of similar items; LIFO is rare outside the U.S.

How does inventory affect cash flow? Buying inventory uses cash immediately, while revenue is recognized only when sold.

Putting It All Together

Inventory accounting ensures that financial statements reflect the true cost of goods and assets held for sale. By choosing the right costing method, recording adjustments, and reconciling regularly, you create accurate reports and better business decisions. Inventory is not just a number—it’s working capital tied to your business health.