Financial - Model Gross Profit
Updated Mon 26 Oct 2026
Running the report
Report options
Choose your opening stock take
The stock take that starts the period. The list shows your posted stock takes from the last 120 days, newest first, with the type in brackets: spot, monthly, yearly, opening or weekly. Spot stock takes can be used for this report. Your most recent stock take is not offered here, because there would be nothing after it to compare it with.
Choose your closing stock take
The stock take that ends the period. It must be later than your opening stock take. The list works the same way as the opening list.
Expand all categories for a detailed view
Ticked (the default) opens every category so you see all of its items straight away. Untick it to see your stock list with every category closed, one line per category. You can always open or close a single category by clicking its + or -. Your last choice is remembered.
On the report options screen there is also an Explainer video, the same video as in Watch the video.
The report at a glance
The two dates are the exact times your opening and closing stock takes were counted, not trading days. Sales are measured between those two moments, so they can differ slightly from a sales report that ends each day at midnight (or at your close of trade).
- The summary card: your two stock takes, the currency and a reminder of how the report works.
- Your stock by category: every food cost stock item with its model cost of sales.
- GP breakdown: net sales, model cost of sales, gross profit and the food cost and gross profit percentages.
- Sales breakdown: gross sales down to turnover.
- Items without model costs: stock items the brand has not priced yet, shown only when there are any.
- Invoice list: the sales behind the turnover figures, opened by clicking a turnover figure.
The summary card
The top of the first page sums up the period before you get to the stock list.
Your two stock takes
One card for the Opening stock take and one for the Closing stock take. Each shows its type (for example Spot or Weekly), its status, when it was counted and by whom, when it was posted and by whom, and any note left on it. A stock take that has been archived is shown in red.
Currency
Currency shows your currency symbol and reminds you that cents have been rounded. Figures on the report are rounded to whole amounts to keep it readable. Hover over a figure to see the exact amount.
How the report works
A short note on the card explains that the report uses the brand's model costs and model wastage percentages for each stock item, multiplied by the recipes of the products sold, and that it can be run even if the store has captured no goods received vouchers, transfers, manufacturing or discards.
Your stock by category
Below the summary, every stock item with the stock type Food cost is listed under its category. Click a category's + or - to open or close it. Each line shows one figure: the Model cost of sales, which is the Theoretical cost of the stock your sales should have used, priced at the brand's model prices.
| Category Item name (PLU) | Theoretical Model cost of sales |
|---|---|
| − Bakery 1 | 5 400 |
| Brioche bun (1010) 2 | 5 400 |
| Sesame seeds (1011) | No recipes 3 |
| + Dairy | 2 900 |
| − Meat | 14 300 |
| Beef patty 150g (1001) | 8 400 |
| Streaky bacon (1002) | 2 100 |
| Chicken fillet (1003) | 3 800 |
| + Produce | 5 000 |
| Totals: | 27 600 |
The gross profit calculation is continued on the next page.
1 Categories
A category's figure is the total of its items. With Expand all categories for a detailed view unticked you see one line per category. The Totals line at the bottom adds every category.
2 Items
Each item is shown with its name and PLU (item code) in brackets. Click the item name to open its stock item audit, which lists every movement of that item. Click the underlined figure to see which menu items you sold and the recipes behind it. Hover over the figure to see the units used, the model price per unit and the resulting model cost of sales.
3 No recipes
If an item is not used in any recipe, the report cannot work out how much of it your sales used, so it shows No recipes in red and adds nothing to your model cost of sales. Add the item to a recipe where it belongs and it will start to count.
GP breakdown
On the next page the report works out your model gross profit: what you sold, less what that stock should have cost at the brand's model prices.
| GP breakdown | Theor |
|---|---|
| Net sales (excl) | 92 000 |
| - Cost of sales 1 | 27 600 |
| = Gross profit 2 | 64 400 |
| Net sales FC % 3 | 30.00% |
| Net sales GP % 3 | 70.00% |
| Gross sales FC % 4 | 28.16% |
1 Cost of sales
The Totals from your stock list: the model cost of the stock your sales should have used.
2 Gross profit
Net sales (excl) less the cost of sales. It is worked out before tax. Because it uses model prices, it is the gross profit you would make if every item had been bought at the brand's model price and nothing had gone to waste beyond the model wastage.
3 Net sales FC % and GP %
Food cost (FC) is the cost of sales as a percentage of net sales, and GP % is the gross profit as a percentage of net sales. Both move when your discounts change. Hover over the small icons next to them for a short explanation.
4 Gross sales FC %
The same food cost measured against gross sales, before discounts. It is not affected by discounts, so a change in it comes from your stock and menu rather than from the discounts you give.
Sales breakdown
Next to the GP breakdown, the sales made between your two stock takes are shown excluding tax and including tax. Voided sales are left out.
| Sales breakdown | Excl | Incl |
|---|---|---|
| Gross sales | 98 000 | 112 700 |
| - Discounts | 6 000 | 6 900 |
| = Net sales 1 | 92 000 | 105 800 |
| + Delivery charges 2 | 4 000 | 4 600 |
| = Turnover 3 | 96 000 | 110 400 |
1 Net sales
Gross sales is what your menu items sold for before discounts. Net sales is gross sales less discounts. Net sales (excl) is the figure your gross profit is built on.
2 Delivery charges
Delivery charges are added back after net sales. They are not part of net sales, because they are not stock you sold.
3 Turnover
Net sales plus delivery charges. The turnover figures are underlined: click one to open the invoice list behind the totals.
A note under the table reminds you that these are the sales between the exact times of your two stock takes, which may differ from your sales reports that end each day at midnight or at your close of trade.
Items without model costs
If some of your food cost stock items have no model cost yet, the report cannot price them, so your model cost of sales may be too low. When that happens, a list is printed after the GP breakdown, headed by this message: The following stock items do not have model costs yet. This may cause the report to be showing an incorrect Cost Of Sales. Please give all Food Cost stock items correct model prices in the portal's brand stock list. If every item has a model cost, this list does not appear.
| Stock items without model costs |
|---|
| Pantry - Truffle oil (2001) - l |
| Produce - Micro herbs (2005) - kg |
Each line shows the category, the item name and PLU, and the unit of measure. Model costs are set by your brand, in the brand stock list in the portal, so ask your head office to price the items on this list.
Invoice list
Click a Turnover figure to open the list of sales behind it. It lists every sale (not voided) between your opening and closing stock take times, with an invoice on each row and the five sales stages from Sales breakdown in three columns each: excl, tax and incl. Click an invoice number to see all the details of that invoice.
| Invoice number | Gross sales | -Discounts | =Net sales | +Delivery charges | =Turnover | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| excl | tax | incl | excl | tax | incl | excl | tax | incl | excl | tax | incl | excl | tax | incl | |
| 20431 | 300.00 | 45.00 | 345.00 | 0.00 | 0.00 | 0.00 | 300.00 | 45.00 | 345.00 | 0.00 | 0.00 | 0.00 | 300.00 | 45.00 | 345.00 |
| 20432 | 400.00 | 60.00 | 460.00 | 40.00 | 6.00 | 46.00 | 360.00 | 54.00 | 414.00 | 60.00 | 9.00 | 69.00 | 420.00 | 63.00 | 483.00 |
| 20433 | 200.00 | 30.00 | 230.00 | 20.00 | 3.00 | 23.00 | 180.00 | 27.00 | 207.00 | 0.00 | 0.00 | 0.00 | 180.00 | 27.00 | 207.00 |
| Total: | 900 | 135 | 1 035 | 60 | 9 | 69 | 840 | 126 | 966 | 60 | 9 | 69 | 900 | 135 | 1 035 |
Totals are rounded to whole amounts to save space. Hover over a total to see the exact amount.
Comparing with your Gross Profit report
This report and the Gross Profit report both work out a theoretical gross profit from your sales and your recipes. The difference is the prices: this report uses the brand's model unit costs, while the Gross Profit report uses the prices your store actually paid.
That means you can compare the two. Put this report's gross profit next to the Theor gross profit on your Gross Profit report for the same period.
- If the two match, you are paying the brand's model prices.
- If they differ, the difference comes from the prices you paid for stock. Run the Purchases and Returns report for the same period to see which items you are paying the wrong price for.
Watch the video
A short walkthrough of the Model Gross Profit report: how to pick your stock takes and how to read the stock list and the GP breakdown.
Can't see the video? Watch it on YouTube.
Frequently asked questions
Why is the gross profit on this report different from the Theoretical gross profit on my Gross Profit report?
This report prices your stock at the brand's model unit costs, while the Gross Profit report uses the prices your store actually paid. Both multiply by the same sales mix and recipes, so any difference comes from the prices you paid. Run the Purchases and Returns report for the same period to see which items you are paying the wrong price for.
Can I run this report between spot stock takes?
Yes. The report never works out what you actually used, so it does not need full stock takes. The two stock takes only mark the start and the end of the period. You can use spot, weekly or monthly stock takes.
Why doesn't this report show stock losses or a score?
Stock losses come from comparing what you actually used with what you should have used. This report only shows what you should have used, priced at the brand's model prices, so there is nothing to compare and no loss or score to show. Use the Gross Profit report for losses and your score.
What does No recipes mean next to an item?
The item is not used in any recipe, so the report cannot work out how much of it your sales used. It adds nothing to your model cost of sales. Add the item to a recipe where it belongs to include it.
Why is there a list of stock items without model costs?
Those items have no model cost, so the report cannot price them and your cost of sales may be too low. Ask your brand's head office to enter model prices for them in the brand stock list in the portal. Once they are priced, the list disappears.
Why don't the sales here match my sales report?
This report measures sales between the exact times of your two stock takes, not whole trading days. Voided sales are left out, and delivery charges are shown separately from net sales. Your daily sales reports end each day at midnight or at your close of trade, so the two can differ slightly.
Does the report include wastage?
It uses the brand's model wastage percentage for each stock item, not what your store actually wasted. It does not use your discards or voids.
Why is an item I know we use missing from the list?
Only stock items with the stock type Food cost are listed. Items with another stock type are not part of this report.
Glossary
- Cost of sales (COS)
- The cost of the stock behind the items you sold. Also called food cost.
- Delivery charges
- What you charged customers for delivery. They are not part of net sales.
- Drill-down
- An underlined figure, heading or name that you can click to dig deeper.
- FC %
- Food cost percentage: cost of sales as a percentage of sales.
- Food cost
- The stock type of the items this report covers. Items with any other stock type are left out.
- Gross profit (GP)
- Net sales less cost of sales.
- Gross sales
- What your menu items sold for before discounts.
- Model cost
- The unit cost your brand has set for a stock item. This report uses it instead of the price you actually paid.
- Model cost of sales
- What your sales should have cost, using the brand's model unit costs and model wastage percentages and your recipes.
- Model wastage percentage
- The allowance for wastage that your brand has set for a stock item.
- Net sales
- Gross sales less discounts.
- Sales mix
- What your store actually sold between the two stock takes: which menu items and how many of each.
- Spot stock take
- A quick count of a few items, as often as you like. You can run this report between spot stock takes.
- Stock take
- A count of the stock you have on hand at a point in time. In this report it only marks the start or the end of the period.
- Theoretical
- What should have happened if every portion was made exactly to its recipe. In this report it is always priced at the brand's model costs.
- Turnover
- Net sales plus delivery charges.