Use the Detailed Product Sales report to understand your products' financial performance, helping you to make informed business decisions. This report shows the value of all transactions processed by your venue on a specific day or within a chosen date range, categorized by each individual product you offer.
The permission Can access Sales reports is required to access the Detailed Product Sales report. Administrators and manager system roles have this permission enabled.
What is this report used for?
The Detailed Product Sales report gives a full overview of funds received and revenue for each product. You can filter it by specific products, booking locations, POS devices and dates.
It's useful for understanding total revenue across your products. For instance, you can quickly see how much each product earns.
Unlike the Detailed Transactions report, the Detailed Product Sales report shows an overall view of transactions grouped by product, not each individual transaction.
Compare cash and accrual figures
This report helps figure out revenue for a specific time, especially with cash accounting. Cash accounting records revenue when money is received in ROLLER, regardless of the booking date.
For accrual accounting, extra columns show revenue recognized when it's earned, not just when payment is received. In ROLLER, this is based on the booking date or ticket expiry date (depending on the product).
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.
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.
| Filter | Description |
|---|---|
| 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:
| Metric | Description |
|---|---|
| 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 payments processed for the time period. |
| Gift cards redeemed | The total value of gift cards redeemed for the time period. |
What data can you see?
To see columns listed below that are not in the default report view, right-click the table and select the columns you want. Then save the view so you can easily run the results you want again.
If you're using accrual accounting method for your venue, additional columns are included in the report. The columns available are:
| Mertic/attribute | Description |
|---|---|
| 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 ($) | Total value of discounts redeemed (on funds received). |
| 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 money received for each sale, less any discounts and including fees. This is determined by the day the payment is received, not when the item is sold. |
| 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 (eg 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. |
Frequently asked questions
What's the difference between Gross Sales and Funds Received?
Gross Sales is simply a calculation of price multiplied by quantity sold for all of your items. Total Funds Received is the actual amount of money that has been received by the venue, and will account for fees, discounts and missing payments.
Why does this not match my banking statement?
Depending on your payment gateway, you may notice that some transactions are recorded the day after it actually occurs. This is because each payment gateway has different cutoff time on when transactions are being recorded. This report runs from midnight to midnight, whereas the payment gateway may have an earlier cutoff time (ie 5 PM).
Why am I seeing 0 quantity sold but there are funds received?
The Quantity Sold column is based on the day the booking for that item is made, whereas the Funds Received column is based on the day payment is received. For instance, if you made a booking today and took the payment tomorrow, you will see the Quantity Sold number increase by the number of items booked, but only see the balance on the Funds Received column tomorrow with no quantity sold.
How is quantity sold impacted by a booking cancellation?
The quantity sold decreases on the date of cancellation, not the date of sale (if different).