---
title: "Where can I find a list of orders, customers and a break down of revenue?"
description: ""
url: https://helpcenter-web-production.up.railway.app/en/articles/8795898-where-can-i-find-a-list-of-orders-customers-and-a-break-down-of-revenue
collection: "Digital ordering / Reporting"
collection_url: https://helpcenter-web-production.up.railway.app/en/collections/10180067-reporting
author: "Mathieu Sneep"
last_updated: 2024-01-16T05:12:09.000Z
---
# Where can I find a list of orders, customers and a break down of revenue?

To view a list of orders, customers and a revenue breakdown, you can visit [kitchen.tablevibe.co](https://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.

![](https://helpcenter-web-production.up.railway.app/media/images/Export-orders-7b4652d223.png)

💡 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** |