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 their takings the same way they did 10 years ago: a notebook, a till roll, maybe a spreadsheet created by someone who left five years ago. The result? You know what you made yesterday, but you have no idea if next week will be better or worse. That’s not business management—that’s hoping things work out. A proper pub weekly takings tracker changes everything. Not because it’s complicated, but because it forces you to see patterns you’ve been missing—slow days you can fix, peak days you can protect, and cash flow problems before they become disasters.
In this guide, I’ll show you exactly how to set up a tracking system that works in the real world, what data actually matters, and how to use your weekly numbers to make decisions that improve profit. You’ll also discover why most pub owners find thousands of pounds in hidden improvements once they start tracking properly.
Key Takeaways
- Weekly takings tracking reveals cash flow patterns and profit trends you cannot see any other way, helping you forecast revenue accurately and spot problems early.
- The most effective pub weekly takings tracker records daily sales by category (wet sales, food, other), day-on-day comparisons, and cash-on-hand reconciliation in one place.
- Manual spreadsheets typically consume 15-20 hours of administrative work monthly; a structured tracking system cuts this by two-thirds and eliminates transcription errors.
- Most pub owners discover £1,000s in hidden improvements within the first week of proper tracking, from understaffed shifts to underpriced categories.
Why Weekly Takings Tracking Matters More Than You Think
Cash flow kills more pubs than lack of profit. You can be profitable on paper and still run out of money Tuesday morning because you don’t know when your revenue actually lands in the bank. That’s where weekly tracking becomes essential.
The most important reason to track weekly takings is that weekly data reveals patterns daily totals hide and monthly summaries obscure. You need to see which days perform, which days struggle, when seasonal trends start, and whether your revenue is drifting up or down. Without this visibility, you’re making staffing decisions, promotions, and pricing changes blind.
At The Teal Farm, tracking labor costs alone has saved thousands annually—but that’s only possible because we see our takings in context. If you know you did £2,400 on Friday but £1,100 on Tuesday, you can ask: why? Was it weather? Did we undersell? Were we understaffed? Did customers leave because the place felt empty? You cannot answer any of these questions with monthly totals.
Weekly tracking also prevents VAT surprises. Your pub financial benchmarks should include VAT forecasting, and you cannot forecast if you don’t track weekly. Most landlords get caught out in quarter-end because they have no idea what their actual sales were week-to-week.
What to Track: The Essential Metrics Every Pub Needs
The fatal mistake most pub landlords make is tracking everything. You end up with a spreadsheet so complicated that filling it in takes an hour, and nobody uses it. Instead, track only what drives profit and cash flow.
Daily Sales by Category
Break your takings into three core categories:
- Wet sales (beer, wine, spirits, soft drinks) – your highest-margin category and typically 60-70% of revenue
- Food sales – if you serve it, separate it out because food has a different margin profile
- Other sales (gaming, pool, slots, machines) – often 5-15% of revenue and easy to overlook
Why split them? Because margins differ dramatically. Your spirit margin tracking needs different visibility than your food costs. If your food sales collapse but wet sales stay strong, you’re still OK—but you won’t see that pattern if you lump everything together.
Day-on-Day Comparison
The second essential metric is comparing this week to last week at the same day. Monday to Monday. Friday to Friday. This shows whether your revenue is trending up or down and whether promotional activity actually worked.
Most pubs run a promotion and hope it worked. With day-on-day tracking, you know it worked. Last week’s Tuesday was £1,200. This week’s Tuesday was £1,450. That’s a 21% increase. You just found a repeatable tactic.
Cash Reconciliation
This sounds boring, but it catches everything from till errors to shrinkage to theft. Record the till reading at close, the cash you counted, and the difference. Most pubs discover 1-2% shrinkage this way—on a £3,000 weekly takings, that’s £30-60 per week you’re losing to something preventable.
Staff Count and Labor Hours
Not to track in detail, but note how many staff were on shift and total hours. This lets you calculate whether 30 percent labour cost is too high in context. A £2,000 takings day with 5 staff is different from a £1,200 day with 3 staff.
How to Build Your Weekly Takings Tracker: The Practical System
You have two real options: spreadsheet or software. Both work, but they require different approaches.
Spreadsheet Approach (Simple, But Risky)
If you’re starting with a spreadsheet:
- Create columns for: Date, Day of Week, Wet Sales, Food Sales, Other Sales, Total, Cash Count, Difference, Staff Count, Notes
- Add a row for each day
- Add a “Weekly Total” row at the bottom of each week
- Create a second sheet with comparison data: This Week vs Last Week, This Week vs Same Week Last Year
- Use conditional formatting to highlight anomalies (days more than 20% above or below the average)
This works, but here’s the problem: manual spreadsheets typically consume 15-20 hours of administrative work monthly, including data entry, formula checking, and correction of transcription errors. You’re spending 3-4 hours per week just entering numbers.
More importantly, a spreadsheet on your laptop or a shared drive can be updated by anyone. Someone fills in the wrong till balance, a formula breaks, and now your entire forecast is wrong. And you have zero visibility until you sit down and open the file.
The Smarter Approach: Integrated Tracking Systems
An integrated pub system collects your takings data automatically or with minimal input, then does the analysis for you. Data flows in from your EPOS till, cash is logged once, and you see your weekly takings and comparisons in real-time.
At The Teal Farm, we moved away from spreadsheets three years ago. Not because we liked the idea of software, but because the time and accuracy gap became impossible to ignore. Now I can see my weekly takings the morning after close, and I can see trends within minutes instead of hours.
With proper pub manager reporting systems, your weekly tracker becomes automatic. Your EPOS feeds data directly in, cash reconciliation happens at the till, labor is logged as staff clock in and out, and you get a complete weekly summary without manual entry.
The setup takes 30 minutes. No formulas. No technical knowledge required. And the cost is typically £97 one-time with no monthly fees—lower than the admin hours you’d spend chasing spreadsheet data.
What to Record Daily (Non-Negotiable)
- Till balance at open and close
- Cash counted and banked
- Sales total by category (if your EPOS doesn’t break this down, ask why—any modern till should)
- Any unusual events (broken equipment, staff absence, special event, power cut)
That’s it. Five data points per day, takes 90 seconds to record, and unlocks everything.
Using Your Weekly Data to Drive Real Changes
Tracking without action is just record-keeping. Real value comes from using your data to answer questions and make decisions.
Spot Revenue Trends
Once you have four weeks of data, patterns emerge. You’ll see that Thursday is consistently 15% below average. Friday is consistently 35% above. Summer Mondays collapse. November is always stronger than September. These aren’t surprises—they’re information you can act on.
The question shifts from “I hope next week is good” to “Thursday is weak—what can we do about it?” Maybe you need a Thursday promotion. Maybe you need to adjust staffing. Maybe Thursday just isn’t a pub night in your area and that’s fine—you staff it lighter and accept the lower revenue.
Validate Your Marketing and Promotions
Day-on-day comparison is the only way to know if a promotion actually worked. You run a “£2 pints Friday” special. Did Friday revenue increase? Compare this Friday to last Friday. If it was £1,800 last week and £2,100 this week, the promotion drove an extra £300. Was that worth the margin discount? Only you can answer, but now you have data.
Most promotions fail silently because pub owners never measure them. With weekly tracking, nothing fails silently anymore.
Forecast Cash Flow
If you know your average weekly takings and can see the trend, you can forecast. “My average is £7,500 per week, trending up 2% monthly, so I expect £7,650 next week and £7,800 the week after.” That’s not a guess—it’s a forecast based on actual data. Multiply by 4-5 weeks and you know whether you can afford a staff hire, a stock purchase, or that till upgrade.
Without this, you’re always surprised by timing. Money arrives when you don’t need it and disappears when you do.
Control Labor Spend
Once you’re tracking takings weekly, add labor hours to the same dashboard. Your revenue was £6,800 this week and your labor was £1,900. That’s 27.9% labor-to-sales. Last week it was 31%. Why? Fewer staff? Shorter shifts? Did takings increase or did you just cut hours? With both metrics visible together, you can answer these questions and adjust your pub labor monitoring accordingly.
Identify Stock and Cash Discrepancies
If your till should have £450 and you count £420, you have a £30 problem. Find it now, not in six months. Weekly reconciliation catches these immediately, while the memory of what happened is fresh.
Common Mistakes in Weekly Takings Tracking (And How to Avoid Them)
Mistake 1: Tracking Too Many Metrics
Pub owners often try to track 20+ metrics in their spreadsheet: separate categories for different beer brands, different pour sizes, customer count, average spend per head, margin percentage, food waste, staff by name, etc. The result is a spreadsheet so complicated that half the columns are never filled in and nobody uses it.
Track the three things that drive profit: revenue total, revenue by category, and labor cost. Everything else is detail that can wait.
Mistake 2: Relying on Till Data Alone
Your EPOS till says you took £2,300. But did you? Did someone do a cash out? Did a staff member not ring something? Did a transaction void? A weekly takings tracker must include physical cash count to verify till data. The difference (shortage or overage) is its own data point that tells you something.
Mistake 3: Not Tracking When You’re Busy
When the pub is heaving, nobody wants to sit down and update the tracker. So it doesn’t get filled in until Thursday, by which time the data is stale and people’s memories are fuzzy. The best tracking system requires minimal time at point of entry. Ideally, your EPOS feeds data automatically, and you only manually enter cash count—one number, 30 seconds.
Mistake 4: Comparing Across Different Staffing Levels
Week 1 you had a chef and three bar staff. Week 2 your chef was sick and you had four bar staff instead. Comparing takings week-on-week without noting staffing changes will mislead you about performance. Always log staff count and unusual events in your notes field.
Mistake 5: Not Acting on the Data
You’ve been tracking for eight weeks. You know Thursday is consistently weak, Friday is strong, and summer Mondays are terrible. Now what? If you’re not using this to change staffing, pricing, promotions, or product mix, you’re just keeping records. Tracking is only useful if it informs decisions.
Frequently Asked Questions
How often should I update my weekly takings tracker?
Daily, ideally within an hour of close. Record till balance, cash counted, and any notes while details are fresh. If you wait until Friday to fill in Monday-Thursday data, accuracy suffers and you lose the ability to spot same-day problems. Modern systems automate this—your EPOS logs data continuously and you verify once daily.
What’s the difference between till reading and actual takings?
Till reading is what your EPOS machine says you took. Actual takings is the physical cash you count plus card payments recorded by your payment processor. The difference reveals till errors, voids, refunds, and staff mistakes. Always reconcile both. If till says £2,400 but you count £2,340, you have an £60 discrepancy that needs investigation.
Should I split takings into different categories, or just record a total?
Split into at least three: wet sales (drinks), food sales, and other (gaming/machines). This reveals which categories are performing and where margins are strongest. If total takings are down 10% but wet sales are up 5%, you know the problem is food sales declining. That tells you whether to review your menu, pricing, or marketing—information you cannot get from a single total.
What should I do if I spot a cash shortage in my takings tracker?
Record it immediately. Investigate while the day is fresh. Was there an error in cash entry? Did someone forget to ring a transaction? Is there breakage or theft? Most shortages under 1% are data entry errors or voids. Over 1% consistently, you have a problem. Document everything and review procedures with staff. Weekly tracking catches this quickly instead of discovering missing thousands in a quarterly stock take.
Can I use my EPOS system’s built-in reporting instead of a separate tracker?
Yes, if your EPOS gives you day-on-day comparison, category breakdown, and weekly forecasting. Most systems show you what you sold but don’t compare to last week or forecast next week. A proper tracker adds that analysis layer. SmartPubTools integrates with most EPOS systems and pulls data automatically, so you’re not duplicating entry. Your EPOS is the data source; the tracker is the analysis layer.
Once you start tracking weekly takings properly, the changes are noticeable within days. You’ll spot slow days, understand your peak times, and start making decisions based on data instead of hope. The time investment drops from hours per week to minutes. And the financial clarity you gain is worth thousands annually.
Start today with whatever system you have—spreadsheet or software. Even a simple weekly total, categorized and compared to last week, will show you more than you know now. Build from there.
Tracking takings manually in scattered spreadsheets costs you hours every week and hides the patterns that would improve your profit.
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 RankFlow marketing tools.