SnapFindBusiness

Bars and restaurants

Free bar inventory template

Count bottles by location — back bar, well, storeroom — with what each one cost you. The same sheet works for a weekly count.

Use this template in SnapFind
Excel (.xlsx)CSV

Free. No sign-up to download.

What's in the template

9 columns and a few example rows to replace with your own.

Name✨Category✨SpaceContainerQuantity✨Value (each)✨Tags✨Barcode/UPCNotes
Vodka, 1 LKitchen & Food Storage🍸 BarWell414spirits—Par 6
Bourbon, 750 mlKitchen & Food Storage🍸 BarBack bar228spirits——
Tonic water, 12 packKitchen & Food Storage📦 StoreroomMixers59mixers——
Lime juice, 1 LKitchen & Food Storage🍸 BarCooler36mixers—Use within 7 days of opening

Example rows. ✨ = SnapFind fills this column from a photo.

Starts you with

"Use this template in SnapFind" creates these spaces and containers in your account. Anything you already have with the same name is reused.

  • 🍸 Bar

    • Back bar
    • Well
    • Cooler

  • 📦 Storeroom

    • Liquor shelf
    • Mixers

How to use it

  1. 1Put your par level in Notes, like "Par 6".
  2. 2Value (each) is your cost per bottle, not the menu price.
  3. 3Scan the bottle barcode into Barcode/UPC once and later counts are a scan.

AI shortcut

Skip the typing

Photograph a shelf in the SnapFind app and every item it sees becomes a row. The columns marked ✨ fill themselves.

In this template, a photo fills:

  • Name
  • Category
  • Quantity
  • Value (each)
  • Tags

Values are AI estimates you can change. You add the rest, like serial numbers and dates, only where you need them.

Import it into SnapFind

  1. 1

    One click

    Choose "Use this template in SnapFind". The spaces and containers are created in your account, ready to fill from your phone.

  2. 2

    Or bring the sheet

    Fill in the template, save it as CSV, and import it in the SnapFind app under Settings → Import Data. Every column is recognised; there is nothing to map.

  3. 3

    Then label it

    Print a QR label for each container. Anyone on your team can scan it to see what is inside.

Use this template in SnapFind

Questions

Should open bottles be counted?
Most bars count full bottles as whole numbers and note open ones separately. Keep one row per product and use Notes for partial bottles.
Are these templates free?
Yes. Download as many as you like; there is no sign-up and no email required.
Do they work in Excel and Google Sheets?
Yes. The .xlsx file opens in Excel, Google Sheets and Numbers. The CSV opens anywhere and is the file SnapFind imports.
How do I import a filled-in template into SnapFind?
Save it as CSV, then open the SnapFind app and go to Settings → Import Data. The column names already match, so the import starts straight away.

More templates

All templates