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

What bookkeeping does a trucking or logistics company need?

Trucking companies need bookkeeping that tracks fuel costs, equipment, driver pay, and per-load profitability. Standard small business bookkeeping doesn't cover IFTA reporting, cost-per-mile analysis, or the receivables delays common in freight.

Read answer

How do I handle bookkeeping for a business with both products and services?

The key is separating your revenue streams and tracking costs differently for each. Products involve inventory and cost of goods sold, while services tie costs to labor and time. Your chart of accounts and reporting need to reflect both.

Read answer

Should I let QuickBooks automatically categorize my transactions?

Use it as a starting point, not a final answer. QuickBooks auto-categorization gets things wrong often enough that blindly accepting suggestions will create messy books and potentially incorrect tax filings.

Read answer

What bookkeeping does an Amazon or Shopify seller need?

E-commerce sellers need bookkeeping that separates gross revenue from marketplace fees, tracks inventory and cost of goods sold accurately, and handles sales tax obligations across multiple states. Recording bank deposits as revenue is the most common and costly mistake.

Read answer

What is a 13-week cash flow forecast and who needs one?

A 13-week cash flow forecast is a week-by-week projection of money coming in and going out of your business over the next quarter. It's especially useful for businesses with uneven revenue, seasonal swings, or tight cash positions.

Read answer

What financial reports should I look at every month?

At minimum, review your Profit & Loss statement, Balance Sheet, and a cash flow summary every month. These three reports tell you whether you're profitable, what your financial position looks like, and whether you have enough cash to operate.

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