The Coffee Numbers · Shop snapshot · thecoffeenumbers.com

BETA

This tool is in beta. We are testing it with real shop owners, so expect rough edges and results that change as we improve it. Tell us what worked and what did not.

Free tool · Beta

Shop snapshot

Put in a few numbers from a typical month. You get a straight read on where the money is going, and what it would take to fix it.

Not sure what you will get?

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.

£
£
£
£
£
How this is worked out

Your main measure is net margin: what is left of every £1 of sales after rent, wages, ingredients and your other costs, before your own pay and before tax. Each number is turned into low, in range or high first, using whole percentages so what you see is what is judged. A story is picked from the pattern across all of them, never from one number alone. The ranges are provisional: they come from UK coffee-shop consultancies and accountants, not an official dataset, so treat them as a guide. "What it takes" aims at an 8% net margin, the middle of the typical range.

SignalLowIn rangeHigh
Net margin (before your pay and tax)under 5%5-12%over 12%
Rent, rates and service charge % of salesunder 8%8-12%over 12% (a warning from 15%)
Wages % of salesunder 28%28-35%over 35%
Ingredients plus wages (prime cost) % of salesn/aunder 65%over 65%
Gross margin (no sales mix given)under 65%65-75%over 75%

If you give your sales mix, the gross margin range is blended from typical margins for each part of the menu: coffee and drinks 72-80%, baked goods 60-70%, food 55-65%. Prime cost (wages plus ingredients) is treated as a ceiling, not a range: a common rule of thumb is to keep it under about 65% of sales. It is not the sum of the wages and margin ranges, because very few shops sit at the top of both at once.

StoryFires when
Squeezednet margin low, with two or more of rent high, wages high, margin low
Rent heavynet margin low or thin, rent high, wages and margin fine
Wages heavynet margin low or thin, wages high, rent and margin fine
Giving margin awaynet margin low or thin, gross margin low, rent and wages fine
Costs eat the restrent, wages and margin all look fine, but not enough is left once loans and other costs are in
Nothing stands outnet margin in a healthy range and no single cost out of range

Sources: Sage (UK), Epos Now (UK), efinancialmodels, Zest Coffee, United Baristas, and gov.uk minimum wage rates for the pay check. These are trade guides, not an official dataset, so the ranges are provisional.