Royalty report
The Royalty report shows the royalty amount each franchisee center owes the corporation, broken down by item type (services, products, memberships, packages, gift cards, prepaid cards). Owners and accountants use it to invoice franchisee centers and reconcile collections.
Before you begin
Permission: Royalty Report under Financial in the Reports(V2) section of the security role β required to open this report. For the classic version of the report, the report-area action under View Admin Reports in the Administrator section of the security role.
Navigation: Open the Reports dashboard, type the report name in Search Report, and select Royalty.
Report details
| Aspect | Detail |
|---|---|
| Purpose | Calculate royalties owed by franchisee centers by item type, on accrual or cash basis |
| Filters | Date range, Zone or Location group, Center, Accounting type, Transaction type, Category |
| View scope | Center, Organization |
Filters
| Filter | Description |
|---|---|
| Accounting Type | Accrual -- royalty applies to every business activity with or without payment. Cash -- royalty applies when the guest pays (excludes redemptions; the redemption-related transaction-type options do not apply). Modified cash -- royalty applies when the guest pays, with redemptions of all items included by default. |
| Royalty Type | Appears only when Accounting Type is Cash or Modified Cash. Three options are available: Include Sales and Refunds, Include Redemption on Tax, and a third option that includes redemptions on tips, support staff gratuity, and other fees. |
| Zones | Search by zone or location group. Visible only if the Enable Location groups setting is on. |
| Category | All Royalty categories (sum across categories), or Center Royalty (uses the percentage configured for the center). |
Note: Optional columns can accommodate up to 100 characters.
Report columns
| Column | Description |
|---|---|
| Center Name | Name of the franchisee center the royalty is calculated for. |
| Center Code | Unique code assigned to the franchisee center under Business details. |
| Service | Royalty calculated from total service sales at the center. Click a non-zero value to drill into the contributing service transactions. |
| Product | Royalty calculated from total product sales. Drilldown shows the contributing product transactions. |
| Class | Royalty calculated from total class sales at the center. Drilldown shows the contributing class transactions. |
| Membership | Royalty calculated from total membership sales at the center. |
| Membership (Charges) | Royalty calculated from recurring membership charges collected at the center. Drilldown shows the contributing membership charge transactions. |
| Package | Royalty calculated from total package sales. Drilldown shows the contributing package sale transactions. |
| Gift Card | Royalty calculated from total gift card sales. Drilldown shows the contributing gift card sale transactions. |
| Prepaid Card | Royalty calculated from total prepaid card sales. Drilldown shows the contributing prepaid card sale transactions. |
| Total Royalty | Total royalty owed by the franchisee based on overall sales for the period. Drilldown shows all contributing transactions across categories. |
Column values are calculated based on the selected Accounting type. Under Accrual, amounts reflect all business activity regardless of payment. Under Cash and Modified Cash, amounts reflect only collected payments, with Modified Cash additionally including applicable redemptions depending on the Transaction type filter.
Note: Under Cash and Modified Cash accounting, an additional Flat Pay Period Fee column may appear -- a fixed royalty charge applied at the franchise or center level, independent of services, products, or sales volume.
Loyalty point handling
Zenoti allows loyalty point (LP) redemptions to be treated as non-taxable redemptions. When configured this way, the LP portion of a sale is excluded from tax calculations, similar to a discount.
For example, a guest pays for a $100 service using $20 worth of loyalty points. If LPs are non-taxable, tax is calculated only on $80. LP redemptions then sit in the discount totals rather than in Sales (excl. Tax).
This feature is off by default. Contact your Customer Success Manager to enable it. The feature applies only to businesses that have enabled the Pre-tax amount configuration for loyalty points (Organization > Loyalty program > Loyalty settings).
Note: Accrual royalty totals include cash equivalent payments and redemptions. Cash and Modified Cash totals include only cash equivalent payments.
Tips
- If the report includes more than one year of data, click Email to receive the export by email.