You would like to create an Attendance Revenue report to know exactly how much money you earn per visit?
You can now easily do this in the reports, with the Attendance Revenue report. To do this, click on the Reports tab in the main menu on the left and select the Attendance Revenue report.
Select event group
Click on the blue field "Event group", which will open a pop-up window.
Here you will find all active event groups. By clicking on the boxes, they will be included in the report. You can use the search bar to search for a specific event group. Click on the green "Confirm" button to save your selection. Generating the report may take a moment, depending on how many event groups you have selected.
It is possible to select a date range between two dates. The pre-selected date range is the last 30 days.
The filters are always activated by default.
Exclude absentees: Check this box to exclude customers who are booked for an event but marked as absent.
Exclude due payments: Check this box to exclude customers who have been booked in for an event with a payment still due.
Export report as an Excel document
To export the report as an Excel document, press the green “Download” button.
Understanding the results
The report contains the following result both in the live preview and in the Excel file:
Date, time, name and trainer leading the event → Monday, March 12, 2018 |19:00 Yoga for athletes | Elena
Customer → First name and surname of the customer taking part in the event.
Product → The product with which the customer booked the event.
Expiration date → The expiration date of the product used to book the event. For credit passes, the remaining credits are displayed.
Trainer → The trainer who led the event.
Absent → A "Yes" or "No" indicates whether the customer was absent.
Origin → Shows how the customer was booked into the event (e.g. fitoAPP, Online, PRO).
Payment method → Displays the payment method used for the product with which the appointment was booked. If the product is due for payment, the previously selected payment method is displayed.
Revenue per visit → Revenue from the booked events
Total → At the bottom is a small summary of the most important information. Including the total number of absences, online bookings (everything except PRO bookings) and the total income.
The attendance revenue is calculated as follows:
Credit pass → The amount of the credit pass is divided by the number of credits. If a 10-credit pass costs 150 €, the turnover per visit is always 15 € - regardless of how many visits have been cancelled.
Contract: The value of the previous contract period (including start and break fees) divided by the number of current bookings.
Course / Workshop: The value of the course divided by the number of events
Single event: The value of the product
Example credit pass:
→ 150€ / 10 = 15€ per visit
→ 150€ / 11 = 13,64€
Example credit pass + 1 extra credit for 7 €
→ (150€+7€) / 11 = 14,27€
Number of bookings up to today: 11
(60 + 39€ + 39€ + 28,6€ (proportional month)) / 11 = 15,15€