Multi Site & Franchise Comparison Tracker Spreadsheet
This spreadsheet puts your sites side by side on the same six cost lines and prices what the difference between the best and the worst is worth.
Six shops, one profit and loss account and one percentage at the bottom tells you the group is fine. It does not tell you that one site is running at nearly a quarter and another at under seven per cent, or what the difference between them would be worth if you closed it.
What is in it
- Sites — 20 rows: manager, opening date, floor area, hours open.
- Monthly Figures — 600 rows, one per site per month, six numbers each.
- By Site — the percentages, plus sales per square foot and per hour open.
- The Gap To Best — every cost line taken at the best percentage anybody in the group achieved and applied to everybody else’s sales.
- Overview — the whole group on one screen.
- Start Here and Setup: three lines you want every site to hit.
Who it is for
Anyone running more than one branch, and franchisors and franchisees comparing units. Twenty sites and six hundred monthly rows is twenty sites for two and a half years. The six columns are sales, cost of sales, labour, rent, utilities and other — the same six lines already on every management account you get — so nothing here needs a new system. Head office is deliberately left out, because site profit is what the branch made before head office, marketing, finance and tax.
The worked example
The worked group has 6 sites, $3,027,797 of sales and $540,967 of site profit — 17.9% — and not one of the six actually trades at 17.9%. The best site runs at 24.7% and the worst at 6.8%, a spread of 17.9 points.
Priced out, the controllable gap to best is $218,929, or 7.2% of group sales, and the lease gap of $92,661 is kept separate on purpose. If every site matched the best on every line, group profit would be $759,896 — a rise of 40.5%. Rent is why: the busiest floor in the group does $745 of sales per square foot and still returns only 9.7%, because 13.6% of everything it takes goes to the landlord.
How it works
Compatible with Microsoft Excel 2016 or newer on Windows or Mac, Google Sheets, and LibreOffice. No macros, no add-ons, no account to create, nothing to install.
The download has two workbooks: one with the example above already filled in, so you can see what every column expects, and the same file completely blank for your own figures. A plain-English guide comes as a PDF. WhatsApp’tan sipariş ver — $9
Orders are taken on WhatsApp: message me and I’ll send the payment details, then the files as soon as the payment is confirmed.
A look inside the file
Questions people actually ask
How do I compare my branches properly instead of looking at one group figure?
You put six numbers per site per month — sales, cost of sales, labour, rent, utilities and other — and the file shows each site's percentages side by side plus sales per square foot and per hour open. In the worked year six sites took $3,027,797 and made $540,967 of site profit, 17.9% of sales, but the best site ran at 24.7% and the worst at 6.8%: a 17.9 point spread, and not one of the six actually trades at the group average. It then takes the best percentage anybody achieved on each cost line and applies it to everybody else's sales, which puts the controllable gap at $218,929, or 7.2% of group sales.
Does it work for a franchise?
Yes, and for any owner with more than one branch — twenty sites and six hundred monthly rows, which is twenty sites for two and a half years. Rent is shown but kept out of the controllable total, because it is the only line a site manager can do nothing about and mixing it in makes every other comparison a lie. In the worked group the busiest floor does $745 of sales per square foot, the best in the group, yet returns 9.7% because 13.6% of what it takes goes to the landlord: that site is not badly run, it is badly leased.
Where do I get the figures, and will a year do instead of monthly?
The six columns are already on every management account you get, so nothing here needs a new system — it needs the same six numbers put side by side instead of added together. A year works; monthly is better, because it shows you which site's problem is seasonal and which one's is permanent. If your cost lines are named differently, rename them and use whatever those six mean in your trade.
Does it work in Google Sheets or do I need Excel?
Both — it is built as .xlsx for Excel 2016 or newer on Windows or Mac, and it loads into Google Sheets through File then Import then Upload. LibreOffice opens it too. No macros, no add-ons, no account to create, nothing to install and no subscription: you download the file and it is yours.
Is head office in the figures, and is this an accounting system?
Head office is deliberately not in the figures — site profit here is what the shop made before head office, marketing, finance and tax, which is what a site comparison should measure. It is not an accounting or bookkeeping system, not a rota, till or stock package and not a consolidation for statutory accounts. Nothing syncs and nothing logs in, and I never ask for a password, your bank or your accounts.
Need it built around your business?
This file assumes sites reporting the same six lines every month: sales, cost of sales, labour, rent, utilities and other. If yours works differently — franchisees paying a royalty and a marketing levy before you ever see a profit figure, branches on different tax or VAT treatments, or a group where three units share one kitchen and one wage bill — I can build the same site-by-site comparison around the way your group is actually structured.
All other templates are listed on the Excel & Google Sheets Templates page.