Bookkeeping and financial strategy for small businesses in Beaver Dam and throughout Wisconsin.

Call or Text: (608) 318-3094

How should a small retail shop track inventory in QuickBooks?

You need QuickBooks Online Plus or Advanced. The Simple Start and Essentials plans don’t include inventory tracking. Once you’re on Plus, you can turn on inventory tracking in settings and start creating inventory items with quantities and costs. QuickBooks uses the average cost method, meaning it calculates your cost of goods sold based on the weighted average of what you paid for each item over time. You don’t get to choose FIFO or LIFO, but average cost works fine for most small shops.

The most important decision you’ll make is how your point-of-sale system connects to QuickBooks. If you’re using Square, Shopify, or Lightspeed, there are integrations that sync sales and inventory data directly into QBO. This is worth setting up correctly from the start because the alternative is manually entering every sale and adjusting inventory by hand. That leads to errors, missed transactions, and inventory counts that don’t match reality. A good integration means that when you sell a candle at the register, QuickBooks automatically reduces your candle inventory by one and records the revenue and cost of goods sold.

Set up your items at a level of detail that’s useful without being overwhelming. A boutique with 200 SKUs can reasonably track each product. A shop with 3,000 items might need to group similar products into categories. The goal is to know what’s selling, what’s sitting, and what your actual margins look like by product or product group. Tracking every color variation of every item sounds thorough but creates a maintenance burden that most small shop owners abandon within a few months.

Run physical cycle counts at least once a month. Pick a section of your store each week or count everything monthly. Compare what you physically count to what QuickBooks says you should have. The difference is shrinkage, whether from theft, damage, miscounts at receiving, or transactions that didn’t get recorded. You can’t fix what you don’t measure, and inventory shrinkage is one of the biggest silent profit killers in retail.

When you receive new inventory, enter it into QuickBooks as soon as it arrives. Record the quantity and what you paid. This keeps your average cost accurate and your on-hand quantities current. Letting purchase orders and receiving pile up creates a backlog that makes your inventory numbers unreliable, which defeats the purpose of tracking in the first place.

Watch your inventory valuation report in QuickBooks monthly. It shows you the total value of what you’re holding. If that number keeps climbing while sales stay flat, you’re buying more than you’re selling. That’s cash sitting on shelves instead of in your bank account. Good inventory accounting gives you the data to make smarter purchasing decisions and avoid overstock situations.

If you’re just getting started with inventory tracking or your current system feels unreliable, working with Rock Steady Bookkeeping can help you get QuickBooks configured properly and connected to your POS so you’re not fighting your own numbers every month. Getting the foundation right saves hours of frustration down the road.

Wisconsin's Small Business Bookkeeper

The Next Step:
A Quick Conversation

Tell us about your business. We'll talk through what you need, answer your questions, and give you a clear quote.

More Questions

What's the best way to track client retainers for a law firm?

Client retainers go into your IOLTA trust account and are recorded as a liability until earned. Track each retainer by client, then move funds to your operating account only after you've billed against the matter and the fees are earned.

Read answer

How do I track profitability by building maintenance contract?

Set up each contract as a project or sub-customer in QuickBooks Online. Allocate direct labor and materials to the contract while keeping shared overhead at the company level. Monthly gross margin per contract tells you which deals are worth renewing.

Read answer

How do property management companies handle owner funds vs operating funds?

Owner funds must be held in a separate trust or escrow account and tracked individually by property. Operating funds like management fees and markups go to the company's own operating account. Commingling the two is illegal in most states, including Wisconsin.

Read answer

How do residential cleaners handle customer deposits?

Customer deposits are liabilities, not revenue. Record them in an unearned revenue account when you collect the money, then move the amount to revenue only after the cleaning is completed.

Read answer

Do I need to 1099 my subcontractors as a roofer?

Yes, in most cases. Any individual or single-member LLC you paid $600 or more via check or ACH during the year needs a 1099-NEC. Corporations are generally exempt.

Read answer

What's the right bookkeeping structure for a building maintenance company?

Separate revenue by contract type (monthly service, on-call, project), track direct labor and materials per contract, and make sure work orders flow into your job costing. Recurring contracts should be clearly visible as monthly recurring revenue.

Read answer

Small business bookkeeping firm based in Beaver Dam, Wisconsin. Bookkeeping, financial strategy, and fractional CFO services built around helping owners understand their numbers and plan ahead. Founded by Laura Prater, a QuickBooks Certified ProAdvisor with over a decade of accounting experience.

  • QuickBooks ProAdvisor Gold badge
  • Intuit Certified QuickBooks ProAdvisor Level 1 badge
  • Gusto Payroll Certification badge
  • Gusto People Advisory Certification badge
  • Float Certified badge
  • Highly Recommended on Alignable badge

© 2026 Rock Steady Bookkeeping LLC