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

Call or Text: (813) 857-5169

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

What causes inventory shrinkage and how does it show up in my bookkeeping?

Shrinkage happens when your physical inventory count is less than what your books say you should have. The most common causes are theft, damage, spoilage, receiving errors, and miscounts. You record the difference as an inventory adjustment that flows into cost of goods sold or a dedicated shrinkage expense account.

Read answer

How should a property management company set up bookkeeping for multiple properties?

Use QBO classes to track each property individually, keep owner funds and security deposits in separate trust accounts, and produce per-property owner statements every month. Your management fee is your revenue, not the rent you collect.

Read answer

How do I account for consignment inventory when I don't own the product I'm selling?

Consignment goods don't go on your balance sheet as inventory because you don't own them. When a consigned item sells, you only record your commission as revenue and the consignor's share as a liability until you pay them.

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

What's the difference between a bookkeeper, controller, and CFO for a small business?

A bookkeeper records and organizes your financial data. A controller oversees accuracy and produces reliable reports. A CFO uses that data to guide strategic decisions about growth, pricing, and cash management.

Read answer

How do I stop QuickBooks bank feeds from creating duplicate transactions?

Duplicates happen when you manually enter a transaction and then add the same one again from the bank feed instead of matching it. The fix is picking one workflow and sticking to it.

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