Your Cart
Loading

The Pub Operator's Weekly P&L Toolkit

On Sale
£39.00
£39.00
Added to cart

Do you know what your pub costs every single day, before you pull a pint?

Most licensees don't. I didn't either, until I worked it out properly, and that number changed how I ran my pub for the next 18 years.

Your accounting software tells your accountant what happened months ago. This tells you what's happening this week.

Ten tabs. Twenty minutes a week. You type into the yellow cells, the sheet does the rest.

The Monday Morning Flash — sales against last week and last year, covers, spend per head, wet and dry split, both GPs and labour percentage, anything off target flagged red.

Weekly and monthly P&L — full profit and loss every week, and a monthly view that smooths the lumpy bills so one heavy week never knocks your confidence in the numbers.

Stocktakes the way pubs actually do them — a five minute weekly count of kegs and meat, a full detailed count monthly. Closing figures only, the sheet carries everything forward. Nobody pretends you'll tenth a bottle of gin every Tuesday.

Your doors open cost — every fixed cost itemised in one place: rent or mortgage, rates, insurance, licences, Sky, music licences, waste, contracts, loans, the lot. Then the three numbers most operators have never seen: what your pub costs per year, per week and per day before you sell a thing, and the break even sales you need just to stand still.

Do your own VAT return — an invoice register with dropdown categories feeds all 9 boxes, ready for MTD bridging software. If you pay a bookkeeper to prepare your VAT, this pays for itself in a quarter.

Is someone stealing from you? — stock variance flags compare what your usage should have earned against what the till actually took. Recorded waste is excluded automatically, so when the flag turns red it's showing genuinely unexplained loss. It won't catch the thief. It will show you the hole.

Waste log — chalk it up as it happens, wet or food, and the weekly totals feed everything automatically. A kitchen that writes its waste down wastes less.

Director's loan account — every purchase on your personal card tracked and totalled, so the business pays you back and your accountant gets a clean record at year end.

What it is not: it isn't accounting software, and I won't pretend otherwise. If you want bank feeds, payroll and statutory accounts, get Xero and a good accountant. This is the management information layer they don't give you. Plenty of operators run both.

What you need: Excel or free LibreOffice. No subscription, no monthly fee, ever. Formulas protected. Full plain English guide included.

Who wrote it: I bought, ran and sold a multi award winning gastropub over 18 years, and now run a food manufacturing business supplying the hospitality trade. Every line in these sheets exists because of a lesson that cost me money to learn.

Price does not include VAT. VAT receipt provided for trade buyers.

Not sure yet? Download Pub P&L Lite free and see how you get on.

You will get the following files:
  • PDF (14KB)
  • XLSX (75KB)