Sales Orders Report

This report provides a detailed view of individual orders processed through the GrubTech platform. It includes comprehensive data points such as order details, pricing breakdowns, customer information, and payment statuses. This report supports filtering, searching, and exporting, offering actionable insights into sales operations.

 

To view Orders Report  please follow below steps

Step 1 : Login to GrubCenter as the user with Real-Time Reports permissions set (e.g. Admin)

Step 2 : Navigate to Real-Time reports section

Step 3 : Select ”Sales - Orders” from the list of the reports to view the details

Sales Orders Report - content:

Order ID - GrubTech order ID

Unique Order ID - order ID which was shared by Food Aggregator (external Order ID)

Sequence ID - number generated as order sequence

Brand - name of brand which received current order

Channel - name of the order channel (e.g. Talabat, Jahez)

Received At – yyyy/mm/dd 00:00:00 (24h format) - reflect when the order was received by GT platform

Type - delivery type e.g. Delivery by restaurant or Delivery by food aggregator

Customer Information:

• Customer Name
• Telephone
• Address

Currency - partner currency, configured during account creation

Item Price

Calculation: Item Price = SUM of Menu Item price + SUM of Modifiers (with VAT)

Surcharge - Small order fee. Surcharge will fulfill minimum order amount

Delivery - delivery charge

Net Sales – calculated considering total net price values based on no of orders.

Calculation: Net Sales = Total Earnings - Tax (VAT) = Gross Sales - (discounts+vat) = (Total Value of Orders + Applicable Charges - Discount ) - TAX Amount

Gross Price – Total price of the items in an order before the discounts + all applicable charges (e.g. delivery or service charges, environmental fee)

Calculation: Gross Sales/Price = Total Item price before discount = Total modifiers price before discount + Delivery Cost + Applicable Charges + Total VAT

Discounts – total discounts that are applied to the individual items in the orders or to the basket total

Calculation: Discounts = Discount 1 + Discount 2 + … Discount X

VAT – calculated considering total tax amount based on no of orders

Calculation: VAT = VAT 1 + VAT 2 + … VAT X = ((Total Order Amount - Discount) x Y/100) / ( 1 + Y/100)

WHERE: Y is VAT percentage value

Extra Charges (dynamic columns) - 

Extra Charges which were defined on GT → Account Settings → Charge Management.

Value displays total amount of the each charge applicable to the menu item in the order

e.g. Carbon Offset Fee, Packaging Fee, Security Charges, Beverage Container Fee

Receipt Total – VAT Inclusive total price.

Calculation: Receipt Total = Total Price = total item price + applicable charges - discount

Channel Service Charge - part of *applicable charges

Payment Type:

• PREPAID
• POSTPAID
• UNPAID
• FOC

Payment Method

• CASH
• CARD
• FOC
• MIXED
• PREPAID
• VOUCHER

Delivery Partner Name – name of the delivery partner which was responsible for delivery of the order. Received from 3PL or Integrations

Delivery Plan – name Instant or Scheduled delivery

Note – order Note which was placed by GrubTech if there was any issues with order

Customer Note – order level instructions placed during order creation

Employee Name – name of the employee/cashier who created the order on POS