Private commission: 7.5% · Public commission: 8% (Brill Line + SFSG)
KPI bonus: 1-3% of $65K per KPI per quarter · Max quarterly: 9% = $5,850
Max annual bonus: 36% = $23,400 · Target total comp: $90,000+
7.5% of Commissionable Private Event Revenue · Commissionable = Total Revenue − Pass-Through Costs (security, A/V, direct costs)
Add Private Event
Private Events Log
▼
8% of Commissionable Bar Sales (current year only) · LY Sales shown for year-over-year comparison
Add Public Event
Public Events Log
▼
Each KPI independently earns 1% ($650), 2% ($1,300), or 3% ($1,950) of annual base salary ($65,000) per quarter.
Max quarterly bonus: 9% = $5,850 · Max annual bonus: 36% = $23,400
Public Event Sales Running Tally
No public events logged yet.
For KPI 2 (Bar Sales Uplift) & Public Event Commissions:
Bar Sales (Brill Line location):
1. Square Dashboard → Reporting → Reports → Sales Summary
2. Filter location: Brill Line
3. Date range: full quarter (e.g. Jan 1 – Mar 31)
4. Group by: Day
5. Click Export (CSV) → upload below as "Bar Sales CSV"
LY Sales (SFSG location):
1. Same path: Reporting → Reports → Sales Summary
2. Filter location: SFSG
3. Same date range & Group by: Day
4. Click Export (CSV) → upload below as "LY Sales CSV"
The "Net Sales" column from each CSV is used to calculate daily bar totals.
Event days vs non-event days are compared to determine KPI 2 (Bar Uplift).
Add Quarterly KPI Data
How to use: Select year & quarter → click "Pull" to auto-fill from APIs → review values → "Save Quarter"