The QuickBooks Inventory Mistake That's Quietly Costing Small Wineries

May 2026 | 3 min read

… And Why It Matters More Now

Written by Jeanette Tan | Photo by Shutterstock

Costs are going up. Labor, materials, compliance, shipping — the expense side of the business keeps climbing regardless of what's happening on the revenue side.

And here's what that means in practice: every case of wine you produce needs to be accounted for correctly. Every bottle that moves — out of the tasting room, through the wine club, to a distributor — needs to land in your system the right way. Because when margins are already thin, the last thing you can afford is inventory errors quietly adding to the damage.

Which brings us to one of the most common and quietly destructive problems I see in small winery QuickBooks files: inventory errors.

The biggest myth I hear is: "QuickBooks can't really handle inventory."

It can. But if it's not set up correctly, it creates a mess that spreads far beyond inventory — into your cost of goods sold, your margins, your reports, and your ability to make decisions with any confidence.

But before we even get to setup errors — there's something more fundamental going on.

The elephant in the room is that you're probably not using the QuickBooks inventory function at all. You have spreadsheets. You have warehouse reports. You have an eCommerce program with its own inventory function. This feels normal — because it is. Almost everyone in the industry does it this way. Even your tax preparer says "just give me your inventory reports and I'll calculate your COGS for you."

But the QuickBooks inventory function isn't just for keeping a tally of your cased goods. It does something your spreadsheet can't: it calculates the cost of goods sold automatically, the moment you record a sale. Getting that number once a year, twelve months after the sale, is too late to do anything with it.

Knowing how much inventory you have on hand matters. But knowing how much money you have tied up in that inventory — and what it actually cost you when it sells — is what drives cash flow decisions and keeps the business on solid ground.

Here are the three mistakes I see most often:

1. Inconsistent sales entry. If you record wholesale and distribution sales in QuickBooks sometimes by the bottle and sometimes by the case — and record DTC sales separately in your POS or eCommerce program with its own workflow — QuickBooks can't keep up. Some owners try to solve this by running everything through their eCommerce program instead. That doesn't work either: the entries still don't match, the count starts drifting, and before long you've got a growing gap between what's in your cellar and what your system thinks is there. In a year when you need to know exactly what you have and what it's worth, that gap is a real problem.

2. Losing case goods after a bottle run. This one is sneaky. It is a longstanding tradition to give the bottling team some wine and to set aside the first-off and last-off cases. But if these cases aren't accounted for correctly after bottling, they basically disappear into a bookkeeping black hole — physically in your cellar, invisible to your accounting system. This creates phantom losses, incorrect COGS, and reports you can't rely on.

3. Not tracking samples, pours, and giveaways. Tasting room pours, distributor samples, promo bottles — all of this matters. When every case counts, untracked inventory quietly distorts your COGS and makes your reports less reliable with each passing month.

Once inventory is off, nothing downstream is right. Your cost of goods sold is off. Your margins are off. Your pricing decisions are based on numbers that don't reflect reality. And when the industry is this unforgiving, making decisions on bad data is one of the fastest ways to end up in serious trouble.

The encouraging thing: these problems are almost always traceable to a setup issue. Fix the structure, and the numbers start telling the truth again.

QuickBooks Inventory Mistakes Quietly Costing Small Wineries

What this video covers:

• Why most small wineries work around QuickBooks inventory - and why that’s costing them

• The 3 most common entry mistakes and what they do to your COGS and margins

• Why these problems almost always trace back to setup, not math

Fixing inventory is one of the first things we tackle in the Fundamental Five — because when your inventory is right, everything downstream becomes a lot more trustworthy. But first, I want to make sure your numbers are actually working for you — not just sitting in reports you open and then set aside.

That’s what I’m covering in my free webinar on May 14th: “Why Your Numbers Aren’t Helping You Make Better Decisions” — and what to do about it.

If you’re a small winery owner who looks at your financials and still isn’t sure what to do next, this is for you. We’ll talk about what your reports should actually be telling you, and why most winery financials fall short of that — not because the numbers are wrong, but because they’re not set up to answer the right questions.