Get unlimited access to 5000+ Templates for Google Docs, Slides and Sheets
Unlimited Access
All Templates

Bar Inventory Template

Use this free template with Google Sheets and Microsoft Excel

4.47 (2 reviews)
Last updated Updated June 18, 2026
Created by Alexander Clark
Type Spreadsheet
ADVERTISEMENT

Template Specification

Format Google Sheets
Created January 17, 2022
Last Updated June 18, 2026
Community Added to collections by 9 Users
Usage Stats 78 downloads this month

Key Features of This Template

About this template

Our Bar Inventory Template allows you to manage your entire product and alcohol stock much more efficiently. No matter how many customers you have or how often you need to reorder, this template makes it easy. It is fillable and editable in Google Sheets and Excel and offers a range of convenient features.

Manage Your Bar Inventory Professionally

With this bar inventory template, you can record and manage the restocking of any goods, equipment, and supplies. We've prepared a convenient table with a header and key placeholders. You can add your bar logo and name to the header or leave the default design with two beers.

The main table consists of three sections. In the first section, you can select the product type (wine, rum, champagne, liquor, and more) from an editable drop-down list. Here, all that's left to do is enter the brand name, description, strength, vendor details, and country of origin.

In the second section, enter the bottle quantity and price to automatically calculate the total cost for each item. The template also includes:

  • A separate section with an overview of the profit earned from each product type.
  • Editable drop-down lists for product types and bottle/can sizes.
  • An unlimited number of product entry lines.

You can use pre-made formatting or customize the template to suit your bar's needs. Select the inventory spreadsheet template in Google Sheets and start filling it out.

ADVERTISEMENT
Free Template

Download Free Template

Choose your platform and start editing right away
PLATFORM

Google Sheets

Opens in browser
PAPER SIZE
US Letter
Google Sheets – US Letter
No account required • Attribution required

WHAT’S INCLUDED

Editable product type drop-down list
Automatic total cost calculations
Vendor and origin country sections
Overview for profit tracking

Inventory Tips

1
Update your inventory weekly for accurate stock levels.
2
Customize categories to match your bar's product types.
3
Use the profit overview to refine your pricing strategy.
4
Regularly check vendor details to ensure accuracy.

FAQ

Is this compatible with Google Sheets and Excel? Yes, it works with both platforms for your convenience.
Is the template easy to use? Absolutely, it's designed for simple and efficient tracking.
Can I customize the template? Yes, you can modify it to suit your bar’s needs.
Is this template free to download? Yes, it's completely free to download and use.
Does it include product cost analysis? Yes, it tracks costs to help manage expenses.
ADVERTISEMENT

How to Use and Edit This Template

Get Your Document
1

Get Your Document

Click the "Edit Template" button to create your own editable copy in Google Sheets or download for Microsoft Excel
Customize Everything
2

Customize Everything

Easily change colors, fonts, and layouts to match your unique style or brand identity
Add Your Content
3

Add Your Content

Fill in your data, upload images, and replace the placeholder text with your own information
Print, Export, or Share
4

Print, Export, or Share

Print, export as PDF, or share instantly

Related Templates

Recently Viewed