Transaction Details Report

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

The Transaction Detail Report shows each order and associated guest information. At food halls, the same information is available on the Vendor Transaction Report. (Note: this report isn't always enabled. If this report does not show in your Report Builder, it can be added by request to support@bbot.menu.)

The Transaction Detail report shows the following information:

Date - Calendar date and time the 'order number' was submitted. 

Location - The code attached to the 'order number' on the 'order date' signifying which ‘Tables / Location Codes’ the order was placed from.  Please see Location Codes for more information.

Transaction id - Bbot number associated with the ‘order numbers’ on the ‘order date’.  This uniquely identifies a specific order in Bbot. (Because the guest-facing Order Numbers wrap around and repeat after Order 999.) The order id can be used to search for the order in other reports.

Order number - Number associated with the guest's order on the 'order date'.

User id - Bbot number associated with the guest or device the guest used when placing the 'order number' on the 'order date'. 

User signed in - Denoted with a '1' or '0.' '1' if the user has an account with a username and password and '0' if the guest ordered without signing in.

Guest name - The name the patron entered at checkout when submitting the 'order number' on the 'order date'. 

Guest phone - The phone number the patron entered at checkout when submitting the 'order number' on the 'order date'.

Guest email - The email address the patron entered at checkout when submitting the 'order number' on the 'order date'. 

Guest information can be collected by default and used for marketing.  Please see Marketing Opt-In at Checkout for information on set-up.

For more information on capturing guest information at checkout, please see Required Delivery Information.

Consents to special offers - Denoted with a '1' or '0'. '1' if the user checked the box "I would like to receive special offers" when signing up for an account. '0' if the user did not create an account. If you send "thank you + promo code" emails after guest visits, we recommend our customers only send emails to guests with '1' in this column.

Fulfillment method - How the 'order number' on the 'order date' is completed/delivered.  

Please see fulfillment method for more detailed information on fulfillment methods.

Delivery address - The address entered by the guest for the 'order number' on the 'order date' to be used for delivery.

Num items - Total number of items applied to the 'order number' on the 'order date'.

Num refunded - Total number of items refunded for the 'order number' on the 'order date'.

Promotions - Name of the promotion code applied to the 'order number' on the 'order date' if applicable.

Service fee pretax - Total dollar amount of any 'Service Charges' before tax, applicable for the ‘order number’ on the ‘order date’.

Promos Total - The total dollar amount taken off the total bill resulting from the promotion code applied to the 'order number' on the 'order date'.

Promos Used - Name of the promotion code, guest-facing promo name, and the discounted amount applied to the 'order number' on the 'order date' if applicable.

Checkout Info - Information collected at checkout including guest information, pickup/delivery times, and delivery location data for the 'order number' on the 'order date'.

For more information on capturing guest information at checkout, please see Required Delivery Information.

Items pretax - Total dollar amount of all items sold before tax for the ‘order number’ on the ‘order date’.

Tax - Total dollar amount of tax applied to the 'order number' on the 'order date'.

Tip - Total dollar amount of tip applied to the 'order number' on the 'order date'.

Total - Total dollar amount after tax of the 'order number' on the 'order date'.

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

Bank transfer after fees - Total dollar amount for the ‘order number’ on the 'order date’ that will be transferred to the venue's bank account through Stripe.

Description - Lists the menu items ordered for the 'order number' on the 'order date'

Still need help? Contact Us Contact Us