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

Call or Text: (407) 476-6348

How do I set up QuickBooks Online for a business that carries inventory?

Before anything else, confirm you’re on QuickBooks Online Plus or Advanced. Simple Start and Essentials do not support inventory tracking. If you’re on one of the lower plans and try to manage inventory, you won’t even see the option. Upgrading is straightforward inside QBO, but it does change your monthly subscription cost, so factor that in.

To enable inventory tracking, go to Settings (the gear icon), then Account and Settings, then Sales. Under the Products and Services section, turn on “Track inventory quantity on hand.” This tells QBO that when you create a product, you want to monitor how much you have, what it costs, and what it’s worth. Without this toggle, QBO treats everything as a non-inventory item and won’t track quantities.

Once tracking is enabled, set up each inventory product individually. Go to Sales, then Products and Services, and create a new item. Choose “Inventory” as the type. You’ll need to fill in the item name, SKU if you use one, the sales price, the cost, and the income, expense, and asset accounts. The income account is typically a Sales or Revenue account. The expense account is usually Cost of Goods Sold. The asset account is your Inventory Asset account, which QBO creates by default. Getting these account mappings right matters because they directly affect your profit and loss and balance sheet. Wrong mapping means your financial statements won’t reflect reality.

Enter your starting quantity on hand and the “as of” date. This is your baseline. QBO adjusts quantity automatically from there as you create invoices and purchase orders. If you’re migrating from spreadsheets or another system, take a physical count before entering starting quantities so you begin with accurate numbers rather than inheriting old errors.

QBO uses the FIFO method (first in, first out) for inventory valuation. You don’t get to choose a different method. FIFO means the oldest inventory costs flow out first when you record a sale. For most small businesses this works fine and is accepted by the IRS. If your business requires weighted average or LIFO, QBO won’t accommodate that natively and you’d need a third-party integration or a different platform.

Organize your products into categories if you carry a large number of items. Categories don’t affect accounting but they make your product list manageable when you’re creating invoices or running reports. A retail shop with 200 products needs some structure or searching for items becomes a daily headache.

Physical inventory counts are non-negotiable. QBO tracks quantities based on transactions you record, but shrinkage, damage, miscounts, and receiving errors all create discrepancies over time. Run the Inventory Valuation Summary report in QBO, compare it to your physical count, and enter adjustments through the Inventory Quantity Adjustment screen. How often you count depends on your volume. Monthly is good for most businesses. Weekly makes sense for high-volume operations like restaurants or busy retail shops.

If your business deals with a high volume of products or sells across multiple channels, you may eventually outgrow QBO’s built-in inventory features. Tools like SOS Inventory, inFlow, or Cin7 integrate with QBO and handle more complex needs like lot tracking, multiple warehouses, or manufacturing assemblies. But for most small businesses in the Orlando area, QBO’s native inventory tracking covers what you need when it’s set up correctly.

The setup itself isn’t difficult, but doing it wrong creates problems that snowball. Incorrect starting balances, mismatched accounts, or skipped physical counts lead to financial statements you can’t trust. If you want it done right the first time, QuickBooks Online setup and training with someone who understands the platform saves you from chasing errors later. And if your business relies heavily on product, working with someone experienced in inventory accounting in Orlando means your books actually reflect what’s on your shelves and what it’s worth.

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 should a dropshipping business track cost of goods sold when inventory is never on hand?

Track COGS per order by recording the supplier cost plus shipping to the customer for every sale. Set up products as non-inventory items in QuickBooks Online so each transaction captures both revenue and cost automatically.

Read answer

What should I look for when hiring a bilingual bookkeeper for my business?

Look for real bookkeeping qualifications first, then evaluate their ability to explain financial concepts clearly in your preferred language. Bilingual ability should complement competence, not replace it.

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

What bookkeeping mistakes do first-time franchise owners make that cause problems later?

First-time franchise owners commonly mix personal and business finances, mishandle royalty fee tracking, skip sales tax setup, and assume the franchisor handles the accounting side. These mistakes compound quickly and create expensive problems at tax time.

Read answer

What does a fractional CFO actually do for a small business that a bookkeeper doesn't?

A bookkeeper records and organizes what already happened in your finances. A fractional CFO uses that financial data to help you plan ahead, make strategic decisions, and manage risk.

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

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