Spreadsheet vs app: which inventory method actually works

Last updated: 26 June 2026

Most pubs are bleeding money into stock loss without knowing it—and the choice between a spreadsheet and an app is where that leak either gets sealed or spreads wider.

I spent seven years running my Marston’s pub on a tangle of Excel files, partial keg notes scattered across receipts, and a vague monthly reconciliation that never quite matched the till. Then I built a simple count routine with a dipstick and a set of scales. Within a fortnight, the weekly variance went from guesswork to a number I could trust. That’s when I understood: the tool is almost irrelevant. The discipline is everything.

But here’s the thing—a messy spreadsheet enforces zero discipline. And an app that doesn’t fit your cellar workflow might as well not exist. In this article, I’ll walk you through the real differences between the two, the hidden costs of each, and which one actually catches the £3,000–£5,000 a year that a typical pub loses to 1% stock variance.

This isn’t about which platform looks nicer. It’s about which one you’ll actually use every week—and whether it stops you from losing money.

Why most pubs choose the wrong method

Here’s what I see in most pubs: a licensee inherits either a spreadsheet or a piece of paper, uses it for a few weeks, then stops because something else is always more urgent. The cellar count becomes a bottleneck, or it takes too long to reconcile, or the numbers don’t make sense anyway.

The method that requires the least friction on week one almost always wins—whether it’s the right choice or not. That’s why spreadsheets win in the majority of cases. Excel is already on your computer. You already know how to use it. No subscription, no setup, no new passwords.

But friction on week one isn’t the problem. Friction on week 12 is. That’s when you stop using whatever system you chose.

Most licensees don’t actually choose between spreadsheet and app. They choose between “the thing I’m already using” and “the thing someone told me I should try.” The actual tool matters far less than your answer to this: Will I really do this every single week for six months straight?

Spreadsheets: the false economy

Let me be blunt about spreadsheets: they work brilliantly in theory and fail silently in practice.

A spreadsheet costs nothing to set up. There’s no subscription, no learning curve, no dependency on Wi-Fi or app updates. You can customise it exactly how you want. Most importantly, spreadsheets don’t require anyone else’s help—you own the data completely.

In my first pub, that felt like a massive advantage. I thought I’d built a perfect system: columns for opening stock, purchases, sales (pulled from the till), closing stock, and a variance column that would flag anything above 2%. It looked professional. It was comprehensive. It was a graveyard.

Within four weeks, I stopped updating it. Then eight weeks. By month three, I had three months of stale data that told me absolutely nothing about my current stock position. I’d pick it up again when something felt wrong—a keg seemed empty too quickly, or till numbers didn’t make sense—but by then the damage was already done.

The spreadsheet problem isn’t the tool itself. It’s that spreadsheets reward you for not using them. If you don’t update it, nothing breaks. No notification, no alarm, no system nagging you. The spreadsheet just sits there, silently out of date. Meanwhile, your actual stock is drifting, waste is accumulating, and you’re losing money you don’t know about.

Spreadsheets also hide measurement errors beautifully. A partial keg that wasn’t dipped properly, a spirit bottle that should have been weighed but wasn’t, a till reading that includes a discount you forgot to log—these all become “variance” that you blame on waste or shrinkage. But they’re often just bad data going in.

There’s also the cellar workflow problem. A spreadsheet lives on your office computer. Your stock lives in the cellar. You either print out a list (and manually transcribe the numbers back into the spreadsheet), or you take photos, or you try to update it on your phone (which is painful), or you do the count in the cellar and then spend an hour reconciling it all against till data and purchases. Most pubs choose option four, which is why the count happens once a month instead of every week.

When a spreadsheet actually works

That said, spreadsheets work in one very specific scenario: when you’re disciplined enough to treat it like a ritual, not a task. Every single Thursday at 9am, you’re in the cellar with a notepad and a pen, taking physical measurements (dipping casks, weighing open bottles, checking keg codes). You’re in your office by 10am entering those numbers into the spreadsheet. You’re running the reconciliation by lunchtime. You’re reviewing the numbers same-day against till data.

If you actually do this, a spreadsheet catches stock issues within a week. Most pubs don’t. Most pubs do it when they remember, or when the month is coming to an end, or when stock numbers feel off.

Apps: promise vs reality

An app sounds like the answer. Notifications remind you to count. Data syncs instantly. No manual entry. You can check your position from anywhere. For a lot of modern businesses, apps are genuinely better than spreadsheets.

But pub inventory apps aren’t the same as, say, a project management app. They’re not solving an office workflow problem. They’re trying to replace a physical, hands-on cellar routine with a digital interface. That’s harder than it sounds.

The most effective bar inventory system combines real measurement (dipstick, scales, till reconciliation) with a digital record that you trust—whether that record lives in a spreadsheet or an app. The app doesn’t do the measuring for you. It just records what you measure.

A good app makes that recording frictionless. A bad app adds another layer of work. I’ve seen pub apps that require you to select each product from a dropdown menu, enter multiple fields of data per item, and then sync to the cloud. If you’re counting 80 different stock lines, that’s not faster than a spreadsheet. It’s slower.

Where apps genuinely win is in accountability and routine enforcement. A good app sends you a notification on Wednesday saying “Your weekly count is due.” It won’t let you skip it without logging why. It stores all your historical data in one place and spots trends instantly. It can pull till data automatically and highlight the lines where your physical count doesn’t match what sold.

The StockTap pub stock app from SmartPubTools is built specifically for this: a quick cellar count on your phone, synced straight to a weekly report that compares physical stock against till data and purchases. No complex data entry, no guessing about partial kegs. Just: dip the cask, measure the spirit, record it, move on.

But here’s the caveat: an app is only useful if it fits the way you actually work. If your cellar is in a dead zone without Wi-Fi, or if you’re counting at 6am before the system is fully up, or if your app crashes during the count, you’re back to paper notes anyway.

The real cost of spreadsheets vs apps

Let’s be clear about money, because this is where the conversation gets real.

A spreadsheet costs nothing upfront and nothing ongoing. But it costs you time. If you’re doing a proper weekly count, you’re spending 45 minutes to an hour on measurements, then another 45 minutes entering data and reconciling it. That’s roughly 100 hours a year. At typical pub manager rates (£12–£16/hour), that’s £1,200–£1,600 a year in labour cost, just to maintain the spreadsheet.

Most pubs don’t account for this cost, which is why they think the spreadsheet is free. It’s not. You’re just not writing it on an invoice.

A paid app costs money. Most subscription-based systems are £30–£100 per month. That’s £360–£1,200 per year, plus setup time, plus learning time. But if the app actually saves you 20 minutes per week (because the data entry is faster and the reconciliation is automatic), you’re saving 17 hours a year. At £14/hour (middle rate), that’s £238 of labour. The math starts to get closer.

More importantly, a good app should catch an extra 0.5–1% of stock loss that your old system was missing. For a pub with £100,000 annual wet sales, that’s £500–£1,000 per year of money you’re reclaiming. Suddenly the app isn’t a cost—it’s an investment with a payback period of months, not years.

I moved from my spreadsheet to a real count routine with a dipstick and a set of scales (the physical measurement is crucial—nothing digital about it), but I documented the process in a simple app rather than Excel. My weekly variance went from ±4% (useless data) to ±0.8% (actionable). That told me my stock loss was actually 1.2%, not the 3–4% I’d assumed. Clawing back 2 GP points on a £100k wet turnover is worth £2,000 a year.

What actually works: the weekly routine

This is where both spreadsheet and app users fail. They confuse the tool with the routine.

The spreadsheet doesn’t make you count weekly. The app doesn’t make you count weekly. You have to decide that weekly is non-negotiable.

Here’s the routine that actually works, whether you record in Excel or an app:

• Pick a fixed day. Wednesday mornings, every single week. Not “whenever I get round to it.” Same day, same time. This alone changes everything because it becomes a habit, not a task.
• Physical measurement first. Dip every cask (depth in inches × cask size = litres remaining). Weigh every open spirit bottle. Check partial kegs against delivery notes. Count stub bottles. Record it all on paper or phone—whatever is fastest in your cellar.
• Same-day reconciliation. Pull till sales data (what the system says you sold) and compare against what your physical count says should be gone. Do this the same day, not three days later, because memory matters.
• Identify the line. If a cask is 2 litres short of where it should be based on till data, that’s your variance for that line. Is it waste (bad line, overpour, spill)? Is it theft? Is it a till error? Write it down.
• Weekly review, not monthly panic. Spend 15 minutes reviewing the numbers. Is there a pattern (spirits creeping high, draught lines consistently short)? Is this week in line with last week? Do you need to clean the lines, tighten the taps, or retrain bar staff on measures?

This routine works on a spreadsheet. It also works on an app. The tool is secondary. The discipline is everything.

Where an app genuinely helps is in maintaining that discipline. It sends you a reminder Wednesday morning at 8am. It stores six months of historical data so you can spot trends. It flags when a line’s variance goes above your tolerance. You can’t ignore it as easily as you can ignore a spreadsheet.

Which method should you choose

Here’s my honest answer: it depends on one question.

Will you actually do a disciplined weekly count, or will you rely on the tool to force you to?

If you’re naturally disciplined, a spreadsheet is fine. It costs nothing. You own the data. You can customise it exactly how you want. But you have to be honest with yourself: are you actually going to do this every single week, without fail, for six months? Most people say yes. Most people don’t.

If you know you need external accountability—a system that nags you, that won’t let you skip a week without logging why, that automatically flags problems—then an app is worth the money. Not because the app is magic, but because it removes the friction of deciding whether to do the count this week or next week.

The worst choice is a spreadsheet with the expectation that it will enforce discipline. It won’t. Spreadsheets are passive. They wait. Apps are active. They push.

If you’re serious about catching that 1–2% of stock loss that’s disappearing every year, and you’re serious about turning it into profit margin, you need a system that forces a weekly routine. Most spreadsheets fail that test because they don’t create consequences for skipping a week. An app, by design, does.

There’s also a middle ground: use a spreadsheet for your detailed measurement notes (dip readings, weights, till data), but sync that into an app that handles the reconciliation and trend analysis. Some pubs do this. It takes the best of both worlds—spreadsheet flexibility plus app accountability.

What you absolutely cannot do is set up a system and then forget about it for three weeks. That’s worse than having no system at all, because the data becomes misleading. You’ll trust numbers that are months out of date, make decisions based on that bad data, and never actually know if you’re losing money or not.