The Transactions by Product report shows your venue's revenue position in terms of cash accounting practices.
What is this report used for?
- The Transactions by Product 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 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.
- Booking location - this filter is used to select where the transaction was processed. Some things to note:
- All bookings
- Online Bookings Only refers to transactions made via your online checkout and will go through your online payment gateway. These will all be either Credit Card or Paypal
- POS refers to transactions made via ROLLER Point of Sale at the venue. You can select individual POS devices with this filter
- Venue refers to transactions processed by staff members in the ROLLER Venue Manager
- Product name - 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
In order to adjust the column displayed on the report, select the window icon:
The columns available are:
- Product Name is the name of the ticket type that was checked in
- Unit Cost is the currently set cost of the ticket type. 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
- Quantity 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
- Total Sales is the value of the sales of each product. This is an exact calculation of Unit Cost multiplied by Quantity Sold and ignores any discounts, missing payments and fees
- Funds Received is the actual amount of money received for each product. This includes fees, and the sum of all of these values will match the total funds received on your Transaction Report. Funds received is based on when the venue receives payment for the booking
- Gift Card Redemptions is the value of gift cards redeemed to purchase each product
- Transaction Fees is the value of transaction fees charged for each product
- Credit Card Fees is the value of credit card fees charged for each product
- Per Ticket Fees is the value of per ticket fees charged for each product
- Booking Modifiers is the value of modifiers that make up the funds received for each product, eg. coffee modifiers that demand an additional cost
- Discounts is the value of discount codes or complimentary bookings that have been issued used each product
- Quantity Recognised is the number of tickets/products that have been recognised as a sale. Quantity is recognised when the item is redeemed (used) or expired
- Recognised revenue is the earned revenue (once it is redeemed). This should add up to the accrual accounting report recognised revenue. Revenue is recognised when the item is redeemed (used) or expired
- GL Code is the GL code assigned to that ticket type (if applicable)
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 Total Sales and Total 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. The Transaction 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 Transactions by Product report can also be used to calculate a venue’s revenue figure over a time period if they are using the cash accounting method.