Free Izakaya Menu Pricing Template for Osaka

See your Top 3 profit leaks in seconds. Calculate food cost %, gross profit, and pricing gaps for your kushikatsu, doteyaki, and Osaka favorites—all in Google Sheets™.

🆓 Free template 📊 Google Sheets™ 🔝 Top 3 preview 🇯🇵 JPY 🍶 Kushikatsu & Izakaya
👀 View the template (read-only) 📋 Copy to your Drive — Free

Copy uses Google's standard screen to create a duplicate in your Drive. The original template is read-only.

✅ Works inside Google Sheets™ ⚡ 30-second analysis (after install)
🍶

Report Preview (Top 3)

Kushikatsu · Doteyaki · Takoyaki · Drinks

What this template does

Quick analysis of your izakaya menu pricing and food/drink costs

📝

Enter menu & ingredients

Add your food and drinks with prices. Pre-filled with Osaka izakaya samples—kushikatsu, doteyaki, takoyaki, negiyaki, plus beer, highball, and local drinks.

📊

Calculate food/drink cost %

Auto-calculates cost per item, cost percentage, and gross profit. Includes frying oil, sauce, ingredients, and alcohol costs separately.

🔝

See Top 3 profit leaks

Instantly identifies your 3 biggest profit improvement opportunities—often premium kushikatsu items or all-you-can-eat courses with underestimated consumption.

⚠️ Note: This template shows your Top 3 items only—a preview to validate the approach works for your menu. For full menu analysis, install MenuGauge AI.

How to use (3 steps)

Get your Top 3 profit improvement opportunities in minutes

1

View the template

Click "View the template" to preview the spreadsheet layout and sample data. No sign-in required to browse.

2

Copy to your Drive

Click "Copy to your Drive" to create your own copy. Replace sample data with your actual menu items, prices, and ingredient costs.

3

View Top 3 preview

Check the Report Preview tab to see your Top 3 profit leak items. Ready for full analysis? Install MenuGauge AI.

💡 Osaka tip: Kushikatsu sauce is communal—"Nidozuke kinshi!" (no double-dipping). Make your own sauce in bulk for ¥50-80/liter vs ¥200+ for bottled. Better taste AND better margins!

What's inside the spreadsheet

5 tabs designed to get you from data entry to insights

📘 Start Here ▼
Quick start guide, template limits explanation, and the Install CTA. This is your first stop—read it before diving in.
🍽️ Menu ▼
Your menu items and current prices. Two columns: Menu (item name) and Price (in JPY). Pre-filled with 30 Osaka izakaya samples—kushikatsu, konamon, Osaka classics, drinks, and course options.
🥗 Ingredients ▼
Ingredient costs per menu item. Five columns: Menu (must match Menu tab), Ingredient, Qty, Unit, Unit Price. This is where food/drink cost calculation begins.
🔢 Calc ▼
Auto-calculated intermediate values: Standard Cost (sum of ingredients), Food/Drink Cost %, Gross Profit. You can view this tab but don't need to edit it.
📊 Report Preview ▼
Your Top 3 profit leak items—the menu items with the biggest improvement potential. Shows cost %, gross profit, and ranking. Full ranking requires MenuGauge AI.

Designed for Osaka izakayas

Sample data reflects Osaka's lively drinking culture

🍢

Kushikatsu

Pork, beef, shrimp, vegetable

🍲

Osaka Classics

Doteyaki, horumon, tecchiri

🐙

Konamon

Takoyaki, negiyaki, okonomiyaki

🍺

Drinks

Beer, highball, shochu, sake

📝 Sample data is just a starting point. Replace it with your actual menu—the formulas adapt to your items.

Free template limits

What this template can and cannot do

Template limitations

  • Top 3 items only (preview)
  • Designed for menus up to 30 items
  • No competitor price range
  • No review priority score
  • No full ranking
  • No weekly update workflow

Unlock with MenuGauge AI

  • Full menu analysis (50 / Unlimited)
  • Competitor price range (auto)
  • Review priority score (%)
  • Complete ranking of all items
  • Weekly re-pricing workflow
  • Works inside your spreadsheet
🚀 Install MenuGauge AI — Free

Analyze your full menu in MenuGauge AI

Go beyond Top 3—get complete menu intelligence in 30 seconds

📊 Full menu analysis

Analyze 50 items (Plus) or unlimited items (Pro). See every profit opportunity, not just the top 3.

📈 Competitor price range

Auto-generated price ranges based on your location and industry. Know where your prices stand.

🔄 Weekly updates

Re-analyze weekly as costs change. Track priority improvements over time with review scores.

Free

$0
/ month
3 items

Plus

$29
/ month
50 items

Pro

$99
/ month
Unlimited
🚀 Install MenuGauge AI — Free

Frequently Asked Questions

Everything you need to know about this template

Is this template really free?▼
Yes, 100% free. Copy it to your Google Drive and use it forever. The template shows your Top 3 profit improvement opportunities. For full menu analysis (50+ items), you can install MenuGauge AI.
Do I need to install anything to use it?▼
No installation required for the template. Just click "Copy to your Drive" and start using it. The template works standalone for Top 3 preview. MenuGauge AI installation is optional for full analysis.
What's the difference between template vs add-on?▼
The template is a standalone spreadsheet showing Top 3 items only. MenuGauge AI add-on provides full menu analysis (50/unlimited items), competitor price ranges, review priority scores, and weekly update workflows.
Does it include kushikatsu and Osaka specialties?▼
Yes! The sample data includes Osaka izakaya essentials—kushikatsu (deep-fried skewers), doteyaki (beef tendon stew), takoyaki, negiyaki—plus drinks like beer, highball, and shochu with accurate local pricing.
What's a good food cost % for an Osaka izakaya?▼
Osaka izakayas typically aim for 30-38% food cost overall. Kushikatsu achieves 25-32% while premium items like doteyaki run 35-42%. Drinks should maintain 75%+ margins to balance the food cost.
Can I use it outside JP-Osaka?▼
Yes, but this template is optimized for JPY pricing and Osaka izakaya menu structures. We have templates for other regions: Tokyo, NYC, LA, Vancouver, London, Sydney, Singapore with local currencies.
How do I change currency?▼
This template uses JPY. For other currencies (USD, CAD, GBP, AUD, SGD), use our region-specific templates or install MenuGauge AI which auto-detects your location and adjusts currency.
What data do you store?▼
The template stores nothing—it's your Google Sheets copy. If you install MenuGauge AI, we process data only to generate recommendations. We never share or sell your menu data.
How long does it take to get results?▼
With sample data: instant. With your data: 5–10 minutes to enter menu items, then instant Top 3 results. MenuGauge AI provides full analysis in 30 seconds.
Where can I view the template before copying?▼
Click the "View the template" button at the top of this page. It opens the spreadsheet in read-only mode so you can preview the layout and sample data before making your own copy.
Why only Top 3?▼
Top 3 preview helps you validate the template works for your menu. For full ranking, weekly updates, and competitor comparisons, install MenuGauge AI—it's free to start.

Related templates

Explore more templates for your business

🏯 Same city (JP-Osaka)

🍜 Ramen

Ramen shops for Osaka

🥢 Udon & Soba

Japanese noodles for Osaka

☕ Cafe

Cafes for Osaka

🌍 Same industry (Izakaya / Bar)

🗼 Tokyo

Izakaya template for Tokyo (JPY)

🇬🇧 London

Pub template for UK (GBP)

🇦🇺 Sydney

Bar template for AU (AUD)
Browse all templates →   |   All JP-Osaka templates →

Start with Top 3. Scale to full menu.

View the free template, copy it to your Drive, or install MenuGauge AI for complete analysis.

👀 View the template 📋 Copy to your Drive

Copy uses Google's standard screen to create a duplicate in your Drive. The original template is read-only.