From Manual Reporting to Daily Financial Clarity: A Zürich Bar's Story
Consolidating multiple payment channels into a single, automated Excel-based KPI dashboard to eliminate month-end reporting delay.
Independent Bar & Lounge
Zürich, Switzerland (Anonymous)
Hospitality, Food & Beverage
Reporting Time: Days to Minutes
Excel, Formulas, SumUp/Twist Integration
Cash Flow Visibility
Month-End Reporting Work
Budget vs. Actual Tracking
The Challenge
A popular independent bar in Zürich, Switzerland, was struggling to manage its day-to-day finances due to highly fragmented transaction data.
The business accepted multiple payment platforms, including Twint and SumUp. With no unified view, the owner spent days at the end of each month manually compiling numbers.
As a result, decisions regarding inventory, labor, and budget adjustments were made entirely on gut feel. The owner had no foresight into weekly margin percentages or critical cash flow leaks.
What We Did
Built a Consolidated Payment Tracker
Created a custom Excel financial workbook that automatically extracts and cleans data files from Twint, SumUp, and cash reports, rendering them into a single, unified view.
Designed a Live KPI Dashboard
Implemented daily and weekly trackers for sales velocity, cost of goods sold (COGS %), and margin tracking per product category (beer, cocktails, spirits, wine, and snacks).
Created Budget vs. Actual Forecasting
Engineered a dynamic cash flow forecasting dashboard that flags margin anomalies in real time, allowing the business owner to react immediately before month-end reviews.
"We finally know where we stand every morning. No more surprises at month-end. The Excel tracker consolidates our Twint and card sales automatically, giving us back hours of accounting work."
Running a bar, restaurant, or café in Switzerland?
Let's build your numbers dashboard. Contact us to streamline your Twint, card system, and labor reports into clean daily visibility.