Monthly Budget Template for UK Pubs

Last updated: 11 April 2026

Most pub landlords don’t budget monthly—they wait until the accountant’s year-end summary to find out where the money went, and by then it’s far too late to fix anything. A monthly budget template isn’t a fancy finance spreadsheet; it’s a survival tool that shows you exactly where your cash is flowing and where it’s leaking away. If you’re running a pub without a monthly forecast, you’re flying blind, and every decision you make is based on guesswork rather than data. This guide will walk you through building a practical pub monthly budget template designed for the real operational pressures of running a UK pub in 2026—from quiet Tuesdays to packed match days—and show you how to use it to protect your profit margin before the month even ends.

Why Most Pubs Fail at Monthly Budgeting

I’ve seen a lot of pubs struggle with budgeting, and the problem is almost always the same: they treat it like a compliance exercise rather than a management tool. They build a budget in spreadsheet because an accountant told them to, then never look at it again until February when the accountant asks for it. By then, the damage is done.

The most effective way to budget for a UK pub is to build a template that reflects your actual trading week, not an imaginary “average” week. A wet-led pub in Washington serving quiz nights and match days has completely different revenue and cost patterns from a food-led establishment, and your budget needs to account for that variation. I learned this the hard way at Teal Farm Pub: we’d forecast based on a flat £4,000 weekly wet sales average, but reality was more like £2,800 on a quiet Tuesday and £6,200 on a Saturday with a match on the screens. Using the flat average meant we either looked over-budget or under-budget almost every single week, which made the template useless as a decision-making tool.

The second mistake most pub operators make is failing to separate revenue streams. You’ll lump “sales” into one line, but wet sales, food sales, and other income (gaming machines, quiz money, room hire) all have completely different cost profiles. Draught beer might be 65% cost of goods, but food is closer to 30%, and gaming machine income is nearly all profit. If you don’t separate them, you can’t see which part of your business is actually profitable.

Third: most pub budget templates don’t account for the irregular costs that hit UK pubs. You’ll budget for rent, rates, staff wages, and utilities—all good—but then a cellar deep-clean, equipment repair, or peak season staff bonus arrives unplanned and blows your forecast apart. A real budget needs contingency lines and seasonal adjustment factors.

The Five Core Sections of a Pub Budget Template

A workable pub monthly budget template has five distinct sections. Keep it simple, because simplicity is what makes you actually use it.

Section 1: Revenue Forecast

Break this into at least three lines:

• Wet sales (draught, bottles, spirits, wine): This is your primary revenue driver and the most volatile. Budget separately for standard weeks and event weeks (match days, quiz nights, bank holidays).
• Food sales: If you serve food, forecast separately. Your food margin is completely different from wet sales, and mixing them obscures the real profitability.
• Other income: Gaming machines, quiz entry fees, room hire, raffles. These are smaller but important for margin calculation.

The reason this matters is because you need to forecast not just total revenue, but the mix of revenue. A month with high food sales will look profitable on the top line but carry lower overall margin than a month with equivalent wet sales volume.

Section 2: Cost of Goods Sold (COGS)

This section is where most pub operators get sloppy. Budget separately for:

• Draught beer, cider, lager cost
• Spirits, gin, vodka cost
• Wine and prosecco cost
• Food COGS (if applicable)
• Glass breakage and waste

Why this granularity? Because not all beer costs the same. A pint of premium lager costs you more than standard bitter, and if you’re running heavy on premium sales that month, your overall wet COGS percentage will be higher. If you lump all COGS into one line, you’ll think you have a cost problem when actually you just sold a different product mix.

Section 3: Direct Operating Costs

These are the costs that scale with sales volume:

• Staff wages (FOH and kitchen)
• National Insurance and pension contributions
• Cleaning and hygiene
• Packaging (bags, boxes, branded materials)

These costs don’t stay flat when your sales go up. A Saturday night with double the usual revenue will require extra staff on shift, more cleaning materials, and more packaging. Your budget needs to reflect that.

Section 4: Fixed Operating Costs

These are the costs that don’t change month to month (or don’t change much):

• Rent and business rates
• Utilities (gas, electric, water)
• Insurance
• Maintenance and repairs (budgeted, not emergency)
• Professional fees (accountant, legal)
• Licensing and compliance

The word “fixed” is slightly misleading—utilities will vary seasonally, and if you’re tied to a pubco, your supplies might come through a mandated pricing structure. If you’re operating under a pubco arrangement, your budget is only useful if it accounts for pubco pricing and mandatory purchase commitments, not open market rates.

Section 5: Cash Flow and Variance

This is the section most pubs skip, and it’s the one that matters most. Budget not just for profit, but for cash timing. You might have a profitable month on paper but be short of cash because supplier invoices hit on the 5th and your cash sales came in on the 25th. This section should show you:

• Budgeted profit/loss for the month
• Cash in hand at month start
• Actual cash surplus/deficit
• Variance between budget and actual (investigated every month)

Using a pub profit margin calculator alongside your budget template helps you understand not just whether you hit your numbers, but what margin you’re actually working with on each revenue stream.

Revenue Forecasting: Getting Your Numbers Right

Here’s an operator insight that only someone who’s actually managed a pub till system would know: your EPOS data is your best budgeting tool, but only if you’re reading it correctly. Most pub operators look at total weekly sales and call it a forecast. Wrong. You need to break it down by day of week, by daypart (lunchtime vs. evening vs. late night), and by product category.

Monthly revenue forecasting for a pub requires analysing your last 12 months of trading by day of week and event type, not by averaging everything into one “normal week” figure. At Teal Farm, we discovered that our Thursday quiz nights added £480 in wet sales but also required £120 in additional staff costs and £60 in quiz materials. Our Saturday football match days added £1,800 in revenue but required double kitchen and bar staffing, meaning the actual profit contribution was only 35% instead of our normal 60%. Once we broke the forecast down this way, budgeting became real.

Your forecast needs to account for:

• Day of week variation: Monday to Friday probably looks completely different from weekends. Budget separately.
• Event weeks: Bank holidays, major sporting events, quiz nights, karaoke nights. These are forecasted separately because they’re not “normal” weeks.
• Seasonal variation: Summer might see garden trade but lighter evening bar trade. Winter sees heavier bar trading but higher utility costs. Spring and autumn are often quiet. Your budget needs to reflect the actual season, not pretend every month is the same.
• Product mix: If July sees more cider and prosecco sales than February (higher margin), your average COGS will actually be lower. This matters for your bottom line.

For food-led pubs, forecast food revenue separately, because food drives different customer behaviour. A customer buying a £18 Sunday roast generates £12 in revenue margin but requires 45 minutes of kitchen labour. That same customer might buy a pint worth £3 margin with 30 seconds of bar staff time. Your budget needs to understand what type of customer traffic is actually profitable.

Cost Categories Every Pub Must Track

I’m going to be direct here: most pubs under-budget for staffing costs, and it kills them by Q3. Staff costs are your single largest controllable expense in a UK pub, and if you don’t budget for them properly, you’ll either overspend and wreck your margin, or under-staff and destroy your customer experience.

Your staffing budget needs to account for:

• Base hourly rates (which will vary by role and experience)
• National Minimum Wage requirements (different for apprentices, under-21s, and over-21s)
• Employer National Insurance on all wages above the threshold
• Pension contributions (auto-enrolment is mandatory if you have staff)
• Holiday pay accrual (5.6 weeks paid time off per year is a legal requirement)
• Overtime or unsocial hours premiums if applicable
• Training time paid but not revenue-generating

A common mistake: budgeting for 40 hours of bar staff per week at £11/hour and thinking that’s your cost. It’s not. Add National Insurance (~15% on wages), pension contributions (~3%), and holiday accrual (~11% on top of hourly rate), and that 40 hours just cost you about £560/week, not £440. Miss this adjustment and you’ll be overspending on staffing by £120/week without knowing why.

If you’re managing multiple staff across front-of-house and kitchen operations like we do at Teal Farm with 17 team members, use a pub staffing cost calculator as your starting point, then adjust for your actual roster and shift patterns. Don’t guess.

Beyond staffing, your other cost lines need monthly attention:

Cost of Goods Sold (COGS): Most UK pubs target 62-68% wet COGS and 28-32% food COGS. If you’re running higher, there’s either a stock control problem, a pricing problem, or a product mix problem. Budget to your historical actual, not to industry averages, because your venue is unique.

Utilities: Budget seasonal variation. January heating costs might be 40% higher than June. If you have a beer garden or outdoor heaters, budget for seasonal spikes.

Maintenance and repairs: Most pubs budget £100-300/month for planned maintenance and then get blindsided by a £1,500 cellar cooler repair. Set aside a “maintenance contingency” line of 2-3% of monthly revenue and use it only for actual repairs, not for day-to-day supplies.

Rates and rent: These should be flat unless you know of a review coming. But check your lease—some pubco tenants have variable rent tied to sales performance.

Setting Realistic Targets and Variance Analysis

A budget with no variance column is just a guess. The real power of budgeting comes from comparing what you forecast against what actually happened, every single month, and investigating the difference.

Set up your template with these columns:

• Budgeted amount
• Actual amount
• Variance (actual minus budget)
• Variance percentage
• Notes (what caused the difference?)

Most variances under 5% are noise and don’t need investigation. Variances over 5% on major line items demand attention. If you budgeted £3,500 in wet sales and actual was £3,200, that’s a 9% miss. You need to know why. Was it weather? Was it a cancelled event? Was it a pricing issue? Was it lower footfall?

The reason this matters is because understanding variance teaches you how to forecast better next month, and it flags real business problems before they become crises. If your wet COGS was budgeted at 65% but actual came in at 68%, you either have a stock control problem, a till accuracy problem, a theft problem, or you’re selling a different product mix than you thought. Those are very different investigations, and a budget variance forces you to pick one and find out.

For tied pubs or those working with a pubco, your budget variance also matters for compliance. Some pubco arrangements require monthly reporting against budget, and a significant variance might trigger a pubco audit or support visit. Use variance analysis as your first line of defence: investigate your own numbers before the pubco does.

Monthly variance investigation of just 20 minutes per line item catches cost drift before it compounds into quarterly losses. Make this a routine: spend 20 minutes on the Friday after month-end reviewing variances and making notes. That single habit will save you thousands in the year.

How to Use Your Budget as a Management Tool

The biggest mistake pub operators make with their budget template is treating it as a document to complete, not a document to use. They build it, hand it to an accountant, and forget about it until next month.

Your budget should drive real decisions:

Staffing decisions: If your budget said you’d need 45 hours of bar staff this week based on forecasted revenue, but actual revenue is tracking 15% below budget by Wednesday, you’ve got permission to send someone home early or cancel the Friday shift. Most pub staff understand this if you explain it clearly.

Purchasing decisions: If you forecasted £800 in food COGS but you’re at £650 with two weeks left in the month, you have headroom to order extra stock for a planned event. If you’re already at £750 with two weeks left, you need to tighten purchasing.

Pricing decisions: If your actual COGS is running 3 percentage points higher than budget, your next action isn’t to panic—it’s to either adjust purchasing or consider a small price increase. Use the pub drink pricing calculator to model what a 20p increase on your average pint does to margin. You might find you can absorb the COGS increase without hurting volume.

Strategic decisions: A well-maintained budget tells you which revenue streams are actually profitable. If your quiz night generates £480 in revenue but costs £180 in prizes, staff, and materials, and leaves you with £300 in contribution, that’s valuable. But if your karaoke night generates £400 in revenue and costs £200 in equipment and staff, leaving you with £200 contribution, the quiz night is a better investment of your time and resources. Your budget forces these trade-offs into the light.

For operators running multiple cost centres or complex staffing (like managing a team across kitchen and front-of-house), pub IT solutions can help you automate data collection from your EPOS and payroll systems, feeding actuals directly into your budget template. This eliminates manual data entry errors and lets you review variance analysis with reliable numbers.

One final operator insight: your budget is most useful when it’s reviewed religiously with your management team or your accountant. I review ours on the first Friday of every month with our kitchen manager and head of bar. It takes 45 minutes. They see the numbers, they understand the targets, and when they’re in charge of staffing or purchasing decisions, they already know what we’re trying to hit. This removes guesswork and creates accountability at every level.

For more information, visit pub profit margin calculator.

For more information, visit pub staffing cost calculator.

For a working example with real figures, the Pub Command Centre is used daily at Teal Farm Pub (Washington NE38, 180 covers) — labour runs at 15% against a 25–30% UK average.