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

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

How are tips handled in payroll for a Wisconsin restaurant?

Wisconsin allows a tip credit, so you can pay tipped employees a base wage of $2.33 per hour as long as tips bring them to the $7.25 minimum. All tips must be reported and taxed through payroll.

Read answer

How do landscapers track job costs in QuickBooks?

Turn on Projects in QuickBooks Online and assign every expense and labor entry to a specific job when it happens. Material receipts should be captured and coded at the time of purchase, not batched weeks later.

Read answer

How does IOLTA trust accounting work for a Wisconsin law firm?

IOLTA pools client funds that are too small or short-term to earn individual interest. The pooled interest goes to the Wisconsin Trust Account Foundation for legal aid. Firms must keep client-matter ledgers, never commingle funds, and reconcile monthly.

Read answer

Should a property management company use trust accounting software with QuickBooks?

Yes. Dedicated property management software like Buildium or AppFolio handles owner trust ledgers that QuickBooks Online wasn't built for. Monthly summaries from that system flow into QBO for your operating company financials.

Read answer

How should a restaurant handle daily sales entry in QuickBooks?

Enter one daily sales summary from your POS Z-report instead of individual transactions. Break out taxable sales, non-taxable sales, comps, sales tax collected, and payment types so everything ties to your bank deposits.

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