Profitability

Restaurant Profit and Loss Template

Restaurant P&L Template
Works in Excel and Google Sheets

A restaurant P&L is read in percentages, not in money. Sales move with the season, so the figures that tell you whether the venue is healthy are food cost, labour and prime cost expressed as a share of sales — and the template calculates all three on every line.

Prime cost — food plus beverage plus total labour — is the number operators steer by, because it is the part of the P&L that moves daily and that management can actually change. Rent is fixed for years, and by the time it is a problem there is nothing to do about it this month. Prime cost can be worse in week two than week one, and you can act in week three.

Separate food from beverage. They behave differently: beverage carries a much better margin, so a venue with a strong bar can run a food cost that would sink a restaurant without one. Blended together, a drinks-led month hides a kitchen that has started over-portioning, and the one month where you could have caught it passes unnoticed.

Labour belongs in the same block as food, including the employer taxes and the casual shifts. A schedule that looks fine in hours can be expensive in money once overtime and shift premiums land, and the P&L is the only place where that shows up honestly. Track labour as a percentage of sales by period, not as a monthly total.

The reason most venue P&Ls arrive six weeks late is that the inputs live in a POS, a supplier inbox and a payroll file that nobody joins up until month end. Finmap pulls payments and categories together as they happen, so the percentages are available while the month can still be changed.

Restaurant P&L Template (Excel)