Pub Takings Sheet Template for 2026

Last updated: 2 May 2026

Most pubs I know use a takings sheet that hasn’t changed since 2010. The problem isn’t the template — it’s that pub operators treat it like an admin task rather than a financial control. When I took on Teal Farm Pub three years ago, my cash reconciliation was off by £200-300 every week, and I couldn’t find where the money had gone. I didn’t have a proper takings sheet; I had a piece of paper and a vague memory of what I’d banked. You’re probably in a similar position: you want to track your daily takings, but you’re not sure what information actually matters or how to spot problems early.

A proper pub takings sheet template does three specific things. It gives you a daily record that your pubco can audit. It helps you spot stock variance before it becomes a crisis. And it makes banking reconciliation take minutes instead of hours. This guide walks you through what a working takings sheet looks like, what you should record, and why the order matters.

What a Pub Takings Sheet Actually Is

A pub takings sheet is a daily record of cash in and out, matched against EPOS sales, with a final variance line that tells you if the numbers agree. Not a guess. Not a rough total written on the back of a beer mat. A record that your pubco, your accountant, or an auditor can follow and verify.

Most pubs call it different things: cash reconciliation, daily takings sheet, till sheet, or just “the numbers.” The principle is always the same — you record what the till says you’ve taken, what you’ve actually banked, and whether they match.

Here’s the distinction that matters: a takings sheet is not the same as a till reading. Your till (or EPOS system) tells you what customers bought. Your takings sheet tells you whether that money made it to the bank. When those two numbers don’t match, your takings sheet is the document that proves you investigated and found out why.

Why It Matters More Than You Think

During my NSF audit in March 2026, the auditor spent forty minutes on my takings sheets. Not because they were looking for evidence of theft — they weren’t. They were checking that I had a system of control. If your takings sheet is haphazard, your pubco assumes your stock control is haphazard too. If your stock control looks weak, variance becomes suspicious. If variance is suspicious, you’re in a conversation you don’t want to have.

The real reason to keep a takings sheet is that it proves you’re running the pub like a business, not a hobby. That matters to your pubco, your accountant, and eventually to a bank if you ever need to refinance or take on investment.

A second reason: variance. When you reconcile your takings weekly, you spot stock issues in days, not weeks. I once had a takings variance of £47 on a Wednesday. Turned out the cellarman had put one keg in the skip instead of the waste line — I’d already paid for that beer but it never made a sale. The takings sheet caught it before it became a £200+ problem by the end of the month.

Your pubco also uses takings sheets to justify your rent. If your takings sheets show consistent, documented revenue, that’s evidence in your favour if you ever challenge a rent review or need to defend your financial position. A pub profit margin calculator can help you understand what those takings should convert to, but the calculator is only as good as your data.

What to Record on Your Takings Sheet

The Core Columns

A minimal takings sheet has these columns — in this order:

• Date — Calendar date, plus day of week (helps you spot patterns)
• EPOS total — What your till says you took (including cash and card)
• Cash banked — The actual cash you took to the bank that day (or the next morning)
• Card takings — Card payments processed through your EPOS
• Cash in till — Float you left in the till overnight
• Variance — The difference between EPOS total and (cash banked + card takings + float)

That’s it. Six columns. You don’t need more. Every column you add is another place to make a mistake.

What to Do With Variance

Variance can be zero, positive (you’ve taken more than the till says), or negative (you’ve taken less). A small variance (under £10 on a pub doing £1,500 daily takings) is normal — rounding errors, mistakes in short change, the till display being fractionally different from what the system shows. Anything larger needs investigation.

When you find variance, write a note: “£23 over — found £20 note under bar, banked £43 instead of £20 cash.” That note is worth more than the variance column itself. It proves you investigated.

Optional Columns (Only If You Use Them)

Some pubs add columns for:

• Voids or refunds (track separately if they’re significant)
• Staff tips (if you operate a tronc or separate tips jar)
• Opening float (helps with cash flow forecasting)
• Wet sales and dry sales split (more useful in a pub management system than on a paper sheet)

Only add these if your pubco requires them or if they solve a real problem you’re facing. A takings sheet that’s too complicated doesn’t get filled in.

Cash Reconciliation: The Real Test

Cash reconciliation is the moment when your takings sheet either balances or reveals a problem — and that moment should happen weekly, not at the end of the month.

Here’s how it works in practice at Teal Farm:

1. Every night, I empty the till and count the cash.
2. I record the amount on the takings sheet.
3. The next morning, before the pub opens, I reconcile: EPOS total minus card takings minus cash float equals the cash that should be in my pouch ready to bank.
4. If it matches, I bank it and record the date banked.
5. If it doesn’t match, I investigate before I bank anything — sometimes I’ve miscounted, sometimes there’s an error in the till.
6. Every Friday, I total up the week’s takings and check that the sum of variances is close to zero. If it’s not, something is systematically wrong.

This takes me five minutes a day and fifteen minutes at the end of the week. It catches ninety percent of problems before they become your pubco’s problem.

The pubco will also verify this. During an NSF audit or a compliance visit, they’ll ask to see your takings sheets and they’ll spot-check them against your bank statements and EPOS reports. If your takings sheets don’t line up with your bank deposits, questions get asked. If you can’t answer them with evidence, your credibility takes a hit.

Common Mistakes Pub Operators Make

Mistake 1: Filling It In Weekly Instead of Daily

If you wait until Friday to fill in your takings sheet, you’ll forget details. You won’t remember why Tuesday’s till was £15 light. You’ll guess instead of investigate. By then, the variance is four days old and harder to trace. Fill it in daily, same time every day (I do mine with a coffee before we open).

Mistake 2: Mixing Cash Banked With Cash Spent

Your cash banked figure should be the amount you actually took to the bank — nothing more, nothing less. If you spent £30 on crisps with cash that morning, that’s not part of your takings. It’s a purchase. Record it separately in your cash flow sheet, not in your takings sheet. These two documents serve different purposes.

Mistake 3: Not Documenting Variances

I’ve seen takings sheets where someone just writes “£12 variance” and nothing else. Your pubco or an auditor will want to know why. “Voids,” “over-ring,” “customer refund,” “staff discount” — these are actual answers. Write them. If you can’t explain it, it looks like you’re hiding something, even if you’re not.

Mistake 4: Using Multiple Tills and Not Reconciling Each One

If you have a back bar till and a front bar till, reconcile both separately, then add them together for your main takings sheet. Don’t try to reconcile them as one figure — you’ll never know which till the error came from. At Teal Farm we have two tills and I reconcile them separately every night, even though it adds two minutes to the process.

Mistake 5: Trusting the Till Reading Absolutely

Your EPOS system should be accurate, but it’s not perfect. Tills can have glitches. Sometimes a transaction doesn’t close properly. Sometimes a refund processes but the till display doesn’t update. That’s why you count the physical cash. The physical count is your truth. The till is the hypothesis you’re testing.

Tools, Templates and Systems

Paper Takings Sheets

A paper takings sheet works. Print a template, laminate it, fill it in with a dry-erase pen, photograph it every week, and keep the originals in a folder. Your pubco will ask for these during an audit and you need to be able to produce them. If you’re starting out and don’t have a system yet, a paper sheet with the six columns I’ve outlined above is a completely legitimate starting point.

Excel or Google Sheets

Most pubs I know use a spreadsheet. Google Sheets for pub management works well because you can access it from your phone, set up automatic variance calculations, and email it to your accountant at the end of the week. Build in a formula so the variance column calculates itself — fewer mistakes.

The advantage of a spreadsheet is that weekly totals, monthly totals, and variance averages work automatically. You also have a running record that’s easy to search. The disadvantage is that you have to remember to fill it in — it won’t remind you like a paper sheet pinned to the till does.

Integrated EPOS Systems

Serious pub operators use an EPOS system that generates your takings automatically. You still need to reconcile manually (because the till can be wrong), but a modern EPOS should give you a daily takings report that includes cash expected, cards expected, and a space for your manual reconciliation notes. I’ve personally evaluated best pub EPOS systems for community pubs handling wet sales, dry sales, quiz nights, and match day events simultaneously — the reconciliation features are usually buried in menus and not well designed for daily use.

If you’re considering an EPOS system, ask specifically how the daily reconciliation works. If you have to log into five different screens to find your numbers, you won’t use it consistently.

Pub Management Systems

The most advanced option is a Pub Command Centre that integrates takings, stock, labour, and compliance in one place. You record your daily reconciliation once, and it feeds into your weekly P&L, your stock variance tracking, and your pubco reporting. At Teal Farm, combining takings data with a proper system has reduced our paperwork by hours and given us real-time visibility into whether we’re profitable or not. That wasn’t possible with a paper sheet.

But if you’re not ready for a full system, don’t let that stop you from keeping proper takings sheets. A spreadsheet is better than nothing. Paper is better than a spreadsheet that doesn’t exist.

For more information, visit retail partner earnings calculator.