Restaurant Cost of Goods Sold Template

It's so important for bar and restaurant operators to track Cost of Goods Sold (called COGS) for your inventory.

Whether you want to see how you compare to the average COGS for restaurants, or see itemized COGS for alcohol, this free template is built to track cost of goods for your bar inventory like spirits, wine, and beer.

 

Tracking COGs will help you:

 

- Reduce inventory overhead
- Increase profitability
- Improve cash flow
- Better understand the items that turn profits
Illustration of a POS system and CoGs template

What is Included in COGs for restaurant

 

A common question that we're asked at Backbar is how to calculate cost of goods sold. It's important for restaurant and bar managers to track and analyze COGs because it can influence a business's bottom line. That's why we put together this free cost of goods template to help you.

 

What you'll get in this spreadsheet:

  1. Twelve month layout to track monthly cost of goods sold at your bar
  2. Track inventory, purchasing, sales, and COGs data for wine, beer, spirits
  3. Break down your drink types into subtypes like red wine or white wine, draft beer or bottle beer, and common spirit types like vodka and whiskey.
  4. More insight into how to make your bar more profitable

About Backbar
Backbar is an inventory management software for bars and restaurants. Spend less time taking inventory and see increased profits when you sign up for free with Backbar.