As exciting as the new memberships feature is, it's only effective with good reporting. At ROLLER, we love analytics and knowing that our features are providing our clients with benefits.
Memberships offer 2 avenues of revenue:
- Recurring Billing
- Fixed Cost
Recurring Billing
One of the new features offered is the ability to set up recurring billing for a membership. This can be set up as either on-going indefinitely or a set number of recurring payments.
e.g. an on-going indefinite membership will cost $100 per month. After their first initial upfront payment, the following payments will be recognised based on each month the customer is charged (this occurs one calendar month after their first initial payment) Each payment will be recognised for the amount in the set time frame.
Reporting will recognise these payments as normal revenue based on the time the transaction lands.
Fixed Cost
For venues looking to take a one-off payment, memberships can also be created to be a single payment only.
This allows the venue to take larger payments and lock in customers, but this is considered deferred revenue and requires some changes in how we report on these payments.
When this is the case, Roller Analytics will take the total amount charged and break this over the course of the memberships validity.
e.g. a one-off payment for a yearly membership of $1,200.00. The total amount will be recognised monthly. Initially, the first payment will be a 12th of the subscription, thereafter the revenue recognised each month will be a 12th ($100.00)
Tracking Memberships
There are a few various ways to track memberships. The best way is dependent on what exactly needs to be monitored.
Creating a 'Membership Report'
To ensure getting the most out of memberships, it's best to learn about the ROLLER Reports
We suggest creating Reporting Categories for all membership products. Using the GL Code's allows segregating data in a GL Report.
To monitor the number of memberships signed on during a particular period, the best report is the Bookings Report and only select the Memberships that are to be reported on. When downloaded as a CSV file, it's possible to then group these by the 'Item' which will group the different memberships. From there, you can report on a multitude of variables.
The Membership Grid
The easier way to monitor memberships and subscriptions is in Customer > Memberships. This 'Grid' presents a quick and very accessible view of what the memberships are doing as well as the status' of these memberships. The grid breaks these down into the below columns:
- Member Name
- DOB
- Membership - this is the type of membership they hold.
- Status - whether it is active, suspended or cancelled
- Redemption's - the amount of time the member has used their discount code. This is calculated per total cart purchase not based on individual product purchase
- Total Discount Value - This is the total discount they've received using their memberships. This includes stock and add-ons discounts provided
- Created - date it was purchased.
These columns can be changed by adding or removing whichever one is most applicable:
