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 | 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) | Sum of service fees paid by both customer and restaurant |
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). |
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 |
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 |