This is an example shop with made-up numbers. Overwrite them with yours, or clear them.
Step 1: the basics
Monthly figures in pounds, from a typical month. The first four are needed. The rest sharpen the read. Profit here means what is left before your own pay and before tax.
A quick word on VAT
If you are VAT registered, leave VAT out of everything: sales without the VAT you collect, and costs without any VAT you claim back.
If you are not, use the amounts as they are. You do not charge VAT on sales, and you cannot claim it back on costs, so what you pay is what it costs you.
Either way, treat every figure the same way, so the picture adds up. Not sure? Ask your accountant.
Total takings in a typical month
Everything you pay for the premises each month. Enter 0 if you own it.
All staff pay including employer NI and pension. If you pay yourself a salary through the payroll, include it here, not in your own pay. Enter 0 if there are no staff.
Beans, milk, food, cups and packaging, including what you throw away (wastage and spillage). Not labour.
Everything else you pay out
Optional, but it shows what is actually left of every £1 you take, before corporation tax and income tax. Enter 0 if none.
Monthly. Bank or start-up loans, equipment finance, credit lines
Monthly. Utilities, insurance, software, repairs. Rates are in the rent box above.
Monthly. What you take out for yourself, such as drawings or dividends. Leave blank if it is already in your wages above, so it is not counted twice. It is not taken off your profit figure, but it is counted in cash and break-even.
How much you sell, and what
Optional, but it sharpens everything below. Order value turns the sales you need into customers a week. Your mix of sales sets the margin range you are judged against, because a coffee-led shop keeps more of each £1 than a food-led one.
What a typical customer spends per visit. Turns the sales you'd need into transactions a week.
Only if you know it from your till. It replaces the order value above.
Share of your sales from each. Aim for about 100% in total.
Sandwiches, lunch, hot food
Optional. Each step sharpens the read.
Step 2: cash and staffing
Business account balance today
Monthly. Card processing fees, delivery app commission. Not ingredients, which are above.
People on the rota
Total paid hours across the team
Turns break-even into a figure for each open day
Shows what the shop pays you per hour
Step 3: deeper detail
Itemised other costs replace the single "Everything else" figure in step 1. Put equipment finance in loan repayments.
Want more than a directional read?
This tool works from a handful of numbers you typed in. The health check goes further: we measure everything properly from your real till and accounts data, and you get advice built around your shop, not typical ranges. Have a chat with Chris and see if it fits.