Beverage KPI Dashboard Toolkit
A practical digital KPI dashboard to track beverage sales, Actual COGS, Theoretical COGS, variance, gross profit, sales mix and category performance in one executive view.
Combine POS sales data, inventory-based COGS and item costing to review real beverage performance.
Track Net Sales, COGS %, Gross Profit, Gross Margin, variance, sales mix and Data Quality Score.
Includes Excel workbook, Google Sheets import file, PDF guide, POS mapping, menu engineering, bridge analysis and print summary.
Trusted by bartenders, consultants & hospitality teams worldwide
AT A GLANCE
Format
Excel, Sheets and PDF files
Delivery
Instant access after purchase
Price
$9.90 One-time purchase​
Support
Email support included
Works On
Desktop, tablet and mobile
The Beverage KPI Dashboard Toolkit is a practical digital workbook designed to help bars, restaurants, hotels and beverage teams review beverage performance through sales, COGS, gross profit, variance and sales mix data.
It connects POS sales exports, inventory-based Actual COGS, item-level Theoretical COGS, KPI targets, category performance, price checks and prior-period comparisons in one structured dashboard.You receive a complete beverage KPI dashboard toolkit with an Excel workbook, a Google Sheets import version, a PDF user guide and Google Sheets import instructions.
Many beverage programs look profitable from sales alone, but the real picture changes when Actual COGS, theoretical cost, variance and sales mix are reviewed together.
This toolkit helps you see where money is being made, where margin is leaking, which categories need attention and whether your data is reliable enough to support operational decisions.You can use this toolkit to review weekly or monthly beverage performance, compare sales with inventory-based COGS, identify variance by category, monitor sales mix and prepare executive summaries for owners, managers or clients.
It is also useful for beverage audits, menu reviews, cost-control meetings, consulting projects, pricing checks, POS cleanup, period-over-period analysis and action planning for the following week or month.Start in Setup by entering venue name, currency, reporting period, outlets, categories and KPI targets. Then paste POS sales data into Sales Data using date, item name, category, units and net sales.
Enter beginning inventory, purchases, transfers and ending inventory by category inside Inventory COGS. Add item-level cost per serve in Item Costing, or use the Pour Cost Translator to calculate cost per pour for spirits, wine, beer or other simple pours.
The Dashboard combines sales, Actual COGS and Theoretical COGS to calculate KPI cards, category performance, variance, sales mix, action priorities and Data Quality Score. Use POS Mapping to clean messy POS names, Bridge to compare periods and Print Summary to export a clean executive view.Best for bar owners, beverage managers, general managers, hotel F&B teams, restaurant groups, head bartenders, consultants and operators who need a clearer view of beverage performance.
It is especially useful for venues that want to control COGS, understand variance, review category profitability, clean up POS data, prepare management reports and move from opinions to numbers in beverage decision-making.
_edited.jpg)
BUILT FROM REAL BAR OPERATIONS
Created by Riccardo Grechi, working head mixologist, bar consultant & trainer.
The Double Strainer is built by Riccardo Grechi, an Italian head mixologist, bar consultant and trainer with 10+ years of hands-on experience across Europe and Southeast Asia. His work combines cocktail R&D, menu engineering, cost control, SOP development, training and beverage-program design, with a focus on practical systems that can be used in real service, not just theory.
10+ years of bar and hospitality experience
Award-winning head mixologist
Menu development, training & operations systems
Luxury hotel, cocktail bar & multi-venue experience
Founder of The Double Strainer, read by 30,000+ people yearly
WHAT'S INSIDE
Ready-To-Use Files
Includes an Excel workbook, Google Sheets import file, PDF user guide and import notes, ready to adapt to your beverage sales, COGS and reporting workflow.
Practical Tools
Use POS sales input, inventory COGS, item costing, pour cost translation, price reference checks, POS mapping, menu engineering, bridge analysis and print summaries.
Real Examples
Includes demo sales data, category structures, costing examples, action prompts and dashboard outputs, so you can understand the workflow before entering your own venue data.
Operational Checks
Data Quality Score, mapping checks, price integrity tools and variance outputs help you identify unreliable data, margin leaks, POS issues and categories that need review.
WHAT BAR PROS ARE SAYING
A practical tool for consulting and cost-control work. It turns POS and inventory numbers into a clearer dashboard that owners and managers can actually discuss.
Gino P.
Food & Beverage Manager
This toolkit gave us a clearer and more professional way to organize our bar work. It is practical, easy to follow, and useful from the first time you open it.
Sophie C.
Beverage Operations Manager
A very well-structured resource for anyone who wants better systems behind the bar. It saves time, reduces confusion, and makes daily operations easier to manage.
Daniel B.
Hospitality Consultant
What I liked most is that it feels built for real hospitality work. Clear files, practical guidance, and a structure that can actually be used in a working venue.
Elena M.
Head Bartender
FAQ
Yes. The toolkit is designed to be practical and easy to follow, even if you are not an advanced spreadsheet user. It is most useful when you have a real bar, menu, project or operation to organize.
Yes. I also offer a done-for-you service where I can fill in the toolkit with your venue data, recipes, prices, suppliers, stock levels or operational details. This is a separate custom service and can be requested after purchase or before buying. Contact me to have more info about this service.
No, but basic hospitality or beverage knowledge helps. The toolkit gives you structure, prompts and examples so you do not have to build the system from zero.
After purchase, you receive access to the digital files or download page. Delivery details are provided after checkout and by email.
This is a digital toolkit, not a live class. It is a practical set of files, templates, calculators, guides or checklists that you can use at your own pace.
Where editable files are included, yes. You can adapt them to your venue, recipes, prices, suppliers, stock levels, team or workflow. PDF files may be intended for reading or printing only.
Many files can be viewed on mobile, but desktop or laptop use is recommended, especially for spreadsheets, dashboards and operational files with multiple tabs.
Yes. The toolkit is designed for practical use in bars, restaurants, hotels, cafés, event operations, beverage programs and consulting projects.
No. The toolkit gives you a strong operational structure, but it does not replace a tailored consulting project, full venue audit, custom menu build or team training program.
Yes. Custom versions, additional currencies, extra sheets, translations, layout changes or venue-specific adjustments can be requested separately, depending on the project.
No. The files are for use inside your own business, team or client project. They cannot be resold, redistributed, republished or presented as your own product.