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

What is prime cost in a restaurant and why is it the most important number to track?

Prime cost is your total cost of goods sold (food and beverage) plus your total labor costs (wages, benefits, and payroll taxes). It should fall between 55% and 65% of total revenue, and it matters more than any other number because it covers the two largest controllable expenses in your restaurant.

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

How do I set up a chart of accounts in QuickBooks that makes sense for a restaurant?

The default QuickBooks chart of accounts doesn't work for restaurants. You need separate accounts for food costs, beverage costs, labor by role, and restaurant-specific operating expenses so your reports actually show where the money is going.

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 track job costs for an HVAC or plumbing business in QuickBooks?

Use QBO Projects to tag every expense to a specific job, including materials, labor, subcontractor costs, and permits. Compare total job costs against the invoice amount to see per-job profitability and review unbilled costs regularly.

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

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