Purpose
The Commission and Gratuity Report lists sales transactions for products, services, packages, and gratuities, and credits them to the assigned staff member. The report calculates commission amounts using either percentage‑based or fixed dollar commission rules.
The report can be exported to a spreadsheet, allowing the practice to apply additional or external commission logic, such as tiered, sliding‑scale, or performance‑based commission models.
Exclusions
The Commission and Gratuity Report does not include the following transaction types:
-
Custom “Miscellaneous Payment” types
Miscellaneous or ad‑hoc payment types are not treated as commissionable or reportable sales items and will not appear on the report. -
Surgical procedures
Surgical procedures are excluded from this report. Surgical revenue, charges, and compensation are typically tracked through surgical, facility, anesthesia, or procedure‑specific reports, rather than standard commission reporting.
What the Report Includes
- Product sales
- Service sales
- Package sales and/or package item delivery
- Gratuities
- Assigned staff member attribution
- Calculated commission amounts:
- Percentage‑based commissions
- Fixed dollar amount commissions
- Optional inclusion or exclusion of:
- Discounts
- Cost of Goods (COGs)
Prerequisites and Configuration Requirements
Staff Profiles
Staff profiles must be configured correctly in order to appear on the report and receive credit.
- Gets Commissions – Required for staff earning commissions
- Can Receive Gratuity – Required for staff receiving tips
Products
Products must be configured as commissionable or reportable items.
- Commission or Report Item checkbox must be enabled
Commission types:
- Percentage of Total
- Commission can be calculated on:
- Line total
- Discounted total
- Total with COGs deducted
- Commission can be calculated on:
- Fixed Dollar Amount
- Commission is paid per item
- Paid regardless of discounts or total sale amount
Services
Services must be configured to appear on the report.
- Report and Commission Item checkbox must be enabled
Commission types:
- Percentage of Total
- Commission can be calculated on:
- Line total
- Discounted total
- Total with COGs deducted
- Commission can be calculated on:
- Fixed Dollar Amount
- Commission is paid per service
- Paid regardless of discounts or total charge .
Packages
Packages must be configured to support commission tracking.
- Commission amount must be greater than zero
Important note:
Typically, commissions are not paid on the sale of a package, but rather on the delivery of the package’s child items (services or products included in the package). This ensures commissions are earned when work is actually performed.
Report Settings and Filters
The Commission and Gratuity Report includes multiple filters to refine results:
Staff Filter
- All Staff
- Individual staff members
Location Filter
- All Locations
- Individual locations
Date Range Filter
- Month to Date
- Last Month
- Last 30 Days
- Year to Date
- Last Year
- Last 12 Months
- Custom Date Range
Additional Options
- Include Staff Without Items
- Deduct Cost of Goods from Commission
- Deduct Cost of Goods from Fixed Commission
- Include invoice items in commission report before being paid
Report Type
- Commission + Gratuity
- Commission Only
- Gratuity Only
Display Options
- Display Individual Patients
- Display summary total by product or service type
Calculations and Output Columns
Each line item in the report includes detailed calculation fields, such as:
- Item
- Quantity
- Unit Price
- Extended Price
- Discount
- Cost of Goods (COG)
- Amount After Discount & COG
- Commission Rule (percentage or fixed amount)
- Commission (Full – COG)
- Commission (Discount – COG)
Example Calculation
- Item : Skin Cream
- Qty : 1
- Unit Price: $100.00
- Extended Price: $100.00
- Discount: $0.00
- COG* : $25.00
- After Disc & COG: $75 .00
- Commis Rule : 10%
- Commiss Full - COG: $7.50
- Commiss - Disc - COG: $7.50
This structure allows practices to clearly see how commission amounts are calculated under different discount and COG scenarios.
Help Center