Vendor Transactions Report

For help accessing reports please see Accessing the Report Builder & Using the Options

Refining your Report 

You can use the dropdown menus to refine this report. 

Whole Day - This will set your set time frame parameters to whole days and there will be no need to set specific times of the day. 

Custome Time Range - This setting will change the time frame parameters to include specific times.

Order Time - This setting will define your search time parameters to pull the report according to the times that the orders were made.

Desired Fullmillment Date - This setting will define your search time parameters to pull reports according to the times that the orders were set to be fulfilled.

Both Order Time and Fulfillment Date - To select this option use the blue plus sign next to the dropdown box. You can then use the date rage boxes to create a report that includes both date ranges for each variable.

Reporting Columns 

The Vendor Transactions Report is used for food halls with multiple vendors. It combines the Transaction Detail Report for orders across all vendors. The following data is formulated for the transactions:

Date - Calendar date and time the 'order number' was placed by the guest and fulfilled by the ‘vendor’.

Location - The code attached to the ‘order number’ fulfilled by the 'vendor' on the 'date' signifying which Tables / Location Codes the order is attached to. Tables / Location Codes are located in the Owner Panel within Tables / Location Codes.

Vendor - The location supplying the guest with the items placed within their ‘order number’ on the 'date'. Vendors are usually located in a Food Hall. 

Is multi-vendor checkout - a 'Y' Yes or 'N' No field which shows whether a Transaction was a multi-vendor checkout. Multi-vendor checkouts will have the same transaction ID.

Transaction id - Unique Bbot ID associated with the ‘order number’ fulfilled by the 'vendor' on the 'date'.

Order number - The number(s) attached to the guest’s purchase on the 'date' to be fulfilled by the vendor.  Order numbers are searchable in the Owner Panel under ‘Past Order (receipts/refund)'.  For more information on accessing past orders please see How to Refund a Guest.

User id - Unique Bbot ID associated with the user who placed the ‘order number’ fulfilled by the 'vendor' on the 'date'

User signed in - Denotes whether the guest was signed into their Bbot account when placing the ‘order number’ fulfilled by the 'vendor' on the 'date'.

     0 - Not signed in

     1 - Signed in

Guest data captured at checkout - Information can be requested at checkout or required.  For more information on adding fields to capture information at checkout, please see Required Delivery Information.

In the example below the venue requires 'guest name' and 'guest phone' at checkout but only requests 'guest email'. 

Doordash Adjustments - This will include any fees or tips that are refunded for any Doordash fees or tips that are withheld for the order. When that amount is refunded, it is given back to whoever the money was taken from.

Consents To Special Offers - Denotes whether a guest consented to receive special offers when creating their Bbot account. 

N/A - The guest does not have a Bbot Account

yes - The guest was signed into their Bbot account when placing their order and consented to receive special offers

no - The guest was signed into their Bbot account when placing their order and did not consent to receive special offers

Num items - The total number of menu items chosen by the guest for the ‘order number’ fulfilled by the 'vendor' on the 'date'.

Num refunded - The total number of menu items refunded for the ‘order number’ fulfilled by the 'vendor' on the 'date'.

In the example below, order #732 for vendor Good Chicken had 2 items ordered and 1 item (Fried Pickles) refunded. 

Promotions - You can see which Promotions were available, used, and the amount used for the 'order number' fulfilled by the 'vendor' on the 'date.' For more information on promo codes please see Creating Promo/Discount Codes.

Pretax sale - Total dollar amount of sales before tax for the ‘order number’ fulfilled by the 'vendor' on the 'date'.

Service Fees Pretax - Total dollar amount of service charges before tax applied to the ‘order number’ fulfilled by the 'vendor' on the 'date'.

Delivery charge - Total dollar amount of service charges applied to the ‘order number’ fulfilled by the 'vendor' on the 'date'.

Tax - Total dollar amount of tax on the ‘order number’ fulfilled by the 'vendor' on the 'date'.

Tip - Total dollar amount of tip the guest applied to the ‘order number’ fulfilled by the 'vendor' on the 'date'.

Total - Total dollar amount of the sale for the ‘order number’ fulfilled by the 'vendor' on the 'date'.

Bbot and processing fees - Total dollar amount of fees applicable to the ‘order number’ fulfilled by the 'vendor' on the ‘date’ which may include Bbot, third party delivery, or any other third party service fees. 

Bank transfer after fees - Shows the total dollar amount for a bank transfer to the parent account as well the bank transfer to a merchant account for the total dollar amount for the. The total dollar amount for the ‘order number’ fulfilled by the 'vendor' on the 'order date’ that will be transferred to the venue's bank account through Stripe.

Items - The menu items sold or refunded for the ‘order number’ fulfilled by the 'vendor' on the 'date.