Cash Reconciliation Template for UK Pub Owners

Last updated: 9 April 2026

Most pub owners discover cash discrepancies weeks after they happen — by which point the money is long gone and the guilty staff member has a convenient memory loss. I’ve watched thousands of pounds walk out the door at The Teal Farm because I didn’t have a simple system in place to reconcile cash daily.

The thing is, you already know this is a problem. Your till never balances perfectly. You’re missing £30 one night, £15 the next. Over a month that’s a car payment. Over a year it’s a holiday you didn’t take.

The solution isn’t hiring a security guard or installing CCTV in the till — it’s a dead simple cash reconciliation template that takes five minutes to complete at the end of each shift. I’m going to show you exactly how I do it at The Teal Farm, give you a template you can use from tomorrow, and explain why most pubs get this completely wrong.

Here’s what you’ll learn: how to set up a daily cash reconciliation system that actually works, what to do when the till doesn’t balance, how to spot staff dishonesty versus genuine mistakes, and how to integrate this into a complete pub management system so you’re not scattered across ten spreadsheets.

Read on if you want to stop losing money to cash discrepancies and actually know where every penny goes.

What Is Cash Reconciliation and Why It Matters

Cash reconciliation is the process of comparing your expected till balance to your actual cash at the end of a shift, identifying any discrepancies, and correcting them immediately. It’s not complicated. It’s not optional. And it’s the single most effective way to stop cash walking out the door.

Here’s how it works in practice:

You start your shift with a float — let’s say £200. During the shift, you ring £1,240 in sales. You also take out £50 in staff tips, £30 for a supplier, and £20 for a broken glass. Your expected balance at the end of the shift should be:

Float (£200) + Sales (£1,240) – Payouts (£100) = £1,340

You count the till and find £1,338. Discrepancy: £2. Is that a problem? Not really — it’s rounding, a missed penny, genuine human error. But if you count the till and find £1,300 — that’s a £40 problem. Someone took it, or the till ring was wrong, or a payment wasn’t processed. Without reconciliation you’d never know.

Most pubs don’t reconcile at all. They count the till at the end of the night, put the cash in the safe, and assume it’s fine. Then the accountant raises questions about missing figures six months later. By then it’s impossible to trace.

I started reconciling at The Teal Farm in 2019 and found £8,000 worth of cash discrepancies in the first month alone — mostly tiny amounts (£5-£15) that added up. Once I put the system in place and started holding staff accountable, the discrepancies dropped by 85%. That’s not coincidence. That’s the power of accountability.

Why Most Pubs Fail at Cash Reconciliation

Three reasons pub owners don’t reconcile cash properly, and three reasons they should.

Reason 1: They Use Outdated Spreadsheets

I’ve seen pubs with 15-year-old Excel templates that have never been updated. Formulas break. Staff don’t understand them. Numbers aren’t entered consistently. Someone adds a row in the middle of the formula and the whole thing breaks. The template becomes a paperweight.

A modern pub cash reconciliation template should be simple enough that a teenager can use it, but robust enough that it catches every discrepancy. That means no complex formulas, clear instructions, and automated calculations where it matters.

Reason 2: They Don’t Reconcile Daily

Some pubs reconcile weekly or monthly. That’s like waiting a month to check if your brakes work — by then you’ve had an accident. Cash discrepancies need to be caught the same shift they happen, while staff memory is fresh and you can actually do something about it.

At The Teal Farm, every till is reconciled before the staff member finishes their shift. Takes five minutes. No exceptions.

Reason 3: They Have No Process When the Till Doesn’t Balance

This is the killer. The till is £20 short. What happens? In most pubs: nothing. Someone makes a vague joke about it. Everyone goes home. The manager forgets about it. In a properly run pub: you recount the till. You review the transactions. You check the till readings. You don’t finish the shift until you know where the money is.

Having a template means nothing if you don’t have a process for what happens when it reveals a problem.

The Cash Reconciliation Template (Step-by-Step)

Here’s the exact template I use at The Teal Farm. It’s designed to be completed in under five minutes and works whether you use an old manual till or modern POS system.

Section 1: Opening Float

Record the float you started with. This is your baseline. If your float should always be £200, and someone starts a shift with £180, you’ve already found a problem.

Fields:

• Date
• Shift (Morning/Afternoon/Evening)
• Staff member name
• Opening float amount
• Opening float verified by (manager name)

Section 2: Sales and Transactions

Pull the till readings directly from your POS system. Don’t rely on memory or handwritten notes. Modern tills have detailed reports — use them.

Fields:

• Total sales (from POS reading)
• Card payments processed
• Cash tendered (should match total sales minus card)
• Voids/refunds (with reason)
• Complimentary items (with reason)

Section 3: Payouts and Removals

Every pound that leaves the till must be recorded and authorised. Tips, staff advances, breakage, supplier payments — everything goes here.

Fields:

• Staff tips (total)
• Staff cash advances (with reason)
• Breakage/damage (with reason)
• Supplier payments (with reason)
• Other (with reason)
• Total payouts

Section 4: Expected Balance Calculation

This is the critical bit. Your template should do this automatically, but here’s the formula:

Expected Balance = Opening Float + Total Sales – Card Payments – Total Payouts

This is what you should have in the till.

Section 5: Physical Count

Count the actual cash in the till. Use a second person to verify — two sets of eyes catch mistakes. Record:

• Notes (£50, £20, £10, £5, £1)
• Coins (£2, £1, 50p, 20p, 10p, 5p, 2p, 1p)
• Total physical cash
• Counted by (staff member)
• Verified by (manager)

Section 6: Reconciliation and Variance

Compare expected balance to physical count:

Variance = Physical Count – Expected Balance

Variance should be zero. If it’s not, you have a problem to solve.

Fields:

• Expected balance
• Physical cash counted
• Variance (difference)
• Variance explanation (if not zero)
• Authorised by (manager)

Section 7: Sign-Off

Both staff member and manager sign and date. This creates accountability. You’d be amazed how honest people become when they know they’re signing their name to a document.

I’ve attached a free downloadable template at the end of this section that you can print or adapt to your POS system.

The template takes about five minutes to complete if you’re organised. If you’re using Pub Command Centre, it integrates directly into your system and calculates everything automatically — no manual entry, no room for formula errors.

How to Integrate Reconciliation Into Your System

A standalone template is better than nothing, but it’s still a paper trail that lives in a folder somewhere. The real power comes when you integrate cash reconciliation into a complete pub management system.

Here’s why that matters:

Problem 1: Spreadsheets Don’t Talk to Each Other

You have one spreadsheet for daily reconciliation, another for weekly summaries, another for staff performance. None of them speak to each other. A discrepancy in the reconciliation sheet doesn’t trigger an alert in payroll. An unusually high number of voids doesn’t flag in the manager’s dashboard.

When reconciliation integrates with your POS, inventory, and labour system, patterns emerge that spreadsheets hide. You might notice that specific staff members have higher discrepancies on certain days — that’s a training issue or a theft issue, and you need to know it.

At The Teal Farm, we track every till discrepancy alongside staff shift patterns, menu sales, and customer traffic. We’ve spotted staff stealing within days instead of months because the system joins the dots.

Problem 2: Manual Entry Creates Errors

Someone counts the till, writes down the number, then you manually type it into a spreadsheet. Two opportunities for error before the number even hits your system. Then you manually calculate the variance. Then you manually check if it’s within tolerance. Each step is a chance to get it wrong.

A modern pub management system pulls the till reading directly from your POS, calculates expected balance automatically, flags discrepancies instantly, and notifies the manager — zero manual entry, zero human error in the calculation.

Problem 3: You Can’t See Patterns Over Time

Reconciliation spreadsheets are good for daily control. They’re terrible for spotting trends. Is your Friday night till consistently £30 short? Are certain staff members more reliable than others? Is there a seasonal pattern to discrepancies?

A system like SmartPubTools that handles complete pub operations shows you these patterns in real time. You can see a 12-month trend of cash discrepancies, filter by staff member, by shift time, by till — whatever you need to understand what’s actually happening in your business.

How to Integrate Step-by-Step

Step 1: Choose a System

Your POS system might have built-in reconciliation. Your accounting software might do it. But most dedicated pub management systems handle reconciliation as part of a broader suite — sales, labour, inventory, cash flow all in one place.

Step 2: Set Tolerance Levels

Decide what variance you’ll accept without investigation. Most pubs use 0.5% — a £10 variance on a £2,000 till is acceptable, a £50 variance isn’t. The system flags anything outside tolerance and requires manager approval.

Step 3: Automate Daily Reconciliation

Set the system to run reconciliation at the end of each shift automatically. It pulls sales from the POS, pulls payouts from your records, calculates expected balance, and waits for the physical count.

Step 4: Create an Alert System

Any discrepancy outside tolerance triggers an alert to the manager’s phone. Don’t wait until tomorrow. Deal with it tonight while staff are still there and memories are fresh.

Step 5: Review Weekly Trends

Every Sunday, run a reconciliation report. Spot patterns. Identify staff members with consistent issues. See if certain till periods (breakfast, lunch, dinner) have higher discrepancies. Use data to make training or staffing decisions.

This level of integration is why Pub Command Centre is so effective. Most pub owners I’ve spoken to find discrepancies drop by 70-80% once they implement daily reconciliation with alerts and trend tracking. The system creates accountability without being punitive — staff know the system will catch problems, so problems become rare.

Spotting Real Problems vs. Human Error

Not every till discrepancy is theft. Sometimes it’s honest mistakes. Sometimes it’s system errors. Here’s how to tell the difference — and what to do.

Discrepancy Type 1: Small Random Variances (Under £2)

Cause: Rounding, missed pennies, someone broke a coin, genuine counting error.

Action: Ignore. If it happens consistently, recount and double-check your process. But random £1 variances are noise in a busy till.

Discrepancy Type 2: Consistent Directional Bias (Always Short, Always Over)

Cause: A staff member systematically taking money, or a till that consistently miscounts. If the till is always £5-£10 short on Friday nights, that’s a pattern.

Action: Investigate. Review transactions for that shift. Check if voids and refunds are being processed correctly. Watch that till for a week. If it persists, it’s either a till malfunction or a staff issue.

A pattern of small shortfalls is more dangerous than one large theft — it suggests someone is stealing deliberately and repeatedly, confident they won’t be caught. The goal of daily reconciliation is to catch this before it becomes a £10,000 problem.

Discrepancy Type 3: Large One-Off Variance (£20+)

Cause: Void that wasn’t recorded, refund that didn’t process properly, till error, or outright theft.

Action: Investigate immediately. Review till readings and transaction logs. Ask the staff member. Don’t accuse — ask. “The till is £20 short. Can you walk me through what happened?” Honest staff will help you find the error. Dishonest staff will get defensive.

Discrepancy Type 4: Multiple Variances from Multiple Staff

Cause: Till training issue, POS system glitch, or a culture problem where cash reconciliation isn’t taken seriously.

Action: Review till procedures. Retrain all staff on how to ring sales, process refunds, and handle cash. Check your POS logs for system errors. Make it clear that reconciliation is non-negotiable.

The truth is, most discrepancies aren’t malicious. I’ve found that 80% of variances come from:

• Refunds that weren’t recorded in the till system
• Tips that were removed before the till was read
• Void items that weren’t logged properly
• Honest counting errors (someone miscounted the notes)
• Change that was given incorrectly

The remaining 20% is theft, or till system failures, or staff who aren’t trained properly. That’s why daily reconciliation with clear process is so important — you catch the 20% before it becomes a 40% problem, and you fix training issues before they become culture issues.

For more information, visit RankFlow free trial.