Transfers Breakdown Report

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

Each night, Bbot's accounting system processes credit card charges and combines them into transfers based on the day when the card charges will clear. The Transfers Breakdown report shows data for individual transactions within a transfer batch. You can only run this report for a single accounting date. 

Refine Report 

This report can be refined by a date range by using the dropdown calendars or by typing the dates in. Note: This report can only be be run for single day time ranges.

For each individual transaction within a Stripe transfer, the Transfers Breakdown report shows the following:

Accounting Date -  The day on which a calculation concerning the 'order number' on the 'order date' was applied.  

Order Date - Calendar date the guest placed their 'order number'. 

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

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

Fulfillment Method - How the order was fulfilled (ex: delivery, pickup, or server delivery).  

Please see Fulfillment Method for more detailed information on fulfillment methods.

Reporting Category Sales - Total dollar amount of items sold before tax for the respective reporting category for the 'order number' on the 'order date'.

For more information on reporting categories please see Editing a Single Menu Item.

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

Service Charges - Total dollar amount of any Service Charges applicable for the ‘order number’ on the ‘order date’.

Tax - Total dollar amount of sales tax for the ‘order number’ on the ‘order date’.

Gross incl tax - Total dollar amount of sales + tax + service charges for the ‘order number’ on the ‘order date’.

Total tips - Total dollar amount of tips received for 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. 

Partner agreements - Total dollar amount of fees applicable to the ‘order number’ on the ‘order date’ from Bbot partners associated with the venue.

Card income after fees - Total dollar amount of income received after fees for the ‘order number’ on the ‘order date’. 

In the example below for order number 533 on Sept 25th, 2020 - Gross incl tax is 130.99 + Total tips 24.20 - Bbot and processing fees 4.63 - partner agreements 0.00 = Card income after fees 150.56.

Card disputes - Total dollar amount of disputed charges by a guest for the ‘order number’ on the 'order date' but applied on the ‘accounting date’ of the dispute.  This amount will be deducted from the transfer batch with the associated ‘Transfer ID’.  

For additional information on disputes, please see How Does Bbot Handle Chargebacks.

Withholdings (delivery bills etc) - The total dollar amount withheld for delivery fees or any other applicable fee associated with the ‘order number’ on the ‘order date’.

In the example below, order number 533 was delivered by Doordash and the fee withheld for the Doordash delivery was 7.25.  Total tips of 24.20 + 7.25 for the Doordash Delivery fee = 31.45 which is shown as -31.45 in the 'Withholdings (delivery bills etc) column as this amount will be deducted from 'Card income after fees'.

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. 

Final transfer - Total dollar amount for the ‘order number’ on the 'order date’ that will be transferred within the batch with the associated ‘Transfer ID’.  

'Card income after fees' minus 'Card disputes' minus 'Withholdings delivery bills etc' equals 'Final bank transfer

Transfer date - Date the ‘order number’ on the ‘order date’ is transferred from Bbot to Stripe within the batch with the associated ‘Transfer ID’

Transfer ID - The number associated with a transfer batch.  Each ‘order number’ on their respective ‘order date’ with the same ‘Transfer ID’ are all transferred together. 

Please see Reconciling Stripe Transfers for more information on reconciling each transaction to a Stripe Transfer.