Liquor Inventory Sheet Template | Jotform Tables (2024)

Tables

Contact Sales Sign Up for Free

  • Benefits
  • Features
  • Workspaces
  • Templates
  • Story
  • Explore
    • FAQ
    • Help Guides
    • Blog Posts
  • Get Started Now - It’s Free!

See Demo:

Shared by Jotform in Inventory Templates

Cloned 3,804

See Demo

A liquor inventory spreadsheet is used to track liquor supplies for a bar, restaurant, grocery store, or liquor store. With Jotform’s free online Liquor Inventory Spreadsheet, you can expertly organize and manage your workplace’s liquor supply in an online inventory template. Once you’ve entered supply details into your spreadsheet, you can organize the entries by alcohol type, proof, price, quantity, or age. You can then seamlessly track which brands you need to stock up on, and which brands may not be selling very well.

Need to change the layout of this Liquor Inventory Spreadsheet? Customize it in just a few clicks by adding new labels, columns, or tabs to better organize your information. You can even sort entries with colored labels, to more quickly identify important information by eye! Organizing your liquor supply at work doesn’t have to be a pain — with our free Liquor Inventory Spreadsheet, you can easily add new products, track existing ones, and perform stock takes faster than ever before.

More templates like this

Preview: Product Inventory Template
Product Inventory Template

Record and monitor the amount of products your company has available. Keep inventory info in an easy-to-read spreadsheet you can view and edit on any device.

Inventory Templates

Preview

Preview: Equipment Inventory Template
Equipment Inventory Template

Improve your equipment inventory management. Organize inventory data in a free, easily-accessible spreadsheet. Edit and view on any device. No coding required.

Inventory Templates

Preview

Preview: Order Tracker
Order Tracker

Track orders for your business online. Free order tracking table template. Switch between table, calendar, or card view. Easy to customize. No coding.

Inventory Templates

Preview

Liquor Bar Inventory Template FAQs

1) Why is a liquor bar inventory template used?

A bar inventory template is a document used by any establishment that serves alcohol to organize and track inventory. Bar managers use bar inventory templates to ensure they have enough supplies on hand, prevent overstocking, and reduce waste. Inventory sheets can keep costs down and ensure that bars have all the items they need to function efficiently.

2) What should be included in a liquor bar inventory sheet?

A liquor bar inventory sheet should include columns for the following elements:

  • Item name
  • Amount of each item currently in stock
  • Item expiration date
  • Item cost
  • Any additional comments
  • Staff member who took stock
  • Date

3) When should I use a liquor bar inventory template?

A bar inventory template should be used regularly to keep track of your bar’s stock levels. Inventory can be taken daily, weekly, biweekly, or monthly, depending on the size of the bar and the volume of sales. Taking inventory before placing new orders is also beneficial to ensure that all needed items are restocked.

4) Who can use a liquor bar inventory template?

A liquor bar inventory template can be used by anyone involved in the management and operation of a bar. This includes managers, bartenders, and other staff members.

5) How can I create a liquor bar inventory sheet with Jotform?

Creating a liquor bar inventory table with Jotform is quick and easy. Start by logging into your Jotform account. Go to My Tables and click Create Table. Choose whether you’d like to start from scratch or use one of our ready-made table templates.

After you choose how you’d like to build your table, you can customize your inventory table to your liking — organize and add columns and rows, add formulas and calculations, and more. Once you’re satisfied with the look and feel of your liquor bar inventory table, share it with your staff members for easy access.

6) What are the benefits of using a liquor bar inventory template?

Using a liquor bar inventory template offers several benefits:

  • It allows your bar to conveniently track inventory from any device.
  • It saves you time by automating data entry.
  • It prevents overstocking and understocking items.
  • It provides valuable information on what drinks and ingredients are most popular at your bar.

Inventory Templates

`;if(isCheck(elm)){elm.parentElement.insertAdjacentHTML('beforeend', htmlMarkup);}}

Inventory Templates

17 Templates

Preview: Product Inventory Template
Product Inventory Template

Record and monitor the amount of products your company has available. Keep inventory info in an easy-to-read spreadsheet you can view and edit on any device.

Inventory Templates

Preview

Preview: Equipment Inventory Template
Equipment Inventory Template

Improve your equipment inventory management. Organize inventory data in a free, easily-accessible spreadsheet. Edit and view on any device. No coding required.

Inventory Templates

Preview

Preview: Order Tracker
Order Tracker

Track orders for your business online. Free order tracking table template. Switch between table, calendar, or card view. Easy to customize. No coding.

Inventory Templates

Preview

Preview: Book Inventory Template
Book Inventory Template

Record the amount of books currently available at your bookstore or library. Display information in an easily accessible spreadsheet. No coding required.

Inventory Templates

Preview

Preview: Restaurant Inventory Template
Restaurant Inventory Template

Keep better track of your restaurant’s ingredients and equipment. Take inventory in a beautifully-plated spreadsheet you can edit and view on any device.

Inventory Templates

Preview

Preview: Liquor Inventory Spreadsheet
Liquor Inventory Spreadsheet

Keep track of your stock with a free online Liquor Inventory Spreadsheet. Organize by alcohol type, age, price, proof, and more. Great for bars or restaurants!

Inventory Templates

Preview

Preview: Art Inventory Template
Art Inventory Template

Catalog your artwork with this easy-to-use spreadsheet. Customize without coding. Access on any device. Perfect for gallery owners, curators, and artists.

Inventory Templates

Preview

Preview: Asset Inventory Template
Asset Inventory Template

Improve your asset inventory management system with an online Asset Inventory Template. View all items in a professional spreadsheet. Customize in seconds.

Inventory Templates

Preview

Preview: Beauty Supply Store Inventory List
Beauty Supply Store Inventory List

Manage inventory and orders for your beauty supply store. Free online table template. Easy to customize, download, and share. Works on any device. No coding.

Salon

Preview

Preview: Home Inventory Template
Home Inventory Template

Keep track of items at home with our free Home Inventory Spreadsheet. Add descriptions and photos of furniture, appliances, electronics, and more!

Inventory Templates

Preview

Preview: Office Inventory Template
Office Inventory Template

Keep track of office supplies with this free Office Inventory Template. Manage items, serial numbers, and dates of purchase in a professional spreadsheet.

Inventory Templates

Preview

Preview: Bar Inventory Template
Bar Inventory Template

Track equipment, furniture, food, and beverages in your bar with an online Bar Inventory Template. Organize info in a clear spreadsheet. Free to use and customize!

Inventory Templates

Preview

Preview: Furnished Rental Inventory Checklist
Furnished Rental Inventory Checklist

Keep track of items in your rental properties with a free Furnished Rental Inventory Checklist. Great for real estate agencies and landlords. Easy to customize.

Real Estate

Preview

Preview: Food Waste Log Sheet
Food Waste Log Sheet

Food Waste Log Sheet is a sheet used by restaurants, catering companies, schools, cafeterias and all other businesses to control food waste. Feel free to fully customize this template. No coding.

Nonprofit

Preview

Preview: Supermarket Price Tracker Template
Supermarket Price Tracker Template

Track supermarket product prices across multiple stores with this free spreadsheet table. Easy to customize and share. Download on any device. No coding.

Checklist Templates

Preview

Preview: Personal Property Sheet
Personal Property Sheet

A Personal Property Sheet is used to collect the information of the owner's belongings in the house and to list the details about these items. You can customize this sheet without coding features!

Inventory Templates

Preview

Preview: Pantry Inventory Template
Pantry Inventory Template

Track and manage the food you have in your kitchen. Avoid overshopping and see what you’re out of at a glance. Works on any device. Customizable without coding.

Inventory Templates

Preview

About Inventory Templates

An inventory template is used to record and monitor items, either at work or at home. So whether you’re keeping track of supplies at the office or items in your home, get organized with our free online inventory templates. No more writing out inventory lists or stock takes by hand — simply enter inventory info into your chosen inventory record form or online spreadsheet and view the information in an easy-to-read format. All data is stored securely in your Jotform account, making it accessible no matter where you are.

Don’t see an inventory template that matches your needs? No worries! Just customize one of the spreadsheets below by adding new tabs, columns, or color-coded labels, and you’ll soon have the design you’re looking for — with no coding required. By taking your inventory spreadsheets online with one of our readymade inventory templates, you can eliminate messy paperwork, better manage your inventory, and easily view all of your items’ information in a professional spreadsheet format.

Liquor Inventory Sheet Template | Jotform Tables (2024)

FAQs

How to do inventory count on liquor? ›

Tenthing is the traditional method in which the person conducting the inventory count picks up or eyeballs a bottle to estimate how full it is to the nearest tenth. For example, the bottle that looks a third of the way full will be recorded on a clipboard as 0.3.

How do you format an inventory list? ›

At its simplest, an inventory list is formatted as a grid; each row contains a single item and its details, which are specified by the columns. Column labels typically include an item's name, its SKU, its unit price and quantity in stock.

How to make an inventory spreadsheet in Excel? ›

How to create an Excel inventory spreadsheet
  1. Create a spreadsheet. To create a new spreadsheet, you can open Excel, click on "Menu", and select "New". ...
  2. Add product categories as columns. ...
  3. Add each product to the spreadsheet. ...
  4. Adjust quantities as the company's products change.
Feb 12, 2024

How to keep track of liquor inventory? ›

How to take a liquor inventory
  1. Follow a consistent method. ...
  2. Set a dedicated time for inventory counting. ...
  3. Keep a record of inventory received since last count. ...
  4. Count inventory at the front bar. ...
  5. Use the “tenthing” counting method. ...
  6. Repeat inventory for back bar and storage. ...
  7. Calculate the final numbers.

Does Google Docs have an inventory template? ›

Google Sheets Physical Inventory Count Template

This streamlined template helps you account for every item in any type of physical inventory and enables you to list, track, and manage inventory items by name, number, location, and order history.

What are the 4 types of inventory? ›

The four types of inventory most commonly used are Raw Materials, Work-In-Process (WIP), Finished Goods, and Maintenance, Repair, and Overhaul (MRO).

How to use Google Forms for inventory? ›

How to use Google Forms for inventory management
  1. Open Google Sheets and create a new sheet.
  2. Name your spreadsheet and list your inventory.
  3. Add your current inventory numbers.
  4. Go to the Tools menu and select Create a New Form.
  5. Add the data fields you need to track.
  6. Click on the three vertical dots to add a Response validation.
Aug 14, 2024

How do you conduct an inventory count? ›

The Physical Inventory Counting Process
  1. Assign maps, inventory to-be-counted printouts, and equipment to staff.
  2. Staff counts the assigned inventory.
  3. Staff fills out spreadsheets or count tags.
  4. Staff returns the spreadsheets or count tags to the managers. ...
  5. Managers enter the data into the inventory system.
Aug 25, 2020

How do you calculate liquor cost from inventory? ›

You can calculate your restaurant's liquor cost by adding up your beginning inventory for a specific period and any additional inventory purchases you made during that period, and then subtracting your ending inventory from this number. The average pour cost percentage is considered to be between 18% to 24%.

How do I calculate my inventory? ›

The formula can be expressed as: Beginning Inventory = Sales (COGS) + Ending Inventory - Purchases (inventory added to stock). For example, if a company had $450,000 in sales/COGS, $600,000 in ending inventory, and $300,000 in purchases, then its beginning inventory would be $750,000 (450,000 + 600,000 - 300,000).

References

Top Articles
Latest Posts
Article information

Author: Gov. Deandrea McKenzie

Last Updated:

Views: 6011

Rating: 4.6 / 5 (46 voted)

Reviews: 85% of readers found this page helpful

Author information

Name: Gov. Deandrea McKenzie

Birthday: 2001-01-17

Address: Suite 769 2454 Marsha Coves, Debbieton, MS 95002

Phone: +813077629322

Job: Real-Estate Executive

Hobby: Archery, Metal detecting, Kitesurfing, Genealogy, Kitesurfing, Calligraphy, Roller skating

Introduction: My name is Gov. Deandrea McKenzie, I am a spotless, clean, glamorous, sparkling, adventurous, nice, brainy person who loves writing and wants to share my knowledge and understanding with you.