What sales said versus what the register said

The situation

Marketing could see deals marked won in the CRM. Operations could see revenue in the point-of-sale system. Nobody could tell whether an event that sold for a given number actually rang up that number, and the gap between the two was a running argument with no data behind it.

What we built

• A KPI dashboard that pulls won deals from the CRM and reconciles expected event revenue against actual point-of-sale totals
• Walk-in customer demographics from the venue system layered alongside, so booked business and walk-in business can be read together
• Role-based access, venue filtering, and arbitrary date ranges, behind authentication

The details that mattered

• The join is the hard part. Two systems, two definitions of an event, two definitions of revenue, and no shared key. Most of the work was in the reconciliation logic, not the charts.
• Access is scoped by role and by venue, so a regional manager sees their locations and corporate sees all of them.

What it proves

Every multi-location operator has this exact gap between what the sales system claims and what the register recorded. Closing it is a two-system join with a real number at the end, not a data warehouse project.