The bookings report export lets you track franchise fees and franchisee earnings for a given month. You can filter the data to calculate commissions paid to HQ and the remaining revenue for each franchisee.
This article explains how to use the bookings report to manage franchise fees and franchisee takings.
What’s new in the bookings report?
The CSV export now includes two key columns:
Franchise Fees (Column L): This column shows the commission fee paid to the Franchise HQ.
Franchisee Takings (Column M): This column shows the total amount the franchisee receives after deducting the HQ commission fee.
Filtering your bookings report
To filter your bookings report before you export it:
Select Bookings from the left-hand menu.
In the Start Date and End Date fields, select the day of the month for which you wish to report using the calendar tool:
Under Attendance Status, check the Complete box to only include fully paid bookings in the search:
Select Search to generate the results based on your filters.
Select the Options drop-down, then Export bookings (CSV) to download your report:
Find the downloaded file on your device and open it in your preferred spreadsheet application (e.g. Google Sheets, Excel).
In the CSV, locate the Created column (usually Column D).
Filter the dates to show only bookings created in the month you are reporting on (e.g., select all dates created in March for March data).
Sum the values in Franchise Fees (usually Column L) to calculate the total commission paid to the HQ for that month’s bookings.
Sum the values in Franchisee Takings (usually Column M) to find out how much you’ve earned after deducting HQ fees.
💬 Need extra help?
For the quickest response, contact us via live chat on our homepage or your account. Buddy, our trusty chatbot, will assist first and pass you to a support team member if needed.
Prefer email? Send us an email instead.
Thank you! 🕺