Your first stock take.
One shelf at a time.
Start with the bottle story below. Then follow five simple steps to count your drinks and understand their costs.
Watch it work · Set up · Count · Monthly numbers · COGS example · Finish & export
Watch: from shelf to stock cost
One bottle costs $10. This is a made-up example, not your inventory.
Bottles that leave the shelf become stock cost. Buying more bottles adds stock; it does not mean you used them. This example has no spills. In your real counts, we cannot tell sales from unexplained loss without a separate usage record.
1. Set up your inventory items
- Create your business account. Once approved, company owners use their email and company password to open the locations dashboard. Location staff use their own location username and password.
- Select the correct month before entering numbers.
- Add an item: name, category, bottle or can, unit cost, case size and target stock. For bottles, enter the full contents measurement and its unit. You can edit items later.
Categories are Beer, Wine, Spirits, Bottled Water, and NA Cans and Bottles. Choose the right category so each group gets its own COGS percentage.
Unit cost means the purchase cost of one full bottle or one can, not its selling price or the whole case price. A $48 case of 24 cans costs $2 per can. Use one currency throughout; changing the currency label does not convert amounts.
2. Count what is actually on the shelf
One full bottle = 1 point. Count sealed bottles, then enter the measured remainder of each open bottle. Stocktails converts the remainder into a fraction of a full bottle.
Example: 3 full bottles plus 7 oz left in a bottle with 35 oz of full contents = 3 + 7 ÷ 35 = 3.20 points. This is a measurement example; use your item's real full measurement.
If weighing a bottle including the glass, use the empty bottle weight so it can be subtracted. Use matching units for the empty bottle, full contents and remainder. Fluid ounces measure volume; weight ounces and grams measure weight.
Cans count individually: 2 cases of 24 plus 5 loose cans = 53 cans. Full water bottles also count as whole bottles.
On your phone, use Walk-around count. Choose a start-of-month or end-of-month count, then select a category. Tap +/− or type the full-bottle or can number, then Save & next. Have an open bottle? Tap the remainder button and enter its measurement. Use “Only show items still to count” to finish missed products. Wait for the online save before moving on.
Enter 0 when you checked and there is none. Leave an item uncounted when you have not checked it. Skipping an item is not a zero count. Counting requires Wi-Fi or mobile data.
3. What goes in each box
| Field | What to enter / what it means |
|---|---|
| Opening quantity | What you had at the start of the month. Count bottles and their remainders, or whole cans. |
| Received orders | All deliveries received during the month. Enter quantities, not money. Convert cases using the case size. |
| Usage | Usually leave this blank—we work it out from your counts. Only fill it in if you have a separate record of drinks used. Enter quantities, not sales money. |
| Spillage | Quantity spilled or wasted, in points or cans. It is already included in depletion and COGS. |
| Ending quantity | What is left when you count at the end of the month. |
| Target stock | How much you want to keep on the shelf. It helps plan your order and does not change your stock cost. |
| Unit cost | Purchase cost per full bottle or can used to value that month's stock. This is not a weighted average of differently priced deliveries. |
| Category sales | The money you made selling each drink group this month. Get this from your till report and use the same currency as your costs. |
| COGS | (Opening + Received − Ending) × Unit cost. |
| Ending total value | Ending quantity × Unit cost. |
Discrepancy: if you enter usage, expected ending = opening + received − usage − spillage. Actual ending minus expected ending is the variance: negative means short, positive means extra.
Without independent usage, counts can calculate depletion but cannot tell you how much was sold versus lost. Check your counts and deliveries when ending exceeds available stock. Incomplete or invalid counts need fixing before relying on the totals.
4. Try a COGS example
Purchases and COGS cover different things. Purchases are what arrived this month. COGS is the cost of stock that left inventory, including older stock, spillage and unexplained loss.
This practice calculator does not save or change your inventory.
Category COGS % = category COGS ÷ category sales × 100. Beer, Wine, Spirits, Bottled Water, and NA Cans and Bottles each have their own percentage. The overall percentage is total COGS divided by total sales—not an average of the category percentages. Missing or zero sales cannot produce a meaningful percentage.
5. Finish the month and export
- Complete all opening and ending counts, received orders and spillage.
- Enter each category's monthly sales and review any discrepancies or invalid quantities.
- Check the save status says your inventory is saved online before leaving.
- Export Excel for the formatted Monthly Summary and Inventory sheets, including COGS percentage columns. Editing the exported file does not update the website.
- Start the next month to carry ending stock into its opening count. Changing the month selector only switches your view; it does not move a month's entries.
Use JSON backup for a full backup. Importing a backup replaces the shared inventory for that business, so review it before confirming.
Quick answers
Why is my COGS different from what I bought?
In the example above, you bought $480 of stock but used $350 of stock. The $230 left on the shelf remains inventory. Opening stock was $100: $100 + $480 − $230 = $350 COGS. COGS includes stock from previous purchases too.
Do I add spillage cost on top of COGS?
No. Spilled stock is already missing from the ending count, so its cost is included in COGS. The separate spillage cost shows how much of COGS was waste.
Can my team count the same inventory?
Yes, your team uses its location login. Each location has its own inventory. Company owners can switch between their locations from the dashboard; location staff cannot open other locations. If someone saves a newer version while you are editing, Stocktails asks you to resolve the conflict instead of overwriting their work. Preserve your draft, reload the latest inventory, and re-enter your changes.
Can I put it on my phone's home screen?
On iPhone, open your inventory in Safari, use Share, then Add to Home Screen. On Android, use Chrome's Install app or Add to Home Screen option. You still need an internet connection to save counts.
How do I get help?
Email tshipster@gmail.com with your business name, month and the issue. Never send your password.