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 track food cost percentage at the end of each week using QuickBooks?
Use the formula Beginning Inventory + Purchases - Ending Inventory = COGS, then divide by food revenue. Set up QuickBooks with the right accounts and record a weekly inventory count so you can run this calculation consistently.
Read answerWhat's the best way to record monthly inventory adjustments in QuickBooks Online?
Use the Adjust Quantity feature under Products & Services in QBO. Enter your physical count, and QuickBooks calculates the variance automatically and posts it to an expense account like Inventory Shrinkage.
Read answerWhat are the most common bookkeeping mistakes restaurant owners make in their first year?
The biggest mistakes include mixing personal and business finances, not tracking food costs at the item level, falling behind on sales tax, and failing to reconcile POS reports with bank deposits. Most of these are preventable with the right systems from day one.
Read answerHow do I reconcile my POS system sales report with what actually hits my bank account?
Your POS total and bank deposit will almost never match. The difference comes from credit card processing fees, timing delays, tips held for payroll, comps and voids, and cash variances. A sales clearing account is the cleanest way to track and reconcile these gaps.
Read answerWhat's the difference between FIFO, LIFO, and weighted average for inventory valuation?
FIFO records the oldest inventory costs as cost of goods sold first, LIFO records the newest costs first, and weighted average blends all costs together. The method you pick directly affects your reported profit and tax liability.
Read answerHow do I reconcile Amazon FBA settlement reports with what shows in my bank account?
Amazon deposits a net settlement amount after deducting fees, returns, reimbursements, and reserves. You need to break that single deposit into its component parts so your books reflect actual revenue and actual expenses.
Read answer
