Cash Flow Forecasting for Pubs: Stop Guessing, Start Planning

Last updated: 10 April 2026

Most pub owners don’t know if they’ll have cash in the bank next month until it’s too late. You’re trading profitably on paper but running out of money in reality—and there’s no warning sign until the overdraft maxes out or VAT is due and you can’t pay it.

I’ve watched good pubs fail not because they were unprofitable, but because the owner had no visibility into cash flow timing. A supplier demands payment upfront. A major event didn’t happen. A staff member didn’t show up and you paid overtime. Suddenly the cash position collapsed—and there was zero advance warning.

This article cuts through the complexity. You’ll learn exactly how to forecast your cash position 13 weeks ahead, spot VAT shortfalls before they hit, and make decisions based on reality instead of guesswork. No spreadsheet nightmares. No accounting jargon. Just a practical system that works at The Teal Farm and works for hundreds of other pubs using Pub Command Centre.

Why does this matter? Cash kills more pubs than lack of profit. You can be profitable and bankrupt simultaneously—and that’s preventable with proper forecasting.

What Cash Flow Forecasting Actually Is

Cash flow forecasting is predicting when money physically enters and leaves your bank account over the next 13 weeks. It’s not profit. It’s not turnover. It’s the actual cash position on specific dates.

Here’s the distinction that matters: Your pub might show £15,000 profit this month on an accounts basis. But if you bought £8,000 of stock on credit last month and that’s due this week, plus your rent is due Friday, plus you have £3,000 payroll Tuesday—your actual cash position might be negative despite the profit. That’s a cash flow problem, and spreadsheets rarely capture it properly.

A cash flow forecast answers three questions:

• What’s my cash position on specific dates over the next 13 weeks?
• When will I fall short and need to cover it with overdraft or savings?
• When should I expect positive cash weeks where I can pay down debt or invest?

The 13-week horizon matters because it covers the major payment cycles: rent (usually monthly), VAT (quarterly), loan repayments, stock purchasing, and payroll. Shorter forecasts miss the bigger patterns. Longer forecasts become unreliable guesses.

Why Most Pubs Get This Wrong

Most pub owners focus on profit and turnover—and then wonder why their bank balance doesn’t match the numbers. Here’s why the mismatch happens:

Timing gaps between profit and cash. You sell a drink today for £5 (profit recorded). The customer paid cash, so the cash is immediate. But you bought that bottle on 30-day credit terms two weeks ago. That cash left your account before the sale happened. If you bought £2,000 of stock this week but don’t sell it for three weeks, your cash position is negative even though profit is positive.

Most pub owners don’t track the difference. They see turnover and assume cash position follows—it rarely does.

VAT is a cash killer. You collect VAT from customers (holding it in your account as a liability). You pay it to HMRC quarterly. If you haven’t mentally set that cash aside, VAT due date becomes a crisis. I’ve seen pubs with strong sales fail because they spent their VAT liability on stock and couldn’t pay HMRC when the bill landed.

For pub and hospitality business insurance, Premierline compare quotes from leading UK insurers in minutes. As a specialist business insurance broker they understand the specific risks pub landlords face — from public liability to employers liability and stock cover. Get a quote from Premierline here.

Loan and rent payments are predictable but often forgotten in forecasts. You know exactly when rent is due, but most one-off forecasts don’t account for it properly. Building a rolling forecast means these fixed payments are always visible.

Seasonal swings catch owners unprepared. Summer is strong, autumn is quieter, Christmas is busy, January is dead. If you don’t forecast this ahead, you’ll hit January short on cash and panic. A forecast shows you the gap three months in advance.

The honest reason most pubs fail at cash forecasting? Manual spreadsheets are painful, time-consuming, and they lie. You update them once a month, they’re outdated by week two, and you stop trusting them.

The Problem With Spreadsheets and Guessing

I’ve spent hundreds of hours building pub financial models in Excel. Every time, the same pattern emerges: the spreadsheet is accurate for three weeks, then it’s out of sync with reality. Actuals change faster than you update the forecast. You get frustrated and stop using it.

Here’s what breaks manual forecasts:

Data entry takes 15-20 minutes daily if you’re doing it right. Most pub owners don’t have that time, so they update once a week or once a month. By then, actuals have changed. The forecast becomes fiction. You stop trusting it, so you stop using it.

Manual spreadsheets don’t connect to your actual accounts. You’re copying numbers from your till, your bank account, maybe a supplier invoice, maybe a payroll system. All manual entry means human error. And if actual figures change, you have to manually update the forecast.

You don’t know which numbers matter. Should you be forecasting daily sales or weekly? Daily labour or weekly? Should VAT be a line item or a percentage? Most owners guess, which means the forecast is only as good as those guesses.

It’s impossible to run scenarios. “What if footfall drops 10% next month?” requires a complete rebuild of the spreadsheet. “What if I hire another member of staff?” means rewriting payroll sections. Scenario planning—which is the actual value of forecasting—becomes too time-consuming to bother with.

The result? Most pubs abandon cash flow forecasting entirely. They manage cash reactively: when the overdraft is high, they worry. When it’s low, they relax. That’s not forecasting—that’s hoping.

How to Build a 13-Week Cash Flow Forecast

This is the practical system that works. It’s designed for pub owners with zero accounting background and zero time to spare.

Step 1: Set Up Your Forecast Structure

Create a simple table with 13 columns (13 weeks ahead) and rows for each cash category. Don’t overcomplicate it. Here’s the structure:

• Opening cash balance (what you start the week with)
• Cash in: Till sales (cash taken), card payments (when they hit your account), other income
• Cash out: Payroll, supplier payments, rent, utilities, loan repayment, drawings
• Closing cash balance (opening + cash in − cash out)

That’s it. Five lines. Thirteen weeks. Don’t add “projected profit” or “accruals” or any accounting complexity. This is a cash tool, not an accounts tool.

Step 2: Populate Historical Data

Look back at your last 13 weeks of bank statements and till data. Calculate:

• Average weekly cash sales (till takeout)
• Average weekly card sales (look at deposits to your account)
• Weekly payroll average
• Weekly supplier payment average (be honest about payment terms—if you buy on credit, forecast when you pay, not when you order)
• Fixed costs: rent, rates, loans, insurance (the weekly amount of each)

Don’t try to be too precise. A 13-week forecast is inherently imprecise. Close approximations are fine. The value is in spotting the gaps, not hitting exact numbers.

Step 3: Account for Known Events

Now adjust for things you know are coming:

• Seasonal dips: If January is always quiet, forecast 20% lower sales than average.
• Supplier terms: If you buy £1,000 stock this week but pay in 30 days, show the cash going out in week 4, not week 1.
• Planned purchases: If you’re buying new equipment, new stock, or refurbishing, put that cash out in the right week.
• VAT payments: VAT is due quarterly. If it’s due in week 6, calculate your likely VAT liability and show it going out then.
• Loan or rent reviews: If rent is increasing next quarter, adjust it in the forecast now.

This is where forecasting actually prevents disasters. Three months ago, I noticed our forecast showed a cash shortfall in week 9 due to VAT and rent falling in the same week. We weren’t profitable yet—we just hadn’t noticed it. Because we saw it in advance, we adjusted stock purchasing that month and smoothed the cash flow. Without the forecast, we’d have hit week 9 in crisis mode.

Step 4: Review Weekly, Update Rolling

Every Monday morning, spend 10 minutes updating the forecast:

• Remove last week’s forecast column (you now have actuals instead)
• Add a new column 13 weeks ahead
• Update this week’s actuals (cash in and cash out) based on your bank account and till
• Look at the closing balance for weeks 2–4. Are there any shortfalls?

That’s the whole process. Ten minutes. Weekly. Rolling 13-week view.

The Key Variables You Must Track

Most pub owners try to forecast too much detail. Here are the variables that actually matter:

Cash Sales vs Card Sales Timing

This is the biggest mistake in pub forecasting. Cash tills and card payments don’t hit your account at the same time. Cash comes out of the till immediately (you physically have it). Card payments take 1–3 days to deposit depending on your payment processor.

If you average £500 cash daily and £1,000 card daily, your actual weekly cash position isn’t £10,500 on Tuesday. It’s £3,500 cash (Monday–Wednesday tills) plus £1,000–2,000 card deposits (depending on processing delays). That gap matters.

Forecast cash and card separately. Look at your actual bank deposits from last month. See the pattern. Most pubs deposit daily, but the actual cash hit your account 1–2 days later.

Payroll Timing

When does payroll actually leave your account? If you pay weekly on Friday, forecast it leaving Friday. If you pay monthly on the 25th, forecast it then. Don’t use an “average” payroll number—use actual payroll weeks.

Track overtime separately too. If you typically have one member of staff away per month, you’ll have one week with 10% higher payroll costs. Put that in specific weeks, not averaged across all weeks.

Stock and Supplier Payments

This is where most forecasts fail. You don’t forecast cash when you order stock. You forecast cash when you pay for it.

Look at your actual payment terms with suppliers. Are you paying cash on delivery? 7 days? 30 days? If you buy £2,000 stock on Tuesday on 30-day terms, show that £2,000 cash going out 30 days later, not on Tuesday.

For daily stock purchasing (small suppliers, cash buys), estimate a weekly figure based on last month’s actuals.

VAT and Tax Liabilities

This deserves its own line in your forecast. Calculate your average weekly VAT collection (roughly 20% of your net sales if you’re standard-rated). Multiply that by three. That’s your VAT liability forecast for the next VAT period.

When is VAT due? Add that in the specific week. Most pubs go quarterly: January 31st, April 30th, July 31st, October 31st. When those dates approach, your forecast should light up red.

VAT surprises are 100% preventable with proper forecasting. You know exactly when VAT is due and roughly how much you’ll owe. If your forecast shows you’ll be short, you can adjust purchasing or borrowing now, not panic on due date.

Fixed Costs (Rent, Rates, Insurance, Loans)

These don’t vary week to week, but they’re easy to forget. Put them in the specific weeks they’re due:

• Rent: usually monthly on a fixed date
• Business rates: quarterly or monthly depending on your arrangement
• Insurance: monthly, quarterly, or annual depending on your policy
• Loan repayment: monthly or as per your loan agreement
• Utilities: monthly, sometimes quarterly for gas

These are forecast certainties. You know exactly when they’re due and how much. There’s no guessing.

For pub business rates increases in 2026, if you know a new rate is coming, adjust your forecast now. Don’t wait for the bill.

Avoiding Common Cash Flow Traps

Here’s where most pub owners stumble:

Trap 1: Confusing Profit With Cash

You can be profitable and short of cash simultaneously. Here’s how: You sell to a customer on credit terms (30 days). You immediately record it as profit. But the cash doesn’t arrive for 30 days. Meanwhile, you’ve paid your supplier cash on delivery. Profit is positive. Cash is temporarily negative.

In pubs, this usually happens with wholesale or events. You agree to supply a function on 30-day terms. You buy stock cash upfront. Profit is recorded immediately. Cash is delayed. Most pub owners don’t forecast this correctly.

Solution: Forecast only actual cash in/out, not profit. Don’t try to map profit into your cash forecast. They’re different things. Use your forecast for cash decisions, your P&L for profit decisions.

Trap 2: Forgetting Stock Purchases Are Cash, Not Profit

When you buy £1,000 of stock, that’s cash out immediately (or on your terms). It doesn’t become profit until you sell it. Yet most pub owners forecast stock as if it’s an expense that spreads across weeks.

It’s not. It’s cash out on the day you buy it (or pay for it if on credit). Forecast it that way.

Trap 3: Ignoring Seasonal Cash Swings

Summer is busy. January is dead. Most pubs know this intellectually but don’t forecast it. So they hit January short on cash and wonder why.

Look at your last two years of sales data. What was January actual compared to average? December? August? Build that seasonality into your forecast. If January is 30% down compared to average, forecast it that way.

Trap 4: Not Accounting for Payment Term Changes

You’ve been buying from a supplier on 30-day terms. They tighten it to 14 days. That’s not a profit issue—it’s a cash issue. Your cash goes out faster. If you don’t adjust your forecast, you’ll hit a week where you’re suddenly short.

Every time a supplier changes payment terms, update your cash forecast immediately.

Trap 5: Underestimating Unplanned Cash Out

Equipment breaks. You need replacement stock. A supplier demands payment upfront for an event. Real businesses have unplanned cash leaks.

Don’t try to forecast these specifically. Instead, keep a cash buffer. If your forecast shows you’ll hit £1,000 on the lowest week, aim to actually have £2,500 in reserve. That buffer absorbs the surprises.

Most pubs using SmartPubTools find £1,000s in hidden cash optimizations in the first week of forecasting properly. Most of that isn’t “better trading”—it’s simply knowing when cash is tight and managing purchasing accordingly.

Implementing Your First 13-Week Forecast

Don’t try to build a perfect forecast. Build a simple one that’s 80% accurate and actually gets used.

Week 1: Build the structure. Set up your 13 columns. Add your five main line items (opening balance, cash in, cash out, closing balance). Add sub-lines for payroll, suppliers, rent, VAT. That’s it. 30 minutes.

Week 2: Populate with history. Look at your last 13 weeks of bank statements. Calculate averages. Fill in the forecast with those numbers. Add known fixed costs. 45 minutes.

Week 3: Add next quarter’s known events. VAT due? New rent rate? Stock purchases planned? Equipment replacements? Add them to specific weeks. 20 minutes.

Ongoing: Update every Monday morning. 10 minutes. Remove last week. Add new week 13. Look for red flags in weeks 2–4.

That’s the system. It’s not glamorous. It’s not complicated. But it works because it’s based on how pub finances actually function, not accounting theory.

The alternative is what most pub owners do: no forecast, reactive cash management, and periodic panic when the overdraft maxes out. Your choice.

For pubs that want to eliminate the spreadsheet entirely and have cash forecasting built directly into their systems, Pub Command Centre handles this automatically. Your cash forecast updates daily based on your actual sales and labour data. But the logic remains the same: predict cash in/out for 13 weeks, update weekly, act on what you see.

For more information, visit RankFlow free trial.

For more information, visit RankFlow marketing tools.