Sep 20, 2026
Last Updated: September 19, 2026
Yes, you can manage alcohol stock without paying for software using a free alcohol stock app, spreadsheets, and manual tracking. A basic approach works for a small independent bar with 30-40 different drinks, but gaps appear quickly once you scale to larger venues or multiple product lines.
Free methods work best as a starting point, they teach you what data matters before investing in paid solutions. At Swallow Drinks, we've worked with independent venues and found the difference comes down to discipline and process, not the tool itself.
This guide covers what works with free options, where they fall short, and when you need something more robust.
Free apps offer core features at no cost. Freemium tools charge for advanced functions. Paid solutions cost upfront but deliver full functionality. The real trade-offs lie beyond the headline features.
Free tools include: basic stock tracking (manual entry), simple reporting, limited user accounts, no POS integration, no cloud backup, no mobile app.
Free tools exclude: barcode scanning, automatic pour cost calculation, real-time alerts, trend reports, multi-location management, supplier integration, staff-level accountability.
Freemium tools add: cloud storage, mobile app access, limited automation, basic analytics, barcode scanning, 1-3 user accounts.
Freemium tools exclude: full POS integration, advanced waste tracking, recipe management, supplier management, unlimited users, priority support.
Paid solutions provide:
The hidden costs of 'free':
Setup takes 4-8 hours to manually enter 100+ stock keeping units (SKUs). Data migration to paid software later requires another 2-4 hours of manual work. Some free apps need a Bluetooth barcode scanner. Most critically, manual entry and reconciliation cost time: one extra hour per week can quickly add up, more than most paid solutions.
The honest breakdown:
Small independent bars (one location, 50-80 SKUs) work with free spreadsheets at 1-2 hours per week. Bars with 100+ SKUs or multiple locations benefit from freemium tools. High-volume venues can recover paid solution costs through reduced waste and faster counts. The real question: how much is your time worth, and how much are you losing to shrinkage?
Discipline beats software. Start with a physical count schedule: count stock weekly on the same day in a quiet period. Use a simple tracking sheet with columns for product name, supplier, opening stock, purchases, closing stock, cost per unit, and total value. Update it every time you receive a delivery, fifteen minutes if organised.
Track par levels: the minimum stock before reordering (e.g., six bottles for busy spirits, two for slow movers). Record every pour using a tally sheet behind the bar. This is tedious but essential, it's the only way to spot theft, over-pouring, or spillage. A bar losing one measure per shift across ten spirits loses hundreds of pounds monthly.
Pour cost is the percentage of revenue spent on drinks. A healthy pour cost is typically 20-30%; above 35% signals a problem. Formula: Cost of drinks sold ÷ Revenue from drinks = Pour cost percentage. Example: If you spent £500 on stock and had £2,000 in sales, your pour cost would be 25%. Track three weekly numbers: opening stock value, purchases, and closing stock value. Then: (Opening stock + Purchases) − Closing stock = Cost of drinks sold.
Waste tracking: record every unsold pour, breakage, and comp. If waste exceeds 5% of stock value, investigate. Common causes: over-pouring, spillage, free drinks. A bar losing £50 weekly to waste loses £2,600 annually.
A stock take template standardises your counts and reveals trends. Include: date, time, staff member, product name and brand, bottle size, quantity on hand (decimals for partials: 0.5 = half-full), unit cost, total value, and notes (damage, missing labels, age).
Print copies and keep them in a folder to create a paper trail for disputes or discrepancies.
The counting process: Count in sections over three days (spirits, wines, beers/soft drinks) to reduce fatigue errors. Use a pen. Assign one person to count, another to write, this catches mistakes and creates accountability. Count every shelf, storage area, and back-of-house location; missing even one throws off reconciliation.
The reconciliation process:
Reconciliation is where you catch shrinkage and errors. This is the step most venues skip, and it's the step that matters most.
Once you've finished counting, follow this process:
Step 1: Calculate theoretical stock: (Opening stock + Purchases) − Sales = Theoretical stock. Example: (£2,400 + £800) − £1,600 = £1,600.
View our low and non-alcoholic range →
Step 2: Calculate actual stock value from your count sheet. Example: £1,540.
Step 3: Calculate shrinkage: Theoretical − Actual = Shrinkage. Example: £1,600 − £1,540 = £60 (3.75%).
Step 4: Investigate.
If shrinkage is within a typical range, that's normal. Spillage, over-pouring, and minor mistakes happen.
If shrinkage is above a certain threshold, something's wrong. Review your notes from the count:
If the numbers still don't match, dig deeper:
Step 5: Document and adjust.
Write down the reason for any discrepancy. Examples:
If you find genuine shrinkage (theft, over-pouring, or unexplained loss), address it immediately. Talk to your team. Tighten controls. Count again next week to see if the problem persists.
Weekly reconciliation template:
Create a simple one-page sheet you fill in every week:
| Item | Amount |
|---|---|
| Opening stock value | £ |
| + Purchases this week | £ |
| − Sales this week | £ |
| = Theoretical stock | £ |
| Actual stock (from count) | £ |
| Shrinkage (difference) | £ |
| Shrinkage % | % |
| Reason for discrepancy | |
| Action taken |
Keep these sheets in a folder. After four weeks, you'll see patterns. If shrinkage is consistently high, you have a systemic problem. If it varies wildly, you have a counting or recording error.
Common reconciliation mistakes:
Why this matters:
A bar losing a certain amount each week to shrinkage is losing a significant amount each year. If you can identify and fix the cause, whether it's over-pouring, spillage, or theft, you've just found profit. That's why disciplined reconciliation is worth the time investment.
At Swallow Drinks, we work with independent venues that use this exact process. The ones that reconcile every week know their numbers, catch problems early, and stay profitable. The ones that skip reconciliation wonder where their margins went. The difference is discipline, not software.
Free systems work until they don't. Watch for these warning signs.
Your counts never match your sales records. You're losing track of what's being sold versus what's on the shelf.
A sustainable system is one you'll actually use. That means it has to fit your workflow, not fight it.
Most apps advertised as 'free' are actually freemium, offering basic features at no cost but limiting users to a small number of stock items or locations. Genuinely free options exist, primarily spreadsheet templates and simple tracking tools, but they lack real-time analytics, mobile scanning, and automated reporting. For busy bars, these free solutions often require significant manual data entry and offer no integration with POS systems, making them suitable only for very small operations or testing before investing in a paid solution.
Effective stock tracking combines regular physical counts with digital records. Conduct full stock takes weekly or fortnightly, depending on your volume. Use a consistent alcohol stock take template to record bottle counts, dates, and variances. Track pour costs by dividing total alcohol cost by ounces sold, which reveals whether shrinkage is within acceptable limits (typically 15-25% for bars). Digital tools speed this process, but even manual systems work if you're disciplined about frequency and consistency.
Pour cost measures the percentage of revenue lost to alcohol consumption. Calculate it by dividing total alcohol cost by total drink sales revenue, then multiplying by 100. For example, if you spent £500 on stock and generated £2,000 in drink sales, your pour cost is 25%. Track this monthly to spot trends. High pour costs signal over-pouring, theft, or waste. Most bars aim for 18-24% pour cost; anything above 28% warrants investigation into your bar stock management practices and supplier relationships.
Look for mobile scanning (reduces manual entry errors), real-time stock level updates, POS integration (connects sales to stock automatically), and automated shrinkage reporting. For free tools, prioritise ease of use and compatibility with your existing systems. Consider whether the app handles recipe management (useful for tracking ingredient costs in cocktails) and supplier management (tracks orders and supplier performance). If you're managing multiple locations or high volume, free tools typically fall short; a paid solution usually pays for itself through waste reduction and labour savings.
Members of:
AWRS Registration Number: XJAW00000100730
