ROLLER reports are detailed collections of your venue's financial and performance data presented primarily in a grid format. They cover areas like bookings and headcount, daily sales takings, attendance, guests, transactions, memberships, payouts, taxes, accounting and more. This guide provides an overview of the types of reports in ROLLER to help inform better business decisions.
What to expect
Reports can be adjusted and filtered to suit your specific needs, saved or made the default view, or downloaded as CSV files to manipulate further in external spreadsheet programs.
Accrual accounting for revenue reporting offers more data and reports, enabling you to track deferred revenue and accounts receivable. This method recognizes income when it's earned, for example when tickets are redeemed at POS or expired, rather than just when funds are received.
Key terms & concepts
For a quick guide to essential ROLLER reporting concepts and terms, refer to the guide Key concepts & terms in ROLLER reports.
Access reports
From Venue Manager, go to Reports > All reports.
Here, you'll find a list of all ROLLER reports grouped into sections by their intended purpose. You can either scroll down the page to find the report you need or search for the report you want.
Bookmark your favorite reports
If you frequently use particular reports, you can bookmark them as favorites to access them more quickly. Simply select a star icon next to a report name .
Adjust and save report views
You can adjust the default reports in ROLLER to display the data that you want. You can filter data, edit, sort and group columns, and select different time ranges.
You can then save the adjusted report grid as a saved view to easily run next time you access the report or make it the default report view. Learn more
Report sections
We've organized all the reports based on the type of data they provide on the Reports > All reports page.
Summary
This report shows summarized daily performance data for one day only.
Report | When to use |
---|---|
Daily Summary | Quickly assess venue sales, attendance and redemption activity for any given day. This report provides a high-level summary of total sales takings (funds received) for the day, expected and actual headcount, a breakdown of funds received by payment method and sales channel, product sales and summaries of closed tills. |
Sales
Here, you can find out about how much you're selling for different products or product categories, and how you're making sales (eg online or at your venue). These reports help you figure out how well the different areas of your business is doing in terms of making money.
Report | When to use |
---|---|
Bookings | View all bookings within a selected date range to see details such as booking status, expected headcount, payment status and contact details. This report provides a detailed overview of all venue bookings within a specified date range, focusing on the event date (booking date) rather than transaction dates. It includes essential information such as booking ID, expected guest headcount, total booking value, payment status and contact details of the booking holder. |
Detailed Gift Cards | Manage and track the inventory of issued gift cards. This report provides a comprehensive list of issued gift cards that you can download, offering details like purchase dates, initial and current balances, recipient information and expiry dates if applicable. |
Detailed Product Sales | Gain insights into the performance of your products This report provides a comprehensive overview of your venue's financial performance by specific product for the time period selected, presenting data on quantities sold, total value of product sales, discounts applied and fees incurred. It helps you make informed decisions about product offerings and sales strategies. If you're using accrual accounting, additional columns appear showing revenue recognized through ticket redemption for the time period selected. |
Gift Card Sales | Keep tabs on how much money you've made from gift card sales on specific dates, giving you a clear picture of your gift card income. The report offers a detailed overview of the total sales from gift cards for the selected time period, allowing you to track revenue generated and discounts applied. |
Invoices | Find and manage invoices for bookings. The report provides key invoice information such as the unique invoice number, associated booking ID and name, issue date, due date for payment, invoice amount, payment status based on booking activity, payment date, payment method and booking status. |
Package Product Sales | Track and allocate revenue from package product sales only. The report provides a comprehensive view of package sales, including the revenue that has been recognized through ticket redemptions. This means it outlines not only the sales figures but also recognized revenue as tickets are redeemed in line with accrual accounting practices. |
Cost of Goods | Get insight into the sales and related expenses of stock items within your venue. This report provides details about the sales and associated costs of stock items in your venue, including quantities sold, unit costs, funds received, discounts, gift cards redeemed, and costs of goods. |
Sales by Modifier | Track and analyze the performance of different modifiers, helping you make informed decisions about your offerings. This report provides details on the quantity and value of modifiers purchased within a specified time frame. It includes columns for modifier group name, modifier name, quantity (total purchases) and amount (total dollar value of purchases). |
Payment Links | Track and manage the status of payment request links that have been sent to guests. The report provides a searchable list of payment links that have been issued including their payment status. |
Transactions
The reports in this section cover everything related to money transactions. It includes details about payments, refunds and reports on the money left to be paid for bookings. This helps you keep track of all the financial transactions in your business, helping you reconcile funds processed.
Report | When to use |
---|---|
Bookings Receivables | Keep track of amounts owing for bookings that have been redeemed or have expired. This report helps you identify which bookings have balances that guests haven't paid yet. You can also use this report to reach out to guests for collecting these payments and spot any mistakes or missing charges in the bookings. This way, you can ensure all transactions are accurate and complete. |
Detailed Transactions | Monitor and analyze the total funds received from various sales channels. The report includes information about the date and time of each transaction, unique booking identifiers, total transaction value, booking status, payment type, staff member responsible for the transaction and additional details like guest names and transaction reference numbers. |
Recurring Payment Log | Manage recurring memberships by tracking payment attempts, statuses and reasons for any failed transactions. This report provides details on recurring memberships, including booking IDs, attempted payment times, booking holder names, payment amounts, payment statuses (successful or failed), and the number of payment attempts. It also summarizes the total number and value of attempted, successful and failed payments within a selected date range. |
Refund by Staff Export | Monitor refunds processed by different staff members. This report provides a PDF export of refunds performed and grouped by staff member. |
Transactions by Card Export | Track and analyze payment activities, providing insights into how card transactions are distributed across various channels. This report provides a detailed list of card transactions grouped by sales channel (online checkout, POS) and exported as PDF. |
Transactions by Channel | Assess the popularity of various payment methods over a selected time frame. The report includes a detailed breakdown of different payment methods used for transactions within a specified date range. It categorizes payments by type, such as Credit Card, Cash and more, showing the total amounts received for each method. Additionally, it distinguishes between online, Venue Manager, and POS transactions, providing a comprehensive overview of payment channels. |
ROLLER Payments reports
|
Track and reconcile funds processed with payouts received in your bank account. For a more detailed overview of ROLLER Payments transaction reports, refer to the guide ROLLER Payments reports overview. |
Guests
The reports in this section can provide insights into guest attendance at your venue, including data on memberships, membership performance and engagement, ticket redemptions and booking information. It helps in making informed decisions regarding staffing, promotions, business operations and growth.
Report | When to use |
---|---|
Attendance | Get insights into attendance patterns at your venue This report can provide insights into guest attendance by showing the total quantity of redemptions, the device used for redemptions, and the most redeemed products. This information aids in making decisions about staffing and promotional efforts. |
Booking zip code |
Detailed list of ZIP codes and redemptions per booking exported as CSV. |
Membership Growth | Keep track of the overall growth and performance of memberships in your venue or business. This report offers a detailed record of daily memberships sold and churned, along with an overall view of membership growth trends. This data allows you to track the performance of your membership program and business growth. |
Membership Redemptions | Track and analyze the redemption activity of your memberships. This report includes a comprehensive list of all memberships that have been redeemed within a specified time period. This data helps in understanding the usage patterns of memberships and provides insights for optimizing membership benefits. |
Membership Status Log | Track changes in membership status, helping you identify suspended memberships and monitor specific events like upgrades. The information in this report aids in managing and communicating with members effectively. |
Memberships | This report provides a detailed overview of all memberships. |
Operations
The reports in this section offer detailed insights into various aspects of bookings, discounts and staff performance, providing valuable data for effective operational management and accurate financial records.
Report | When to use |
---|---|
Bookings by Staff Member Export (PDF) | Track and organize bookings made by different staff members. The Bookings by Staff Member report provides a PDF list of bookings grouped by staff member. It includes information such as transaction date, booking date, booking ID, guest name, and booking amount. This report helps in efficiently tracking and organizing bookings made by different staff members. |
Discounts by Booking | Analyze and manage discounts applied to various bookings. This report offers a detailed list of discount redemptions, filterable by date and discount code. It provides information like the redemption date, booking ID, product name, booking amount after the discount, total discounted amount, discount name, and more. |
Discounts by Staff Export | Track and manage discounts applied by staff members. This report offers a detailed list of discounts performed per booking and product, grouped by staff member and exported to PDF. It provides information such as transaction date, booking ID, approving manager (if applicable), product name, and total amount discounted off the booking during the transaction. |
Discount Summary Export | Analyze the usage and impact of different discount codes. This report provides a summary of all discounts redeemed within a specified period, grouped by discount code and exported as a PDF. It includes data such as discount type, count of times the discount was applied, discount description, and the total discounted amount across all bookings for each discount. |
Session Punctuality Export | Track the punctuality of guests in relation to the scheduled session start times. This report allows you to compare session start times with redemption times, and it's exported as a CSV file. This report provides data on booking IDs, booking names, transaction dates, names on tickets, session times, and ticket redemption times at POS. |
Staff Gratuity | Track and manage gratuities (tips) within your business This report provides a detailed summary of gratuities received by staff members. It includes information on transaction dates, booking IDs, staff names, and the total amount of gratuities earned by each staff member. |
Till Discrepancy by Staff Export | Identify and address any cash discrepancies in closed tills. This report provides a summary of any discrepancies found in the till operations performed by staff members for a selected time period as a PDF document. It groups information by POS device and staff names and includes details such as the date and time stamp of when the till was closed and the total amount of the discrepancy. |
Till Reconciliation | Track and reconcile the activities of POS tills over a specified date range. This report provides a summary of POS till activities for a specified date range, including data on cash, card transactions and discounts. It's important to note that timely opening and closing of tills on the same day is crucial for accurate reporting and helps identify discrepancies or irregularities in the till sessions. |
Accounting
The reports in this section facilitate financial reporting, catering to both cash and accrual accounting methods. These reports provide detailed insights into deferred revenue, ledger summaries, sales tax and trial balance.
Report | When to use |
---|---|
Deferred Revenue by Booking | Track accrued deferred revenue for a selected time period. This report provides a summary list of deferred revenue per booking based on accrual revenue recognition. It offers data such as transaction date, recognized date, booking ID, status, booking name, deferred revenue and gift card deferred revenue for each booking up to the selected date. |
Ledger Summary | Track financial performance of reporting categories and General Ledger (GL) Codes and tax payable at the end of a period. This report in ROLLER provides a detailed financial overview by aggregating metrics for each reporting category and its corresponding GL Code. It allows users to track vital financial data, including funds received, tax amounts, gross revenue and more. |
Revenue Recognition | Get insight into the financial position of your business based on accrual accounting practices and validate the data you need for financial reporting. When using accrual accounting, this report provides a detailed view of the financial flow in your venue, starting from a transaction in ROLLER, through deferred revenue, and culminating in recognized revenue upon ticket redemption or expiry. It breaks down each booking into three distinct entries: Transaction (for payments or refunds), Recognition (for ticket redemption or expiration), and Adjustment (in case of booking modifications). When using cash accounting, accrual metrics and columns are removed from the report. |
Sales Tax | Manage sales tax liabilities by tax type for period based on accrual accounting. This report provides a summary of sales tax categorized by different tax types for a specific period. It allows you to view the total sales, taxable sales, non-taxable sales, and the amount of tax payable based on accrual accounting practices. This report is only available with accrual accounting enabled in your venue. |
Trial Balance | Verify the accuracy of financial transactions and prepare financial statements. This report offers a summary representation of funds processed and revenue for a specific period, distinguishing between debits and credits. It provides an overview of financial activity in your venue, helping you make sure that the accounting records are in balance. |
Xero Export (Accrual method) | This report allows you to generate a CSV file containing journal entries formatted for Xero Software. This export is based on accrual revenue recognition, making it compatible with Xero's accounting practices. |
Xero Export (Cash method) | The Xero Export (Cash Method) report is specifically designed for cash accounting. It generates a CSV file containing journal entries formatted for Xero Software, aligning with cash-based accounting practices. |
United States 1099-K tax form | Downloadable copy of the 1099-K tax form submitted to the IRS for United States entities. |