Bookkeeping, accounting, and fractional CFO services for small businesses across Central Florida.

Call or Text: (407) 476-6348

How do I set up inventory tracking in QuickBooks Online without making it overly complicated?

The first step is turning on inventory tracking in QuickBooks Online. Go to Settings, then Account and Settings, then Sales, and enable the option to track inventory quantity on hand. This unlocks the ability to create inventory-type products that QBO will monitor as you buy and sell them. Without this turned on, you only get non-inventory and service items.

Once enabled, go to the Products and Services list and create items using the “Inventory” type. For each item, enter the name, SKU if you use one, the cost you pay, the price you sell it for, and the current quantity on hand. QBO uses the FIFO method (first in, first out) automatically, so it tracks your cost of goods sold based on the order you purchased inventory. Get your starting quantities and costs right because correcting them later creates a mess in your reports.

The biggest thing that makes inventory tracking complicated is trying to track too much. Only create inventory items for products you actually sell that have a meaningful per-unit cost. Office supplies, cleaning products, and small consumables are better tracked as regular expenses. If you sell 15 products, track those 15 products. Don’t create 200 line items for every variation and supply you keep on a shelf.

Set reorder points for items that tend to run low so QBO alerts you when stock drops below a certain level. This is a simple feature that saves you from manually checking quantities all the time. Skip it for items you restock on a fixed schedule anyway.

Categories help keep your product list organized but don’t go overboard creating subcategories within subcategories. A flat or lightly grouped structure is easier to manage. You can always add more detail later if you need it.

Do a physical inventory count at least once a month and adjust quantities in QBO to match reality. No system stays perfectly accurate without regular verification. Shrinkage, damage, and miscounts happen. The longer you go without reconciling physical counts to your system, the more your numbers drift from reality and the less useful the data becomes.

If your business has complex inventory needs like tracking raw materials that get combined into finished products, or managing inventory across multiple locations, QBO’s built-in tracking may not be enough. In those cases, you might need an add-on app or a more structured approach to inventory accounting in Orlando that goes beyond what the default settings offer.

The goal is a system you actually maintain. A complicated setup that you stop updating after two months gives you worse data than a simple one you keep current. Start with the basics and only add complexity when you have a real need for it. If you’re unsure how to structure your products or chart of accounts for inventory, QuickBooks Online setup and training can save you from building something you’ll need to tear apart and redo six months from now.

Central Florida's Trusted Bookkeeping Firm

Start Here:
A 30-Minute Consultation

Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.

More Questions

How does Florida sales tax work when my business sells both products and services?

Florida taxes tangible products but exempts most services. When you sell both, separately listing taxable and non-taxable items on your invoices determines what gets taxed.

Read answer

How do I track cost of goods sold when my supplier prices change every order?

Use a consistent inventory costing method like weighted average or FIFO. QuickBooks Online calculates FIFO automatically when inventory tracking is enabled, so your COGS stays accurate even as purchase prices shift.

Read answer

How do I record franchise territory rights as an asset and amortize them over time?

Record the initial franchise fee as an intangible asset called Franchise Rights. Then amortize it using straight-line amortization over the life of your franchise agreement, which is typically 10 to 20 years.

Read answer

How do Florida's county-level surtax rates affect what I charge and collect from customers?

Florida's 6% state sales tax is just the starting point. Most counties add a discretionary surtax of 0.5% to 1.5%, and you're required to charge the rate for the county where the product is delivered, not where your business sits.

Read answer

When does a growing business need an external controller instead of just a bookkeeper?

You need an external controller when your business has outgrown basic transaction recording and you need someone reviewing the numbers, catching errors, and giving you financial insight you can actually act on.

Read answer

How do I account for damaged, expired, or obsolete inventory in my books?

You remove the value from your books through a write-down or write-off. This means debiting an expense account and crediting your inventory asset account, with documentation to support the adjustment.

Read answer

Orlando bookkeeping firm serving small businesses across Central Florida. Full-service bookkeeping, accounting, and advisory services backed by 10+ years of accounting experience. QuickBooks ProAdvisor certified and bilingual in English and Spanish.

Service Area

Serving Orlando, Lake Nona, Avalon Park, Winter Park, Kissimmee and surrounding areas

Client Reviews

5-Star Rated Firm

Social

  • QuickBooks ProAdvisor badge
  • QuickBooks Online Certification Level 1 badge
  • QuickBooks Online Certification Level 2 badge
  • GDA Certificate badge

© 2026 Zacosta Bookkeeping Services