Cosmovex/tools

Count bar and restaurant stock by scanning bottles, with a price per item

Bar stocktake with Scanlist

This page opens in Add quantity mode with Location and Price columns suggested and Excel as the first export, for a stocktake of bottles, cans and kitchen goods. Scan each product once, set the quantity you counted, and export a list that can be multiplied by price in Excel.

  1. Name the list after the area and the date, for example Back bar 21 Nov, and set its default Location (Pro).
  2. Scan the barcode on a bottle or case. Scanning another of the same product adds 1.
  3. For a partly used bottle, add a note such as 0.5 or Open.
  4. Set the Price (Pro) for items that do not have one in your system, or add it after export.
  5. Export to Excel and multiply quantity by price to get the stock value.
bar stocktake app bottle count scannerrestaurant stock take phonescan bottles to excelliquor inventory count app
Open Scanlist Free to start · no account

What to know

A bar stocktake is a counting job: the same product is on the back bar, the fridge and the store room, and the totals matter more than where each bottle is. Scan one bottle per product per location and type the rest as the quantity, or scan every bottle for an exact count; repeat scans add 1 either way. A different Location per list keeps the areas separate in the export.

Bottle barcodes are EAN-13 or UPC-A on most spirits, wine and soft drinks, and cases often carry a separate ITF code, so decide whether you count bottles or cases and stay with it. Codes are saved as text, and with Pro the Excel file can use number and date cells so the quantity and price columns can be summed straight away. Free scanning is unlimited; three exports a day include 25 rows each, and Pro removes the row limit.

Pro Compare checks the count against an expected-stock CSV from your till or stock system, listing what is missing, short, over or extra, which is where a shortage shows up. Export the expected quantities with a code column and a quantity column, count the same products, and the lines that differ are the ones to chase before the next order goes in.

Updated · Cosmovex

Questions

Can I record half-empty bottles?

Type the amount in the row's note, for example 0.5, or count full bottles in the quantity and list open ones as separate rows with a note. The list does not calculate volumes.

Does it contain prices and stock value?

With Pro you can add a Price column and a default per list. The export is a plain table, so multiply quantity by price in Excel to get the value.

What about items with no barcode, like loose produce?

Type a short name or code in the box under the scanner and press Add, then set the quantity. It becomes a row like any scanned one.

Can the count be compared with last month?

Export each month's count and compare them in Excel, or use Pro Compare with last month's export as the expected-stock CSV; it matches by code.

The free plan covers everything on this page. Scanlist Pro ($5/mo, billed monthly) is described on the Scanlist page.