INTRODUCTION
Feature Summary: CourtReserve’s Reservations Report and Instructor Time Report can be used to calculate instructor pay for a given time period. By filtering these reports by instructor name and date range, clubs can support multiple pay models—including revenue splits, flat rates, and hourly compensation—using real reservation and lesson data.
Use Cases: Clubs commonly use these reports to:
Calculate weekly, bi-weekly, or monthly instructor pay
Support different pay structures across instructors
Reconcile lesson revenue with instructor hours
Validate payouts before payroll processing
OVERVIEW
CourtReserve provides flexible, instructor-level reporting so clubs can calculate pay based on their preferred structure.
Two reports are typically used together:
Reservations Report - Used to calculate pay based on lesson revenue
Instructor Time Report - Used to calculate pay based on hours taught and/or lesson types
Both reports can be:
Filtered by date range
Filtered by individual instructor
Exported as an .xlsx file for payroll calculations
In the examples below, we’ll walk through how these reports can be used to calculate instructor pay based on three common instructor pay methods.
Report 1: Reservations Report (Revenue-Based Calculations)
What This Report Shows
The Reservations Report displays each lesson booked, including such output fields as:
Reservation Type (lesson type)
Start and End Date/Time
Instructor
Member(s)
Payment Status
Member Count
Fee Amount (this is the member fee for the lesson)
This report is helpful for revenue-based pay models. Be sure to pay special attention to what output fields work best for the data you need.
Filters should be used to, for example, pick the relevant date range, Reservation Type(s) and Instructor(s).
In the example shown, three private tennis lessons were completed during the month. The instructor is paid a 50/50 split based on member fees, and only lessons with a Payment Status of Paid are included in the pay calculation.
Lesson | Member Payment Status | Fee |
1 Hour Private Lesson – Tennis | Paid | $70.00 |
1 Hour Private Lesson – Tennis | Paid | $70.00 |
1 Hour Private Lesson – Tennis | Paid | $65.00 |
From here, the admin can export the report to Excel and total the Fee Amount column. In this example, the total lesson revenue is $205. With a 50/50 split, the instructor’s pay would be $102.50.
Important Note About Fee Amount and Payment Fields
While the Reservations Report is helpful for tracking instructor activity, in certain circumstances, the Fee Amount may appear blank or show $0.00.
This can occur when:
Payments are edited or partially paid
A participant registers and pays for a full event rather than individual dates
The report references individual reservation instances tied to a broader event payment
Payment data has changed after the reservation was created
Because this report does not perform financial accrual calculations, fee and payment data may not always align with actual revenue collected. However, the Reservations Report does accurately display the instructor’s activity—such as date, start time, end time, and attendance—and can be used to support manual instructor pay calculations when needed.
Report 2: Instructor Time Report (Hour-Based Calculations)
What This Report Shows
The Instructor Time Report summarizes teaching hours by instructor, including such output fields as:
Instructor Name
Lesson Type
Total Hours (The sum of all hours worked by the instructor across lessons, reservations, and events)
Total Lesson Hours
Lesson counts by lesson type
This report is ideal for hourly or flat-rate pay models.
In this example:
Total Lesson Hours: 4
1 Hour Private Pickleball Lessons: 1
1 Hour Private Tennis Lessons: 3
For example, if the club pays a flat $25 per pickleball lesson and $30 per tennis lesson, this instructor would earn $25 + $90 (3 lessons * $30 per lesson)= $115.
Alternatively, if the club pays instructors hourly, the admin can reference the Total Lesson Hours (4) to calculate pay for the period. For example, at $20 per hour, 4 lesson hours would result in $80 in instructor pay.
Lesson | Number Taught | Total Payment |
1 Hour Private Lesson – | 1 | $25.00 |
1 Hour Private Lesson – Tennis | 3 | $90.00 |
| Total Flat Fee Pay: | $115.00 |
Save the Report
Note: If the selected report filters and output fields best meet yours needs, be sure to save the report, allowing you to reuse the same settings when running the report again.
Running Reports by Instructor
Both the Reservations Report and Instructor Time Report can be filtered by individual instructor name.
This allows clubs to:
Run reports one instructor at a time
Export instructor-specific data
Share breakdowns with instructors if needed
Avoid manual filtering in spreadsheets
In Summary
While instructor pay is not calculated automatically in CourtReserve, the Reservations Report and Instructor Time Report provide flexible reporting tools that clubs can use to calculate instructor compensation accurately when the correct filters and outputs are applied.
Using these reports effectively allows clubs to:
Calculate instructor pay for weekly, bi-weekly, or monthly pay periods
Support multiple pay models, including revenue splits, flat rates, and hourly pay
Filter results by date range, reservation or lesson type, and instructor name
Export data to Excel for final payroll calculations
Save report configurations to reuse the same filters and output fields for each instructor
Reduce manual cleanup by running reports one instructor at a time
While some manual review may still be required, careful use of filters and saved reports helps streamline the process and ensures instructor pay is calculated using accurate, real lesson data from CourtReserve.