Royalty v2 report
Disclaimer
This article is only for the latest version of Zenoti Reports. Do not compare the data in this version with the data in the previous version.
In a franchisee-based business model where a corporate allows independent business owners to use its branding, business model, and other intellectual property. For this, the franchisee pays a percentage of their sales to the corporate.
Business owners and accountants can use this report to view details of royalty to be collected from franchisees.
Accounting type
Accrual: Revenue is for every business activity performed with or without payment
Cash: Revenue is recorded when the guest pays. This does not include redemptions.
For cash, the Include redemption on tax and Include redemption on tips/SSG transaction types are irrelevant.
Modified cash: Revenue is recorded when the guest pays. By default, this includes the redemption of all items.
When the guest redeems a liability to buy a service, product, or class, there's no payment and thus redemptions are not recorded as revenue.
If you wish to exclude redemptions on tax and tips, please use the transaction type filter and select Include sales and refunds only.
If loyalty point (LP) redemptions are configured as non-taxable, then the LP portion is treated as a discount and excluded from revenue and royalty computations.
Transaction type
Note
The Transaction Type filter only appears if the Accounting Type filter is set to Cash or Modified Cash. All three transaction types are included for all existing customers.
Include sales and refunds:
Cash Accounting Type (Collected exc. Redemption) = {(Sales Collected [Cash, card, check, custom]- Redemption on Tax - Redemption on Tips) * (Royalty Percentages for Royalty Categories [Percentage] or Royalty percentage for the item type)}.
If the royalty category is of the flat amount type, the computation is based on the flat amount for that category (Royalty category [Flat Amount]).
Modified Cash Accounting Type (Sales exc. Redemption) = {(Sales Exc. Redemption - Redemption on Tax - Redemption on Tips) * (Royalty Percentages for Royalty Categories [Percentage] or Royalty percentage for the item type)}.
If the royalty category is of the flat amount type, the computation is based on the flat amount for that category (Royalty category [Flat Amount]).
Include redemption on tax:
Cash Accounting Type (Collected exc. Redemption on Tax) = {(Tax Collected [redemption]) * (Royalty Percentages for Royalty Categories [Percentage] + Royalty percentage for the item type)}.
Modified Cash Accounting Type (Redemption on Tax) = {(Redemption on Tax) * (Royalty Percentages for Royalty Categories [Percentage]+ Royalty percentage for the item type)}.
If loyalty point (LP) redemptions are configured as non-taxable, they are excluded from Sales Exc. Redemption and are instead considered part of discounts. These LP amounts are not included in the royalty calculation.
Include redemption on Tips/SSG:
Cash Accounting Type (Collected exc. Redemption on Tips) = {(Tip Collected [redemption]) * (Royalty Percentages for Royalty Categories [Percentage] + Royalty percentage for the item type)}.
Modified Cash Accounting Type (Redemption on Tips) = {(Redemption on Tip) * (Royalty Percentages for Royalty Categories [Percentage]+ Royalty percentage for the item type)}.
Zone/Location group
Allows you to search for both zones and location groups if location groups are configured for the organization for at least one zone. Location groups will only be shown if the Enable Location groups setting is enabled. If the Zone/Location group filter is not visible, it means it is not enabled for your account. Please contact a person from Zenoti to enable this feature.
Category
All Royalty categories: Sum of royalty of individual categories.
Center Royalty: Royalty based on the percentage that is configured for the center.
Note
The optional columns can accommodate up to 100 characters.
At the organization or center level, click the Reports icon.
On the Reports page, search for and select the Business Payments: Royalty report.
If the report has many columns, scroll horizontally to the right or left to view all columns.
To view specific data on the report, select the desired filters. For more information, refer to report features on Zenoti.
Click Refresh.
If you generate the report for over a year, click the Email button.
Column | Accrual | Cash | Modified cash |
Center Code | Unique code that identifies the franchisee | Unique code that identifies the franchisee | Unique code that identifies the franchisee |
Center Name | Center from which the royalty must be collected | Center from which the royalty must be collected | Center from which the royalty must be collected |
Service | Amount of royalty to be collected from service sales | Amount of royalty to be collected from service sales | Amount of royalty to be collected from service sales |
Product | Amount of royalty to be collected from product sales | Amount of royalty to be collected from product sales | Amount of royalty to be collected from product sales |
Membership | Amount of royalty collected from membership sales | Amount of royalty collected from membership sales | Amount of royalty collected from membership sales |
Package | - | Amount of royalty to be collected from package sales | Amount of royalty to be collected from package sales |
Gift Cards | - | Amount of royalty to be collected from gift card sales | Amount of royalty to be collected from gift card sales |
Prepaid Card | - | Amount of royalty to be collected from prepaid card sales | Amount of royalty to be collected from prepaid card sales |
Total Royalty | Total amount of royalty to be collected from the franchisee for all sales | Total amount of royalty to be collected from the franchisee for all sales | Total amount of royalty to be collected from the franchisee for all sales |
Note
For accrual accounting, the amount includes cash equivalent payments and redemptions, whereas for cash and modified cash, it only includes cash equivalent payments.