Commission Reports Process SOP

This process outlines the steps to calculate events team commission each month.

Notes

• All events must be paid and have status "Closed" to qualify for commission.

• Make sure events are in the correct category, some virtual events have been under Corporate in the past

• Origin reports are generated in Tripleseat under "Reports".

Steps to Calculate Commissions

• Open the Tripleseat report for the month you're calculating. https://3789.tripleseat.com/reports

  • See below for reports

• Export/download as .xls and open the file.

• Remove excess data (totals), and combine sections Corporate/Social into one section. Virtual is separate.

• For Corporate/Social Events:

  • =SUM of all event rev categories (bev, rental, admin)

  • for food, calculate 18% for all values in this column and then =SUM that category (% may be lower in Greenpoint)

  • Total Threes event revenue (bev, rental, admin, 18% food) and calculate % commission necessary to report to payroll.

• For Virtual Events:

  • =SUM all event revenue categories (beverage, service fee, virtual event fees, snacks)

  • Total Threes virtual event revenue and calculate % commission necessary to report to payroll.

• Save this file as 'commission_YYYY_MM' in both XLS and PDF format and save to this folder.