Reports

The Orders and Transactions tabs within the console are not intended for use as reports - they are intended to allow merchants to quickly locate a specific order or payment for further action (such as processing a refund or re-sending a receipt).


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).



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 Reference 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 completed 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

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 customise the display name of table numbers in the console, however in this report it will always be displayed as "Table Number".


Daily Sales Report

The daily sales report is an extension of the "order total" metric reported on the dashboard, reported on a per-day-per-month 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.