Restaurant Cost Reconciliation Dashboard

Analysis Period: 2025-01-01 to 2025-12-31

Generated: 2026-02-03 05:38:54 Data Quality: Good

Recipe Editor Ingredient Costs Errors & Warnings Passthrough Items Expense Analysis Data Explorer Estimated Prices
Total Revenue iTotal net sales from all POS channels (Toast, Shopify, etc.) for the selected period.
$386,042
58,377 items sold
Theoretical Cost iThe ideal food cost if every dish followed its recipe exactly with zero waste or spillage. Calculated from recipes × quantities sold.
18.5%
$71,516
Actual Cost iWhat you actually spent on food and ingredients based on vendor invoices and bank transactions.
28.5%
$110,138
Receipts $89,687 + Bank $20,451
Food $68,557 · Pkg $19,400 · Other $799 · Unknown $931
Variance iDifference between actual and theoretical cost. Positive means overspending — investigate waste, over-portioning, or missing recipes.
+6.4%
$24,869
Recipe Coverage iPercentage of revenue from menu items that have recipes defined. Higher coverage = more accurate theoretical cost.
100%
$346,142 covered
Data Provenance iPercentage of ingredient costs sourced from actual purchase invoices vs. estimated prices. Higher = more reliable.
49%
204/414 from purchases
115 estimated, 95 missing

Cost Overview

i
Actual Food Cost % Compares your actual food cost percentage to the theoretical cost (what it should be based on recipes). The gauge shows red/yellow/green zones.
💡 If actual exceeds theoretical, investigate waste, portioning, or untracked items.
i
Revenue Coverage Shows what portion of your sales have recipes defined. "With Recipes" = costed items, "Passthrough" = resold items, "Uncovered" = items missing recipes.
💡 Aim for 90%+ coverage. Add recipes for high-revenue uncovered items first.
i
Cost Variance Breakdown Shows how your cost grows from theoretical to actual. Each bar represents a source of variance: uncovered items, waste, portioning differences, and price changes.
💡 The largest bar is your biggest opportunity for cost savings.
i
Daily Sale & COGs Trend Tracks revenue (bars) and COGs over time. The shaded areas show 30-day rolling averages for sales (blue) and actual COGs (red). Toggle 7-day averages from the legend for finer-grained trends.
💡 When the actual rolling average rises above theoretical, investigate sustained cost overruns.
i
Daily COGs by Category Stacked breakdown of food costs by menu category. The top of the stack represents the 30-day rolling average of actual spend.
💡 Variance/Unknown represents the gap between theoretical recipe costs and actual vendor spend.

Margin Analysis

i
Best & Worst Margins Shows your highest and lowest margin products. Margin = (Revenue - Cost) / Revenue. The dashed line shows the 50% target.
💡 Consider promoting high-margin items or repricing low-margin ones.
i
Margins by Category Compares profit margins across your menu categories. Helps identify which parts of your menu are most/least profitable.
💡 Low-margin categories may need recipe optimization or price adjustments.
i
Product Portfolio Matrix Plots each item by revenue (x) and margin (y). ⭐ Stars = high revenue, high margin. 🐄 Cash Cows = high revenue, low margin. ❓ Question Marks = low revenue, high margin. 🐕 Dogs = both low.
💡 Promote Stars, optimize Cash Cows, evaluate if Dogs should stay on menu.

Revenue Treemap

i
Revenue Treemap Proportional view of revenue by menu item. Larger blocks represent higher revenue items.
Quickly see which items dominate your revenue mix.

Revenue by Item Sold

i
Revenue by Item Sold Ranks your top menu items by total revenue generated.
Focus menu optimization and marketing on your highest-revenue items.

Ingredient Flow Analysis

Actual purchase price Estimated price (no receipts) Derived from sub-recipe Waste / unused

Filter Ingredients

i
Ingredient Flow Diagram Shows how purchased ingredients flow into menu items sold. Red flows indicate waste - ingredients purchased but not fully used in sales.
💡 Large waste flows suggest over-ordering or spoilage issues for those ingredients.
i
Menu Item Composition Shows what ingredients go into each menu item you sell. Helps visualize which items share ingredients and their relative proportions.
💡 Items sharing expensive ingredients can benefit from bulk purchasing.
i
Ingredient Utilization Shows what percentage of each purchased ingredient was actually used vs leftover/wasted. Sorted by lowest utilization first.
💡 Low utilization = opportunity to reduce order quantities or find new uses.
i
Unassigned Ingredients Ingredients you purchased that aren't in any recipe. These add to costs but aren't tracked in menu item costing.
💡 Either add these to recipes or investigate if they're needed at all.

Variance Details

i
Top Variance Items Shows menu items with the largest deviation from target food cost (30%). Red bars = over target (bad), green = under target (good).
💡 Focus on high-variance items first - review recipes, portions, or pricing.

Vendor Price Comparison

i
Multi-Vendor Price Comparison For ingredients bought from multiple vendors, shows each vendor's average price as a dot connected by a range line. Green dot = cheapest vendor, Red dot = most expensive. Only items with complete pricing data are shown.
💡 Hover over dots to see brand names, price ranges, and most recent prices. The Δ% label shows the price spread between cheapest and most expensive vendor.
i
Egg Size Value Comparison Compares the price of different egg sizes across all vendors, normalized to the weight of a standard 'Large' egg (56.7g).
💡 Use this to identify the best value size regardless of vendor packaging.
i
Egg Price Over Time Tracks normalized egg prices (per large-egg equivalent) month by month for each vendor, so you can spot price trends and seasonal changes.
💡 Use this to see if a vendor's egg pricing is trending up or down over time.
i
Brand/Source Reference Table Shows all original brand/product names from vendor invoices that map to each consolidated canonical ingredient name, with pricing details per vendor.
💡 Use this table to see exactly which products each vendor sells under a consolidated ingredient name.

Brand/Source Reference Table

Canonical Name ▴▾ Vendor ▴▾ Brand Names Avg Price ▴▾ Price Range Most Recent ▴▾ Total Qty Total Spend ▴▾
large eggs Instacart - Restaurant Depot
James Farms - Large Cage Free Eggs, Loose - 15 Dz (180 x 15 doz)
 $0.03/dz $0.03 - $0.03 $0.03
2025-08-08 		2,700.0 dz $67.99
large eggs Instacart - Costco
Kirkland Signature Eggs, Large, 5 dozen-count (60 ct)
 $2.90/dz $2.90 - $2.90 $2.90
2025-09-21 		15.0 dz $43.53
large eggs Sysco
Egg Shell Large White Aa Cage Free | 7182289 | 1/15 DZ | WHOLESOME FARMS IMPERIAL
 $3.01/dz $2.20 - $4.93 $3.33
2025-12-16 		900.0 dz $2,713.24
large eggs Instacart - Costco Business Center
Large Eggs, Cage Free, 15 Dozen (180 ct)
 $3.22/dz $2.85 - $3.59 $2.85
2025-10-19 		30.0 dz $96.67
charmin ultra soft bath tissue, 2-ply, 4.5" x 4.2", 213 sheets, 30 ct Instacart - Costco Business Center
Charmin Ultra Soft Bath Tissue, 2-Ply, 4.5" x 4.2", 213 Sheets, 30 ct (30 ct)
 $1.02/ea $0.91 - $1.13 $1.13
2025-08-30 		60.0 ea $61.36
charmin ultra soft bath tissue, 2-ply, 4.5" x 4.2", 213 sheets, 30 ct Costco Business Delivery
Charmin Ultra Soft Bath Tissue, 2-Ply, 4.5" x 4.2", 213 Sheets, 30 ct
 $34.89/ea $34.89 - $34.89 $34.89
2025-10-12 		1.0 ea $34.89
charmin ultra strong bath tissue, jumbo roll, 2-ply, 4.5" x 4", 220 sheets, 30 ct Instacart - Costco Business Center
Charmin Ultra Strong Bath Tissue, Jumbo Roll, 2-Ply, 4.5" x 4", 220 Sheets, 30 ct (30 ct)
 $1.12/ea $1.12 - $1.12 $1.12
2025-10-19 		30.0 ea $33.54
charmin ultra strong bath tissue, jumbo roll, 2-ply, 4.5" x 4", 220 sheets, 30 ct Costco Business Delivery
Charmin Ultra Strong Bath Tissue, Jumbo Roll, 2-Ply, 4.5" x 4", 220 Sheets, 30 ct
 $34.69/ea $34.69 - $34.69 $34.69
2025-10-16 		1.0 ea $34.69
peeled garlic Instacart - Restaurant Depot
Peeled Garlic (30 x 3 lb)
 $0.22/lb $0.22 - $0.22 $0.22
2025-08-08 		90.0 lb $19.99
peeled garlic Sysco
Garlic Peeled Fresh | 1821537 | 4/5LB | IMPERIAL FRESH
 $1.53/lb $1.30 - $2.79 $1.40
2025-12-11 		480.0 lb $735.85
pork belly Costco Business Delivery
Swift Pork Belly, Skin On, Boneless
 $3.63/ea $3.59 - $3.69 $3.59
2025-12-18 		157.3 ea $570.77
pork belly Instacart - Costco Business Center
Swift Pork Belly, Boneless (~ 11 lb)
Swift Pork Belly, Skin Off, Boneless (~ 9.82 lb)
 $11.21/ea $9.89 - $13.85 $9.89
2025-09-02 		6.0 ea $67.26
usda select special trim Costco Business Delivery
USDA Select Special Trim
 $5.76/ea $5.59 - $5.89 $5.59
2025-12-15 		245.2 ea $1,413.47
usda select special trim Instacart - Costco Business Center
USDA Select Special Trim (~ 16.72 lb)
 $9.89/ea $9.89 - $9.89 $9.89
2025-09-05 		8.0 ea $79.12
olde thompson cracked black pepper, 5 lbs Instacart - Costco Business Center
Olde Thompson Cracked Black Pepper, 5 lbs (each)
 $33.54/ea $33.54 - $33.54 $33.54
2025-09-02 		1.0 ea $33.54
olde thompson cracked black pepper, 5 lbs Costco Business Delivery
Olde Thompson Cracked Black Pepper, 5 lbs
 $45.99/ea $45.99 - $45.99 $45.99
2025-10-09 		1.0 ea $45.99
romaine lettuce hearts, 6 ct Instacart - Costco Business Center
Romaine Lettuce Hearts, 6 ct (each)
 $5.49/ea $5.49 - $5.49 $5.49
2025-09-02 		11.0 ea $60.39
romaine lettuce hearts, 6 ct Costco Business Delivery
Romaine Lettuce Hearts, 6 ct
 $7.17/ea $6.19 - $7.39 $7.39
2025-10-27 		12.0 ea $86.08
kirkland signature chicken thighs, boneless skinless, 6.5 lbs Instacart - Costco Business Center
Kirkland Signature Chicken Thighs, Boneless Skinless, 6.5 lbs (each)
 $19.79/ea $19.79 - $19.79 $19.79
2025-08-19 		4.0 ea $79.16
kirkland signature chicken thighs, boneless skinless, 6.5 lbs Costco Business Delivery
Kirkland Signature Chicken Thighs, Boneless Skinless, 6.5 lbs
 $22.59/ea $22.59 - $22.59 $22.59
2025-12-15 		56.0 ea $1,265.04
ardent mills bread flour, 25 lbs Instacart - Costco Business Center
Ardent Mills Bread Flour, 25 lbs (each)
 $9.89/ea $9.89 - $9.89 $9.89
2025-10-07 		8.0 ea $79.12
ardent mills bread flour, 25 lbs Costco Business Delivery
Ardent Mills Bread Flour, 25 lbs
 $10.51/ea $10.39 - $10.99 $10.99
2025-12-18 		53.0 ea $557.27
kirkland signature 2-ply paper towels, white, 160 create-a-size sheets, 12 ct Instacart - Costco Business Center
Kirkland Signature 2-Ply Paper Towels, White, 160 Create-A-Size Sheets, 12 ct (each)
 $22.54/ea $22.54 - $22.54 $22.54
2025-10-07 		4.0 ea $90.16
kirkland signature 2-ply paper towels, white, 160 create-a-size sheets, 12 ct Costco Business Delivery
Kirkland Signature 2-Ply Paper Towels, White, 160 Create-A-Size Sheets, 12 ct
 $23.49/ea $23.49 - $23.49 $23.49
2025-12-15 		10.0 ea $234.90
jimmy dean fresh pork sausage, 3 lbs Instacart - Costco Business Center
Jimmy Dean Fresh Pork Sausage, 3 lbs (each)
 $11.65/ea $11.65 - $11.65 $11.65
2025-09-24 		4.0 ea $46.60
jimmy dean fresh pork sausage, 3 lbs Costco Business Delivery
Jimmy Dean Fresh Pork Sausage, 3 lbs
 $11.99/ea $11.99 - $11.99 $11.99
2025-12-15 		9.0 ea $107.91
galbani professionale ricotta cheese, classic, 5 lbs Instacart - Costco Business Center
Galbani Professionale Ricotta Cheese, Classic, 5 lbs (28 oz)
 $11.76/ea $11.76 - $11.76 $11.76
2025-09-05 		3.0 ea $35.28
galbani professionale ricotta cheese, classic, 5 lbs Costco Business Delivery
Galbani Professionale Ricotta Cheese, Classic, 5 lbs
 $12.09/ea $12.09 - $12.09 $12.09
2025-12-15 		7.0 ea $84.63
clabber girl corn starch, 3 lbs Costco Business Delivery
Clabber Girl Corn Starch, 3 lbs
 $5.39/ea $5.39 - $5.39 $5.39
2025-10-20 		2.0 ea $10.78
clabber girl corn starch, 3 lbs Instacart - Costco Business Center
Clabber Girl Corn Starch, 3 lbs (each)
 $5.49/ea $5.49 - $5.49 $5.49
2025-09-05 		2.0 ea $10.98
i
Complete Margin Analysis Full breakdown of every menu item's profitability. Margin % shows how much of each dollar of revenue is profit after ingredient costs.
💡 Items below 50% margin may need recipe optimization or price increases.

Complete Margin Analysis

Menu Item Revenue Cost Margin Margin % Qty Sold Data Source Status
Kare - Kare EST $1,172.82 $1.16 $1,171.66 99.9% 70 N/A Excellent
Garden Salad (Serves 10 or 20) - Fullsize (20 people) $37.50 $0.05 $37.45 99.9% 1 100% Purchase Excellent
Decorated Cake (non sculptural) - feeds 5-10 / Birthday Card / 1 Candle $64.00 $0.10 $63.90 99.9% 1 100% Purchase Excellent
Guava and Cream Cheese EST $4,170.89 $6.39 $4,164.50 99.8% 773 N/A Excellent
Apple Juice $39.20 $0.06 $39.14 99.8% 14 N/A Excellent
Decorated Cake (non sculptural) - Feeds 4-6 - Ideal for couples as well / None / None $100.00 $0.19 $99.81 99.8% 2 100% Purchase Excellent
Raspberry Roll EST $1,436.82 $2.82 $1,434.00 99.8% 341 N/A Excellent
Beef & Cabbage Piroshki EST $6,416.28 $12.62 $6,403.66 99.8% 763 N/A Excellent
Potato & Mushrooms Vegetable Piroshki EST $6,653.50 $13.25 $6,640.25 99.8% 801 N/A Excellent
Grilled Liempo & Atchara EST $10,421.99 $22.55 $10,399.44 99.8% 1,364 N/A Excellent
Honey cake - With Walnuts (our traditional version) / 19-30 People - Full cake EST $100.00 $0.26 $99.74 99.7% 1 33% Estimated Excellent
Honey cake - Without Walnuts / 12-18 People - Full cake EST $75.00 $0.26 $74.74 99.7% 1 33% Estimated Excellent
Cabbage Roll EST $17.90 $0.07 $17.83 99.6% 1 50% Mixed Excellent
Cabbage $51.00 $0.20 $50.80 99.6% 3 100% Purchase Excellent
Glutten Free Cabbage Lunch Special - 1 $34.00 $0.13 $33.87 99.6% 2 100% Purchase Excellent
Stuffed cabbage roll meal EST $17.00 $0.07 $16.93 99.6% 1 50% Mixed Excellent
CR Red Table $20.00 $0.08 $19.92 99.6% 2 100% Purchase Excellent
Honey cake - With Walnuts (our traditional version) / 7-11 People - Full cake EST $55.00 $0.26 $54.74 99.5% 1 33% Estimated Excellent
Notebook Red $21.00 $0.12 $20.88 99.4% 3 100% Purchase Excellent
Honey cake - With Walnuts (our traditional version) / 4-6 People - Full cake EST $60.00 $0.52 $59.48 99.1% 2 33% Estimated Excellent
i
Ingredient Waste Analysis Shows ingredients with excess inventory - purchased but not used based on sales and recipes. High waste % = over-ordering.
💡 "Reduce Order" items should have smaller order quantities next time.

Ingredient Waste Analysis

Ingredient Leftover Waste % Est. Cost Lost Action
paper bags 0.0 ea 100.0% $9,300.00 Reduce Order
impossible burger patty 0.0 oz 100.0% $3,484.75 Reduce Order
sausage polish links smoked 5 per # 0.0 lb 100.0% $3,084.31 Reduce Order
discovery blend whole bean 0.0 ea 100.0% $2,871.90 Reduce Order
large eggs 0.0 ea 96.6% $2,823.49 Reduce Order
cream coconut natural 0.0 ea 100.0% $2,350.18 Reduce Order
french butter sheets 0.0 lb 100.0% $2,119.39 Reduce Order
milk 0.0 g 100.0% $2,103.07 Reduce Order
butter block 0.0 g 94.8% $2,009.54 Reduce Order
granulated sugar 0.0 lb 100.0% $1,512.22 Reduce Order
usda select special trim 0.0 ea 100.0% $1,492.59 Reduce Order
beef short rib bone-in 2 inch no-roll frozen 0.0 #avg 100.0% $1,409.02 Reduce Order
kirkland signature chicken thighs, boneless skinless, 6.5 lbs 0.0 ea 100.0% $1,344.20 Reduce Order
napkin dinner 16x17 1/8f 3p wht 0.0 ea 100.0% $1,285.37 Reduce Order
dough puff pastry 5" x 5" zero trans fat 0.0 oz 100.0% $1,274.73 Reduce Order
i
Passthrough Margins Visual breakdown of cost vs margin for each passthrough item. Red = cost portion, Green = margin portion.
💡 Items with large red bars have low margins - consider repricing.
i
Passthrough Items Products you buy and resell without modification (drinks, packaged goods, etc.). Cost is calculated directly from purchase price, not recipes.
💡 Watch Cost % on these - should typically be 30-50% for good margins.

Passthrough Items (Sold As-Is)

POS Name Qty Sold Avg Cost/Unit Avg Sale Price Cost % Method Data Category
Specialty Dessert 1,363 $0.57 $7.38 7.7% proportional No Data Special
Piroshki of the Month 1,263 $1.57 $7.20 21.8% proportional No Data Special
Vegan Piroshki of the Month 749 $0.49 $8.42 5.9% proportional No Data Special
Diet Soda Can 414 $0.62 $3.38 18.5% purchase_linked No Data Beverage
4 Non-Vegan Frozen 62 $3.01 $16.71 18.0% percentage Pct Frozen
Small Juice 377 $1.00 $2.71 37.0% fixed Fixed Beverage
Cold Brew Can 206 $2.00 $4.37 45.8% fixed Fixed Beverage
Vegetable Piroshki 388 $0.57 $2.31 24.6% proportional No Data Special
Red Bull 197 $2.17 $3.84 56.4% purchase_linked Purchase Beverage
Ketha Cookies 194 $0.97 $3.86 25.0% percentage Pct Baked Goods
Vegan Piroshki 77 $0.49 $8.38 5.9% proportional No Data Special
San Pellegrino 211 $1.29 $3.01 42.7% purchase_linked Purchase Beverage
Alternative Milk 1,203 $0.20 $0.48 41.4% fixed Fixed Coffee Modifier
Non-Diet Soda Can 156 $0.00 $3.65 0.0% purchase_linked No Data Beverage
Juice 198 $1.00 $2.73 36.6% fixed Fixed Beverage
i
Data Quality Warnings Items flagged for missing purchase data, suspicious cost percentages, or estimated pricing. Items with 0% cost have no linked purchase data at all. Non-zero percentages show the calculated cost — expand details for the calculation breakdown.
💡 Review linked ingredients and unit conversions for flagged items.
⚠ 8 item(s) with insufficient or suspicious data
Item Cost % Issue
Diet Soda Can 18.5% No purchase data found for linked ingredient
Cost from group 'diet_soda' average ($0.6250/unit, 2 member(s) with data) — linked to 'soda coke diet', total cost $258.75 on $1398.89 revenue
Non-Diet Soda Can 0.0% No purchase data found for linked ingredient
Linked to 'soda coca cola classic' (method: purchase_linked) but no purchase or estimated price found
Water Bottle 0.0% No purchase data found for linked ingredient
Linked to 'water bottled' (method: purchase_linked) but no purchase or estimated price found
Non-Diet Sprite 16.9oz 0.0% No purchase data found for linked ingredient
Linked to 'soda sprite cans' (method: purchase_linked) but no purchase or estimated price found
Dr Pepper 0.0% No purchase data found for linked ingredient
Linked to 'soda dr pepper can cube' (method: purchase_linked) but no purchase or estimated price found
Apple Juice 0.2% Cost suspiciously low — check unit conversion
Linked to 'juice apple plastic bottle' — $0.0045/g, conv. factor 1.0, total cost $0.06 on $39.20 revenue
Diet Dr Pepper 25.5% No purchase data found for linked ingredient
Cost from group 'diet_soda' average ($0.6250/unit, 2 member(s) with data) — linked to 'soda dr pepper diet', total cost $6.88 on $26.95 revenue
Sprite 0.0% No purchase data found for linked ingredient
Linked to 'soda sprite cans' (method: purchase_linked) but no purchase or estimated price found

Sales Breakdown

i
Sales by Source Shows the percentage breakdown of revenue by sales channel (Toast, Shopify, etc.). Hover for detailed transaction counts and dollar amounts.
💡 Track which channels drive the most revenue.