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

How do I categorize Amazon FBA fees, storage fees, and referral fees in my books?

Create separate expense accounts for each major fee type. Lumping them into one 'Amazon Fees' account hides where your margins are actually going and makes it impossible to control costs.

Read answer

How does sales tax nexus work for a Florida-based e-commerce seller shipping to other states?

Your Florida location creates automatic nexus in the state, but you likely owe sales tax in other states too. Since the 2018 Wayfair ruling, any state where you exceed economic nexus thresholds can require you to collect and remit sales tax.

Read answer

What financial reports should I review before making a major hiring or expansion decision?

At minimum, review your profit and loss statement, balance sheet, and a cash flow forecast. Together these tell you whether the business is profitable enough, financially stable enough, and has enough cash runway to support growth.

Read answer

How do I know if my current bookkeeper is doing a good enough job with my financials?

Look at your reports, your reconciliations, and how well your bookkeeper can explain your numbers. If any of those areas feel unclear or inconsistent, there's likely a problem worth investigating.

Read answer

Which QuickBooks Online plan does my business actually need?

Most small service businesses do well with Essentials. You need Plus if you track inventory, want project profitability reporting, or need more than three users. Simple Start only makes sense for solo operators with basic needs.

Read answer

What is the Florida commercial rent sales tax and how do I record it in my books?

Florida charges sales tax on commercial rent at 2% state plus your county's discretionary surtax. Record the tax as a separate line item from your base rent so your books stay clean and your occupancy costs are accurate.

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