Food-cost report
The food-cost report answers one question per branch: between two counts, did the kitchen use more than the recipes say it should have? And of the difference, how much is waste someone recorded, and how much nobody can explain?
The report shows the difference; it doesn't decide why it happened, and it never changes a recipe or your stock.
Restaurant → Food cost. Open Food cost
Before you start
- Recipes. Theoretical usage comes from the recipes of the dishes you sold. See Recipes and food cost.
- Classify your categories as Food, Beverage or Other: Classify categories at the top of the page. A category you don't classify is reported on its own Unclassified line, never counted as food.
- Two food-cost counts, approved: one to open the period, one to close it.
Periods
On the Periods tab, choose a branch and New period, then pick the posted count that opens it. The period starts at that count's cutoff.
At the end of the period, choose Set closing count and pick the next posted count. The period ends at its cutoff. The next period can open on the same count.
Periods of one branch never overlap.
Read the report
Open a period's Report.
The totals
For Food, Beverage, Other, Unclassified and Total:
| Net sales | Paid restaurant orders in the period, without VAT, as in menu engineering. Retail sales aren't included. |
| Theoretical cost | What the dishes sold should have cost, by their recipes. |
| Recorded waste | Waste someone recorded, at its posted value. |
| Unexplained | The shortage the closing count found that nothing explains. |
| Theoretical % / Actual % | Theoretical cost and actual cost (theoretical + waste + unexplained) as a share of net sales. |
| Variance % | Waste + unexplained, as a share of net sales. |
Sales and theoretical cost follow the dish's category (a burger's beef is food because the burger is). Waste and unexplained shortage follow the ingredient's category.
The ingredients
Each ingredient has one row. Read it left to right:
Opening + Receipts + Transfers in − Transfers out + Production output − Production usage − Recipe consumption ± Other adjustments − Recorded waste − Other sales ± returns = Book, what the system expected on the shelf at the closing cutoff.
Then Closing count is what was there, and Unexplained = Book − Closing count: the shortage nobody can explain.
Example — beef in October, at Q 80/kg: opening 10 kg, received 20, sent 2 to another branch, 15 used by the burgers sold, 0.65 recorded as waste. The book is 12.35 kg; the closing count found 11.00 kg.
| Quantity | Value | |
|---|---|---|
| Theoretical usage | 15.00 kg | Q 1,200.00 |
| Recorded waste | 0.65 kg | Q 52.00 |
| Unexplained | 1.35 kg | Q 108.00 |
| Actual usage | 17.00 kg | Q 1,360.00 |
With Q 4,000 of net food sales, food reads 30.00 % theoretical and 34.00 % actual.
Ledger gap: if stock changed without a movement being recorded (for example someone edited a quantity by hand), the book and the movements disagree. The difference is shown here and the ingredient is marked, instead of being hidden in the unexplained figure.
Choose an ingredient's name to see the detail: each column with the documents behind it — the goods received note, the transfer, each waste record, the production run — and recipe consumption by dish: which dishes used it, how many sold, and how much they took.
Complete or incomplete
The Completeness banner says whether you can trust the figures, and why not when you can't. A number FlowPOS doesn't know shows —, never 0. Common reasons:
| Reason | What to do |
|---|---|
| No closing count | Set the closing count. Until then there is no actual usage. |
| Not counted / Counted once | The ingredient was used but missing from one or both counts. Add it to your count list. |
| Uncosted / Sales without a full cost | An ingredient has no cost, or a dish has no recipe. Fix it in Recipes; until then totals cover costed lines only. |
| Movements not in the ledger | See the ledger gap above. |
| Unclassified movement | A stock movement FlowPOS can't place. It's listed below the report. |
| Voided after payment – not prepared / Voids – preparation unknown | Their ingredients were taken out of stock but may never have been cooked. They are listed so you can judge the shortage. |
| Voided as prepared – no waste record | A prepared void that didn't become waste. Record it by hand. |
| Resale deduction began mid-period | Before this update, bottled drinks and other resale items didn't leave stock when an order was paid. A period that started earlier reads their sales as a shortage. |
Count coverage is the share of theoretical cost from ingredients counted at both ends; Cost coverage is the share that could be valued.
Close and reopen
When the figures are right, Close period. They are frozen as of that moment and the report shows Frozen · close 1. Later changes — a goods receipt dated inside the period, a reversed waste record — don't change the frozen figures: they appear under Late entries.
To correct a closed period, Reopen it with a reason, fix what's wrong, and close it again. Every close stays readable: choose it in Version.
Compare branches
The Compare tab lists, for the dates you choose, each branch's closed periods that end in those dates, side by side, each with its own start and end. The total adds up only the periods listed and shows Periods differ when their dates aren't the same. A branch with nothing closed shows No closed period.
Export
Export CSV downloads the report or an ingredient's detail. Unknown values are left empty, never 0. Every export is recorded in the activity log.
Who can do what
| See the report and export | Open, close and reopen periods | |
|---|---|---|
| Owner, administrator, store manager, inventory manager | ✓ | ✓ |
| Accountant | ✓ |
You only see the branches you are assigned to. Classifying categories needs an owner or administrator.