Bar Waste, Complimentary Drinks & Staff Drinks Cost Tracker
Use one structured workflow to make small losses visible before they turn into recurring margin leakage. Built with a daily log, approval gate, auto-sorted reporting, action tracking, dashboard, and print-ready A4 summary for easier weekly review.
“Clean, straightforward, and useful for turning messy daily incidents into something the team can actually review."
Emma J. | Hospitality consultant
The problem it solves
Most venues do not lose margin through one big mistake. They lose it through small losses that never get measured properly.
If waste, comps, and staff drinks are logged inconsistently, not linked to real costs, or never approved, nobody sees the real drivers. The same issues repeat, the same people or processes stay unchecked, and leakage becomes normal instead of visible.
This toolkit helps standardise daily logging and weekly review, so losses can be tracked by type, reason, item, outlet, and staff member before they turn into silent margin erosion, weak controls, or repeated team issues.
How it works
Add your staff list, item list, outlet names, and cost data. Then log each waste, comp, or staff drink event with quantity, reason, unit of measure, and approval status.
The file pulls the item cost, flags incomplete or incorrect entries, and feeds approved rows into a report and dashboard that highlight total leakage, top drivers, missing costs, pending approvals, and open actions.
That gives you a clearer weekly review workflow and a faster view of where losses are coming from, who is involved, and what needs follow-up first.
Best for
Bars, beverage managers, venue operators, and consultants who want tighter control over waste, comps, and staff drinks through a simple daily log and weekly review rhythm.
Choose the right version
Both options use the same core toolkit. The difference is how much setup work you want to handle yourself.
Instant Download
You receive the full tracker with setup sheet, item master, worked example, drop-down lists, built-in checks, dashboard, and cost leakage report ready to use.
Add your own staff, items, and events, then use the tracker internally to log, approve, and review daily leakage with a cleaner workflow.
Best for teams that want the full tracker ready to use and prefer to manage staff and item inputs internally.
Includes:
-
instant download
-
Excel workbook + Google Sheets import file
-
setup sheet, item master, and worked example
-
drop-down lists and built-in status checks
-
dashboard and cost leakage report
-
support files
Done for You Setup (4 days delivery)
A done-for-you version built from your real venue data.
You send your staff list, outlet names, and item list with pack sizes, pack prices, unit costs, and yield loss where needed. The tracker is returned mapped, validated, and ready for live logging, with a short action summary highlighting top drivers, high-cost events, and the first process fixes to implement.
Best for operators who want faster implementation, less setup work, and clearer outputs for action.
Includes:
-
everything in Standard
-
done-for-you build
-
your staff, outlet, and item data structured into the file
-
ready-to-log tracker setup
-
validated cost and unit structure
-
short action summary
-
top driver visibility
-
high-cost event review
-
first process-fix priorities
What’s inside the toolkit
-
Setup sheet with targets and alerts
Controls total leakage alert, leakage as a percentage of sales target, and driver alert thresholds. -
Staff list with period cost and rank
Adds clearer accountability by person. -
Item Master with two costing methods
Supports manual unit cost or pack-costing that calculates true unit cost automatically. -
UoM conversions
Handles ml, oz, g, kg, ea, and dash, with editable dash size. -
Optional yield loss %
Adds flexibility where actual usable cost differs from purchase cost. -
Automatic item cost status flags
Helps catch missing pack info, missing manual cost, or inactive items. -
Daily Log for up to 500 events
Tracks waste, comps, and staff drinks in one place. -
Event fields by type, reason, item, quantity, and UoM
Makes daily logging cleaner and easier to review later. -
Auto unit cost lookup with optional override
Links each event to a real cost while allowing controlled adjustments. -
Manager approval gate
Only approved rows feed reporting. -
Status flags
Highlights incomplete rows, unknown items, missing costs, UoM issues, and pending approvals. -
Action tracking
Logs action taken, owner, due date, close date, and close notes. -
Open high-cost logic
Flags higher-cost events above your threshold when no action is logged. -
Cost Leakage Report
Summarises total leakage, leakage by type and reason, top items, top staff, missing costs, and pending approvals for selected dates. -
Dashboard
Shows period snapshot KPIs, alert checks, open actions, open cost, top drivers, and an 8-week leakage trend split by type.
Each section is built to make daily logging and weekly leakage review clearer, faster, and easier to repeat.
License & Support
This toolkit is licensed for internal use by one user or one business.
It may not be resold, redistributed, shared outside your business, or repackaged for resale.
Reasonable support is available for setup, formulas, and functionality questions. Genuine technical issues will be reviewed and corrected where applicable.
Delivery format
This toolkit is delivered as a ZIP download.
Inside the ZIP you will find:
-
Excel master workbook (.xlsx)
-
Google Sheets import file (.xlsx)
-
PDF quick-start guide
-
Overwrite-ready example menu
-
For the configured version, setup support is included as described above.
Customer feedback
Review requests are sent after purchase.
Feedback may be checked before publication.