All Collections
Payments and refunds
Where can I find a list of orders, customers and a break down of revenue?
Where can I find a list of orders, customers and a break down of revenue?
Carrie avatar
Written by Carrie
Updated over a week ago

To view a list of orders, customers and a revenue breakdown, you can visit kitchen.tablevibe.co and click on "All orders" in the left hand side menu. On that page, click on "Export Orders" to download a .CSV report.

💡 Even canceled orders are still reflected on the exported file.

The report will be automatically downloaded by your browser after clicking on "Export Orders" once. Please note this may take a few minutes.

You may refer to the tables for the columns reflected in the "Export Orders" file.

Order Information

Order Ref

Ordered at

Ordered for

Type

Track this reference on your Orders Dashboard or on your mobile device

Time that the order was created

`estimated_completion_time` of the order
- If it’s a Delivery and a Pre-Order, we show the `schedule_time`
- If it’s a normal Delivery, we show the `estimated_delivery_time` (Delivery time provided by the Delivery Partner)
- If it’s a Pickup (Pre-Order or not), we show the `estimated_pickup_time`

Delivery/ Pickup/ Dine In

Customer Name

Customer Email

Customer Phone

Marketing Approved

Check whether the customer subscribed to marketing emails during the ordering process

Brand

Location

Status

Cancellation Reason

Determines the brand the order came from

Determines which branch the order is coming from

Action status of the order upon exporting

Reason for cancellation

Cancellation Comment

Currency

Payment Method

Promo Code

Extra comments on the cancellation (can be blank)

Check the mode of payment the customer used

Identify if the customer used a promo code for the order

Customer Payment Information

Subtotal *

Discount Given *

Promotion Given *

Total food costs after discounts before promo codes

Discounts given via the Discount feature resulting in a reduced subtotal

Promo-code discounts given. This amount is deducted after the subtotal

Cashback *

Service Fee Customer *

Delivery Fee Customer *

Cashback discount given. This amount is deducted after the subtotal

Amount paid by the customer on service fees

Amount paid by the customer on delivery fees

Tip

Total VAT

Total Paid Customer *

This is tax-exempt

Taxes from products, services, and delivery fees

Total amount the customer paid

* - VAT inclusive

Fees to Tableivbe

Total third party Delivery Fee (VAT Exc)

Total Service Fee (VAT Exc)

Total 3rd party delivery fees paid by both the customer and restaurant (`self-deliveries` have no charge)

Expect a charge if no free delivery discount was made
Expect 0 charges if:
1. Free delivery promo
2. Pick up, cancelled or completed deliveries
3. Self Delivered

Sum of service fees paid by both customer and restaurant

- Completed orders are always charged
For Canceled orders
- Expect a charge if any delivery was charged or already booked
- 0 if no delivery was booked
- 0 for pickup orders

Total Platform Fee VAT

Total platform fee including VAT

We are currently VAT exempt so expect this to be 0

Total third party Delivery Fee and the Total Service Fee to be paid to Tablevibe

Payment

Automated deduction*

Additional transfers*

In cases where orders are changed with upgrades/downgrades or when there was no online payment this may require an additional transfer. However, this is a case to case basis since we automatically deduct the total platform fee from each customer payment if possible.

(i.e. delivery upgrades/downgrades, pay on pickup, self-deliveries, etc).
A positive value means that there were extra costs on the delivery that need to be charged to the restaurant.

0 additional cost if delivery fees were not changed and the order was paid online

Total Additional Fees Paid *

Total Fees Due *

The sum of the automated deductions and the additional transfers made. This is the amount that they should receive from Stripe/Xendit (after deducting their transaction fees if any)

If no transfer was possible (i.e. limited balance). This column shows the total amount due to still pay manually.

* - VAT inclusive

Additional Info

Payment ID

Reference of the payment intent created for Xendit/Stripe, useful to match with their reports.

Platform Fee Refund

This column shows if the order is eligible for a platform fee refund if the order got cancelled.

- Delivery → No rider assigned, or cancelled, or is an online payment
- Pickup → Cancelled and online payment

Gateway payout account ID

Reference number for the payout the order will be in

Delivery Partner order id

Driver accepted at

Driver picked up at

Driver delivered at

Did this answer your question?