Sales Report (Orders)

To view sales orders report, follow these steps:

Step 1 : Login to GrubCenter 

Step 2 : Navigate to Real-Time reports section

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

Users will be able to see these details in the Sales > Orders report.

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: The order date reflects when the order received in Grubtech platform.
 yy/mm/dd 00:00:00 (24h format) 

Type: Order delivery type such as (Delivery by restaurant or Delivery by food aggregator).

 

Customer Information: Customer Name, Telephone, and Address.

Note: If the order source (food aggregators) provides customer details, they will be visible; otherwise, no customer information will be displayed.

Currency: Account 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

Next Article: 

• Sales Orders Report - Download E-Invoice