The Pub Operator's Weekly P&L Toolkit — Rooms Edition

Letting rooms are not free money, whatever the top line says.

Every stay carries costs the standard templates ignore: laundry, breakfast food and the wages to cook it, housekeeping, heating and hot water, toiletries, and the commission the booking sites quietly take. If you judge your rooms on revenue alone, you don't know whether they're making you money.

The Rooms Edition is everything in the standard toolkit — the Monday flash, weekly and monthly P&L, doors open cost, DIY VAT return, stock control, leakage flags, waste log, director's loan account — plus a proper accommodation operation:

True rooms profit — accommodation revenue minus its real direct costs, week by week. Not the flattering version.

Occupancy and average rate — enter your room count once and your room nights each week, and you get the two numbers every rooms operator lives by.

Utilities that track occupancy — set a cost per occupied room night and the rooms share of gas, electric and water calculates itself. No guessing, no retyping.

OTA commission in the open — watch what the booking sites take across a season, and see exactly what every direct booking through your own website is worth to your bottom line.

Voucher deals kept honest — running a winter Groupon with a free welcome drink? Commission and giveaways get their own columns, and giveaway cost moves out of your wet GP into promotions, so deal season doesn't make your cellar look leaky and you see what the deal really cost before you run it again.

Built by an operator with 18 years running a multi award winning gastropub. Priced at less than one night's room revenue.

Works in Excel or free LibreOffice. No subscription, ever. Formulas protected, full plain English guide included.