Coach Commission Calculation SOP

Coach commission calculation is one of the highest-trust tasks you hand off in a fitness business. Get it wrong once and you damage the relationship with your best coaches. Get it right every month with a clear statement and you build the kind of loyalty that retains talent. A fitness virtual assistant can own this process entirely, but only if the SOP is specific enough that there is no room for interpretation. This guide covers tier definitions, exception handling, and the monthly statement format coaches actually trust.

Defining Commission Tiers Before the VA Touches the Math

Ambiguous tier structures are the root cause of most commission disputes. Before your VA runs a single calculation, you need a written tier table that answers four questions: what counts as a session, when does a tier change take effect, what happens when a coach hits a threshold mid-period, and whether different session types carry different rates.

Build a reference table, not a formula. The VA should never be reverse-engineering your commission logic from a conversation thread. The SOP document should contain an explicit table like this:

Add a notes column to the reference table. Common notes: "Silver tier applies retroactively to all sessions in the period if the coach hits 20 before the last day." Or: "Gold tier is prospective only. Sessions above 40 get the higher rate; sessions 1-39 stay at Silver." These two scenarios produce meaningfully different paychecks. Document which one you run.

Session type mapping. Your scheduling platform (MindBody, Mariana Tek, or a competitor like Pike13) codes sessions differently. Map each session type code in your system to a commission category. For example:

• PT_60 → Personal Training, full rate
• PT_30 → Personal Training, 60% rate
• GRP_YOGA → Group Class, group rate
• GRP_HIIT → Group Class, group rate
• ASSESS → Assessment, flat $15 (not commission-based)
• COMP → Complimentary session, $0 commission

This mapping table lives in the SOP. The VA references it every cycle when pulling the session export. Any session type that does not appear on the mapping table gets flagged (not guessed) and escalated to the manager before the commission calc is finalized.

Running the Calculation: Step-by-Step for the VA

Once the reference tables exist, the monthly calculation becomes a repeatable data operation. Here is the exact sequence your VA should follow.

Step 1: Pull the session export. From MindBody or your scheduling platform, export all completed sessions for the pay period. Filter for status "Completed" only. Exclude cancelled, no-show (unless your policy pays no-show rates, which you should document separately), and pending sessions.

Step 2: Map each session to a commission category. Use a VLOOKUP or INDEX/MATCH in the commission spreadsheet to match each session type code to the rate table. If using Google Sheets, a simple VLOOKUP against the mapping table tab takes 2 minutes to build and eliminates manual categorization errors.

Step 3: Count sessions per coach by category. Use a pivot table or SUMIF to get each coach's total by session type. This gives you the raw counts needed for tier determination.

Step 4: Apply tier logic. Check each coach's total qualifying session count against the tier table. Apply the correct rate. If your policy is retroactive, multiply the total count by the tier rate. If prospective, calculate each band separately.

Step 5: Document exceptions before finalizing. Any approved exceptions (a comp session that gets partial commission, a makeup session from a prior period, a corrected no-show) need a row in an exceptions tab with: coach name, session date, exception type, approved rate, manager sign-off reference. No exception gets added to the final commission figure without that reference.

Step 6: Cross-check totals. Total commission this period vs. last period. Any coach whose commission varies more than 25% (up or down) gets a second look. High variances are usually correct (a coach had a strong month or took PTO), but the VA should confirm before submitting.

The Monthly Statement Format Coaches Actually Trust

Coaches dispute commissions when they cannot verify the math themselves. A transparent monthly statement eliminates most disputes before they start. The statement your VA sends each coach should contain:

Header block:

• Coach name
• Pay period dates
• Statement generated date

Session detail table:

Summary block:

• Total sessions by type
• Tier achieved and effective rate
• Gross commission subtotal
• Any exceptions with description
• Final commission total

Deliver the statement before payday. Send it 2-3 business days before the payroll submit deadline. This gives coaches time to raise questions while the VA still has time to investigate and correct. Coaches who receive a detailed statement before their paycheck rarely dispute it. Coaches who get only a paycheck and have to ask for the breakdown lose trust fast.

Delivery method. A PDF via email works. For studios using Trainerize or TrueCoach, you can attach the statement to the coach's profile or send via the platform's messaging. What does not work: a verbal summary or a Slack message with just the total. The detail has to be in writing.

The tasks a fitness VA handles in commission management are high-value precisely because coaches notice when they are done well. They notice immediately when they are done poorly.

Handling Disputes and Corrections

Even a clean SOP produces occasional disputes. The process for handling them matters as much as the original calculation.

When a coach flags a discrepancy:

1. The VA pulls the raw session export for the contested period.
2. The VA compares the coach's claimed sessions against the platform record.
3. If the platform record is missing a session, the VA requests the coach provide confirmation (a client receipt email, a booking confirmation, or a calendar entry). The VA does not add sessions based on coach memory alone.
4. If the platform record is correct and the coach miscounted, the VA walks through the statement line by line with the coach via email. Most discrepancies resolve at this step.
5. If a platform error is confirmed (the session shows completed in one view but not another, which happens in MindBody), escalate to the platform admin and request a correction. Apply the corrected session in the next cycle with a note.

Correction policy. Define a lookback window in your SOP, typically 60 days. Disputes raised after 60 days from the statement date are reviewed at management discretion only. This prevents coaches from auditing commissions from 18 months ago and creating retroactive payroll corrections.

Dispute log. The VA maintains a running dispute log: date raised, coach, period in question, amount disputed, resolution, and date closed. This log is reviewed monthly by the owner. Recurring disputes from the same coach or about the same session type are a signal the tier table or mapping needs to be clarified.

Frequently asked questions

How often should the commission SOP be reviewed and updated?

Review it at every rate change, every time you add a new session type to your scheduling platform, and at minimum annually. The VA should flag any session type that hits the "not in mapping table" exception more than twice. That is usually a signal that a new service was added without updating the SOP.

What is the best format for the commission tracking spreadsheet?

Google Sheets works well for most studios under 20 coaches because it is shareable and audit-able (version history shows every edit). For larger teams, Airtable gives you relational structure that makes cross-referencing coach profiles, session types, and rate tables easier. Either way, the source data tab should never be edited manually after the export is locked. All changes go through the exceptions tab.

Should coaches see each other's commission rates?

No. The VA sends individual statements, not a team-wide report. The tier structure itself can be shared in the coach handbook so coaches understand how to move up, but individual paycheck data stays private.

How do you handle a coach who works across multiple locations?

Track sessions by location in the export and confirm whether commission rates vary by location. Some studios pay a flat rate regardless of location; others pay differently for a downtown flagship versus a smaller satellite. Document this in the mapping table. The VA aggregates the coach's total qualifying sessions across all locations for tier determination unless your policy treats locations separately.

What happens if the scheduling platform export has errors?

Platform export errors happen most often after software updates or bulk schedule changes. The VA's job is to flag the anomaly, not to correct it. If the export shows fewer sessions than the week prior with no obvious reason (holiday, low booking month), the VA flags it before running any calculations. Submitting commission based on a corrupted export is a harder problem to fix than a one-day delay to pull a corrected report.