Running a restaurant or café means juggling a hundred things at once: tracking ingredients, knowing what to reorder, pricing menus so you actually make money, and keeping an eye on daily income and expenses. If you have been managing all of this in your head, on paper, or across scattered notes, this free Excel template for restaurant and café management is about to make your life much easier. It works with Google Sheets, so you can use it on any device for free, and it calculates the numbers for you automatically.
What This Free Restaurant Excel Template Does
This template was built to answer the questions every restaurant and café owner asks:
- How much stock do I have left right now, and what do I need to reorder?
- What is the gross profit of each menu item?
- Which menu items earn well, and which ones barely break even?
- Did I make a profit or a loss this month?
- Am I profitable this year?
- What is my average ingredient cost?
You get all of this in one file. No formulas to build, no accounting knowledge required — the spreadsheet does the math for you the moment you enter your numbers.
Download the Free Restaurant Management Spreadsheet
The file is an XLSX spreadsheet that you can open directly in Microsoft Excel, Google Sheets, or WPS Office. If you prefer to work online, upload it to Google Drive and open it with Google Sheets — everything stays in sync across your phone, tablet, and computer.
1. Track Menu Items and Recipes
The first sheet lets you list every menu item — food and drinks — along with its ingredients and portion sizes. For each dish, you record how much of each ingredient goes into one serving, and the spreadsheet calculates the real ingredient cost per portion automatically. This is the foundation of everything else: once your recipes are correct, your profit numbers become trustworthy.
You can also set your selling price next to each item. The template then shows you the gross profit and the profit margin of every dish at a glance, so you can see immediately which items are your money-makers and which ones are quietly costing you money.
2. Manage Customer Queues
If your café or restaurant gets busy during peak hours, the queue sheet helps you keep track of tables and waiting customers without losing anyone. Log the table number, the number of guests, the order status, and the time — and keep the whole service flow organized even when it is packed.
3. Control Stock and Ingredients
Stock control is where most small restaurants lose money without realizing it. This sheet tracks your current inventory of every ingredient, so you always know what is left and what needs to be reordered before you run out during service. You can record purchases and usage, and the template keeps a running balance for each item.
Because the template tracks average ingredient costs too, you can spot when prices go up and adjust your menu prices accordingly — instead of discovering months later that your margins have silently shrunk.
4. Track Daily Sales and Income
The sales sheet records your daily revenue by menu item or by shift. Enter the quantities sold, and the template calculates total sales, cost of goods sold, and gross profit for the day automatically. Over time, you build a clear picture of your busy days, slow days, and which items drive your revenue.
5. Income and Expense Ledger for Your Café
One question owners ask most is whether this template can handle bookkeeping. The answer is yes — the same file includes an income and expense sheet where you record daily cash in and cash out by category: food costs, drink ingredients, utilities, rent, salaries, and more. The spreadsheet calculates your running balance, monthly totals, and profit or loss automatically, so you always know where your money is going without hiring an accountant.
If you want a standalone, even simpler income and expense tracker, download the free Excel income and expense tracker for 2026. And if you want AI to analyze your numbers for you, read our guide on using Claude with Excel like having an analyst beside you.
How to Use the Template with Google Sheets
Getting started takes less than five minutes:
- Download the XLSX file using the button above.
- Open sheets.google.com and sign in with your Google account.
- Click the folder icon (Open file picker) and upload the downloaded file, or drag it into the browser.
- Google Sheets converts it automatically and keeps all formulas working.
- Start entering your menu items, stock, and daily numbers — the template updates the totals instantly.
Because the file lives in Google Drive, you can share it with your staff or your business partner and let multiple people update it at the same time. You can also access it from your phone with the Google Sheets app, which is perfect for checking daily sales right from the counter.
AI Tools for Restaurants in 2026
Modern restaurant owners no longer have to manage everything by hand. AI tools can now calculate ingredient costs, analyze sales patterns, and forecast stock automatically. If you want to take your restaurant management further, read our guides on AI for Restaurants 2026: tools that boost sales and cut costs and AI for Inventory Management 2026. For a broader look at how data analysis is changing spreadsheets, check out AI for Data Analysis in 2026.
Final Thoughts
Managing a restaurant or café is hard work, but the numbers should not be the hardest part. This free Excel template puts your stock, recipes, profits, and income and expenses in one place, calculates everything automatically, and works free on Google Sheets from any device. Download it, fill in your menu, and start seeing the real numbers of your business today.
