Bar Waste, Complimentary Drinks & Staff Drinks Cost Tracker
What it is
A practical daily cost leakage log plus reporting dashboard for bars. Log Waste, Comps, and Staff Drinks in seconds, link each event to a real unit cost, approve it, then review leakage by week with a report, dashboard, and print ready A4 summary.
What it solves
Most venues lose margin through small losses that never get measured. If events are not costed and not approved, nobody sees the real drivers and the same problems repeat. This toolkit makes leakage visible by type, reason, item, outlet, and staff member, with actions and due dates to close issues. It helps surface recurring leakage before it turns into silent margin loss, weak controls, or repeated staff and process issues.
Why teams use this tracker
-
Assign a real cost to every event so losses stop being invisible
-
Use an approval gate so only verified events feed reporting
-
Rank leakage by staff, item, reason, and outlet to find the real drivers
-
Run faster weekly reviews with a cleaner auto sorted report
-
Catch missing costs and bad inputs before they distort your review
Best for: bars that want tighter control over comps, wastage, and staff drinks with a simple weekly review rhythm.
Not for: buyers looking for a fully custom operations consulting service instead of a structured ready to use leakage tracking system.
Select a package
Compare the options below before choosing the right fit.
Packages and turnaround
Starter
(Instant download)
You receive the template with:
-
Setup + Item Master + worked example
-
Drop-down lists and built-in status checks
-
Dashboard + Cost Leakage Report ready out of the box
-
Best if the venue can self-input staff and items.
Best for teams that want the full tracker ready to use and prefer to manage their own staff and item inputs internally.
Standard
(2 days delivery)
Template setup for your venue plus validation:
-
Outlet names, staff list, default reporting dates, targets and alerts configured
-
Item Master structured to your categories and costing method (manual or pack)
-
UoM conversions checked (ml, oz, g, kg, ea, dash with editable dash size)
-
Quick QA pass to prevent the most common “missing cost / wrong UoM / inactive item” errors delivered as a clean ready-to-use file.
Best for venues that want cleaner setup, validated inputs, and a more reliable rollout from the start.
Advanced
(4 days delivery)
Done-for-you build:
-
You send staff list, outlet names, and item list (pack sizes, pack prices, unit costs, yield loss if needed)
-
Template returned fully mapped, validated, and ready for live logging
-
Short action summary included: top drivers, high-cost events, and the first process fixes to implement this week
Best for operators who want faster implementation, less setup work, and clearer action focused outputs.
What’s inside
-
Setup sheet with targets and alerts (total leakage alert, leakage % of sales target, driver alert threshold)
-
Staff list with period cost and rank (accountability by person)
Item Master that supports:
-
Manual unit cost OR pack-costing that calculates true unit cost automatically
-
UoM conversions (including configurable dash size)
-
Optional yield loss %
-
Automatic “item cost status” flags (missing pack info, missing manual cost, inactive)
Daily Log (up to 500 events) including:
-
Waste / Comp / Staff Drink type
-
Reason, item, qty, UoM
-
Auto unit cost lookup plus optional override
-
Manager approval (only approved rows are reported)
-
Status flags (incomplete, unknown item, missing cost, check UoM, pending)
-
Action tracking: action taken, owner, due date, close date, close notes
-
“Open high-cost” logic for events above your threshold with no action logged
Cost Leakage Report (auto-summary for selected dates)
-
Total leakage, by type, by reason
-
Top items and top staff (with type filter)
-
Missing cost and pending approval counters
Dashboard
-
Period snapshot KPIs, alert checks, open actions and open cost
-
Top drivers (items and staff) with alert flags
-
8-week leakage trend (total plus split by type)
Each section is designed to make daily logging and weekly leakage review clearer, faster, and easier to repeat.
License & Support
This toolkit is licensed for internal use by a single user or business. It is designed to be practical, ready to use, and easy to adapt within your own operation, but it may not be resold, redistributed, shared outside your business, or repackaged for resale. If you need help with setup, formulas, or functionality, support is available for reasonable usage-related questions. Any genuine technical issue will be reviewed and corrected where applicable.
Delivery format
This toolkit is delivered as a single ZIP download. Inside the ZIP you will find:
• Excel master workbook (.xlsx)
• Google Sheets import file (.xlsx)
• README import checklist (step by step)
• PDF User Guide (Quick Start + workflow notes)
After purchase, you receive a clear ZIP download with the workbook, import file, and guide, so setup feels straightforward from the start.