Definition and method of calculating turnover
The turnover (or net sales) for a year is calculated by adding the amounts excluding tax of customers that were won or finalised in sessions that are drafts, planned or completed . These amounts are then applied pro rata to the number of hours of the session over the given year.
Calculation method
(Sum of hours over the period / Total duration of training in hours)
× Amount excluding tax per customer.
You can find it in
Your Home > Dashboard tab in the left-hand menu:
Your Business Performance Tracking
After navigating to the Performance Reports > Business Performance Tracking, we invite you to find the same number as in the dashboard to apply the filter "Also take pro rata the sessions which overlap the period"
Let's take an example:
On a session with 2 modules Theory and Practice:
Theory costs €10 per customer and runs over a 20-hour date range from December 1, 2022 to January 31, 2023.
Practice has two prices: £ 12 per learner per hour for training and £ 30 per learner for materials. The module takes place over 3 slots of 4 hours each on December 15, 2022, January 5, 2023, and January 19, 2023.
The total amount excluding tax for a customer with 2 learners is calculated as follows:
£ 10 + (2 × £ 12 × (3 × 4h)) + (2 × £ 30) = £ 358
This amount will be shared between 2022 and 2023 by counting the number of hours in each year. In 2022, the modules count 14 hours out of a total of 32 hours:
((31d × 20h / 62d) + (1 × 4h)) / (20h + (3 × 4h))
We apply this ratio to the total amount to obtain the amount for 2022.
14/32 × £ 358 = £ 156,625
The customer's amount excluding tax for 2022 will therefore be £ 156,625, and the remainder (£ 201,375) will apply for 2023.