Best free bar inventory app for pubs

Last updated: 26 June 2026

Most pub landlords searching for a free bar inventory app have already lost money without knowing it. A 1% stock loss on wet sales quietly costs a typical pub £3,000–£5,000 a year, and spreadsheets plus guesswork won’t catch it. The hard truth is that free tools work well until they don’t — usually the moment you need to reconcile a partial keg against till data while standing in a cellar at 6 a.m.

You’re probably thinking: “Why spend money on an app when I can use a spreadsheet?” That’s fair. But most pubs that move from messy spreadsheets to a disciplined weekly count claw back 1–2 gross profit (GP) points within a couple of months. That’s not because the app is magic. It’s because a structured routine forces you to actually measure things properly instead of estimating.

This article cuts through the noise. I’ll show you what free bar inventory apps can actually do, where they fail, why most pubs outgrow them fast, and when a proper stocktake system (even a paid one) makes genuine financial sense. No sales pitch. Just operator truth.

What Free Bar Inventory Apps Can Actually Do

Free bar inventory apps are basically digital lists with a database backend. They let you log your products, create counts, store them in the cloud, and sometimes send reports. That’s genuinely useful if you’ve been scribbling on paper or hunting through 47 spreadsheet tabs.

A few free tools worth knowing about:

• Inventory tracker templates — Google Sheets templates designed for hospitality. Free. Functional for basic logging. But they live in your Google Drive, they don’t talk to your till, and you manually update everything.
• Open-source inventory systems — Some are available for hospitality. Free to use. Usually clunky. Require someone tech-comfortable to set up and maintain.
• App-based free tier tools — Certain hospitality platforms offer a free version with limited users, products, or storage. Good for trying the concept. Unusable at scale.

All of them share the same weakness: they’re data-collection boxes, not decision-making systems. They’ll tell you what you counted. They won’t tell you if that count is accurate, whether it makes financial sense, or what you should actually do about it.

Where Free Apps Fail in a Real Pub

Free apps fail the moment your stock doesn’t match your till data — which happens in every pub, every week. Here’s what that actually looks like on the ground:

No till integration

Your till says you sold 40 pints of lager. Your count says you poured from two casks and got 38 pints. Three pints are missing. Where? Is it pouring error? Spillage? Theft? A free app will log the count and the discrepancy, but it won’t automatically pull till data or flag the variance so you can investigate the same day. You’re manually comparing two separate systems and hoping you didn’t miss anything.

At my own pub, I was running stock on a tangle of spreadsheets and still losing track of partial kegs and spirit measures. I built a simple count routine around a dipstick and a set of scales, and within a fortnight the weekly variance went from guesswork to a number I could trust. But that only worked because I reconciled the count against till data the same day. A free app won’t do that for you automatically.

No temperature or line data

Draught stock loss hides in poor cellar temperature and bad line cleaning waste. A free app might let you log a cellar temperature manually, but it won’t store a history or flag when a temperature spike correlates with unusual pouring variance. You’re collecting data with no context.

No measurement tools built in

You still need a dipstick, scales, and a measuring jug. A free app doesn’t include these or teach you how to use them properly. Most pub staff have never weighed an open spirit bottle or dipped a cask correctly. An app alone won’t fix that — you need process discipline.

No GP split by line

Most free apps show total stock value or total variance. The number that actually matters is wet GP by line. Spirits hide losses in over-pouring (a free-poured 25ml is often 32–35ml). Draught hides it in cellar temperature and line waste. Soft drinks might be fine. A free app gives you a headline number. It doesn’t tell you which line is leaking profit.

Why Spreadsheets and Free Tools Lose You Money

The spreadsheet feels cheap because it is. But the hidden cost is brutal.

Spreadsheets lose money because they require perfect manual entry, perfect formula maintenance, and perfect discipline — all three of which are impossible in a busy pub. One typo, one missed line, one formula that breaks when you add a new product, and your variance is meaningless. You’re managing data debt instead of managing stock.

Time cost

A proper weekly count takes 45 minutes to an hour in a small to medium pub. Add 20 minutes of manual data entry into a spreadsheet, then 15 minutes of cross-checking and formula corrections. That’s 75–90 minutes you’re not serving, managing, or doing anything else. A staff member doing it is 90 minutes of wages. A manager doing it is 90 minutes of management time lost. Over a year, that’s 75+ hours of labour. Most pubs don’t account for that as a cost because it’s not on the payroll, it’s just “time gone.”

Measurement error

Spirits don’t get weighed properly. Casks don’t get dipped at the same angle twice. Partial kegs get estimated instead of measured. Carryover stock from the previous week gets forgotten. These measurement errors compound week on week. You think you’ve got a 2–3% variance. You actually have a 5–7% variance that’s hiding in 47 different small inaccuracies.

Missing the real story

A spreadsheet gives you a variance number. It doesn’t tell you if the variance is acceptable, where it’s coming from, or what you should change. At the end of month one, you’ve got a 2.5% loss. You note it. By month three, it’s 3.2%. You’re drifting. But you don’t know if it’s because someone’s pouring heavy, because the cellar temperature is drifting upward, because you’ve got a leaky line, or because your measurement process is getting sloppy. A free app gives you the same problem in a slightly prettier interface.

What Actually Works for Weekly Stocktake

The most effective way to run a pub stocktake is to measure everything the same way every week, reconcile it against till data the same day, and track variance by line over time. This catches measurement error, pouring error, spillage, and theft all in one routine.

Here’s what that looks like in practice:

Spirits: weigh every open bottle

An open spirit bottle is your biggest loss risk. A 25ml free-pour is often 32–35ml in reality. Use a set of scales. Weigh each open bottle the same day every week (I use Friday afternoon). Record the weight. Reconcile against till sales from the previous week. If the weight loss is 5% more than the pouring variance allows, you’ve got a problem to investigate.

Draught: dip every cask and partial keg

Use a dipstick. Mark your cellar with tape so the dip is at the same point and angle every time. Record the depth. Compare to previous week. One cask should move predictably based on till data. If a cask dropped 40 pints but till says 38, investigate. If it dropped 40 pints but till says 45, you’ve got a measurement or pouring error to find.

Soft drinks and cordials: count and weigh

Count bottles or cans. Check batch codes and rotation. Weigh carboys of cordial if you use them. These are usually lower variance, but if they’re missing, people notice.

Do it the same day every week

I do mine on a Friday afternoon, before service. Same day, same time, same person if possible. It takes 45 minutes. I reconcile against till data on the same day. By Monday morning, I know if there’s a variance and which line it’s on.

This discipline is what actually stops losses. Not the software. Not the app. The routine. A free bar inventory app can support the routine, but most don’t — they just log your data after the fact.

When a Paid App Makes Financial Sense

I’m not going to tell you that free apps are useless or that you need to spend money. I’m going to tell you the actual trade-off.

A paid stocktake system makes sense when:

• You have multiple bars or lines and need to track variance by line (not total stock).
• You need till integration so variance is flagged automatically against sales data.
• You’re losing track of partial kegs, open bottles, or carryover stock week to week.
• You want historical data so you can spot trends (a cellar temperature drift, a staff member’s pouring variance, seasonal changes).
• You need to spend 45 minutes on counting instead of 45 minutes on counting plus 30 minutes on data entry and manual reconciliation.

The StockTap pub stock app costs £97 one-off, no subscription. It’s designed specifically for pub counting — cask dips, spirit weights, till reconciliation, weekly P&L by line. Built by a working pub landlord, not a generic hospitality software company. It handles the data entry, the reconciliation, and the trend spotting automatically. You do the measuring. The app does the thinking.

Is £97 worth it? If a 1% stock loss costs you £3,000–£5,000 a year, and a proper system claws back half of that (which most pubs do within eight weeks), then yes. You’re spending £97 to protect £1,500–£2,500. That’s not an expense. That’s insurance.

The Reality Check: What You Really Need

Here’s the unvarnished truth: most free bar inventory apps fail because they treat stocktake as a data-logging exercise instead of a loss-prevention routine. You don’t have a stock problem. You have a measurement and discipline problem.

A free app will let you log counts. It won’t force you to weigh spirits, dip casks, or reconcile against till data. It won’t show you variance by line. It won’t tell you which changes actually matter. It’s a notepad with a database.

If you’re currently using nothing (just guessing) or using a chaos of spreadsheets, a free app is a step forward — it brings some structure. But you’ll outgrow it within a month or two, because the moment you try to reconcile a count against till data or spot a trend across six weeks, you’ll realize you need software that was actually built for this.

The real question isn’t “Do I need a free app?” It’s “How much is 1% of my wet sales costing me, and what am I willing to invest to stop it?” Most stock ‘theft’ is actually measurement error and forgotten wastage. Weigh open spirit bottles, dip every cask and partial keg, and reconcile against till data the same day. That’s the system. The app just makes it sustainable.

If you want to do that properly without building your own spreadsheet nightmare, SmartPubTools makes tools purpose-built for pub operators who are serious about knowing their numbers.