Last updated: 7 April 2026
Running this problem at your pub?
Here's the system I use at The Teal Farm to fix it — real-time labour %, cash position, and VAT liability in one dashboard. 30-minute setup. £97 once, no monthly fees.
Get Pub Command Centre — £97 →No monthly fees. 30-day money-back guarantee. Built by a working pub landlord.
Most UK pub landlords track daily sales in scattered notebooks, till rolls, or half-finished spreadsheets—then wonder why they can’t answer basic questions about their business by Wednesday. A daily sales record template solves this. It’s not about complexity; it’s about capturing the three numbers that actually matter: what you took, what it cost to deliver, and whether tomorrow will be better or worse than today. This article shows you exactly what to track, why it matters, and how to set up a system that takes five minutes daily instead of five hours weekly.
Key Takeaways
- Daily sales records reveal trends, margin problems, and cash flow issues before they become emergencies.
- The most effective daily pub tracking captures just four data points: takings, labour cost, key product margins, and a one-line note.
- A proper template takes five minutes to complete daily but saves 15–20 hours of monthly spreadsheet administration.
- Manual daily tracking is the foundation of any control system; without it, you’re running your pub blind.
Why Daily Sales Records Matter More Than You Think
Most pub landlords wait until the end of the month to look at their numbers. By then, the damage is done. A quiet Tuesday happened two weeks ago. A staffing cost spike was never questioned. A margin collapse on spirits went unnoticed because you were busy pulling pints.
Daily sales records are early warning systems, not just historical documents. They tell you immediately if something has shifted. You can see a pattern emerging before it becomes a crisis. At The Teal Farm, I discovered a 3% margin drop on our largest revenue category simply by reviewing daily figures. When I dug into it, our supplier had quietly raised prices. We negotiated better terms within a week. That was worth £800 monthly. A monthly review would have cost me £9,600 in lost margin before I noticed.
The most common objection I hear is: “I don’t have time to track daily.” But this misses the point. You’re already generating this data. Your till is already recording transactions. Your labour system already knows your wage bill. The question isn’t whether you have time to track daily—it’s whether you have time to not track daily and lose thousands in hidden costs.
According to Federation of Small Businesses research on small business financial management, businesses that track performance daily are 40% more likely to spot cost issues before they become serious. In hospitality, where margins are typically 20–30%, spotting a 2% margin leak early is the difference between a profitable year and a struggling one.
That’s where a daily sales record template comes in. It’s not about perfect data entry. It’s about creating a five-minute habit that gives you visibility. Real-time pub metrics matter because they let you see what’s happening as it happens, not three weeks later when the damage is already done.
What Every Daily Sales Template Must Include
I’ve built and tested dozens of pub tracking systems over 15 years. The ones that work share one thing: they’re simple enough to complete in five minutes but detailed enough to reveal problems. The ones that fail are either too complicated (nobody fills them in) or too vague (they don’t tell you anything useful).
The Core Four Data Points
Your daily sales record should capture exactly four pieces of information:
- Total Takings — the gross revenue from the till or your POS system
- Labour Cost — the total wage bill for that day (you need this to calculate labour percentage)
- One Key Margin Indicator — typically your largest revenue category (wet sales, food, or both) expressed as a percentage or absolute figure
- One-Line Note — events that affected the day (staff absence, promotion, unusual quiet period, local event)
That’s it. Four things. If you try to track 20 variables, you’ll quit by Thursday. If you track just these four, you’ll maintain the habit.
Why these four? Because they answer the three questions you should ask yourself every evening: “Did we make money today? Did we control our costs? And why was today different from yesterday?”
Optional But Valuable Additions
Once the core four become automatic, you can add:
- Customer count — if you can estimate or your POS tracks it (tells you revenue per customer)
- Food vs wet split — reveals which category is driving profit
- Waste or stock adjustments — flags unusual shrinkage
- Staff scheduled vs actual — reveals scheduling efficiency
But don’t add these until the core four are locked in as a daily habit. Too much too soon kills the system.
When setting up your pub manager reporting system, the data structure matters as much as the discipline. A template that aligns with your till system saves time and reduces errors. If your EPOS records categories, make sure your daily template reflects those same categories. Misalignment between your daily tracking and your till data creates confusion and double-work.
How to Build Your Daily Record System
The Simple Spreadsheet Approach
You don’t need software for a daily sales record template. A spreadsheet works fine if it’s set up correctly. Here’s the structure I recommend:
- Column A: Date — auto-fill with dates
- Column B: Day of Week — helps you spot patterns (Fridays vs Tuesdays)
- Column C: Total Takings — pulled from your till or entered manually
- Column D: Labour Cost — from your payroll system or timesheets
- Column E: Labour % — calculated automatically (labour cost ÷ takings)
- Column F: Key Margin % — wet sales margin, food margin, or combined
- Column G: Notes — one line only (e.g., “staff absence,” “quiz night,” “quiet due to local event”)
The formulas do the heavy lifting. Once you enter takings and labour cost, the percentages calculate automatically. This removes mental maths and error.
Crucially: set up your template on a single sheet that rolls forward month by month. Don’t create a new sheet every month. Keep 12 months of daily data visible on one view. This is how you spot seasonal patterns. Tuesday’s takings in January compared to Tuesday’s takings in March tells you if your business is growing or shrinking.
The Daily Discipline
The template only works if it’s completed daily. Here’s the system I use at The Teal Farm:
Every evening, after the till closes, I or my manager spend five minutes filling in today’s row. Takings come from the till reconciliation. Labour cost comes from our system (I’ll explain this in a moment). Margin is calculated. Notes are written. Done. The next morning, I review the previous day’s metrics over coffee—before anything else. This takes two minutes. I’m looking for one thing: is anything different from the norm? If labour percentage jumped from 27% to 31%, I need to know why. If takings were 20% below average, was there a reason? If there wasn’t a note explaining it, I ask staff.
This isn’t about blame. It’s about understanding your business. A quiet Tuesday because there was a local power cut is different from a quiet Tuesday because you ran no promotion. The first is market; the second is controllable.
Most pub owners find £1,000s in hidden savings in the first week once they start tracking daily. Why? Because visibility creates accountability. When you know you’re tracking something, you manage it differently.
Labour Cost Tracking Integration
Daily labour cost is the number most pub owners struggle with. You can’t wait for payroll at the end of the month. You need the actual cost for that specific day.
If you use a scheduling app (Deputy, When I Work, or similar), it can export daily labour hours. Multiply by your average hourly rate (including employer’s NI and pension if applicable) and you have your daily labour cost. It’s not perfect on the day (because you don’t know sick pay adjustments or overtime yet), but it’s accurate within 2–3%, which is precise enough for trend spotting.
If you don’t use scheduling software, you’re likely spending 15–20 hours monthly manually calculating labour costs. Pub labour monitoring becomes manageable only when your scheduling and payroll systems talk to each other. Even a free scheduling app cuts this time dramatically and gives you daily visibility.
At The Teal Farm, tracking staffing costs alone saved us thousands in the first month. We discovered our afternoon shift was consistently over-staffed for the trade we were doing. We adjusted scheduling without cutting anyone’s contracted hours. That single insight paid for a management system ten times over.
Real Numbers From The Teal Farm
Here’s what daily sales tracking actually revealed in my pub over three months:
Week 1: Baseline. Completed the template daily. Discovered our average weekday takings were £2,100 and labour was running 29%. Saturday was £4,200 with 31% labour (higher because we have more staff). Nothing shocking, but now I had context.
Week 3: Noticed Monday takings dropped to £1,800 (14% below average). Notes said “no reason given.” I checked with the team. Turns out a local competitor had run a heavy promotion on Sundays, drawing customers away on Mondays. Armed with this information, we ran a light offer on Monday evenings to compete. Recovered £280 per week within two weeks.
Week 5: Labour percentage spiked to 32% despite normal takings. I reviewed scheduling notes. We’d had three unplanned absences that day and paid premium rates for cover. This revealed we needed better absence management and standby staff protocols. Simple fix. Saved 1.5% labour cost monthly going forward.
Week 8: Noticed gross margin on our biggest category (spirits) had drifted from 66% to 63%. This looked like either overpouring or free drinks. Checked measures with staff and tightened free-pour protocols. Recovered 2% margin on spirits—that’s £140 monthly on average sales.
Total value from three months of disciplined daily tracking: £420–£500 monthly in recovered margin and labour efficiency. No system cost. Just five minutes daily habit and a spreadsheet.
For a pub with £3,000–£5,000 weekly takings, that’s real money. And that’s just the obvious stuff. The deeper benefit is knowing your business so well that you can make decisions instead of guessing.
Common Mistakes Pub Owners Make With Daily Tracking
Mistake 1: Tracking Too Much Data
The most common reason pub owners abandon daily tracking is they’ve built a template with 15 variables. By day three, it takes 20 minutes to complete. By day ten, they’ve stopped filling it in. Start with the core four. Expand only when that habit is locked.
Mistake 2: Not Acting on What You Learn
Data without action is just administration. The template only creates value if you review it and respond. If takings are 20% below average, you need to understand why. If labour percentage is creeping up, you need to investigate. Set a rule: every Sunday evening, review the previous week’s data and identify one thing to change or investigate.
Mistake 3: Relying on Memory for Notes
You think you’ll remember why last Tuesday was quiet. You won’t. By next Tuesday, you’ve forgotten. The one-line note isn’t optional. It’s the bridge between raw data and understanding. “Staff illness,” “promotion run,” “local event,” “unusual quiet”—one line, written immediately. It changes the entire value of the data.
Mistake 4: Using Multiple Tracking Systems
I see pub owners tracking takings in a spreadsheet, labour in a scheduling app, and margins in their till system, then wondering why they can’t see the full picture. All four data points need to flow into one place—your daily sales template. This means your till needs to talk to your template, your labour system needs to export data, and your margin calculations need to be consistent. An integrated pub system prevents this fragmentation, but even with manual entry, keep everything in one template.
Mistake 5: Not Benchmarking Against Yourself
A daily takings figure only matters in context. £2,100 on Monday is great if your average Monday is £1,800. It’s terrible if your average Monday is £2,600. Your template should include a rolling 4-week average so you can spot deviations instantly. The variance from your own norm is more useful than any industry benchmark.
Automating Your Daily Records
The Next Level: Semi-Automated Systems
If spreadsheets work but feel manual, there are options that bridge the gap between free and complex.
Many modern EPOS systems (Square, TouchBistro, Lightspeed) can export daily summaries automatically. If your EPOS can email you a daily report, you’re 70% of the way there. You enter labour cost and notes, the EPOS provides takings and category breakdown automatically. This removes data-entry error and saves time.
Some pub managers use Google Forms to create a simple daily entry form that feeds data into a spreadsheet automatically. Staff submit the form (one minute), it populates your template, and you have a permanent record. This works especially well if you have multiple sites or multiple staff members filling in data.
The key principle: automation should reduce manual data entry, not increase complexity. If a system takes longer to set up or maintain than a spreadsheet, stick with the spreadsheet.
What a Professional System Looks Like
If you’re ready to move beyond spreadsheets entirely, a proper pub management software for small pubs should handle daily sales records natively, with automatic calculation, trend analysis, and alerts. You enter the data (or it pulls automatically from your EPOS), and the system shows you immediately if something is outside your normal range. It highlights anomalies instead of making you hunt for them. This is the difference between reactive tracking and proactive management.
Pub Command Centre integrates daily sales tracking with labour, inventory, and cash flow, so you’re not jumping between systems. Everything feeds into one operational dashboard. This matters because it means your daily sales record isn’t isolated data—it connects to your real cash flow, your actual labour spend, and your inventory variance. You can see not just what happened, but why it happened and what it means for your business.
The most effective way to track daily sales in a pub is to capture the data once at source and have it flow into every system that needs it, eliminating duplicate entry and keeping your numbers consistent across sales, labour, and margins. This is how you move from tracking to actually controlling your pub.
Frequently Asked Questions
What’s the difference between a daily sales record and a till roll?
A till roll shows every transaction. A daily sales record shows totals and context. You need both—the till roll is the audit trail, the daily record is the insight tool. The daily record answers: did we make money, did we control costs, and why was today different? The till roll just proves what the total was.
How do I calculate daily labour cost if staff work flexible hours?
Use your scheduling system to export actual hours worked that day, then multiply by your standard hourly rate. If someone works a premium shift, multiply by their premium rate. This gives you a daily labour cost that’s accurate within 2–3%—close enough for trend spotting. For dead-accurate cost, you’d need to wait for payroll, but that defeats the purpose of daily tracking. Close enough, quickly, beats perfect and late.
Should I track daily sales for every product category or just totals?
Start with totals and one key margin indicator (usually wet sales or food). Once that’s automatic, add the split between wet and food if it’s meaningful for your business. Don’t add category-level tracking (beer vs spirits vs wine) until you’ve locked in the basic habit. Too much detail kills the system.
Can I use my EPOS system’s built-in reports instead of a separate template?
If your EPOS exports daily reports automatically and includes labour and margin data, yes—that can work. But most EPOS systems don’t include labour cost or contextual notes. You’d still need to add those manually. A single template that combines EPOS data with labour and notes is cleaner than three separate reports you have to cross-reference.
How far back should I keep daily sales records?
Keep at least 12 months visible at once so you can spot seasonal patterns. Beyond that, archive to a separate sheet but don’t delete. You never know when you’ll need to reference a specific date or compare year-on-year performance. Storage is cheap; losing historical context is expensive.
Managing daily sales records in a spreadsheet works—but you’re still juggling labour data, margins, and cash flow separately.
Stop managing scattered spreadsheets. One system for sales, labour, costs, cash flow, and inventory. See everything. Control everything. From one place.
For more information, visit RankFlow free trial.
For more information, visit SmartPubTools.
For more information, visit RankFlow marketing tools.