Bookkeeping, controller, and CFO services for small businesses in Chandler and Greater Phoenix.

Call or Text: (480) 256-9894

How do I track inventory costs in QuickBooks Online?

QuickBooks Online uses the FIFO method (First In, First Out) for inventory costing. When you sell a product, QBO assumes you’re selling the oldest units first and calculates your cost of goods sold based on what those units actually cost. You don’t get to choose LIFO or weighted average in QBO, so it’s worth understanding how FIFO affects your reported margins if your purchase prices fluctuate.

Start by enabling inventory tracking. Go to Settings, then Account and Settings, then Sales, and turn on “Track inventory quantity on hand.” Once enabled, create inventory items under Products and Services. For each item, enter the product name, the cost you pay, and the price you sell it for. QBO will create the Inventory Asset and Cost of Goods Sold accounts automatically if they don’t already exist.

When you purchase inventory, record it through a bill or expense and select the inventory item. QBO adds the quantity to your on-hand count and records the cost. When you create an invoice or sales receipt for that item, QBO reduces inventory and moves the appropriate cost from your Inventory Asset account to Cost of Goods Sold. This happens automatically as long as your items are set up correctly.

Run physical inventory counts regularly and compare them to what QBO shows on hand. Discrepancies happen from theft, damage, miscounts, or data entry errors. Use the Inventory Quantity Adjustment feature to correct the numbers when your physical count doesn’t match the system. Every adjustment hits your financials, so document the reason.

A few common mistakes to watch for. Don’t record inventory purchases as regular expenses because that skips the inventory asset entirely and makes your cost of goods sold wrong. Don’t forget to record adjustments for damaged or returned goods. And don’t let months go by without reconciling what’s on the shelf to what’s in the system.

QBO works well for businesses with straightforward inventory needs. If you buy finished goods and resell them with a manageable number of SKUs, the built-in features are probably enough. Where QBO starts to struggle is with manufacturing, assemblies, multiple warehouse locations, or businesses needing lot tracking and serial numbers. In those cases, an add-on like SOS Inventory or Katana can integrate with QBO and handle the complexity.

Working with a QuickBooks ProAdvisor in Chandler helps you get the chart of accounts and inventory items configured correctly from the start. A bad setup means your cost of goods sold, gross margins, and inventory valuations will be off on every financial statement you pull.

For businesses where inventory makes up a significant portion of your assets, accurate inventory accounting affects everything from your tax return to your purchasing decisions. If the numbers in QBO don’t match what’s actually sitting on your shelves, the reports you’re relying on are giving you bad information and you won’t know it until something goes wrong.

Bookkeeping for East Valley Small Businesses

The Next Step:
Tell Us About Your Business

Let us know where things stand with your books and what kind of help you're looking for. We'll give you an honest assessment and a clear price.

More Questions

Should I set up a line of credit as a cash flow safety net?

In most cases, yes. A business line of credit is one of the smartest safety nets you can have. The key is to apply while your business is healthy and your books are clean, not when you're already in a cash crunch.

Read answer

What is a fractional CFO and how is it different from a bookkeeper?

A bookkeeper records your financial transactions and keeps your books accurate. A fractional CFO uses that financial data to help you make strategic decisions about growth, cash flow, and profitability on a part-time basis.

Read answer

What's the difference between accounts payable and accounts receivable?

Accounts payable is money your business owes to others. Accounts receivable is money others owe to your business. Together they determine your short-term cash position and how smoothly your operations run.

Read answer

I haven't done my books in two years—where do I even start?

Start by gathering your bank and credit card statements for the full period. Those statements are the backbone of any catch-up effort. From there, work through each month chronologically to categorize transactions and reconcile accounts.

Read answer

How does a fractional CFO help with cash flow problems?

A fractional CFO builds a cash flow forecast, identifies the root cause of your cash problems, and creates a plan to fix them. You get strategic financial guidance without the cost of a full-time hire.

Read answer

How do I know if my business is actually profitable?

Profitability isn't about how much cash is in your bank account. You need accurate financial statements, especially a profit and loss report, and you need to account for owner compensation before calling any leftover money profit.

Read answer

Jackrabbit Accounting is a Chandler firm serving small businesses across the East Valley and Greater Phoenix. Led by Sean Larsen, CPA, we provide bookkeeping, controller, and fractional CFO services backed by over a decade of corporate finance and Big 4 accounting experience.

  • Intuit ProAdvisor Gold Tier badge
  • QuickBooks ProAdvisor Level 1 Certified badge
  • QuickBooks ProAdvisor Level 2 Certified badge

© 2026 Jackrabbit Accounting Services, LLC