Use this report to understand which products are driving sales, where sales are coming from and how much money has been collected over a selected day, date or date range.
Track sales and performance
Use this report when you want to:
Identify your best-selling products and variations.
Compare sales across channels such as online checkout, POS, and Venue Manager.
Review sales by POS device during busy periods.
Track funds received for products sold over a selected timeframe.
Compare items sold with recognized revenue if your venue uses accrual accounting.
This report focuses on product-level sales and does not include gratuities, because tips are recorded at the transaction level.
Choose a different report for:
Detailed Transactions report — full transaction totals, including tips
Daily Summary report — an overview of daily sales and takings
Revenue Recognition report — recognized revenue
Sales Tax report — tax reporting
Why sales, payments and revenue may not match
Some values in this report can differ because they are based on different dates.
Quantity sold is based on when the item was purchased.
Funds received is based on when payment was collected.
Recognized revenue is based on when the item was redeemed at POS or expired, if your venue uses accrual accounting.
For example, if a guest books tickets today for a visit next week, the sale appears when the booking is made, payment appears when money is collected, and revenue is recognized only when the tickets are redeemed or expire.
If accrual accounting is enabled in Settings > Account > Venue settings, additional columns appear to help you compare sales activity with recognized revenue
Access the report
- From Venue Manager, go to Reports > All reports.
- Search for and select the Detailed Product Sales report.
- The report defaults to showing results for yesterday.
- Use the date selector to choose a different day, date or date range.
- Then select Apply filters to return results for the specific timeframe.
Filter the report
Use filters to answer specific questions about product sales.
- Use the date selector to report on a day, date, or date range.
- Filter by sales channel to compare where bookings were made, such as online checkout, POS, or Venue Manager.
- Filter by payment device to review sales from specific POS devices.
- Filter by product or product category to focus on individual items or grouped offerings.
After applying your filters, review the summary metrics and detailed table results for the selected timeframe.
| Filter | Description |
|---|---|
| Booking location (sales channel) |
Select where transactions were processed: Online checkout, POS, Venue Manager, Self-Serve Kiosk, Recurring Billing, API or Channel Partners. To narrow POS results further, use the Payment device filter. |
| Product |
Include or exclude specific products, product categories or archived products. Leave blank to include all products, including archived products with sales in the selected timeframe. |
Review summary metrics
At the top of the report, you’ll see summary metrics based on your selected filters. These help you quickly compare product sales and money collected before reviewing the detailed line items below.
| Metric | Description |
|---|---|
| Gross sales | Gross sales shows the total value of items sold before discounts, based on item price multiplied by quantity sold. It does not depend on whether payment has been collected. |
| Funds received | Funds received shows the amount actually collected during the selected time period, excluding gratuities or tips. |
| Gift cards redeemed | Indicates the value of product purchased using pre-paid gift cards as a payment type, which helps track gift card usage. |
These values may differ when bookings are paid later, paid in installments or booked for future dates.
Detailed data
The table shows product-level sales data for each item or variation. If your venue uses accrual accounting, additional revenue recognition columns are also available.
To show extra columns, right-click anywhere in the table and select the columns you want to display. Save your preferred layout to reuse it later.
Start by reviewing these key columns first:
Product name
Quantity sold
Gross sales
Funds received
Gift cards redeemed
If accrual accounting is enabled, also review:
Quantity recognized
Gross revenue
Tax payable
Net revenue
| Metric/attribute | Description |
|---|---|
| Cash & accrual | |
| Product Name | The name of the product or service sold. Each product variation sold has its own line "Product name - variation name". |
| Quantity Sold (Qty sold) | The total number of items sold per product variation. Quantity is based on when the guest purchased the item, regardless of whether the purchase has been paid for in full or the tickets redeemed. |
| Amount ($) | Price set for each product variation in product settings. |
| Discounts ($) | The total value of discounts applied on collected payments (funds received). |
| Gross Sales ($) | The total booking value before discounts are applied, including tax. Formula: Gross sales = Quantity sold x item amount |
| Funds Received ($) | The actual money collected after discounts are applied, including taxes and fees. |
| Gift Cards (GC) Redeemed ($) | The total value of gift cards used to pay for products. |
| Fees ($) | The amount of fees applied to items when paying online. |
| Credit Card Fees ($) | The fees charged to guests for online payments. |
| Ticket Fees ($) | The value of per ticket fees charged for each product. |
| Modifiers Amount (or Party package gross sales) ($) |
The funds received from modifiers sold (eg coffee add-ons). For party packages, this column shows the total booking value. |
| Vouchers Redeemed ($) | The total value of vouchers redeemed to purchase products (eg Groupon). |
| Reporting Category | The reporting or general ledger category assigned to each product. |
| Accrual only | |
| Quantity Recognised (Qty Recognised) ($) | The number of tickets/products recognized as revenue. Revenue is recognized when the item is redeemed at POS or is no longer valid and expires (accrual accounting). |
| Gross Revenue ($) | The total recognized revenue, including tax, based on redemption at POS or expiration. |
| Tax payable ($) | The total tax on recognized revenue (accrual accounting). |
| Net revenue ($) | The total value of revenue excluding tax based on redeeming tickets at POS or expiry (accrual method). Formula: Net revenue = Gross revenue - Tax payable. |
Export and download the report
- Select the download button at the top right of the page.
- Select Export (CSV).
- Select Alert me when complete to confirm the action. ROLLER will generate the data in the background.
- When the export is ready, open the notifications panel from the bell icon in the main menu and download the file.
Frequently asked questions
Total Funds Received is the actual amount of money that has been received by the venue and will account for fees, discounts and partial payments. If guests make partial payments (eg deposits or installment payments), the total reflects only the amount that has actually been paid so far, not the full booking value.
This is because the payment gateway has a different cut-off time for recording transactions. This report runs from midnight to midnight, whereas the payment gateway may have an earlier cutoff time (ie 5 PM).
For example, if a booking is made today and payment is taken tomorrow, the Quantity Sold will update today with the booked items.
However, the Funds Received will be updated tomorrow, showing the payment with no additional quantity sold.