Written by: JJ Tan, Founder, Jelly
Key Takeaways
- COGS is calculated as Opening Inventory + Purchases − Closing Inventory, and only direct ingredient costs count.
- Accurate stocktake cut-offs and consistent valuation methods prevent phantom variances between periods.
- Separate food and beverage COGS tracking stops weak performance in one category being hidden by the other.
- Manual spreadsheet processes consume 10–20 hours weekly and often create errors that distort margins and pricing decisions.
- Book a demo with Jelly to automate invoice capture, live dish costing, and stocktake valuation for real-time margins.
Step 1: Record Your Beginning Inventory Value Accurately
The opening inventory figure must match the prior period’s closing inventory exactly. Any discrepancy between the two creates a phantom COGS variance before a single purchase is recorded. Pull the closing value from last month’s stocktake sheet and carry it forward as-is.
Value every item at cost, not at selling price. Common valuation errors include counting opening inventory at purchase price while counting closing inventory at current price, or mixing valuation methods within a single period. Choose FIFO, weighted average, or most-recent-cost and apply that method consistently every month.
For multi-site operators, stock transferred between sites is not a purchase and must be excluded from the purchasing figure and handled as an internal transfer. Treating transfers as purchases inflates COGS at the receiving site.
Step 2: Total All Purchases During the Period
Purchases cover every ingredient bought during the period, valued at the actual invoiced price, including delivery charges and minus credit notes. Work through every supplier invoice line by line. Avoid using statement totals, which can hide unresolved credits.
Exclude non-inventory items from the COGS bucket. Cleaning chemicals, pest control, laundry, and hood cleaning are classified as operating expenses rather than food cost, even when they arrive on the same supplier invoice as kitchen items. When a single invoice mixes categories, split it by line item so only true consumables flow into COGS.
Once you have categorised all line items correctly, handle any credits tied to those purchases. Supplier invoice credits must reverse the original category they affected, such as a meat supplier credit reducing food cost, rather than being posted to a generic adjustments account. Missing a credit note is one of the most common reasons COGS runs artificially high at month end.
Step 3: Conduct and Value Your Ending Inventory
Operators should select one consistent cut-off moment, most commonly the last night of the trading period or the first morning before the first delivery of the new period, and repeat it every cycle so that opening and closing stock figures are directly comparable. Consistency here supports the opening-closing inventory link described in Step 1.
The single most common error in stocktakes is receiving a delivery mid-count, which makes it unclear whether items belong to the old or new period. To avoid this confusion, complete the count before any delivery lands, or after it is fully put away. Even with perfect timing, human error remains a risk, and using at least two people, one counting and one recording, reduces mistakes during the stocktake process.
Stocktake frequency should be tiered by item value: high-value items such as proteins, seafood, and spirits counted weekly, mid-value items such as dairy and oils fortnightly, low-value stable items monthly, with a full count run monthly for the books. Digital tools can reduce stocktake times from hours to minutes.
A stocktake error of 3% in either direction can swing the COGS percentage by a full point. An inaccurate monthly stocktake contaminates two months of data because of the opening-closing inventory link described in Step 1.
Step 4: Apply the COGS Formula to Your Figures
With all three components confirmed, the calculation becomes straightforward. Here is a worked UK example:
| Component | £ Value |
|---|---|
| Opening Inventory (1 June) | £15,000 |
| + Purchases (June invoices, net of credits) | £30,000 |
| − Closing Inventory (30 June stocktake) | £17,000 |
| = COGS | £28,000 |
This mirrors the Dishcost worked example, adapted to £ figures. The £28,000 figure flows directly into your P&L as the ingredient cost line for June.
Ready to see this calculated automatically, live, every day? Book a demo, schedule a chat and see how Jelly turns your invoice data into real-time margins.
Step 5: Turn COGS into a Percentage You Can Track
Convert the COGS figure into a percentage so you can compare performance over time. Divide COGS by total net sales for the period, then multiply by 100:
COGS % = (COGS ÷ Total Sales) × 100
Using the June example above with £87,500 in sales, (£28,000 ÷ £87,500) × 100 = 32%. That single percentage is the number your P&L, your chef, and your accountant all need to act on. The next step is understanding whether that 32% sits within a healthy range for your concept.
Restaurant COGS Percentage Benchmarks in the UK
UK benchmarks vary by concept and revenue mix. Combined COGS (food and beverage) for a UK restaurant typically falls between 28% and 35% of revenue, while food-only COGS usually runs higher. The table below summarises current UK targets:
| Concept | Food COGS % | Beverage COGS % | Blended COGS % |
|---|---|---|---|
| Fine Dining | 30–35% | 18–24% | 35–40% |
| Casual Dining | 28–32% | 18–24% | 28–35% |
| Pubs & Gastropubs | 28–35% | 18–24% | 28–35% |
| Fast Casual | 25–30% | 18–24% | 28–32% |
Rising energy and ingredient costs have pushed many UK restaurant food cost percentages towards the higher end of the 28–35% range. A sustained food cost above 35% can indicate problems with supplier prices, portioning, or waste.
How to Calculate COGS in Excel from Stocktake
A basic Excel COGS tracker uses four worksheets: Opening Stock, Purchases, Closing Stock, and Summary. The structure below covers the minimum viable setup:
- Opening Stock tab: Columns for Item, Unit, Quantity, Unit Cost, Total Cost. Pull closing values from last month’s Closing Stock tab using a VLOOKUP or named range so the figure carries forward automatically.
- Purchases tab: One row per invoice line item, including Supplier, Date, Item, Unit, Quantity, Unit Cost, Total Cost, and Category (Food / Beverage / Non-COGS). Filter out Non-COGS rows before summing the Purchases total.
- Closing Stock tab: Use the same structure as Opening Stock. Enter physical count quantities after the stocktake. Unit costs should match the most recent purchase price for that item.
- Summary tab: Three cells, Opening Stock Total, Purchases Total, and Closing Stock Total, feed the formula
=OpeningStock+Purchases-ClosingStockfor COGS and=COGS/TotalSales*100for COGS %. - Importing supplier invoices: Request CSV exports from your main suppliers or use your accounting software’s export function. Paste line items directly into the Purchases tab, then use a category column with data validation to tag each line as Food, Beverage, or Non-COGS before the summary pulls through.
The limitation of this approach is that every price change requires a manual update across the Purchases tab and the Closing Stock unit costs. A single missed update produces the kind of inventory valuation error described in Step 3, often the difference between a profitable and an unprofitable menu item.
Why You Should Separate Food and Beverage COGS
Food and beverage COGS should be tracked separately because the two categories carry very different margins. Blending the two masks underperformance in either category and makes supplier negotiations harder. Use the benchmark table above as a reference for the gap between food and beverage margins.
Run the same formula twice, once for food stock and food invoices, and once for beverage stock and beverage invoices:
- Food COGS: Opening Food Stock + Food Purchases − Closing Food Stock
- Beverage COGS: Opening Beverage Stock + Beverage Purchases − Closing Beverage Stock
In the June example above, if food sales were £68,000 with food COGS of £24,072, food COGS % = 35.4%. If beverage sales were £18,000 with beverage COGS of £3,834, beverage COGS % = 21.3%. The blended figure of 32.8% would have hidden the fact that food is running at the top of its acceptable range.
Apply the same line-item splitting approach from Step 2 when separating food and beverage COGS. A mixed invoice must be split so only true consumables flow into each COGS bucket.
Real Operator Pain Points with Manual COGS
The operators Jelly works with describe the same frustrations in almost identical terms:
- “By the time I’ve reconciled last month’s invoices, the figures are already three weeks old. I’m making menu pricing decisions on stale data.”
- “My chef does not have time to update a spreadsheet every time a delivery lands. So the closing stock value is always wrong, and the COGS is always wrong.”
- “I know my supplier has put prices up, I can feel it in the margins, but I cannot prove it without going through every invoice line by line.”
- “We run three sites. Getting a clean, comparable COGS figure across all of them at the same cut-off point is a full day’s work every month.”
Many restaurants operate with food costs 3–7 percentage points higher than theoretical because they rely on monthly estimates rather than weekly physical inventory counts. Full-service restaurants typically achieve net profit margins of only 3–5% of sales, so a small increase in COGS can significantly reduce total profit.
Manual vs Automated COGS: Time and Margin Impact
| Task | Manual (Spreadsheets) | Automated (Jelly) | Saving |
|---|---|---|---|
| Invoice data entry per week | 10–20 hours | Near zero (auto-scan) | 10–20 hrs/week |
| Monthly stocktake duration | Several hours | Under 30 minutes | Significant time saved |
| Time to cost a single dish | ~28 minutes | ~3 minutes | ~25 mins/dish |
| Supplier price change visibility | End of month (at best) | Same day (Price Alert) | Up to 4 weeks earlier |
| Average GP margin improvement | Baseline | +2 percentage points in first 3 months | +2 pp GP |
| Monthly cash saving (example operator) | Baseline | Substantial | Varies |
Sculpture Hospitality notes that manual inventory turnover calculations increase the risk of error, while inventory management software automates the process and ensures more accurate data. The margin impact compounds, and many operators see gross profit improvements of several percentage points in the first few months.
Move from Spreadsheets to Live Data with Jelly
Jelly replaces the manual steps above with an automated flow. Every supplier invoice, received by email or photographed on a phone, is scanned line by line, with quantity, SKU, price, and tax captured automatically. Those prices feed directly into dish costings in the Kitchen section, so every recipe’s gross profit margin updates the moment a new invoice lands.
The Price Alert feature flags every ingredient price movement, up or down, by how much, and from which supplier. This gives chefs the hard data to negotiate credits and gives finance managers the evidence to challenge invoices before they are paid. Flash Reports deliver a daily, weekly, or monthly GP view by integrating with POS systems including Square, Lightspeed, EPOS Now, and Toast, so the COGS percentage is never more than a transaction old.
Jelly connects to Xero for one-click invoice push, which removes manual bookkeeping entry. Onboarding takes under a week with a simple monthly subscription, with no per-user charges and no variable fees.
Book a demo, schedule a chat to see how Jelly imports your supplier invoices and turns your next stocktake into a live margin dashboard.
Frequently Asked Questions
How often should I calculate COGS from a stocktake?
Most UK operators run a full stocktake monthly, which produces one COGS figure per period for the P&L. For tighter control, conduct weekly spot counts on high-value items such as proteins, seafood, and spirits so variances are caught within days rather than at month end. The monthly full count supplies the closing stock value needed for the formal COGS calculation, and the weekly partial counts support operational decisions in between.
What items should I exclude from my COGS calculation?
Exclude anything that is not a direct food or beverage ingredient consumed in producing a dish or drink. Cleaning chemicals, pest control, packaging and disposables, laundry, and kitchen maintenance costs are operating expenses, not COGS. When a supplier invoice contains a mix of ingredient and non-ingredient lines, split it by line item and code each line to the correct category before totalling your purchases figure.
How do I handle the stocktake cut-off when I have multiple sites?
Set the same cut-off time across all sites, typically the last moment of trading on the final day of the period, and freeze all stock movements at that point. No deliveries, transfers, or adjustments should occur during the count window. Stock transferred between sites during the period must be recorded as an internal transfer, not a purchase, at the receiving site and not deducted from closing inventory at the sending site. Running all sites to the same cut-off makes the consolidated COGS figure directly comparable month on month.
Can I hand the COGS figures directly to my accountant?
Yes. The COGS figure produced by the formula (Opening Stock + Purchases − Closing Stock) is the same figure your accountant needs for the P&L and year-end accounts. Under the Companies Act 2006, UK companies dealing in goods must keep statements of stocktakings to support year-end stock figures. Providing your accountant with a clean monthly stocktake sheet, a purchases summary net of credit notes, and the resulting COGS figure reduces bookkeeping time significantly. Jelly’s Xero integration pushes digitised invoices directly into your accounting software, so the figures your accountant receives are already reconciled.
Why does my COGS percentage change even when sales are stable?
COGS percentage moves whenever ingredient costs change, stocktake accuracy varies, or the purchases figure is incomplete. The most common causes are unrecorded supplier price increases, missed credit notes, inconsistent stocktake timing such as counting before a delivery one month and after it the next, and valuation method changes between opening and closing stock. Separating food and beverage COGS helps isolate which category is driving the movement, and a price alert tool flags ingredient cost changes the day they happen rather than at month end.
Conclusion: Turn Stocktakes into Reliable COGS Figures
The 5-step process, record opening inventory, total purchases net of credits, conduct a clean cut-off stocktake, apply the COGS formula, and calculate the COGS percentage, forms the foundation of every accurate UK restaurant P&L. Separating food and beverage COGS, excluding non-inventory items, and maintaining consistent valuation methods determine whether the figure is actionable or misleading.
The spreadsheet approach works until it fails. Errors in ending counts from inconsistent units, missed invoices, or unlogged credits produce incorrect COGS figures used for menu pricing and prep planning. Jelly removes those failure points by automating invoice capture, live dish costing, and stocktake valuation, delivering the same COGS calculation in minutes rather than hours, with a 2-percentage-point GP improvement for customers in the first three months.
Book a demo, schedule a chat and see how Jelly turns your next monthly stocktake into a live, accurate margin report without the spreadsheet.