Restaurant Cost of Sales Spreadsheet

🍽️ Restaurant Cost of Sales Spreadsheet (Food‑Only & Food‑and‑Alcohol Versions)

Running a profitable restaurant isn’t just about great food — it’s about controlling costs with precision. Our Restaurant Cost of Sales Spreadsheet gives owners and managers a simple, accurate way to track weekly inventory, vendor purchases, sales, and cost percentages. Whether you operate a café, bar, food truck, or full‑service restaurant, these spreadsheets help you understand exactly where your money is going and how to keep prime costs in line.

We offer two versions depending on your operation:

✔️ Restaurant Cost of Sales Spreadsheet-Food Only

Ideal for restaurants that serve food only.

✔️ Restaurant Cost of Sales Spreadsheet-Food & Alcohol

Perfect for bars, taverns, breweries, or restaurants with a liquor program.

Both versions are included on this page — scroll down to access each spreadsheet.

📊 Why Cost of Sales Tracking Matters

Cost of Sales (COS) is one of the most important financial metrics in the restaurant industry. The Restaurant Cost of Sales Spreadsheet tells you how much of your revenue is being consumed by the food and beverages you purchase. When COS is too high, profits disappear. When COS is controlled, your restaurant thrives.

Our Restaurant Cost of Sales Spreadsheet helps you:

• Track weekly vendor purchases
• Log beginning and ending inventory
• Record daily or weekly sales
• Calculate food and alcohol cost percentages
• Identify waste, theft, or pricing issues
• Compare actual costs to industry benchmarks
• Make smarter menu and pricing decisions

This tool gives you a clear snapshot of your operation’s financial health — without needing expensive software.

🧮 What the Spreadsheet Tracks

Just enter the following information each week:

• Daily or Weekly Sales
• Beginning Inventory Dollars
• Ending Inventory Dollars
• Vendor Purchases (food, beer, wine, liquor, soft beverages)
• Number of Days Open
• Category‑specific sales (for alcohol version)

The spreadsheet automatically calculates:

• Food Cost %
• Alcohol Cost %
• Category breakdowns
• Weekly usage
• Prime cost indicators
• Variances and trends

Everything is done for you — simply plug in your numbers and review the results.

📉 Understanding Prime Costs

Prime cost is the combination of food cost + labor cost, and it’s the single most important profitability metric in the restaurant industry. Most restaurants aim for 60%–65% prime cost to remain profitable.

Here’s a quick example:

• Weekly Sales: $20,000
• Weekly Food & Beverage Cost: $7,000 → 35% Food Cost
• Weekly Labor Cost: $5,000 → 25% Labor Cost
• Prime Cost = 60%

If your prime cost is higher than industry averages, your profits shrink. Our spreadsheet helps you identify exactly where costs are rising so you can take action.

🍺 Alcohol Cost Benchmarks (for the Alcohol Version)

If you serve alcohol, your cost percentages will vary by category:

• Liquor: 18%–20%
• Bar Consumables: 4%–5%
• Bottled Beer: 24%–28%
• Draft Beer: 15%–18%
• Wine: 35%–45%
• Soft Drinks: 10%–15%
• Coffee: 12%–20%
• Iced Tea: 5%–10%

The Alcohol version of the Restaurant Cost of Sales Spreadsheet breaks these categories out so you can see exactly where your beverage program is performing well — and where margins are slipping.

🔍 If Your Costs Are Too High…

High food or alcohol costs can be caused by:

• Incorrect menu pricing
• Poor portion control
• Vendor price increases
• Waste or spoilage
• Theft
• Lack of inventory tracking
• No perpetual inventory system
• Over‑pouring or comped drinks

Our Restaurant Cost of Sales Spreadsheets help you spot these issues quickly. And if you need deeper help, Workplace Wizards can assist with menu engineering, cost analysis, and operational improvements.

📥 Download the Restaurant Cost of Sales Spreadsheets

Restaurant Cost of Sales Spreadsheet-Food Only

Restaurant Cost of Sales Spreadsheet - Food only

The use of the Cost of Sales Spreadsheet will allow monitoring of your restaurant or bar performance. There are two versions of the Cost of Sales spreadsheet: 1) Food Cost of Sales Spreadsheet 2) Food and Alcohol Cost of Sales Spreadsheet (see next item) At a glance, you can view the food and alcohol cost percentages and you will also be able to view how much product you go through during a specific period.

Price: $15.00

Restaurant Cost of Sales Spreadsheet-Food & Alcohol

Restaurant Cost of Sales Spreadsheet-Food and Alcohol

The use of the Cost of Sales Spreadsheet will allow monitoring of your bar's performance. There are two versions of the Cost of Sales spreadsheet: 1) Food Cost of Sales Spreadsheet (see the previous item) 2) Food and Alcohol Cost of Sales Spreadsheet At a glance, you can view the food and alcohol cost percentages. You are also able to view how much product you go through during a specific period.

Price: $15.00

📚 Explore More Restaurant Tools

To view all restaurant forms, checklists, spreadsheets, and training manuals, visit our Individual Forms, Checklists and Spreadsheets page.

You can read some interesting information on the National Restaurant Association. Here is an article about the impact of Cost of Sales.