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

How do I read a profit and loss statement?

A profit and loss statement shows whether your business made or lost money over a period of time. Read it from top to bottom, starting with revenue, subtracting costs, and ending with your net profit or loss.

Read answer

What financial records should I keep for my Arizona-based LLC?

Keep bank and credit card statements, receipts for all business expenses, tax returns, payroll records, contracts, and your LLC formation documents. Most records should be retained for at least three to seven years depending on the type.

Read answer

How do I track tips and gratuities in my books?

Tips should be tracked through a tips payable liability account, not as revenue. Credit card tips flow through your bank and get cleared when paid out, while cash tips still need to be reported and run through payroll for tax purposes.

Read answer

How should a real estate investor track rental income and expenses?

Track every dollar of income and expense by individual property using dedicated business bank accounts and accounting software configured for rental portfolios. This gives you accurate per-property profitability and makes Schedule E reporting straightforward at tax time.

Read answer

What are the annual report requirements for Arizona LLCs?

Arizona LLCs are not required to file annual reports. This is one of the advantages of operating an LLC in Arizona, though there are still other compliance obligations to stay on top of.

Read answer

What's the difference between a fractional CFO and a controller?

A controller ensures your financial data is accurate and properly reported. A fractional CFO uses that data to guide business decisions like cash flow planning, pricing, and growth strategy. Which one you need depends on where your biggest gap is.

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