Metrics and profitability

A weekly P&L for restaurants: the Monday flash report

Build a one-page weekly P&L for a UK restaurant or pub every Monday: sales, food and drink cost, full labour cost, overheads and cash, with an example.

Ava research teamPublished 7 min read

On this page
  1. Why a weekly P&L, when the accountant does a monthly one
  2. What goes on the page
  3. Set the sheet up once
  4. Food and drink cost: count stock, do not add up invoices
  5. Labour: the full cost, not the hourly rate
  6. Example: a 70-cover neighbourhood bistro
  7. The 45-minute Monday routine
  8. Reading the numbers: when to act
  9. Waste: the line most venues never record
  10. Frequently asked questions
  11. References

Key takeaways

  • A weekly flash P&L is an estimate you can trust within a point or two, ready by Monday lunchtime, not a set of accounts.
  • Food and drink cost must come from stock counts, not invoices, or the number swings with delivery days.
  • Labour on the page is the full cost: wages plus employer National Insurance at 15% above the secondary threshold[1], holiday accrual and pension.
  • Labour and material costs are each named as a top challenge to turnover by almost four in ten accommodation and food businesses[2], so these are the lines to watch weekly.

Why a weekly P&L, when the accountant does a monthly one

Monthly management accounts usually arrive two to four weeks after the month ends. By then a bad rota or a creeping portion size has cost you six weeks of margin. A flash P&L is a one-page estimate of last week's profit that you build yourself every Monday from the till, the stock count and the rota. It will never match the accountant to the penny, and it does not need to. It needs to be consistent, so that a change from one week to the next is real.

The pressure on the cost lines is the reason to do it. In October 2026, economic uncertainty, labour costs and material costs were the three most common challenges to turnover reported by UK accommodation and food businesses, each named by close to four in ten of them[2].

Top challenges to turnover, UK accommodation and food businesses, October 2026Share of businesses naming each challenge (ONS Business Insights and Conditions Survey).
Top challenges to turnover, UK accommodation and food businesses, October 2026Bar chart. Economic uncertainty: 39.8%; Labour costs: 39%; Material costs: 38.5%.Economic uncertaintyEconomic uncertainty: 39.8%39.8%Labour costsLabour costs: 39%39%Material costsMaterial costs: 38.5%38.5%Top challenges to turnover, UK accommodation and food businesses, October 2026Bar chart. Economic uncertainty: 39.8%; Labour costs: 39%; Material costs: 38.5%.Economic uncertaintyEconomic uncertainty: 39.8%39.8%Labour costsLabour costs: 39%39%Material costsMaterial costs: 38.5%38.5%

Source: Office for National Statistics, 2026[2]

Show the data
ItemValue
Economic uncertainty39.8%
Labour costs39%
Material costs38.5%

Cash is the other reason. One in five accommodation and food businesses said they had no cash reserves in October 2026, and a further 13.2% had less than a month's worth[2]. If that describes you, a weekly view of profit is the earliest warning you will get.

What goes on the page

Keep it to eight lines. Every extra line is another number to chase on a Monday morning, and the report only works if it is finished before lunch.

The eight lines of a one-page weekly P&L, and how to source each one.
LineWhere the number comes fromCheck before you trust it
Net salesTill or EPOS Z reports, excluding VAT, tips and any service charge passed to staffVoids, refunds and comps reviewed; delivery app sales added at net of VAT
Food costOpening stock + purchases - closing stockStock counted the same day and time each week
Drink costSame method, bar stock onlyCellar and back bar counted, not just the bar
LabourRota actuals from clock-in dataIncludes employer NI, holiday accrual, pension and agency staff
ControllablesEnergy, cleaning, smallwares, repairs, card fees, marketingEnergy from meter readings, not the last bill
Fixed costsRent, rates, insurance, licences, loans: one 52nd of the annual figureUpdated when a bill or rateable value changes
Flash profitNet sales minus all of the aboveCompared with last week and the four-week average
Cash positionBank balance plus card takings in transit, minus bills due in 14 daysIncludes the next VAT and PAYE payments

Set the sheet up once

Most of the work is in the first week. After that the report is mostly typing in four exports and one count. Before your first Monday, settle these points and write them on the front tab so anyone covering for you uses the same rules.

  • Your trading week: pick Monday to Sunday or Tuesday to Monday and never change it, or week-on-week comparisons break.
  • Your fixed weekly overhead figure: add up rent, business rates, insurance, licences, loan repayments and software for the year and divide by 52.
  • Who counts stock and when, with a deputy for holidays.
  • Which sales count as food and which as drink, especially set menus and packages that include a drink; split them by a fixed rule.
  • A threshold for comps and voids that must be explained, for example anything above a set amount on one bill.
  • Where the report is saved and who receives it each Monday.

Food and drink cost: count stock, do not add up invoices

The most common error in home-made P&Ls is treating the week's invoices as the week's food cost. If the meat delivery lands on a Monday one week and a Saturday the next, your food percentage jumps around for no reason. Cost of sales is what you used, not what you bought.

  1. Count closing stock at the same point every week, for example after Sunday close, using a fixed count sheet in shelf order.
  2. Value it at latest invoice price per unit. Do not guess values for prepared items; cost them from the recipe.
  3. Food cost = opening stock + purchases received in the week - credits - closing stock. Do the same for drink separately.
  4. Subtract staff meals and any transfers from kitchen to bar, and record them on their own line so they stay visible.
  5. Divide by net food sales (or net drink sales) for the percentage. Do not divide food cost by total sales.

If a full count every week is too much, count the top 30 lines by value weekly and do a full count monthly. The top lines are usually most of the money.

Labour: the full cost, not the hourly rate

Labour on a flash P&L should be what the hours really cost you. Start with actual hours from clock-in data, not the planned rota, multiplied by each person's rate. From April 2026 the National Living Wage for workers aged 21 and over is £12.71 an hour[3]. Then add the extras.

  • Employer National Insurance: 15% of earnings above the secondary threshold[1], which is £96 a week in 2026 to 2027[4]. Apply it per employee, not to the total wage bill, or you will overstate it for part-timers.
  • Holiday accrual: most workers are entitled to 5.6 weeks of paid leave a year[5]. A simple accrual for hourly staff is 5.6 divided by 46.4 working weeks, about 12.07% of pay for hours worked.
  • Employer pension contributions for staff who are enrolled.
  • Agency staff and freelance chefs at their invoiced cost, in the week they worked.
  • Salaried managers at one 52nd of their annual cost including NI and pension.

Tips and service charge passed to staff are neither sales nor labour cost on this report. Keep them off both lines so your percentages are not distorted.

Example: a 70-cover neighbourhood bistro

Example (fictional figures). A 70-cover bistro in a market town closes the week with these numbers. The owner compares each line with the four-week average rather than with a target from a book.

Example: one week's flash P&L for a fictional bistro, before interest, tax and depreciation.
LineThis week% of net salesFour-week average %
Net sales£18,400100%100%
Food cost£4,05022.0%20.6%
Drink cost£1,2907.0%7.1%
Labour (full cost)£6,07033.0%33.4%
Controllables£1,5608.5%8.2%
Fixed costs£2,76015.0%15.4%
Flash profit£2,67014.5%15.3%

In this Example the headline profit looks fine, but food cost is 1.4 points above its four-week average. On £18,400 of sales that is roughly £260 in one week. The owner checks the count sheet first (a missed shelf is the usual cause), then the price of the top five ingredients on the latest invoices, then portioning on the two best-selling dishes.

The 45-minute Monday routine

  1. Pull sales (10 minutes)

    Export last week's net sales by day and by food and drink. Add delivery platform sales net of VAT. Note any voids or comps above your threshold.

  2. Enter the stock counts (10 minutes)

    Type the Sunday-night food and drink counts into your sheet. It should value them automatically from the latest prices.

  3. Add purchases and credits (5 minutes)

    Total the week's delivered invoices and credit notes by supplier. Chase any delivery with no invoice so it is not missed.

  4. Add labour (10 minutes)

    Export actual hours from your clock-in system, apply rates and on-costs, and add agency invoices.

  5. Add overheads and cash (5 minutes)

    Fixed costs are a set weekly figure. Read the energy meters, check the bank and list bills due in the next 14 days.

  6. Write three lines (5 minutes)

    What moved, why you think it moved, and what you will do this week. Share it with the head chef and the general manager.

Reading the numbers: when to act

A weekly report invites overreaction. Set rules in advance so one wet Saturday does not trigger a menu rewrite.

  • Food or drink cost more than one point above the four-week average for two weeks running: recount, then check prices, portions and waste in that order.
  • Labour percentage up while sales are flat: compare actual hours with the planned rota by day part; the gap is usually on quiet shifts.
  • Controllables rising: read the energy meters daily for a week to see whether the rise is in opening hours or overnight.
  • Flash profit below the four-week average for three weeks: book a full review of menu prices and the rota with your accountant.
  • Cash position below two weeks of fixed costs and wages: talk to your bank and HMRC before payments fall due, not after.

Waste: the line most venues never record

Hospitality and food service produces about 1.1 million tonnes of food waste a year, around 11% of the UK total[6]. The edible part of that was valued at £3.21 billion at 2021 prices[6]. On a flash P&L, waste hides inside food cost. A simple waste sheet by the pass, filled in at the end of each service with item, weight and reason, lets you split the food cost variance into waste and everything else.

Once you have a few weeks of the sheet, compare the waste total with the gap between your actual and theoretical food cost. If waste explains most of it, fix prep quantities and ordering. If it explains little, look at portions, unrecorded staff food and theft.

Frequently asked questions

Should food cost on a weekly P&L include VAT?

No. Use purchase costs excluding reclaimable VAT and net sales excluding output VAT, so both sides of the percentage are on the same basis. If you are not VAT-registered, use gross purchase costs and gross sales.

How accurate does a flash P&L need to be?

Within a point or two of the month-end accounts is good enough. What matters is that you use the same method every week so that movements are real. Reconcile it with the management accounts each month and adjust your method if there is a consistent gap.

Do I need special software?

No. A spreadsheet with a stock count tab, a purchases tab and a labour tab works well for a single site. Many EPOS and rota systems export the sales and hours you need; the stock count is the part that has to be done by hand.

Where do delivery app commissions go?

Record delivery sales at their full menu value net of VAT and put commission and fees under controllables, so you can see the true cost of the channel rather than a smaller sales figure.

References

  1. ICAEW Library & Information Service (2025). Hospitality: industry profile (opens in a new tab) ↑

  2. Office for National Statistics (2026). Business insights and impact on the UK economy, wave 166 dataset (opens in a new tab) ↑

  3. GOV.UK (2026). National Minimum Wage and National Living Wage rates (opens in a new tab) ↑

  4. HM Revenue & Customs (2026). Rates and thresholds for employers 2026 to 2027 (opens in a new tab) ↑

  5. GOV.UK (2026). Holiday entitlement (opens in a new tab) ↑

  6. WRAP (2025). UK Food Waste & Food Surplus: Key Facts (updated July 2025) (opens in a new tab) ↑

Book a demo

See Ava handle your calls.

Book a short demo. We’ll walk through your calls and workflow, and agree what Ava should take care of.

Book a demo