Reports
While loyalty point and stored value transactions are reflected in all of our reports, our GTO integrations do not report loyalty transactions to mall management as of 16/07/2024. If your mall specifically requires these to be reported please contact your account manager for assistance.
Dashboard
The dashboard provides a quick summary of today's performance. While it is not a substitute for actual reports, it does provide useful metrics that can be tracked throughout the day.
Order Count
A simple count of all non-cancelled orders placed within the reporting period (the current calendar day).
Order Total
The aggregate total value of all non-cancelled orders placed within the reporting period (the current calendar day). Total value is the aggregate value of the line items including discounts, surcharges and taxes, before payments.
Payment Total
The aggregate net collected from all successful payments within the reporting period (the current calendar day). Net collected is the value of the transaction, less any refunds that have been processed.
There are a number of situations where this metric won't match the "Order Total", including:
- When there are orders that have been placed with Pay @ Counter, but are yet to be paid
- Any refunds have been processed
- The order was placed outside of the reporting period (for example, 11:59pm the day before) and payment was processed within the reporting period
- An order was cancelled, but the associated payment(s) have not yet been refunded
- Cash rounding
Most Recent Orders
A simple list of the 5 most recent orders (regardless of cancellation status) placed within the reporting period (the current calendar day).
Most Popular Items
A simple list of the 5 best selling (by quantity) items associated with orders placed within the reporting period (the current calendar day).
Order Summary
The order support report provides a snapshot of the orders that have been processed.
The reported fields operate as per the below table.
| Field | Description |
| Order Number | The "order number" associated with the order. |
| Outlet | The name and locality of the outlet associated with the order. |
| Placed | The date and time that the order was successfully placed by the customer. This occurs when a successful payment is processed against the order, or the customer requests Pay @ Counter, whichever comes first. |
| Service Type | The service type requested by the customer. |
| Table No * | The "table number" entered by the customer. |
| PAX | The number of customers associated with the order (if supplied). |
| Status | The current status of the order. |
| Collect/Deliver At | The date and time that the customer has scheduled the order for collection/delivery. ASAP orders will show - for this field. |
| YQueue Delivery Fee | The fee levied by YQueue on behalf of an external delivery partner. This is a legacy field and will only show a non-zero value for orders that were previously delivered by Lalamove or GoGoX. |
| Subtotal | The order subtotal. |
| Total Discounts | The total value of all discounts applied to the order. |
| Total Surcharges | The total value of all discounts levied against the order. |
| Total Taxes | The total value of all taxes levied against the order. |
| Total | The total value of the order (after discounts, surcharges and taxes). |
| Cash Rounding | The value of any cash rounding that has been applied to the order due to a cash payment. |
| Balance | The outstanding/unpaid amount against the order. This is the total value of the order, minus any successful and non-refunded payments against the order. A non-zero value will be shown for any order that does not have payments equal to the total value of the order, regardless of the cancellation status. |
| Promo Codes(s) | The promo codes that were applied to the order (if any). |
| Source App | The application that was used to place the order. |
| Customer Name | The name of the customer that placed the order (if known). |
| Customer Email | The email address of the customer that placed the order (if known). |
| Customer Number | The phone number of the customer that placed the order (if known). |
* Merchants can customize the display name of table numbers in the console, however in this report it will always be displayed as "Table No".
Transaction Summary
The transaction support report provides a snapshot of the transactions that have been processed (or are being processed).
The reported fields operate as per the below table.
| Field | Description |
| Order Number | The order number associated with the transaction. As an order can have more than one transaction, it is possible for the same order number to appear multiple times. An order number will only be generated for an order that has at least one successful transaction, or Pay @ Counter was requested. |
| Outlet | The name and locality of the outlet associated with the transaction. |
| Txn Ref | YQueue's internal reference for the payment. |
| Status | The status of the payment (irrespective of refunds) reported to YQueue by the associated payment gateway. |
| Gateway | The payment gateway that was used to process the transaction. |
| Tender | The tender that was used for the transaction. |
| Currency | The currency of the transaction. |
| Payment Amount | The amount tendered by the customer. |
| Refund Amount | The amount successfully refunded against the original payment. |
| Total Collected | The payment amount, minus any successful refunds. This will always be $0.00 if the original payment was not successfully processed. |
| Processed | The date-time that the gateway finished processing the transaction. |
SKU Report
The SKU reports allows merchants to track the performance of individual items, modifiers and meals associated with non-cancelled orders placed during the desired reporting period. It is possible to group results by day, week or month and compare gross sales or quantity (due to the grouped nature of the report, gross sales and quantity are reported separately).
A item/modifier/meal will be included in the SKU report regardless of the payment status of the associated orders. The SKU report also does not consider discounts, taxes or surcharges when reporting the gross sales for an SKU (as the gross sales is simply quantity multiplied by unit price).
The reported metrics operate as per the below table.
| Catalog Type | Gross Sales | Quantity |
| Item | The value of the item, multiplied by quantity ordered after the allocation of modifiers, meals, discounts, surcharges and taxes. | The total quantity ordered. |
| Modifier | The value of the modifier, multiplied by the quantity ordered before the allocation discounts, surcharges and taxes. | The total quantity ordered. |
| Meal | The value of the meal, multiplied by the quantity ordered before the allocation of modifiers, discounts, surcharges and taxes. | The total quantity ordered. |
Payment Methods Report
If you accept loyalty point or stored value transactions we recommend you discuss your tax implications with your accountant and adapt the values reported accordingly.
The payment methods report allows merchants to track which payment methods are used by their customers during the desired reporting period. In addition to the summary report, it is possible to group results by day, week or month and compare payment count, refund count, payment amount, refund amount and total collected.
A payment will be included in the report if it was successfully processed within the desired reporting period, regardless of the status (or date) of the associated order.
Order Items Report
The order items report allows merchants to view a breakdown of the individual line items within each non-cancelled order placed during the desired reporting period.
A line item will be included in the order items report regardless of the payment status of the associated orders.
The reported metrics operate as per the below table.
| Metric | Behavior |
| Order No | The number of the order associated with the line item. |
| Order Time | The date & time that the order was placed. |
| Customer Name | The name of the customer that placed the order (if known). |
| Customer Number | The mobile number of the customer that placed the order (if known). |
| Table Number * | The table number associated with the order (if any). |
| PAX | The PAX associated with the order (if any). |
| Item Name | The name of the item that was ordered. |
| Quantity | The quantity that the customer ordered. |
| Price | The individual unit price of the item that was ordered before modifiers, meals, discounts, surcharges and taxes. |
| Total Price | The price of the item multiplied by the quantity ordered after the allocation of modifiers and meals, but before the allocation of discounts, surcharges and taxes. |
| Total Discounts | The total value of any discounts applied to the item. |
| Promo Code(s) | The promo code(s) that were associated with the line item. |
* Merchants can customize the display name of table numbers in the console, however in this report it will always be displayed as "Table Number".
Daily & Hourly Sales Report
The daily/hourly sales report is an extension of the "order total" metric reported on the dashboard, reported on a per-day-per-month or per-hour-per-day basis. It is the aggregate total value of all non-cancelled orders placed during the desired reporting period. Total value is the aggregate value of the line items including discounts, surcharges and taxes, before payments.
Promo Code Usage Report
The promo code usage report allows merchants to quickly determine the frequency of redemption for all promo codes associated with non-cancelled orders placed within the desired reporting period.
If a promo code was unused within the report period (or was only associated with cancelled orders), it will not be included in the report. Additionally, a promo code will be included in the promo code usage report regardless of the payment status of the associated orders.
Reimbursement Report
This report allows merchants to view the expected reimbursement amount from YQueue and any third-party payment gateways that were used to process customer payments on the YQueue platform.
This report is rolling out to all merchants in Singapore over the coming weeks.