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

What percentage of peak-season revenue should a seasonal business set aside for off-season expenses?

Most seasonal businesses target saving 25 to 40 percent of peak-season revenue. Your specific number depends on your total fixed costs and how many months your slow season lasts.

Read answer

How should a cleaning company track revenue and expenses across multiple client contracts?

Use classes or projects in your accounting software to tag every transaction to a specific contract. This lets you see revenue and expenses per client so you know which contracts are actually profitable and which ones are costing you money.

Read answer

What bookkeeping does a medical practice need that other small businesses don't?

The biggest difference is how revenue works. Medical practices don't get paid at the point of service. They bill insurance, wait for reimbursement, track contractual adjustments, and manage patient balances, all of which require specialized accounts receivable tracking that most small businesses never deal with.

Read answer

How do I track project-based revenue and expenses as a consultant or creative agency?

Set up each project as a separate tracking category in your accounting software, then assign every invoice and direct expense to the right project. Pair that with consistent time tracking and you'll know exactly which projects and clients are actually profitable.

Read answer

How do I account for tips as a liability until they're paid out to employees?

Create a Tips Payable liability account and credit it every time tips are collected. When tips are disbursed through payroll, debit Tips Payable to clear the balance. Florida allows passing credit card processing fees on tips to employees, but this requires careful tracking.

Read answer

When does a business actually need professional inventory accounting vs a spreadsheet?

A spreadsheet works fine when you carry a handful of products and restock infrequently. Once your SKU count grows, you sell across multiple channels, or your inventory value is large enough to distort your tax return if it's wrong, it's time for something more structured.

Read answer

Orlando bookkeeping firm serving small businesses across Central Florida. Full-service bookkeeping, accounting, and consultation 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