The Detailed Product Sales Report (previously Transactions by Product report) shows your venue's revenue position in terms of cash accounting practices. This report was formerly known as the Transaction by Product or Product Revenue Report.
What is this report used for?
- The Detailed Product Sales Report shows the value of all of the transactions your venue has processed over a selected date range, broken down per individual product you offer
- The purpose of using this report is to see how much money has been taken across all of the different products you offer. The difference between this report and the Detailed Transaction Report is that instead of seeing each individual transaction, you can only see the sum of transactions broken down by product
How does it work?
- This report recognises revenue when you receive the money
- The date bar enables you to adjust the time frame for this report
What data can you see?
You can filter the report by booking location and product name.
- Channel - this filter is used to select through which channel the transaction was processed. Some things to note:
- All will show you the product sales across all channels
- Online checkout refers to transactions made via your online checkout and will go through your online payment gateway
- POS refers to transactions made via ROLLER Point of Sale at the venue. You can then also select individual POS devices with the Booking device filter
- Venue manager refers to transactions processed by staff members in the ROLLER Venue Manager
- Self-serve kiosk refers to transactions done through the Self-Serve Kiosk
- Recurring billing refers to transactions processed due to a recurring payment, usually for memberships
- API refers to any transactions processed using ROLLER's API
- Product - this filter is used to include or exclude certain products from appearing on the report. Leaving it blank will include all products including archived product if there is a booking for that product on the selected date range. If you click Select all, it will only include products that are active as at the day you run the report
To learn how to adjust the columns displayed, group the data or change the ordering we suggest you check out our guide on using the Reporting Grid.
The columns available are:
- Product name is the name of the ticket type that was checked in
- Quantity sold (Qty sold) is the number of these tickets that have been sold. If you have a group pass (eg. Family Pass) that provides 4 individual tickets when you purchase one pass, each pass will be 4 units sold. Quantity sold is based on the day the booking was made
- Amount is the currently 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 will be the cost per ticket. For example, a $40 Family Pass will have a unit cost of $10
- Gross sales is the value of gross sales before discounts and including tax. This is an exact calculation of Qty sold multiplied by Amount and ignores any discounts, transaction fees or missing payments.
- Discounts is the value of discount codes or complimentary bookings that have been issued for each product
- Fees is the amount of fees applied to your guests for their online payment
- Credit card fees is the value of card fees charged for each product
- Ticket fees is the value of per ticket fees charged for each product
- Modifiers amount is the revenue attributable to stock modifiers sold e.g. coffee modifiers that demand an additional cost
- Funds received is the actual amount of money received for each product. This is Gross sales less Discounts plus any Fees
- Gift cards redeemed (GC Redeemed) is the value of gift cards redeemed to purchase each product
- Vouchers redeemed is the value of vouchers redeemed to purchase each product
- Reporting category is the name of the reporting or general ledger category assigned to each product
- Quantity recognised (Qty recognised) is the number of tickets/products that have been recognised. Revenue is recognised when the item is redeemed or expired (accrual method)
- Gross revenue is the value of revenue including tax for each product based on redemption. Revenue is recognised when the item is redeemed or expired (accrual method)
- Tax payable is the total value of tax payable for each product based on redemption (accrual method)
- Net revenue is the total value of revenue excluding tax based on redemption (accrual method). This is Gross revenue less Tax payable
How is this report activated?
You will need to contact your Account Manager to activate this report. Additional fee may apply
- What's the difference between Sales and Funds Received?
Total 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 this such as 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 (i.e. 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.
The Detailed Product Sales Report can also be used to calculate a venue’s revenue figure over a time period if they are using the cash accounting method.