End of Day Takings Template for UK Pubs
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 pub landlords spend 45 minutes every night scribbling notes on a till receipt and hoping the numbers add up the next morning. You’re not tracking daily takings accurately—and money is walking out the door as a result. I’ve watched pub owners lose thousands because they didn’t know where their cash actually went each day, only discovering the problem months later when the bank statements didn’t match the P&L.
The good news: a proper end of day takings template solves this in under 10 minutes. It catches discrepancies on day one, not month twelve. It shows you exactly what came through the till, where it went, and whether anything’s missing. And it’s the foundation of every financially healthy pub operation.
In this article, I’ll show you exactly what a working end of day takings template looks like, why most pub owners get it wrong, and how to set one up so you never lose track of your daily revenue again.
Key Takeaways
- An end of day takings template tracks cash, card payments, voids, discounts, and tips to reconcile your till against your POS system every single day.
- Most pub owners lose £50–£200 monthly through untracked discrepancies because they don’t reconcile daily—only weekly or monthly.
- Your template must include till opening balance, all payment types, refunds, and a final variance calculation to identify problems immediately.
- Automating your takings tracking removes 90% of manual admin and catches errors before they compound into hidden profit loss.
What Is an End of Day Takings Template?
An end of day takings template is a structured record of every pound that came through your pub on a given day. It reconciles your till against your POS system, accounts for all payment methods (cash, card, contactless), tracks voids and refunds, and flags any discrepancies before they become problems.
The most effective way to manage daily pub takings is to reconcile your till against your POS system at the end of every single trading day. This is non-negotiable. Not weekly. Not monthly. Every day. Most pub owners don’t do this, which is why they discover £1,000s in unexplained variance three months in.
A proper template captures:
- Till opening balance (float from previous day)
- Total sales from POS system (food, drinks, dry goods)
- Cash received
- Card payments processed
- Voids and cancelled transactions
- Discounts given
- Tips and gratuities
- Refunds issued
- Till closing balance (actual cash in drawer)
- Variance (difference between what should be there and what is)
This isn’t complicated. It’s just discipline. And discipline is what separates pubs that know their numbers from pubs that guess their numbers.
Why Your Daily Takings Template Matters
Cash flow kills more pubs than lack of profit. You can be making money on paper and still go bust because you don’t know where your cash actually went. A daily takings template is your first line of defence against this.
At The Teal Farm, we started tracking end of day takings properly in 2022. Within the first week, we spotted a £230 discrepancy that nobody had noticed before. It was a combination of four small voids that hadn’t been logged, plus a till operator who wasn’t recording refunds. Once we had visibility through a proper template, we fixed it immediately. Over a year, that alone saved us nearly £3,000.
More importantly: a daily takings template gives you real-time visibility into your revenue and cash position. You wake up each morning knowing exactly how much money came in yesterday, where it went, and whether anything’s unexplained. You’re not surprised by bank reconciliations. You’re not guessing at your weekly cash position. You know.
This visibility does three things:
- Catches theft immediately — staff shortages, POS errors, or deliberate misappropriation show up as variance on day one, not month three
- Identifies POS issues — if your template reveals consistent variance, your till system has a problem you need to fix
- Improves cash forecasting — you know exactly what’s coming in each day, so you can plan outgoings accordingly
The template is also your evidence trail. If a transaction is disputed, if a customer claims they weren’t charged, or if you need to prove your takings to your accountant or your bank, your daily template is the documentation that backs it up.
The Problem With Manual Takings Tracking
Most pub landlords do one of two things: they don’t track daily takings at all (they reconcile weekly or monthly), or they do it manually using a spreadsheet or a handwritten ledger.
Both are disasters.
If you reconcile weekly, you’ve got seven days of variance to track down. If a till operator made an error on Tuesday, you won’t find it until Friday. By then, you’ve forgotten who was on shift, what happened that day, and where to even start looking. You’ll spend three hours chasing it and probably never find the root cause.
If you do it manually—spreadsheet or pen and paper—you’re spending 15–30 minutes every night entering data that your POS system already has. You’re transcribing numbers, which introduces human error. You’re relying on staff to remember and report voids, discounts, and refunds that weren’t logged properly. And you’re not spotting patterns, because you’re too busy just getting the data in the first place.
Manual tracking also means it never happens consistently. Some nights you do it, some nights you don’t. You tell yourself you’ll catch up on Sunday. You don’t. Three weeks go by and suddenly you’ve got ten days to reconcile and you can’t remember what happened on any of them.
The real cost of manual takings tracking isn’t just the time—it’s the money you lose because you don’t have visibility. Every day you’re not reconciling is a day a mistake, a void, or a theft could happen and you won’t know about it for days. That adds up.
When you use Pub Command Centre, the template becomes automatic. Your POS data flows straight in. You see your cash position in minutes, not hours. You spot variance immediately. You know exactly what happened that day. And you can make decisions based on facts, not guesses.
How to Build a Takings Template That Works
If you’re starting from scratch, here’s what a working end of day takings template looks like. I’m using a simple structure that works whether you’re on paper, spreadsheet, or system.
Step 1: Set Up Your Sections
Your template should have four main sections:
- Opening Position — what you started the day with
- Daily Activity — what came in and went out
- Closing Position — what you should have at the end of the day
- Actual Count & Variance — what you actually have and the difference
Step 2: Build Out the Opening Section
Record:
- Date
- Till number (if you have multiple)
- Staff member responsible
- Opening float (cash in drawer at start of day)
- Opening balance recorded on POS
Step 3: Capture All Daily Activity
Pull directly from your POS system:
- Total sales (food revenue)
- Total drinks revenue
- Total dry goods revenue (if applicable)
- Total voids (transactions cancelled or refunded)
- Total discounts given
- Cash received
- Card payments processed
- Tips/gratuities received
Don’t estimate. Pull the actual numbers from your POS end-of-day report. If your system doesn’t give you this automatically, that’s your first problem to solve—and you should fix it immediately.
Step 4: Calculate Expected Closing Balance
This is the math:
Opening Float + Cash Received – Refunds Issued + Tips = Expected Closing Cash
This is what should be in your drawer at the end of the day, before you remove any takings.
Step 5: Count the Till
Empty the drawer. Count the actual cash. Record the amount.
Step 6: Calculate Variance
Actual Cash Counted – Expected Closing Balance = Variance
A variance of £0–£2 is normal and acceptable (rounding, coins). A variance of £5+ needs investigation on the day. A pattern of £10+ variance needs immediate action.
Key Fields Every Takings Template Must Include
Here’s the complete list of fields your template needs. Don’t skip any of them—each one serves a purpose:
- Date & Trading Period — which day, which shift (lunch/dinner or day/evening)
- Operator Name — who was responsible for the till
- Opening Float Amount — cash handed to operator at start
- POS Opening Balance — what the system said before trading started
- Total Sales (broken by category) — drinks, food, other, from POS
- Total Voids — refunds, cancelled transactions
- Total Discounts — staff drinks, promotions, comps
- Cash Payments Received — notes and coins from customers
- Card Payments — total card transactions processed
- Tips Received — cash tips left by customers
- Refunds Issued — cash paid back to customers
- Expected Closing Balance (Calculated) — the number the till should match
- Actual Cash Counted — physical count after trading
- Variance — difference between expected and actual
- Variance Notes — explanation if variance exists (missing receipt, voided transaction, etc.)
- Authorization — manager signature confirming the count
If you’re using SmartPubTools, most of these fields populate automatically from your POS system. You count the cash, enter the actual amount, and the variance calculates instantly. You spend five minutes, not 30.
How to Automate Your End of Day Takings
Here’s the truth: manual templates work, but they’re fragile. They depend on staff remembering to fill them in, on you remembering to check them, and on nobody making data entry errors. After running The Teal Farm for 15 years, I can tell you: that won’t happen consistently.
Automation changes everything.
What Real Automation Looks Like
When your takings tracking is automated, here’s what happens:
- Your POS system exports a daily summary automatically at close of trading
- All sales data, voids, discounts, and refunds are captured without manual entry
- You count the cash in the drawer
- You enter one number: the actual cash count
- The system calculates variance instantly and flags any discrepancies
- You have a complete, audit-ready record that updates in real-time
This takes 5–10 minutes instead of 30. Mistakes drop by 80%. You never lose a day’s reconciliation because it’s automatic. And your daily cash position is always current.
Most pub owners find £1,000s in hidden savings in their first week when they switch to automated tracking—simply because they start seeing actual numbers instead of guesses. Labour cost visibility alone typically saves £200–£500 monthly at a medium-sized pub. Daily takings tracking catches another £50–£200 monthly through spotting discrepancies early.
The Three Automation Tiers
Tier 1: Spreadsheet Automation — Use a spreadsheet template with built-in formulas. Staff enter daily data into one row. Variance calculates automatically. Better than manual, but still requires data entry and human discipline.
Tier 2: POS Integration — Your POS system has a built-in end of day report that you review and sign off on. Most modern systems (Square, Lightspeed, Toast) offer this. Much faster, fewer errors.
Tier 3: Full System Integration — Your takings template is part of a wider financial control system that pulls data from your POS, your bank, your labour clock, and your inventory system. You see everything in one place. This is what Pub Command Centre does—one dashboard for sales, costs, cash flow, and labour. No switching between systems. No re-entering data. No guesswork.
Tier 3 costs £97 one-time and takes 30 minutes to set up. Tier 1 takes hours to build and costs you money every month in lost visibility. The math is obvious.
Integration With Your Weekly Cash Reconciliation
Your daily takings template feeds directly into your weekly bank reconciliation. If you reconcile daily, weekly reconciliation takes 15 minutes instead of three hours. You’re not chasing down mismatches because you’ve already found and explained them daily.
This also means your monthly accountancy is spot on. Your accountant isn’t asking questions. Your P&L matches your bank statements. VAT calculations are correct. You’re not surprised by anything.
Frequently Asked Questions
How often should I reconcile my till takings?
Every single day. Not weekly, not monthly—daily. At the end of each trading period, count the till against your POS numbers and record the variance. This is the only way to catch discrepancies immediately. If you wait a week, you’ll spend hours chasing down mismatches that would have taken five minutes to explain on day one.
What’s an acceptable variance on my daily takings?
Zero to two pounds is normal due to rounding and coin handling. Anything under five pounds probably isn’t worth investigating. Five to ten pounds should prompt a quick review—check for voided transactions or refunds that weren’t logged. Anything over ten pounds needs investigation the same day. Consistent variance (five to ten pounds every day) points to a POS error or staff training issue.
Can I use a spreadsheet template for my end of day takings?
Yes, a spreadsheet works if you have formulas built in and you actually use it every day. But spreadsheets require manual data entry from your POS, which introduces error. You’re also relying on staff discipline. A better approach is to pull your POS data automatically and use a system like pub management software for small pubs that integrates with your till. Same information, no manual work.
What should I do if my daily takings don’t match my POS total?
First: check for voids, refunds, and discounts that weren’t logged on the POS. Second: recount the cash (counting errors happen). Third: check if a till transaction failed to process. Fourth: review the shift with your staff. Most discrepancies are honest mistakes. Track them anyway. If the same operator has variance every shift, they need retraining or supervision. If variance is random across staff, your POS has a glitch.
How do I track tips in my end of day takings?
Separate tips from takings. Record tips received (cash, card, contactless) as a separate line item. Don’t mix tips into your takings total. Tips belong to staff, not the business. Your takings template shows business revenue only. Tips are tracked separately for staff records and wage calculations. If you use pub labour monitoring systems, tips are often integrated with payroll automatically.
Final Verdict
An end of day takings template isn’t optional. It’s the foundation of financial control in any pub. Without it, you’re flying blind. With it, you know exactly where your money is every single day.
The template itself is simple—just a structured record of opening position, activity, closing position, and variance. The discipline is harder: actually using it every day without fail.
But here’s what happens when you do: you catch discrepancies on day one instead of month three. You spot patterns that reveal problems (POS glitches, staff training issues, theft). You reconcile your bank instantly. You know your cash position. You sleep better.
At The Teal Farm, a daily takings template saved us £3,000+ in the first year alone—just from catching small discrepancies before they compounded. Combined with proper real-time pub metrics tracking, our financial visibility went from guesswork to complete control.
Start today. Get your template live. Do it every single day. You’ll find money you didn’t know you were losing.
Tracking your daily takings manually costs you time and money every single week.
Stop managing scattered spreadsheets and struggling to reconcile your till against your POS. 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.