Food traceability/Food margin analysis

Restaurant food cost calculator: stock, transfers and sales

Calculate period food cost and gross food margin from counted stock, received purchases and matching sales. Test transfers and share a worked example.

Kivloo editorial teamUpdated October 30, 2026

5 min read

Calculate period food cost and gross food margin from counted stock, received purchases and matching sales. Test transfers and share a worked example. — AI-generated editorial illustration

At a glance

Period food cost equals opening food stock plus received purchases plus net transfers in, minus closing food stock. Divide by matching food sales to find the cost percentage. The remaining amount is a food gross contribution before labour, rent and other expenses; it is not net profit.

Define the period before entering numbers

Use this calculator for one site and one completed week or month. It measures food consumed over a period, rather than the theoretical cost of an individual recipe. Choose opening and closing counts with a consistent cutoff and valuation method. Keep drinks outside both the stock figure and the food-sales denominator unless you intentionally define a combined food-and-beverage calculation.

Enter stock and purchases at cost, rather than menu selling prices. Use the same currency and tax basis for all amounts; the calculator does not convert currencies or interpret local tax rules. Keep the original count sheets, received-delivery records and sales export so another person can reproduce the result. A calculated number cannot certify that those records are complete.

BCcampus · Monthly Food Costs

Use received purchases and count transfers once

Purchases means food received during the chosen period, after consistent purchase returns or credits. An order awaiting delivery is not received stock. A late invoice should be reconciled against its receipt date rather than silently assigned to the month when someone entered it. If a return was already deducted from purchases, do not subtract it a second time.

The optional signed transfer field is transfers in minus transfers out, valued on the same basis as inventory. Enter 500 for net incoming stock or -500 for net outgoing stock. Keep it at zero when transfers are already included in purchases. Internal transfers cancel when consolidating the same group; do not count them as new external purchases.

Example record and review decision

Fictional example in one currency: opening inventory 4,000, received purchases 15,000, net transfers in 500 and closing inventory 3,500 give food cost 16,000. Food sales of 50,000 give a food-cost percentage of 32%. Sales minus food cost is 34,000, a 68% gross food margin before other expenses. This is an illustration, not a customer result or recommended target.

The reviewer checks the 500 transfer against both sites and confirms it is absent from received purchases. If it had already been included, remove it from the transfer field: cost becomes 15,500, cost percentage 31% and food gross contribution 34,500. This 500 difference is a correction to the calculation, not evidence of savings. Keep the rejected version and the reason for changing it.

Read validation messages before interpreting the result

Opening stock, purchases and closing stock must be non-negative; only net transfers may be signed. All fields are required, including a deliberate zero. Food sales must exceed zero before a ratio can be calculated. A blank field is missing information, not zero. If closing stock exceeds the recorded available stock, investigate counts, unrecorded receipts or transfer signs; the calculator blocks a negative consumption result.

A cost percentage above 100% can be mathematically valid, for example after unusually low sales, but requires investigation. The calculator shows it without imposing a supposed industry benchmark. It also does not add a separate waste charge: waste already reduces closing inventory in this period-consumption method. Adding the same waste again would overstate food cost.

Share a scenario and preserve its assumptions

Open the localized calculator below and load the fictional example. Change one input at a time and press calculate. The share control creates a URL containing the entered amounts; copy it only when you intend recipients to see those figures. The page processes the calculation in the browser and does not connect to your Kivloo account. Avoid putting confidential site figures in a publicly shared link.

The shared URL restores inputs rather than a signed financial record. Keep the period, site, currency, tax basis and evidence outside the link in your review notes. Print the result if useful. For a cause-by-cause investigation, use the related actual-versus-theoretical reconciliation guide; this calculator establishes the period total and does not explain every variance.

Connect the calculation to a completed-day review

Kivloo procurement beta connects usable stock, receipts, recipes and classified sales with completed-day margin reports and visible missing data. Web setup and an active connection are required for procurement. Invoice and scan workflows are web-only, and internal order approval does not send an order to a supplier. Check the feature page before deciding whether the current beta fits your workflow.

First reconcile the manual period total against the records you intend to use in the product. Investigate missing receipts, inconsistent units and unclassified sales before attributing a change to operations. The free calculator is a separate educational tool; it does not import invoices, validate stock counts or forecast a guaranteed margin increase. Use consistent complete periods for subsequent comparisons.

Kivloo · Procurement beta