When navigating ROLLER reports you will need to choose the date range you want the data to appear for. Your options are today, tomorrow, yesterday, on a certain day, between a date range, within the next day, week month or within the last day, week, month.
In this example, I'm going to filter the transactions report for the month of December. As you can see it’s giving me a summary of all the funds received for that period. You also have options to further filter this data further by selecting from the available filters next to the date selector. In this example I’m going to filter for POS transactions only. Depending on the report you may need to export the report in order to filter by a particular column heading. Using this report as an example, if I wanted to filter by staff name I would need to export and filter by staff name in excel.
If you’re consistently using the same filters when running your reports, you can save views by clicking the downwards arrow next to the report name. In this example I’m going to save this view as POS transactions grouped by payment method & save this as a new view. In future, I can easily filter the report using this saved view and it will automatically use the same filters.
You can group the transactions displayed by the column heading, if the column heading has a diamond icon next to it. In this example I’m grouping by payment method. You can also add or remove columns by right clicking the reporting grid and ticking or unticking the available options. If you’re unsure what any of the columns headings are displaying you can hover over the tooltip to get a brief summary.
Within the reporting grid you also have the ability to drill down into the bookings by clicking the booking ID. As you can when I click the booking ID it will give me a summary of the booking where this transaction occurred and from here I can click go to booking to review or make further modifications to the booking.
To export the data, click the downwards facing arrow in the top right-hand corner of the screen, depending on the report you’re exporting you’ll have an option to export to CSV or Export to Excel. Both exports will reflect any date or product filters you’ve applied. Exporting to Excel will also keep any column heading groupings that you’ve applied to the data.
Brief summary of key ROLLER reports
To find the daily summary of bookings, attendances, funds received by payment type, funds received by payment location, products sold and till summaries head to the Daily Summary report. This report should only be utilized for daily reporting (not weekly or monthly). You can have this report emailed to you daily at the time of your choice. Just submit a support ticket requesting this and our support team will action this for you.
To find attendances for a period of time head to the attendances report and choose your date range. If the same ticket is checked 3 times, this will be 1 unique redemption and 3 total redemptions.
To find the total sales for bookings & tickets sold for a period of time head to the bookings report. The tickets figure will equal the total guests booked for that period whether they actually attended or not. The total sales figure will equate to the total cost of the booking and isn’t linked to the actual funds received against the booking. Entries for this report will be based on the booking date - not transaction date - so these figures will not reconcile with the detailed transactions report or detailed product sales report. To find a summary of funds received, quantity sold, total sales & revenue segmented by product for a period of time, head to the detailed product sales report. Funds received figures in this report should reconcile against the funds received in the detailed transactions report & the revenue recognition report.
To find a summary of the funds received and gift cards redeemed for a particular period of time you can utilise the detailed transactions report. This report will have 1 entry for every payment or refund that is processed through the platform at the time this transaction occurs. Funds received figures in this report should reconcile against the revenue report & detailed product sales report.
If you need to report on an accrual basis we highly recommend setting up your reporting categories & GL codes before completing any accounting or financial reporting in ROLLER. This will help group revenue figures into general ledger codes to match any third party accounting software you may utilise. Once your reporting categories are set up you can head to the Ledger Summary report which will summarize funds received & net revenue segmented by general ledger code. The trial balance report is also a great summary report that will present the financial data in the form of debits vs credits of funds processed and revenue for a particular period.
If you want to dive deeper into this summarized revenue data in both the trial balance report & ledger summary report then you will need to utilise the revenue recognition report.This report has 3 entry types: a transaction entry - when the money is received for a ticket and becomes deferred revenue & a redemption or expiration entry when the ticket is either redeemed or expired and the revenue becomes recognised for that ticket. Data in this report will reconcile against what you see in the trial balance report & the ledger summary reports.
Integrations
ROLLER has a xero export where you can map. If you looking to create your own custom reports or dashboards you can use our data API to push ROLLER Reporting data to your business intelligence tool so you have full power to
