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 are the annual filing requirements for a Florida LLC to stay in good standing?
The main requirement is filing your Annual Report with the Florida Division of Corporations by May 1st each year. Miss the deadline and you face a $400 late fee. Miss it entirely and the state can dissolve your LLC.
Read answerWhat 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 answerWhat's the best way for a retail store to catch and track inventory shrinkage?
Regular physical inventory counts compared against your book inventory reveal shrinkage. The key is doing counts frequently enough to catch problems early and categorizing losses so you can identify patterns and root causes.
Read answerHow do I set up QuickBooks to produce the exact reports my bookkeeper or CPA needs?
The reports are already built into QuickBooks. The real work is setting up your chart of accounts, categorizing transactions consistently, and reconciling monthly so those reports actually reflect what happened in the business.
Read answerWhat are the benefits of working with a bookkeeper who understands both English and Spanish business documents?
A bilingual bookkeeper correctly interprets and categorizes documents in both languages without relying on translation tools. This improves accuracy, speeds up your monthly close, and ensures nothing gets misclassified because a document wasn't fully understood.
Read answerHow do I set up a chart of accounts in QuickBooks that actually matches my business?
Start by understanding your revenue streams, major expense categories, and what financial questions you need your books to answer. Then build the chart of accounts around that reality instead of accepting the default template QuickBooks gives you.
Read answer

