Reports
Reporting update planned for 6 November 2026
Read about the upcoming reporting changes, including payment and refund dates, POS summaries, and merged orders.
Note
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.
In the sales reports below, non-cancelled orders exclude original orders merged into another order. Detailed order-history reports can still include those originals when their statuses are selected.
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 during the reporting period (the current calendar day).
From the planned 6 November update, this will mean successful payments processed during the period less successful refunds processed during the same period, including refunds of earlier payments. A day with more refunds than payments can show a negative Payment Total.
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
Cash Collected
From the planned 6 November update, this will show successful cash payments less successful cash refunds in the reporting period. A cash refund of a card payment will reduce Cash Collected on the refund date.
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 surcharges 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). |
Info
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).
From the planned 6 November update, finalised payments will be selected by processing date. Successful refunds will be included in their own processing period, even when the original payment was earlier. Payments still being processed will use their creation date until they are finalised.
The same transaction reference can appear in the payment period and a later refund period. A refund-only appearance will show $0.00 Payment Amount and a negative Total Collected.
The reported fields will operate as follows after the update.
| 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. |
| Payment Method | The method used for the original payment. Refunds made using another method are attributed to that method in Payment Methods reports. |
| Currency | The currency of the transaction. |
| Payment Amount | The payment value recorded for the selected period, after cash change. A row included only because of a later refund shows $0.00. This field can be non-zero for an unsuccessful payment; check Status and Total Collected. |
| Refund Amount | The amount successfully refunded during the selected period against the original payment. |
| Total Collected | Successful payment amounts less successful refunds in the selected period. An unsuccessful payment contributes no collected amount; refund-only activity can make this value negative. |
| Processed | The date-time of the latest included payment or refund activity. Shows - while the payment is unfinalised; scheduled CSV attachments leave this cell blank. |
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.
From the planned 6 November update:
- Successful refunds will be included in their own processing period and against the method used to return the money.
- Refund Count will count individual successful refunds.
- Refund amount/count views will omit methods with no successful refunds in the selected period.
- Total Collected will be successful payments less successful refunds in the selected period, and can be negative.
See the before/after examples for refunds on another day or using another payment method.
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. |
Info
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.