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

Do restaurants need accrual accounting or is cash okay?

Cash basis is legal for most restaurants, but accrual accounting gives you a much clearer picture of monthly profitability. Many well-run restaurants use accrual internally for decision-making even when they file taxes on a cash basis.

Read answer

Are cleaning services subject to Wisconsin sales tax?

Most cleaning services in Wisconsin are taxable. This includes commercial janitorial work, residential house cleaning, carpet cleaning, window washing, and pressure washing. You need a seller's permit and must collect and remit sales tax.

Read answer

How should a pressure washing business handle equipment financing?

Financed equipment goes on your balance sheet as a fixed asset with a matching loan liability. Each monthly payment gets split between interest expense and principal paydown, and depreciation is recorded separately.

Read answer

How do I form an LLC in Wisconsin?

File Articles of Organization with the Wisconsin Department of Financial Institutions (DFI) online for $130. Your LLC name must be unique and include 'LLC' or a variation. Online filings are typically processed within 1-2 business days.

Read answer

How do agencies account for media pass-through spend (ads)?

Book ad spend at full value, either as a reimbursable expense billed at cost or as revenue with matching COGS if you mark it up. Never book the net amount only. Gross reporting matters for revenue recognition and financial accuracy.

Read answer

How should a marketing agency handle retainer vs project revenue?

Retainer payments are deferred revenue until you deliver the work each month. Project revenue is recognized as deliverables are completed. Use separate income accounts for each so you can see your real revenue mix.

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