Café Weekly Numbers: sales vs target, labour % and GP (UK)

Did last week hit target? Cafe Weekly Numbers puts sales against target, labour % and GP % for your café, kiosk or takeaway on one page, with an on target, close or off target flag on each.

Type in your till takings, delivery app sales, rota hours, purchases and stock count. The sheet works out sales without VAT, labour cost from each person's hourly rate, food and packaging used from your stock movement, and your GP %.

Included:

• Settings: targets, opening hours, VAT registered or not, delivery app treatment (net of commission, or gross with your commission %), up to 10 staff with hourly rates and an optional on-cost %
• Daily sales: takings, card and cash, app sales, transactions, average spend, hour bands
• Rota and hours: planned against actual, per person per day
• Food cost: purchases, opening and closing stock, real food cost % and GP %
• Weekly dashboard: sales, labour and GP against target, best and weakest day, chart
• 52-week tracker: every week, against the same week last year, and year to date

Two .xlsx files come in the download: an example kiosk (£5,000 weekly target, four staff, all figures made up) and a blank copy. Works in Excel 2016 or later and Google Sheets. No macros.

VAT rate 20%, checked on gov.uk on 7 November 2026. A management view of your week, not accounting, tax or payroll advice. Rates and targets are typed by you.