The report generator offers over 50 system fields (depending on the reporting level) to choose from. This allows you to dynamically create reports that are relevant to you and your business. Below is a short description of each field offered. Field options for add-ons, taxes, fees, or questions are not listed in this document as they are dynamic to your business. However, those will be prepended with a type.
Abandoned Cart Email Sent - True/False. Tells you if this transaction came from an abandoned cart email.
Affiliate Name - If you use affiliates and they make a booking you will see the name of the affiliate that made the booking
Booked By - For manual adds and other transactions within account, this will list the user name of the user who placed the booking on behalf of a customer.
Business Name - The name of your business.
Buyer Email - The email address of the buyer.
Buyer Name - The full name of the buyer.
Buyer Phone - The phone number of the buyer.
Cart Source - Where the cart originated from.
Notes - When editing the system and user can add notes. These notes will be added here.
Outstanding Balance - Any outstanding balance on the purchase.
Participant Count - How many participants are in the purchase.
Payment Processor - How the payment was processed.
Prior Refund Amount - The previous, if any, refund amount from an edit.
Promotion Code - Any promotion code that was applied.
Promotion Discount - The amount of the discount applied, if any.
Purchase Date - The full date of the purchase.
Purchase Month - Just the month of the purchase.
Purchase Year - Just the year of the purchase.
Purchase Date and Time - The full date and time of the purchase.
Refund Cancellation Fee Amount - The amount of the fee charged due to a cancellation, if any.
Refund Date - The date of a refund on the purchase.
Service Fees - The total of the service fees for the purchase,
Sub Total - The total cost of goods less taxes and fees.
Taxes - The total of the taxes for the purchase.
Total - The overall total amount for the purchase, including taxes and fees.
Tracking Source Code - This is a free-form string taken from the src URL parameter on a booking/embedding link. This allows you to tag a purchase with this string.
Transaction Identifier - The unique identifier for a purchase.
Voucher Discount - If applied this will show the discount of an applied voucher.
Outstanding Balance - Any outstanding balance that exists for this activity,
Participant Count - The total participant count for a given activity.
Prior Refund Amount - The existing refunded amount for an activity, if any.
Promotion Discount - If a promotion is applied this lists the total discount amount for the activity.
Refund Cancellation Fee Amount - If there is a fee charged due to a refund this lists the total fee for the activity refunded.
Service Fees - Total service fees for the activity,
Start Date - The full start date for a scheduled activity.
Start Date and Time - The full start date and start time for a scheduled activity.
Sub Total - The total of the activity and all add ons but not inclusive of taxes or fees.
Taxes - The total amount of taxes charged for this activity.
Title - The name of the activity.
Total - The total for this activity, inclusive of taxes and fees.
Voucher Discount - If a voucher is applied to this activity this is the discount the voucher afforded.
Outstanding Balance - Any remaining balance due for the participant.
Price - The price selected for the participant. This is the numeric value (i.e. 100).
Price Description - The name of the price selected for the participant. This is the title (i.e. "Adult").
Prior Refund Amount - Any existing refund amount on this participant.
Promotion Discount - IF a promotion is applied this lists the discount given to the participant.
Refund Cancellation Fee Amount - If the participant is charged a cancellation fee for refund this lists the amount of the cancellation fee for the participant.
Service Fees - Total service fees collected for this participant.
Sub Total - Total price and add ons for the participant, not inclusive of taxes or fees.
Taxes - The total tax charged for this participant.
Total - Overall total for the participant, inclusive of taxes and fees.
Voucher Discount - If a voucher is applied to this participant this is the discount the voucher afforded.