Use the bookings report export to track franchise fees and franchisee takings for a specific month. Filter the data to calculate the commission paid to HQ and the franchisee’s earnings after fees are deducted.
This article covers:
What’s new in the bookings report?
The CSV export now includes two key columns:
Franchise Fees (Column L): This column hows 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
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 update 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.
💬 Any questions or feedback? There are two ways to get in touch:
For a quicker response, please contact us via live chat on our homepage or your account.
Or send us an email
Thank you! 🕺