Private commission: 7.5% · Public commission: 8% (combined bar sales)
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 = Subtotal (before tax/service charge) − 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
▼
Comp & KPI Settings (Programs Director)
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:
Per-Location Sales Export:
1. Square Dashboard → Reporting → Reports → Sales Summary
2. Filter by location (if multiple)
3. Date range: full quarter (e.g. Jan 1 – Mar 31)
4. Group by: Day
5. Click Export (CSV) → upload below
Repeat for each location if you have more than one.
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"
Square API not configured. Use CSV import below, or add SQUARE_ACCESS_TOKEN to environment.
▶ Manual CSV Import
No data imported
No data imported
Payroll Period (Sun–Sat)
Private Event Commissions
Only events with status "Collected" and not yet paid are included.
Public Event Commissions
All logged public events (not yet paid) are included by event date.
Payroll History
Theoreticals — Promotion Earnings Projector
Rudimentary what-if. Estimate annual earnings under a hypothetical offer (e.g. a three-venue promotion at a reduced per-venue base). Does not change any real numbers.