Download Pub Command Centre: Your Setup Guide for 2026

Last updated: 6 April 2026

Most pub owners spend their first month after buying management software just trying to figure out how to use it. Meanwhile, money’s leaking out of the business unnoticed. That’s not how it should work. The best pub management tool is the one you actually use—and that means it has to be dead simple to get running. Pub Command Centre is built on that principle: download it, set it up in 30 minutes, start seeing your numbers clearly by day two. This guide walks you through exactly what to expect, how long it takes, and what you’ll have under control the moment you’re live.

What You Get When You Download Pub Command Centre

When you download Pub Command Centre, you’re getting a complete operating system for your pub—not just another spreadsheet. This is the difference between a tool that sits on your hard drive and one that actually changes how you run your business.

The download package includes everything you need from day one: a pre-built financial dashboard, labour tracking templates, cash flow forecasting sheets, inventory management modules, and built-in profit margin calculators for every category of drink and food you serve. Nothing is left blank. Nothing requires you to build it from scratch. At The Teal Farm, we had our first complete financial picture within two hours of opening the file.

You’re also getting access to the setup support resources, the video walkthrough library, and direct access to the community of pub owners who use the same system. That matters more than it sounds. When you get stuck—and everyone gets stuck somewhere—you’ve got real landlords who’ve solved the exact problem you’re facing.

The file size is under 50MB, so download time is seconds on any reasonable internet connection. It works on Windows, Mac, and Linux. You don’t need to install anything or pay monthly subscriptions. Download Pub Command Centre once, own it permanently, and use it forever. £97 one-time payment covers everything.

System Requirements and Pre-Download Checklist

This is where most pub management software becomes a nightmare. They demand specific operating systems, outdated browsers, or seventeen different plugins. Pub Command Centre works on nearly any device you already own.

Minimum Requirements

• Windows 10 or later, macOS 10.13 or later, or any modern Linux distribution
• At least 2GB of available hard drive space
• No internet connection required after download (though optional cloud backup requires one)
• Microsoft Excel, Google Sheets, or any compatible spreadsheet application

Before You Download: Pre-Setup Checklist

Spend ten minutes gathering these things before you hit download. It accelerates setup by about 75 percent.

• Your last three months of bank statements — screenshot or PDF, it doesn’t matter. You’ll need these to populate your opening balances.
• Current staff list — names, hourly rates, contracted hours, department (bar, kitchen, management). A simple notepad list works fine.
• Your current drink and food pricing — just a list of what you charge for your top 20 products. You don’t need everything on day one.
• Your lease and loan documents — to input fixed costs like rent, mortgage, or equipment finance. These are one-time entries.
• Your last VAT return — if you’re VAT registered, you’ll want this handy to verify your historical tax position.

That’s it. If you’re missing any of these, don’t wait. Setup proceeds fine without them—they just make the first hour faster and more accurate.

Step-by-Step Download and Installation Process

Here’s the actual process, exactly as it happens, from the moment you decide to download.

Step 1: Purchase and Receive Your Download Link (2 minutes)

You visit https://smartpubtools.com/5684-2/, complete the checkout for the £97 one-time payment, and within seconds you’ll receive an email containing your unique download link and your access credentials. The email also contains your setup video and a PDF quick-start guide. Don’t lose this email—save it or print it. That’s your reference during setup.

Step 2: Download the File (30 seconds)

Click the download link in your email. The file downloads as a .zip archive called PubCommandCentre_2026.zip. On Windows, right-click it and select “Extract All.” On Mac, double-click it and it extracts automatically. On Linux, use your file manager or terminal to unzip it. The extracted folder contains everything you need: the main spreadsheet file, the supporting documents, and a folder full of video tutorials.

Step 3: Open the Main File (1 minute)

Inside the extracted folder, you’ll see a file called PubCommandCentre_Master.xlsx (or .ods if you use LibreOffice). Open this in Excel, Google Sheets, or your preferred spreadsheet app. You’ll see a dashboard immediately. It looks blank because you haven’t populated it yet. That’s normal. Don’t panic. Every single cell that needs data has a label telling you exactly what goes there.

Step 4: Enable Macros and Formulas (1 minute)

If you’re using Excel on Windows, you’ll see a yellow banner at the top saying “Macros have been disabled.” Click “Enable Content.” This allows the formulas and automated calculations to run. If you’re on Mac or using Google Sheets, this step is automatic. This is the only semi-technical moment in the entire setup, and it’s genuinely one click.

The system is now ready for data entry. You are not installing anything. You are not configuring servers. You are opening a file and entering information. That’s the entire “installation.”

Your First 30 Minutes: Initial Setup and Data Entry

Once the file is open, you’re walking through a guided setup sequence. The first sheet you see is called “Setup Wizard.” Follow it exactly as written. It’s structured to gather the minimum information needed to give you a working financial dashboard in under 30 minutes.

Section A: Your Pub Profile (3 minutes)

• Pub name and location
• Trading start date
• Number of staff members
• Number of covers per week (rough estimate is fine)
• Annual turnover estimate

These fields are used only for context and benchmarking. They don’t drive any calculations. If you get any of them slightly wrong, it doesn’t matter. You can change them anytime. I’d rather you start with rough numbers and refine them later than delay setup waiting for perfect information.

Section B: Opening Balances (8 minutes)

This is where you tell the system what you’re starting with. Pull out those bank statements you gathered earlier.

• Opening cash balance: The amount of physical cash in your till on the first day of your reporting period
• Bank account balance: Your current bank account balance
• Stock value: A rough estimate of your current drinks and food inventory (don’t agonise over this—£3,000–£8,000 is a reasonable range for most pubs)
• VAT owed or due: If you’re registered, put the amount you currently owe or are owed

These figures are critical because they form the baseline of your cash flow forecast. Get them as accurate as you can manage in two minutes per field. The system will track changes from this point forward.

Section C: Your Fixed Costs (12 minutes)

These are the costs that don’t change week to week: rent, mortgage, insurance, loan repayments, utilities (estimated), professional fees. Enter them once and the system calculates them every month automatically.

This is where SmartPubTools becomes genuinely valuable. Most pubs don’t track fixed costs properly because they’re not variable—they feel invisible. They’re not. They’re often the difference between a pub that looks profitable and one that actually is. At The Teal Farm, tracking fixed costs properly revealed that we were actually making £400 a month less profit than our P&L suggested, because we hadn’t accounted for quarterly insurance payments and annual subscriptions.

You don’t need exact figures. Estimates are fine. The system recalculates based on actual payments you log later, so this is just an initial forecast.

Section D: Your Key Products (7 minutes)

Enter your top 10–15 drink and food items: standard bitter, lager, wine, spirits, coffee, burgers, pies, whatever drives your turnover. For each one, enter the name, the unit cost to you, and the selling price.

The system automatically calculates your margin on each item. You’ll immediately see which products are actually profitable and which ones you’re nearly giving away. Most pub owners find this genuinely shocking. We had a wine that looked profitable at the glass price until we factored in the full bottle cost and waste—it was actually losing us money. Removing it from the menu added £140 a month to our bottom line.

You don’t need every product on day one. Add your top 15 now, add another 20 tomorrow. The system grows with your data.

After These Four Sections: You Have a Working Dashboard

The moment you complete those four sections, the dashboard becomes live. You can see:

• Your current cash position
• Your monthly profit forecast based on opening balances and fixed costs
• Your product margins ranked from best to worst
• A 12-week cash flow projection
• Your VAT liability forecast

This is what most pubs don’t have: a real-time, one-page view of their financial position. It took you 30 minutes to set up. From here, everything else is optional refinement.

Getting Your First Reports Running

After the initial setup, you have access to the reporting sheets. The most valuable report you’ll run first is the “Weekly Performance Summary”—it shows turnover, labour costs, product costs, and profit for the week that just ended. This one sheet answers the question “Did we make money last week?”

The Daily Takings Sheet

Every day, you (or whoever closes the till) enters:

• Cash in the till
• Card payments processed
• Total covers served
• Average spend per head

This takes two minutes. The system automatically logs it as a daily entry and rolls it into your weekly and monthly summaries. You don’t have to think about maths. You type four numbers, and the system tells you your daily profit margin, your cash position, and your trend against last week.

The Weekly Recon Sheet

Once a week—I do it Monday morning—you’ll count your physical cash, count your till float, and make sure the numbers match the system. Takes 10 minutes. If there’s a variance, the system flags it so you know where to look. Most pubs lose £50–£200 a week to untracked cash leaks. One pub in Birmingham found £140 a week in unrecorded bar sales just by running this check consistently.

The Labour Sheet

Enter your staff hours as they work them (or batch-enter them weekly from your scheduling app). The system calculates labour cost as a percentage of turnover, which is the single most important metric in pub management. RankFlow marketing tools can help you drive more covers, which naturally lowers your labour percentage—but you need this visibility first. If your labour cost is 35% of turnover and industry standard is 28%, the system shows you that immediately. You know it’s your biggest controllable cost and you can act on it.

Common Setup Issues and How to Solve Them

After working with hundreds of pub landlords setting up this system, I’ve seen the same obstacles come up repeatedly. Here’s how to handle them.

Issue: “I can’t find the download link in my email”

Check your spam folder first. Email providers are overzealous sometimes. If it’s not there, check the email address you used for purchase. If you still can’t find it, reply to the order confirmation email and ask for the link to be resent. Turnaround is usually under an hour.

Issue: “The file won’t open in Google Sheets”

Google Sheets and Excel are compatible but not perfectly. If the .xlsx file doesn’t open cleanly, download the .ods version instead (it’s included in your download package). Or upload the .xlsx file directly to Google Drive, right-click it, and select “Open With” > “Google Sheets.” Google will convert it automatically.

Issue: “Half the columns are showing numbers instead of dates”

This is a regional settings issue. Your computer is interpreting dates in the wrong format. Right-click the column, select “Format Cells,” and change the format to your local date convention. On a Mac, use the Format menu instead. This takes 30 seconds and fixes the entire column.

Issue: “The formulas aren’t calculating”

In Excel, you likely haven’t enabled macros (see Step 4 above). In Google Sheets, this shouldn’t happen—but if it does, download the Excel version and use that instead. Formulas work perfectly in both, but Excel is slightly more reliable for complex calculations.

Issue: “I’m not sure if my opening balances are right”

They don’t have to be perfect. The system is designed to adjust. Enter your best estimate, start logging daily takings, and let the actual data correct the forecast over the first two weeks. After 14 days of real numbers, your cash position and profit forecast will be accurate regardless of your opening estimates. Perfection on day one isn’t the goal—accuracy over time is.

Issue: “Can I set this up on multiple computers?”

Yes. You own the file. You can copy it to as many devices as you want. The only thing to remember: only one person should be editing it at a time. If your manager updates it at 2pm and you update it at 2:15pm, the later changes will overwrite the earlier ones. For a second copy, use cloud backup (OneDrive, Google Drive, Dropbox) and make sure you’re always working from the same synced version. Most pubs just keep it on one computer and have staff log data into a simple Google Form that the owner enters into the system once daily. That’s the safest approach.

For more information, visit RankFlow free trial.