Add a raw material
Everything else is priced from this list. Enter the rate in the unit you buy in — kilos, litres or pieces. Recipes can still be written in grams or millilitres.
Raw material list
| Code | Material | Category | Unit | Rate | Used in |
|---|
Menu item recipes
A recipe is the standard quantity of each raw material that one portion of a menu item should use. This is what turns your sales figures into consumption.
| Code | Menu item | Ingredients | Cost / portion | Selling price | Food cost % |
|---|
Record item sales
Enter the quantity sold of each menu item. You can also bring a whole month in from Excel on the last tab.
Sales entries
| Date | Menu item | Qty sold | Revenue | Recipe cost |
|---|
Production batches
For packed food. Enter the raw materials that went into one production run and how much finished good came out of it — the tool works back to the cost of a single pack.
| Batch | Date | Finished good | Output | Material cost | Other cost | Total cost | Cost / unit |
|---|
Reporting period
Leave the dates blank to include every sales entry.
to
Menu item profitability
What each dish sold, what it cost you in raw materials, and what it left behind.
| Menu item | Sold | Cost / portion | Price | Total cost | Revenue | Margin | Food cost % |
|---|
Raw material consumption & variance
The theoretical column is what your recipes say should have been used. Type in what the store actually issued and the difference shows up as pilferage, over-portioning or wastage.
Theoretical
Actual issued
Excess over theoretical
| Material | Unit | Theoretical qty | Theoretical value | Actual qty | Variance qty | Variance value | Comparison |
|---|
Finished goods costing
Every production run, and what one unit of output cost to make.
| Finished good | Batches | Total output | Material cost | Other cost | Total cost | Avg cost / unit |
|---|
Bring entries in from Excel
Download the template, fill the sheets you need, then upload the same file back. Sheets you leave empty are ignored.
- — it has four sheets with the column headings already in place and a filled example row.
- Delete the example rows and enter your own data. Keep the headings exactly as they are.
- Upload the file below. Existing entries are kept; new ones are added on top.
Material codes tie everything together. A recipe or batch row must use a code that already exists on the
Materials sheet, or that you are importing in the same file.Drop your Excel file here
.xlsx, .xls or .csv
Backup and settings
Your data is stored in this browser on this device. Take a backup file regularly, and to move to another computer just restore it there.