Do I need to enable macros to use XL Recipe Manager?

Yes. The tool uses VBA macros for key functions such as backups and dynamic forms. Enable macros when prompted to ensure full functionality.

Can I track stock adjustments manually?

Yes. You can log manual stock adjustments for waste or loss in the Stock Usage Log sheet.

XL Recipe Manager Powerful – Smart Food Costing & Inventory Excel App

What is XL Recipe Manager?

The XL Recipe Manager is an Excel-based solution designed for chefs, caterers, and food entrepreneurs to accurately manage recipe costing and kitchen inventory effortlessly.

It leverages intuitive dashboards and real-time data to give you actionable insights on cost trends and stock levels, enabling you to optimize menu pricing, minimize waste, and boost profitability across every dish you prepare.

Main Features

✓ Accurate real-time recipe costing based on current prices
✓ Automatic stock monitoring with low-stock alerts
✓ Easy management of purchases, suppliers, and expenses
✓ Powerful unit conversion functionality
✓ Dynamic price trend analysis and reporting
✓ Instant PDF reports and data backups

Ideal For

🍽️

Catering Services

Quickly estimate and control costs for event menus.

🏪

Small Food Businesses

Maintain precise control over ingredient inventory and profitability.

🍴

Restaurants

Streamline menu costing and stock management efficiently.

How It Works

Enter your materials and suppliers
Define recipes and ingredients precisely
Track consumption and update inventory automatically
Generate reports and analyze price trends instantly

Limitations

This Excel file uses VBA macros to automate processes. You must enable macros when prompted to access full functionality. The file is only compatible with Microsoft Excel desktop versions (2016 or later) and will not work in Excel Online or mobile environments. For step-by-step instructions on enabling macros and unblocking files, please see our Macros & Security Guide.

Screenshots

Dashboard: Real-time overview of low stock alerts, price trends, latest purchases, and recent price changes — all in one central panel.

Materials: Full inventory tracking with current stock, prices, supplier details, and interactive price reports for each material.

Purchases: Log every material purchase with supplier, unit prices, and quantities to automatically update cost calculations.

Suppliers: Manage all supplier contact information and link each material to the supplier with the lowest historical price.

Recipes: Define each recipe with prep time, cost breakdown, margin, and selling price — dynamically updated as ingredients change.

Recipe Ingredients: Assign exact ingredients, quantities, and units to each recipe and instantly calculate material cost per portion.

Consumption: Log your daily recipe usage and sold portions. All ingredient usage is calculated automatically per portion.

Menu Costing: Combine multiple recipes to create full menus, define portions, and calculate the total cost of production instantly.

Stock Usage Log: Keep a detailed log of all ingredient usage, whether from sold portions, waste, or manual adjustments.

Expenses: Add monthly operating costs like rent, wages, and utilities. The system calculates cost per minute for recipe cost allocation.

Units & Conversions: Define all measurement units (kg, lt, gram, etc.) and set unit conversion ratios for consistent costing accuracy.

Price Trend Reports: Visualize price fluctuations over time for each ingredient to make better purchasing decisions and anticipate cost changes.

See It in Action

Ready to Get Started?

Gain full control over your kitchen management with XL Recipe Manager.

Buy Now – $199

Looking for customizations? Contact us here.