One platform for
11 venues

Case Study Hospitality

How Northern Collective unified their multi-site hospitality group with real-time sales intelligence, automated P&L reporting, and AI-powered business insights.

11
Venues
15min
Sync Cycle
12
Integrations
See how we did it
The Client

Northern Collective

Northern Collective is a Sheffield-based hospitality group operating eleven distinctive venues across the Peak District and South Yorkshire. From premium gastropubs to artisan coffee houses, each venue maintains its unique character while benefiting from centralised management oversight.

Multi-Location Operation

11 venues including pubs, restaurants, coffee shops, and a visitor centre

Two Legal Entities

Bank House Bar & Restaurant Ltd and Castleton Coffee Co. Ltd

Diverse Team Structure

Directors, general managers, and front-line staff across all venues

Northern Collective
Bank House
Cross Scythes
The Dore
Castleton Coffee
Peveril Stores
Vintners
The Challenge

Fragmented Systems, Hidden Insights

Like many growing hospitality groups, Northern Collective faced the classic multi-site challenge: different systems at different venues, making group-wide visibility nearly impossible.

Multiple POS Systems

Square at some sites, EposNow at others, with ICRTouch being introduced. No single view of sales.

Spreadsheet Reconciliation

Hours spent manually pulling data from different systems into Excel. Data was stale before reports were ready.

Delayed Decisions

Labour costs and GP% weren't visible until weeks after the trading period. Reactive, not proactive management.

Card Reconciliation Chaos

Matching POS card transactions with processor payouts was manual and error-prone. Discrepancies went unnoticed.

Discount Blind Spots

No visibility into who was giving discounts, why, or whether promotional vs. waste discounts were balanced.

Siloed Staff Data

Rotaready for scheduling, POS for sales, Sage for accounting - but no way to see labour cost as a % of sales.

The Solution

Northern Collective Portal

A purpose-built unified management platform that sits on top of existing systems - no replacements, no disruption, just complete visibility.

Real-Time Sales Sync

Transaction data from Square and EposNow syncs every 15 minutes. Live dashboards show today's performance as it happens.

Unified Dashboards

Widget-based homepage shows Sales, Staff Costs, GP%, Reviews, and Compliance at a glance. Filter by site or see the whole group.

Automated P&L

Sales from POS, wages from Rotaready, COGS from purchasing systems - all flowing into a self-building profit & loss report.

Discount Intelligence

AI-powered classification: Promotions (good), Waste (bad), Staff (neutral). Track who, what, when, and spot patterns instantly.

Team Performance

Sales attribution by staff member. See who's selling, their average transaction value, and discount patterns per team member.

Card Reconciliation

Automatic matching of POS card transactions with Dojo/Square payouts. Flag discrepancies, mark cash, reconcile with confidence.

Connected Systems

Sales Module

Real-Time Sales Intelligence

Every transaction flows into the portal within minutes. See today's revenue as it happens, broken down by wet (drinks), dry (food), and service categories. Toggle between Inc VAT and Ex VAT with a single click.

  • 15-minute sync from Square & EposNow
  • Wet/Dry/Rooms/Other category split
  • Period comparison with % change
  • Drill-down to individual transactions

Today's Sales

Inc VAT
£12,847
+8.3% vs last week
£5,420
Wet
£6,890
Dry
£537
Other

Labour This Week

Signed Off
£8,240
Total wages
23%
£5,120
FOH
£3,120
Kitchen
Staff Costs Module

Labour Cost as % of Sales

Rotaready wage data meets real POS sales data. See labour cost as a true percentage of revenue - not estimates. Split by FOH and Kitchen, with sign-off status tracking for payroll accuracy.

  • Automatic Rotaready integration
  • FOH / Kitchen wage split
  • Real-time labour % gauge
  • Actual vs. forecast comparison
Coming Soon

Lawrence 2.0 - AI Business Analyst

Built on Anthropic's Claude, Lawrence has deep contextual access to all portal data. Ask questions in natural language and get instant, accurate answers about your business performance.

  • "What were our total sales last week?"
  • "Who gave the most discounts at Bank House?"
  • "Why is GP% down at The Dore?"
  • Proactive anomaly detection & alerts

How did Bank House do last week?

L

Bank House generated £42,350 in sales last week, up 8% from the previous week.

Wet sales were particularly strong at £18,200, driven by Friday and Saturday evening trade.

What about labour costs?

Lawrence is thinking...
The Results

Transformation in Action

From fragmented spreadsheets to unified real-time visibility across the entire group.

11
Venues Unified
Single login, complete visibility
12
Systems Integrated
POS, payments, scheduling, reviews
15min
Sync Frequency
Near real-time data across all sites
0
Spreadsheets Needed
Automated reporting end-to-end

Before Stack.

  • Hours spent reconciling data from multiple POS systems
  • P&L reports completed weeks after period close
  • No visibility into discount patterns or abuse
  • Labour costs unknown until payroll processed
  • Card reconciliation a manual, error-prone process

After Stack.

  • All POS data unified in one dashboard, auto-synced
  • Live P&L that builds itself from integrated data sources
  • AI-powered discount classification and trend analysis
  • Real-time labour % of sales with FOH/Kitchen split
  • Automatic card reconciliation with exception flagging
The portal has completely transformed how we manage our sites. What used to take days of spreadsheet work now happens automatically. We can finally make decisions based on real-time data.
Northern Collective
Management Team
Built With

Modern Technology Stack

Enterprise-grade infrastructure designed for reliability, security, and scale.

Laravel 12

Modern PHP framework for robust backend architecture

Livewire 3

Reactive components without JavaScript complexity

Tailwind CSS

Utility-first CSS for responsive, modern UI

MySQL 8.0

Optimised database with full audit trail

Ready to unify your hospitality group?

Whether you have two sites or twenty, Stack. can bring all your systems together into one unified view. Let's discuss your integration requirements.