The Detailed Product Sales report shows the value of all the transactions your venue has processed on a specific day or over a selected date range, broken down per individual product you offer.
What is this report used for?
The Detailed Product Sales report provides a comprehensive summary of revenue and funds generated by each product. It allows you to filter the report based on specific products, booking locations, devices, and dates.
This report is particularly useful for gaining insights into the total revenue generated across your different product offerings. For example, you can easily determine the amount of revenue earned by each individual product.
The main distinction between the Detailed Product Sales report and the Detailed Transaction report is that the former provides an aggregated view of transactions grouped by product, rather than displaying each individual transaction.
Additionally, this report can be used to calculate revenue over a specific time period, especially when adopting the cash accounting method. If you're using accrual accounting method for your venue, additional columns are included in the report.
By leveraging the Detailed Product Sales report, you can gain valuable insights into the financial performance of your products and make informed business decisions.
How do I run the report?
The Detailed Product Sales report is located in the Sales section of the All reports page in ROLLER.
- From Venue Manager, go to Reports > All reports.
- Search for and select the Detailed Product Sales report.
To learn how to adjust the columns displayed, save a particular view of results, group the data or change the ordering, refer to the guide Using the reporting grid.
Filter your results
- The date selector at the top of the page enables you to adjust the timeframe for this report.
- The filters enable you to return results based on booking location, payment device, specific product/s or the product categories you've set up. Make sure the products you want are assigned to the right product category if using this filter.
|Booking location||This filter is used to select where the transaction was processed. Some things to note:
|Product||This filter is used to include or exclude certain products from appearing in the report. Leaving it blank will include all products, including archived products if there is a booking for that product within the selected date range. If you choose "Select all", it only includes products that are active for the day or time period you run the report for.|
Review a summary of results
For the date or time period and filters selected, you can see at the top of the report:
|Gross sales||The total value of products before discounts and including tax for the period as filtered. This is an exact calculation of quantity sold multiplied by the amount of units sold and ignores any discounts, transaction fees, or missing payments.|
|Funds received||The total value of actual funds received as filtered for the period. This is gross sales less discounts plus any fees.|
|Gift cards redeemed||The total value of gift cards redeemed as filtered for the period.|
What data can you see?
If you're using accrual accounting method for your venue, additional columns are included in the report. The columns available are:
|Product Name||The name of the product that was sold or redeemed. For passes, each ticket type is listed. For stock and add-on products, each variety is listed here.|
|Quantity Sold (Qty sold)||The total quantity of products sold. If you have a group pass (eg Family Pass) that provides 4 individual tickets when you purchase one pass, each pass is 4 units sold. Quantity sold is based on the day the booking was made, not redeemed.|
|Amount ($)||The current set unit sale value of the product. If you adjust the price, this number will change accordingly. If you have different prices for the same product, it will have two different lines for each ticket - one for each price. If you have a group pass (e.g., Family Pass) that provides 4 individual tickets when you purchase one pass, the unit cost is the cost per ticket. For example, a $40 Family Pass has a unit cost of $10.|
|Discounts ($)||The value of discount codes or complimentary bookings that have been issued for each product.|
|Gross Sales ($)||The total value of gross sales before discounts and including tax. This is an exact calculation of quantity sold multiplied by the amount of units sold and ignores any discounts, transaction fees or missing payments. Gross sales = Total units sold.|
|Funds Received ($)||The actual amount of money received for each product. This is gross sales less discounts plus any fees.|
|Gift Cards (GC) Redeemed ($)||The total value of gift cards redeemed to purchase each product.|
|Fees ($)||The amount of fees applied to your guests for their online payment.|
|Credit Card Fees ($)||The value of card fees charged for each product.|
|Ticket Fees ($)||The value of per ticket fees charged for each product.|
|Modifiers Amount ($)||The revenue attributable to stock modifiers sold (eg coffee modifiers that have an additional cost).|
|Vouchers Redeemed ($)||The value of vouchers redeemed to purchase each product (e.g., Groupon).|
|Reporting Category||The name of the reporting or general ledger category assigned to each product.|
|Quantity Recognised (Qty Recognised) ($)||The number of tickets/products that have been recognized. Revenue is recognized when the item is redeemed or expired (accrual method).|
|Gross Revenue ($)||The value of revenue including tax for each product based on redemption. Revenue is recognized when the item is redeemed or expired (accrual method).|
|Tax payable ($)||The total value of tax payable for each product based on redemption (accrual method).|
|Net revenue ($)||The total value of revenue excluding tax based on redemption (accrual method). This is gross revenue less Tax payable.|