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 do I set up inventory tracking in QuickBooks Online without making it overly complicated?
Enable inventory tracking in QBO settings, create inventory-type products with accurate costs and starting quantities, and only track items you actually sell. The biggest mistake is trying to track everything.
Read answerIs QuickBooks auto-categorization reliable or is it messing up my books?
It's useful as a starting point but not reliable enough to accept without review. QuickBooks frequently miscategorizes new vendors, split transactions, and transfers between accounts, which can quietly distort your financial statements.
Read answerWhat 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 answerHow do I track inventory and sales across Amazon, Shopify, and eBay in one set of books?
Use a multichannel integration tool like A2X, Bookkeep, or Klayena to summarize each platform's daily activity into QuickBooks Online journal entries. Give each channel its own income account or class so you can see profitability by platform.
Read answerHow 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 answerAt what point does it cost me more to do my own bookkeeping than to hire someone?
It usually costs more than you think already. Most business owners undercount the hours they spend and completely overlook the cost of mistakes, missed deductions, and late filings.
Read answer

