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, such as when tickets are redeemed at POS or expire 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 .
Customize, save and reuse report views
You can customize the default reports in ROLLER to display your desired data. You can filter data, edit, sort and group columns and select different days, dates and date ranges.
You can then save the customized 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
On the Reports > All reports page, often referred to as the reporting homepage, we've organized all the reports into categories based on the type of data they provide.
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. It also includes a net revenue metric for the day, showing how much revenue (ie service provided) was recognized for accrual accounting venues. This metric is removed for venues using cash accounting. |
Sales
Here, you can find out how many items you sell for different products or product categories and which sales channels (eg, online or at POS) generate the most sales and net revenue. These reports help you figure out how well the different areas of your business are 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. |
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. It offers details such as gift card 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 selected period. It presents data on quantities sold, total product sales value, discounts applied, and fees incurred. This information 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 selected time period. |
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 total gift card sales for the selected time period, allowing you to track sales value generated and discounts applied to gift card purchase values. |
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 detailed view of package sales, including the revenue that has been recognized through ticket redemptions. This means it outlines the sales figures and recognizes revenue as redeemed tickets (ie service delivered) 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 owed for bookings that have been redeemed or have expired. This report helps you identify bookings that have been made but are pending payment or partially paid. You can use it to contact guests and collect these payments. |
Detailed Transactions | Monitor the total funds received from various sales channels by transaction. 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 such as guest names and transaction reference numbers. |
Recurring Payment Log | Track recurring membership 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 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 (ie payment method and sales 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. |
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 your venue's attendance patterns by tracking the number of POS redemptions for your ticketed products. This report can provide insights into guest attendance by showing the total quantity of ticket redemptions at POS, the device used for redemptions and the most redeemed ticketed products. |
Booking zip code |
A detailed list of ZIP codes and redemptions per booking, exported as CSV. |
Membership Growth | Keep track of the overall growth and performance of memberships. This report offers a detailed record of daily memberships sold and churned and 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 usage activity of your memberships by monitoring membership redemptions. This data helps understand 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 helps you manage and communicate 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 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 efficiently track and organize bookings made by different staff members. |
Discounts by Booking | Monitor discounts applied to various bookings. This report offers a detailed list of discount redemptions, which can be filtered by date and discount code. It provides information such as 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 and see which tickets have not been redeemed at POS (eg no-shows). 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 Bookings | Track accrued deferred revenue for a selected time period. This report provides a list of deferred revenue by booking based on accrual revenue recognition. It provides 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, etc. |
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 your venue's financial flow, starting with a transaction in ROLLER, through deferred revenue, and culminating in recognized revenue upon ticket redemption or expiry. It breaks down each booking into three different types of entries: transaction (for payments or refunds), Recognition (for ticket redemption or expiration) and Adjustment (in case of booking modifications or cancellations). Accrual metrics and columns are removed from the report when using cash accounting. |
Manage sales tax liabilities by tax type for periods based on accrual accounting or cash 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 due based on accrual (tax payable) or cash (tax collected) accounting practices. |
|
Trial Balance | Verify the accuracy of financial transactions and prepare financial statements. This report summarizes funds processed and revenue for a specific period, distinguishing between debits and credits. It provides an overview of financial activity in your venue and helps ensure 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. |